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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.