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

[Draft] Assertion failed: 0 in field.cc, store_lowendian() called by Field_enum::store_type() called by Field_set::store() called by Column_stat::get_stat_values() on INSERT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • N/A
    • OTHER
    • None

    Description

      Assertion failed: 0, file field.cc, line 4779
      R6010
      - abort() has been called
       
      [ERROR] mysqld got exception 0x80000003 ;
      ...
      Server version: 10.0.0-MariaDB-debug-log
      key_buffer_size=1048576
      read_buffer_size=131072
      max_used_connections=9
      max_threads=501
      thread_count=8
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 195304 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x0x162fdc80
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      mysqld.exe!my_sigabrt_handler()[my_thr_init.c:504]
      mysqld.exe!raise()[winsig.c:593]
      mysqld.exe!abort()[abort.c:81]
      mysqld.exe!_wassert()[assert.c:336]
      mysqld.exe!store_lowendian()[field.cc:4779]
      mysqld.exe!Field_enum::store_type()[field.cc:7646]
      mysqld.exe!Field_set::store()[field.cc:7870]
      mysqld.exe!Column_stat::get_stat_values()[sql_statistics.cc:1013]
      mysqld.exe!read_statistics_for_table()[sql_statistics.cc:2380]
      mysqld.exe!read_statistics_for_tables_if_needed()[sql_statistics.cc:2571]
      mysqld.exe!open_and_lock_tables()[sql_base.cc:5615]
      mysqld.exe!open_and_lock_tables()[sql_base.h:501]
      mysqld.exe!mysql_insert()[sql_insert.cc:729]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3054]
      mysqld.exe!mysql_parse()[sql_parse.cc:5874]
      mysqld.exe!dispatch_command()[sql_parse.cc:1075]
      mysqld.exe!do_command()[sql_parse.cc:811]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:225]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
      KERNEL32.DLL!GetThreadInformation()
      ntdll.dll!RtlpUnWaitCriticalSection()
      ntdll.dll!RtlCompareUnicodeString()
      KERNEL32.DLL!BaseThreadInitThunk()
      ntdll.dll!RtlUserThreadStart()

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x15e71798): INSERT INTO `table10_aria` ( `pk` ) VALUES ( NULL )
      Connection ID (thread ID): 15
      Status: NOT_KILLED
       
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off

      10.0-base Revno: 3456
      10.0-base Revision-Id: igor@askmonty.org-20121220031551-p2jlpfxvagh4mlrw

      rqg-mariadb Revno: 1001
      mariadb-toolbox Revno: 78

      1st occasion:

      RQG command line: C:\elenst\rqg-mariadb/runall.pl --queries=100000000 --no-mask --seed=time --threads=6 --duration=400 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --redefine=c:/elenst/mariadb-toolbox/grammars/general-workarounds.yy --redefine=c:/elenst/mariadb-toolbox/grammars/mdev-3806-redefine.yy --mysqld=--use-stat-tables=preferably --views --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --engine=Aria --rpl_mode=row --mysqld=--slave-skip-errors=1049,1305,1539,1505 --mysqld=--log-output=FILE,TABLE --mtr-build-thread=300 --mask=38649 --basedir1=c:/elenst/10.0-base --vardir1=c:/elenst/test_results/mdev-3806-general-6/current1_1
       
      RQG seed: 1356112623
       
      Log location: C:\elenst\test_results\mdev-3806-general-6\vardir1_169

      2nd occasion:

      C:\elenst\rqg-mariadb/runall.pl --queries=100000000 --no-mask --seed=time --threads=6 --duration=400 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --redefine=c:/elenst/mariadb-toolbox/grammars/general-workarounds.yy --redefine=c:/elenst/mariadb-toolbox/grammars/mdev-3806-redefine.yy --mysqld=--use-stat-tables=preferably --views --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --engine=MyISAM --rpl_mode=statement --mysqld=--slave-skip-errors=1054,1317,1049,1305,1539,1505 --mysqld=--log-output=FILE --mtr-build-thread=300 --mask=48154 --basedir1=c:/elenst/10.0-base --vardir1=c:/elenst/test_results/mdev-3806-general-6/current1_1
       
      RQG seed: 1356111393
       
      Log location: C:\elenst\test_results\mdev-3806-general-6\vardir1_164

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.