afsilver

I gave up, and deleted the whole db and rebuilt it. Added users manually and scanned files in nextcloud folder to add the userfiles. Had a new btrfs fail on the cache drive and lost the db again, this time i had a local and external backup!

i had a severe crash on my unraid server 3 days ago, docker service kept locking up, and i had to delete docker image and start over. now everything is back except mariadb. log from docker: [cont-init.d] 10-adduser: exited 0. [cont-init.d] 30-config: executing... [cont-init.d] 30-config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] 90-custom-folders: executing... [cont-init.d] 90-custom-folders: exited 0. [cont-init.d] 99-custom-files: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-files: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. 220519 18:55:56 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:55:56 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:55:58 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:55:58 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:00 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:00 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:02 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:02 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:05 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:05 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:07 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases Caught SIGTERM signal! cat: /var/run/mysqld/mysqld.pid: No such file or directory [cont-finish.d] executing container finish scripts... [cont-finish.d] done. [s6-finish] waiting for services. [s6-finish] sending all processes the TERM signal. [s6-finish] sending all processes the KILL signal and exiting. text from e8ae576d472a.err: 220519 18:43:20 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2022-05-19 18:43:20 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB-log) starting as process 518 ... 2022-05-19 18:43:21 0 [Note] InnoDB: Uses event mutexes 2022-05-19 18:43:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-05-19 18:43:21 0 [Note] InnoDB: Number of pools: 1 2022-05-19 18:43:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-05-19 18:43:21 0 [Note] InnoDB: Using Linux native AIO 2022-05-19 18:43:21 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2022-05-19 18:43:21 0 [Note] InnoDB: Completed initialization of buffer pool 2022-05-19 18:43:22 0 [Note] InnoDB: Transaction 50443189 was in the XA prepared state. 2022-05-19 18:43:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2022-05-19 18:43:22 0 [Note] InnoDB: Trx id counter is 50443190 2022-05-19 18:43:22 0 [Note] InnoDB: 128 rollback segments are active. 2022-05-19 18:43:22 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2022-05-19 18:43:22 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2022-05-19 18:43:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-05-19 18:43:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-05-19 18:43:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-05-19 18:43:22 0 [Note] InnoDB: 10.5.15 started; log sequence number 11641422179; transaction id 50443191 2022-05-19 18:43:22 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2022-05-19 18:43:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-05-19 18:43:22 0 [Note] InnoDB: Starting recovery for XA transactions... 2022-05-19 18:43:22 0 [Note] InnoDB: Transaction 50443189 in prepared state after recovery 2022-05-19 18:43:22 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-05-19 18:43:22 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2022-05-19 18:43:22 0 [Note] Found 1 prepared transaction(s) in InnoDB 2022-05-19 18:43:22 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was ma> 2022-05-19 18:43:22 0 [ERROR] Aborting 220519 18:43:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended tried "mysqld --user=root --tc-heuristic-recover" with rollback and commit. in the docker console. root@e8ae576d472a:/# mysqld --user=root --tc-heuristic-recover rollback 2022-05-19 19:01:16 0 [Note] mysqld (mysqld 10.5.15-MariaDB-log) starting as process 1375 ... 2022-05-19 19:01:16 0 [Note] InnoDB: Uses event mutexes 2022-05-19 19:01:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-05-19 19:01:16 0 [Note] InnoDB: Number of pools: 1 2022-05-19 19:01:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-05-19 19:01:16 0 [Note] InnoDB: Using Linux native AIO 2022-05-19 19:01:16 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2022-05-19 19:01:16 0 [Note] InnoDB: Completed initialization of buffer pool 2022-05-19 19:01:17 0 [Note] InnoDB: 128 rollback segments are active. 2022-05-19 19:01:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-05-19 19:01:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-05-19 19:01:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-05-19 19:01:17 0 [Note] InnoDB: 10.5.15 started; log sequence number 35064; transaction id 8 2022-05-19 19:01:17 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-05-19 19:01:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-05-19 19:01:17 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-05-19 19:01:17 0 [Note] Heuristic crash recovery mode 2022-05-19 19:01:17 0 [Note] Please restart mysqld without --tc-heuristic-recover 2022-05-19 19:01:17 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") 2022-05-19 19:01:17 0 [Note] InnoDB: Buffer pool(s) load completed at 220519 19:01:17 2022-05-19 19:01:17 0 [ERROR] Can't init tc log 2022-05-19 19:01:17 0 [ERROR] Aborting But i do not know how to proceed from here. any help is grately appriciated!

Cant really remember, i believe it got a full reset. So i started over, since it did not contain any files, just a few users. But i also believe this is the wrong thread for nextcloud issues.

i never bothered to check as i assumed subfolder was for "example.com/example" only. thank you very much 😃

I have letsencrypt working flawlessly with several subdomains. However, i want my top domain to reverse proxy into the Heimdall container. If i access my domain now, i get the following: Welcome to our server The website is currently being setup under this address. For help and support, please contact: [email protected]. How can i redirect https://example.com to Heimdall?

i did edit my first post, axplaining that i "fixed" mariadb by deleting the mariadb folder in appdata. you must have missed it 😃 it now works. but onto nextcloud which is also f'd. thanks for the help anyways

i had the appdata share set to cache only. but some files where not moved. so i set cache to prefer and started the mover. then i set the cache back to only. now i cannot find any appdata folders on any disks. but i later read in another thread that i should manually move from mnt/disk'X' -> mnt/cache, not from mnt/user -> mnt/cache. but to answer your question. my mapping for mariadb was /mnt/user/appdata/mariadb, but now it is /mnt/cache/appdata/mariadb.

Hi, yesterday i added a cache drive to my unraid server, which i belive somehow messed up the appdata share for the docker containers. all the containers need to be set up again. currently i am stuck at fixing mariadb, as the "mysqld.sock" is missing and the sql server wont start. it is supposed to be located in "/var/run/mysqld/" trying to login to the sql server gives me this error: "# mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" i have removed and readded the mariadb docker from the community applications plugin. but still the file is missing. edit: turns out i am missing alot of files in appdata folder after my screwup. deleting mariadb folder from appdata and setting up mariadb from scratch solved my issue.