Kallithea issues archive

Issue #272: gearbox setup-db failed

Reported by: tonich_sh
State: resolved
Created on: 2017-04-13 11:32
Updated on: 2017-04-15 14:26

Description

@0452c45a546c

gearbox setup-db -c development.ini --user=admin --password=qwerty --repo=/tmp

2017-04-13 14:30:23.672 DEBUG [tg.configuration.app_config] Initializing configuration, package: 'kallithea'
2017-04-13 14:30:23.673 DEBUG [tg.configuration.milestones] config_ready milestone reached
2017-04-13 14:30:23.674 DEBUG [tg.configuration.hooks] Registering <function setup_application at 0x7f2e81b7e9b0> for application wide hook before_config
2017-04-13 14:30:23.674 DEBUG [tg.configuration.hooks] Registering <function setup_configuration at 0x7f2e81b7e668> for application wide hook configure_new_app
2017-04-13 14:30:23.682 DEBUG [tg.configuration.milestones] renderers_ready milestone reached
2017-04-13 14:30:23.689 INFO  [kallithea.model.base] initializing db for sqlite:////mnt/src/kallithea/kallithea.db?timeout=60
2017-04-13 14:30:23.690 DEBUG [tg.configuration.milestones] environment_loaded milestone reached
2017-04-13 14:30:23.690 DEBUG [tg.appwrappers.i18n] i18n enabled: True -> {'lang': None, 'no_session_touch': False, 'lang_session_key': 'tg_lang', 'enabled': True}
2017-04-13 14:30:23.690 DEBUG [tg.appwrappers.identity] Identity enabled: False -> {'allow_missing_user': True, 'enabled': True, 'authmetadata': None}
2017-04-13 14:30:23.691 DEBUG [tg.appwrappers.session] Sessions enabled: True -> {'secret': 'development-not-secret', 'invalidate_corrupt': True, 'data_dir': '/mnt/src/kallithea/data/sessions', 'key': 'kallithea', 'timeout': 2592000, 'data_serializer': 'json', 'log_file': None, 'type': None, 'httponly': True}
2017-04-13 14:30:23.692 DEBUG [tg.appwrappers.caching] Caching enabled: True -> {'data_dir': '/mnt/src/kallithea/data/cache/data', 'cache_regions': {'long_term': {'expire': 36000, 'data_dir': '/mnt/src/kallithea/data/cache/data', 'type': 'memory', 'enabled': True, 'lock_dir': '/mnt/src/kallithea/data/cache/lock', 'key_length': 256}, 'sql_cache_short': {'expire': 10, 'data_dir': '/mnt/src/kallithea/data/cache/data', 'type': 'memory', 'enabled': True, 'lock_dir': '/mnt/src/kallithea/data/cache/lock', 'key_length': 256}, 'short_term': {'expire': 60, 'data_dir': '/mnt/src/kallithea/data/cache/data', 'type': 'memory', 'enabled': True, 'lock_dir': '/mnt/src/kallithea/data/cache/lock', 'key_length': 256}}, 'expire': None, 'log_file': None, 'type': 'memory', 'lock_dir': '/mnt/src/kallithea/data/cache/lock'}
2017-04-13 14:30:23.692 DEBUG [tg.appwrappers.mingflush] MingSessionFlush enabled: False -> {'autoflush': False}
2017-04-13 14:30:23.693 DEBUG [tg.appwrappers.transaction_manager] TransactionManager enabled: False -> {'attempts': 1, 'enabled': False, 'commit_veto': None}
2017-04-13 14:30:23.693 DEBUG [tg.appwrappers.errorpage] ErrorPageApplicationWrapper enabled: True -> {'content_types': ['text/html', None], 'handle_exceptions': False, 'path': '/error/document', 'status_codes': [400, 401, 403, 404], 'enabled': True}
2017-04-13 14:30:23.702 INFO  [kallithea.lib.auth] getting information about all available permissions
2017-04-13 14:30:23.849 INFO [sqlalchemy.engine.base.Engine] 
    SELECT 
     CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2017-04-13 14:30:23.851 INFO [sqlalchemy.engine.base.Engine] ()
2017-04-13 14:30:23.852 INFO [sqlalchemy.engine.base.Engine] 
    SELECT 
     CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2017-04-13 14:30:23.853 INFO [sqlalchemy.engine.base.Engine] ()
2017-04-13 14:30:23.854 INFO [sqlalchemy.engine.base.Engine] BEGIN (implicit)
2017-04-13 14:30:23.855 INFO [sqlalchemy.engine.base.Engine] 
    SELECT 
     permissions.permission_id AS permissions_permission_id,
     permissions.permission_name AS permissions_permission_name 
    FROM permissions
2017-04-13 14:30:23.857 INFO [sqlalchemy.engine.base.Engine] ()
2017-04-13 14:30:23.859 INFO [sqlalchemy.engine.base.Engine] ROLLBACK
2017-04-13 14:30:23.860 ERROR [gearbox] (sqlite3.OperationalError) no such table: permissions [SQL: u'SELECT permissions.permission_id AS permissions_permission_id, permissions.permission_name AS permissions_permission_name \nFROM permissions']
Traceback (most recent call last):
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/gearbox/main.py", line 167, in _run_subcommand
    return cmd.run(parsed_args)
  File "/mnt/src/kallithea/kallithea/lib/paster_commands/common.py", line 65, in run
    self._bootstrap_config(args.config_file)
  File "/mnt/src/kallithea/kallithea/lib/paster_commands/common.py", line 90, in _bootstrap_config
    make_app(conf.global_conf, **conf.local_conf)
  File "/mnt/src/kallithea/kallithea/config/middleware.py", line 46, in make_app
    app = make_base_app(global_conf, full_stack=full_stack, **app_conf)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/tg/configuration/app_config.py", line 1240, in make_base_app
    tg.hooks.notify('configure_new_app', args=(app,))
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/tg/configuration/hooks.py", line 109, in notify
    self._call_handler(hook_name, trap_exceptions, func, args, kwargs)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/tg/configuration/hooks.py", line 33, in _call_handler
    return func(*args, **kwargs)
  File "/mnt/src/kallithea/kallithea/config/app_cfg.py", line 142, in setup_configuration
    set_available_permissions(config)
  File "/mnt/src/kallithea/kallithea/lib/auth.py", line 728, in set_available_permissions
    all_perms = sa.query(Permission).all()
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2613, in all
    return list(self)
  File "/mnt/src/kallithea/kallithea/lib/caching_query.py", line 81, in __iter__
    return Query.__iter__(self)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2761, in __iter__
    return self._execute_and_instances(context)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2776, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/opt/git/.virtualenvs/kallithea/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) no such table: permissions [SQL: u'SELECT permissions.permission_id AS permissions_permission_id, permissions.permission_name AS permissions_permission_name \nFROM permissions']

Attachments

Comments

Comment by tonich_sh, on 2017-04-13 11:38

Comment by Thomas De Schampheleire, on 2017-04-13 20:12

Problem has been reported already by @tlvu and a fix proposed in pull request #318

Comment by Mads Kiilerich, on 2017-04-15 00:23

Please confirm it has been fixed by 304aae43194c .

Comment by Long Vu, on 2017-04-15 03:34

@kiilerix confirm fixed by 304aae43194c

Comment by Mads Kiilerich, on 2017-04-15 14:26

Thanks