<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >Well that is the point where you should open a ticket so that the GUI folks can do some proper analysis. Just looking at your snippet it looks like we queried mounts for nrg5_tools but then insert ones for nrg1_tools which is weird. I know the code loops over the filesystems individually.</div>
<div dir="ltr" > </div>
<div dir="ltr" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial;font-size:10.5pt" ><div dir="ltr" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Arial" size="2" >Mit freundlichen Grüßen / Kind regards</font> </font> </font> </font>
<p><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><img height="23" src="cid:16159683898096" width="605" ></font></font></font></p><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > </font> </font> </font>
<table border="0" cellpadding="0" cellspacing="0" > <tbody> <tr valign="top" > <td style="width: 0px;" valign="middle" width="202" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><img alt="" src="cid:16159683898098" style="width: 100px; height: 100px;" ></font>
<div><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font></div> <font face="Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font></font></td> <td style="width: 0px;" valign="middle" width="202" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > </font></td> <td style="width: 0px;" valign="middle" width="31" > <ul style="padding-left: 0pt; margin-left: 0px; list-style-type: none;" > <li><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font size="3" > </font></font></font></font></li> </ul> </td> <td style="width: 0px;" valign="middle" width="464" > <ul style="padding-left: 0pt; margin-left: 0px; list-style-type: none;" > <li><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><b><font face="Arial" size="3" >Dr. Alexander Wolf-Reber</font></b><br> <font face="Arial" size="1" >Spectrum Scale container native architect<br> Department M069 / Spectrum Scale Software Development<br> <br> +49-160-90540880<br> a.wolf-reber@de.ibm.com</font></font></font></font></li> </ul> </td> </tr> </tbody></table><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > <img height="23" src="cid:16159683898097" width="605" > </font> </font> </font>
<div><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><a href="https://www.ibm.com/privacy/us/en/" rel="noopener noreferrer" target="_blank" >IBM Data Privacy Statement</a></font></div><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > </font>
<p><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" ><font color="#999999" face="Arial" size="1" >IBM Deutschland Research & Development GmbH / Vorsitzende des Aufsichtsrats: Gregor Pillen / Geschäftsführung: Dirk Wittkopp<br>Sitz der Gesellschaft: Böblingen / Registergericht: Amtsgericht Stuttgart, HRB 243294</font></font></font></font></p><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > <font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<div dir="ltr" > </div>
<div dir="ltr" > </div>
<blockquote data-history-content-modified="1" data-history-expanded="1" dir="ltr" style="border-left:solid #aaaaaa 2px; margin-left:5px; padding-left:5px; direction:ltr; margin-right:0px" >----- Original message -----<br>From: "Oesterlin, Robert" <Robert.Oesterlin@nuance.com><br>Sent by: gpfsug-discuss-bounces@spectrumscale.org<br>To: gpfsug main discussion list <gpfsug-discuss@spectrumscale.org><br>Cc:<br>Subject: [EXTERNAL] Re: [gpfsug-discuss] GUI: FILESYSTEM_MOUNT returns ERROR: duplicate key value violates unique constraint<br>Date: Wed, Mar 17, 2021 17:10<br> <br><!--Notes ACF
<meta http-equiv="Content-Type" content="text/html; charset=utf8" >--> <!--[if !mso]><style></style><![endif]--><!--[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]-->
<div><p style="margin: 0px;" >The command completed, and I re-ran the FILESYSTEM_MOUNT, but it failed the same way.<o:p></o:p></p>
<p style="margin: 0px;" ><o:p> </o:p></p>
<p style="margin: 0px;" >[root@ess1ems ~]# psql postgres postgres -c "delete from fscc.filesystem_mounts"<o:p></o:p></p>
<p style="margin: 0px;" >DELETE 20<o:p></o:p></p>
<p style="margin: 0px;" ><o:p> </o:p></p>
<p style="margin: 0px;" >/usr/lpp/mmfs/gui/cli/runtask FILESYSTEM_MOUNT -debug<o:p></o:p></p>
<p style="margin: 0px;" >10:32 AM<o:p></o:p></p>
<p style="margin: 0px;" >Operation Failed<o:p></o:p></p>
<p style="margin: 0px;" >10:32 AM<o:p></o:p></p>
<p style="margin: 0px;" >Error: debug: locale=en_US<br>debug: Running 'mmlsmount 'fs1' -Y ' on node localhost<br>debug: Running 'mmlsmount 'fs2' -Y ' on node localhost<br>debug: Running 'mmlsmount 'fs3' -Y ' on node localhost<br>debug: Running 'mmlsmount 'fs4' -Y ' on node localhost<br>debug: Running 'mmlsmount 'nrg1_tools' -Y ' on node localhost<br>debug: Running 'mmlsmount 'nrg5_tools' -Y ' on node localhost<br>err: java.sql.BatchUpdateException: Batch entry 5 INSERT INTO FSCC.FILESYSTEM_MOUNTS (CLUSTER_ID, DEVICENAME, HOST_NAME, MOUNT_MODE, LAST_UPDATE) VALUES ('16677155164911809171','nrg1_tools','ems1-hs','RO','2021-03-17 11:32:38.830000-04'::timestamp) was aborted: ERROR: duplicate key value violates unique constraint "filesystem_mounts_pk"<br>Detail: Key (host_name, cluster_id, devicename)=(ems1-hs, 16677155164911809171, nrg1_tools) already exists. Call getNextException to see other errors in the batch.<o:p></o:p></p>
<p style="margin: 0px;" ><o:p> </o:p></p>
<div><p style="margin: 0px;" ><o:p> </o:p></p>
<p style="margin: 0px;" ><span style="font-size:12.0pt" >Bob Oesterlin<o:p></o:p></span></p>
<p style="margin: 0px;" ><span style="font-size:12.0pt" >Sr Principal Storage Engineer, Nuance<o:p></o:p></span></p></div>
<p style="margin: 0px;" ><o:p> </o:p></p>
<p style="margin: 0px;" ><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in" ><p style="margin: 0px;" ><b><span style="font-size:12.0pt;color:black" >From: </span></b><span style="font-size:12.0pt;color:black" ><gpfsug-discuss-bounces@spectrumscale.org> on behalf of Alexander Wolf <A.Wolf-Reber@de.ibm.com><br><b>Reply-To: </b>gpfsug main discussion list <gpfsug-discuss@spectrumscale.org><br><b>Date: </b>Wednesday, March 17, 2021 at 10:10 AM<br><b>To: </b>"gpfsug-discuss@spectrumscale.org" <gpfsug-discuss@spectrumscale.org><br><b>Subject: </b>[EXTERNAL] Re: [gpfsug-discuss] GUI: FILESYSTEM_MOUNT returns ERROR: duplicate key value violates unique constraint<o:p></o:p></span></p></div>
<div><p style="margin: 0px;" ><o:p> </o:p></p></div>
<div align="center" ><table border="1" cellpadding="0" cellspacing="0" > <tbody> <tr> <td style="width:100.0%;background:#FFEB9C;padding:0in 0in 0in 0in" width="100%" > <p align="center" style="text-align: center; margin: 0px;" ><b><span style="font-size:10.0pt;color:red" >CAUTION: </span></b><span style="font-size:10.0pt;color:black" >This Email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments.</span><o:p></o:p></p> </td> </tr> </tbody></table></div>
<div align="center" style="text-align: center; margin: 0px;" ><hr align="center" size="0" width="100%" ></div>
<div><div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" >I think<o:p></o:p></span></p></div>
<div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" > <o:p></o:p></span></p></div>
<div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" > psql postgres postgres -c "delete from fscc.filesystem_mounts"'<o:p></o:p></span></p></div>
<div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" > <o:p></o:p></span></p></div>
<div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" >ran as root should do the trick.<o:p></o:p></span></p></div>
<div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" > <o:p></o:p></span></p></div>
<div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><p style="margin: 0px;" ><span style="font-size:10.0pt;font-family:"Arial",sans-serif" >Mit freundlichen Grüßen / Kind regards</span><span style="font-size:10.0pt;font-family:"Verdana",sans-serif" > </span><span style="font-size:10.5pt;font-family:"Arial",sans-serif" ><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif" ><img height="24" id="_x0000_i1025" src="cid:image001.png@01D71B19.07732D00" style="width:6.302in;height:.25in" width="605" ></span><span style="font-size:10.5pt;font-family:"Arial",sans-serif" ><o:p></o:p></span></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<div><font face="Default Monospace,Courier New,Courier,monospace" size="2" >_______________________________________________<br>gpfsug-discuss mailing list<br>gpfsug-discuss at spectrumscale.org<br><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__gpfsug.org_mailman_listinfo_gpfsug-2Ddiscuss&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=IbxtjdkPAM2Sbon4Lbbi4w&m=9wVvU2JGu8kk60_rkUVBwR84NKAkfYjSxxNdTKbY3Dk&s=wKkPWxQO-O2mhz5iEJ0MIVNX6LTAK391l99FAl7QsGk&e=" target="_blank" >https://urldefense.proofpoint.com/v2/url?u=http-3A__gpfsug.org_mailman_listinfo_gpfsug-2Ddiscuss&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=IbxtjdkPAM2Sbon4Lbbi4w&m=9wVvU2JGu8kk60_rkUVBwR84NKAkfYjSxxNdTKbY3Dk&s=wKkPWxQO-O2mhz5iEJ0MIVNX6LTAK391l99FAl7QsGk&e=</a> </font></div></blockquote>
<div dir="ltr" > </div></div>
<BR>