Question: Upgrade Script
0
gravatar for Victor Ruotti
6.8 years ago by
Victor Ruotti90 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 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 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)>
galaxy • 1.2k views
ADD COMMENTlink modified 6.8 years ago by Greg Von Kuster810 • written 6.8 years ago by Victor Ruotti90
0
gravatar for Greg Von Kuster
6.8 years ago by
Penn State University
Greg Von Kuster810 wrote:
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
ADD COMMENTlink written 6.8 years ago by Greg Von Kuster810
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 180 users visited in the last hour