openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geir Magnusson Jr." <g...@pobox.com>
Subject Re: problem wi
Date Fri, 29 Feb 2008 17:36:27 GMT
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. <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