Difference between revisions of "/var/log/mysql/error.log (MariaDB)"

From wikieduonline
Jump to navigation Jump to search
Line 37: Line 37:
 
* <code>[[mariadb-check --all-databases]]</code>
 
* <code>[[mariadb-check --all-databases]]</code>
 
* <code>[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code>
 
* <code>[[/etc/mysql/mariadb.conf.d/50-server.cnf]]</code>
 +
* <code>[[/usr/lib/nagios/plugins/check_mysql]]</code>
  
 
== See also ==
 
== See also ==

Revision as of 07:57, 21 December 2023

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


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

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.

Related terms

See also

Advertising: