Database upgrade failure from 5.0.6 to 5.1.1
Posted: Thu Jun 11, 2015 3:54 pm
We have OMERO 5.0.6 running successfully on Ubuntu 14.03 and wish to upgrade to 5.1.
Following the upgrade instructions, I am unable to upgrade our database from 5.0.6 to 5.1.1. When I run the upgrade script, the terminal output has many lines of;
"ERROR: current transaction is aborted, commands ignored until end of transaction block"
and I never see the requested "Password for user ..."
Without the server running (it fails to start since the database version is wrong), the output from "omero admin diagnostics" is:
Previous upgrades have run without problems, so this is a mystery to me.
Wade
Following the upgrade instructions, I am unable to upgrade our database from 5.0.6 to 5.1.1. When I run the upgrade script, the terminal output has many lines of;
"ERROR: current transaction is aborted, commands ignored until end of transaction block"
and I never see the requested "Password for user ..."
Without the server running (it fails to start since the database version is wrong), the output from "omero admin diagnostics" is:
================================================================================
OMERO Diagnostics 5.1.1-ice35-b43
================================================================================
WARNING:omero.util.UpgradeCheck:UPGRADE AVAILABLE:Please upgrade to 5.1.2 See http://trac.openmicroscopy.org.uk/omero for the latest version
Commands: java -version 1.7.0 (/usr/bin/java)
Commands: python -V 2.7.6 (/usr/bin/python)
Commands: icegridnode --version 3.5.1 (/usr/bin/icegridnode)
Commands: icegridadmin --version 3.5.1 (/usr/bin/icegridadmin)
Commands: psql --version 9.3.7 (/usr/bin/psql)
Server: icegridnode running
Server: Blitz-0 active (pid = 16800, enabled)
Server: DropBox active (pid = 16812, enabled)
Server: FileServer active (pid = 16816, enabled)
Server: Indexer-0 active (pid = 16819, enabled)
Server: MonitorServer active (pid = 16821, enabled)
Server: OMERO.Glacier2 active (pid = 16823, enabled)
Server: OMERO.IceStorm active (pid = 16826, enabled)
Server: PixelData-0 active (pid = 16827, enabled)
Server: Processor-0 active (pid = 16836, enabled)
Server: Tables-0 active (pid = 16845, enabled)
Server: TestDropBox inactive (enabled)
Log dir: /home/omero/OMERO.server-5.1.1-ice35-b43/var/log exists
Log files: Blitz-0.log 21.0 KB errors=8 warnings=0
Log files: DropBox.log 1.0 KB errors=2 warnings=1
Log files: FileServer.log 0.0 KB
Log files: Indexer-0.log 2.0 MB errors=660 warnings=132
Log files: MonitorServer.log 0.0 KB
Log files: OMEROweb.log n/a
Log files: PixelData-0.log 1.0 MB errors=325 warnings=65
Log files: Processor-0.log 15.0 KB errors=8 warnings=4
Log files: Tables-0.log 16.0 KB errors=8 warnings=4
Log files: TestDropBox.log n/a
Log files: master.err 0.0 KB errors=0 warnings=2
Log files: master.out 0.0 KB
Log files: Total size 3.26 MB
Environment:OMERO_HOME=(unset)
Environment:OMERO_NODE=(unset)
Environment:OMERO_MASTER=(unset)
Environment:OMERO_TEMPDIR=(unset)
Environment:PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
Environment:PYTHONPATH=(unset)
Environment:ICE_HOME=(unset)
Environment:LD_LIBRARY_PATH=(unset)
Environment:DYLD_LIBRARY_PATH=(unset)
OMERO SSL port:4064
OMERO TCP port:4063
OMERO data dir:'/OMERO' Exists? True Is writable? True
OMERO temp dir:'/home/omero/omero/tmp' Exists? True Is writable? True (Size: 0)
JVM settings: Blitz -Xmx3600m -XX:MaxPermSize=1g # Settings({'system_memory': '24000'})
JVM settings: Indexer -Xmx2400m -XX:MaxPermSize=1g # Settings({'system_memory': '24000'})
JVM settings: Pixeldata -Xmx3600m -XX:MaxPermSize=1g # Settings({'system_memory': '24000'})
JVM settings: Repository -Xmx2400m -XX:MaxPermSize=1g # Settings({'system_memory': '24000'})
OMERO.web status... [NOT STARTED]
Previous upgrades have run without problems, so this is a mystery to me.
Wade