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

[Oesterlin, Robert]

Can you give me details on how to do this? I tried this:

[root at ess1ems ~]# su postgres -c 'psql -d postgres -c "delete from fscc.filesystem_mounts"'
could not change directory to "/root"
psql: FATAL:  Peer authentication failed for user "postgres"


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 9:19 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.
________________________________
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gpfsug.org/pipermail/gpfsug-discuss_gpfsug.org/attachments/20210317/d2e9f442/attachment-0002.htm>