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
ReporterCodyCooper 
Assigned To 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusconfirmedResolutionopen 
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
Environment.NET / Windows64
Mono VersionNone
ViewerFirestorm
Attached Files

- Relationships

-  Notes
(0033159)
watcher64 (reporter)
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 (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 0.9.0.1 (dev included) and I have not sql errors and seem all is running perfectly.
(0033169)
watcher64 (reporter)
2018-10-15 09:17

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

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

It is not just with the OpenSim 9x branch, but also with 0.8.2.1 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 watcher64 Note Added: 0033159
2018-10-10 23:09 watcher64 Status new => confirmed
2018-10-15 04:18 Luisillo_Contepomi Note Added: 0033168
2018-10-15 09:16 watcher64 Product Version => 0.9.0.1
2018-10-15 09:17 watcher64 Note Added: 0033169
2018-10-15 09:17 watcher64 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