Hi
I'm using version 1.103-1.git.5.682e0d9.el7.centos.. taken from the
https://copr.fedorainfracloud.org/coprs/g/copr/copr/package/copr-frontend/ repository, and
just rebuild for CentOS...
Should I use the 1.103-1.fc23 release instead???
Regards
Martin
[root@copr01 ~]# su - postgres -c 'dropdb coprdb'
[root@copr01 ~]# su - postgres -c 'PGPASSWORD=coprpass ; createdb -E UTF8 coprdb'
[root@copr01 ~]# cd /usr/share/copr/coprs_frontend/
[root@copr01 coprs_frontend]# ./manage.py create_db --alembic alembic.ini
--------------------------------------------------------------------------------
INFO in log [/usr/share/copr/coprs_frontend/coprs/log.py:48]:
logging configuration finished, config: <Config {'JSON_AS_ASCII': True,
'INTRANET_IPS': ['127.0.0.1', '192.168.20.0/24'],
'KRB5_LOGIN': {'RH': {'log_text': 'Krb5 login',
'URI': 'casalogic', 'email_domain': 'CASALOGIC.LAN'}},
'LOG_FILENAME': '/var/log/copr-frontend/frontend.log',
'DIST_GIT_URL': 'http://copr01.casalogic.lan/cgit',
'SQLALCHEMY_POOL_RECYCLE': None, 'OPENID_STORE':
'/var/lib/copr/data/openid_store', 'BACKEND_BASE_URL':
'http://copr01.casalogic.lan', 'SQLALCHEMY_ECHO': False,
'SQLALCHEMY_TRACK_MODIFICATIONS': True, 'SEND_LOGS_TO':
['root@localhost'], 'SQLALCHEMY_POOL_TIMEOUT': None,
'SQLALCHEMY_RECORD_QUERIES': None, 'SESSION_COOKIE_DOMAIN': None,
'SESSION_COOKIE_NAME': 'session', 'SRPM_STORAGE_DIR':
'/var/lib/copr/data/srpm_storage', 'KRB5_LOGIN_BASEURI':
'/krb5_login/', 'WHOOSHEE_DIR': '/var/lib/copr/data/whooshee',
'REDIS_PORT': 6379, 'SQLALCHEMY_NATIVE_UNICODE': None,
'MAX_CONTENT_LENGTH': None, 'API_TOKEN_LENGTH': 30, 'DATABASE':
'/var/lib/copr/data/copr.db', 'SEND_EMAILS': True,
'PERMANENT_SESSION_LIFETIME': datetime.timedelta(31),
'SQLALCHEMY_POOL_SIZE': None, 'SQLALCHEMY_MAX_OVERFLOW': None,
'SEND_LEGAL_TO': ['root@localhost'], 'TRAP_HTTP_EXCEPTIONS':
False, 'PRESERVE_CONTEXT_ON_EXCEPTION': None, 'BUILDER_IPS':
['127.0.0.1'], 'DATA_DIR': '/var/lib/copr/data',
'API_TOKEN_EXPIRATION': 180, 'BACKEND_PASSWORD': 'mjp123',
'SESSION_COOKIE_PATH': None, 'COPR_DIST_GIT_LOGS_URL':
'http://copr01.casalogic.lan/per-task-logs', 'LOGGER_NAME':
'coprs', 'SECRET_KEY': 'mjp123', 'OPENID_FS_STORE_PATH':
None, 'ENFORCE_PROTOCOL_FOR_BACKEND_URL': 'http',
'USE_ALLOWED_USERS': False, 'APPLICATION_ROOT': None,
'SERVER_NAME': None, 'PREFERRED_URL_SCHEME': 'http',
'TESTING': False, 'ENFORCE_PROTOCOL_FOR_FRONTEND_URL': 'http',
'ALLOWED_USERS': [], 'LOG_DIR': '/var/log/copr-frontend/',
'BLACKLISTED_GROUPS': ['fedorabugs', 'packager',
'provenpackager'], 'LOGGING_LEVEL': 10, 'USE_X_SENDFILE': False,
'SQLALCHEMY_DATABASE_URI':
'postgresql+psycopg2://copr-fe:coprpass@localhost/coprdb',
'SESSION_COOKIE_SECURE': False, 'REDIS_HOST': '127.0.0.1',
'DEBUG': True, 'SQLALCHEMY_COMMIT_ON_TEARDOWN': False,
'SQLALCHEMY_BINDS': None, 'REPO_GPGCHECK': 1,
'JSONIFY_PRETTYPRINT_REGULAR': True, 'PROPAGATE_EXCEPTIONS': None,
'TRAP_BAD_REQUEST_ERRORS': False, 'JSON_SORT_KEYS': True,
'SESSION_COOKIE_HTTPONLY': True, 'SEND_FILE_MAX_AGE_DEFAULT': 43200,
'PUBLIC_COPR_HOSTNAME': 'copr01.casalogic.lan'}>
--------------------------------------------------------------------------------
{'OpenID': <class 'flask_openid.OpenID'>,
'RedisConnectionProvider': <class
'coprs.helpers.RedisConnectionProvider'>,
'RedisSessionInterface': <class
'coprs.redis_session.RedisSessionInterface'>,
'SQLAlchemy': <class 'flask_sqlalchemy.SQLAlchemy'>,
'TeamsResponse': <class 'openid_teams.teams.TeamsResponse'>,
'URL_PREFIX': '/api_2',
'Whooshee': <class 'flask_whooshee.Whooshee'>,
'__builtins__': {'ArithmeticError': <type
'exceptions.ArithmeticError'>,
'AssertionError': <type
'exceptions.AssertionError'>,
'AttributeError': <type
'exceptions.AttributeError'>,
'BaseException': <type
'exceptions.BaseException'>,
'BufferError': <type 'exceptions.BufferError'>,
'BytesWarning': <type 'exceptions.BytesWarning'>,
'DeprecationWarning': <type
'exceptions.DeprecationWarning'>,
'EOFError': <type 'exceptions.EOFError'>,
'Ellipsis': Ellipsis,
'EnvironmentError': <type
'exceptions.EnvironmentError'>,
'Exception': <type 'exceptions.Exception'>,
'False': False,
'FloatingPointError': <type
'exceptions.FloatingPointError'>,
'FutureWarning': <type
'exceptions.FutureWarning'>,
'GeneratorExit': <type
'exceptions.GeneratorExit'>,
'IOError': <type 'exceptions.IOError'>,
'ImportError': <type 'exceptions.ImportError'>,
'ImportWarning': <type
'exceptions.ImportWarning'>,
'IndentationError': <type
'exceptions.IndentationError'>,
'IndexError': <type 'exceptions.IndexError'>,
'KeyError': <type 'exceptions.KeyError'>,
'KeyboardInterrupt': <type
'exceptions.KeyboardInterrupt'>,
'LookupError': <type 'exceptions.LookupError'>,
'MemoryError': <type 'exceptions.MemoryError'>,
'NameError': <type 'exceptions.NameError'>,
'None': None,
'NotImplemented': NotImplemented,
'NotImplementedError': <type
'exceptions.NotImplementedError'>,
'OSError': <type 'exceptions.OSError'>,
'OverflowError': <type
'exceptions.OverflowError'>,
'PendingDeprecationWarning': <type
'exceptions.PendingDeprecationWarning'>,
'ReferenceError': <type
'exceptions.ReferenceError'>,
'RuntimeError': <type 'exceptions.RuntimeError'>,
'RuntimeWarning': <type
'exceptions.RuntimeWarning'>,
'StandardError': <type
'exceptions.StandardError'>,
'StopIteration': <type
'exceptions.StopIteration'>,
'SyntaxError': <type 'exceptions.SyntaxError'>,
'SyntaxWarning': <type
'exceptions.SyntaxWarning'>,
'SystemError': <type 'exceptions.SystemError'>,
'SystemExit': <type 'exceptions.SystemExit'>,
'TabError': <type 'exceptions.TabError'>,
'True': True,
'TypeError': <type 'exceptions.TypeError'>,
'UnboundLocalError': <type
'exceptions.UnboundLocalError'>,
'UnicodeDecodeError': <type
'exceptions.UnicodeDecodeError'>,
'UnicodeEncodeError': <type
'exceptions.UnicodeEncodeError'>,
'UnicodeError': <type 'exceptions.UnicodeError'>,
'UnicodeTranslateError': <type
'exceptions.UnicodeTranslateError'>,
'UnicodeWarning': <type
'exceptions.UnicodeWarning'>,
'UserWarning': <type 'exceptions.UserWarning'>,
'ValueError': <type 'exceptions.ValueError'>,
'Warning': <type 'exceptions.Warning'>,
'ZeroDivisionError': <type
'exceptions.ZeroDivisionError'>,
'__debug__': True,
'__doc__': "Built-in functions, exceptions, and other
objects.\n\nNoteworthy: None is the `nil' object; Ellipsis represents `...' in
slices.",
'__import__': <built-in function __import__>,
'__name__': '__builtin__',
'__package__': None,
'abs': <built-in function abs>,
'all': <built-in function all>,
'any': <built-in function any>,
'apply': <built-in function apply>,
'basestring': <type 'basestring'>,
'bin': <built-in function bin>,
'bool': <type 'bool'>,
'buffer': <type 'buffer'>,
'bytearray': <type 'bytearray'>,
'bytes': <type 'str'>,
'callable': <built-in function callable>,
'chr': <built-in function chr>,
'classmethod': <type 'classmethod'>,
'cmp': <built-in function cmp>,
'coerce': <built-in function coerce>,
'compile': <built-in function compile>,
'complex': <type 'complex'>,
'copyright': Copyright (c) 2001-2013 Python Software
Foundation.
All Rights Reserved.
Copyright (c) 2000
BeOpen.com.
All Rights Reserved.
Copyright (c) 1995-2001 Corporation for National Research Initiatives.
All Rights Reserved.
Copyright (c) 1991-1995 Stichting Mathematisch Centrum, Amsterdam.
All Rights Reserved.,
'credits': Thanks to CWI, CNRI,
BeOpen.com, Zope Corporation
and a cast of thousands
for supporting Python development. See
www.python.org for more information.,
'delattr': <built-in function delattr>,
'dict': <type 'dict'>,
'dir': <built-in function dir>,
'divmod': <built-in function divmod>,
'enumerate': <type 'enumerate'>,
'eval': <built-in function eval>,
'execfile': <built-in function execfile>,
'exit': Use exit() or Ctrl-D (i.e. EOF) to exit,
'file': <type 'file'>,
'filter': <built-in function filter>,
'float': <type 'float'>,
'format': <built-in function format>,
'frozenset': <type 'frozenset'>,
'getattr': <built-in function getattr>,
'globals': <built-in function globals>,
'hasattr': <built-in function hasattr>,
'hash': <built-in function hash>,
'help': Type help() for interactive help, or help(object) for
help about object.,
'hex': <built-in function hex>,
'id': <built-in function id>,
'input': <built-in function input>,
'int': <type 'int'>,
'intern': <built-in function intern>,
'isinstance': <built-in function isinstance>,
'issubclass': <built-in function issubclass>,
'iter': <built-in function iter>,
'len': <built-in function len>,
'license': See
http://www.python.org/2.7/license.html,
'list': <type 'list'>,
'locals': <built-in function locals>,
'long': <type 'long'>,
'map': <built-in function map>,
'max': <built-in function max>,
'memoryview': <type 'memoryview'>,
'min': <built-in function min>,
'next': <built-in function next>,
'object': <type 'object'>,
'oct': <built-in function oct>,
'open': <built-in function open>,
'ord': <built-in function ord>,
'pow': <built-in function pow>,
'print': <built-in function print>,
'property': <type 'property'>,
'quit': Use quit() or Ctrl-D (i.e. EOF) to exit,
'range': <built-in function range>,
'raw_input': <built-in function raw_input>,
'reduce': <built-in function reduce>,
'reload': <built-in function reload>,
'repr': <built-in function repr>,
'reversed': <type 'reversed'>,
'round': <built-in function round>,
'set': <type 'set'>,
'setattr': <built-in function setattr>,
'slice': <type 'slice'>,
'sorted': <built-in function sorted>,
'staticmethod': <type 'staticmethod'>,
'str': <type 'str'>,
'sum': <built-in function sum>,
'super': <type 'super'>,
'tuple': <type 'tuple'>,
'type': <type 'type'>,
'unichr': <built-in function unichr>,
'unicode': <type 'unicode'>,
'vars': <built-in function vars>,
'xrange': <type 'xrange'>,
'zip': <built-in function zip>},
'__doc__': None,
'__file__': '/usr/share/copr/coprs_frontend/coprs/__init__.pyc',
'__name__': 'coprs',
'__package__': 'coprs',
'__path__': ['/usr/share/copr/coprs_frontend/coprs'],
'admin_general': <module 'coprs.views.admin_ns.admin_general' from
'/usr/share/copr/coprs_frontend/coprs/views/admin_ns/admin_general.pyc'>,
'admin_ns': <module 'coprs.views.admin_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/admin_ns/__init__.pyc'>,
'api_general': <module 'coprs.views.api_ns.api_general' from
'/usr/share/copr/coprs_frontend/coprs/views/api_ns/api_general.pyc'>,
'api_ns': <module 'coprs.views.api_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/api_ns/__init__.pyc'>,
'app': <Flask 'coprs'>,
'backend_general': <module 'coprs.views.backend_ns.backend_general'
from
'/usr/share/copr/coprs_frontend/coprs/views/backend_ns/backend_general.pyc'>,
'backend_ns': <module 'coprs.views.backend_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/backend_ns/__init__.pyc'>,
'config': <module 'coprs.config' from
'/usr/share/copr/coprs_frontend/coprs/config.pyc'>,
'constants': <module 'coprs.constants' from
'/usr/share/copr/coprs_frontend/coprs/constants.pyc'>,
'context_processors': <module 'coprs.context_processors' from
'/usr/share/copr/coprs_frontend/coprs/context_processors.pyc'>,
'coprs': <module 'coprs' from
'/usr/share/copr/coprs_frontend/coprs/__init__.pyc'>,
'coprs_builds': <module 'coprs.views.coprs_ns.coprs_builds' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_builds.pyc'>,
'coprs_chroots': <module 'coprs.views.coprs_ns.coprs_chroots' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_chroots.pyc'>,
'coprs_general': <module 'coprs.views.coprs_ns.coprs_general' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_general.pyc'>,
'coprs_ns': <module 'coprs.views.coprs_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/__init__.pyc'>,
'coprs_packages': <module 'coprs.views.coprs_ns.coprs_packages' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_packages.pyc'>,
'db': <SQLAlchemy
engine='postgresql+psycopg2://copr-fe:coprpass@localhost/coprdb'>,
'exceptions': <module 'coprs.exceptions' from
'/usr/share/copr/coprs_frontend/coprs/exceptions.pyc'>,
'filters': <module 'coprs.filters' from
'/usr/share/copr/coprs_frontend/coprs/filters.pyc'>,
'flask': <module 'flask' from
'/usr/lib/python2.7/site-packages/flask/__init__.pyc'>,
'forms': <module 'coprs.forms' from
'/usr/share/copr/coprs_frontend/coprs/forms.pyc'>,
'groups_general': <module 'coprs.views.groups_ns.groups_general' from
'/usr/share/copr/coprs_frontend/coprs/views/groups_ns/groups_general.pyc'>,
'groups_ns': <flask.blueprints.Blueprint object at 0x3e7a050>,
'helpers': <module 'coprs.helpers' from
'/usr/share/copr/coprs_frontend/coprs/helpers.pyc'>,
'include_banner': <function include_banner at 0x3ff98c0>,
'inject_fedmenu': <function inject_fedmenu at 0x3ff9f50>,
'log': <module 'coprs.log' from
'/usr/share/copr/coprs_frontend/coprs/log.pyc'>,
'logic': <module 'coprs.logic' from
'/usr/share/copr/coprs_frontend/coprs/logic/__init__.pyc'>,
'misc': <module 'coprs.views.misc' from
'/usr/share/copr/coprs_frontend/coprs/views/misc.pyc'>,
'models': <module 'coprs.models' from
'/usr/share/copr/coprs_frontend/coprs/models.pyc'>,
'models_committed': <blinker.base.NamedSignal object at 0x2dcb510;
'models-committed'>,
'oid': <flask_openid.OpenID object at 0x35d8410>,
'os': <module 'os' from '/usr/lib64/python2.7/os.pyc'>,
'pprint': <function pprint at 0x2919de8>,
'rcp': <coprs.helpers.RedisConnectionProvider object at 0x3bf0f50>,
'recent_general': <module 'coprs.views.recent_ns.recent_general' from
'/usr/share/copr/coprs_frontend/coprs/views/recent_ns/recent_general.pyc'>,
'recent_ns': <module 'coprs.views.recent_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/recent_ns/__init__.pyc'>,
'redis_session': <module 'coprs.redis_session' from
'/usr/share/copr/coprs_frontend/coprs/redis_session.pyc'>,
'register_api_error_handler': <function register_api_error_handler at
0x424f500>,
'rest_api': <module 'coprs.rest_api' from
'/usr/share/copr/coprs_frontend/coprs/rest_api/__init__.pyc'>,
'rest_api_bp': <flask.blueprints.Blueprint object at 0x41f1d90>,
'rmodels': <module 'coprs.rmodels' from
'/usr/share/copr/coprs_frontend/coprs/rmodels.pyc'>,
'setup_log': <function setup_log at 0x3a84938>,
'stats_receiver': <module 'coprs.views.stats_ns.stats_receiver' from
'/usr/share/copr/coprs_frontend/coprs/views/stats_ns/stats_receiver.pyc'>,
'status_general': <module 'coprs.views.status_ns.status_general' from
'/usr/share/copr/coprs_frontend/coprs/views/status_ns/status_general.pyc'>,
'status_ns': <module 'coprs.views.status_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/status_ns/__init__.pyc'>,
'tmp_general': <module 'coprs.views.tmp_ns.tmp_general' from
'/usr/share/copr/coprs_frontend/coprs/views/tmp_ns/tmp_general.pyc'>,
'tmp_ns': <module 'coprs.views.tmp_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/tmp_ns/__init__.pyc'>,
'views': <module 'coprs.views' from
'/usr/share/copr/coprs_frontend/coprs/views/__init__.pyc'>,
'webhooks_general': <module 'coprs.views.webhooks_ns.webhooks_general'
from
'/usr/share/copr/coprs_frontend/coprs/views/webhooks_ns/webhooks_general.pyc'>,
'webhooks_ns': <flask.blueprints.Blueprint object at 0x3ffa810>,
'whooshee': <flask_whooshee.Whooshee object at 0x35d8990>,
'whoosheers': <module 'coprs.whoosheers' from
'/usr/share/copr/coprs_frontend/coprs/whoosheers.pyc'>,
'with_statement': _Feature((2, 5, 0, 'alpha', 1), (2, 6, 0,
'alpha', 0), 32768)}
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running stamp_revision -> 414a86b37a0f
[root@copr01 coprs_frontend]# COPR_CONFIG=/etc/copr/copr.conf alembic downgrade
3ec22e1db75a
--------------------------------------------------------------------------------
INFO in log [/usr/share/copr/coprs_frontend/coprs/log.py:48]:
logging configuration finished, config: <Config {'JSON_AS_ASCII': True,
'INTRANET_IPS': ['127.0.0.1', '192.168.20.0/24'],
'KRB5_LOGIN': {'RH': {'log_text': 'Krb5 login',
'URI': 'casalogic', 'email_domain': 'CASALOGIC.LAN'}},
'LOG_FILENAME': '/var/log/copr-frontend/frontend.log',
'DIST_GIT_URL': 'http://copr01.casalogic.lan/cgit',
'SQLALCHEMY_POOL_RECYCLE': None, 'OPENID_STORE':
'/var/lib/copr/data/openid_store', 'BACKEND_BASE_URL':
'http://copr01.casalogic.lan', 'SQLALCHEMY_ECHO': False,
'SQLALCHEMY_TRACK_MODIFICATIONS': True, 'SEND_LOGS_TO':
['root@localhost'], 'SQLALCHEMY_POOL_TIMEOUT': None,
'SQLALCHEMY_RECORD_QUERIES': None, 'SESSION_COOKIE_DOMAIN': None,
'SESSION_COOKIE_NAME': 'session', 'SRPM_STORAGE_DIR':
'/var/lib/copr/data/srpm_storage', 'KRB5_LOGIN_BASEURI':
'/krb5_login/', 'WHOOSHEE_DIR': '/var/lib/copr/data/whooshee',
'REDIS_PORT': 6379, 'SQLALCHEMY_NATIVE_UNICODE': None,
'MAX_CONTENT_LENGTH': None, 'API_TOKEN_LENGTH': 30, 'DATABASE':
'/var/lib/copr/data/copr.db', 'SEND_EMAILS': True,
'PERMANENT_SESSION_LIFETIME': datetime.timedelta(31),
'SQLALCHEMY_POOL_SIZE': None, 'SQLALCHEMY_MAX_OVERFLOW': None,
'SEND_LEGAL_TO': ['root@localhost'], 'TRAP_HTTP_EXCEPTIONS':
False, 'PRESERVE_CONTEXT_ON_EXCEPTION': None, 'BUILDER_IPS':
['127.0.0.1'], 'DATA_DIR': '/var/lib/copr/data',
'API_TOKEN_EXPIRATION': 180, 'BACKEND_PASSWORD': 'mjp123',
'SESSION_COOKIE_PATH': None, 'COPR_DIST_GIT_LOGS_URL':
'http://copr01.casalogic.lan/per-task-logs', 'LOGGER_NAME':
'coprs', 'SECRET_KEY': 'mjp123', 'OPENID_FS_STORE_PATH':
None, 'ENFORCE_PROTOCOL_FOR_BACKEND_URL': 'http',
'USE_ALLOWED_USERS': False, 'APPLICATION_ROOT': None,
'SERVER_NAME': None, 'PREFERRED_URL_SCHEME': 'http',
'TESTING': False, 'ENFORCE_PROTOCOL_FOR_FRONTEND_URL': 'http',
'ALLOWED_USERS': [], 'LOG_DIR': '/var/log/copr-frontend/',
'BLACKLISTED_GROUPS': ['fedorabugs', 'packager',
'provenpackager'], 'LOGGING_LEVEL': 10, 'USE_X_SENDFILE': False,
'SQLALCHEMY_DATABASE_URI':
'postgresql+psycopg2://copr-fe:coprpass@localhost/coprdb',
'SESSION_COOKIE_SECURE': False, 'REDIS_HOST': '127.0.0.1',
'DEBUG': True, 'SQLALCHEMY_COMMIT_ON_TEARDOWN': False,
'SQLALCHEMY_BINDS': None, 'REPO_GPGCHECK': 1,
'JSONIFY_PRETTYPRINT_REGULAR': True, 'PROPAGATE_EXCEPTIONS': None,
'TRAP_BAD_REQUEST_ERRORS': False, 'JSON_SORT_KEYS': True,
'SESSION_COOKIE_HTTPONLY': True, 'SEND_FILE_MAX_AGE_DEFAULT': 43200,
'PUBLIC_COPR_HOSTNAME': 'copr01.casalogic.lan'}>
--------------------------------------------------------------------------------
INFO [coprs] logging configuration finished, config: <Config {'JSON_AS_ASCII':
True, 'INTRANET_IPS': ['127.0.0.1', '192.168.20.0/24'],
'KRB5_LOGIN': {'RH': {'log_text': 'Krb5 login',
'URI': 'casalogic', 'email_domain': 'CASALOGIC.LAN'}},
'LOG_FILENAME': '/var/log/copr-frontend/frontend.log',
'DIST_GIT_URL': 'http://copr01.casalogic.lan/cgit',
'SQLALCHEMY_POOL_RECYCLE': None, 'OPENID_STORE':
'/var/lib/copr/data/openid_store', 'BACKEND_BASE_URL':
'http://copr01.casalogic.lan', 'SQLALCHEMY_ECHO': False,
'SQLALCHEMY_TRACK_MODIFICATIONS': True, 'SEND_LOGS_TO':
['root@localhost'], 'SQLALCHEMY_POOL_TIMEOUT': None,
'SQLALCHEMY_RECORD_QUERIES': None, 'SESSION_COOKIE_DOMAIN': None,
'SESSION_COOKIE_NAME': 'session', 'SRPM_STORAGE_DIR':
'/var/lib/copr/data/srpm_storage', 'KRB5_LOGIN_BASEURI':
'/krb5_login/', 'WHOOSHEE_DIR': '/var/lib/copr/data/whooshee',
'REDIS_PORT': 6379, 'SQLALCHEMY_NATIVE_UNICODE': None,
'MAX_CONTENT_LENGTH': None, 'API_TOKEN_LENGTH': 30, 'DATABASE':
'/var/lib/copr/data/copr.db', 'SEND_EMAILS': True,
'PERMANENT_SESSION_LIFETIME': datetime.timedelta(31),
'SQLALCHEMY_POOL_SIZE': None, 'SQLALCHEMY_MAX_OVERFLOW': None,
'SEND_LEGAL_TO': ['root@localhost'], 'TRAP_HTTP_EXCEPTIONS':
False, 'PRESERVE_CONTEXT_ON_EXCEPTION': None, 'BUILDER_IPS':
['127.0.0.1'], 'DATA_DIR': '/var/lib/copr/data',
'API_TOKEN_EXPIRATION': 180, 'BACKEND_PASSWORD': 'mjp123',
'SESSION_COOKIE_PATH': None, 'COPR_DIST_GIT_LOGS_URL':
'http://copr01.casalogic.lan/per-task-logs', 'LOGGER_NAME':
'coprs', 'SECRET_KEY': 'mjp123', 'OPENID_FS_STORE_PATH':
None, 'ENFORCE_PROTOCOL_FOR_BACKEND_URL': 'http',
'USE_ALLOWED_USERS': False, 'APPLICATION_ROOT': None,
'SERVER_NAME': None, 'PREFERRED_URL_SCHEME': 'http',
'TESTING': False, 'ENFORCE_PROTOCOL_FOR_FRONTEND_URL': 'http',
'ALLOWED_USERS': [], 'LOG_DIR': '/var/log/copr-frontend/',
'BLACKLISTED_GROUPS': ['fedorabugs', 'packager',
'provenpackager'], 'LOGGING_LEVEL': 10, 'USE_X_SENDFILE': False,
'SQLALCHEMY_DATABASE_URI':
'postgresql+psycopg2://copr-fe:coprpass@localhost/coprdb',
'SESSION_COOKIE_SECURE': False, 'REDIS_HOST': '127.0.0.1',
'DEBUG': True, 'SQLALCHEMY_COMMIT_ON_TEARDOWN': False,
'SQLALCHEMY_BINDS': None, 'REPO_GPGCHECK': 1,
'JSONIFY_PRETTYPRINT_REGULAR': True, 'PROPAGATE_EXCEPTIONS': None,
'TRAP_BAD_REQUEST_ERRORS': False, 'JSON_SORT_KEYS': True,
'SESSION_COOKIE_HTTPONLY': True, 'SEND_FILE_MAX_AGE_DEFAULT': 43200,
'PUBLIC_COPR_HOSTNAME': 'copr01.casalogic.lan'}>
{'OpenID': <class 'flask_openid.OpenID'>,
'RedisConnectionProvider': <class
'coprs.helpers.RedisConnectionProvider'>,
'RedisSessionInterface': <class
'coprs.redis_session.RedisSessionInterface'>,
'SQLAlchemy': <class 'flask_sqlalchemy.SQLAlchemy'>,
'TeamsResponse': <class 'openid_teams.teams.TeamsResponse'>,
'URL_PREFIX': '/api_2',
'Whooshee': <class 'flask_whooshee.Whooshee'>,
'__builtins__': {'ArithmeticError': <type
'exceptions.ArithmeticError'>,
'AssertionError': <type
'exceptions.AssertionError'>,
'AttributeError': <type
'exceptions.AttributeError'>,
'BaseException': <type
'exceptions.BaseException'>,
'BufferError': <type 'exceptions.BufferError'>,
'BytesWarning': <type 'exceptions.BytesWarning'>,
'DeprecationWarning': <type
'exceptions.DeprecationWarning'>,
'EOFError': <type 'exceptions.EOFError'>,
'Ellipsis': Ellipsis,
'EnvironmentError': <type
'exceptions.EnvironmentError'>,
'Exception': <type 'exceptions.Exception'>,
'False': False,
'FloatingPointError': <type
'exceptions.FloatingPointError'>,
'FutureWarning': <type
'exceptions.FutureWarning'>,
'GeneratorExit': <type
'exceptions.GeneratorExit'>,
'IOError': <type 'exceptions.IOError'>,
'ImportError': <type 'exceptions.ImportError'>,
'ImportWarning': <type
'exceptions.ImportWarning'>,
'IndentationError': <type
'exceptions.IndentationError'>,
'IndexError': <type 'exceptions.IndexError'>,
'KeyError': <type 'exceptions.KeyError'>,
'KeyboardInterrupt': <type
'exceptions.KeyboardInterrupt'>,
'LookupError': <type 'exceptions.LookupError'>,
'MemoryError': <type 'exceptions.MemoryError'>,
'NameError': <type 'exceptions.NameError'>,
'None': None,
'NotImplemented': NotImplemented,
'NotImplementedError': <type
'exceptions.NotImplementedError'>,
'OSError': <type 'exceptions.OSError'>,
'OverflowError': <type
'exceptions.OverflowError'>,
'PendingDeprecationWarning': <type
'exceptions.PendingDeprecationWarning'>,
'ReferenceError': <type
'exceptions.ReferenceError'>,
'RuntimeError': <type 'exceptions.RuntimeError'>,
'RuntimeWarning': <type
'exceptions.RuntimeWarning'>,
'StandardError': <type
'exceptions.StandardError'>,
'StopIteration': <type
'exceptions.StopIteration'>,
'SyntaxError': <type 'exceptions.SyntaxError'>,
'SyntaxWarning': <type
'exceptions.SyntaxWarning'>,
'SystemError': <type 'exceptions.SystemError'>,
'SystemExit': <type 'exceptions.SystemExit'>,
'TabError': <type 'exceptions.TabError'>,
'True': True,
'TypeError': <type 'exceptions.TypeError'>,
'UnboundLocalError': <type
'exceptions.UnboundLocalError'>,
'UnicodeDecodeError': <type
'exceptions.UnicodeDecodeError'>,
'UnicodeEncodeError': <type
'exceptions.UnicodeEncodeError'>,
'UnicodeError': <type 'exceptions.UnicodeError'>,
'UnicodeTranslateError': <type
'exceptions.UnicodeTranslateError'>,
'UnicodeWarning': <type
'exceptions.UnicodeWarning'>,
'UserWarning': <type 'exceptions.UserWarning'>,
'ValueError': <type 'exceptions.ValueError'>,
'Warning': <type 'exceptions.Warning'>,
'ZeroDivisionError': <type
'exceptions.ZeroDivisionError'>,
'__debug__': True,
'__doc__': "Built-in functions, exceptions, and other
objects.\n\nNoteworthy: None is the `nil' object; Ellipsis represents `...' in
slices.",
'__import__': <built-in function __import__>,
'__name__': '__builtin__',
'__package__': None,
'abs': <built-in function abs>,
'all': <built-in function all>,
'any': <built-in function any>,
'apply': <built-in function apply>,
'basestring': <type 'basestring'>,
'bin': <built-in function bin>,
'bool': <type 'bool'>,
'buffer': <type 'buffer'>,
'bytearray': <type 'bytearray'>,
'bytes': <type 'str'>,
'callable': <built-in function callable>,
'chr': <built-in function chr>,
'classmethod': <type 'classmethod'>,
'cmp': <built-in function cmp>,
'coerce': <built-in function coerce>,
'compile': <built-in function compile>,
'complex': <type 'complex'>,
'copyright': Copyright (c) 2001-2013 Python Software
Foundation.
All Rights Reserved.
Copyright (c) 2000
BeOpen.com.
All Rights Reserved.
Copyright (c) 1995-2001 Corporation for National Research Initiatives.
All Rights Reserved.
Copyright (c) 1991-1995 Stichting Mathematisch Centrum, Amsterdam.
All Rights Reserved.,
'credits': Thanks to CWI, CNRI,
BeOpen.com, Zope Corporation
and a cast of thousands
for supporting Python development. See
www.python.org for more information.,
'delattr': <built-in function delattr>,
'dict': <type 'dict'>,
'dir': <built-in function dir>,
'divmod': <built-in function divmod>,
'enumerate': <type 'enumerate'>,
'eval': <built-in function eval>,
'execfile': <built-in function execfile>,
'exit': Use exit() or Ctrl-D (i.e. EOF) to exit,
'file': <type 'file'>,
'filter': <built-in function filter>,
'float': <type 'float'>,
'format': <built-in function format>,
'frozenset': <type 'frozenset'>,
'getattr': <built-in function getattr>,
'globals': <built-in function globals>,
'hasattr': <built-in function hasattr>,
'hash': <built-in function hash>,
'help': Type help() for interactive help, or help(object) for
help about object.,
'hex': <built-in function hex>,
'id': <built-in function id>,
'input': <built-in function input>,
'int': <type 'int'>,
'intern': <built-in function intern>,
'isinstance': <built-in function isinstance>,
'issubclass': <built-in function issubclass>,
'iter': <built-in function iter>,
'len': <built-in function len>,
'license': See
http://www.python.org/2.7/license.html,
'list': <type 'list'>,
'locals': <built-in function locals>,
'long': <type 'long'>,
'map': <built-in function map>,
'max': <built-in function max>,
'memoryview': <type 'memoryview'>,
'min': <built-in function min>,
'next': <built-in function next>,
'object': <type 'object'>,
'oct': <built-in function oct>,
'open': <built-in function open>,
'ord': <built-in function ord>,
'pow': <built-in function pow>,
'print': <built-in function print>,
'property': <type 'property'>,
'quit': Use quit() or Ctrl-D (i.e. EOF) to exit,
'range': <built-in function range>,
'raw_input': <built-in function raw_input>,
'reduce': <built-in function reduce>,
'reload': <built-in function reload>,
'repr': <built-in function repr>,
'reversed': <type 'reversed'>,
'round': <built-in function round>,
'set': <type 'set'>,
'setattr': <built-in function setattr>,
'slice': <type 'slice'>,
'sorted': <built-in function sorted>,
'staticmethod': <type 'staticmethod'>,
'str': <type 'str'>,
'sum': <built-in function sum>,
'super': <type 'super'>,
'tuple': <type 'tuple'>,
'type': <type 'type'>,
'unichr': <built-in function unichr>,
'unicode': <type 'unicode'>,
'vars': <built-in function vars>,
'xrange': <type 'xrange'>,
'zip': <built-in function zip>},
'__doc__': None,
'__file__': '/usr/share/copr/coprs_frontend/coprs/__init__.pyc',
'__name__': 'coprs',
'__package__': 'coprs',
'__path__': ['/usr/share/copr/coprs_frontend/coprs'],
'admin_general': <module 'coprs.views.admin_ns.admin_general' from
'/usr/share/copr/coprs_frontend/coprs/views/admin_ns/admin_general.pyc'>,
'admin_ns': <module 'coprs.views.admin_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/admin_ns/__init__.pyc'>,
'api_general': <module 'coprs.views.api_ns.api_general' from
'/usr/share/copr/coprs_frontend/coprs/views/api_ns/api_general.pyc'>,
'api_ns': <module 'coprs.views.api_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/api_ns/__init__.pyc'>,
'app': <Flask 'coprs'>,
'backend_general': <module 'coprs.views.backend_ns.backend_general'
from
'/usr/share/copr/coprs_frontend/coprs/views/backend_ns/backend_general.pyc'>,
'backend_ns': <module 'coprs.views.backend_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/backend_ns/__init__.pyc'>,
'config': <module 'coprs.config' from
'/usr/share/copr/coprs_frontend/coprs/config.pyc'>,
'constants': <module 'coprs.constants' from
'/usr/share/copr/coprs_frontend/coprs/constants.pyc'>,
'context_processors': <module 'coprs.context_processors' from
'/usr/share/copr/coprs_frontend/coprs/context_processors.pyc'>,
'coprs': <module 'coprs' from
'/usr/share/copr/coprs_frontend/coprs/__init__.pyc'>,
'coprs_builds': <module 'coprs.views.coprs_ns.coprs_builds' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_builds.pyc'>,
'coprs_chroots': <module 'coprs.views.coprs_ns.coprs_chroots' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_chroots.pyc'>,
'coprs_general': <module 'coprs.views.coprs_ns.coprs_general' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_general.pyc'>,
'coprs_ns': <module 'coprs.views.coprs_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/__init__.pyc'>,
'coprs_packages': <module 'coprs.views.coprs_ns.coprs_packages' from
'/usr/share/copr/coprs_frontend/coprs/views/coprs_ns/coprs_packages.pyc'>,
'db': <SQLAlchemy
engine='postgresql+psycopg2://copr-fe:coprpass@localhost/coprdb'>,
'exceptions': <module 'coprs.exceptions' from
'/usr/share/copr/coprs_frontend/coprs/exceptions.pyc'>,
'filters': <module 'coprs.filters' from
'/usr/share/copr/coprs_frontend/coprs/filters.pyc'>,
'flask': <module 'flask' from
'/usr/lib/python2.7/site-packages/flask/__init__.pyc'>,
'forms': <module 'coprs.forms' from
'/usr/share/copr/coprs_frontend/coprs/forms.pyc'>,
'groups_general': <module 'coprs.views.groups_ns.groups_general' from
'/usr/share/copr/coprs_frontend/coprs/views/groups_ns/groups_general.pyc'>,
'groups_ns': <flask.blueprints.Blueprint object at 0x433e410>,
'helpers': <module 'coprs.helpers' from
'/usr/share/copr/coprs_frontend/coprs/helpers.pyc'>,
'include_banner': <function include_banner at 0x43779b0>,
'inject_fedmenu': <function inject_fedmenu at 0x43790c8>,
'log': <module 'coprs.log' from
'/usr/share/copr/coprs_frontend/coprs/log.pyc'>,
'logic': <module 'coprs.logic' from
'/usr/share/copr/coprs_frontend/coprs/logic/__init__.pyc'>,
'misc': <module 'coprs.views.misc' from
'/usr/share/copr/coprs_frontend/coprs/views/misc.pyc'>,
'models': <module 'coprs.models' from
'/usr/share/copr/coprs_frontend/coprs/models.pyc'>,
'models_committed': <blinker.base.NamedSignal object at 0x33ea6d0;
'models-committed'>,
'oid': <flask_openid.OpenID object at 0x3abb810>,
'os': <module 'os' from '/usr/lib64/python2.7/os.pyc'>,
'pprint': <function pprint at 0x1ebded8>,
'rcp': <coprs.helpers.RedisConnectionProvider object at 0x3e9acd0>,
'recent_general': <module 'coprs.views.recent_ns.recent_general' from
'/usr/share/copr/coprs_frontend/coprs/views/recent_ns/recent_general.pyc'>,
'recent_ns': <module 'coprs.views.recent_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/recent_ns/__init__.pyc'>,
'redis_session': <module 'coprs.redis_session' from
'/usr/share/copr/coprs_frontend/coprs/redis_session.pyc'>,
'register_api_error_handler': <function register_api_error_handler at
0x45c75f0>,
'rest_api': <module 'coprs.rest_api' from
'/usr/share/copr/coprs_frontend/coprs/rest_api/__init__.pyc'>,
'rest_api_bp': <flask.blueprints.Blueprint object at 0x45c3190>,
'rmodels': <module 'coprs.rmodels' from
'/usr/share/copr/coprs_frontend/coprs/rmodels.pyc'>,
'setup_log': <function setup_log at 0x3cad848>,
'stats_receiver': <module 'coprs.views.stats_ns.stats_receiver' from
'/usr/share/copr/coprs_frontend/coprs/views/stats_ns/stats_receiver.pyc'>,
'status_general': <module 'coprs.views.status_ns.status_general' from
'/usr/share/copr/coprs_frontend/coprs/views/status_ns/status_general.pyc'>,
'status_ns': <module 'coprs.views.status_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/status_ns/__init__.pyc'>,
'tmp_general': <module 'coprs.views.tmp_ns.tmp_general' from
'/usr/share/copr/coprs_frontend/coprs/views/tmp_ns/tmp_general.pyc'>,
'tmp_ns': <module 'coprs.views.tmp_ns' from
'/usr/share/copr/coprs_frontend/coprs/views/tmp_ns/__init__.pyc'>,
'views': <module 'coprs.views' from
'/usr/share/copr/coprs_frontend/coprs/views/__init__.pyc'>,
'webhooks_general': <module 'coprs.views.webhooks_ns.webhooks_general'
from
'/usr/share/copr/coprs_frontend/coprs/views/webhooks_ns/webhooks_general.pyc'>,
'webhooks_ns': <flask.blueprints.Blueprint object at 0x4374bd0>,
'whooshee': <flask_whooshee.Whooshee object at 0x3abbd90>,
'whoosheers': <module 'coprs.whoosheers' from
'/usr/share/copr/coprs_frontend/coprs/whoosheers.pyc'>,
'with_statement': _Feature((2, 5, 0, 'alpha', 1), (2, 6, 0,
'alpha', 0), 32768)}
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running downgrade 414a86b37a0f -> 38f205566f20, add
unique constraint on (copr_id, name) in package table
Traceback (most recent call last):
File "/usr/bin/alembic", line 9, in <module>
load_entry_point('alembic==0.8.7', 'console_scripts',
'alembic')()
File "/usr/lib/python2.7/site-packages/alembic/config.py", line 479, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/lib/python2.7/site-packages/alembic/config.py", line 473, in main
self.run_cmd(cfg, options)
File "/usr/lib/python2.7/site-packages/alembic/config.py", line 456, in
run_cmd
**dict((k, getattr(options, k)) for k in kwarg)
File "/usr/lib/python2.7/site-packages/alembic/command.py", line 202, in
downgrade
script.run_env()
File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 407, in
run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in
load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in
load_module_py
mod = imp.load_source(module_id, path, fp)
File "alembic/env.py", line 73, in <module>
run_migrations_online()
File "alembic/env.py", line 66, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/lib/python2.7/site-packages/alembic/runtime/environment.py", line
797, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/lib/python2.7/site-packages/alembic/runtime/migration.py", line
312, in run_migrations
step.migration_fn(**kw)
File
"/usr/share/copr/coprs_frontend/alembic/versions/414a86b37a0f_add_unique_constraint_on_copr_id_name_.py",
line 22, in downgrade
op.drop_constraint("packages_copr_pkgname", "package")
File "<string>", line 8, in drop_constraint
File "<string>", line 3, in drop_constraint
File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 145,
in drop_constraint
return operations.invoke(op)
File "/usr/lib/python2.7/site-packages/alembic/operations/base.py", line 318,
in invoke
return fn(self, operation)
File "/usr/lib/python2.7/site-packages/alembic/operations/toimpl.py", line
146, in drop_constraint
schema=operation.schema,
File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 183, in
drop_constraint
self._exec(schema.DropConstraint(const))
File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in
_exec
return conn.execute(construct, *multiparams, **params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914,
in execute
return meth(self, multiparams, params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in
_execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 968,
in _execute_ddl
compiled
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
1146, in _execute_context
context)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
1341, in _handle_dbapi_exception
exc_info
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200,
in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
1139, in _execute_context
context)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) constraint
"packages_copr_pkgname" of relation "package" does not exist
[SQL: 'ALTER TABLE package DROP CONSTRAINT packages_copr_pkgname']
----- Original meddelelse -----
Fra: "Michal Novotny" <clime(a)redhat.com>
Til: "copr-devel" <copr-devel(a)lists.fedorahosted.org>
Sendt: onsdag, 16. november 2016 17:00:47
Emne: | Re: missing status_to_order function
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError)
constraint "packages_copr_pkgname" of relation "package" does not
exist
How old sources do you have? This has been fixed in
https://pagure.io/copr/copr/c/e47e6cd41c3e72f58a38a0f25b95b1e5c92b19de?br... .
Please upgrade to the latest sources (or downgrade to the latest stable release
copr-frontend-1.103-1 :)) and setup your db from scratch (dropdb coprdb; createdb coprdb;
./manage.py create_db --alembic alembic.ini) and then run alembic downgrade ... and
alembic upgrade head.
clime
_______________________________________________
copr-devel mailing list -- copr-devel(a)lists.fedorahosted.org
To unsubscribe send an email to copr-devel-leave(a)lists.fedorahosted.org