[Opensim-users] Anyway to verify the database

[Justin Clark-Casey]

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