Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

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)

fourOneDb (771.9 KB) - added by wmoore 14 years ago.
4.1 DB back up
log.zip (9.1 KB) - added by wmoore 14 years ago.
4.2 server logs.

Download all attachments as: .zip

Change History (4)

Changed 14 years ago by wmoore

4.1 DB back up

Changed 14 years ago by wmoore

4.2 server logs.

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.

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.111680 sec.)

We're Hiring!