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
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

  http://lists.bx.psu.edu/

Reply via email to