MantisBT - opensim
View Issue Details
0007794opensim[GRID] Asset Servicepublic2015-12-30 22:252018-07-13 07:12
Orion Pseudo 
UbitUmarov 
urgentmajoralways
resolvedfixed 
monoLinuxUbuntu 14.04
master (dev code) 
 
0.8.2-post-fixes
Grid (1 Region per Sim)
BulletSim
Mono / Linux64
3.2
0007794: MySQL connection in FSAssets times out after a few hours causing asset read / write failures.
If 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.
Included 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.
No tags attached.
related to 0002742closed  'Connection must be valid and open' message appearing sporadically in console when storing prims 
patch 0001-Changed-handling-of-mysql-connections-to-open-and-cl.patch (18,448) 2015-12-30 22:25
http://opensimulator.org/mantis/file_download.php?file_id=4464&type=bug
Issue History
2015-12-30 22:25Orion PseudoNew Issue
2015-12-30 22:25Orion PseudoFile Added: 0001-Changed-handling-of-mysql-connections-to-open-and-cl.patch
2015-12-30 22:26Orion PseudoSummaryMySQL 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:05Orion PseudoStatusnew => patch included
2015-12-30 23:54Orion PseudoRelationship addedrelated to 0002742
2016-01-25 08:05shin ingenNote Added: 0030022
2018-07-08 06:08UbitUmarovNote Added: 0032742
2018-07-08 06:08UbitUmarovNote Added: 0032743
2018-07-08 06:08UbitUmarovStatuspatch included => resolved
2018-07-08 06:08UbitUmarovResolutionopen => fixed
2018-07-08 06:08UbitUmarovAssigned To => UbitUmarov

Notes
(0030022)
shin ingen   
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   
2018-07-08 06:08   
our code seems to implement this patch

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