Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6837

INSERT DELAYED on a Mroonga table hangs and does not honor lock_wait_timeout value

        Details

          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #20 - INSERT DELAYED on a Mroonga table hangs and does not honor lock_wait_timeout value

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  kou Kouhei Sutou added a comment -

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

                  Show
                  kou Kouhei Sutou added a comment - I've disabled the feature in Mroonga. Could you confirm with the latest MariaDB 10.0?
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment - 
                  MariaDB [test]> insert delayed into t1 values (1);
ERROR 1616 (HY000): DELAYED option not supported for table 't1'
                  Show
                  elenst Elena Stepanova added a comment - MariaDB [test]> insert delayed into t1 values (1); ERROR 1616 (HY000): DELAYED option not supported for table 't1'

                    People

                    • Assignee:
                      Kentoku Kentoku
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: