[ome-users] DB upgrade errors (4.1.1 to 4.2 RC)
John Wallach
jmwallach at gmail.com
Thu Jul 8 22:54:42 BST 2010
Hi,
I am sending the attached report for help completing the upgrade to 4.2.
Thanks!
jmw
-------------- next part --------------
BEGIN
CREATE FUNCTION
omero_assert_db_version
-------------------------
(1 row)
DROP FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:omero-4.1-permissions-report.sql:33: NOTICE: aggregate omero_textcat_all(text) does not exist, skipping
DROP AGGREGATE
CREATE AGGREGATE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
id | currentpatch | currentversion | permissions | finished | message | previouspatch | previousversion | external_id
----+--------------+----------------+-------------+---------------------------+-----------------+---------------+-----------------+-------------
1 | 0 | OMERO4.1 | -35 | 2010-04-02 10:24:53.90655 | Database ready. | 0 | OMERO4.1 |
(1 row)
id | description | permissions | name | version | creation_id | external_id | group_id | owner_id | update_id
----+-------------+-------------+----------+---------+-------------+-------------+----------+----------+-----------
0 | | -35 | system | 0 | 0 | | 0 | 0 | 0
1 | | -35 | user | 0 | 0 | | 0 | 0 | 0
2 | | -35 | default | 0 | 0 | | 0 | 0 | 0
3 | | -35 | guest | 0 | 0 | | 0 | 0 | 0
4 | | -35 | scratch | 0 | 50573 | | 0 | 52 | 63351
5 | | -35 | hvanepps | 0 | 110576 | | 0 | 53 | 110592
(6 rows)
id | permissions | version | child | creation_id | external_id | group_id | owner_id | update_id | parent | child_index
----+-------------+---------+-------+-------------+-------------+----------+----------+-----------+--------+-------------
0 | -35 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0
1 | -35 | 0 | 0 | 0 | | 0 | 0 | 0 | 1 | 1
2 | -35 | 0 | 1 | 0 | | 0 | 0 | 0 | 3 | 0
5 | -1 | 0 | 2 | 68 | | 0 | 0 | 68 | 1 | 2
4 | -1 | 0 | 2 | 68 | | 0 | 0 | 68 | 0 | 0
3 | -1 | 0 | 2 | 68 | | 0 | 0 | 68 | 2 | 1
6 | -1 | 0 | 3 | 383 | | 0 | 0 | 383 | 2 | 0
7 | -1 | 0 | 3 | 383 | | 0 | 0 | 383 | 1 | 1
53 | -1 | 0 | 52 | 50580 | | 0 | 0 | 50580 | 4 | 0
54 | -1 | 0 | 52 | 50580 | | 0 | 0 | 50580 | 1 | 1
55 | -1 | 0 | 52 | 50580 | | 0 | 0 | 50580 | 2 | 2
56 | -1 | 0 | 53 | 110584 | | 0 | 2 | 110584 | 5 | 0
57 | -1 | 0 | 53 | 110584 | | 0 | 2 | 110584 | 1 | 1
58 | -1 | 0 | 54 | 116424 | | 0 | 0 | 116424 | 2 | 0
59 | -1 | 0 | 54 | 116477 | | 0 | 0 | 116477 | 1 | 1
(15 rows)
CREATE FUNCTION
CREATE FUNCTION
psql:omero-4.1-permissions-report.sql:394: ERROR:
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=1, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=2, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=3, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=4, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=5, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=6, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=51, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=52, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=53, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=56, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=59, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=62, group=5, owner=53, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=65, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=68, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=71, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=72, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=75, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=80, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=83, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=86, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=89, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=92, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=95, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=98, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=101, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=104, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=107, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=110, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=113, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=116, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=119, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=122, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=125, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=126, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=131, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=134, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=137, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=140, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=143, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=144, group=2, owner=3, perms=-rw----)
Warning: OriginalFile(id=2, group=0, owner=0, perms=Lr-r-r-) <--> JobOriginalFileLink.child(id=145, group=2, owner=3, perms=-rw----)
ERROR ON omero_41_check:
Your database has data which is incompatible with 4.2 and will need to be manually updated
Contact ome-users at openmicroscopy.org.uk for help adjusting your data.
More information about the ome-users
mailing list