https://wiki.lhep.unibe.ch/index.php?action=history&feed=atom&title=Yet_another_problem_with_publication_to_OPFRAYet another problem with publication to OPFRA - Revision history2026-05-14T21:15:21ZRevision history for this page on the wikiMediaWiki 1.43.8https://wiki.lhep.unibe.ch/index.php?title=Yet_another_problem_with_publication_to_OPFRA&diff=517&oldid=prevLhep: 1 revision imported2015-03-18T07:49:29Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 09:49, 18 March 2015</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>Lhephttps://wiki.lhep.unibe.ch/index.php?title=Yet_another_problem_with_publication_to_OPFRA&diff=516&oldid=prevLhep at 18:02, 30 August 20082008-08-30T18:02:29Z<p></p>
<p><b>New page</b></p><div><pre><br />
Dear Igor,<br />
<br />
Elisabetta can delete the data set. After she deletes it, I will send you<br />
both the latest test version of publication software. Please do not retry<br />
with the current version. You can instead publish smaller data sets.<br />
Best regards<br />
<br />
Cristiano<br />
<br />
<br />
----- Original Message -----<br />
From: "Igor Kreslo" <Igor.Kreslo@cern.ch><br />
To: "Cristiano Bozza" <kryss@sa.infn.it><br />
Cc: <pennacc@ipnl.in2p3.fr><br />
Sent: Saturday, August 30, 2008 6:12 PM<br />
Subject: RE: Contact<br />
<br />
<br />
Dear Cristiano,<br />
<br />
ok, clear. I'll restart publication.<br />
The only question - how can I safely delete from OPFRA data set, which is<br />
not complete?<br />
Since this will probably happen again in future, the deleting tool is<br />
needed.<br />
<br />
Best regards, Igor.<br />
<br />
-----Original Message-----<br />
From: Cristiano Bozza [mailto:kryss@sa.infn.it]<br />
Sent: Sat 8/30/2008 2:39 PM<br />
To: Igor Kreslo<br />
Cc: pennacc@ipnl.in2p3.fr<br />
Subject: Re: Contact<br />
<br />
Dear Igor,<br />
<br />
unfortunately you hit a known problem of the current publication procedures.<br />
This error happens when the data set is very large, and takes long time. It<br />
is favoured by long-running queries and concurrent activity. The data set<br />
must be deleted and published again. This problem happened very frequently<br />
(even repeatably) at the beginning of August while publishing from LNGS to<br />
OPITA, and from OPITA to OPFRA. Now we have a set of test publication<br />
procedures, which appear to run very well from LNGS to OPITA, but have NEVER<br />
been tested in other connections. If you and Elisabetta are willing to test<br />
them, we can arrange. I have no other "safe" solution (it might even happen<br />
that if you publish again with the old version you don't hit the error, but<br />
I cannot guarantee).<br />
Best regards<br />
<br />
Cristiano<br />
<br />
<br />
<br />
<br />
----- Original Message -----<br />
From: "Igor Kreslo" <Igor.Kreslo@cern.ch><br />
To: "Cristiano Bozza" <kryss@sa.infn.it><br />
Sent: Saturday, August 30, 2008 10:57 AM<br />
Subject: RE: Contact<br />
<br />
<br />
Dear Cristiano,<br />
<br />
during publication of the brick 1022299 to the central DB<br />
the operation aborted at ~92% with the message:<br />
Error ORA-01555: snapshot too old: rollback segment number 5 with name<br />
"_SYSSMU5$" too small in PP_PUBLISH_OP<br />
What does this mean and what can be done to resume operation ?<br />
Regards,<br />
Igor.<br />
</pre></div>Lhep