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

From wikieduonline
Jump to navigation Jump to search
 
(22 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
  [[/var/log/mysql/]]error.log
+
  Note | Warning | ERROR
−
cat /var/log/mysql/error.log | grep -v [[Note]]
+
 
 +
cat [[/var/log/mysql/]]error.log | grep -v [[Note]]
 
  [[zcat -f]] /var/log/mysql/error*
 
  [[zcat -f]] /var/log/mysql/error*
 
  zcat -f /var/log/mysql/error* | grep -i ERROR
 
  zcat -f /var/log/mysql/error* | grep -i 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 [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 ==
 +
[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 ==
 
  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.
  
−
  2020-05-05 5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/searchindex' is marked as crashed and should be repaired
+
  2023-12-26 5:52:14 0 [Note] [[InnoDB]]: [[Starting crash recovery from checkpoint]] LSN=14814872110
−
2020-05-05  5:56:00 139949468755712 [Warning] Checking table:  './xxxxx/searchindex'
 
  
 
== Related terms ==
 
== Related terms ==
 
* [[MariaDB versions]]
 
* [[MariaDB versions]]
 
* <code>[[systemctl status mariadb]]</code>
 
* <code>[[systemctl status mariadb]]</code>
−
* <code>[[mariadbcheck]]</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>
 +
* [[Rebuildrecentchanges.php (page)]]
 +
* [[/var/log/mysql/mariadb-slow.log]]
  
 
== See also ==
 
== See also ==
 +
* {{MariaDB logs}}
 
* {{MariaDB}}
 
* {{MariaDB}}
−
 
  
 
[[Category:MariaDB]]
 
[[Category:MariaDB]]

Latest revision as of 10:42, 2 October 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=346958"

Advertising: