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

[draft] Assertion `min <= max' failed in translog_sync_files; Assertion `i + (8U*1024) <= buffer->size' failed in translog_buffer_flush; Assertion `log_descriptor.bc.buffer->prev_last_lsn == ((LSN)0)' failed in translog_flush_buffers

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL)
    • None
    • Storage Engine - Aria
    • None

    Description

      10.4 e80bcd7f64fc8ff6f46c1

      /10.4/storage/maria/ma_loghandler.c:7869: translog_sync_files: Assertion `min <= max' failed.
       
      stdlib/abort.c:91(__GI_abort)[0x7fa5ecc4002a]
      assert/assert.c:92(__assert_fail_base)[0x7fa5ecc36bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fa5ecc36c82]
      maria/ma_loghandler.c:7871(translog_sync_files)[0x564c2047b421]
      maria/ma_loghandler.c:8194(translog_flush)[0x564c2047cc36]
      maria/ma_bitmap.c:3113(flush_log_for_bitmap)[0x564c20563d4f]
      maria/ma_pagecache.c:660(pagecache_fwrite)[0x564c20483172]
      maria/ma_pagecache.c:4420(flush_cached_blocks)[0x564c2049efa8]
      maria/ma_pagecache.c:4716(flush_pagecache_blocks_int)[0x564c204a0433]
      maria/ma_pagecache.c:4831(flush_pagecache_blocks_with_filter)[0x564c204a0c3f]
      maria/ma_blockrec.c:451(_ma_once_end_block_record)[0x564c2052595d]
      maria/ma_close.c:109(maria_close)[0x564c205893ff]
      maria/ha_maria.cc:1311(ha_maria::close())[0x564c2042d241]
      sql/handler.cc:2963(handler::ha_close())[0x564c1ff2717b]
      sql/table.cc:3620(closefrm(TABLE*))[0x564c1fa7b839]
      sql/table_cache.cc:223(intern_close_table(TABLE*))[0x564c1fd1b8a3]
      sql/table_cache.cc:334(tc_purge(bool))[0x564c1fd1bf23]
      sql/sql_base.cc:337(purge_tables(bool))[0x564c1f6778a1]
      sql/sql_base.cc:365(close_cached_tables(THD*, TABLE_LIST*, bool, unsigned long))[0x564c1f677a60]
      sql/sql_reload.cc:339(reload_acl_and_cache(THD*, unsigned long long, TABLE_LIST*, int*))[0x564c1fb97039]
      sql/sql_parse.cc:5668(mysql_execute_command(THD*))[0x564c1f7ebf13]
      sql/sql_parse.cc:8120(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x564c1f7fb014]
      sql/sql_parse.cc:1808(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564c1f7d3ca9]
      sql/sql_parse.cc:1356(do_command(THD*))[0x564c1f7d0e13]
      sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x564c1fb2e950]
      sql/sql_connect.cc:1303(handle_one_connection)[0x564c1fb2e31a]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fa5eda7f6ba]
      x86_64/clone.S:111(clone)[0x7fa5ecd1041d]
       
      Query (0x62b0001b2288): FLUSH TABLES 
      

      /10.4/storage/maria/ma_loghandler.c:2670: translog_buffer_flush: Assertion `i + (8U*1024) <= buffer->size' failed.
       
      stdlib/abort.c:91(__GI_abort)[0x7f04ad99602a]
      assert/assert.c:92(__assert_fail_base)[0x7f04ad98cbd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f04ad98cc82]
      maria/ma_loghandler.c:2671(translog_buffer_flush)[0x55ed5c9be833]
      maria/ma_loghandler.c:8020(translog_flush_buffers)[0x55ed5c9de38c]
      maria/ma_loghandler.c:8139(translog_flush)[0x55ed5c9de91a]
      maria/ma_pagecrc.c:375(maria_flush_log_for_page)[0x55ed5ca20889]
      maria/ma_pagecache.c:660(pagecache_fwrite)[0x55ed5c9e5172]
      maria/ma_pagecache.c:4420(flush_cached_blocks)[0x55ed5ca00fa8]
      maria/ma_pagecache.c:4716(flush_pagecache_blocks_int)[0x55ed5ca02433]
      maria/ma_pagecache.c:4831(flush_pagecache_blocks_with_filter)[0x55ed5ca02c3f]
      maria/ma_extra.c:648(_ma_flush_table_files)[0x55ed5ca4cc38]
      maria/ma_extra.c:420(maria_extra)[0x55ed5ca4b641]
      maria/ha_maria.cc:2671(ha_maria::extra(ha_extra_function))[0x55ed5c99a7e1]
      sql/sp.cc:1442(Sp_handler::sp_create_routine(THD*, sp_head const*) const)[0x55ed5c83d726]
      sql/sql_parse.cc:3008(mysql_create_routine(THD*, LEX*))[0x55ed5bd3cbb7]
      sql/sql_parse.cc:5912(mysql_execute_command(THD*))[0x55ed5bd4fa6d]
      sql/sql_parse.cc:8120(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55ed5bd5d014]
      sql/sql_parse.cc:1808(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55ed5bd35ca9]
      sql/sql_parse.cc:1356(do_command(THD*))[0x55ed5bd32e13]
      sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x55ed5c090950]
      sql/sql_connect.cc:1303(handle_one_connection)[0x55ed5c09031a]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f04ae7d56ba]
      x86_64/clone.S:111(clone)[0x7f04ada6641d]
       
      Query (0x62b0000d9288): CREATE PROCEDURE stored_proc_20950 () LANGUAGE SQL SELECT LASTVAL( seq9 ) 
      

      /10.4/storage/maria/ma_loghandler.c:7969: translog_flush_buffers: Assertion `log_descriptor.bc.buffer->prev_last_lsn == ((LSN)0)' failed.
       
      stdlib/abort.c:91(__GI_abort)[0x7f680e27902a]
      assert/assert.c:92(__assert_fail_base)[0x7f680e26fbd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f680e26fc82]
      maria/ma_loghandler.c:7970(translog_flush_buffers)[0x55b9f1ab6b2b]
      maria/ma_loghandler.c:8139(translog_flush)[0x55b9f1ab791a]
      maria/ma_commit.c:65(ma_commit)[0x55b9f1af7a13]
      maria/ha_maria.cc:2973(ha_maria::implicit_commit(THD*, bool))[0x55b9f1a74f56]
      sql/handler.cc:1418(ha_commit_trans(THD*, bool))[0x55b9f15570bd]
      sql/transaction.cc:513(trans_commit_stmt(THD*))[0x55b9f1198bab]
      sql/sql_parse.cc:6367(mysql_execute_command(THD*))[0x55b9f0e2be2f]
      sql/sql_parse.cc:8120(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b9f0e36014]
      sql/sql_parse.cc:1911(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b9f0e0f804]
      sql/sql_parse.cc:1356(do_command(THD*))[0x55b9f0e0be13]
      sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x55b9f1169950]
      sql/sql_connect.cc:1303(handle_one_connection)[0x55b9f116931a]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f680f0b86ba]
      x86_64/clone.S:111(clone)[0x7f680e34941d]
      

      Attachments

        1. 1.7z
          4.25 MB
        2. 2.7z
          4.58 MB

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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