[Opensim-users] Anyway to verify the database

[Rick Anderson]

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



-- 
Rick Anderson
Director of Virtual Worlds
Division of Continuing Studies (DoCS)
Rutgers University
(732) 586-3265