[gpfsug-discuss] GUI: FILESYSTEM_MOUNT returns ERROR: duplicate key value violates unique constraint

[Oesterlin, Robert]

The command completed, and I re-ran the FILESYSTEM_MOUNT, but it failed the same way.

[root at ess1ems ~]# psql postgres postgres -c "delete from fscc.filesystem_mounts"
DELETE 20

/usr/lpp/mmfs/gui/cli/runtask FILESYSTEM_MOUNT -debug
10:32 AM
Operation Failed
10:32 AM
Error: debug: locale=en_US
debug: Running 'mmlsmount 'fs1' -Y ' on node localhost
debug: Running 'mmlsmount 'fs2' -Y ' on node localhost
debug: Running 'mmlsmount 'fs3' -Y ' on node localhost
debug: Running 'mmlsmount 'fs4' -Y ' on node localhost
debug: Running 'mmlsmount 'nrg1_tools' -Y ' on node localhost
debug: Running 'mmlsmount 'nrg5_tools' -Y ' on node localhost
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"
Detail: Key (host_name, cluster_id, devicename)=(ems1-hs, 16677155164911809171, nrg1_tools) already exists. Call getNextException to see other errors in the batch.


Bob Oesterlin
Sr Principal Storage Engineer, Nuance


From: <gpfsug-discuss-bounces at spectrumscale.org> on behalf of Alexander Wolf <A.Wolf-Reber at de.ibm.com>
Reply-To: gpfsug main discussion list <gpfsug-discuss at spectrumscale.org>
Date: Wednesday, March 17, 2021 at 10:10 AM
To: "gpfsug-discuss at spectrumscale.org" <gpfsug-discuss at spectrumscale.org>
Subject: [EXTERNAL] Re: [gpfsug-discuss] GUI: FILESYSTEM_MOUNT returns ERROR: duplicate key value violates unique constraint

CAUTION: This Email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments.
________________________________
I think

    psql postgres postgres -c "delete from fscc.filesystem_mounts"'

ran as root should do the trick.

Mit freundlichen Grüßen / Kind regards

[cid:image001.png at 01D71B19.07732D00]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gpfsug.org/pipermail/gpfsug-discuss_gpfsug.org/attachments/20210317/aa71a5d5/attachment-0002.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1135 bytes
Desc: image001.png
URL: <http://gpfsug.org/pipermail/gpfsug-discuss_gpfsug.org/attachments/20210317/aa71a5d5/attachment-0002.png>