-
Notifications
You must be signed in to change notification settings - Fork 16
Open
Description
In rare cases, array jobs can create job ids that are longer than 32 characters. Need to change the length of jids in the database. This will require a complete decompression of the database.
Error from sync_acct:
error in mrg.copy: duplicate key value violates unique constraint "job_data_pkey"
DETAIL: Key (jid)=(1732251_[53,55-57,60,62,64,67-74) already exists.
CONTEXT: COPY job_data, line 1
error in single insert: 22001 value too long for type character varying(32)
while executing INSERT INTO "job_data" ("jid","queue","account","username","submit_time","start_time","end_time","state","nhosts","ncores","timelimit","host_list","jobname","runtime","node_hrs") VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);
Metadata
Metadata
Assignees
Labels
No labels