[Opensim-users] Problem with physical objects

[Teravus Ovares]

You can remove the offending object by bringing your region down,
opening up the region database.   Finding the object in the rows and
removing it.

I would suggest looking for fast rotating objects, however you may
also look for objects with no parent ID(or zero) with a position
that's outside of your region.    Be careful looking for objects
outside of the region bounds.   The 'no parent ID' part is important
because the non-root parts of a 'linkset' will have a number or UUID
in the parentID column and have, what looks like, weird positions.

Hopefully this helps

Teravus

2011/2/21 Fokides Manos <fokides at aegean.gr>:
> Thaks for the reply.
> Are you suggesting that I have to delete any fast rotating objects, rez the objects that need to be physical and re-rez the deleted rotating ones?
> Furthermore, I've got an object that has crossed the bountaries of my sim (it has gone to an unreachable and invalid region (?)), that was scripted and physical. Can this be the cause of the problem? If so, how can I delete it?
>
> ________________________________________
> From: Teravus Ovares [teravus at gmail.com]
> Sent: Monday, February 21, 2011 10:18 AM
> To: opensim-users at lists.berlios.de
> Cc: Fokides Manos
> Subject: Re: [Opensim-users] Problem with physical objects
>
> If I were to debug this, I'd look for objects in the database with a
> high rate of rotation.    NaN share their NaN status with other
> objects if it's not caught in time.  You might have an object that's
> NaN-ing your objects when you rez them.  Often times this is caused by
> fast rotating objects.
>
> Regards
>
> Teravus
>
> On Mon, Feb 21, 2011 at 1:36 AM, Fokides Aegean <fokides at aegean.gr> wrote:
>> Hi all!
>>
>> Whenever I turn an object into physical  (physical or physical and locked) I
>> get the following error:
>>
>>
>>
>> 2011-02-21 04:23:44,802 DEBUG -
>> OpenSim.Region.Framework.Scenes.SceneObjectGroup [SCENE]: Storing Wooden
>> Crate, 0a0b9dfa-ca2e-44cb-bdad-89f6b4cd84e8 in Fokides 5
>>
>> 2011-02-21 04:23:44,805 ERROR - OpenSim.Data.MySQL.MySQLDataStore [REGION
>> DB]: MySQL error in ExecuteNonQuery: Unknown column 'NaN' in 'field list'
>>
>> 2011-02-21 04:23:44,807 ERROR -
>> OpenSim.Region.Framework.Scenes.SceneObjectGroup [SCENE]: Storing of Wooden
>> Crate, 0a0b9dfa-ca2e-44cb-bdad-89f6b4cd84e8 in Fokides 5 failed with
>> exception MySql.Data.MySqlClient.MySqlException: Unknown column 'NaN' in
>> 'field list'
>>
>>    at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
>>
>>    at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows,
>> Int64& lastInsertId)
>>
>>    at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
>>
>>    at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
>>
>>    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
>> behavior)
>>
>>    at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
>>
>>    at OpenSim.Data.MySQL.MySQLDataStore.ExecuteNonQuery(MySqlCommand c)
>>
>>    at OpenSim.Data.MySQL.MySQLDataStore.StoreObject(SceneObjectGroup obj,
>> UUID regionUUID)
>>
>>    at
>> OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup(IRegionDataStore
>> datastore, Boolean forcedBackup)
>>
>>                    at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
>>
>>    at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows,
>> Int64& lastInsertId)
>>
>>    at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
>>
>>    at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
>>
>>    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
>> behavior)
>>
>>    at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
>>
>>    at OpenSim.Data.MySQL.MySQLDataStore.ExecuteNonQuery(MySqlCommand c)
>>
>>    at OpenSim.Data.MySQL.MySQLDataStore.StoreObject(SceneObjectGroup obj,
>> UUID regionUUID)
>>
>>    at
>> OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup(IRegionDataStore
>> datastore, Boolean forcedBackup)
>>
>>
>>
>> The problem appears in all kinds of objects (single or multiple prim, in
>> objects in my inventory as well in newly rezzed simple objects such as a
>> cube).
>>
>> After restarting opensim, the objects are no longer in the scene (since they
>> weren’t stored).
>>
>> I googled the problem but I can’t seem to find an suitable answers.
>>
>> Running latest Diva distribution, windows 7 64bit and mysql-5.1.54-winx64.
>>
>>
>>
>> Any ideas?
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>