I'm working on a raspberry pi with LAMPP installed on it. All worked but since 3 day, Maria db don't wan't to start.
When I use the command systemctl status mariadb.service, I have this result 2 day ago.
- Code: Select all
● mariadb.service - MariaDB 10.5.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: activating (start) since Sat 2022-04-16 20:54:28 CEST; 383ms ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 5721 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 5722 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 5724 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && s>
Main PID: 5774 (mariadbd)
Tasks: 3 (limit: 4915)
CPU: 317ms
CGroup: /system.slice/mariadb.service
└─5774 /usr/sbin/mariadbd
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745884202: unable to open file ./test/#sql-alter-1b1a-18.ibd for>
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745887079: unable to open file ./test/#sql-ib23.ibd for tablespa>
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745887596: unable to open file ./test/tweets.ibd for tablespace 8
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745891380: unable to open file ./test/#sql-alter-1b1a-18.ibd for>
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745895502: unable to open file ./test/tweets.ibd for tablespace 8
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745895502: unable to open file ./test/#sql-backup-1b1a-18.ibd fo>
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5745897354: unable to open file ./test/tweets.ibd for tablespace 9
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5746324812: unable to open file ./test/tweets.ibd for tablespace 9
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: At LSN: 5746383975: unable to open file ./test/tweets.ibd for tablespace 9
avril 16 20:54:29 raspberrypi mariadbd[5774]: 2022-04-16 20:54:29 0 [Note] InnoDB: Starting final batch to recover 12 pages from redo log.
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: 128 rollback segments are active.
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; >
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: 10.5.12 started; log sequence number 5746472218; transaction id 13760997
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [Note] Plugin 'FEEDBACK' is disabled.
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0 [ERROR] InnoDB: Space id and page no stored in the page, read in are [page id: space=6, >
avril 16 20:54:30 raspberrypi mariadbd[5774]: 2022-04-16 20:54:30 0x962fd380 InnoDB: Assertion failure in file ./storage/innobase/include/fut0lst.h line 128
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: Failing assertion: ut_align_offset(faddr, srv_page_size) >= FIL_PAGE_DATA
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: We intentionally generate a memory trap.
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: If you get repeated assertion failures or crashes, even
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: immediately after the mysqld startup, there may be
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: corruption in the InnoDB tablespace. Please refer to
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
avril 16 20:54:30 raspberrypi mariadbd[5774]: InnoDB: about forcing recovery.
avril 16 20:54:30 raspberrypi mariadbd[5774]: 220416 20:54:30 [ERROR] mysqld got signal 6 ;
avril 16 20:54:30 raspberrypi mariadbd[5774]: This could be because you hit a bug. It is also possible that this binary
avril 16 20:54:30 raspberrypi mariadbd[5774]: or one of the libraries it was linked against is corrupt, improperly built,
avril 16 20:54:30 raspberrypi mariadbd[5774]: or misconfigured. This error can also be caused by malfunctioning hardware.
avril 16 20:54:30 raspberrypi mariadbd[5774]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
avril 16 20:54:30 raspberrypi mariadbd[5774]: We will try our best to scrape up some info that will hopefully help
avril 16 20:54:30 raspberrypi mariadbd[5774]: diagnose the problem, but since we have already crashed,
avril 16 20:54:30 raspberrypi mariadbd[5774]: something is definitely wrong and this may fail.
avril 16 20:54:30 raspberrypi mariadbd[5774]: Server version: 10.5.12-MariaDB-0+deb11u1
avril 16 20:54:30 raspberrypi mariadbd[5774]: key_buffer_size=134217728
avril 16 20:54:30 raspberrypi mariadbd[5774]: read_buffer_size=131072
avril 16 20:54:30 raspberrypi mariadbd[5774]: max_used_connections=0
avril 16 20:54:30 raspberrypi mariadbd[5774]: max_threads=153
avril 16 20:54:30 raspberrypi mariadbd[5774]: thread_count=1
avril 16 20:54:30 raspberrypi mariadbd[5774]: It is possible that mysqld could use up to
avril 16 20:54:30 raspberrypi mariadbd[5774]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466524 K bytes of memory
avril 16 20:54:30 raspberrypi mariadbd[5774]: Hope that's ok; if not, decrease some variables in the equation.
avril 16 20:54:30 raspberrypi mariadbd[5774]: Thread pointer: 0x99900fa8
avril 16 20:54:30 raspberrypi mariadbd[5774]: Attempting backtrace. You can use the following information to find out
avril 16 20:54:30 raspberrypi mariadbd[5774]: where mysqld died. If you see no messages after this, something went
avril 16 20:54:30 raspberrypi mariadbd[5774]: terribly wrong...
avril 16 20:54:30 raspberrypi mariadbd[5774]: stack_bottom = 0x962fcccc thread_stack 0x49000
avril 16 20:54:30 raspberrypi mariadbd[5774]: Trying to get some variables.
avril 16 20:54:30 raspberrypi mariadbd[5774]: Some pointers may be invalid and cause the dump to abort.
avril 16 20:54:30 raspberrypi mariadbd[5774]: Query (0x0): (null)
avril 16 20:54:30 raspberrypi mariadbd[5774]: Connection ID (thread ID): 0
avril 16 20:54:30 raspberrypi mariadbd[5774]: Status: NOT_KILLED
avril 16 20:54:30 raspberrypi mariadbd[5774]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,in>
avril 16 20:54:30 raspberrypi mariadbd[5774]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
avril 16 20:54:30 raspberrypi mariadbd[5774]: information that should help you find out what is causing the crash.
avril 16 20:54:30 raspberrypi mariadbd[5774]: We think the query pointer is invalid, but we will try to print it anyway.
avril 16 20:54:30 raspberrypi mariadbd[5774]: Query:
avril 16 20:54:30 raspberrypi mariadbd[5774]: Writing a core file...
avril 16 20:54:30 raspberrypi mariadbd[5774]: Working directory at /var/lib/mysql
avril 16 20:54:30 raspberrypi mariadbd[5774]: Resource Limits:
avril 16 20:54:30 raspberrypi mariadbd[5774]: Limit Soft Limit Hard Limit Units
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max cpu time unlimited unlimited seconds
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max file size unlimited unlimited bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max data size unlimited unlimited bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max stack size 8388608 unlimited bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max core file size 0 unlimited bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max resident set unlimited unlimited bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max processes 60613 60613 processes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max open files 32768 32768 files
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max locked memory 65536 65536 bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max address space unlimited unlimited bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max file locks unlimited unlimited locks
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max pending signals 60613 60613 signals
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max msgqueue size 819200 819200 bytes
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max nice priority 0 0
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max realtime priority 0 0
avril 16 20:54:30 raspberrypi mariadbd[5774]: Max realtime timeout unlimited unlimited us
avril 16 20:54:30 raspberrypi mariadbd[5774]: Core pattern: core
now, I have not the same result, I have this :
- Code: Select all
● mariadb.service - MariaDB 10.5.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: signal) since Mon 2022-04-18 15:57:18 CEST; 4s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 19628 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 19629 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 19631 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 19679 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
Main PID: 19679 (code=killed, signal=ABRT)
Status: "Starting final batch to recover 12 pages from redo log"
CPU: 559ms
avril 18 15:56:12 raspberrypi systemd[1]: mariadb.service: Failed with result 'signal'.
avril 18 15:56:12 raspberrypi systemd[1]: Failed to start MariaDB 10.5.12 database server.
When I try to execute mysqlanalyse or mysqldump, I have this result :
- Code: Select all
mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)" when trying to connect
Is it possible to find a solution to start maria db or to dump the database please?
Thank you!