Dear Galaxy Team,
I am switching our Galaxy production service to a new machine, We are using Postgres as database server.
The existing database belongs to postgres version 8.3 and I took my instance's dump using postgres version 8.4.
I am able to restore my database on postgres 8.4, Except few tables were empty and with few strange
error message left on log file. I am not sure how many tables are empty, but I found table called 'job' returns 0 rows.
Original job table returns me 40733 rows.
excerpts from error log:
ERROR: insert or update on table "history_dataset_association_annotation_association" violates foreign key constraint "history_dataset_association_a_history_dataset_association__fkey"
DETAIL: Key (history_dataset_association_id)=(284985) is not present in table "history_dataset_association".
STATEMENT: ALTER TABLE ONLY history_dataset_association_annotation_association
ADD CONSTRAINT history_dataset_association_a_history_dataset_association__fkey FOREIGN KEY (history_dataset_association_id) REFERENCES history_dataset_association(id);
ERROR: insert or update on table "history_dataset_association_tag_association" violates foreign key constraint "history_dataset_association_t_history_dataset_association__fkey"
DETAIL: Key (history_dataset_association_id)=(387932) is not present in table "history_dataset_association".
STATEMENT: ALTER TABLE ONLY history_dataset_association_tag_association
In my knowledge we didn't do any manual transactions on Galaxy database and Could anyone let me know something
wrong at my end. I'm sure this has been covered somewhere but I haven't been able to find it on the Wiki or by searching the archives.
Thanks in advance, Vipin
Friedrich Miescher Laboratory of the Max Planck Society
Spemannstrasse 39, 72076
Tuebingen, Germany