a foreign key constraint fails in TPC-C test

Bug #406761 reported by Aleksandr Kuzminsky on 2009-07-30
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBXT
Undecided
Unassigned

Bug Description

While running a TPC-C test (https://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql)
With options:
***************************************
*** ###easy### TPC-C Load Generator ***
***************************************
<Parameters>
     [server]: 127.0.0.1
     [DBname]: test
       [user]: root
       [pass]: ""
  [warehouse]: 2
 [connection]: 1
     [rampup]: 10 (sec.)
    [measure]: 30 (sec.)

The error emerges:
neword 0:3
1451, 23000, Cannot delete or update a parent row: a foreign key constraint fails (Constraint: `fkey_customer_1`)

Related branches

Hi Aleksandr,

thanks for the report. Which version/revision of MySQL/PBXT are you using?

Hi Vladimir,
MySQL is 5.1.36, PBXT is the latest one from the trunk, revision 677.

Paul McCullagh (paul-mccullagh) wrote :

I have tested the TPCC benchmark, with FK activated in version 1.0.11.

Changed in pbxt:
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers