Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007794opensim[GRID] Asset Servicepublic2015-12-30 22:252018-07-13 07:12
ReporterOrion Pseudo 
Assigned ToUbitUmarov 
PriorityurgentSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformmonoOSLinuxOS 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
EnvironmentMono / Linux64
Mono Version3.2
Viewer
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
(0030022)
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.
(0032742)
UbitUmarov (administrator)
2018-07-08 06:08

our code seems to implement this patch

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

outdated ??

- 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


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker