• All submissions to this site are governed by Second Life Project Contribution Agreement. By submitting patches and other information using this site, you acknowledge that you have read, understood, and agreed to those terms.
Issue Details (XML | Word | Printable)

Key: SVC-483
Type: Bug Bug
Status: Reopened Reopened
Priority: Critical Critical
Assignee: Unassigned
Reporter: Laronzo Fitzgerald
Votes: 29
Watchers: 6
Operations

If you were logged in you would be able to see more operations.
2. Second Life Service - SVC

Script is missing from Database

Created: 29/Jul/07 05:49 PM   Updated: 10/Aug/09 05:36 PM
Return to search
Component/s: Scripts
Affects Version/s: 1.18.0, 1.24 Server, 1.26 Server, 1.27 Server
Fix Version/s: None

Environment:
Windows XP with 3G/GPRS card
All platforms.
Issue Links:
Duplicate
 
Relates

Linden Lab Issue ID: DEV-5485


 Description  « Hide
Hi,

At around 5:30PM PDT today I was saving a script when my connection to SL via 3G broke. I reconnected, restarted SL and opened the script again to find that I was receiving this error:

"Script is missing from database"

The script never loads, the window just says "Loading..."

The asset UUID also now returns: 00000000-0000-0000-0000-000000000000

The script still seems to exist as the object it was in still responds to commands that were in it like '/1 start' or '/1 stop' and the sit target which was the latest thing I had changed is the same as it was at my most recent save around 5:25PM PDT.

I'm guessing then there was an error in saving to the database and now the UUID's aren't matching or something?

I have sent Torley Linden a copy of this script as I saw she has been dealing with similar issues with other users.

Many thanks in advance, I hope this can be resolved fairly simply, perhaps looking it up in the database and reassigning the UUID or sending me the content of the lost script. I'm not an expert but I'm assuming that if the script is running normally in the object it must exist somewhere, in some state and thus be recoverable in some manner. Many thanks!

When I open the script I get the following in the Debug Console
_________________________________________________

INFO: LLTaskLSLBridge::openItem() 17af35a4-d829-cc4c-0b56-2cfb028d96a1

INFO: LLAssetStorage::getInvItemAsset: Starting transfer for inventory asset
17af35a4-d829-cc4c-0b56-2cfb028d96a1 owned by
e5cdcb84-3986-453a-9ff9-4dc1ae408bde,93b036db-3159-f86b-eaef-6929fc335ee2

INFO: LLAssetStorage::getInvItemAsset: Starting transfer for inventory asset
17af35a4-d829-cc4c-0b56-2cfb028d96a1 owned by
e5cdcb84-3986-453a-9ff9-4dc1ae408bde,93b036db-3159-f86b-eaef-6929fc335ee2

WARNING: LLTransferManager::processTransferInfo:
2caa26c7-77e2-618a-e746-b1194162dbab: Non-ok status, cleaning up

WARNING: LLTransferTargetVFile::completionCallback: Aborting vfile transfer for 000000000-0000-0000-000000000000

WARNING: LLTransferManager::processTransferInfo:
07e2b008-9730-c2d8-df9c-54c5b4ee777f: Non-ok status, cleaning up

WARNING: LLTransferTargetVFile::completionCallback: Aborting vfile transfer for 000000000-0000-0000-000000000000



 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
Torley Linden added a comment - 30/Jul/07 08:41 AM
Thanks Laronzo, I wonder if this is related to the problems we had over the weekend: http://blog.secondlife.com/2007/07/29/gridwide-slowdowns/

Laronzo Fitzgerald added a comment - 30/Jul/07 08:52 AM
Yes, lots of nasty little glitches there eek! Good luck with the fix guys and cheers for your time on my issue.

Lex Neva added a comment - 30/Jul/07 09:29 AM
I lost a script with the exact same sympoms recently. I'm very upset, since I spent a lot of time on this script. This is not due to the weekend slowdowns... or at least it has not fixed itself as of yet.

Lex Neva added a comment - 30/Jul/07 09:34 AM
Note: I'd really hate to see this issue shoved off in the corner until a few hundred people vote it up. That'd mean a few hundred cases of content loss!

Lex Neva added a comment - 30/Jul/07 09:34 AM
(raising priority to critical since this is a content loss bug)

Torley Linden added a comment - 30/Jul/07 09:59 AM
I am keeping an eye on this and will let Lindens working on content loss-related projects know too.

Laronzo Fitzgerald added a comment - 30/Jul/07 11:48 AM
Thanks for your vote Lex =) Sorry to hear you're experiencing a similar problem =(

Laronzo Fitzgerald added a comment - 30/Jul/07 11:52 AM
Yea I know it's pretty disconcerting and discouraging =\ I spent a good few days honing this particular script too and my last backup is about a week old. Hopefully it's recoverable though =)

Lex Neva added a comment - 31/Jul/07 09:23 AM
I spent MONTHS honing mine

fred charles added a comment - 05/Aug/07 09:48 AM
Same problem as in previous comments.

When I try to open the script, I get a blue pop-up error box that says: "Script is missing from database". The edit window just says: "Loading..."

This script is in a HUD I've been wearing for a while. This still works correctly (so at least the byte code must be on the system somewhere), but I can't see or edit the script anymore .

No backup of the script exists as I've been editing it in-situ ---- my fault, I know.

I guess I can rewrite the code if I need to, but its a bit of a pain.

Fred.


BlckCobra Shikami added a comment - 11/Aug/07 03:22 AM
I found a script I created a while ago is missing from database.
After verifying this in several regions I checked all copies and models (in my inventory and also in 3 independant vendors) of the product I use it in.
All copies give me a "missing from database".

This means I either have to rewrite it and replace it in all products and derived models I use it in - or I close my business
Just a matter of time until the first customers come and want a refund (I assume it's gone in their copies aswell).
This is absolutely a very critical issue ...


Laronzo Fitzgerald added a comment - 16/Aug/07 10:53 AM
This issue is still unresolved 2 1/2 weeks after the report - can you please give me an idea of the timescale you estimate this could take to be looked at and fixed? Is there an average resolution time for reported bugs? Many thanks, Laronzo.

Triple Peccable added a comment - 01/Sep/07 05:15 PM
I have had this error too, and found that if I add a new script to the object, then delete the new script, the "missing from database" script is back. That has worked everytime for me, but it didn't work for someone else who tried it. In my case I have always been actively working on scripts at the time of getting the error. It could be that after a certain amount of time has passed this "fix" no longer works.

LaeMi Qian added a comment - 05/Sep/07 04:58 AM
I have a number of scripts doing this - some my own, some freeware that I have been able to get into to edit originally.
They still run, just the access to the script is gone. Very frustrating!

Bridie Linden added a comment - 01/Oct/07 04:40 PM
Dupe of VWR-2148

Laronzo Fitzgerald added a comment - 02/Oct/07 05:54 AM - edited
This issue has NOT been resolved - Do you have any news as to suspected causes? Is it merely misplaced in the database, is it retrievable and so forth?

Cheers, Laronzo / Mark


Max Duesenburg added a comment - 27/Oct/07 01:12 PM
Sorry Bridie - while the two issues may be related, they are not duplicates.

In this case the script is 'missing from database' yet still functions. This has been around for a LONG time. In previous reports it was believed that what had happened was that the text version of the script had gone missing but the bytecode was still present - hence the retained functionality.

While the cause may well be the same as the cause of VWR-2148, the symptom certainly is not and hence needs to be considered separately.

Max Duesenburg


Max Duesenburg added a comment - 27/Oct/07 01:14 PM
Not a duplicate issue.

Nava Muni added a comment - 10/Nov/07 11:15 PM
I have been experiencing this problem for a LONG time, too.
However, for me, it only seems to affect scripts in attachments which haven't a corresponding script copy in my general inventory.
So yes - if I have an attachment with, say, 3 scripts - if two of the scripts were added by drag/drop from inventory, I can get to their source INSIDE the attached object. However, let's say the 3rd script - created in situ - has lost its source.

AmigaDragon Greatrex added a comment - 15/Dec/07 09:56 PM
I've had something like this myself, but not relating to a lost connection while saving. I have at least 1-2 scripts in objects that still function but won't load to edit them. I have at least one other that won't load to edit and doesn't even run.

AmigaDragon Greatrex added a comment - 15/Dec/07 09:59 PM
Do you think these lost scripts will ever be recoverable?

Boss Spectre added a comment - 31/Jan/08 01:05 PM
I have experienced this too. This is only a guess, but I believe this to be caused by a bug which rolls back an attachment to the last saved version in inventory when the viewer crashes (Or more correctly, fails to save the changes). Each time a script is saved, it gets a new UUID, the inventory of the attachment is updated (but not saved back to user inventory, normal behavior for attachments) and the previously saved script is tagged for trash collection (since no other objects ever contained it). Yet when a viewer crashes, attached objects appear to not get saved back to inventory, and the instance is lost, so they are simply left as they were in inventory when last detached. The result is an object which contains a script source UUID for text which was deleted when a new script was saved over the only instance of that particular script UUID. The bytecode still exists so the script still runs (if it was running at the time of the crash), yet the new UUID to the latest source has been lost. I'd guess it's still in the database somewhere, marked as active, but I have no idea if it could be easily found at LL.

Just offering a possible clue for the Lindens as to where to look, I believe this is caused by how altered attachments are discarded when a viewer crashes.

Defensively, when you get something you wish to back up, you can detach and copy the object, then reattach the copy to continue. For the more adventurous of you, if your viewer crashes while working on an attachment, the text for saved scripts can often be retrieved from your cache data file, if you have the resources to look in there you might find several copies, one of which is your last saved version.


Prismatica Palisades added a comment - 08/Apr/08 10:22 AM
Now its been over a week, and I'm still having the script not found problem it just says loading. I can't get it to be active and running and this is seriously impacting my sales as I can't package my products.

Talarus Luan added a comment - 15/May/08 08:55 PM
Just a question to everyone who is having this issue: are these scripts that are in attachments? I have lost two scripts to this bug, and both were in attachments. I have a sneaking suspicion that one vector of this problem has something to do with reference counting and garbage collection related to scripts (or any assets, really) in attachment prim inventories.

Jimmy Loveless added a comment - 17/Jun/08 08:55 PM
Experiencing "Script is missing from database."

The script is in fact in an attachment that i'm always wearing. The script is running, just can't open it.


knotsauce latte added a comment - 05/Aug/08 06:34 PM
So why is this not a top priority issue? Does LL even care that users are losing irreplaceable content?

Laronzo Fitzgerald added a comment - 03/Sep/08 04:55 PM - edited
bump

1 year and 2 months on and still, no response, fix or compensation to any users or developers who lost hours of development time, critical deadline script solutions for clients to this bug.

We've learnt the hard way to back up our scripts in RL and not rely on SL for this - but this shouldn't have to be the case.


Latif Khalifa added a comment - 10/Sep/08 05:12 PM
One of the most common script sets in SL, MLP1.2 has a script missing from database now. The set is freely available at

http://slurl.com/secondlife/Apukohai/30/151/94

And inside it ~pos script is "missing from the database". It seems that the asset server randomly deletes assets from time to time, and now it has hit one of the most popular SL scripts.

The asset disappearead about a week ago and the asset it is:

69692bc8-fe75-3c8c-e0c5-8d16ce49bcec.lsltext

Hope this info helps trace down the problem.


Ellla McMahon added a comment - 12/Sep/08 04:10 PM
Duplicate issues recently reported SVC-2940 & MISC-1541

Johan Durant added a comment - 13/Sep/08 08:46 AM
I noticed this issue with the ~pos script from MLP. And note that I tested both some of my items using that script, and a fresh copy obtained from Miffy Fluffy's pick.

On the main forum others have indicated that the issue only crops up on certain sims, and thus appears to be problem specific to the asset server connected to those sims.


Laronzo Fitzgerald added a comment - 13/Sep/08 09:34 AM - edited
Very interesting observation Johan - I think you're spot on. I'm convinced these scripts are all recoverable if someone applied some time working out a methodology of how to recover just one of these such scripts and then making those steps reproducable in an automated recovery program or feature.

How do you store your sim data Linden Labs? In essence, those of us who own regions with scripts missing have an active interest and right in recovering the data. Does the space which missing scripts sit on get overwritten like deleted ones would do - and so become irrecoverable once the space has been designated as writable? Or does it remain intact and there is simply a mismatch in the database such that the entry points to the wrong sector of the server for the data? Can this then be hunted down? These are simple but crucial questions, answers to which would bring much relief or conclusion to the anxieties of those suffering from this issue.

Assuming then that this is a sim by sim issue, since assets are stored on the server a sim is on, then those of us like myself who own the sim are entitled to know how their data is being stored and what do in emergencies like this, we have paid good money to own an active stake in the relevant server itself - just because we are effectively renting the server does not mean those rights are negated. A tenant in an apartment cannot be deprived of his gas, water or electricity supplies, his personal effects cannot be removed without explanation - the same applies here in a virtual context.

We have had no notification of what exactly has been done to look into this issue for well over a year, no notification of the steps being taken, the problems being encountered, the formalities, data structures, storage methods. I think it's about time we all heard some answers.


JoJo Mandel added a comment - 24/Sep/08 06:47 PM
Let my name add to the growing list of people affected by this ~pos script missing.

We need to send out a search party ASAP! It's affected 3 of my menu driven animation objects in my home. Others remain in tact. I can't figure out why only 3 were affected.


BlckCobra Shikami added a comment - 18/May/09 11:48 AM
Another script gone "missing from database"

Object was and is rezzed inworld. Script was written by me and is "missing from database now".
The object containing the script has not been touched for a while.
Owner Perms are still MCT, next owner perms: none. Object itself seems to be intact.

An incident some weeks ago showed another interesting effect. One of my sales server stopped working suddenly. When trying to open the scripts they ALL showed "missing from database". Support suggested to restart the sim. The result remained the same: The scripts were and are gone.

This still happens quite too often to be just a weird coincidence. No slowdowns or assert server problems have been reported at those times and the scripts remain missing.


BlckCobra Shikami added a comment - 10/Aug/09 09:42 AM
Another script missing from database.

Script was written and owned by me and inside an object which was and is inworld.
It was not touched for several weeks and just sitting there and waiting for me to finish it.
Interesting is what it has in common with the previous "missing scripts": they were in state "Not Running".