Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17841 S3 Storage engine
  3. MDEV-19575

Assertion `page_st == 1' failed upon SELECT from S3 table which is being converted into Aria

    XMLWordPrintable

Details

    Description

      Note: it fails for me every time, but it's still a concurrent non-deterministic test case, run with --repeat if it doesn't fail for you right away.

      CREATE TABLE t1 (f INT);
      ALTER TABLE t1 ENGINE=S3;
       
      --connect (con1,localhost,root,,test)
      --send
        ALTER TABLE t1 ENGINE=Aria;
       
      --connection default
      SELECT * FROM t1;
       
      # Cleanup
      --connection con1
      --reap
      --disconnect con1
      --connection default
      DROP TABLE t1;
      

      10.5 ebfe8c4e

      mysqld: /data/src/10.5/storage/maria/ma_pagecache.c:3698: pagecache_read: Assertion `page_st == 1' failed.
      190523 21:49:27 [ERROR] mysqld got signal 6 ;
       
      #5  0x00007f1b5b11142a in __GI_abort () at abort.c:89
      #6  0x00007f1b5b108e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55cea2e07a04 "page_st == 1", file=file@entry=0x55cea2e06118 "/data/src/10.5/storage/maria/ma_pagecache.c", line=line@entry=3698, function=function@entry=0x55cea2e08778 <__PRETTY_FUNCTION__.16148> "pagecache_read") at assert.c:92
      #7  0x00007f1b5b108f12 in __GI___assert_fail (assertion=0x55cea2e07a04 "page_st == 1", file=0x55cea2e06118 "/data/src/10.5/storage/maria/ma_pagecache.c", line=3698, function=0x55cea2e08778 <__PRETTY_FUNCTION__.16148> "pagecache_read") at assert.c:101
      #8  0x000055cea281842d in pagecache_read (pagecache=0x55cea3fa1400 <s3_pagecache>, file=0x7f1b3011b1f8, pageno=0, level=0, buff=0x7f1b2c05fe60 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7f1b4d6fa7a0) at /data/src/10.5/storage/maria/ma_pagecache.c:3698
      #9  0x000055cea285a96e in _ma_scan_block_record (info=0x7f1b2c11ef00, record=0x7f1b2c1abfc0 "\377", record_pos=0, skip_deleted=1 '\001') at /data/src/10.5/storage/maria/ma_blockrec.c:5568
      #10 0x000055cea2846e8a in maria_scan (info=0x7f1b2c11ef00, record=0x7f1b2c1abfc0 "\377") at /data/src/10.5/storage/maria/ma_scan.c:54
      #11 0x000055cea27ed47d in ha_maria::rnd_next (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377") at /data/src/10.5/storage/maria/ha_maria.cc:2541
      #12 0x000055cea21f69d9 in handler::ha_rnd_next (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377") at /data/src/10.5/sql/handler.cc:2803
      #13 0x000055cea21f8489 in handler::read_first_row (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377", primary_key=64) at /data/src/10.5/sql/handler.cc:3047
      #14 0x000055cea1f4dcbd in handler::ha_read_first_row (this=0x7f1b2c1ac418, buf=0x7f1b2c1abfc0 "\377", primary_key=64) at /data/src/10.5/sql/sql_class.h:6556
      #15 0x000055cea1f345b7 in join_read_system (tab=0x7f1b2c0152c0) at /data/src/10.5/sql/sql_select.cc:20568
      #16 0x000055cea1f3413c in join_read_const_table (thd=0x7f1b2c000b10, tab=0x7f1b2c0152c0, pos=0x7f1b2c015890) at /data/src/10.5/sql/sql_select.cc:20464
      #17 0x000055cea1f0b77c in make_join_statistics (join=0x7f1b2c014a00, tables_list=..., keyuse_array=0x7f1b2c014cf0) at /data/src/10.5/sql/sql_select.cc:5020
      #18 0x000055cea1f017fa in JOIN::optimize_inner (this=0x7f1b2c014a00) at /data/src/10.5/sql/sql_select.cc:2191
      #19 0x000055cea1eff46a in JOIN::optimize (this=0x7f1b2c014a00) at /data/src/10.5/sql/sql_select.cc:1561
      #20 0x000055cea1f0a260 in mysql_select (thd=0x7f1b2c000b10, tables=0x7f1b2c0139d0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f1b2c0149d8, unit=0x7f1b2c004a38, select_lex=0x7f1b2c013410) at /data/src/10.5/sql/sql_select.cc:4589
      #21 0x000055cea1efa8f8 in handle_select (thd=0x7f1b2c000b10, lex=0x7f1b2c004970, result=0x7f1b2c0149d8, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:424
      #22 0x000055cea1ec42f7 in execute_sqlcom_select (thd=0x7f1b2c000b10, all_tables=0x7f1b2c0139d0) at /data/src/10.5/sql/sql_parse.cc:6600
      #23 0x000055cea1eb9558 in mysql_execute_command (thd=0x7f1b2c000b10) at /data/src/10.5/sql/sql_parse.cc:3887
      #24 0x000055cea1ec808b in mysql_parse (thd=0x7f1b2c000b10, rawbuf=0x7f1b2c013388 "SELECT * FROM t1", length=16, parser_state=0x7f1b4d6fc180, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8152
      #25 0x000055cea1eb3715 in dispatch_command (command=COM_QUERY, thd=0x7f1b2c000b10, packet=0x7f1b2c008321 "SELECT * FROM t1", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1829
      #26 0x000055cea1eb1ed5 in do_command (thd=0x7f1b2c000b10) at /data/src/10.5/sql/sql_parse.cc:1362
      #27 0x000055cea2029e5b in do_handle_one_connection (connect=0x55cea4ec1e80, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1413
      #28 0x000055cea2029b9f in handle_one_connection (arg=0x55cea4ec1e80) at /data/src/10.5/sql/sql_connect.cc:1309
      #29 0x000055cea295d953 in pfs_spawn_thread (arg=0x55cea4ec1ad0) at /data/src/10.5/storage/perfschema/pfs.cc:1862
      #30 0x00007f1b5d4e44a4 in start_thread (arg=0x7f1b4d6fd700) at pthread_create.c:456
      #31 0x00007f1b5b1c5d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              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.