Details
Major Description
After updating mariadb from 11.4.5 to 11.4.7 it crashes, when trying to access some tables.
After downgrading back to 11.4.5 the table is accessible.
What can be monitored:
show processlist;
|
| 2 | event_scheduler | localhost | NULL | Daemon | 1055 | Waiting for next activation | NULL | 0.000 |
|
| 6 | system user | | NULL | Slave_IO | 1055 | Waiting for master to send event | NULL | 0.000 |
|
| 7 | system user | | qmsystems | Slave_SQL | 438 | | INSERT INTO rdStrassensperrung SET `ID`="0",`Strasse`="Innenstadt Waldkirch",`Ort`="Waldkirch",`hinw | 0.000 |
|
| 20 | replication_user | 10.0.1.14:56460 | NULL | Binlog Dump | 1054 | Master has sent all binlog to slave; waiting for more updates | NULL | 0.000 |
|
| 23 | root | localhost | qmsystems | Killed | 976 | | select * from rdStrassensperrung LIMIT 1 | 0.000 |
|
| 124 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
|
| 175 | root | localhost | NULL | Sleep | 55 | | NULL | 0.000 |
|
a simple select to that aria table makes it crash - other tables work.
Mysql process uses 100% cpu, the database server can't be stopped (killed) via
mariadb-admin shutdown
|
nor
systemctl stop mysqld
|
it must be killed via
killall -9 mysqld
|
There is nothing special about that table, as fas as I can see:
show create table rdStrassensperrung;
|
| Table | Create Table |
|
| rdStrassensperrung | CREATE TABLE `rdStrassensperrung` (
|
`ID` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
|
`OrganisationID` smallint(5) unsigned NOT NULL,
|
`Strasse` varchar(255) NOT NULL,
|
`Ort` tinytext NOT NULL,
|
`von` datetime NOT NULL,
|
`bis` datetime DEFAULT NULL,
|
`hinweis` varchar(400) NOT NULL,
|
`Grund` enum('Bauarbeiten','Veranstaltung','Demonstration','Begrenzte Höhe / Breite / Gewicht','Sondereinsatzpläne','Objektpläne','Lotsenpunkte','Sonstiges') NOT NULL,
|
`Sperrung` enum('Teilsperrung','Nachtsperrung','Wochenendsperrung','Nacht-/Wochenendsperrung','Vollsperrung','Information') NOT NULL,
|
`Link` tinytext DEFAULT NULL,
|
`Wache` tinytext NOT NULL,
|
PRIMARY KEY (`ID`),
|
KEY `OrganisationID` (`OrganisationID`),
|
KEY `bis` (`bis`),
|
CONSTRAINT `basicCheck` CHECK (`bis` is null or `von` < `bis`)
|
) ENGINE=Aria AUTO_INCREMENT=55548 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci CHECKSUM=1 PAGE_CHECKSUM=1 ROW_FORMAT=PAGE TRANSACTIONAL=1 COMMENT='Strassensperrungsverzeichnis' |
|
This happend on a server - but luckily I can reproduce this issue locally, so tell me what information you need.
Attachments
Issue Links
- duplicates
-
MDEV-36765 JSON histograms cannot handle >1 byte characters from 10.11.12
-
- Closed
-