Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008864opensim[REGION] OpenSim Corepublic2021-02-11 01:382021-02-12 21:57
Reportervladimir Djannovic 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionopen 
Platform0.9.2 lastautobuildOperating SystemWindowsOperating System VersionServer 2012 R2
Product Version 
Target VersionFixed in Version 
Summary0008864: Slow loading of prims, database timeout, teleport fail
Descriptionwhen restarting a simulator, the prims are slow to load before it restarts and I get this in other simulators: [REGION DB]: MySQL error in ExecuteNonQuery: Timeout expired.
During the time of the simulator restart, it is no longer possible to teleport from one region to another.

Once the simulator has finished its restart, it returns to normal
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBulletSim
Script EngineYEngine
Environment.NET / Windows64
Mono VersionNone
Viewer
Attached Files

- Relationships

-  Notes
(0037555)
vladimir Djannovic (reporter)
2021-02-11 01:47

10:46:25 - [ENTITY TRANSFER MODULE]: Exception on teleport of Belledejour Rose f
rom <193.1891, 114.7287, 20.92402>@Belledejour_Land to <122.8156, 188.7969, 22.0
5219>@Sandbox2: La référence d'objet n'est pas définie à une instance d'un objet
. à OpenSim.Region.Framework.Scenes.ScenePresence.MakeChildAgent(UInt64 newReg
ionHandle)
   à OpenSim.Region.CoreModules.Framework.EntityTransfer.EntityTransferModule.Tr
ansferAgent_V2(ScenePresence sp, AgentCircuitData agentCircuit, GridRegion reg,
GridRegion finalDestination, IPEndPoint endPoint, UInt32 teleportFlags, Boolean
OutSideViewRange, EntityTransferContext ctx, String& reason)
   à OpenSim.Region.CoreModules.Framework.EntityTransfer.EntityTransferModule.Do
TeleportInternal(ScenePresence sp, GridRegion reg, GridRegion finalDestination,
Vector3 position, Vector3 lookAt, UInt32 teleportFlags)
   à OpenSim.Region.CoreModules.Framework.EntityTransfer.EntityTransferModule.Te
leportAgentToDifferentRegion(ScenePresence sp, UInt64 regionHandle, Vector3 posi
tion, Vector3 lookAt, UInt32 teleportFlags, GridRegion& finalDestination)
   à OpenSim.Region.CoreModules.Framework.EntityTransfer.EntityTransferModule.Te
leport(ScenePresence sp, UInt64 regionHandle, Vector3 position, Vector3 lookAt,
UInt32 teleportFlags)
(0037556)
tampa (reporter)
2021-02-11 01:52

Please post error messages in english next time.

If you are getting a timeout from mysql that can have multiple causes:

- Your database is slow to react, especially running on normal harddrives this can happen-> Increase timeout value in my.cnf
- The connection to the database breaks due to packet size being exceed-> check my.cnf for innodb config
- Especially if teleports and such fail you may have a timing issue-> check your clocksource is tsc and check system load, if your system is overloaded there is much to fail

During the initial period of startup and even shortly after logins are enabled there is still a lot going, so a simulator may not immediately react as snappy as when it has been running for a bit.

This seems more an issue with your setup or system than an OpenSim bug.
(0037557)
vladimir Djannovic (reporter)
2021-02-11 01:57

do i need to change this?

innodb_lock_wait_timeout= 50
(0037558)
UbitUmarov (administrator)
2021-02-11 03:51

i case you are doing it, do not use console (or script, etc) regions restart. Fully shutdown the entire simulator. And start it again
(0037559)
UbitUmarov (administrator)
2021-02-11 07:32

also check machine free memory...
if you hit swaping, you are "dead" ;)

also part of the free memory is used as disk cache by windows or linux ( if enabled). Not having much may impact disk operation performance
(0037562)
vladimir Djannovic (reporter)
2021-02-12 21:43

My concern is resolved, but I had to change several things in my mysql configuration file.

- Issue History
Date Modified Username Field Change
2021-02-11 01:38 vladimir Djannovic New Issue
2021-02-11 01:47 vladimir Djannovic Note Added: 0037555
2021-02-11 01:52 tampa Note Added: 0037556
2021-02-11 01:53 tampa Priority high => normal
2021-02-11 01:53 tampa Category [GRID] Other Service => [REGION] OpenSim Core
2021-02-11 01:53 tampa Operating System Version Serveur 2012 R2 => Server 2012 R2
2021-02-11 01:53 tampa Summary Opensim 0.9.2 => Slow loading of prims, database timeout, teleport fail
2021-02-11 01:53 tampa Steps to Reproduce Updated View Revisions
2021-02-11 01:57 vladimir Djannovic Note Added: 0037557
2021-02-11 03:51 UbitUmarov Note Added: 0037558
2021-02-11 07:32 UbitUmarov Note Added: 0037559
2021-02-12 21:43 vladimir Djannovic Note Added: 0037562
2021-02-12 21:57 vladimir Djannovic Status new => resolved


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker