Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007794opensim[GRID] Asset Servicepublic2015-12-30 22:252019-02-06 11:28
ReporterOrion Pseudo 
Assigned ToUbitUmarov 
PlatformmonoOperating SystemLinuxOperating System VersionUbuntu 14.04
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0007794: MySQL connection in FSAssets times out after a few hours causing asset read / write failures.
DescriptionIf left idle for several hours, the single MySQL connection used by the FSAsset service will time out thereby causing future read / write requests to fail.
Additional InformationIncluded is a patch that solves this by creating / disposing the connection on an as needed basis (same as MySQLAssetData and MySQLXAssetData). The patch also ensures proper disposal of MySQL commands and readers by enclosing them in using blocks.
TagsNo tags attached.
Git Revision or version number0.8.2-post-fixes
Run Mode Grid (1 Region per Sim)
Physics EngineBulletSim
Script Engine
EnvironmentMono / Linux64
Mono Version3.2
Attached Filespatch file icon 0001-Changed-handling-of-mysql-connections-to-open-and-cl.patch [^] (18,448 bytes) 2015-12-30 22:25 [Show Content]

- Relationships
related to 0002742closed 'Connection must be valid and open' message appearing sporadically in console when storing prims 

-  Notes
shin ingen (reporter)
2016-01-25 08:05

Have this issue been address at all? I am experiencing the same issue and getting the same console error when robust had run for a few hours.
UbitUmarov (administrator)
2018-07-08 06:08

our code seems to implement this patch

Please reopen if still issues
UbitUmarov (administrator)
2018-07-08 06:08

outdated ??
BillBlight (developer)
2019-02-06 11:28

Marked as Resolved but never closed, can be reopened if needed.

- Issue History
Date Modified Username Field Change
2015-12-30 22:25 Orion Pseudo New Issue
2015-12-30 22:25 Orion Pseudo File Added: 0001-Changed-handling-of-mysql-connections-to-open-and-cl.patch
2015-12-30 22:26 Orion Pseudo Summary MySQL connection in FSAssets times out after a few hours causing asset write failures. => MySQL connection in FSAssets times out after a few hours causing asset read / write failures.
2015-12-30 23:05 Orion Pseudo Status new => patch included
2015-12-30 23:54 Orion Pseudo Relationship added related to 0002742
2016-01-25 08:05 shin ingen Note Added: 0030022
2018-07-08 06:08 UbitUmarov Note Added: 0032742
2018-07-08 06:08 UbitUmarov Note Added: 0032743
2018-07-08 06:08 UbitUmarov Status patch included => resolved
2018-07-08 06:08 UbitUmarov Resolution open => fixed
2018-07-08 06:08 UbitUmarov Assigned To => UbitUmarov
2019-02-06 11:28 BillBlight Note Added: 0034387
2019-02-06 11:28 BillBlight Status resolved => closed

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker