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!