oh - fantastic!  Thanks

On Feb 29, 2008, at 12:24 PM, Patrick Linskey wrote:

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

Reply via email to