avlec

@glennv, Will give it a try pointing it at my other cache pool (which the appdata now uses). If you don't hear from me assume that has worked out!

Hey I am having some issues with the Postgresql container. I am only using it for nextcloud as well as for a Davinci Resolve database (haven't used it well before this started happening). I had previously moved the database folder off the cache when I split apart my cache drives. It regenerated a new database because the data folder was pointed to /mnt/cache/appdata/postgres. But I realized that error quickly deleted the new empty database on /mnt/cache/appdata/postgres and pointed the container at the original database which was now on /mnt/user/appdata/postgres and everything worked fine until these errors below started happening. I fixed it once before by using "touch" to create a new empty file with the name of the one that's missing but this does not seem to be a permanent solution. Here are the container logs. ###### Original problem after restarting database to see if that would fix it. ###### PostgreSQL Database directory appears to contain a database; Skipping initialization 2021-07-01 19:32:01.480 PDT [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2021-07-01 19:32:01.480 PDT [1] LOG: listening on IPv6 address "::", port 5432 2021-07-01 19:32:01.622 PDT [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2021-07-01 19:32:01.650 PDT [25] LOG: database system was shut down at 2021-06-29 16:53:24 PDT 2021-07-01 19:32:01.760 PDT [25] LOG: could not link file "pg_wal/xlogtemp.25" to "pg_wal/000000010000000000000012": Function not implemented 2021-07-01 19:32:01.762 PDT [25] FATAL: could not open file "pg_wal/000000010000000000000012": No such file or directory 2021-07-01 19:32:01.763 PDT [1] LOG: startup process (PID 25) exited with exit code 1 2021-07-01 19:32:01.763 PDT [1] LOG: aborting startup due to startup process failure 2021-07-01 19:32:01.764 PDT [1] LOG: database system is shut down ###### After running `touch pg_wal/000000010000000000000012` ###### ###### Seems to work fine but eventually runs into the same issue. ###### ###### This time with more detail because it's before restarting container. ###### PostgreSQL Database directory appears to contain a database; Skipping initialization 2021-07-01 19:37:17.510 PDT [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2021-07-01 19:37:17.510 PDT [1] LOG: listening on IPv6 address "::", port 5432 2021-07-01 19:37:17.746 PDT [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2021-07-01 19:37:17.776 PDT [26] LOG: database system was shut down at 2021-06-29 16:53:24 PDT 2021-07-01 19:37:17.785 PDT [1] LOG: database system is ready to accept connections 2021-07-01 19:47:18.362 PDT [27] LOG: could not link file "pg_wal/000000010000000000000011" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 02:47:23.654 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 02:47:23.656 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 02:52:26.833 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 02:52:26.835 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 02:57:28.930 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 02:57:28.932 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:02:31.826 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:02:31.828 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:07:34.968 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:07:34.970 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:12:37.012 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:12:37.014 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:17:39.823 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:17:39.825 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:22:43.381 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:22:43.383 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:27:45.554 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:27:45.556 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:32:48.448 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:32:48.450 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:37:51.810 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:37:51.812 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:42:53.856 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:42:53.858 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:47:56.817 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:47:56.819 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:52:59.952 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:52:59.954 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 03:58:01.729 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 03:58:01.731 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:03:04.614 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:03:04.616 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:08:07.763 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:08:07.766 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:13:09.816 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:13:09.818 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:18:12.641 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:18:12.643 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:23:15.834 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:23:15.836 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:28:17.997 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:28:18.000 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:33:20.891 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:33:20.894 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:38:24.033 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:38:24.035 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:43:26.020 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:43:26.021 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:48:29.015 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:48:29.017 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:53:32.198 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:53:32.200 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 04:58:34.361 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 04:58:34.363 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:03:37.250 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:03:37.252 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:08:40.422 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:08:40.424 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:13:42.389 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:13:42.391 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:18:45.306 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:18:45.308 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:23:48.492 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:23:48.494 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:28:50.349 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:28:50.351 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:33:53.247 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:33:53.249 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:38:56.814 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:38:56.816 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:43:58.586 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:43:58.588 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:49:01.582 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:49:01.584 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:54:04.875 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:54:04.876 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 05:59:07.040 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 05:59:07.042 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:04:09.876 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:04:09.878 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:09:13.045 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:09:13.047 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:14:15.028 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:14:15.030 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:19:18.036 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:19:18.038 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:24:21.252 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:24:21.255 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:29:23.317 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:29:23.320 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:34:26.151 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:34:26.154 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:39:29.362 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:39:29.364 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:44:31.450 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:44:31.451 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:49:34.343 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:49:34.346 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:54:37.518 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:54:37.519 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 06:59:39.492 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 06:59:39.495 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:04:42.431 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:04:42.433 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:09:45.606 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:09:45.608 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:14:47.719 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:14:47.721 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:19:51.452 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:19:51.454 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:24:53.793 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:24:53.795 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:29:55.893 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:29:55.895 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:34:58.950 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:34:58.952 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:40:01.975 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:40:01.977 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:45:04.779 PDT [27] LOG: could not link file "pg_wal/xlogtemp.27" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:45:04.781 PDT [27] ERROR: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:45:50.366 PDT [1046] LOG: could not link file "pg_wal/xlogtemp.1046" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:45:50.368 PDT [1046] PANIC: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:45:50.369 PDT [1] LOG: server process (PID 1046) was terminated by signal 6: Aborted 2021-07-02 07:45:50.369 PDT [1] DETAIL: Failed process was running: autovacuum: ANALYZE public.oc_jobs 2021-07-02 07:45:50.369 PDT [1] LOG: terminating any other active server processes 2021-07-02 07:45:50.369 PDT [30] WARNING: terminating connection because of crash of another server process 2021-07-02 07:45:50.369 PDT [30] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2021-07-02 07:45:50.369 PDT [30] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2021-07-02 07:45:50.373 PDT [1] LOG: all server processes terminated; reinitializing 2021-07-02 07:45:50.388 PDT [1047] LOG: database system was interrupted; last known up at 2021-07-02 07:45:04 PDT 2021-07-02 07:45:50.786 PDT [1047] LOG: database system was not properly shut down; automatic recovery in progress 2021-07-02 07:45:50.825 PDT [1047] LOG: redo starts at 0/12FFDAB0 2021-07-02 07:45:50.826 PDT [1047] LOG: redo done at 0/12FFDBC8 2021-07-02 07:45:50.989 PDT [1047] LOG: could not link file "pg_wal/xlogtemp.1047" to "pg_wal/000000010000000000000013": Function not implemented 2021-07-02 07:45:50.992 PDT [1047] FATAL: could not open file "pg_wal/000000010000000000000013": No such file or directory 2021-07-02 07:45:50.993 PDT [1] LOG: startup process (PID 1047) exited with exit code 1 2021-07-02 07:45:50.993 PDT [1] LOG: aborting startup due to startup process failure 2021-07-02 07:45:50.996 PDT [1] LOG: database system is shut down

Just a weird quirk I noticed when to configuring the nextcloud container to use my postgresql database was that if you fail to enter a port number with the IP address the container locks up and you have to remove the container and manually delete the folder containing the docker files. rm -rf /mnt/user/appdata/nextcloud

I have added the suggested change to my VM config. It should not be related to my problem as verified after the change the space has free'd a GB or two. I have very little on my cache drive other than 2 vdisks that are capped at 32 and 128 GB. They use 34.4 and 137 GB on the cache respectively (171.4 combined). But other than the vdisks I would guarantee other usage should measure around 5 GB, definitely less than 10GB, from what I can see on the webgui's cache file browser.

I have a problem or perhaps I'm missing something here? Unraid reports the used cache space as 245GB, while the output of `du -H` run through ssh reports 158GB of used space. I am also unable to manually find browsing via ssh or webgui anything that could be occupying that much space. Any insight would be appreciated. Screenshot of drive setup. I have also attached the diagnostic zip in case it is needed. trantor-diagnostics-20210311-1216.zip

I'm trying to get GPU passthrough working on Windows 10The VNC connection was used to setup the virtual machine, which worked fine (installed the virtio display driver). When switching the VM to display through the video card, after the setup through VNC, the UNRAID login command line interface disappears and the screen turns black. Nothing happens after that. What's interesting is that when I use the GPU passthrough with a Ubuntu 18.10 server VM, the command line appears for that VM on the screen. Heard trying to switch from QEMU to SeaBIOS could work. However, the option to switch the BIOS is greyed out. Solved: Turns out that the VirtIO driver hates the GPU, so rolling back the driver to the windows basic display driver through the VNC connection fixed the problem.