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