Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30856

Reproducible crash when inserting data into a table on 10.6




      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


        Issue Links



              vlad.lesin Vladislav Lesin
              jimmyo Jimmy Olsen
              1 Vote for this issue
              6 Start watching this issue



                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.