Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of jbryanlewis@gmail.com
 designates 209.85.214.171 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <605526E6-72CF-4B2D-97A7-76766A951E74@earthlink.net>
References: <1CAF0260-43A3-409E-9833-3A551EC5208A@earthlink.net>
 <B2241A4C-B03B-4C45-979D-64D05C9C0659@earthlink.net>
 <C777D02B-AFDD-43F5-9A7D-6D48772793CD@objectstyle.org>
 <605526E6-72CF-4B2D-97A7-76766A951E74@earthlink.net>
From: Bryan Lewis <jbryanlewis@gmail.com>
Date: Mon, 6 Feb 2012 07:18:24 -0500
Message-ID: 
 <CAFYr+8bqnQTpPmywyXdFy7OOFfzXhHjM0fWo3oa3ubfZzxSmgw@mail.gmail.com>
Subject: Re: Odd error
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=f46d0444eccde458a804b84aa96c

--f46d0444eccde458a804b84aa96c
Content-Type: text/plain; charset=ISO-8859-1

This error reminds me of something we see in our shop.  If multiple related
entities are being committed together, Cayenne can sometimes commit them
out of order which can cause FK constraint violations.  The commit order
seems to be indeterminate; it can work as expected on a dev machine and
fail in production.

Look at the SQL issued just before the error.  On one server you might see
the packagetype being inserted before the product, but the other way around
on the other server.  If this is the problem, the fix is to subclass the
AshwoodEntitySorter as has been discussed a couple of times in the list.


On Sun, Feb 5, 2012 at 6:48 PM, Joe Baldwin <jfbaldwin@earthlink.net> wrote:

>
> Here is the current error (which is really odd because it is working just
> fine on my dev server)
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
> Cannot add or update a child row: a foreign key constraint fails
> (`eagle1_om28`.`product`, CONSTRAINT `product_ibfk_2` FOREIGN KEY
> (`packageTypeOid`) REFERENCES `packagetype` (`oid`))
>

--f46d0444eccde458a804b84aa96c--