[JIRA] Updated: (SVC-553) numerous reports of objects, notecards, scripts, gestures "missing from database"

Tyler Pera (JIRA) no-reply at lindenlab.cascadeo.com
Fri Nov 27 12:14:10 PST 2009

     [ http://jira.secondlife.com/browse/SVC-553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tyler Pera updated SVC-553:

    Affects Version/s: 1.32 Server
                           (was: 1.24 Server)
                           (was: 1.26 Server)

> numerous reports of objects, notecards, scripts, gestures "missing from database"
> ---------------------------------------------------------------------------------
>                 Key: SVC-553
>                 URL: http://jira.secondlife.com/browse/SVC-553
>             Project: 2. Second Life Service - SVC
>          Issue Type: Bug
>          Components: Inventory
>    Affects Versions: 1.32 Server
>         Environment: CPU: AMD (Unknown model) (2000 MHz)
> Memory: 2048 MB
> OS Version: Microsoft Windows XP Service Pack 3 (Build 2600)
> Graphics Card Vendor: ATI Technologies Inc.
> Graphics Card: Radeon X1650 Series
> OpenGL Version: 2.1.7873 Release
>            Reporter: Lex Neva
>            Priority: Critical
> It seems that there's a quiet epidemic of items coming up "missing from database".  The standard symptoms seem to be one of the following cases:
> 1. A script that's full permissions functions properly, but hwen the author attempts to view the LSL code, they get a blue popup in the lower left that says, "Script missing from database."
> 2. Opening a notecard that previously was viewable now results in a popup, "Notecard missing from database."
> 3. Upon logging in, one or more messages appear, saying "Gesture missing from database."
> 4. Objects that used to rez fine now give the error "Object missing from database." on rez.
> 5. (Cay Trudeau) I have lost all older items AND new items BASED on old items. Being a hair maker I always use old stuff as a starting point.  I have also lost TEXTURES which are supposed to be called as an UIID from my color changing scripts. Now even the EXISTING hairdos are useless. This is a SHOWSTOPPER for businesses.
> (I haven't heard of textures, clothing, or other item types being lost, but feel free to add to this list.)
> I've personally lost at least four items this way.  One is a hoverbike contained in and rezzed from an attachment I constantly wear.  Two were objects in a toy gun I occasionally use.  One is an AO script I spent over a year honing, and while it still functions, I can no longer get at the code to make improvements (this one hurts the most!)
> Many of my friends have seen "missing from database" errors.  In a recent informal poll, 7 of 8 people present had seen at least one "missing from databse" error, and some had seen several.  This JIRA seems to have a rash of related issues, none of which seem to have definitive resolutions, and some of which are resolved as duplicates in favor of each other.
> I suspect that there's an underlying asset loss problem quietly chewing up assets.  I know that it's difficult to chase down this kind of bug when there's no reproducible way to CAUSE an item to become "missing from database", but I think it's significant that many people across the grid seem to be quietly losing their items, and quite a few have actually found their way here to open duplicate issues (linked here).
> I reported the loss of my script to LL support via the support portal.  It was suggested that I 1) clear my cache, 2) log in to another region, 3) make sure that the missing items hadn't been "coalesced" during an object return, and 4) learn to use the inventory search system to find my items.  1 & 2 didn't help in my case, and don't seem to help in any of the cases I've heard of.  3 & 4 aren't applicable in the case of a script.  In all cases I've heard of, the inventory item exists in someone's inventory and can be copied and even handed to other residents, but rezzing it is impossible.  It doesn't matter which region you try to rez it in, or how long you wait, or whether there's currently grid instability.  The underlying asset is missing from the database.
> I remember this kind of error appearing a year or two back.  At that time, LL posted that they were having trouble with their garbage collection routine.  Assets were being erroneously marked as "not in use" and being shunted off to the "to be deleted" pile.  Some assets were, however, still in use, and were referenced in inventory items.  When an attempt was made to rez the item, the system realized the asset had been incorrectly garbage collected, and it was marked to be restored.  Eventually, so many "mistakes" of this sort were found that the entire garbage collection scheme was put on hold and ALL assets were restored.
> Here's a blog entry from that incident: http://blog.secondlife.com/2006/11/10/inventory-issues-its-not-just-you/
> I suspect that now, garbage collection is being attempted again.  In this case, there doesn't seem to be a failsafe, or if there is, maybe some items are falling through the cracks.  It seems that assets all across the grid are being lost, and that scares the heck out of me.  My items have been missing for over a month, and I have no illusions that I'll ever get them back.
> I know this isn't a reproducible issue, but it's clearly a widespread issue, and I really hope one or two devs can take a look at things and see if they can figure out how assets might be going missing.  It's incredibly devastating to lose content like this, when we're led to believe that LL holds all of our inventory items for all time.  There is no local backup solution offered, so we place our trust in LL to keep our data safe.
> 10/12: More information that bolsters my theory about garbage collection is in the latest blog post from LL about inventory loss reduction, located here: http://blog.secondlife.com/2007/10/12/inventory-loss-reduction-initiaitive/#more-1297
> Here's an excerpt:
> Asset Collection Improvement
> Assets are the items in your inventory and those you've rezzed onto land. When an asset is no longer in any Residents' inventory and not rezzed in any Region, then we collect it and set aside for deletion. However, because it is a very complex problem to determine which assets are not being used, there are cases where we accidentally collect an asset, which is still in someone's inventory. When you get an "Object cannot be found in inventory" error message, asset collection might be the cause. Fortunately, we have a program that is watching and puts the item back in your inventory within an hour if we still have it. So next time you get this error, do be sure to check back in an hour. We have just kicked off a project to improve asset collection to fix the underlying problem of accidentally collecting assets still in use.
> I think this explains several things.  It explains why some people have found weird combinations of logging into the beta grid and clearing cache while spinning in a circle and holding your breath to bring your inventory back.  It also explains why some people, like me, have found that our inventory never comes back; it's that key "if we still have it" phrase.  I think this means that many of us who haven't seen our inventory come back after an hour have lost our data forever.  Sigh.
> 11/08/07 --
> With yet another inventory loss, I think I'm able to draw a conclusion about what tends to lead to this type of inventory loss.  It seems that attachments, items in the inventory of attachments, and worn gestures seem to be especially susceptible.  Maybe this is just because we NOTICE more quickly when these items are missing, but it may be that something in the garbage collection algorithm doesn't handle attachments well.  Perhaps a race condition?

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://jira.secondlife.com/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


More information about the Jira-notify mailing list