Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005294opensim[REGION] OpenSim Corepublic2010-12-30 08:482012-03-30 16:22
ReporterMarauder Moe 
Assigned Tojustincc 
PlatformOperating SystemOperating System Version
Product Version 
Target VersionFixed in Version 
Summary0005294: MySql exception during initial startup (after estate setup)
DescriptionOpenSim 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!
Additional Information2010-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
TagsNo tags attached.
Git Revision or version number? Using latest binary release on website
Run ModeStandalone (1 Region)
Physics EngineBasicPhysics
Script Engine
EnvironmentMono / Windows
Mono Version2.8
Attached Files

- Relationships
has duplicate 0005302closedConnorBaily Crashes every time after answering estate question 

-  Notes
samiam (reporter)
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.
samiam (reporter)
2010-12-31 13:34

not a block. set it back to another lev. TRnx for reporting this. were gonna look :)
snowcrashed (reporter)
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.
ceeimages (reporter)
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.
justincc (administrator)
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?
justincc (administrator)
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?
dslake (manager)
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)

hbenjones (reporter)
2011-03-05 21:07

If you can afford to delete and recreate the opensim database, the problem may go away.
nebadon (administrator)
2011-03-05 21:10

A possible solution to this problem is to change "localhost" to "" in your connection string in GridCommon.ini
justincc (administrator)
2012-03-02 19:17

Anybody know if this bug is still around?
Pixel Tomsen (manager)
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)

- Issue History
Date Modified Username Field Change
2010-12-30 08:48 Marauder Moe New Issue
2010-12-30 08:48 Marauder Moe Git Revision => ? Using latest binary release on website
2010-12-30 08:48 Marauder Moe SVN Revision => 0
2010-12-30 08:48 Marauder Moe Run Mode => Standalone (1 Region)
2010-12-30 08:48 Marauder Moe Physics Engine => BasicPhysics
2010-12-30 08:48 Marauder Moe Environment => Mono / Windows
2010-12-30 08:48 Marauder Moe Mono Version => 2.8
2010-12-31 07:34 samiam Note Added: 0017703
2010-12-31 13:34 samiam Note Added: 0017712
2011-01-16 23:06 snowcrashed Note Added: 0017858
2011-01-18 18:16 ceeimages Note Added: 0017859
2011-01-24 16:00 justincc Note Added: 0017892
2011-01-24 16:00 justincc Status new => feedback
2011-01-24 16:01 justincc Note Added: 0017893
2011-01-30 02:40 dslake Note Added: 0017913
2011-01-30 02:41 dslake Note Edited: 0017913
2011-02-04 07:00 justincc Relationship added has duplicate 0005302
2011-03-05 21:07 hbenjones Note Added: 0018123
2011-03-05 21:10 nebadon Note Added: 0018124
2012-03-02 19:17 justincc Note Added: 0021020
2012-03-06 13:23 Pixel Tomsen Note Added: 0021035
2012-03-30 16:22 justincc Status feedback => closed
2012-03-30 16:22 justincc Assigned To => justincc
2012-03-30 16:22 justincc Resolution open => fixed

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker