[MDEV-29317] Assertion `sp && savepoint_next && *sp && *sp <= savepoint_level' failed in federatedx_txn::sp_release Created: 2022-08-16  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29178 Assertion `sp > last_savepoint()' fai... Confirmed

 Description   

INSTALL SONAME 'ha_federatedx';
eval CREATE SERVER fedlink FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST '127.0.0.1', DATABASE 'test', PORT $MASTER_MYPORT);
 
CREATE TABLE t (id INT);
CREATE TABLE fed_t ENGINE=FEDERATED CONNECTION='fedlink/t';
INSERT INTO fed_t VALUES (1);
START TRANSACTION;
SELECT * FROM fed_t;
SAVEPOINT sp;
SAVEPOINT sp;
 
# Cleanup
DROP TABLE fed_t, t;

10.3 8c21dc52

mysqld: /data/src/10.3/storage/federatedx/federatedx_txn.cc:336: int federatedx_txn::sp_release(ulong*): Assertion `sp && savepoint_next && *sp && *sp <= savepoint_level' failed.
220816 19:45:57 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f9562db6662 in __GI___assert_fail (assertion=0x7f955cd8bc48 "sp && savepoint_next && *sp && *sp <= savepoint_level", file=0x7f955cd8b888 "/data/src/10.3/storage/federatedx/federatedx_txn.cc", line=336, function=0x7f955cd8bcc8 "int federatedx_txn::sp_release(ulong*)") at assert.c:101
#8  0x00007f955cd87029 in federatedx_txn::sp_release (this=0x7f954c146cf0, sp=0x7f954c018be0) at /data/src/10.3/storage/federatedx/federatedx_txn.cc:336
#9  0x00007f955cd830be in ha_federatedx::savepoint_release (hton=0x7f954c006ff0, thd=0x7f954c000d90, sv=0x7f954c018be0) at /data/src/10.3/storage/federatedx/ha_federatedx.cc:3559
#10 0x0000560e5b78131f in ha_release_savepoint (thd=0x7f954c000d90, sv=0x7f954c018b78) at /data/src/10.3/sql/handler.cc:2466
#11 0x0000560e5b5e5b96 in trans_savepoint (thd=0x7f954c000d90, name=...) at /data/src/10.3/sql/transaction.cc:631
#12 0x0000560e5b4603e9 in mysql_execute_command (thd=0x7f954c000d90) at /data/src/10.3/sql/sql_parse.cc:5675
#13 0x0000560e5b4671ea in mysql_parse (thd=0x7f954c000d90, rawbuf=0x7f954c012ad8 "SAVEPOINT sp", length=12, parser_state=0x7f955cddd5b0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7871
#14 0x0000560e5b453a1f in dispatch_command (command=COM_QUERY, thd=0x7f954c000d90, packet=0x7f954c008f31 "SAVEPOINT sp", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
#15 0x0000560e5b4523dd in do_command (thd=0x7f954c000d90) at /data/src/10.3/sql/sql_parse.cc:1398
#16 0x0000560e5b5cfe30 in do_handle_one_connection (connect=0x560e5e505170) at /data/src/10.3/sql/sql_connect.cc:1403
#17 0x0000560e5b5cfb9b in handle_one_connection (arg=0x560e5e505170) at /data/src/10.3/sql/sql_connect.cc:1308
#18 0x0000560e5bf80346 in pfs_spawn_thread (arg=0x560e5e605a40) at /data/src/10.3/storage/perfschema/pfs.cc:1869
#19 0x00007f9562f4fea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#20 0x00007f9562e7fdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Likely related to MDEV-29178.


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