Mantis Bug Tracker

View Revisions: Issue #8065 All Revisions ] Back to Issue ]
Summary 0008065: [ASSET DB]: MySQL failure creating asset ... Error: Data too long for column 'description' at row 1
Revision 2016-11-24 05:55 by aiaustin
Description I spotted some errors on the consoles for the Openvue grid using 0.9.1.0 dev master while an OSGrid avatar was visiting via hypergrid. The console indicated that the creation of some DB assets that look like they may be landmarks were throwing errors. I am not sure what the visiting avatar saw as an error or asset creation message... but it may be a mismatch in the "description" field length allowed by OSGrid and the default set in dev master.

OpenSim.exe console:
13:23:36 - [Assets]: Upload failed: aa1b4295-5d5b-4154-a00d-8f603b2f9b25 type 3 will retry later
13:23:36 - [Assets]: Upload failed: f32ce319-89e9-4d92-9e1a-e8f540647e9f type 3 will retry later

Robust.exe console:
12:23:35 - [ASSET DB]: MySQL failure creating asset aa1b4295-5d5b-4154-a00d-8f603b2f9b25 with name "HG Openvue Welcome Island". Error: Data too long for column 'description' at row 1
12:23:35 - [ASSET DB]: MySQL failure creating asset f32ce319-89e9-4d92-9e1a-e8f540647e9f with name "Okaloosa Island". Error: Data too long for column 'description' at row 1

Both sets of messages are then repeated several times on the retries.

One thing that is surprising is that its an error rather than the description being shortened to fit the available DB field "description" length.

But also, my investigation indicates that we may still have serious issues with the asset table field length for "description" which is still 64 characters long in the latest MySQL DB settings in 0.9.1.0 dev master... though I thought it had been lengthened before to 128 characters.

I occasionally still see some yellow warnings (but not red errors) indicating trimming of description fields down to 64 characters, and a check of the Openvue grid 0.9.1.0 MyQQL database tables indicates that the Asset description length is set to varchar(64).

I thought this had been corrected and the description field lengthened to 128 characters before? See

     http://opensimulator.org/mantis/view.php?id=7476 [^]
     http://opensimulator.org/mantis/view.php?id=7350 [^]

But on checking now I see the description field is still set at length 64 on Openvue as a 0.9.1.0 dev master grid with no manual changes to the data bases other than the usual migrations taking place.

As reported some years ago, we know that 64 characters is far too short for some uses of the description field to hold URLs and data for things like Google spreadsheet avatar visitor trackers, where the URL definitely exceeds 64.... and if trimmed cannot work. Its also incompatible with Second Life decsription n field length, so scripts working there that use the description field will not work in the same way.
Revision 2016-11-24 05:54 by aiaustin
Description I spotted some errors on the consoles for the Openvue grid using 0.9.1.0 dev master while an OSGrid avatar was visiting via hypergrid. The console indicated that the creation of some DB assets that look like they may be landmarks were throwing errors. I am not sure what the visiting avatar saw as an error or asset creation message... but it may be a mismatch in the "description" field length allowed by OSGrid and the default set in dev master.

OpenSim.exe console:
13:23:36 - [Assets]: Upload failed: aa1b4295-5d5b-4154-a00d-8f603b2f9b25 type 3 will retry later
13:23:36 - [Assets]: Upload failed: f32ce319-89e9-4d92-9e1a-e8f540647e9f type 3 will retry later

Robust.exe console:
12:23:35 - [ASSET DB]: MySQL failure creating asset aa1b4295-5d5b-4154-a00d-8f603b2f9b25 with name "HG Openvue Welcome Island". Error: Data too long for column 'description' at row 1
12:23:35 - [ASSET DB]: MySQL failure creating asset f32ce319-89e9-4d92-9e1a-e8f540647e9f with name "Okaloosa Island". Error: Data too long for column 'description' at row 1

Both sets of messages are then repeated several times on the retries.

One thing that is surprising is that its an error rather than the description being shortened to fit the available DB field "description" length.

But also, my investigation indicates that we may still have serious issues with the asset table field length for "description" which is still 64 characters long in the latest MySQL DB settings in 0.9.1.0 dev master... though I thought it had been lengthened before to 128 characters.

I occasionally still see some yellow warnings (but not red errors) indicating trimming of description fields down to 64 characters, and a check of the Openvue grid 0.9.1.0 MyQQL database tables indicates that the Asset description length is set to varchar(64).

I thought this had been corrected and the description field lengthened to 128 characters before? See

     http://opensimulator.org/mantis/view.php?id=7476 [^]

But on checking now I see the description field is still set at length 64 on Openvue as a 0.9.1.0 dev master grid with no manual changes to the data bases other than the usual migrations taking place.

As reported some years ago, we know that 64 characters is far too short for some uses of the description field to hold URLs and data for things like Google spreadsheet avatar visitor trackers, where the URL definitely exceeds 64.... and if trimmed cannot work. Its also incompatible with Second Life decsription n field length, so scripts working there that use the description field will not work in the same way.
Revision 2016-11-24 05:45 by aiaustin
Description I spotted some errors on the consoles for the Openvue grid using 0.9.1.0 dev master while an OSGrid avatar was visiting via hypergrid. The console indicated that the creation of some DB assets that look like they may be landmarks were throwing errors. I am not sure what the visiting avatar saw as an error or asset creation message... but it may be a mismatch in the "description" field length allowed by OSGrid and the default set in dev master.

OpenSim.exe console:
13:23:36 - [Assets]: Upload failed: aa1b4295-5d5b-4154-a00d-8f603b2f9b25 type 3 will retry later
13:23:36 - [Assets]: Upload failed: f32ce319-89e9-4d92-9e1a-e8f540647e9f type 3 will retry later

Robust.exe console:
12:23:35 - [ASSET DB]: MySQL failure creating asset aa1b4295-5d5b-4154-a00d-8f603b2f9b25 with name "HG Openvue Welcome Island". Error: Data too long for column 'description' at row 1
12:23:35 - [ASSET DB]: MySQL failure creating asset f32ce319-89e9-4d92-9e1a-e8f540647e9f with name "Okaloosa Island". Error: Data too long for column 'description' at row 1

One things that is surprising is that its an error rather than the description being shortened to fit the available DB field "description" length.

But also, my investigation indicates that we may still have a serious issues with the asset table field length for "desc ription" which is still 64 cgaracters long in the latest MySQL DB settings in 0.9.1.0 dev master... though I thought it had been lengthened before to 255 (or 127?).

I occasionally still see some yellow warnings (but not red errors) indicating trimming of description fields down to 64 characters.

See http://opensimulator.org/mantis/view.php?id=7476 [^]

I thought this had been corrected and the description field lengthened to 255 characters before. See

But on checking now I see the description field is still set at length 64.

I know this is far too short fro some uses of the description field to hold URLs and data for things like Google spreadsheet avatar visitor trackers, where the URL definitely exceeds 64.... and if trimmed cannot work.



Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker