Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1304

LP #1144911: Prepared statements can cause node hanging

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Seppo Jaakola last update 21-03-2013 18:06:34

      Conflicting prepared statements in multi-master use case can cause node to hang. The symptom is different in Percona XtraDB Cluster and Galera Cluster, but the underlying issue deals with prepared statement execution loop, which does not honor wsrep status codes correctly.

      A good way to reproduce, is to run sysbench version 0.4 oltp mode, with high conflict rate and load balanced against two nodes, e.g. like here:

      sysbench --test=oltp --oltp-auto-inc=off --oltp-test-mode=nontrx --oltp-nontrx-mode=update_key --oltp-table-size=1000 --num-threads=32 --init-rng=on --max-requests=0 --max-time=3000 run

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: