[Opensim-users] Anyway to verify the database

Chris mewtwo0641 at gmail.com
Sat Aug 18 10:05:33 UTC 2012


Seems I spoke too soon on issue 1. Those pesky intermittent issues never 
pop up when you're actually looking and testing for them =) But I 
believe I've come up with at least a partial amount of steps that I 
think might be contributing to it:

I am running git r/20019 for these steps

1. Rez an object that has multiple links to the ground. (In my case it 
is usually attachments that I've rezzed from inventory to unlink and 
make modifications on; although I am unsure if this makes a difference 
or not)

2. Unlink the object and spend a little while (perhaps 10 or 15 minutes) 
making modifications such as shift copy of prims, adding scripts, 
changing prim sizes, textureing, etc.

3. Either delete the finished object or take the it back into inventory.

4. Upon relog the object will reappear (or perhaps random parts of the 
object if it was deleted and not linked before hand).
     a. This is also visible to other avatars to after they relog.
     b. If attempting to take the object again or delete again it will 
be back again after another relog.
     c. The object will persist until server restart where it will 
reappear again, but can finally be gotten rid of for good by means of a 
delete or take to inventory.

A few things that I have noticed when the issue triggers:
     * When removing a multiple selection of prims, only the root prim 
of that selection seems to persist removal, resulting in the appearance 
of most of the rest of the object still being there upon relog.

     * When examining the MySQL database at the prims table using SELECT 
count(*) FROM `databasenamehere`.`prims` the prim count goes down by one 
even though multiple prims may be selected for removal.

     * If the server is restarted the affected objects can be removed 
and it will be persisted.

Unfortunately it doesn't it trigger consistently applying the above 
steps and I've not yet found a way to consistently trigger it.

I've created a mantis for this particular issue here: 
http://opensimulator.org/mantis/view.php?id=6175

Good luck with the other two issues though Rick!

On 8/17/2012 9:31 PM, Rick Anderson wrote:
> I'm hoping to get time to do this:
>> In theory, one could verify the data in certain ways (e.g. make sure all
>> prims in the database had a root prim) but I haven't done this myself.
>>
> Also, I'm planning to start running Splunk on my log files. Maybe, it
> can help find some of the issues. Trying to sort through the log ins't
> fun by hand.
>
> -_Rick
>
> On Fri, Aug 17, 2012 at 7:07 PM, Justin Clark-Casey
> <jjustincc at googlemail.com> wrote:
>> Issue 1 is odd - it's never something I've seen or reproduced myself though
>> I do seem to have heard reports.  It's worth trying 0.7.4-rc1 for this
>> though I don't know of any specific fixes.
>>
>> Issue 2 is not something I would expect to see in OpenSim at all.  If you're
>> using third party user creation code then I would suggest looking there
>> first.
>>
>> For issue 3, there have been some permission fixes in 0.7.4-rc1, though I
>> would not expect such things to vary via the viewer as the enforcement of
>> permissions ins enforced purely server-side.
>>
>> In theory, one could verify the data in certain ways (e.g. make sure all
>> prims in the database had a root prim) but I haven't done this myself.
>>
>>
>> On 16/08/12 11:38, Rick Anderson wrote:
>>> Not yet, but I'd be willing to test it.
>>> --Rick
>>>
>>> On Thu, Aug 16, 2012 at 2:23 AM, Chris <mewtwo0641 at gmail.com> wrote:
>>>> I'm not sure about issue 2 and 3 but I used to run into issue 1 quite
>>>> frequently myself; but I have not seen it pop up (yet) since upgrading to
>>>> the master revision. Have you tried master or 0.7.4 RC1 yet?
>>>>
>>>> Just my thoughts. Hope this helps in your search =)
>>>>
>>>>
>>>>
>>>> On 8/15/2012 12:30 PM, Rick Anderson wrote:
>>>>>
>>>>> Hi All,
>>>>>
>>>>> I've been running into a set of issues which I'm suspecting is related
>>>>> to my database.
>>>>>
>>>>> 1. Prims deleted by users return on their next log in.
>>>>>
>>>>> 2. Avatars that were in active for 10 months log in and get new user
>>>>> ids and lose their inventory
>>>>>
>>>>> 3. Permissions change when giving items thought this varies by viewer
>>>>>
>>>>> Is there any sql or techniques to verify the database?
>>>>>
>>>>> I'd like to be able to know that it's consistent so that when I hunt
>>>>> down these issues I know it's not the db.
>>>>>
>>>>> Thanks,
>>>>> --Rick
>>>>>
>>>>
>>>> --
>>>> OpenSim: 10 Region Standalone on 0.7.4 Dev
>>>> Physics: Open Dynamics Engine
>>>> OS: Windows 7 (x64)
>>>> CPU: AMD Phenom II X4 840 3.2 GHz
>>>> Memory: 11 GB DDR3
>>>> Database: MySQL 5.1.63 (x64)
>>>>
>>>> _______________________________________________
>>>> Opensim-users mailing list
>>>> Opensim-users at lists.berlios.de
>>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>>
>>>
>>
>> --
>> Justin Clark-Casey (justincc)
>> http://justincc.org/blog
>> http://twitter.com/justincc
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>


-- 
OpenSim: 10 Region Standalone on 0.7.4 Dev
Physics: Open Dynamics Engine
OS: Windows 7 (x64)
CPU: AMD Phenom II X4 840 3.2 GHz
Memory: 11 GB DDR3
Database: MySQL 5.1.63 (x64)




More information about the Opensim-users mailing list