BUG: 4.1 upgrade doesn't start

[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.

[wmoore]

4.1 DB back up

[wmoore]

4.2 server logs.

[wmoore]

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
..........