<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">All appears to be working now. I did stop Omero, edit the file and then start Omero again. I updated the entries in the DB for the one file that I imported
and it now works as well. Running the ‘</span>select repo, count(*) from originalfile group by repo;<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">’ query only reports the one repository like I would expect.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">-Jason<o:p></o:p></span></p>
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></a></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> Josh Moore [mailto:josh@glencoesoftware.com]
<br>
<b>Sent:</b> Wednesday, November 19, 2014 2:56 PM<br>
<b>To:</b> Kotecki, Jason<br>
<b>Cc:</b> OME Users<br>
<b>Subject:</b> Re: [ome-users] Unhandled exception after migration<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><br>
<br>
On Wed, Nov 19, 2014 at 5:24 PM, Kotecki, Jason <<a href="mailto:Jason.Kotecki@vai.org">Jason.Kotecki@vai.org</a>> wrote:<br>
<br>
Hi Jason,<br>
<br>
> Josh, I just imported an image and it looks like it uploaded to the new repository.<br>
><br>
> select repo, count(*) from originalfile group by repo;<br>
> Repo Count<br>
> "" 87<br>
> "a652e6b8-be52-417e-b4d5-7921ffb93049" 6<br>
> "ScriptRepo" 16<br>
> "69b60b5f-cec8-42f6-8c33-668585685e61" 3894<br>
<br>
That makes some sense. I'd also assume you see no issues with thumbnails, downloads, etc. From your previous mail:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">The repo_uuid file contains:<br>
^@$a652e6b8-be52-417e-b4d5-7921ffb93049</span><o:p></o:p></p>
</blockquote>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">you can see that the new repository:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#500050"> 4 | 5652 | a652e6b8-be52-417e-b4d5-7921ffb93049 | Managed | /omero_repo2/ManagedRepository</span><o:p></o:p></p>
</blockquote>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">has become the ruler of this directory. I was hoping to find time to reproduce the steps today but didn't manage. After saving a copy of repo_uuid, my assumption is that if you stop OMERO, modify the UUID a652...049 to be:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 69b60b5f-cec8-42f6-8c33-668585685e61</span><o:p></o:p></p>
</blockquote>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">and restart your server, that all the old images will start working, and the newly imported images will start failing. Then you can either delete those new test images, or update the files in the DB to also point to the old repository.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">~Josh.<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
> -Jason<br>
><br>
> -----Original Message-----<br>
> From: Josh Moore [mailto:<a href="mailto:josh@glencoesoftware.com">josh@glencoesoftware.com</a>]<br>
> Sent: Tuesday, November 18, 2014 8:35 AM<br>
> To: Kotecki, Jason<br>
> Cc: OME Users<br>
> Subject: Re: [ome-users] Unhandled exception after migration<br>
><br>
> Hi Jason,<br>
><br>
> On Tue, Nov 18, 2014 at 3:13 AM, Kotecki, Jason <<a href="mailto:Jason.Kotecki@vai.org">Jason.Kotecki@vai.org</a>> wrote:<br>
> > Here's the result of the "select repo, count(*) from originalfile group by repo" query.<br>
> ><br>
> > "";87<br>
> > "69b60b5f-cec8-42f6-8c33-668585685e61";3894<br>
> > "ScriptRepo";16<br>
><br>
> So this says that only the original repository has any files, which is good. Could you also show us the contents of<br>
><br>
> /omero_repo2/ManagedRepository/.omero/repository<br>
><br>
><br>
> Also, do you know if the original copy from the Windows server would have preserved the .omero directory?<br>
><br>
> ~J.<br>
><br>
><br>
> > -Jason<br>
> ><br>
> > -----Original Message-----<br>
> > From: Josh Moore [mailto:<a href="mailto:josh@glencoesoftware.com">josh@glencoesoftware.com</a>]<br>
> > Sent: Monday, November 17, 2014 5:43 PM<br>
> > To: Kotecki, Jason<br>
> > Cc: OME Users<br>
> > Subject: Re: [ome-users] Unhandled exception after migration<br>
> ><br>
> > Hi Jason,<br>
> ><br>
> > On Nov 17, 2014, at 5:12 PM, Kotecki, Jason wrote:<br>
> ><br>
> >> ... In trying to troubleshoot this I came across this post: <a href="http://scanmail.trustwave.com/?c=129&d=xfXs1L19ZaBiN3lsHWe-h60-UDhLFmJyA76c9Wcq7Q&u=https%3a%2f%2ftrac%2eopenmicroscopy%2eorg%2euk%2fome%2fticket%2f12355">
http://scanmail.trustwave.com/?c=129&d=8crr1A1ejF4P3raxq_th5UCbK6-b78ipRJtZbcr9-Q&u=https%3a%2f%2ftrac%2eopenmicroscopy%2eorg%2euk%2fome%2fticket%2f12355</a> Could the problem be similar to this?<br>
> ><br>
> > I think that's the same issue you're seeing. Could you run the SQL listed and send it to us?<br>
> ><br>
> > select repo, count(*) from originalfile group by repo;<br>
> ><br>
> ><br>
> > On Nov 14, 2014, at 6:21 PM, Kotecki, Jason wrote:<br>
> ><br>
> >> Mark, I was able to run the omero fs repos command once I realized that it needed an Omero user and not a linux user. Here is the output:<br>
> >> # | Id | UUID | Type | Path<br>
> >> ---+------+--------------------------------------+---------+---------<br>
> >> ---+------+--------------------------------------+---------+---------<br>
> >> ---+------+--------------------------------------+---------+---------<br>
> >> ---+------+--------------------------------------+---------+---------<br>
> >> ---+------+--------------------------------------+---------+---------<br>
> >> ---+------+--------------------------------------+---------+---------<br>
> >> 0 | 1 | ScriptRepo | Script | /home/omero/OMERO.server-5.0.5-ice35-b47/lib/scripts<br>
> >> 1 | 2 | 69b60b5f-cec8-42f6-8c33-668585685e61 | Public | /omero_repo2/ManagedRepository<br>
> >> 2 | 3 | f06f1c35-1689-4283-ac0b-412f83a5cbd4 | Public | /omero_repo2<br>
> >> 3 | 5651 | 0d343001-6051-45a1-912e-659874f9d416 | Public |<br>
> >> /omero_repo2<br>
> >> 4 | 5652 | a652e6b8-be52-417e-b4d5-7921ffb93049 | Managed |<br>
> >> /omero_repo2/ManagedRepository<br>
> >><br>
> >> It looks like it created a new managed repository ' a652e6b8-be52-417e-b4d5-7921ffb93049' but my other repository has a type of Public. How can I delete the new managed repository and change the type of my old repository?<br>
> ><br>
> > Going back to a previous thread:<br>
> ><br>
> >> Colin, thanks for the reply. The omero.data.dir is correct and I am able to open all of the images. I just can't download them. One thing I had to do to the database was to update the paths in the pixels and originalfile tables to switch the slashes from
\ to /.<br>
> ><br>
> ><br>
> > I'm wondering if the OMERO logic for detecting repo equality is breaking on some of these modifications. Could you try to reconstruct the steps to date so we can try to reproduce? For example:<br>
> ><br>
> > * installed under Windows with omero.data.dir = C:\omero\data<br>
> > * moved to Linux; set omero.data.dir = /omero/data<br>
> > * executed SQL ...<br>
> ><br>
> > Cheers,<br>
> > ~Josh.<br>
> ><br>
> ><br>
> >> Thanks,<br>
> >> Jason<br>
> >><br>
> >> -----Original Message-----<br>
> >> From: ome-users<br>
> >> [mailto:<a href="mailto:ome-users-bounces@lists.openmicroscopy.org.uk">ome-users-bounces@lists.openmicroscopy.org.uk</a>] On Behalf Of<br>
> >> Mark Carroll<br>
> >> Sent: Friday, November 14, 2014 10:44 AM<br>
> >> To: <a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br>
> >> Subject: Re: [ome-users] Unhandled exception after migration<br>
> >><br>
> >> Dear Jason,<br>
> >><br>
> >> Are there any clues in your Blitz-0.log on the server when you try the failed download or the omero fs repos login? We would certainly be happy to help you diagnose any complaints from that log. I am coming to this thread a little late, but useful information
in general may be:<br>
> >><br>
> >> - Blitz-0.log extracts when wrong things happened<br>
> >> - output of bin/omero admin diagnostics<br>
> >> - any other information on how the server is configured (e.g. from<br>
> >> bin/omero config get, but don't include any passwords!)<br>
> >> - lines from the originalfile DB table or other relevant tables for the problem repositories and images, and any comments about how the paths and names in the table correspond to how the files on your actual disks are arranged.<br>
> >><br>
> >>> I'm suspicious of the name '<br>
> >> PublicRepository-69b60b5f-cec8-42f6-8c33-668585685e61'.<br>
> >> '69b60b5f-cec8-42f6-8c33-668585685e61' is my ManagedRepository. Looking at the repositories in the 'originalfile' table of the database, I do not see a PublicRepository. Should there be one?<br>
> >><br>
> >> This part is probably okay, at least: ManagedRepository is a subclass of PublicRepository, and it uses various methods from that class. It would also be good to make sure from psql that the output of this makes sense:<br>
> >><br>
> >> select path from originalfile where name = 'ManagedRepository' and<br>
> >> mimetype = 'Repository';<br>
> >><br>
> >> If it is most convenient for you, feel free to risk sending too much<br>
> >> information instead of too little: you can zip it all up and upload<br>
> >> it via<br>
> >> <a href="http://scanmail.trustwave.com/?c=129&d=8crr1A1ejF4P3raxq_th5UCbK6-b78">
http://scanmail.trustwave.com/?c=129&d=8crr1A1ejF4P3raxq_th5UCbK6-b78</a><br>
> >> ipRJRbPMmu-Q&u=http%3a%2f%2fqa%2eopenmicroscopy%2eorg%2euk%2fqa%2fupl<br>
> >> oad%2f<br>
> >><br>
> >> In the future, we are thinking that we really ought to write further documentation regarding moving OMERO's binary repository, as it can be tricky. Thank you for your patience as things are now!<br>
> >><br>
> >> Have a good weekend.<br>
> >><br>
> >> Cheers,<br>
> >><br>
> >> Mark<o:p></o:p></p>
</div>
</body>
</html>