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

System table in InnoDB format allowed in MariaDB could lead to crash

Details

    • 10.1.18

    Description

      Hi,

      After working on an upstream bug with a time_zone_name table created in InnoDB format, I figured out than trying to create them in InnoDB is forbidden in MySQL, but not in MariaDB.

      The original bugreport : http://bugs.mysql.com/bug.php?id=82910

      When I try to import the timezone.sql from this bugreport in MySQL, it's forbidden :

      MySQL 5.6.33 : 

      mysql mysql < timezone.sql
      		 
      ERROR 1726 (HY000) at line 72: Storage engine 'InnoDB' does not support system tables. [mysql.time_zone_name]

      However in MariaDB it works like a charm, and it leads to the crashes described in the bugreport, easily reproducible in MariaDB.

      It would be great to have the same check than in MySQL (since MariaDB also crashes with a time_zone_name table in InnoDB format).

      Thanks and regards,
      Jocelyn Fournier

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10957 Assertion failure when dropping a myisam table with wsrep_replicate_myisam enabled

          • Major - Major loss of function.
          • Closed

          Activity

            elenst Elena Stepanova added a comment -

            Thanks for the report.
            I agree the check would be nice, but as it was correctly noted in http://bugs.mysql.com/bug.php?id=82910, it's not enough, because the table could come as InnoDB from previous versions, where it was allowed. mysql_upgrade does not check that, and upon using the table the crash still occurs (and debug build of MySQL 5.6 keeps crashing on startup if this table is InnoDB).
            So, for a more reasonable fix, not only a check for creating the table is required, but also mysql_upgrade should fix it (or, instead of crashing a query which triggers the usage of the "bad" table should produce an error).

            MTR-like test case:

            --source include/have_innodb.inc
            		 
             
            		 
            alter table mysql.time_zone_name engine=InnoDB;
            		 
             
            		 
            DROP TABLE IF EXISTS envois3;
            		 
            CREATE TABLE `envois3` (
            		 
              `starttime` datetime NOT NULL
            		 
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
            		 
             
            		 
            INSERT INTO envois3 VALUES ('2008-08-11 22:43:00');
            		 
             
            		 
            --source include/restart_mysqld.inc
            		 
             
            		 
            SELECT CONVERT_TZ(starttime,'SYSTEM','Europe/Lisbon') starttime FROM envois3;

            Stack trace from 10.0 6c74ef8ae9 debug build

            		 
            2016-09-09 14:52:00 7fb2a4c7d700  InnoDB: Assertion failure in thread 140405245466368 in file lock0lock.cc line 4216
            		 
            InnoDB: Failing assertion: (trx)->in_ro_trx_list == (trx)->read_only
            		 
            ...
            		 
            #5  0x00007fb2a29c9448 in __GI_abort () at abort.c:89
            		 
            #6  0x00007fb29b39c545 in lock_table_create (table=0x7fb29c9d7ef8, type_mode=0, trx=0x7fb28fa51a78) at /data/src/10.0/storage/innobase/lock/lock0lock.cc:4216
            		 
            #7  0x00007fb29b39d411 in lock_table (flags=0, table=0x7fb29c9d7ef8, mode=LOCK_IS, thr=0x7fb28fa89708) at /data/src/10.0/storage/innobase/lock/lock0lock.cc:4585
            		 
            #8  0x00007fb29b4669a0 in row_search_for_mysql (buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., mode=2, prebuilt=0x7fb28fa89078, match_mode=1, direction=0) at /data/src/10.0/storage/innobase/row/row0sel.cc:4097
            		 
            #9  0x00007fb29b348d28 in ha_innodb::index_read (this=0x7fb28f874888, buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., key_ptr=0x7fb28f81e489 "Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245\377"..., key_len=192, find_flag=HA_READ_KEY_EXACT) at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:8116
            		 
            #10 0x00007fb29b359672 in handler::index_read_map (this=0x7fb28f874888, buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., key=0x7fb28f81e489 "Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245\377"..., keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT) at /data/src/10.0/sql/handler.h:2928
            		 
            #11 0x000000000083752d in handler::ha_index_read_map (this=0x7fb28f874888, buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., key=0x7fb28f81e489 "Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245\377"..., keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT) at /data/src/10.0/sql/handler.cc:2642
            		 
            #12 0x00000000007359c6 in tz_load_from_open_tables (tz_name=0x7fb28f8f83f8, tz_tables=0x7fb2a4c79c10) at /data/src/10.0/sql/tztime.cc:1903
            		 
            #13 0x0000000000736b9c in my_tz_find (thd=0x7fb29ca2e070, name=0x7fb28f8f83f8) at /data/src/10.0/sql/tztime.cc:2347
            		 
            #14 0x00000000008f24ed in Item_func_convert_tz::get_date (this=0x7fb28f8f84e0, ltime=0x7fb2a4c7ae90, fuzzy_date=0) at /data/src/10.0/sql/item_timefunc.cc:2029
            		 
            #15 0x0000000000854485 in Item::send (this=0x7fb28f8f84e0, protocol=0x7fb29ca2e5f8, buffer=0x7fb2a4c7af40) at /data/src/10.0/sql/item.cc:6574
            		 
            #16 0x000000000059f1d8 in Protocol::send_result_set_row (this=0x7fb29ca2e5f8, row_items=0x7fb29ca32218) at /data/src/10.0/sql/protocol.cc:912
            		 
            #17 0x000000000060d779 in select_send::send_data (this=0x7fb28f8f8ce0, items=...) at /data/src/10.0/sql/sql_class.cc:2573
            		 
            #18 0x00000000006a9d2b in end_send (join=0x7fb28f8f8d00, join_tab=0x7fb28f8f9fe8, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18972
            		 
            #19 0x00000000006a7ab4 in evaluate_join_record (join=0x7fb28f8f8d00, join_tab=0x7fb28f8f9cc0, error=0) at /data/src/10.0/sql/sql_select.cc:18065
            		 
            #20 0x00000000006a73d6 in sub_select (join=0x7fb28f8f8d00, join_tab=0x7fb28f8f9cc0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17843
            		 
            #21 0x00000000006a6c49 in do_select (join=0x7fb28f8f8d00, fields=0x7fb29ca32218, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17505
            		 
            #22 0x0000000000683d40 in JOIN::exec_inner (this=0x7fb28f8f8d00) at /data/src/10.0/sql/sql_select.cc:3084
            		 
            #23 0x0000000000681216 in JOIN::exec (this=0x7fb28f8f8d00) at /data/src/10.0/sql/sql_select.cc:2373
            		 
            #24 0x000000000068457e in mysql_select (thd=0x7fb29ca2e070, rref_pointer_array=0x7fb29ca32378, tables=0x7fb28f8f8648, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb28f8f8ce0, unit=0x7fb29ca31a10, select_lex=0x7fb29ca32100) at /data/src/10.0/sql/sql_select.cc:3308
            		 
            #25 0x000000000067a93a in handle_select (thd=0x7fb29ca2e070, lex=0x7fb29ca31948, result=0x7fb28f8f8ce0, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:373
            		 
            #26 0x000000000064f197 in execute_sqlcom_select (thd=0x7fb29ca2e070, all_tables=0x7fb28f8f8648) at /data/src/10.0/sql/sql_parse.cc:5294
            		 
            #27 0x00000000006476c2 in mysql_execute_command (thd=0x7fb29ca2e070) at /data/src/10.0/sql/sql_parse.cc:2563
            		 
            #28 0x0000000000651e18 in mysql_parse (thd=0x7fb29ca2e070, rawbuf=0x7fb28f8f8088 "SELECT CONVERT_TZ(starttime,'SYSTEM','Europe/Lisbon') starttime FROM envois3", length=76, parser_state=0x7fb2a4c7c650) at /data/src/10.0/sql/sql_parse.cc:6576
            		 
            #29 0x0000000000644918 in dispatch_command (command=COM_QUERY, thd=0x7fb29ca2e070, packet=0x7fb296f54071 "", packet_length=76) at /data/src/10.0/sql/sql_parse.cc:1309
            		 
            #30 0x0000000000643bdb in do_command (thd=0x7fb29ca2e070) at /data/src/10.0/sql/sql_parse.cc:999
            		 
            #31 0x0000000000761efa in do_handle_one_connection (thd_arg=0x7fb29ca2e070) at /data/src/10.0/sql/sql_connect.cc:1378
            		 
            #32 0x0000000000761c6c in handle_one_connection (arg=0x7fb29ca2e070) at /data/src/10.0/sql/sql_connect.cc:1293
            		 
            #33 0x00000000009faa88 in pfs_spawn_thread (arg=0x7fb296ee3670) at /data/src/10.0/storage/perfschema/pfs.cc:1860
            		 
            #34 0x00007fb2a48c30a4 in start_thread (arg=0x7fb2a4c7d700) at pthread_create.c:309
            		 
            #35 0x00007fb2a2a7b87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

            Stack trace from 10.1.16 release

            		 
            2016-09-09 15:00:46 7ff338b78b00  InnoDB: Assertion failure in thread 140682605333248 in file trx0trx.cc line 1202
            		 
            InnoDB: Failing assertion: UT_LIST_GET_LEN(trx->lock.trx_locks) == 0
            		 
            ...
            		 
            #4  0x00007ff33640f448 in __GI_abort () at abort.c:89
            		 
            #5  0x00007ff32f931a4e in trx_commit_in_memory (trx=trx@entry=0x7ff32153fa68, lsn=0) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1202
            		 
            #6  0x00007ff32f9321d3 in trx_commit_low (mtr=0x0, trx=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1429
            		 
            #7  trx_commit (trx=trx@entry=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1450
            		 
            #8  0x00007ff32f932872 in trx_commit_for_mysql (trx=trx@entry=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1672
            		 
            #9  0x00007ff32f823a78 in innobase_commit_low (trx=trx@entry=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:4082
            		 
            #10 0x00007ff32f8277d1 in innobase_commit_ordered_2 (trx=trx@entry=0x7ff32153fa68, thd=thd@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:4186
            		 
            #11 0x00007ff32f82d931 in innobase_commit (hton=<optimized out>, thd=thd@entry=0x7ff32ca78008, commit_trx=commit_trx@entry=true) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:4298
            		 
            #12 0x00007ff32f82fab6 in ha_innodb::external_lock (this=0x7ff321627020, thd=0x7ff32ca78008, lock_type=<optimized out>) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:14867
            		 
            #13 0x00007ff337fe0726 in handler::ha_external_lock (this=0x7ff321627020, thd=thd@entry=0x7ff32ca78008, lock_type=lock_type@entry=2) at /home/buildbot/buildbot/build/sql/handler.cc:5807
            		 
            #14 0x00007ff33809087b in unlock_external (thd=0x7ff32ca78008, table=0x7ff3214c5c48, count=<optimized out>) at /home/buildbot/buildbot/build/sql/lock.cc:686
            		 
            #15 0x00007ff338090e2c in mysql_unlock_read_tables (thd=<optimized out>, sql_lock=0x7ff3214c5c20) at /home/buildbot/buildbot/build/sql/lock.cc:447
            		 
            #16 0x00007ff337ea7c3b in JOIN::join_free (this=this@entry=0x7ff3214c5c70) at /home/buildbot/buildbot/build/sql/sql_select.cc:11895
            		 
            #17 0x00007ff337ea7f8c in do_select (join=join@entry=0x7ff3214c5c70, fields=fields@entry=0x7ff32ca7c0f8, table=table@entry=0x0, procedure=0x0) at /home/buildbot/buildbot/build/sql/sql_select.cc:17999
            		 
            #18 0x00007ff337eb8c8e in JOIN::exec_inner (this=this@entry=0x7ff3214c5c70) at /home/buildbot/buildbot/build/sql/sql_select.cc:3228
            		 
            #19 0x00007ff337ebac0d in JOIN::exec (this=this@entry=0x7ff3214c5c70) at /home/buildbot/buildbot/build/sql/sql_select.cc:2518
            		 
            #20 0x00007ff337eb75fa in mysql_select (thd=thd@entry=0x7ff32ca78008, rref_pointer_array=rref_pointer_array@entry=0x7ff32ca7c258, tables=<optimized out>, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7ff3214c5c50, unit=unit@entry=0x7ff32ca7b8e0, select_lex=select_lex@entry=0x7ff32ca7bfe0) at /home/buildbot/buildbot/build/sql/sql_select.cc:3451
            		 
            #21 0x00007ff337ebaeed in handle_select (thd=thd@entry=0x7ff32ca78008, lex=lex@entry=0x7ff32ca7b818, result=result@entry=0x7ff3214c5c50, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:384
            		 
            #22 0x00007ff337e5ce72 in execute_sqlcom_select (thd=thd@entry=0x7ff32ca78008, all_tables=0x7ff3214c5588) at /home/buildbot/buildbot/build/sql/sql_parse.cc:5894
            		 
            #23 0x00007ff337e690ee in mysql_execute_command (thd=thd@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:2960
            		 
            #24 0x00007ff337e6c63d in mysql_parse (thd=0x7ff32ca78008, rawbuf=<optimized out>, length=<optimized out>, parser_state=0x7ff338b77600) at /home/buildbot/buildbot/build/sql/sql_parse.cc:7314
            		 
            #25 0x00007ff337e6f0f3 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7ff32ca78008, packet=0x7ff3214c5020 "SELECT CONVERT_TZ(starttime,'SYSTEM','Europe/Lisbon') starttime FROM envois3", packet_length=packet_length@entry=76) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1486
            		 
            #26 0x00007ff337e6f68b in do_command (thd=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1107
            		 
            #27 0x00007ff337f2ba0f in do_handle_one_connection (thd_arg=thd_arg@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1350
            		 
            #28 0x00007ff337f2bb67 in handle_one_connection (arg=arg@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1262
            		 
            #29 0x00007ff33836728d in pfs_spawn_thread (arg=0x7ff33582d808) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1860
            		 
            #30 0x00007ff336d980a4 in start_thread (arg=0x7ff338b78b00) at pthread_create.c:309
            		 
            #31 0x00007ff3364c187d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

            elenst Elena Stepanova added a comment - Thanks for the report. I agree the check would be nice, but as it was correctly noted in http://bugs.mysql.com/bug.php?id=82910 , it's not enough, because the table could come as InnoDB from previous versions, where it was allowed. mysql_upgrade does not check that, and upon using the table the crash still occurs (and debug build of MySQL 5.6 keeps crashing on startup if this table is InnoDB). So, for a more reasonable fix, not only a check for creating the table is required, but also mysql_upgrade should fix it (or, instead of crashing a query which triggers the usage of the "bad" table should produce an error). MTR-like test case: --source include/have_innodb.inc   alter table mysql.time_zone_name engine=InnoDB;   DROP TABLE IF EXISTS envois3; CREATE TABLE `envois3` ( `starttime` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;   INSERT INTO envois3 VALUES ( '2008-08-11 22:43:00' );   --source include/restart_mysqld.inc   SELECT CONVERT_TZ(starttime, 'SYSTEM' , 'Europe/Lisbon' ) starttime FROM envois3; Stack trace from 10.0 6c74ef8ae9 debug build 2016-09-09 14:52:00 7fb2a4c7d700 InnoDB: Assertion failure in thread 140405245466368 in file lock0lock.cc line 4216 InnoDB: Failing assertion: (trx)->in_ro_trx_list == (trx)->read_only ... #5 0x00007fb2a29c9448 in __GI_abort () at abort.c:89 #6 0x00007fb29b39c545 in lock_table_create (table=0x7fb29c9d7ef8, type_mode=0, trx=0x7fb28fa51a78) at /data/src/10.0/storage/innobase/lock/lock0lock.cc:4216 #7 0x00007fb29b39d411 in lock_table (flags=0, table=0x7fb29c9d7ef8, mode=LOCK_IS, thr=0x7fb28fa89708) at /data/src/10.0/storage/innobase/lock/lock0lock.cc:4585 #8 0x00007fb29b4669a0 in row_search_for_mysql (buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., mode=2, prebuilt=0x7fb28fa89078, match_mode=1, direction=0) at /data/src/10.0/storage/innobase/row/row0sel.cc:4097 #9 0x00007fb29b348d28 in ha_innodb::index_read (this=0x7fb28f874888, buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., key_ptr=0x7fb28f81e489 "Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245\377"..., key_len=192, find_flag=HA_READ_KEY_EXACT) at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:8116 #10 0x00007fb29b359672 in handler::index_read_map (this=0x7fb28f874888, buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., key=0x7fb28f81e489 "Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245\377"..., keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT) at /data/src/10.0/sql/handler.h:2928 #11 0x000000000083752d in handler::ha_index_read_map (this=0x7fb28f874888, buf=0x7fb28f81e488 "\377Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245"..., key=0x7fb28f81e489 "Europe/Lisbon", ' ' <repeats 179 times>, "\217\217\217\217\245\245\245\377"..., keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT) at /data/src/10.0/sql/handler.cc:2642 #12 0x00000000007359c6 in tz_load_from_open_tables (tz_name=0x7fb28f8f83f8, tz_tables=0x7fb2a4c79c10) at /data/src/10.0/sql/tztime.cc:1903 #13 0x0000000000736b9c in my_tz_find (thd=0x7fb29ca2e070, name=0x7fb28f8f83f8) at /data/src/10.0/sql/tztime.cc:2347 #14 0x00000000008f24ed in Item_func_convert_tz::get_date (this=0x7fb28f8f84e0, ltime=0x7fb2a4c7ae90, fuzzy_date=0) at /data/src/10.0/sql/item_timefunc.cc:2029 #15 0x0000000000854485 in Item::send (this=0x7fb28f8f84e0, protocol=0x7fb29ca2e5f8, buffer=0x7fb2a4c7af40) at /data/src/10.0/sql/item.cc:6574 #16 0x000000000059f1d8 in Protocol::send_result_set_row (this=0x7fb29ca2e5f8, row_items=0x7fb29ca32218) at /data/src/10.0/sql/protocol.cc:912 #17 0x000000000060d779 in select_send::send_data (this=0x7fb28f8f8ce0, items=...) at /data/src/10.0/sql/sql_class.cc:2573 #18 0x00000000006a9d2b in end_send (join=0x7fb28f8f8d00, join_tab=0x7fb28f8f9fe8, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18972 #19 0x00000000006a7ab4 in evaluate_join_record (join=0x7fb28f8f8d00, join_tab=0x7fb28f8f9cc0, error=0) at /data/src/10.0/sql/sql_select.cc:18065 #20 0x00000000006a73d6 in sub_select (join=0x7fb28f8f8d00, join_tab=0x7fb28f8f9cc0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17843 #21 0x00000000006a6c49 in do_select (join=0x7fb28f8f8d00, fields=0x7fb29ca32218, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17505 #22 0x0000000000683d40 in JOIN::exec_inner (this=0x7fb28f8f8d00) at /data/src/10.0/sql/sql_select.cc:3084 #23 0x0000000000681216 in JOIN::exec (this=0x7fb28f8f8d00) at /data/src/10.0/sql/sql_select.cc:2373 #24 0x000000000068457e in mysql_select (thd=0x7fb29ca2e070, rref_pointer_array=0x7fb29ca32378, tables=0x7fb28f8f8648, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb28f8f8ce0, unit=0x7fb29ca31a10, select_lex=0x7fb29ca32100) at /data/src/10.0/sql/sql_select.cc:3308 #25 0x000000000067a93a in handle_select (thd=0x7fb29ca2e070, lex=0x7fb29ca31948, result=0x7fb28f8f8ce0, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:373 #26 0x000000000064f197 in execute_sqlcom_select (thd=0x7fb29ca2e070, all_tables=0x7fb28f8f8648) at /data/src/10.0/sql/sql_parse.cc:5294 #27 0x00000000006476c2 in mysql_execute_command (thd=0x7fb29ca2e070) at /data/src/10.0/sql/sql_parse.cc:2563 #28 0x0000000000651e18 in mysql_parse (thd=0x7fb29ca2e070, rawbuf=0x7fb28f8f8088 "SELECT CONVERT_TZ(starttime,'SYSTEM','Europe/Lisbon') starttime FROM envois3", length=76, parser_state=0x7fb2a4c7c650) at /data/src/10.0/sql/sql_parse.cc:6576 #29 0x0000000000644918 in dispatch_command (command=COM_QUERY, thd=0x7fb29ca2e070, packet=0x7fb296f54071 "", packet_length=76) at /data/src/10.0/sql/sql_parse.cc:1309 #30 0x0000000000643bdb in do_command (thd=0x7fb29ca2e070) at /data/src/10.0/sql/sql_parse.cc:999 #31 0x0000000000761efa in do_handle_one_connection (thd_arg=0x7fb29ca2e070) at /data/src/10.0/sql/sql_connect.cc:1378 #32 0x0000000000761c6c in handle_one_connection (arg=0x7fb29ca2e070) at /data/src/10.0/sql/sql_connect.cc:1293 #33 0x00000000009faa88 in pfs_spawn_thread (arg=0x7fb296ee3670) at /data/src/10.0/storage/perfschema/pfs.cc:1860 #34 0x00007fb2a48c30a4 in start_thread (arg=0x7fb2a4c7d700) at pthread_create.c:309 #35 0x00007fb2a2a7b87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 Stack trace from 10.1.16 release 2016-09-09 15:00:46 7ff338b78b00 InnoDB: Assertion failure in thread 140682605333248 in file trx0trx.cc line 1202 InnoDB: Failing assertion: UT_LIST_GET_LEN(trx->lock.trx_locks) == 0 ... #4 0x00007ff33640f448 in __GI_abort () at abort.c:89 #5 0x00007ff32f931a4e in trx_commit_in_memory (trx=trx@entry=0x7ff32153fa68, lsn=0) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1202 #6 0x00007ff32f9321d3 in trx_commit_low (mtr=0x0, trx=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1429 #7 trx_commit (trx=trx@entry=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1450 #8 0x00007ff32f932872 in trx_commit_for_mysql (trx=trx@entry=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc:1672 #9 0x00007ff32f823a78 in innobase_commit_low (trx=trx@entry=0x7ff32153fa68) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:4082 #10 0x00007ff32f8277d1 in innobase_commit_ordered_2 (trx=trx@entry=0x7ff32153fa68, thd=thd@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:4186 #11 0x00007ff32f82d931 in innobase_commit (hton=<optimized out>, thd=thd@entry=0x7ff32ca78008, commit_trx=commit_trx@entry=true) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:4298 #12 0x00007ff32f82fab6 in ha_innodb::external_lock (this=0x7ff321627020, thd=0x7ff32ca78008, lock_type=<optimized out>) at /home/buildbot/buildbot/build/storage/innobase/handler/ha_innodb.cc:14867 #13 0x00007ff337fe0726 in handler::ha_external_lock (this=0x7ff321627020, thd=thd@entry=0x7ff32ca78008, lock_type=lock_type@entry=2) at /home/buildbot/buildbot/build/sql/handler.cc:5807 #14 0x00007ff33809087b in unlock_external (thd=0x7ff32ca78008, table=0x7ff3214c5c48, count=<optimized out>) at /home/buildbot/buildbot/build/sql/lock.cc:686 #15 0x00007ff338090e2c in mysql_unlock_read_tables (thd=<optimized out>, sql_lock=0x7ff3214c5c20) at /home/buildbot/buildbot/build/sql/lock.cc:447 #16 0x00007ff337ea7c3b in JOIN::join_free (this=this@entry=0x7ff3214c5c70) at /home/buildbot/buildbot/build/sql/sql_select.cc:11895 #17 0x00007ff337ea7f8c in do_select (join=join@entry=0x7ff3214c5c70, fields=fields@entry=0x7ff32ca7c0f8, table=table@entry=0x0, procedure=0x0) at /home/buildbot/buildbot/build/sql/sql_select.cc:17999 #18 0x00007ff337eb8c8e in JOIN::exec_inner (this=this@entry=0x7ff3214c5c70) at /home/buildbot/buildbot/build/sql/sql_select.cc:3228 #19 0x00007ff337ebac0d in JOIN::exec (this=this@entry=0x7ff3214c5c70) at /home/buildbot/buildbot/build/sql/sql_select.cc:2518 #20 0x00007ff337eb75fa in mysql_select (thd=thd@entry=0x7ff32ca78008, rref_pointer_array=rref_pointer_array@entry=0x7ff32ca7c258, tables=<optimized out>, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7ff3214c5c50, unit=unit@entry=0x7ff32ca7b8e0, select_lex=select_lex@entry=0x7ff32ca7bfe0) at /home/buildbot/buildbot/build/sql/sql_select.cc:3451 #21 0x00007ff337ebaeed in handle_select (thd=thd@entry=0x7ff32ca78008, lex=lex@entry=0x7ff32ca7b818, result=result@entry=0x7ff3214c5c50, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:384 #22 0x00007ff337e5ce72 in execute_sqlcom_select (thd=thd@entry=0x7ff32ca78008, all_tables=0x7ff3214c5588) at /home/buildbot/buildbot/build/sql/sql_parse.cc:5894 #23 0x00007ff337e690ee in mysql_execute_command (thd=thd@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:2960 #24 0x00007ff337e6c63d in mysql_parse (thd=0x7ff32ca78008, rawbuf=<optimized out>, length=<optimized out>, parser_state=0x7ff338b77600) at /home/buildbot/buildbot/build/sql/sql_parse.cc:7314 #25 0x00007ff337e6f0f3 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7ff32ca78008, packet=0x7ff3214c5020 "SELECT CONVERT_TZ(starttime,'SYSTEM','Europe/Lisbon') starttime FROM envois3", packet_length=packet_length@entry=76) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1486 #26 0x00007ff337e6f68b in do_command (thd=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1107 #27 0x00007ff337f2ba0f in do_handle_one_connection (thd_arg=thd_arg@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1350 #28 0x00007ff337f2bb67 in handle_one_connection (arg=arg@entry=0x7ff32ca78008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1262 #29 0x00007ff33836728d in pfs_spawn_thread (arg=0x7ff33582d808) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1860 #30 0x00007ff336d980a4 in start_thread (arg=0x7ff338b78b00) at pthread_create.c:309 #31 0x00007ff3364c187d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

            People

              serg Sergei Golubchik
              joce jocelyn fournier
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.