Assertion `lock_type != TL_UNLOCK && (lock_type == TL_IGNORE || file->lock.type == TL_UNLOCK)' failed in ha_maria::store_lock with DML, triggers, views
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Michael Widenius |
Bug Description
Version: '5.3.5-
mysqld: ha_maria.cc:2872: virtual THR_LOCK_DATA** ha_maria:
120324 4:06:06 [ERROR] mysqld got signal 6 ;
#8 0xb743e014 in __assert_fail () from /lib/libc.so.6
#9 0x0859d01a in ha_maria:
lock_
#10 0x082c9355 in get_lock_data (thd=0x93945b28, table_ptr=
write_
#11 0x082c780f in mysql_lock_tables (thd=0x93945b28, tables=0x96d3450, count=3, flags=4,
need_
#12 0x08338c61 in lock_tables (thd=0x93945b28, tables=0x95f7cf8, count=3,
need_
#13 0x08337fc8 in open_and_
derived=true) at sql_base.cc:5246
#14 0x082f2dd9 in open_and_
at mysql_priv.h:1754
#15 0x08389896 in mysql_insert (thd=0x93945b28, table_list=
values_
ignore=false) at sql_insert.cc:670
#16 0x082e5b5c in mysql_execute_
#17 0x082ee438 in mysql_parse (thd=0x93945b28,
rawbuf=
found_
#18 0x082e0e19 in dispatch_command (command=COM_QUERY, thd=0x93945b28,
packet=
packet_
#19 0x082e02c3 in do_command (thd=0x93945b28) at sql_parse.cc:923
#20 0x082dd249 in handle_
#21 0xb76ccb25 in start_thread () from /lib/libpthread
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x95f7c18): INSERT INTO `AA` ( `col_int_nokey` ) VALUES ( NULL )
Connection ID (thread ID): 10
Status: NOT_KILLED
bzr version-info
revision-id: <email address hidden>
date: 2012-03-23 18:22:39 +0200
build-date: 2012-03-24 05:12:46 +0400
revno: 3470
Could not reproduce on maria-5.5 revno 3345 or maria-5.2 revno 3122.
# RQG grammar:
# cat assert.yy
query:
dml | ddl ;
dml:
INSERT INTO _table ( _field ) VALUES ( NULL ) |
DELETE FROM _table LIMIT 1 ;
ddl:
CREATE TRIGGER _letter AFTER INSERT ON _table FOR EACH ROW BEGIN dml ; END ;
# EOF
# Run as
perl runall.pl \
--no-mask \
--threads=4 \
--duration=600 \
--queries=100M \
--views \
--engine=Aria \
--grammar=assert.yy \
--basedir=<basedir>
# It fails for me in seconds after the test starts.
Related branches
Changed in maria: | |
status: | New → In Progress |
tags: | added: assertion rqg |
I have set the importance to Medium for now, as I only see the problem on a debug version; the same test on a release build seems to run okay. If there is a hidden general issue, please adjust the importance accordingly.