Thank you for the script, Fred. (I haven't used it yet, I assume it
works as advertised)
This is a great way of addressing this issue for now.
One of these days I can look into adding some preventive measures to, at
least, avoid bad assets from being further imported via OAR/IAR/HG. No
guarantees it's possible.
On 7/28/2015 5:04 PM, Fred Beckhusen wrote:
Mantis 7657 is a report on a bug related to bug 7514 that has been
corrupting assets since October 2014, is still doing so, and
apparently will do so forever.
http://opensimulator.org/mantis/view.php?id=7657
7657 includes a Perl program written by Jeff Kelley and I which we
have used to repair the damage to about 3500 assets out of 80K on our
two small grids.
This is not a permanent fix. 7657 attempts to address that by asking
for a patch.
Judging by our results, the script should make your customers happy to
get back a large number of broken assets. You should, of course, try
it on an backup database with updates disabled, (UPDATE => 0) as a
test. This will print a count of how many assets you have that are
spreading around and making everybody unhappy, and it will also save
the before and after blobs as text to disk for further analysis, if
you are into that.
In my case, it repaired about 1000 assets out of 35K. Jeff had about
2500 out of 40K. I blame my total on my partner's many attempts to
get new shoes. My standalone HG server can scan and repair about 5K
assets a minute. Having peeked in her inventory, that's a lot of
shoes per second. And I can finally rez the things I got from OSCC.
The Bad/Total ratio is at 4.3% now between our two small Windows
grids. I would love to hear how your grid fares, especially if any
corrupted assets have spread to Linux, as that may get attention and
a fix from Those Who Know How To Fix Things. If you make changes to
the Perl, I would appreciate any patches or advice direct to my
email. I plan to maintain this and other Perl DB code for
Opensimulator in the free script library at http://www.outworldz.com.
Unfortunately, the Perl must be applied periodically as the corrupted
assets will just travel the HG, and re-infect every database,
including both Linux and Windows machines. As well as OARs and IARs.
It appears from our studies that it will never stop, without a patch
to core.
What we propose may seem to be a hack, but what else can be done?
Ferd Frederix, aka
Fred K. Beckhusen
[email protected]
http://www.outworldz.com
_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
