MantisBT - opensim
View Issue Details
0008392opensim[REGION] OpenSim Corepublic2018-10-06 23:272018-10-18 10:18
CodyCooper 
 
normalmajorsometimes
confirmedopen 
0.9.0.1 
 
Grid (Multiple Regions per Sim)
BulletSim
.NET / Windows64
None
Firestorm
0008392: When Using MySQL 5.8.X (latest) , Simulator will fail to store assets
Several People, including I, have experienced where the simulator logs a sql error, saying "x077x44x454...etc" is not a proper format for field "text", this causes several assets to not persist.

However upon importing database to a MySQL Server with 5.7.23, Not Only is the Persistence Problem fixed, but the Simulator Performance is Improved, Loading Times seem to improve , and region crossings are almost Perfect.

This only seems to occur when storing high ascii characters
No tags attached.
Issue History
2018-10-06 23:27CodyCooperNew Issue
2018-10-06 23:30CodyCooperSeveritycrash => major
2018-10-06 23:30CodyCooperDescription Updatedbug_revision_view_page.php?rev_id=6792#r6792
2018-10-10 23:09BillBlightNote Added: 0033159
2018-10-10 23:09BillBlightStatusnew => confirmed
2018-10-15 04:18Luisillo_ContepomiNote Added: 0033168
2018-10-15 09:16BillBlightProduct Version => 0.9.0.1
2018-10-15 09:17BillBlightNote Added: 0033169
2018-10-15 09:17BillBlightDescription Updatedbug_revision_view_page.php?rev_id=6844#r6844
2018-10-18 10:17CodyCooperNote Added: 0033176
2018-10-18 10:18CodyCooperNote Added: 0033177

Notes
(0033159)
BillBlight   
2018-10-10 23:09   
Was able to replicate on my test grid, and with talking to others with the same error.
(0033168)
Luisillo_Contepomi   
2018-10-15 04:18   
Please what opensimulator version are you talking about?
For me mytsql latest version is MySQL 8.0.12
I am testing mysql 8.0.12 with opensim 0.9.0.1 (dev included) and I have not sql errors and seem all is running perfectly.
(0033169)
BillBlight   
2018-10-15 09:17   
Luisillo_Contepomi this is with the 9x branch and only occurs when storing high ascii charaters
(0033176)
CodyCooper   
2018-10-18 10:17   
watcher64 , this occurs even with simple letters and words like SF Pig
(0033177)
CodyCooper   
2018-10-18 10:18   
It is not just with the OpenSim 9x branch, but also with 0.8.2.1 at least.