j0nnymoe Posted October 4, 2021 Share Posted October 4, 2021 On 10/2/2021 at 1:53 PM, trevaaaaaaa said: I was going to try this but I don't have a mariadb directory in /var/run/s6/services/ of my nextcloud container. Because it's not in the nextcloud container, it's in the mariadb container. Quote Link to comment
eds Posted October 4, 2021 Share Posted October 4, 2021 On 10/1/2021 at 3:55 PM, j0nnymoe said: Just to make it clear, if anyone is having issues with the update to the latest version of mariadb. It's due to your database corrupting as your previous container wasn't shutdown cleanly (Something using during an update / automatic updates killing the container early). To recover your database, do the following with -all- containers that use mariadb off: Try the `linuxserver/mariadb:version-110.4.21mariabionic` tag, let everything start up, check the logs to make sure it's all clean, then do `docker exec nextclouddb s6-svc -d /var/run/s6/services/mariadb/` (assuming your container is called nexclouddb, otherwise adjust that appropriately). Wait ~30 seconds and then stop the container and update to latest. If this doesn't work, you will need to restore a working backup. Thanks for this information. I did the docker downgrade and then I had to do a restore of the db (thank god I had a backup). Everything worked. Then updated the repository to latest. Everything seems stable. Quote Link to comment
jademonkee Posted October 5, 2021 Share Posted October 5, 2021 12 hours ago, eds said: Thanks for this information. I did the docker downgrade and then I had to do a restore of the db (thank god I had a backup). Everything worked. Then updated the repository to latest. Everything seems stable. Out of curiosity, do you have in your logs: 211004 10:30:59 mysqld_safe Logging to '/config/databases/90d1ec1b4a9c.err'. 211004 10:30:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases I have it in mine, but everything works fine (or at least seems to). Just wondering if I do the above 'downgrade, command, upgrade fix' if it will fix that problem, too. Cheers. Quote Link to comment
eds Posted October 5, 2021 Share Posted October 5, 2021 (edited) 12 hours ago, jademonkee said: Out of curiosity, do you have in your logs: 211004 10:30:59 mysqld_safe Logging to '/config/databases/90d1ec1b4a9c.err'. 211004 10:30:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases I have it in mine, but everything works fine (or at least seems to). Just wondering if I do the above 'downgrade, command, upgrade fix' if it will fix that problem, too. Cheers. I have that in mine, but I think it's normal. Now it appears only once at the end of the docker log. Edited October 5, 2021 by eds added end of log for clarification 1 Quote Link to comment
trevaaaaaaa Posted October 5, 2021 Share Posted October 5, 2021 On 10/4/2021 at 7:59 PM, j0nnymoe said: Because it's not in the nextcloud container, it's in the mariadb container. Ah, ooops, I read your docker exec command wrong. Thanks for your help. Quote Link to comment
pengrus Posted October 6, 2021 Share Posted October 6, 2021 Hi, At some point coincident with the latest update to the MariaDB container, I've had an issue where the container will not allow multiple clients to connect to the Kodi databases. I've attached the log, but basically if one client is accessing the database, it will refuse to let another connect until I restart the container. I've made no configuration changes other than attempting the downgrade/upgrade to latest procedure on page 17. Any ideas? Thanks! -P marialog.txt Quote Link to comment
ds123 Posted October 14, 2021 Share Posted October 14, 2021 On 10/6/2021 at 11:57 AM, pengrus said: Hi, At some point coincident with the latest update to the MariaDB container, I've had an issue where the container will not allow multiple clients to connect to the Kodi databases. I've attached the log, but basically if one client is accessing the database, it will refuse to let another connect until I restart the container. I've made no configuration changes other than attempting the downgrade/upgrade to latest procedure on page 17. Any ideas? Thanks! -P marialog.txt 660.88 kB · 1 download I have the same issue. Quote Link to comment
plantsandbinary Posted October 18, 2021 Share Posted October 18, 2021 Why does MariaDB keep rebooting on its own? It's kicking my Ghost blog offline all the time... Quote Link to comment
allanp81 Posted October 19, 2021 Share Posted October 19, 2021 On 10/14/2021 at 5:05 PM, ds123 said: I have the same issue. I thought I'd fixed this issue but no, still occurring so add me to the list of people with this issue and Kodi. Quote Link to comment
Hazgrid Posted October 20, 2021 Share Posted October 20, 2021 Hi everyone, I've just setup my first ever Unraid server, so I'm kind of new to this all. I'm trying to setup a NextCloud Server and and I'm having an issue with installing Mariadb. I've installed the docker, but when I try and log into root in the concole I get this error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I've read that it means the root password is wrong, but tried different types of passwords (short/long/no special characters/etc) and copying and pasting it directly, and completely re-installing the docker, but still no luck. Any ideas? Thank, Harry Quote Link to comment
allanp81 Posted October 20, 2021 Share Posted October 20, 2021 Reinstalling the docker wouldn't necessarily change anything as the appdata directory would still exist. What did you set the password as in the docker config as that's what it should be set as. Quote Link to comment
Hazgrid Posted October 21, 2021 Share Posted October 21, 2021 10 hours ago, allanp81 said: Reinstalling the docker wouldn't necessarily change anything as the appdata directory would still exist. What did you set the password as in the docker config as that's what it should be set as. So should I go into the appdata folder and delete it? it’s currently at ‘password’ but I tried that and it didn’t work, same error Quote Link to comment
allanp81 Posted October 21, 2021 Share Posted October 21, 2021 Wiping the appdata would cause it to start afresh I think. Quote Link to comment
juaaslo Posted October 22, 2021 Share Posted October 22, 2021 Hello, I have the same issue all of the sudden. The recurrent errors when starting like: 211022 20:47:53 mysqld_safe Logging to syslog. 211022 20:47:53 mysqld_safe Starting mysqld daemon with databases from /config/databases But I suspect my data wouldn't be corrupted but I messed by accident with all permissions and ownership of all mariadb disk volumen. Do you think this problem could be related to permissions and ownership, and if so, provide how files and directories should look like?? If no relation between those ideas is seen, I think I'll have to destroy the database and recreate my nextcloud instance. Thanks in advance and BR. pi@raspberrypi:/media/pi/RaspberryPI/mariadb $ ls -larth total 24K drwxrwxr-- 3 pi pi 4,0K mar 10 2021 log-old -rwxrwxr-- 1 pi pi 3,7K mar 10 2021 custom.cnf drwxr-xr-x 6 www-data www-data 4,0K abr 5 2021 .. drwxrwxr-- 3 pi pi 4,0K oct 22 18:47 log drwxrwxrwx 5 pi pi 4,0K oct 22 20:44 . drwxrwxr-- 5 pi pi 4,0K oct 22 20:53 databases pi@raspberrypi:/media/pi/RaspberryPI/mariadb $ cd log pi@raspberrypi:/media/pi/RaspberryPI/mariadb/log $ ls -larth total 12K drwxrwxr-- 3 pi pi 4,0K oct 22 18:47 . drwxrwxrwx 5 pi pi 4,0K oct 22 20:44 .. drwxrwxr-- 2 pi pi 4,0K oct 22 20:54 mysql pi@raspberrypi:/media/pi/RaspberryPI/mariadb/log $ cd mysql/ pi@raspberrypi:/media/pi/RaspberryPI/mariadb/log/mysql $ ls -larth total 8,0K drwxrwxr-- 3 pi pi 4,0K oct 22 18:47 .. -rwxrwxr-- 1 pi pi 0 oct 22 18:47 mariadb-bin.index drwxrwxr-- 2 pi pi 4,0K oct 22 20:54 . pi@raspberrypi:/media/pi/RaspberryPI/mariadb/log/mysql $ pi@raspberrypi:/media/pi/RaspberryPI/mariadb/log/mysql $ cd ../../databases/ pi@raspberrypi:/media/pi/RaspberryPI/mariadb/databases $ ls -larth total 185M drwxr--r-- 2 pi pi 4,0K mar 10 2021 mysql drwxr--r-- 2 pi pi 4,0K mar 10 2021 performance_schema -rwxrwxr-- 1 pi pi 0 mar 10 2021 multi-master.info drwxr--r-- 2 pi pi 12K jul 16 00:37 nextcloud_db -rwxrwxr-- 1 pi pi 48M oct 6 00:50 ib_logfile1 -rwxrwxr-- 1 pi pi 48M oct 17 14:05 ib_logfile0 -rwxrwxr-- 1 pi pi 76M oct 17 14:05 ibdata1 drwxrwxrwx 5 pi pi 4,0K oct 22 20:44 .. drwxrwxr-- 5 pi pi 4,0K oct 22 20:55 . -rwxrwxr-- 1 pi pi 52 oct 22 20:55 aria_log_control -rwxrwxr-- 1 pi pi 13M oct 22 20:55 aria_log.00000001 pi@raspberrypi:/media/pi/RaspberryPI/mariadb/databases $ cd nextcloud_db/ pi@raspberrypi:/media/pi/RaspberryPI/mariadb/databases/nextcloud_db $ ls -larth total 210M -rwxr--r-- 1 pi pi 67 mar 10 2021 db.opt -rwxr--r-- 1 pi pi 2,5K mar 10 2021 oc_migrations.frm -rwxr--r-- 1 pi pi 2,3K mar 10 2021 oc_appconfig.frm -rwxr--r-- 1 pi pi 1,7K mar 10 2021 oc_storages.frm -rwxr--r-- 1 pi pi 16K mar 10 2021 oc_mounts.frm -rwxr--r-- 1 pi pi 2,2K mar 10 2021 oc_mimetypes.frm -rwxr--r-- 1 pi pi 19K mar 10 2021 oc_filecache.frm -rwxr--r-- 1 pi pi 1,8K mar 10 2021 oc_group_user.frm -rwxr--r-- 1 pi pi 1,8K mar 10 2021 oc_group_admin.frm -rwxr--r-- 1 pi pi 1,9K mar 10 2021 oc_groups.frm -rwxr--r-- 1 pi pi 1,5K mar 10 2021 oc_preferences.frm -rwxr--r-- 1 pi pi 3,7K mar 10 2021 oc_properties.frm -rwxr--r-- 1 pi pi 11K mar 10 2021 oc_share.frm -rwxr--r-- 1 pi pi 2,8K mar 10 2021 oc_users.frm -rwxr--r-- 1 pi pi 15K mar 10 2021 oc_jobs.frm -rwxr--r-- 1 pi pi 4,4K mar 10 2021 oc_authtoken.frm -rwxr--r-- 1 pi pi 4,5K mar 10 2021 oc_bruteforce_attempts.frm -rwxr--r-- 1 pi pi 3,6K mar 10 2021 oc_vcategory.frm -rwxr--r-- 1 pi pi 1,7K mar 10 2021 oc_vcategory_to_object.frm -rwxr--r-- 1 pi pi 1,7K mar 10 2021 oc_systemtag.frm -rwxr--r-- 1 pi pi 1,4K mar 10 2021 oc_systemtag_object_mapping.frm -rwxr--r-- 1 pi pi 1,7K mar 10 2021 oc_systemtag_group.frm -rwxr--r-- 1 pi pi 2,2K mar 10 2021 oc_file_locks.frm -rwxr--r-- 1 pi pi 4,4K mar 10 2021 oc_comments.frm -rwxr--r-- 1 pi pi 2,1K mar 10 2021 oc_comments_read_markers.frm -rwxr--r-- 1 pi pi 1,8K mar 10 2021 oc_twofactor_providers.frm -rwxr--r-- 1 pi pi 1,2K mar 10 2021 oc_accounts.frm -rwxr--r-- 1 pi pi 2,4K mar 10 2021 oc_whats_new.frm -rwxr--r-- 1 pi pi 1,2K mar 10 2021 oc_collres_collections.frm -rwxr--r-- 1 pi pi 1,4K mar 10 2021 oc_collres_resources.frm -rwxr--r-- 1 pi pi 2,6K mar 10 2021 oc_collres_accesscache.frm -rwxr--r-- 1 pi pi 9,4K mar 10 2021 oc_login_flow_v2.frm -rwxr--r-- 1 pi pi 2,1K mar 10 2021 oc_filecache_extended.frm -rwxr--r-- 1 pi pi 14K mar 10 2021 oc_direct_edit.frm -rwxr--r-- 1 pi pi 3,1K mar 10 2021 oc_webauthn.frm -rwxr--r-- 1 pi pi 2,4K mar 10 2021 oc_storages_credentials.frm -rwxr--r-- 1 pi pi 3,6K mar 10 2021 oc_accounts_data.frm -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_group_admin.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_properties.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_vcategory_to_object.ibd -rwxr--r-- 1 pi pi 144K mar 10 2021 oc_vcategory.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_systemtag.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_systemtag_object_mapping.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_systemtag_group.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_comments_read_markers.ibd -rwxr--r-- 1 pi pi 160K mar 10 2021 oc_comments.ibd -rwxr--r-- 1 pi pi 2,2K mar 10 2021 oc_user_transfer_owner.frm -rwxr--r-- 1 pi pi 28K mar 10 2021 oc_notifications.frm -rwxr--r-- 1 pi pi 4,8K mar 10 2021 oc_notifications_pushtokens.frm -rwxr--r-- 1 pi pi 2,4K mar 10 2021 oc_flow_checks.frm -rwxr--r-- 1 pi pi 3,4K mar 10 2021 oc_flow_operations.frm -rwxr--r-- 1 pi pi 1,7K mar 10 2021 oc_flow_operations_scope.frm -rwxr--r-- 1 pi pi 18K mar 10 2021 oc_share_external.frm -rwxr--r-- 1 pi pi 5,9K mar 10 2021 oc_recent_contact.frm -rwxr--r-- 1 pi pi 1,2K mar 10 2021 oc_privacy_admins.frm -rwxr--r-- 1 pi pi 5,8K mar 10 2021 oc_files_trash.frm -rwxr--r-- 1 pi pi 1,7K mar 10 2021 oc_federated_reshares.frm -rwxr--r-- 1 pi pi 1,5K mar 10 2021 oc_text_documents.frm -rwxr--r-- 1 pi pi 2,7K mar 10 2021 oc_text_sessions.frm -rwxr--r-- 1 pi pi 2,0K mar 10 2021 oc_text_steps.frm -rwxr--r-- 1 pi pi 31K mar 10 2021 oc_activity.frm -rwxr--r-- 1 pi pi 5,2K mar 10 2021 oc_activity_mq.frm -rwxr--r-- 1 pi pi 4,6K mar 10 2021 oc_addressbooks.frm -rwxr--r-- 1 pi pi 3,7K mar 10 2021 oc_cards.frm -rwxr--r-- 1 pi pi 2,3K mar 10 2021 oc_addressbookchanges.frm -rwxr--r-- 1 pi pi 3,4K mar 10 2021 oc_calendarobjects.frm -rwxr--r-- 1 pi pi 5,7K mar 10 2021 oc_calendars.frm -rwxr--r-- 1 pi pi 4,4K mar 10 2021 oc_calendarsubscriptions.frm -rwxr--r-- 1 pi pi 2,3K mar 10 2021 oc_calendarchanges.frm -rwxr--r-- 1 pi pi 3,2K mar 10 2021 oc_schedulingobjects.frm -rwxr--r-- 1 pi pi 3,9K mar 10 2021 oc_cards_properties.frm -rwxr--r-- 1 pi pi 4,2K mar 10 2021 oc_calendarobjects_props.frm -rwxr--r-- 1 pi pi 2,4K mar 10 2021 oc_directlink.frm -rwxr--r-- 1 pi pi 3,8K mar 10 2021 oc_dav_shares.frm -rwxr--r-- 1 pi pi 17K mar 10 2021 oc_calendar_resources.frm -rwxr--r-- 1 pi pi 17K mar 10 2021 oc_calendar_rooms.frm -rwxr--r-- 1 pi pi 4,8K mar 10 2021 oc_calendar_invitations.frm -rwxr--r-- 1 pi pi 14K mar 10 2021 oc_calendar_resources_md.frm -rwxr--r-- 1 pi pi 14K mar 10 2021 oc_calendar_rooms_md.frm -rwxr--r-- 1 pi pi 2,8K mar 10 2021 oc_dav_cal_proxy.frm -rwxr--r-- 1 pi pi 5,3K mar 10 2021 oc_calendar_reminders.frm -rwxr--r-- 1 pi pi 2,1K mar 10 2021 oc_twofactor_backupcodes.frm -rwxr--r-- 1 pi pi 6,5K mar 10 2021 oc_trusted_servers.frm -rwxr--r-- 1 pi pi 8,0K mar 10 2021 oc_oauth2_clients.frm -rwxr--r-- 1 pi pi 4,7K mar 10 2021 oc_oauth2_access_tokens.frm -rwxr--r-- 1 pi pi 6,1K mar 10 2021 oc_user_status.frm -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_collres_resources.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_collres_collections.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_webauthn.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_direct_edit.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_users.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_storages_credentials.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_groups.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_user_transfer_owner.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_group_user.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_share_external.ibd -rwxr--r-- 1 pi pi 192K mar 10 2021 oc_recent_contact.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_privacy_admins.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_notifications_pushtokens.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_flow_operations_scope.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_flow_operations.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_flow_checks.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_text_steps.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_text_sessions.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_text_documents.ibd -rwxr--r-- 1 pi pi 96K mar 10 2021 oc_federated_reshares.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_schedulingobjects.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_dav_shares.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_calendarsubscriptions.ibd -rwxr--r-- 1 pi pi 160K mar 10 2021 oc_calendarobjects_props.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_calendarobjects.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_calendarchanges.ibd -rwxr--r-- 1 pi pi 144K mar 10 2021 oc_activity_mq.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_twofactor_backupcodes.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_trusted_servers.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_storages.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_oauth2_clients.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_oauth2_access_tokens.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_directlink.ibd -rwxr--r-- 1 pi pi 144K mar 10 2021 oc_dav_cal_proxy.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_calendar_rooms_md.ibd -rwxr--r-- 1 pi pi 144K mar 10 2021 oc_calendar_rooms.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_calendar_resources_md.ibd -rwxr--r-- 1 pi pi 144K mar 10 2021 oc_calendar_resources.ibd -rwxr--r-- 1 pi pi 128K mar 10 2021 oc_calendar_reminders.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_calendar_invitations.ibd -rwxr--r-- 1 pi pi 176K mar 10 2021 oc_mounts.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_twofactor_providers.ibd -rwxr--r-- 1 pi pi 112K mar 10 2021 oc_mimetypes.ibd -rwxr--r-- 1 pi pi 112K mar 13 2021 oc_calendars.ibd -rwxr--r-- 1 pi pi 144K mar 15 2021 oc_cards.ibd -rwxr--r-- 1 pi pi 112K mar 15 2021 oc_addressbookchanges.ibd -rwxr--r-- 1 pi pi 96K mar 15 2021 oc_accounts.ibd -rwxr--r-- 1 pi pi 144K mar 15 2021 oc_accounts_data.ibd -rwxr--r-- 1 pi pi 160K mar 15 2021 oc_cards_properties.ibd -rwxr--r-- 1 pi pi 112K mar 15 2021 oc_addressbooks.ibd -rwxr--r-- 1 pi pi 208K abr 5 2021 oc_share.ibd -rwxr--r-- 1 pi pi 144K abr 14 2021 oc_login_flow_v2.ibd -rwxr--r-- 1 pi pi 128K jul 15 22:46 oc_collres_accesscache.ibd -rwxr--r-- 1 pi pi 3,5K jul 16 00:37 oc_known_users.frm drwxr--r-- 2 pi pi 12K jul 16 00:37 . -rwxr--r-- 1 pi pi 128K jul 16 00:37 oc_known_users.ibd -rwxr--r-- 1 pi pi 96K jul 16 00:37 oc_migrations.ibd -rwxr--r-- 1 pi pi 128K jul 16 00:40 oc_bruteforce_attempts.ibd -rwxr--r-- 1 pi pi 128K sep 23 10:03 oc_whats_new.ibd -rwxr--r-- 1 pi pi 96K sep 25 13:05 oc_preferences.ibd -rwxr--r-- 1 pi pi 160K sep 25 13:24 oc_user_status.ibd -rwxr--r-- 1 pi pi 160K sep 30 14:10 oc_notifications.ibd -rwxr--r-- 1 pi pi 10M oct 7 19:12 oc_files_trash.ibd -rwxr--r-- 1 pi pi 9,0M oct 8 11:46 oc_jobs.ibd -rwxr--r-- 1 pi pi 128K oct 11 11:22 oc_appconfig.ibd -rwxr--r-- 1 pi pi 12M oct 14 12:54 oc_filecache_extended.ibd -rwxr--r-- 1 pi pi 36M oct 14 12:54 oc_activity.ibd -rwxr--r-- 1 pi pi 29M oct 17 13:50 oc_file_locks.ibd -rwxr--r-- 1 pi pi 104M oct 17 13:50 oc_filecache.ibd -rwxr--r-- 1 pi pi 256K oct 17 14:04 oc_authtoken.ibd drwxrwxr-- 5 pi pi 4,0K oct 22 20:55 .. pi@raspberrypi:/media/pi/RaspberryPI/mariadb/databases/nextcloud_db $ Quote Link to comment
trurl Posted October 22, 2021 Share Posted October 22, 2021 9 minutes ago, juaaslo said: pi@raspberrypi:/media/pi/RaspberryPI/mariadb/databases/nextcloud_db $ You should always check the first post in the thread for important information. On 8/24/2015 at 10:09 AM, linuxserver.io said: If you are not using Unraid (and you should be!) then please do not post here, instead head to linuxserver.io to see how to get support. Quote Link to comment
juaaslo Posted October 23, 2021 Share Posted October 23, 2021 13 hours ago, trurl said: You should always check the first post in the thread for important information. Thanks for answering. Just to explain myself, I arrived here from Linuxserver.io - MariaDB docker hub site, following the "Discord - realtime support / chat with the community and the team." link, and when arrived here I see in the first post "[Support] Linuxserver.io - MariaDB", which is exactly the docker image I have, so I thought it was the correct place to get support about my docker image and configuration. I am sorry I didn't even know what Unraid was, so for this particular case, and in order to avoid annoying posts like mine from people trying to follow the stones, I recommend this is explained more clearly in docker hub site, specifying that the proposed link is to get support only for users of a concrete OS and not the image itself. Sorry again, and BR! Quote Link to comment
saarg Posted October 23, 2021 Share Posted October 23, 2021 2 hours ago, juaaslo said: Thanks for answering. Just to explain myself, I arrived here from Linuxserver.io - MariaDB docker hub site, following the "Discord - realtime support / chat with the community and the team." link, and when arrived here I see in the first post "[Support] Linuxserver.io - MariaDB", which is exactly the docker image I have, so I thought it was the correct place to get support about my docker image and configuration. I am sorry I didn't even know what Unraid was, so for this particular case, and in order to avoid annoying posts like mine from people trying to follow the stones, I recommend this is explained more clearly in docker hub site, specifying that the proposed link is to get support only for users of a concrete OS and not the image itself. Sorry again, and BR! I'm not sure how you managed to get to the unraid forum by clicking on the discord link on mariadbs docker hub page? It takes you to an invite link for our Discord server and does not point to this forum. Quote Link to comment
ebnerjoh Posted October 23, 2021 Share Posted October 23, 2021 Hi, Today I updated the MariaDB Docker and now it is not starting anymore. the err-log shows the following: 2021-10-23 17:53:53 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 manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2021-10-23 17:53:53 0 [ERROR] Aborting any ideas? Br, Johannes Quote Link to comment
Pixel5 Posted October 26, 2021 Share Posted October 26, 2021 my mariaDB is stuck in a boot loop now, is anyone else having this problem after the lastest update? 211026 11:00:22 mysqld_safe Starting mariadbd daemon with databases from /config/databases Quote Link to comment
j0nnymoe Posted October 26, 2021 Share Posted October 26, 2021 On 10/23/2021 at 4:57 PM, ebnerjoh said: Hi, Today I updated the MariaDB Docker and now it is not starting anymore. the err-log shows the following: 2021-10-23 17:53:53 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 manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2021-10-23 17:53:53 0 [ERROR] Aborting any ideas? Br, Johannes 40 minutes ago, Pixel5 said: my mariaDB is stuck in a boot loop now, is anyone else having this problem after the lastest update? 211026 11:00:22 mysqld_safe Starting mariadbd daemon with databases from /config/databases This has already been heavily discussed with solutions in previous posts of this thread. Quote Link to comment
Abigel Posted October 28, 2021 Share Posted October 28, 2021 hi my mariadb has high cpu usage and idk why Quote Link to comment
ebnerjoh Posted October 29, 2021 Share Posted October 29, 2021 On 10/26/2021 at 11:41 AM, j0nnymoe said: This has already been heavily discussed with solutions in previous posts of this thread. Unfortunatley nothing helped for me. I have completely removed MariaDB-Docker and reinstalled. A fresh installation is working. But when I copy/paste "databases"-Directory, then its failing again. UMASK must be a 3-digit mode with an additional leading 0 to indicate octal. The first digit will be corrected to 6, the others may be 0, 2, 4, or 6. UMASK corrected from 022 to 0640 ... 211029 11:27:36 mysqld_safe Logging to '/config/databases/92ecc8717197.err'. 211029 11:27:36 mysqld_safe Starting mariadbd daemon with databases from /config/databases 211029 11:29:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2021-10-29 11:29:59 0 [Note] /usr/bin/mariadbd (mysqld 10.5.12-MariaDB-log) starting as process 4723 ... 2021-10-29 11:29:59 0 [Note] InnoDB: Uses event mutexes 2021-10-29 11:29:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-29 11:29:59 0 [Note] InnoDB: Number of pools: 1 2021-10-29 11:29:59 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2021-10-29 11:29:59 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts) 2021-10-29 11:29:59 0 [Note] InnoDB: Using Linux native AIO 2021-10-29 11:29:59 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2021-10-29 11:29:59 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-29 11:29:59 0 [Note] InnoDB: Transaction 209762720 was in the XA prepared state. 2021-10-29 11:29:59 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2021-10-29 11:29:59 0 [Note] InnoDB: Trx id counter is 209762721 2021-10-29 11:29:59 0 [Note] InnoDB: 128 rollback segments are active. 2021-10-29 11:29:59 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2021-10-29 11:29:59 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2021-10-29 11:29:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-29 11:29:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-29 11:29:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-10-29 11:29:59 0 [Note] InnoDB: 10.5.12 started; log sequence number 402194885721; transaction id 209762722 2021-10-29 11:29:59 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-29 11:29:59 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2021-10-29 11:29:59 0 [Note] InnoDB: Buffer pool(s) load completed at 211029 11:29:59 2021-10-29 11:29:59 0 [Note] InnoDB: Starting recovery for XA transactions... 2021-10-29 11:29:59 0 [Note] InnoDB: Transaction 209762720 in prepared state after recovery 2021-10-29 11:29:59 0 [Note] InnoDB: Transaction contains changes to 4 rows 2021-10-29 11:29:59 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2021-10-29 11:29:59 0 [Note] Found 1 prepared transaction(s) in InnoDB 2021-10-29 11:29:59 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 manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2021-10-29 11:29:59 0 [ERROR] Aborting 211029 11:29:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Quote Link to comment
ebnerjoh Posted October 29, 2021 Share Posted October 29, 2021 Then I opened a cmd-line to the docker and exexuted: root@92ecc8717197:/# mysqld --user=root --tc-heuristic-recover rollback 2021-10-29 11:32:32 0 [Note] mysqld (mysqld 10.5.12-MariaDB-log) starting as process 5366 ... 2021-10-29 11:32:32 0 [Note] InnoDB: Uses event mutexes 2021-10-29 11:32:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-29 11:32:32 0 [Note] InnoDB: Number of pools: 1 2021-10-29 11:32:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2021-10-29 11:32:32 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts) 2021-10-29 11:32:32 0 [Note] InnoDB: Using Linux native AIO 2021-10-29 11:32:32 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2021-10-29 11:32:32 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-29 11:32:32 0 [Note] InnoDB: 128 rollback segments are active. 2021-10-29 11:32:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-29 11:32:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-29 11:32:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-10-29 11:32:32 0 [Note] InnoDB: 10.5.12 started; log sequence number 35028; transaction id 8 2021-10-29 11:32:32 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-29 11:32:32 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2021-10-29 11:32:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-10-29 11:32:32 0 [Note] Heuristic crash recovery mode 2021-10-29 11:32:32 0 [Note] Please restart mysqld without --tc-heuristic-recover 2021-10-29 11:32:32 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") 2021-10-29 11:32:32 0 [Note] InnoDB: Buffer pool(s) load completed at 211029 11:32:32 2021-10-29 11:32:32 0 [ERROR] Can't init tc log 2021-10-29 11:32:32 0 [ERROR] Aborting Quote Link to comment
pengrus Posted November 3, 2021 Share Posted November 3, 2021 On 10/23/2021 at 6:54 AM, saarg said: I'm not sure how you managed to get to the unraid forum by clicking on the discord link on mariadbs docker hub page? It takes you to an invite link for our Discord server and does not point to this forum. @saarg, What a very strange way to say "Hey buddy, this forum is for UnRAID support, head over to linuxserver.io for other platforms, or join our Discord at https://discord.gg/YWrKVTn." Which @trurl had basically already said. We all understand that while UnRAID is closed source, these addons are open. And we are grateful. But a huge selling point of the platform is its "supportive community." I have received a great deal of support myself, including from you if memory serves. But that comment is just rude. Maybe they had two browser tabs open searching for help and came to this forum accidentally. Maybe whatever. Point is, if we could keep this forum civil and kind and not have it devolve into neckbeardy "you didn't exactly follow the rules 20 pages ago and didn't ask your question how I want so pack sand and figure it out n00b," I think it would be great. I fully anticipate that I may be wrong and perhaps you didn't mean it the way I took it (if so I apologize in advance), but I just dropped back in to see if anyone had any help for the issue I and others are having (which apparently no one does), and I see this and it's just unhelpful. Felt like I should say something about that. Thank you for coming to my TED Talk. -P Quote Link to comment
trurl Posted November 3, 2021 Share Posted November 3, 2021 3 minutes ago, pengrus said: perhaps you didn't mean it the way I took it (if so I apologize in advance) apology accepted 😉 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.