[Opensim-users] [SCENE]: Loading objects from datastore - TIMEOUT

[Justin Clark-Casey]

This is happening when the simulator is initially loading scene object data.

We did have a problem back in 2010 where the MySQL adaptor was timing out in exactly this way [1].  However, this was 
resolved by updating the MySQL code used by OpenSimlator to a later version which allowed infinite timeouts.

However, I note that the timeout for this call is actually set to 3600 directly in the code.  However, this is still 60 
minutes, which would be more than ample time for any possible load objects query to complete.

Are you using any unusual database settings which might somehow override this?  Is this problem only being thrown after 
60 minutes?  At this point, I would start to suspect you might even has disk issues (which might even explain your other 
particle corruption problem).

[1] http://opensimulator.org/mantis/view.php?id=4831


On 13/03/14 11:44, Drover, Matt wrote:
> Here is my newest error this morning, it is happening on all my regions, even small ones. MySQL is running and other
> apps can reach it. Its on the local box, so no firewall issues.
>
> In my connection string I have the timeout set to 5 min (for testing) and it will sit there after this line for 5 min
> then timeout. "[REGION DB]: Loaded 3990 objects using 23349 prims"
>
> In the past, this took no more than 30 seconds.
>
> My entire grid is down till I resolve this.
>
> LOG:
>
> 08:58:28 - [SCENE]: Loading objects from datastore
>
> 08:58:40 - [REGION DB]: Loaded 5000 prims...
>
> 08:58:41 - [REGION DB]: Loaded 10000 prims...
>
> 08:58:43 - [REGION DB]: Loaded 15000 prims...
>
> 08:58:44 - [REGION DB]: Loaded 20000 prims...
>
> 08:58:46 - [REGION DB]: Loaded 3990 objects using 23349 prims
>
> OpenSim threw an exception:
>
> MySql.Data.MySqlClient.MySqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation
> or the server is not responding. ---> System.TimeoutException: Timeout in IO op
>
> eration
>
>     at MySql.Data.MySqlClient.TimedStream.StopTimer()
>
>     at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
>
>     at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
>
>     at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
>
>     at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
>
>     at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
>
>     at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 columns)
>
>     at MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns)
>
>     at MySql.Data.MySqlClient.ResultSet.GetNextRow()
>
>     at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior)
>
>     at MySql.Data.MySqlClient.MySqlDataReader.Read()
>
>     --- End of inner exception stack trace ---
>
>     at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
>
>     at MySql.Data.MySqlClient.MySqlDataReader.Read()
>
>     at OpenSim.Data.MySQL.MySQLSimulationData.LoadObjects(UUID regionID)
>
>     at OpenSim.Services.Connectors.SimulationDataService.LoadObjects(UUID regionUUID)
>
>     at OpenSim.Region.Framework.Scenes.Scene.LoadPrimsFromStorage(UUID regionID)
>
>     at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene)
>
>     at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, IScene& scene)
>
>     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)
>
> *Matthew Drover
> *Programmer Consultant
>
> Immersive Technology
> Distance Education, Learning and Teaching Support
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


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