[MDEV-31821] Server crashes in _ma_unpin_all_pages/_ma_search on UPDATE with Aria engine Created: 2023-08-01  Updated: 2023-08-01  Resolved: 2023-08-01

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 11.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: regression-11.1

Issue Links:
Duplicate
duplicates MDEV-31278 Server crashes in _ma_unpin_all_pages... Confirmed

 Description   

CREATE TABLE t1 ( id int, s date, e date, period FOR p (s, e), PRIMARY KEY (id, p WITHOUT OVERLAPS)) engine=aria;
INSERT INTO t1 VALUES (1,'1970-01-01','1970-01-02'),(2,'0000-00-00','2000-01-20');
 
UPDATE  IGNORE t1 SET s = 'a' ;

Server version: 11.1.2-MariaDB-debug-log source revision: adc13e2c167c90f4b287efa7b1165c68d441be8d
230801 17:26:36 [ERROR] mysqld got signal 11 ;
 
sql/signal_handler.cc:241(handle_fatal_signal)[0x556f08d589b8]
sigaction.c:0(__restore_rt)[0x7f96a7a02420]
maria/ma_key_recover.c:71(_ma_unpin_all_pages)[0x556f09385f79]
maria/ma_search.c:100(_ma_search)[0x556f0936dc22]
maria/ma_rkey.c:104(maria_rkey)[0x556f093696e4]
maria/ha_maria.cc:2524(ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x556f0929a449]
sql/handler.cc:3665(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x556f08d77df2]
sql/handler.cc:7647(handler::ha_check_overlaps(unsigned char const*, unsigned char const*))[0x556f08d9b3e3]
sql/handler.cc:7844(handler::ha_update_row(unsigned char const*, unsigned char const*))[0x556f08d9dc02]
sql/sql_update.cc:987(Sql_cmd_update::update_single_table(THD*))[0x556f087be851]
sql/sql_update.cc:3067(Sql_cmd_update::execute_inner(THD*))[0x556f087d3649]
sql/sql_select.cc:33356(Sql_cmd_dml::execute(THD*))[0x556f0861bda1]
sql/sql_parse.cc:4393(mysql_execute_command(THD*, bool))[0x556f08437c62]
sql/sql_parse.cc:7774(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556f0844f4d7]
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556f08427a5f]
sql/sql_parse.cc:1405(do_command(THD*, bool))[0x556f084247a9]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556f088f79a9]
sql/sql_connect.cc:1320(handle_one_connection)[0x556f088f7306]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556f09536cb8]
nptl/pthread_create.c:478(start_thread)[0x7f96a79f6609]
 
Query (0x62900004b2a8): UPDATE  IGNORE t1 SET s = 'a'


Generated at Thu Feb 08 10:26:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.