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
<[email protected]> 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 <[email protected]> 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
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
--
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
[email protected]
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)
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
