Bonjour,
J’ai installé un LAMP sur mon rapsberry qui fonctionnait jusque là sans soucis. depuis hier, quand j’essaye de démarrer MariaDB, j’ai une erreur que je n’arrive pas à résoudre. j’ai essayé de démarrer mysqanalyse, mais j’ai cette erreur :
mysqlanalyze: Got error: 2002: Can’t connect to local MySQL server through socket ‹ /run/mysqld/mysqld.sock › (111) when trying to connect
lorsque je vais voir dans systemctl status mariadb.service, j’ai ces erreurs :
● 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)
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
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: 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
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]: 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
Vous auriez une idée de comment relancer la base de données, au moins pour en faire une sauvegarde?
Merci!