<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >I think</div>
<div dir="ltr" > </div>
<div dir="ltr" > psql postgres postgres -c "delete from fscc.filesystem_mounts"'</div>
<div dir="ltr" > </div>
<div dir="ltr" >ran as root should do the trick.</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:16159683898093" 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:16159683898095" 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:16159683898094" 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 15:30<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;" >Can you give me details on how to do this? I tried this:<o:p></o:p></p>
<p style="margin: 0px;" ><o:p> </o:p></p>
<p style="margin: 0px;" >[root@ess1ems ~]# su postgres -c 'psql -d postgres -c "delete from fscc.filesystem_mounts"'<o:p></o:p></p>
<p style="margin: 0px;" >could not change directory to "/root"<o:p></o:p></p>
<p style="margin: 0px;" >psql: FATAL: Peer authentication failed for user "postgres"<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 9:19 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" >This is strange, the Java code should only try to insert rows that are not already there. If it was just the insert for the duplicate row we could ignore it. But this is a batch insert failing and therefore the FILESYSTEM_MOUNTS table does not get updated anymore. A quick fix is to launch the psql client and do a "delete from fscc.filesystem_mounts" to clear the table and run the FILESYSTEM_MOUNT task afterwards to repopulate it.<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><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=Ca33Jr06KzzO4hjuWcM4iQ5J_E1MZR_xSRWwuh6yfsw&m=rg4LOOKhonaORwtrzabpITMM7A6k8GLwlDTyyCYKn6k&s=MGL4i6DG2p1WlFvmP8S1oqNTZbSgrWoR7bzSbQUexiE&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=Ca33Jr06KzzO4hjuWcM4iQ5J_E1MZR_xSRWwuh6yfsw&m=rg4LOOKhonaORwtrzabpITMM7A6k8GLwlDTyyCYKn6k&s=MGL4i6DG2p1WlFvmP8S1oqNTZbSgrWoR7bzSbQUexiE&e=</a> </font></div></blockquote>
<div dir="ltr" > </div></div>
<BR>