<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Thank you for the script, Fred. (I
haven't used it yet, I assume it works as advertised)<br>
<br>
This is a great way of addressing this issue for now.<br>
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.<br>
<br>
On 7/28/2015 5:04 PM, Fred Beckhusen wrote:<br>
</div>
<blockquote cite="mid:55B81896.2070609@mitsi.com" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
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. <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://opensimulator.org/mantis/view.php?id=7657">http://opensimulator.org/mantis/view.php?id=7657</a><br>
<br>
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. <br>
<br>
This is not a permanent fix. 7657 attempts to address that by
asking for a patch. <br>
<br>
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. <br>
<br>
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 <a moz-do-not-send="true"
class="moz-txt-link-freetext" href="http://www.outworldz.com">http://www.outworldz.com</a>.<br>
<br>
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. <br>
<br>
What we propose may seem to be a hack, but what else can be done?<br>
<br>
<font face="Calibri">Ferd Frederix, aka <br>
</font>Fred K. Beckhusen <br>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:fred@mitsi.com">fred@mitsi.com</a> <br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.outworldz.com">http://www.outworldz.com</a> <br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Opensim-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-dev@opensimulator.org">Opensim-dev@opensimulator.org</a>
<a class="moz-txt-link-freetext" href="http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev">http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>