Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 10.6.10, 10.6.12, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL)
-
Ubuntu LTS 20.04 with MariaDB deb packages from mariadb.org repo.
Description
When inserting around 110k rows into a table, mariadb crashes. The table in question:
MariaDB [test]> show create table z_kartverket_midtpunkt_gateadr\G
|
*************************** 1. row ***************************
|
Table: z_kartverket_midtpunkt_gateadr
|
Create Table: CREATE TABLE "z_kartverket_midtpunkt_gateadr" (
|
"kommunenummer" char(4) NOT NULL,
|
"adressenavn" varchar(128) NOT NULL,
|
"postnr" char(4) NOT NULL,
|
"postnummeromrade" varchar(128) NOT NULL,
|
"ant_adresser" int(9) unsigned NOT NULL DEFAULT 0,
|
"lat" float NOT NULL COMMENT 'breddegrad',
|
"lon" float NOT NULL COMMENT 'lengdegrad',
|
"coord" point NOT NULL,
|
"dkstatus" tinyint(1) NOT NULL DEFAULT 1 COMMENT 'DK gyldighet',
|
PRIMARY KEY ("kommunenummer","adressenavn","postnr"),
|
KEY "dkstatus" ("dkstatus"),
|
KEY "ant_adresser" ("ant_adresser"),
|
SPATIAL KEY "coord" ("coord")
|
)
|
1 row in set (0.001 sec)
|
Given a specific SQL file with insert statements, the crash occurs on a specific insert every time. If we remove the insert we get further. Also, doing the specific insert when the table is empty works fine, so it doesn't seem to be the insert itself that is problematic.
A stack trace and the server configuration file are attached.
The error log, a coredump, and a file with inserts that will reproduce the problem has been uploaded to ftp.askmonty.org with the name 2023-03-crash-10.6-coredump-and-sql-to-reproduce.tar.gz .
Steps to reproduce:
- create (or truncate if already exists) the table
- mysql $db < insert-statements.sql
Attachments
Issue Links
- relates to
-
MDEV-13942 Potential InnoDB SPATIAL INDEX corruption during root page split
- Closed