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 <[email protected]>: > 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 [[email protected]] > Sent: Monday, February 21, 2011 10:18 AM > To: [email protected] > 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 <[email protected]> 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 >> [email protected] >> https://lists.berlios.de/mailman/listinfo/opensim-users >> >> > _______________________________________________ > Opensim-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
