How to fix "MIOpen(HIP): Warning [SQLiteBase] Missing system database file"

[denliner]

If you use Arch Linux with Arch4edu you need to: (I haven't tested it on any other distro than Arch or/and without Arch4edu)
-install the miopen-hip package
-go to /opt/rocm/lib/
-copy libMIOpen.so.1.0
-paste it to stable-diffusion-webui/venv/lib/python3.10/site-packages/torch/lib/ (or your global python site-package if you don't use a venv)
-rename or delete the already present libMIOpen.so
-And rename libMIOpen.so.1.0 to libMIOpen.so
-Relaunch webui
-generate an image
-Relaunch webui

This should make this error message disappear and make first generation way faster.

Thank you to arenatemp for this advice ROCm/MIOpen#1930 (comment)

[cyatarow]

This warning is gone thanks to your workaround.
However, when I use upscalers, the following errors occur and the webui stops working.
(except Latent series, Lanczos and Nearest)

MIOpen(HIP): Error [Compile] 'hiprtcCompileProgram(prog.get(), c_options.size(), c_options.data())' naive_conv.cpp: HIPRTC_ERROR_COMPILATION (6)
MIOpen(HIP): Error [BuildHip] HIPRTC status = HIPRTC_ERROR_COMPILATION (6), source file: naive_conv.cpp
MIOpen(HIP): Warning [BuildHip] /tmp/comgr-48d434/input/CompileSource:39:10: fatal error: 'limits' file not found
#include <limits> // std::numeric_limits
         ^~~~~~~~
1 error generated when compiling for gfx1030.
terminate called after throwing an instance of 'miopen::Exception'
  what():  /long_pathname_so_that_rpms_can_package_the_debug_info/data/driver/MLOpen/src/hipoc/hipoc_program.cpp:304: Code object build failed. Source: naive_conv.cpp

My environment:

• Ubuntu 22.04.1
• Radeon RX 5500 XT
• The file name is /opt/rocm/lib/libMIOpen.so.1.0.50401

[Rizzlord]

it works, but i cannot see my progressbar anymore in the console, there are thousands of MI open INFOS

[ApoorvRChincholkar]

This issue went away once I upgraded my Torch.
Additionally it used to take around a minute to pre-compile on the very first generation. That problem too went away. Now it does start instantly.
Using Automatic1111 on 6600XT with Ubuntu 22.04, torch: 2.0.1+rocm5.4.2

[Rizzlord]

What is the command for torch 2.0.1+rocm5.4.2?