[Opensim-users] Unable to rez: could not find asset

Fri Mar 6 02:05:23 UTC 2015

set > innodb_log_file_size=128M in mysql configuration and restart

On Thu, Mar 5, 2015 at 7:57 PM, CiderJack <opensim.users at katijackstudio.com>
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
>> <opensim.users at katijackstudio.com> 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
>>  Opensim-users at opensimulator.org
>>  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
>> Opensim-users at opensimulator.org
>> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>

-- 
Michael Emory Cerquoni
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20150305/84824d85/attachment.html>