Change sync_acct to continue when it hits duplicate keys

[stephenlienharrell]

/hpcstats//accounting/2024-11-05.log
2024-11-05
Total number of existing entries: 2453
Total number of new entries: 685
Traceback (most recent call last):
File "/home/hpcstats/tacc_stats/dbload/sync_acct.py", line 94, in
sync_acct(entry.path, str(startdate.date()))
File "/home/hpcstats/tacc_stats/dbload/sync_acct.py", line 61, in sync_acct
mgr.copy(df.values.tolist())
File "/usr/local/lib/python3.6/site-packages/pgcopy/copy.py", line 296, in copy
self.copystream(datastream)
File "/usr/local/lib/python3.6/site-packages/pgcopy/copy.py", line 338, in copystream
raise e
File "/usr/local/lib/python3.6/site-packages/pgcopy/copy.py", line 334, in copystream
cursor.copy_expert(sql, datastream)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "job_data_pkey"
DETAIL: Key (jid)=(1214685) already exists.
CONTEXT: COPY job_data, line 1

[stephenlienharrell]

This is a duplicate of #56