Task #2578 (closed)
Opened 14 years ago
Closed 14 years ago
BUG: 4.1 upgrade doesn't start
Reported by: | wmoore | Owned by: | jamoore |
---|---|---|---|
Priority: | blocker | Milestone: | OMERO-Beta4.2 |
Component: | ORM | Version: | n.a. |
Keywords: | n.a. | Cc: | |
Resources: | n.a. | Referenced By: | n.a. |
References: | n.a. | Remaining Time: | n.a. |
Sprint: | 2010-06-24 (12) |
Description (last modified by wmoore)
Created a 4.1 db with user 'will' in default group. Imported a load of images, and an INCELL 1000 plate. Changed user into a different group 'fourOne' and then added tags, rating, comments, description to images. Put existing images into a new dataset. Also imported an image and made a Z-projection.
Followed db upgrade - no errors. But 4.2 server won't start.
Terminal output below. 4.2 server logs and 4.1 db attached.
Attachments (2)
Change History (4)
Changed 14 years ago by wmoore
comment:1 Changed 14 years ago by wmoore
- Description modified (diff)
- Owner set to jmoore
Macintosh-2:OMERO4.2__0 omero$ psql -v ON_ERROR_STOP=1 --pset pager=off -h localhost -U omero -f OMERO4.1__0.sql omero Password for user omero: BEGIN Timing is on. CREATE FUNCTION Time: 155.203 ms omero_assert_db_version ------------------------- (1 row) Time: 60.068 ms DROP FUNCTION Time: 43.522 ms INSERT 0 1 Time: 15.017 ms CREATE FUNCTION Time: 2.548 ms UPDATE 0 Time: 16.713 ms UPDATE 0 Time: 1.176 ms UPDATE 0 Time: 1.727 ms UPDATE 2 Time: 3.964 ms DELETE 0 Time: 3.634 ms DELETE 0 Time: 4.104 ms DELETE 0 Time: 1.828 ms Timing is off. CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION id | currentpatch | currentversion | permissions | finished | message | previouspatch | previousversion | external_id ----+--------------+----------------+-------------+----------------------------+-----------------+---------------+-----------------+------------- 1 | 0 | OMERO4.1 | -35 | 2010-07-08 12:10:00.371649 | Database ready. | 0 | OMERO4.1 | 2 | 0 | OMERO4.2 | -35 | | Updating | 0 | OMERO4.1 | (2 rows) 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 | fourOne | 0 | 88 | | 0 | 2 | 90 (5 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 4 | -1 | 0 | 2 | 81 | | 0 | 0 | 81 | 1 | 1 5 | -1 | 0 | 3 | 97 | | 0 | 0 | 97 | 4 | 0 6 | -1 | 0 | 3 | 97 | | 0 | 0 | 97 | 1 | 1 7 | -1 | 0 | 3 | 97 | | 0 | 0 | 97 | 2 | 2 8 | -1 | 0 | 2 | 3172 | | 0 | 0 | 3172 | 4 | 0 3 | -1 | 0 | 2 | 72 | | 0 | 0 | 72 | 2 | 2 (9 rows) CREATE FUNCTION CREATE FUNCTION psql:omero-4.1-permissions-report.sql:382: ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function "omero_41_check" line 43 at RETURN NEXT PL/pgSQL function "omero_41_check" line 14 at FOR over SELECT rows PL/pgSQL function "omero_41_check" line 6 at FOR over SELECT rows Macintosh-2:OMERO4.2__0 omero$ cd ../../../ Macintosh-2:OMERO-4.2.0-DEV-r7497-b3525 omero$ bin/omero admin start Creating directory /Users/omero/Desktop/OMERO-4.2.0-DEV-r7497-b3525/var Importing pre-4.2 preferences Creating /Users/omero/Desktop/OMERO-4.2.0-DEV-r7497-b3525/etc/grid/config.xml Creating /Users/omero/Desktop/OMERO-4.2.0-DEV-r7497-b3525/var/master Initializing /Users/omero/Desktop/OMERO-4.2.0-DEV-r7497-b3525/var/log Creating /Users/omero/Desktop/OMERO-4.2.0-DEV-r7497-b3525/var/registry No descriptor given. Using etc/grid/default.xml Waiting on startup. Use CTRL-C to exit ..........
comment:2 Changed 14 years ago by jmoore
- Component changed from General to ORM
- Priority changed from minor to blocker
- Resolution set to fixed
- Status changed from new to closed
The ERROR during the report prevented the upgrade from actually taking place, so it's understandable that the server wouldn't start. This is rather a Postgres version issue. r7505 fixes.
4.1 DB back up