<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >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.</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:16159683898090" 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:16159683898092" 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:16159683898091" 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" 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] [gpfsug-discuss] GUI: FILESYSTEM_MOUNT returns ERROR: duplicate key value violates unique constraint<br>Date: Wed, Mar 17, 2021 13:00<br> <br><!--Notes ACF
<meta http-equiv="Content-Type" content="text/html; charset=utf8" >-->
<div><p style="margin: 0px;" ><span style="font-size:11.0pt" >Anyone run into this error from the GUI task “FILESYSTEM_MOUNT” or ideas on how to fix it?<o:p></o:p></span></p>
<p style="margin: 0px;" ><span style="font-size:11.0pt" ><o:p> </o:p></span></p>
<p style="margin: 0px;" ><b><span style="font-size:11.0pt" >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 07:55:14.051000-04'::timestamp) was aborted: ERROR: duplicate key value violates unique constraint "filesystem_mounts_pk" Detail: Key (host_name, cluster_id, devicename)=(ems1-hs, 16677155164911809171, nrg1_tools) already exists. <o:p></o:p></span></b></p>
<p style="margin: 0px;" ><b><span style="font-size:11.0pt" ><o:p> </o:p></span></b></p>
<p style="margin: 0px;" ><b><span style="font-size:11.0pt" >Call getNextException to see other errors in the batch.,Batch entry 5 INSERT INTO FSCC.FILESYSTEM_MOUNTS (CLUSTER_ID, DEVICENAME, HOST_NAME, MOUNT_MODE, LAST_UPDATE) VALUES ('16677155164911809171','nrg5_tools','ems1-hs','RO','2021-03-17 07:55:15.686000-04'::timestamp) was aborted: ERROR: duplicate key value violates unique constraint "filesystem_mounts_pk" Detail: Key (host_name, cluster_id, devicename)=(ems1-hs, 16677155164911809171, nrg5_tools) already exists. Call getNextException to see other errors in the batch.</span></b><span style="font-size:11.0pt" ><o:p></o:p></span></p>
<p style="margin: 0px;" ><span style="font-size:11.0pt" ><o:p> </o:p></span></p>
<p style="margin: 0px;" ><span style="font-size:11.0pt" ><o:p> </o:p></span></p>
<p style="margin: 0px;" >Bob Oesterlin<o:p></o:p></p>
<p style="margin: 0px;" >Sr Principal Storage Engineer, Nuance<o:p></o:p></p>
<p style="margin: 0px;" >507-269-0413<o:p></o:p></p>
<p style="margin: 0px;" ><o:p> </o:p></p></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=xCgOgiX440Xjgbcee6C43kYGsj8IprFxLVhy0stdwEA&s=UiVNbeYhHJb-9_m-nItcnyEGqhtTSv7--vBrEF3ItVQ&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=xCgOgiX440Xjgbcee6C43kYGsj8IprFxLVhy0stdwEA&s=UiVNbeYhHJb-9_m-nItcnyEGqhtTSv7--vBrEF3ItVQ&e=</a> </font></div></blockquote>
<div dir="ltr" > </div></div>
<BR>