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

Server crashes on Windows in MYSQLparse upon creating a table partitioned by system_time with certain intervals

    XMLWordPrintable

Details

    Description

      Note: it only crashes on Windows for me, release and debug. Linux builds don't show any visible problems, neither debug, nor release, nor asan, nor valgrind.
      INTERVAL 3 YEAR is important here. INTERVAL 2 YEAR does not crash. INTERVAL 36 MONTH also does not crash.

      --source include/have_partition.inc
      CREATE OR REPLACE TABLE t1 (pk INT) WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 3 YEAR ( PARTITION p1 HISTORY, PARTITION pn CURRENT );
       
      # Cleanup
      DROP TABLE t1;
      

      10.3 afc56a509cc7d

      mysqld.exe!MYSQLparse()[sql_yacc.yy:5873]
      mysqld.exe!parse_sql()[sql_parse.cc:10011]
      mysqld.exe!mysql_unpack_partition()[sql_partition.cc:4194]
      mysqld.exe!open_table_from_share()[table.cc:3364]
      mysqld.exe!ha_create_table()[handler.cc:4911]
      mysqld.exe!rea_create_table()[unireg.cc:526]
      mysqld.exe!create_table_impl()[sql_table.cc:4995]
      mysqld.exe!mysql_create_table_no_lock()[sql_table.cc:5108]
      mysqld.exe!mysql_create_table()[sql_table.cc:5186]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:4257]
      mysqld.exe!mysql_parse()[sql_parse.cc:7980]
      mysqld.exe!dispatch_command()[sql_parse.cc:1827]
      mysqld.exe!do_command()[sql_parse.cc:1369]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
      mysqld.exe!tp_callback()[threadpool_common.cc:186]
      mysqld.exe!tp_callback()[threadpool_win.cc:378]
      mysqld.exe!work_callback()[threadpool_win.cc:452]
      ntdll.dll!TpPostWork()
      ntdll.dll!RtlRealSuccessor()
      kernel32.dll!BaseThreadInitThunk()
      ntdll.dll!RtlUserThreadStart()
      

      Attachments

        1. Capture.PNG
          124 kB
          Aleksey Midenkov

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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