-
-
Notifications
You must be signed in to change notification settings - Fork 495
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
mariaDB crashing #7159
Comments
@pedrom34 moved your topic into issue section can you share following
|
Thanks. cat /var/log/mysql/error.log
readlink /var/lib/mysql
readlink -f /var/lib/mysql
journalctl -u mariadb
|
database file seems to be corrupted. Can you check for kernel error messages
|
A lot of redflags, right? |
At least the drive seems to have some bad blocks. Is this an SSD, HDD or flash drive? |
What type of SBC you are using and how is your external drive powered? |
Odroid C2. System is on eMMC, userdata is on an USB flashdrive. |
If you have another flash drive at hand, please try to move the userdata over to that one. It might fail when it runs into I/O errors while reading the affected blocks, but worth an attempt before we try to repair the filesystem and mask the bad blocks, and serves as backup as well. Then try to repair the filesystem with |
Thanks, I'll try as soon as I have physical access to the server. |
Usually it's not. |
Sorry for the delay, I just came back from vacation, bought a new usb drive, and did what @MichaIng told me. Unfortunately it doesn't solve the issue, as mariaDB refuse to start: dietpi-services status:
And I cannot uninstall/reinstall as dietpi-software tries to backup the DB and fails. Can you help me with that? I can drop the DB, I don't really care. |
The issue changed.
Now it's a permission issue on your new drive. Can you share following
|
ls -la /var/lib/mysql/
|
permissions are incorrectly set. How did you copy these files? Or was this a fresh install? Usually, it should like this
|
Well, the copy was made by the dietpi utility to move dietpi_userdata.
I'll adjust permissions and test.
…-------- Message d'origine --------
Le 04/08/2024 12:56, Joulinar a écrit :
permissions are incorrectly set. How did you copy these files? Or was this a fresh install?
Usually, it should like this
***@***.***:~# ls -la /var/lib/mysql/
total 123332
drwxr-xr-x 5 mysql mysql 4096 Aug 4 11:51 .
drwxrwxr-x 7 dietpi dietpi 4096 Aug 4 11:34 ..
-rw-rw---- 1 mysql mysql 417792 Aug 4 11:51 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Aug 4 11:51 aria_log_control
-rw-rw---- 1 mysql mysql 9 Aug 4 11:51 ddl_recovery.log
-rw-r--r-- 1 root root 0 Aug 4 11:34 debian-10.11.flag
-rw-rw---- 1 mysql mysql 910 Aug 4 11:51 ib_buffer_pool
-rw-rw---- 1 mysql mysql 100663296 Aug 4 11:34 ib_logfile0
-rw-rw---- 1 mysql mysql 12582912 Aug 4 11:34 ibdata1
-rw-rw---- 1 mysql mysql 12582912 Aug 4 11:51 ibtmp1
-rw-rw---- 1 mysql mysql 0 Aug 4 11:34 multi-master.info
drwx------ 2 mysql mysql 4096 Aug 4 11:34 mysql
-rw-r--r-- 1 root root 15 Aug 4 11:34 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Aug 4 11:34 performance_schema
drwx------ 2 mysql mysql 12288 Aug 4 11:34 sys
***@***.***:~#
—
Reply to this email directly, [view it on GitHub](#7159 (comment)), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/AFB34POMAP4DR65TROEYH2TZPYCG5AVCNFSM6AAAAABK2DH57WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRXGQ4TSMJSHE).
You are receiving this because you were mentioned.Message ID: ***@***.***>
|
Ok, I managed to run mariaDB again by adjusting permissions as per your install, and by restoring an old backup of the 3 roles_mapping files, because it seems the files were damaged. So it was a usb key issue all this time. Thanks a lot for your time 👍 |
Discussed in #7158
Originally posted by pedrom34 July 13, 2024
Hey everyone!
Since latest dietpi update, mariadb won't start on one of my SBC (the other is fine).
Can you give a hint on how to debug this? google won't help as I don't know if the answers I found are related to my issue...
Here's dietpi-services status command.
Please tell me it's not a disk issue. I'm at 800km from my server right now...
The text was updated successfully, but these errors were encountered: