[MDEV-30331] MariaDB-Crashed with error message (mysqld got signal 6, mysqld got signal 11) Created: 2023-01-03 Updated: 2023-10-06 Resolved: 2023-01-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Affects Version/s: | 10.4.6 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Manoharan M | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | crash | ||
| Environment: |
OS: CentOS Linux release 7.5.1804 (Core) |
||
| Attachments: |
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Description |
|
DB Replication enabled in Production Environment.(Master-Slave-Slave). At same time all DB instance were crashed & not able to restart the instance. |
| Comments |
| Comment by Daniel Black [ 2023-01-03 ] | ||||||
|
There have been 3.5 years of 10.4 updates since its first GA release on 10.4.6. I'd suggest restoring from a backup with a latest 10.4 version with innodb_change_buffering=none. This bug has similarities to | ||||||
| Comment by Manoharan M [ 2023-01-03 ] | ||||||
|
Last 3 years its running fine without any problem. How suddenly in all 3 instances crash happened at same time. | ||||||
| Comment by Marko Mäkelä [ 2023-01-03 ] | ||||||
|
The following in mariadb_error_log_1-jan-2023.txt
I think that the only fix is to rebuild all tables on which ALTER TABLE…ADD COLUMN or ALTER TABLE…DROP COLUMN was invoked, or columns were reordered in the past, without rebuilding the table. The bug is triggered by a DML operation, such as a massive DELETE, which forces the index tree to shrink. You may have to restore the affected tables from a backup. When it comes to crashing on this corruption, recent versions of MariaDB 10.6 or later series no longer do that, thanks to | ||||||
| Comment by Manoharan M [ 2023-10-06 ] | ||||||
|
In MariaDB 10.4.13 version also similar crashing observed. But its recovers after crash. toku_memory_startup: Assertion `result == 0' failed (errno=0) 230926 3:37:23 [ERROR] mysqld got signal 6 ; Attempting backtrace. You can use the following information to find out
Workaround: Removed mariadb/lib/plugin/ha_tokudb.so file from tar ball installation. Its working without any crash. | ||||||
| Comment by Manoharan M [ 2023-10-06 ] | ||||||
|
Similar & related Issue |