[Support] Linuxserver.io - MariaDB


Recommended Posts

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.

Link to comment
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.

Link to comment
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 by eds
added end of log for clarification
  • Thanks 1
Link to comment

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

Link to comment
  • 2 weeks later...
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.

Link to comment

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

Link to comment
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

Link to comment

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 $


 

Link to comment
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.

 

Link to comment
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!

Link to comment
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.

Link to comment

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

Link to comment
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.

Link to comment
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


 

Link to comment

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

Link to comment

 

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

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.