Announcement

Announcement Module
Collapse
No announcement yet.

What's mean this error in percona logs

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • What's mean this error in percona logs

    Hi,

    I don't know what's mean this logs errors :
    120614 15:25:55 [ERROR] Slave SQL: Could not execute Delete_rows event on table pa.AreaType; Cannot delete or update a parent row: a foreign key constraint fails (`pa`.`Area`, CONSTRAINT `fk_Area_AreaType` FOREIGN KEY (`areaTypeId`) REFERENCES `AreaType` (`id`) ON UPDATE CASCADE), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED; the event's master log FIRST, end_log_pos 129, Error_code: 1451
    120614 15:25:55 [Warning] WSREP: RBR event 2 Delete_rows apply warning: 152, 1925
    120614 15:25:55 [ERROR] WSREP: Failed to apply trx: source: 938778e1-b61c-11e1-0800-00d9733f9bb3 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 1673 trx_id: 17946 seqnos (l: 364, g: 1925, s: 1924, d: 1906, ts: 1339680355633397546)
    120614 15:25:55 [ERROR] WSREP: Failed to apply app buffer: cæÙO, seqno: 1925, status: WSREP_FATAL

    120614 15:28:23 [Warning] WSREP: Certification failed for TO isolated action: source: 938778e1-b61c-11e1-0800-00d9733f9bb3 version: 2 local: 0 state: MUST_ABORT flags: 65 conn_id: 1673 trx_id: -1 seqnos (l: 4, g: 1930, s: 1929, d: 1929, ts: 1339680357271361415)
    120614 15:28:23 [Warning] WSREP: Certification failed for TO isolated action: source: 938778e1-b61c-11e1-0800-00d9733f9bb3 version: 2 local: 0 state: MUST_ABORT flags: 65 conn_id: 1673 trx_id: -1 seqnos (l: 6, g: 1932, s: 1931, d: 1931, ts: 1339680357309181941)
    120614 15:28:23 [Warning] WSREP: Certification failed for TO isolated action: source: 938778e1-b61c-11e1-0800-00d9733f9bb3 version: 2 local: 0 state: MUST_ABORT flags: 65 conn_id: 1673 trx_id: -1 seqnos (l: 8, g: 1934, s: 1933, d: 1933, ts: 1339680357347609350)


    Thx for ur help

  • #2
    What version of XtraDB cluster are you running?

    Comment


    • #3
      hi,

      This is Percona 5.5.24, the last version

      Thx

      Comment


      • #4
        This looks like a problem in processing foreign key constaraint with ON UPDATE CASCADE option.

        Please show the table specifications for related tables, e.g. by:

        mysql> SHOWE CREATE TABLE pa.Area;
        mysql> SHOWE CREATE TABLE pa.AreaType;

        I will try to reproduce this issue and have created a bug report in codership-mysq launchpad project to track the troubleshooting progress: https://bugs.launchpad.net/codership-mysql/+bug/1013978

        Comment


        • #5
          a typo above, commands should be:

          mysql> SHOW CREATE TABLE pa.Area;
          mysql> SHOW CREATE TABLE pa.AreaType;

          Comment


          • #6
            I have an effective regression test for this issue now. Can you confirm if you have:
            1. 'AreaType' table has non-unique index on column 'id'
            2. wsrep_slave_threads variable has value > 1

            Comment


            • #7
              Hi,

              Thank you a lot for yours responses
              my column id is a PK but non-unique and not auto-increment
              my wsrep_slave_threads variable is equal to 4
              For information the pb crash my node

              Best regards

              Comment

              Working...
              X