/var/log/mysql/error.log (MariaDB)

Note | Warning | ERROR

cat /var/log/mysql/error.log | grep -v Note
zcat -f /var/log/mysql/error*
zcat -f /var/log/mysql/error* | grep -i ERROR

ERROR

• [ERROR] No space left on device
• [ERROR] is marked as crashed and should be repaired
• [ERROR] Probably out of disk space
• [ERROR] Crash recovery finished.
• [ERROR] mysqld: Out of memory (Needed 128663552 bytes)
• [ERROR] InnoDB: Cannot allocate memory for the buffer pool

2023-03-30  5:06:42 4395974 [ERROR] mysqld: Disk full (/tmp/#sql_1b3c_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

2020-05-05  5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/searchindex' is marked as crashed and should be repaired
2020-05-05  5:56:00 139949468755712 [Warning] Checking table:   './xxxxx/searchindex'

2022-12-15 19:18:32 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
2022-12-15 19:18:32 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
2022-12-15 19:18:32 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
2022-12-15 19:18:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-12-15 19:18:37 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-12-15 19:18:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-12-15 19:18:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-12-15 19:18:37 0 [ERROR] Aborting
2022-12-15 19:21:06 35 [ERROR] mysqld: Table './xxxxx/searchindex' is marked as crashed and should be repaired

2024-12-23  5:01:05 0 [ERROR] mysqld: Out of memory (Needed 128663552 bytes)

Warning

[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement

[Warning] Aborted connection 139 to db: 'yourdb' user: 'youruser' host: 'localhost' Got an error reading communication packets

2025-08-01  5:01:32 0 [Warning] Aborted connection 0 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Too many connections)
See: max_connections

Note

2020-05-05  5:55:58 139949469387904 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2023-12-26  5:52:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=14814872110

2024-12-18  7:25:29 1686 [Note] Suppressed 11 unsafe warnings during the last 308 seconds

[Note] Suppressing warnings of type

Related terms

• MariaDB versions
• systemctl status mariadb
• mariadb-check --all-databases
• /etc/mysql/mariadb.conf.d/50-server.cnf
• /usr/lib/nagios/plugins/check_mysql
• Rebuildrecentchanges.php (page)
• /var/log/mysql/mariadb-slow.log
• systemctl restart mariadb
• LEMP
• MariaDB binary log

See also

• /var/log/mysql/error.log, mariadbcheck, MariaDB binary log, MariaDB troubleshooting, MariaDB binary log
• mariadbcheck