The collections table in the database had multiple collections with the same id, and the collections_id_seq was at 2. I manually adjusted the IDs for the collections that had matching IDs, but it indicates that collection creation is not using the correct ID sequence.
The
collectionstable in the database had multiple collections with the sameid, and thecollections_id_seqwas at 2. I manually adjusted the IDs for the collections that had matching IDs, but it indicates that collection creation is not using the correct ID sequence.https://github.com/openaddresses/batch/blob/master/api/routes/collection.js#L112-L115
This is likely the cause for the
globalandcacollections having broken links on the website.