You might want to try setting the openjpa.OrphanedKeyAction to "exception" -- this might help debug where the issue is coming from.
-Patrick On Tue, Feb 26, 2008 at 5:22 PM, Geir Magnusson Jr. <[EMAIL PROTECTED]> wrote: > We're getting tons of these in production (and in test). OpenJPA > 1.0.1 and 1.0.2 : > > > 1677 WARN [main] openjpa.Runtime - Detected possible orphaned > reference to deleted object "125706" in > "com.joost.model.GeneratedThumbnail.videoEnclosure". > > In a private chat, Patrick suggested it means that I deleted an > instance of type VideoEnclosure with id 125706, but had refs elsewhere > in the model that I didn't null out > > It seems that the data is all there : > > mysql> select * from GeneratedThumbnail where videoEnclosureId = 125706; > +--------+------------------+-------------+ > | id | videoEnclosureId | captureTime | > +--------+------------------+-------------+ > | 125708 | 125706 | NULL | > +--------+------------------+-------------+ > 1 row in set (0.87 sec) > > mysql> select * from Enclosure where id = 125706; > +--------+----------------+---------+------ > +--------------------------------------+ > | id | itemType | bitRate | sha1 | > p2pId | > +--------+----------------+---------+------ > +--------------------------------------+ > | 125706 | VideoEnclosure | 346 | NULL | 2eb7b0b4-3619-4d47- > ad84-5ceb36c6385e | > +--------+----------------+---------+------ > +--------------------------------------+ > 1 row in set (0.00 sec) > > mysql> select * from VideoEnclosure where id = 125706; > +--------+--------------+----------+-------------+----------- > +-----------+ > | id | languageCode | duration | aspectRatio | frameRate | > frameSize | > +--------+--------------+----------+-------------+----------- > +-----------+ > | 125706 | 1 | 217384 | 4:3 | 29.970 | > 640x480 | > +--------+--------------+----------+-------------+----------- > +-----------+ > 1 row in set (0.00 sec) > > and I don't ever do deletes in this code. Maybe we have broken data > elsewhere the DB - could it be the videoEnclosureId field referenced > in some other entity or class? > > Is the joined inheritance strategy widely used and reliable? > > geir > > -- Patrick Linskey 202 669 5907
