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

ER_LOCK_WAIT_TIMEOUT on SHOW STATUS

    XMLWordPrintable

    Details

      Description

      Start a node with wsrep provider and wsrep_causal_reads=ON and then execute the following commands :

      MariaDB [test]> show status like 'wsrep_ready';
      +---------------+-------+
      | Variable_name | Value |
      +---------------+-------+
      | wsrep_ready   | ON    |
      +---------------+-------+
      1 row in set (0.64 sec)
       
      MariaDB [test]> set global wsrep_provider="/usr/lib/galera/libgalera_smm.so";
      Query OK, 0 rows affected (2.42 sec)
       
      MariaDB [test]> show status like 'wsrep_ready';
      ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
       

        Attachments

          Activity

            People

            Assignee:
            nirbhay_c Nirbhay Choubey (Inactive)
            Reporter:
            nirbhay_c Nirbhay Choubey (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration