openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey" <plins...@gmail.com>
Subject Re: problem wi
Date Fri, 29 Feb 2008 17:24:17 GMT
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. <geir@pobox.com> 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

Mime
View raw message