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

InnoDB: Failing assertion: !memcmp(page, page_zip->data, PAGE_DATA)

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Assertion found while testing MDEV-37688

      origin/MDEV-37688 8bc468ba115af4100d0a5b12aea6d10e3a3e5327

      # 2025-12-03T06:10:14 [3741079] | 2025-12-03 06:10:00 0x1608052a5640  InnoDB: Assertion failure in file /data/Server/MDEV-37688/storage/innobase/page/page0zip.cc line 3032
      # 2025-12-03T06:10:14 [3741079] | InnoDB: Failing assertion: !memcmp(page, page_zip->data, PAGE_DATA)
      

      StackTrace

      # 2025-12-03T06:11:47 [3741079] | #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=24223702210112) at ./nptl/pthread_kill.c:44
      # 2025-12-03T06:11:47 [3741079] | #1  __pthread_kill_internal (signo=6, threadid=24223702210112) at ./nptl/pthread_kill.c:78
      # 2025-12-03T06:11:47 [3741079] | #2  __GI___pthread_kill (threadid=24223702210112, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      # 2025-12-03T06:11:47 [3741079] | #3  0x000013e245c41476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      # 2025-12-03T06:11:47 [3741079] | #4  0x000013e245c277f3 in __GI_abort () at ./stdlib/abort.c:79
      # 2025-12-03T06:11:47 [3741079] | #5  0x000056388c713185 in ut_dbg_assertion_failed (expr=expr@entry=0x56388cd955c0 "!memcmp(page, page_zip->data, PAGE_DATA)", file=file@entry=0x56388cd92a50 "/data/Server/MDEV-37688/storage/innobase/page/page0zip.cc", line=line@entry=3032) at /data/Server/MDEV-37688/storage/innobase/ut/ut0dbg.cc:60
      # 2025-12-03T06:11:47 [3741079] | #6  0x000056388c5bf50c in page_zip_decompress_low (page_zip=page_zip@entry=0xddc7cbe0578, page=page@entry=0xddc7ccff000 "\337\033H\372", all=all@entry=0) at /data/Server/MDEV-37688/storage/innobase/page/page0zip.cc:3032
      # 2025-12-03T06:11:47 [3741079] | #7  0x000056388c5bf82f in page_zip_decompress (page_zip=page_zip@entry=0xddc7cbe0578, page=page@entry=0xddc7ccff000 "\337\033H\372", all=all@entry=0) at /data/Server/MDEV-37688/storage/innobase/page/page0zip.cc:3197
      # 2025-12-03T06:11:47 [3741079] | #8  0x000056388c59b638 in page_cur_insert_rec_zip (cursor=cursor@entry=0x1608052a2e60, rec=rec@entry=0x211d44025448 "\200", offsets=0x1608052a2f30, mtr=mtr@entry=0x1608052a3190) at /data/Server/MDEV-37688/storage/innobase/page/page0cur.cc:1927
      # 2025-12-03T06:11:47 [3741079] | #9  0x000056388c7488db in page_cur_tuple_insert (cursor=cursor@entry=0x1608052a2e60, tuple=tuple@entry=0x211d440241c0, offsets=offsets@entry=0x1608052a2e50, heap=heap@entry=0x1608052a2e48, n_ext=<optimized out>, mtr=mtr@entry=0x1608052a3190) at /data/Server/MDEV-37688/storage/innobase/include/page0cur.inl:183
      # 2025-12-03T06:11:47 [3741079] | #10 0x000056388c7494ca in btr_cur_optimistic_insert (flags=flags@entry=0, cursor=cursor@entry=0x1608052a2e60, offsets=offsets@entry=0x1608052a2e50, heap=heap@entry=0x1608052a2e48, entry=entry@entry=0x211d440241c0, rec=rec@entry=0x1608052a2e58, big_rec=0x1608052a2e40, n_ext=<optimized out>, thr=0x211d4401f9e0, mtr=0x1608052a3190) at /data/Server/MDEV-37688/storage/innobase/btr/btr0cur.cc:2612
      # 2025-12-03T06:11:47 [3741079] | #11 0x000056388c61c8d2 in row_ins_clust_index_entry_low (flags=flags@entry=0, mode=mode@entry=BTR_MODIFY_LEAF, index=index@entry=0x2a0110035340, n_uniq=n_uniq@entry=1, entry=entry@entry=0x211d440241c0, n_ext=n_ext@entry=0, thr=0x211d4401f9e0) at /data/Server/MDEV-37688/storage/innobase/row/row0ins.cc:2878
      # 2025-12-03T06:11:47 [3741079] | #12 0x000056388c61cedb in row_ins_clust_index_entry (index=index@entry=0x2a0110035340, entry=entry@entry=0x211d440241c0, thr=thr@entry=0x211d4401f9e0, n_ext=n_ext@entry=0) at /data/Server/MDEV-37688/storage/innobase/row/row0ins.cc:3281
      # 2025-12-03T06:11:47 [3741079] | #13 0x000056388c61d246 in row_ins_index_entry (index=0x2a0110035340, entry=0x211d440241c0, thr=thr@entry=0x211d4401f9e0) at /data/Server/MDEV-37688/storage/innobase/row/row0ins.cc:3407
      # 2025-12-03T06:11:47 [3741079] | #14 0x000056388c61d521 in row_ins_index_entry_step (node=node@entry=0x211d4401f768, thr=thr@entry=0x211d4401f9e0) at /data/Server/MDEV-37688/storage/innobase/row/row0ins.cc:3573
      # 2025-12-03T06:11:47 [3741079] | #15 0x000056388c61df72 in row_ins (node=node@entry=0x211d4401f768, thr=thr@entry=0x211d4401f9e0) at /data/Server/MDEV-37688/storage/innobase/row/row0ins.cc:3698
      # 2025-12-03T06:11:47 [3741079] | #16 0x000056388c61e736 in row_ins_step (thr=thr@entry=0x211d4401f9e0) at /data/Server/MDEV-37688/storage/innobase/row/row0ins.cc:3827
      # 2025-12-03T06:11:47 [3741079] | #17 0x000056388c6442b8 in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x211d4401da08 "\376N\001", prebuilt=0x211d4401f290, ins_mode=<optimized out>) at /data/Server/MDEV-37688/storage/innobase/row/row0mysql.cc:1296
      # 2025-12-03T06:11:47 [3741079] | #18 0x000056388c4735c8 in ha_innobase::write_row (this=0x211d4401d208, record=0x211d4401da08 "\376N\001") at /data/Server/MDEV-37688/storage/innobase/handler/ha_innodb.cc:7846
      # 2025-12-03T06:11:47 [3741079] | #19 0x000056388c0e7340 in handler::ha_write_row (this=0x211d4401d208, buf=0x211d4401da08 "\376N\001") at /data/Server/MDEV-37688/sql/handler.cc:7776
      # 2025-12-03T06:11:47 [3741079] | #20 0x000056388bd98693 in write_record (thd=thd@entry=0x211d44000d58, table=table@entry=0x211d4401cd98, info=info@entry=0x1608052a3cb0, sink=sink@entry=0x0) at /data/Server/MDEV-37688/sql/sql_insert.cc:2310
      # 2025-12-03T06:11:47 [3741079] | #21 0x000056388bda077f in mysql_insert (thd=thd@entry=0x211d44000d58, table_list=0x211d440136d8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/Server/MDEV-37688/sql/sql_insert.cc:1170
      # 2025-12-03T06:11:47 [3741079] | #22 0x000056388bde3d53 in mysql_execute_command (thd=thd@entry=0x211d44000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-37688/sql/sql_parse.cc:4634
      # 2025-12-03T06:11:47 [3741079] | #23 0x000056388bde98c2 in mysql_parse (thd=thd@entry=0x211d44000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1608052a4390) at /data/Server/MDEV-37688/sql/sql_parse.cc:8200
      # 2025-12-03T06:11:47 [3741079] | #24 0x000056388bdebe5d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x211d44000d58, packet=packet@entry=0x211d4400af69 "\nINSERT INTO test.t_p (col1, col_text) VALUES ( 334, REPEAT(SUBSTR(CAST( 334 AS CHAR),1,1), @fill_amount) ) /* E_R Thread2 QNO 401 CON_ID 14 */ ", packet_length=packet_length@entry=144, blocking=blocking@entry=true) at /data/Server/MDEV-37688/sql/sql_parse.cc:1908
      # 2025-12-03T06:11:47 [3741079] | #25 0x000056388bdedd07 in do_command (thd=thd@entry=0x211d44000d58, blocking=blocking@entry=true) at /data/Server/MDEV-37688/sql/sql_parse.cc:1421
      # 2025-12-03T06:11:47 [3741079] | #26 0x000056388bf46160 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56388f4a2ad8, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-37688/sql/sql_connect.cc:1386
      # 2025-12-03T06:11:47 [3741079] | #27 0x000056388bf46395 in handle_one_connection (arg=0x56388f4a2ad8) at /data/Server/MDEV-37688/sql/sql_connect.cc:1298
      # 2025-12-03T06:11:47 [3741079] | #28 0x000013e245c93ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      # 2025-12-03T06:11:47 [3741079] | #29 0x000013e245d24a04 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RR trace is present on pluto:-
      /data/results/1764742187/TBR-2349

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              saahil Saahil Alam
              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.