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

Reply via email to