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

[Michael Emory Cerquoni]

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
>



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