Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008326opensim[REGION] OpenSim Corepublic2018-05-27 06:542018-07-01 08:15
Reporterclaudio 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
Platformx86_64OSLinuxOS VersionMint 18.3
Product Version0.9.0 
Target VersionFixed in Version 
Summary0008326: mysql errors during backup
Descriptionafter moving away from sqllite to mysql, I have much better performance.

However I am experiencing errors and slowdowns during backup, regardless of the triggering method (backup command, periodic events, and quit command).

The errors assume the form:

15:44:16 - Timeout in threadfunc 7736 (STP:Util:26) (BackupWorker (mall))
15:44:16 - [REGION DB]: MySQL error in ExecuteNonQuery: Fatal error encountered attempting to read the resultset.
15:44:16 - [SCENE]: Storing of Egghead Female, f8a1e83e-c080-4a29-bda3-152fa10a3c2f in mall failed with exception at OpenSim.Region.Framework.Scenes.SceneObjectPartInventory.ProcessInventoryBackup (ISimulationDataService datastore) <0x41087270 + 0x000cf> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.SceneObjectGroup+<ProcessBackup>c__AnonStorey5.<>m__0 (OpenSim.Region.Framework.Scenes.SceneObjectPart part) <0x410871a0 + 0x00032> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ForEachPart (System.Action`1 whatToDo) <0x41087120 + 0x0004b> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup (ISimulationDataService datastore, Boolean forcedBackup) <0x40f50000 + 0x01473> in <filename unknown>:0
15:44:16 - [EVENT MANAGER]: Delegate for TriggerOnBackup failed - continuing. at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup (ISimulationDataService datastore, Boolean forcedBackup) <0x40f50000 + 0x0170f> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.EventManager.TriggerOnBackup (ISimulationDataService dstore, Boolean forced) <0x40e68af0 + 0x000c0> in <filename unknown>:0

The specific object that mysql complains about changes all the time.

Steps To ReproduceInstall 0.9.0 source package,
setup mysql as per instructions (using utf8 collation)

create a region and load the Free Mall 0000002 OAR:
https://zadaroo.com/?page_id=1647 [^]

issue backup, wait long enough, or quit gracefully.

Read the red errors in the terminal
Additional InformationMono JIT compiler version 4.2.1 (Debian 4.2.1.102+dfsg2-7ubuntu4)
TagsNo tags attached.
Git Revision or version number
Run Mode Standalone (Multiple Regions)
Physics EngineBulletSim
EnvironmentMono / Linux64
Mono VersionOther
Vieweralchemy
Attached Files

- Relationships

-  Notes
(0032690)
claudio (reporter)
2018-05-27 11:10

I was able to reproduce this even with much smaller OAR, for example ConferenceCenter OAR:


20:02:37 - Timeout in threadfunc 527 (STP:Util:2) (BackupWorker (conference_center))
20:02:37 - [REGION DB]: MySQL error in ExecuteNonQuery: Fatal error encountered attempting to read the resultset.
20:02:37 - [SCENE]: Storing of conference hall, 992222bb-455d-47fd-a51b-2dbf7a61e8fd in conference_center failed with exception Fatal error encountered attempting to read the resultset. at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) <0x41dcef30 + 0x00de7> in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () <0x41dcef10 + 0x0000f> in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () <0x41dd99d0 + 0x00133> in <filename unknown>:0
  at OpenSim.Data.MySQL.MySQLSimulationData.ExecuteNonQuery (MySql.Data.MySqlClient.MySqlCommand c) <0x41e8e400 + 0x00022> in <filename unknown>:0
20:02:37 - [EVENT MANAGER]: Delegate for TriggerOnBackup failed - continuing. at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup (ISimulationDataService datastore, Boolean forcedBackup) <0x420c43b0 + 0x0170f> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.EventManager.TriggerOnBackup (ISimulationDataService dstore, Boolean forced) <0x41fcd990 + 0x000c0> in <filename unknown>:0
(0032717)
Luisillo_Contepomi (reporter)
2018-07-01 08:15

I have much of this messages but I think that in my case is because my hard disk are old. Mysql can not write to disk in the correct time and then... "time out".
I can not try it with other old versions.

I will continue to investigate this issue

- Issue History
Date Modified Username Field Change
2018-05-27 06:54 claudio New Issue
2018-05-27 11:10 claudio Note Added: 0032690
2018-07-01 08:15 Luisillo_Contepomi Note Added: 0032717


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker