Skip to content

Instantly share code, notes, and snippets.

@silenius
Created May 31, 2016 09:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save silenius/4a662baff185c1765ee881a9f3443ea5 to your computer and use it in GitHub Desktop.
Save silenius/4a662baff185c1765ee881a9f3443ea5 to your computer and use it in GitHub Desktop.
----------
ID: ckan_bbpf_check_db
Function: cmd.run
Name: /usr/local/venvs/ckan_bbpf/bin/paster db version -c /usr/local/www/sites/ckan_bbpf/etc/ckan.ini
Result: False
Comment: Command "/usr/local/venvs/ckan_bbpf/bin/paster db version -c /usr/local/www/sites/ckan_bbpf/etc/ckan.ini" run
Started: 09:46:22.012760
Duration: 1936.275 ms
Changes:
----------
pid:
46337
retcode:
1
stderr:
Traceback (most recent call last):
File "/usr/local/venvs/ckan_bbpf/bin/paster", line 11, in <module>
sys.exit(run())
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/paste/script/command.py", line 102, in run
invoke(command, command_name, options, args[1:])
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/paste/script/command.py", line 141, in invoke
exit_code = runner.run(args)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/paste/script/command.py", line 236, in run
result = self.command()
File "/usr/local/venvs/ckan_bbpf/src/ckan/ckan/lib/cli.py", line 234, in command
self.version()
File "/usr/local/venvs/ckan_bbpf/src/ckan/ckan/lib/cli.py", line 398, in version
print Session.execute('select version from migrate_version;').fetchall()
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 149, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 981, in execute
clause, params or {})
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 727, in execute
return meth(self, multiparams, params)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 824, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 954, in _execute_context
context)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
exc_info
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
context)
File "/usr/local/venvs/ckan_bbpf/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation "migrate_version" does not exist
LINE 1: select version from migrate_version;
^
'select version from migrate_version;' {}
stdout:
----------
ID: ckan_bbpf_init_db
Function: cmd.run
Name: /usr/local/venvs/ckan_bbpf/bin/paster db init -c /usr/local/www/sites/ckan_bbpf/etc/ckan.ini
Result: True
Comment: Command "/usr/local/venvs/ckan_bbpf/bin/paster db init -c /usr/local/www/sites/ckan_bbpf/etc/ckan.ini" run
Started: 09:46:23.964631
Duration: 11756.014 ms
Changes:
----------
pid:
46349
retcode:
0
stderr:
2016-05-31 09:46:25,873 DEBUG [migrate.versioning.repository] Loading repository /usr/local/venvs/ckan_bbpf/src/ckan/ckan/migration...
2016-05-31 09:46:25,874 DEBUG [migrate.versioning.script.base] Loading script /usr/local/venvs/ckan_bbpf/src/ckan/ckan/migration/versions/001_add_existing_tables.py...
2016-05-31 09:46:25,874 DEBUG [migrate.versioning.script.base] Script /usr/local/venvs/ckan_bbpf/src/ckan/ckan/migration/versions/001_add_existing_tables.py loaded successfully
2016-05-31 09:46:35,634 DEBUG [migrate.versioning.repository] Repository /usr/local/venvs/ckan_bbpf/src/ckan/ckan/migration loaded successfully
2016-05-31 09:46:35,634 DEBUG [migrate.versioning.repository] Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'Ckan'), ('version_table', 'migrate_version'), ('required_dbs', '[]')]))])
stdout:
Initialising DB: SUCCESS
----------
Summary for sandbox.lan
-------------
Succeeded: 29 (changed=5)
Failed: 1
-------------
Total states run: 30
Total run time: 23.755 s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment