[MDEV-16093] Assertion `global_status_var.global_memory_used == 0' failed or bytes lost after inserting into table with non-null blob and trigger Created: 2018-05-04  Updated: 2018-06-19  Resolved: 2018-05-26

Status: Closed
Project: MariaDB Server
Component/s: Triggers
Affects Version/s: 10.1, 10.2, 10.3
Fix Version/s: 10.1.34, 10.2.16, 10.3.8

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-13722 Bytes lost or Assertion `global_statu... Closed

 Description    

CREATE TABLE t1 (b BLOB NOT NULL);
 
CREATE TRIGGER tr BEFORE UPDATE ON t1 FOR EACH ROW BEGIN END;
 
INSERT INTO t1 VALUES ( 'foo');
 
 
 
# Cleanup
 
DROP TABLE t1;

10.1 39d248fa55

 
Warning:    8 bytes lost at 0x7f1ecf820570, allocated by T@0 at 0x55dd506c46d7, 0x55dd5055ffbf, 0x55dd5083915c, 0x55dd5086664f, 0x55dd50875266, sql/sql_string.cc:46, sql/sql_string.h:326, sql/field.cc:7992
 
Memory lost: 8 bytes in 1 chunks

10.2 da3c5c3c9a

 
2018-05-05  2:25:22 140564761794304 [Note] /data/bld/10.2/bin/mysqld: Shutdown complete
 
 
 
mysqld: /data/src/10.2/sql/mysqld.cc:2174: void mysqld_exit(int): Assertion `global_status_var.global_memory_used == 0' failed.
 
180505  2:25:22 [ERROR] mysqld got signal 6 ;

ASAN didn't show anything different.

 Comments   
Comment by Michael Widenius [ 2018-05-24 ]

Problem was that blob memory allocated in Table_trigger_list was not
properly freed

Comment by Michael Widenius [ 2018-05-26 ]

Testing and pushing

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