[Opensim-dev] Problem with physical objects

Thu Feb 24 00:32:30 UTC 2011

If you're using OpenSim.32bitLaunch.exe then I expect this is some kind of bug, though I'm surprised other people 
haven't run into it before with simple cubes.

You might want to try reducing the complexity of your setup (e.g. run just one region with one physical prim) and see if 
that changes anything.  If that works, then try with more regions, etc.

On 23/02/11 22:55, Fokides Aegean wrote:
> Hi all!
>
> A couple of days ago I posted an email to the opensim users mailing list about a problem I had each time I turned an
> object into physical.
>
> In short, the error was:
>
> 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'
>
> Since it couldn’t be saved in the database, every physical object simply disappeared from my sim after restarting the
> server.
>
> Teravus kindly replied making a couple of suggestions that unfortunately couldn’t fix the problem.
>
> The only thing that I’ve noticed is that in the SW region and in the region directly above. Physical prims were always
> working OK.
>
> So I decided to uninstall MySQL, delete the database, delete diva-r13981 folder and start from scratch an empty 4X4
> regions totally flat estate which looks like this:
>
> 4 8 12 16
>
> 3 7 11 15
>
> 2 6 10 14
>
> 1 5 9 13
>
> The coordinates I’m using are:
>
> 8100,8100
>
> 8100,8101
>
> 8100,8102
>
> 8100,8103
>
> 8101,8100
>
> 8101,8101
>
> 8101,8102
>
> 8101,8103
>
> 8102,8100
>
> 8102,8101
>
> 8102,8102
>
> 8102,8103
>
> 8103,8100
>
> 8103,8101
>
> 8103,8102
>
> 8103,8103
>
> In each region I rezzed a simple cube (16 in total) and the only attributes I changed in each one was to tick:
>
> everyone can move
>
> everyone can copy
>
> show in search
>
> physical
>
> Nothing more and no scripts. I also didn’t move them from their initial position.
>
> I checked the table prims in MySQL and all 16 prims were saved there.
>
> I used the quit command to shutdown the server.
>
> Rechecked the table prims in MySQL and all 16 prims were saved.
>
> Restarted the server and 6 out of 16 prims were missing.
>
> Re-rezzed the missing ones and a couple of simple non physical cubes close to them. NaN problems started and not all
> could be saved to the database after a shutdown.
>
> Restarted the server, 6 out of 16 were left.
>
> Restarted once more, only 2 were left (in regions 1 and 2).
>
> Re-rezzed all 16 plus 16 non physical and as you might guess, after a restart, some were missing once again…
>
> Tried MySQL 5.1.5.0 64bit, 5.1.5.0 32bit, 5.1.5.4 64bit each time with the same results.
>
> At this point I gave up hope in solving the problem.
>
> Opensim version: Diva r13981
>
> OS: Win7 64bit.
>
> Viewer: Imprudence 1.3.0 (Oct 7 2010 02:31:57)
>
> The only changes that I made in Diva (besides myworld.ini and regionconfig.ini) are in opensim.ini where
>
> I enabled clouds
>
> I enabled freeswitch (but that’s another story)
>
> Added the lines meshing=meshmerizer
>
> Usemeshiesphysics=true
>
> Since I don’t know if I can post attachments, I’m uploading the OpenSim.32BitLaunch.log and an Excel file that contains
> the prims table of MySQL in the various states of restart and shutdown in the following address:
>
> http://www.rhodes.aegean.gr/ptde/personel/fokides/helpme.htm
>
> I don’t know if I’m doing something completely stupid which results in this problem, or if it’s a bug.
>
> So, any help will be much appreciated…
>
> Regards
>
> Manos
>
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev

-- 
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc