[MDEV-6837] INSERT DELAYED on a Mroonga table hangs and does not honor lock_wait_timeout value Created: 2014-10-05  Updated: 2015-09-05  Resolved: 2015-09-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Mroonga
Affects Version/s: 10.0.14
Fix Version/s: 10.0.15

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: mroonga


 Description   

Also filed as https://github.com/mroonga/mroonga/issues/20

Test case

 
install plugin mroonga soname 'ha_mroonga.so';
 
 
 
# Initialize other Mroonga stuff if necessary
 
 
 
create table t1 (i int) engine=Mroonga;
 
lock table t1 read;
 
 
 
--connect (con1,localhost,root,,)
 
set lock_wait_timeout=1;
 
 
 
insert delayed into t1 values (1);

Reasonable outcomes would be:

throw an error that DELAYED option is not supported;
support the option and return from the query immediately;
ignore the option and process the statement as a normal INSERT (preferably with a warning).
Hanging is not a good option.

Observed on lp:maria/10.0 revno 4427.

 Comments   
Comment by Kouhei Sutou [ 2015-08-16 ]

I've disabled the feature in Mroonga.
Could you confirm with the latest MariaDB 10.0?

Comment by Elena Stepanova [ 2015-09-05 ] 

MariaDB [test]> insert delayed into t1 values (1);
 
ERROR 1616 (HY000): DELAYED option not supported for table 't1'

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