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

From wikieduonline
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 8: Line 8:
  
 
== ERROR ==
 
== ERROR ==
 +
* <code>[[No space left on device]]</code>
 +
* <code>[[is marked as crashed and should be repaired]]</code>
 +
* <code>[[Probably out of disk space]]</code>
 +
 +
 +
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 [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'
 
  2020-05-05  5:56:00 139949468755712 [Warning] Checking table:  './xxxxx/searchindex'
Line 22: Line 29:
 
  2022-12-15 19:21:06 35 [ERROR] mysqld: Table './xxxxx/searchindex' [[is marked as crashed and should be repaired]]
 
  2022-12-15 19:21:06 35 [ERROR] mysqld: Table './xxxxx/searchindex' [[is marked as crashed and should be repaired]]
  
−
 
+
== Warning ==
−
  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]]")
+
  [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]]
  
 
== Note ==
 
== 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.
 
  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
  
 
== Related terms ==
 
== Related terms ==
Line 33: Line 42:
 
* <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 ==
 +
* {{InnoDB}}
 
* {{MariaDB}}
 
* {{MariaDB}}
  
  
 
[[Category:MariaDB]]
 
[[Category:MariaDB]]

Latest revision as of 06:31, 9 June 2024

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[edit]


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

Warning[edit]

[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

Note[edit]

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

Related terms[edit]

See also[edit]

Retrieved from "https://www.wikieduonline.com/index.php?title=/var/log/mysql/error.log_(MariaDB)&oldid=325904"

Advertising: