MIssing jobs on import because of length of jid

[stephenlienharrell]

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);