<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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"<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>In the past, this took no more than 30 seconds.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My entire grid is down till I resolve this.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>LOG:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>08:58:28 - [SCENE]: Loading objects from datastore<o:p></o:p></p><p class=MsoNormal>08:58:40 - [REGION DB]: Loaded 5000 prims...<o:p></o:p></p><p class=MsoNormal>08:58:41 - [REGION DB]: Loaded 10000 prims...<o:p></o:p></p><p class=MsoNormal>08:58:43 - [REGION DB]: Loaded 15000 prims...<o:p></o:p></p><p class=MsoNormal>08:58:44 - [REGION DB]: Loaded 20000 prims...<o:p></o:p></p><p class=MsoNormal>08:58:46 - [REGION DB]: Loaded 3990 objects using 23349 prims<o:p></o:p></p><p class=MsoNormal>OpenSim threw an exception:<o:p></o:p></p><p class=MsoNormal>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<o:p></o:p></p><p class=MsoNormal>eration<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.TimedStream.StopTimer()<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)<o:p></o:p></p><p class=MsoNormal> at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.MySqlStream.LoadPacket()<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.MySqlStream.ReadPacket()<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 columns)<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns)<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.ResultSet.GetNextRow()<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior)<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.MySqlDataReader.Read()<o:p></o:p></p><p class=MsoNormal> --- End of inner exception stack trace ---<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)<o:p></o:p></p><p class=MsoNormal> at MySql.Data.MySqlClient.MySqlDataReader.Read()<o:p></o:p></p><p class=MsoNormal> at OpenSim.Data.MySQL.MySQLSimulationData.LoadObjects(UUID regionID)<o:p></o:p></p><p class=MsoNormal> at OpenSim.Services.Connectors.SimulationDataService.LoadObjects(UUID regionUUID)<o:p></o:p></p><p class=MsoNormal> at OpenSim.Region.Framework.Scenes.Scene.LoadPrimsFromStorage(UUID regionID)<o:p></o:p></p><p class=MsoNormal> at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene)<o:p></o:p></p><p class=MsoNormal> at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, IScene& scene)<o:p></o:p></p><p class=MsoNormal> at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise()<o:p></o:p></p><p class=MsoNormal> at OpenSim.OpenSimBase.StartupSpecific()<o:p></o:p></p><p class=MsoNormal> at OpenSim.OpenSim.StartupSpecific()<o:p></o:p></p><p class=MsoNormal> at OpenSim.Framework.Servers.BaseOpenSimServer.Startup()<o:p></o:p></p><p class=MsoNormal> at OpenSim.Application.Main(String[] args)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:#6F1010'>Matthew Drover<br></span></b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:gray'>Programmer Consultant<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:gray'>Immersive Technology<br>Distance Education, Learning and Teaching Support<br><br></span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>