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

Reproducible crash when inserting data into a table on 10.6

    XMLWordPrintable

Details

    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

        1. gdb.txt.gz
          14 kB
          Jimmy Olsen
        2. mariadb.cnf
          2 kB
          Jimmy Olsen

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

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