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@lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users
--
Justin Clark-Casey (justincc)
OSVW Consulting
http://justincc.org
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
Opensim-users@lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users
