Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.11
-
None
-
linux
Description
where to begin.....
Over the last 24 hours i've had 3 (out of 5 total) mariadb production servers crash with similar errors (see attachment).
Each server has about 30 customer databases (identical structure) that customers connect to from an indentical win32 desktop using ODBC.
INNODB tables.
Not aware of any changes to the servers or the databases or the win32.exe.
On each server there has been, since yesterday, one database where if i run a couple of specific but seemingly innocuous queries the server crashes and restarts.
The error mentions an index.... so in each of the queries i (eventually) removed the indexes used by a subquery. and hey presto no crash. slow but no crash.
I must emphasise that i only removed the indexes from the one database on each server that was mentioned in the crash report. The other databases with the same structure on the same servers continue to work just fine with the same queries and the same indexes . And the database that are causing a crash have been same structure running same queries for months and months.
the databases causing the error are no larger than any of the others (a few thousand records in the deal and invoices tables).
i removed the indexes on invoices,dealid invoices.who invoices.term invoices.invoice deal.dealid
.dealid and .invoice and .term are int 11; .who is varchar 10
the other query that causes a crash is an update and uses invoice.invoice in a subquery
again, to emphasise, this query has been run a thousand times a day on 200 or more databases for more than a year with no problem... until yesterday on 3 databases
Attachments
Issue Links
- blocks
-
MDEV-28349 Provide "crash safe" options for CHECK TABLE and ALTER TABLE ... CHECK PARTITION ...
- Open
- causes
-
MDEV-34357 InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211
- Closed
- is blocked by
-
MDEV-13542 Crashing on a corrupted page is unhelpful
- Closed
- is duplicated by
-
MDEV-22736 Assertion failure in file rem0rec.cc line 814
- Closed
-
MDEV-29451 server crash on complex select (Assertion failure in file rem0rec.cc line 815)
- Closed
-
MDEV-30316 mariadb server crash
- Closed