set > innodb_log_file_size=128M in mysql configuration and restart On Thu, Mar 5, 2015 at 7:57 PM, CiderJack <[email protected]> wrote:
> Hmmm... while doing this has stopped generating that console error, a new > console error is now generated instead (and still unable to rez inworld): > > 13:08:33 - [ASSET DB]: MySQL failure creating asset > 8e9cd34e-57e2-4447-b6c8-6275 > 18a1556c with name From IAR. Exception MySql.Data.MySqlClient.MySqlException > ( > 0x80004005): Row size too large (> 8126). Changing some columns to TEXT or > BLOB > or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current > row fo > rmat, BLOB prefix of 768 bytes is stored inline. > at MySql.Data.MySqlClient.MySqlStream.ReadPacket() > at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, > Int32& i > nsertedId) > at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& > affected > Rows, Int32& insertedId) > at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) > at MySql.Data.MySqlClient.MySqlDataReader.NextResult() > at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior > behavior > ) > at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() > at OpenSim.Data.MySQL.MySQLAssetData.StoreAsset(AssetBase asset) > > > So this looks like more MySQL stuff, so presumably it now falls outside > the realm of this list (Or is this still OS database stuff?) and beyond my > area of knowledge. Unless there are further suggestions, it's looking like > I will just have to let it go. > > Anyway, thanks for the help. > > --- > ~!CJ > > > > On 2015-03-06 12:50, Michael Emory Cerquoni wrote: > >> You need to set max_allowed_packet=16M in your MySQL ini either >> /etc/my.cnf on linux or my.ini wherever that file lives on Windows, >> and then restart mysql, you should be ok after that, good luck! >> >> On Thu, Mar 5, 2015 at 5:56 PM, CiderJack >> <[email protected]> wrote: >> >> Thanks Justin. >>> >>> I finally remembered how to mark/copy text from the shell, so >>> here's one of the blocks of red text: >>> >>> 10:41:44 - [ASSET DB]: MySQL failure creating asset >>> 8e9cd34e-57e2-4447-b6c8-627518a1556c with name From IAR. Exception >>> MySql.Data.MySqlClient.MySqlException ( >>> 0x80004005): Packets larger than max_allowed_packet are not >>> allowed. >>> at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket >>> packet) >>> at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket >>> packetToExec >>> ute) >>> at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket >>> queryPacket) >>> at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) >>> at MySql.Data.MySqlClient.Statement.ExecuteNext() >>> at MySql.Data.MySqlClient.PreparableStatement.ExecuteNext() >>> at MySql.Data.MySqlClient.PreparableStatement.Execute() >>> at >>> MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior >>> behavior >>> ) >>> at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() >>> at OpenSim.Data.MySQL.MySQLAssetData.StoreAsset(AssetBase asset) >>> >>> Looking more closely I see "Packets larger than max_allowed_packet >>> are not allowed" although checking the usual .ini files >>> (OpenSim.ini, StandAloneCommon.ini) I am not finding anywhere to >>> change max_allwed_packet. >>> >>> Is this setting accessible to the end user, or is it buried in the >>> code somewhere? >>> >>> This appears to only have affected the Objects, everything else >>> seems intact (textures, sounds, scripts, etc.), so I'm wondering if >>> maybe my linksets have become ungainly (a few exceed 400 prims, some >>> by quite a bit) and this might be what makes the packets too large? >>> Most of what seems to have not loaded are larger linksets (~100-300) >>> although a few are smaller (< 50). Additionally I do have some large >>> linksets that appear to have loaded intact. >>> >>> Looks like around 100 objects in total are affected, and reasonably >>> large/major builds that are not easily replaced. I'd rather not just >>> give up on them if there is any way possible to recover them. >>> >>> --- >>> ~!CJ >>> >>> On 2015-03-06 08:44, Justin Clark-Casey wrote: >>> If those red blocks of text complain about corrupted assets then >>> that >>> may indeed be the case. If there are no other copies then they are >>> lost forever. >>> >>> On 04/03/15 11:26, CiderJack wrote: >>> When attempting to rez certain items from my inventory (loaded from >>> an iar), I am receiving error in viewer blue >>> dialogue box (upper right): >>> Unable to rez: could not find asset [then it shows the uuid & name >>> of the object] >>> >>> Console outputs in yellow text (with actual numbers & names in >>> brackets): >>> [InventoryAccessModule]: Could not find asset [uuid] for item [item >>> name] [different uuid] for [avatar name] in RezObject() >>> >>> Have rebooted both server & viewer to no effect. Have reloaded iar >>> file to no effect. >>> >>> However, while loading the iar file, several blocks of red text >>> show up headed [Asset DB]. Would these be corrupt items, >>> presumably the items that will not rez? >>> >>> Is this a problem anyone has had (nothing found in a web search)? >>> Are the lost items lost forever? Is there something I >>> can do to get those items to rez again? >>> >> >> _______________________________________________ >> Opensim-users mailing list >> [email protected] >> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users [1] >> >> -- >> >> Michael Emory Cerquoni >> >> Links: >> ------ >> [1] http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users >> >> _______________________________________________ >> Opensim-users mailing list >> [email protected] >> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users >> > _______________________________________________ > Opensim-users mailing list > [email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > -- Michael Emory Cerquoni
_______________________________________________ Opensim-users mailing list [email protected] http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
