Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008392opensim[REGION] OpenSim Corepublic2018-10-06 23:272018-10-18 10:18
Assigned To 
PlatformOSOS Version
Product Version0.9.0.1 
Target VersionFixed in Version 
Summary0008392: When Using MySQL 5.8.X (latest) , Simulator will fail to store assets
DescriptionSeveral 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
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBulletSim
Script Engine
Environment.NET / Windows64
Mono VersionNone
Attached Files

- Relationships

-  Notes
BillBlight (developer)
2018-10-10 23:09

Was able to replicate on my test grid, and with talking to others with the same error.
Luisillo_Contepomi (reporter)
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 (dev included) and I have not sql errors and seem all is running perfectly.
BillBlight (developer)
2018-10-15 09:17

Luisillo_Contepomi this is with the 9x branch and only occurs when storing high ascii charaters
CodyCooper (reporter)
2018-10-18 10:17

watcher64 , this occurs even with simple letters and words like SF Pig
CodyCooper (reporter)
2018-10-18 10:18

It is not just with the OpenSim 9x branch, but also with at least.

- Issue History
Date Modified Username Field Change
2018-10-06 23:27 CodyCooper New Issue
2018-10-06 23:30 CodyCooper Severity crash => major
2018-10-06 23:30 CodyCooper Description Updated View Revisions
2018-10-10 23:09 BillBlight Note Added: 0033159
2018-10-10 23:09 BillBlight Status new => confirmed
2018-10-15 04:18 Luisillo_Contepomi Note Added: 0033168
2018-10-15 09:16 BillBlight Product Version =>
2018-10-15 09:17 BillBlight Note Added: 0033169
2018-10-15 09:17 BillBlight Description Updated View Revisions
2018-10-18 10:17 CodyCooper Note Added: 0033176
2018-10-18 10:18 CodyCooper Note Added: 0033177

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker