[#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

/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]

preview-10.9-MDEV-27021-explain b904307368298cc2fa2f
mysqld: /git/10.9/storage/maria/ma_loghandler.c:2673: translog_buffer_flush: Assertion `i + (8U*1024) <= buffer->size' failed.
220413 13:10:27 [ERROR] mysqld got signal 6 ;

Server version: 10.9.0-MariaDB-debug-log

sql/signal_handler.cc:226(handle_fatal_signal)[0x5632b340dce3]
??:0(__restore_rt)[0x7f79beea6730]
linux/raise.c:51(__GI_raise)[0x7f79be9e37bb]
stdlib/abort.c:81(__GI_abort)[0x7f79be9ce535]
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f79be9ce40f]
??:0(__assert_fail)[0x7f79be9dc102]
maria/ma_loghandler.c:2674(translog_buffer_flush)[0x5632b3a1d2af]
maria/ma_loghandler.c:8058(translog_flush_buffers)[0x5632b3a42748]
maria/ma_loghandler.c:8177(translog_flush)[0x5632b3a42e4b]
maria/ma_pagecrc.c:375(maria_flush_log_for_page)[0x5632b3a8c0b8]
maria/ma_pagecache.c:675(pagecache_fwrite)[0x5632b3a4a779]
maria/ma_pagecache.c:4819(flush_cached_blocks)[0x5632b3a6a148]
maria/ma_pagecache.c:5115(flush_pagecache_blocks_int)[0x5632b3a6b946]
maria/ma_pagecache.c:5230(flush_pagecache_blocks_with_filter)[0x5632b3a6c31f]
maria/ma_extra.c:656(_ma_flush_table_files)[0x5632b3ab84e0]
maria/ma_extra.c:427(maria_extra)[0x5632b3ab6e12]
maria/ha_maria.cc:2712(ha_maria::extra(ha_extra_function))[0x5632b39f5248]
sql/sp.cc:1461(Sp_handler::sp_create_routine(THD, sp_head const) const)[0x5632b3847e22]
sql/sql_parse.cc:3089(mysql_create_routine(THD, LEX))[0x5632b2b6fccf]
sql/sql_parse.cc:5707(mysql_execute_command(THD*, bool))[0x5632b2b829ec]
sql/sql_parse.cc:8030(mysql_parse(THD, char, unsigned int, Parser_state*))[0x5632b2b91d7b]
sql/sql_parse.cc:1897(dispatch_command(enum_server_command, THD, char, unsigned int, bool))[0x5632b2b68608]
sql/sql_parse.cc:1403(do_command(THD*, bool))[0x5632b2b652fd]
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x5632b2ff8722]
sql/sql_connect.cc:1314(handle_one_connection)[0x5632b2ff7fa7]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5632b3c7a421]
nptl/pthread_create.c:487(start_thread)[0x7f79bee9bfa3]
x86_64/clone.S:97(clone)[0x7f79beaa4eff]

Query (0x6290004c92a8): CREATE PROCEDURE stored_proc_33782 () LANGUAGE SQL /* QNO 2051 CON_ID 13 `app_periods_t14` `e` e */ SELECT JSON_NORMALIZE( LOAD_FILE('/d1/git/randgen/data/blobs/02.json') ) AS fld FROM app_periods_t14 LIMIT 4

mysqld: /11.0/storage/maria/ma_loghandler.c:7909: translog_sync_files: Assertion `min <= max' failed.

230328  8:41:13 [ERROR] mysqld got signal 6 ;

Server version: 11.0.1-MariaDB-debug-log source revision: e599b8b45867cd24720a9ecd4ba28500f579c5a4

??:0(__assert_fail)[0x7fd9d8bf71a2]

maria/ma_loghandler.c:7911(translog_sync_files)[0x55802257d7a9]

maria/ma_loghandler.c:8256(translog_flush)[0x55802257f413]

maria/ma_bitmap.c:3122(flush_log_for_bitmap)[0x55802267d5a0]

maria/ma_pagecache.c:676(pagecache_fwrite)[0x5580225869c4]

maria/ma_pagecache.c:4825(flush_cached_blocks)[0x5580225a8d18]

maria/ma_pagecache.c:5121(flush_pagecache_blocks_int)[0x5580225aa516]

maria/ma_pagecache.c:5236(flush_pagecache_blocks_with_filter)[0x5580225aaf2f]

maria/ma_bitmap.c:555(_ma_bitmap_flush_all)[0x55802266ead5]

maria/ma_recovery.c:3608(_ma_tmp_disable_logging_for_table)[0x5580225c7153]

maria/ha_maria.cc:2312(ha_maria::start_bulk_insert(unsigned long long, unsigned int))[0x55802252c2b5]

sql/handler.h:3517(handler::ha_start_bulk_insert(unsigned long long, unsigned int))[0x5580215e15b3]

sql/sql_load.cc:659(mysql_load(THD*, sql_exchange const*, TABLE_LIST*, List<Item>&, List<Item>&, List<Item>&, enum_duplicates, bool, bool))[0x558021658999]

sql/sql_parse.cc:5027(mysql_execute_command(THD*, bool))[0x55802168879f]

sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55802169c393]

sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x558021672c81]

sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55802166f98a]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x558021b28416]

sql/sql_connect.cc:1320(handle_one_connection)[0x558021b27d6c]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5580227bd249]

nptl/pthread_create.c:487(start_thread)[0x7fd9d90b6fa3]

x86_64/clone.S:97(clone)[0x7fd9d8cc006f]

Query (0x6290005192a8): LOAD   DATA INFILE 'load_table10_aria_int_2' IGNORE INTO TABLE table10_aria_int

[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 Created: 2019-02-07 Updated: 2023-03-28
Status:	Open
Project:	MariaDB Server
Component/s:	Storage Engine - Aria
Affects Version/s:	10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 11.0
Fix Version/s:	None

[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 Created: 2019-02-07 Updated: 2023-03-28