MantisBT - opensim
View Issue Details
0005294opensim[REGION] OpenSim Corepublic2010-12-30 08:482012-03-30 16:22
Marauder Moe 
? Using latest binary release on website
Standalone (1 Region)
Mono / Windows
0005294: MySql exception during initial startup (after estate setup)
OpenSim binaries running on Windows Vista, 64-bit.

Using example OpenSim.ini and StandaloneCommon.ini but with SQLlite commented out and MySQL connections and connection strings enabled. No other changes.

Verified SQL connection and that tables are being created during the initial run of the server.

Crashes after I answer the following startup question:
Your region is not part of an estate.
Do you wish to join an existing estate? [no]:

Exception message posted in additional information. Please help!
2010-12-30 11:26:14,150 ERROR - OpenSim.Application [APPLICATION]:
APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs

Exception: MySql.Data.MySqlClient.MySqlException: Invalid attempt to access a field before calling Read()
  at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue (Int32 index, Boolean checkNull) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.get_Item (Int32 i) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLEstateStore.DoLoad (MySql.Data.MySqlClient.MySqlCommand cmd, UUID regionID, Boolean create) [0x00000] in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLEstateStore.LoadEstateSettings (UUID regionID, Boolean create) [0x00000] in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.Scene..ctor (OpenSim.Framework.RegionInfo regInfo, OpenSim.Framework.AgentCircuitManager authen, OpenSim.Region.Framework.Scenes.SceneCommunicationService sceneGridService, OpenSim.Region.Framework.StorageManager storeManager, OpenSim.Region.Framework.ModuleLoader moduleLoader, Boolean dumpAssetsToFile, Boolean physicalPrim, Boolean SeeIntoRegionFromNeighbor, IConfigSource config, System.String simulatorVersion) [0x00000] in <filename unknown>:0
  at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo regionInfo, OpenSim.Region.Framework.StorageManager storageManager, OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] in <filename unknown>:0
  at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo regionInfo, Int32 proxyOffset, IConfigSource configSource, IClientNetworkServer& clientServer) [0x00000] in <filename unknown>:0
  at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) [0x00000] in <filename unknown>:0
  at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] in <filename unknown>:0
  at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise () [0x00000] in <filename unknown>:0
  at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename unknown>:0
  at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename unknown>:0
  at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] in <filename unknown>:0
  at OpenSim.Application.Main (System.String[] args) [0x00000] in <filename unknown>:0

Application is terminating: True
No tags attached.
has duplicate 0005302closed ConnorBaily Crashes every time after answering estate question 
Issue History
2010-12-30 08:48Marauder MoeNew Issue
2010-12-30 08:48Marauder MoeGit Revision => ? Using latest binary release on website
2010-12-30 08:48Marauder MoeSVN Revision => 0
2010-12-30 08:48Marauder MoeRun Mode => Standalone (1 Region)
2010-12-30 08:48Marauder MoePhysics Engine => BasicPhysics
2010-12-30 08:48Marauder MoeEnvironment => Mono / Windows
2010-12-30 08:48Marauder MoeMono Version => 2.8
2010-12-31 07:34samiamNote Added: 0017703
2010-12-31 13:34samiamNote Added: 0017712
2011-01-16 23:06snowcrashedNote Added: 0017858
2011-01-18 18:16ceeimagesNote Added: 0017859
2011-01-24 16:00justinccNote Added: 0017892
2011-01-24 16:00justinccStatusnew => feedback
2011-01-24 16:01justinccNote Added: 0017893
2011-01-30 02:40dslakeNote Added: 0017913
2011-01-30 02:41dslakeNote Edited: 0017913
2011-02-04 07:00justinccRelationship addedhas duplicate 0005302
2011-03-05 21:07hbenjonesNote Added: 0018123
2011-03-05 21:10nebadonNote Added: 0018124
2012-03-02 19:17justinccNote Added: 0021020
2012-03-06 13:23Pixel TomsenNote Added: 0021035
2012-03-30 16:22justinccStatusfeedback => closed
2012-03-30 16:22justinccAssigned To => justincc
2012-03-30 16:22justinccResolutionopen => fixed

2010-12-31 07:34   
This may relate to mantis 0005099 to. There is some info about it there.
I have not seen this myselph but i pre-make my region.ini rather than let it do it for me. It will still ask the question though.
2010-12-31 13:34   
not a block. set it back to another lev. TRnx for reporting this. were gonna look :)
2011-01-16 23:06   
Just FYI: I ran into the same issue trying to setup on Windows 7 x64 / MySQL 5.5.8.

For some reason downgrading MySQL to 5.1.54 "fixed" it for me.
2011-01-18 18:16   
I ran into the same issue as well with Opensim I also downgraded to MY SQL 5.1. What worked for me was to answer yes to joining an existing estate. Making up a random Estate name, then getting the prompt this Estate is not found. Then it would ask me again if I wanted to join an existing estate. This time I said no and for some reason it worked and continued on loading the second time. Hope that is helpful.
2011-01-24 16:00   
I just tried to reproduce this on Windows XP with 32-bit MySQL 5.5.8 using the source release and latest master (as of today) and everything worked fine.

Can anybody reproduce this on WinXP 32-bit rather than Vista 64-bit?
2011-01-24 16:01   
Also Marauder, could you try with a git master build or a source build so that we can get line number information?
2011-01-30 02:40   
(edited on: 2011-01-30 02:41)
I ran into the same problem tonight on Windows Server 2008 64-bit with MySQL "Ver 14.14 Distrib 5.5.8, for Win64 (x86)". Downgrading to MySQL 5.1.54 (still Win64) eliminated the problem. I was running release but I'll take a look at the line numbers next time I run debug. Here's what I saw. It's different than the OP.

Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Invalid attempt to access a field before calling Read()
   at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull)
   at MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i)
   at MySql.Data.MySqlClient.MySqlDataReader.get_Item(Int32 i)
   at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
   at OpenSim.Data.MySQL.MySQLEstateStore.DoLoad(MySqlCommand cmd, UUID regionID, Boolean create)
   at OpenSim.Data.MySQL.MySQLEstateStore.LoadEstateSettings(UUID regionID, Boolean create)
   at OpenSim.Services.Connectors.EstateDataService.LoadEstateSettings(UUID regionID, Boolean create)
   at OpenSim.OpenSimBase.PopulateRegionEstateInfo(RegionInfo regInfo)
   at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise()
   at OpenSim.OpenSimBase.StartupSpecific()
   at OpenSim.OpenSim.StartupSpecific()
   at OpenSim.Framework.Servers.BaseOpenSimServer.Startup()
   at OpenSim.Application.Main(String[] args)

2011-03-05 21:07   
If you can afford to delete and recreate the opensim database, the problem may go away.
2011-03-05 21:10   
A possible solution to this problem is to change "localhost" to "" in your connection string in GridCommon.ini
2012-03-02 19:17   
Anybody know if this bug is still around?
Pixel Tomsen   
2012-03-06 13:23   
has always worked well for me (mysql migration up today) ... but may be that there are problems with predecessor migrations(old db's)