Hello Victor,
The following statement in your log is concerning because it looks like something in your
environment got corrupted in some way.
Exception: Your database has version '90' but this code expects version
'79'.
Clean database schema migration upgrades go from smaller to larger numbers (e.g., 89 ->
90, 90 -> 91, etc). Your migrate_versions.version database table column has a value of
90, but your ~/lib/galaxy/model/migrate/versions sub-directory has scripts only up to
0079... (or so it seems). Not sure how best to fix the problem...
Greg Von Kuster
On Feb 21, 2012, at 2:21 PM, Victor Ruotti wrote:
Hi,
I'm trying to use the upgrade script given that the current schema is now version
90.
I get the following error.
Can anyone point me out, maybe there is something to do before upgrading?
thanks in advance.
Victor
----------------trying to start galaxy I get
Traceback (most recent call last):
File "/opt/galaxy/galaxy-dist-original/lib/galaxy/web/buildapp.py", line 82,
in app_factory
app = UniverseApplication( global_conf = global_conf, **kwargs )
File "/opt/galaxy/galaxy-dist-original/lib/galaxy/app.py", line 32, in
__init__
create_or_verify_database( db_url, kwargs.get( 'global_conf', {} ).get(
'__file__', None ), self.config.database_engine_options )
File "/opt/galaxy/galaxy-dist-original/lib/galaxy/model/migrate/check.py",
line 105, in create_or_verify_database
% ( db_schema.version, migrate_repository.versions.latest, config_arg ) )
Exception: Your database has version '90' but this code expects version
'79'. Please backup your database and then migrate the schema by running 'sh
manage_db.sh -c ./universe_wsgi.runner.ini upgrade'.
Removing PID file runner0.pid
--------------trying to upgrade
sh manage_db.sh -c ./universe_wsgi.runner.ini upgrade
Traceback (most recent call last):
File "./scripts/manage_db.py", line 63, in <module>
main( repository=repo, url=db_url )
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/shell.py",
line 150, in main
ret = command_func(**kwargs)
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/api.py",
line 221, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/api.py",
line 327, in _migrate
changeset = schema.changeset(version)
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/schema.py",
line 173, in changeset
changeset = self.repository.changeset(database, start_ver, version)
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/repository.py",
line 170, in changeset
changes = [self.version(v).script(database, op) for v in versions]
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/repository.py",
line 145, in version
return self.versions.version(*p, **k)
File
"/opt/galaxy/galaxy-dist-original/eggs/sqlalchemy_migrate-0.5.4-py2.6.egg/migrate/versioning/version.py",
line 125, in version
return self.versions[VerNum(vernum)]
KeyError: <VerNum(90)>
___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at
usegalaxy.org. Please keep all replies on the list by
using "reply all" in your mail client. For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:
http://lists.bx.psu.edu/listinfo/galaxy-dev
To manage your subscriptions to this and other Galaxy lists,
please use the interface at:
http://lists.bx.psu.edu/