Hi,
I started to build my own copr , I follow
thehttp://frostyx.cz/posts/copr-docker-compose-without-supervisord
but can't pass the init-database.sh [1], I'm using
https://pagure.io/copr/copr.git 30 dec 2021 commit (f18faf4f)
any tip ?
[1]
docker exec -it copr_frontend_1 bash
cd /usr/share/copr/coprs_frontend/ && copr-frontend create-db --
alembic
alembic.ini
[2022-01-03 23:01:38,665] INFO in log: logging configuration
finished
/usr/share/copr/coprs_frontend/coprs/models.py:2445: SAWarning:
relationship 'Build.package' will copy column package.id to column
build.package_id, whichconflicts with relationship(s):
'Package.builds'
(copies package.id to build.package_id). If this is not the
intention,
consider if these relationships should be linked with
back_populates,
or if viewonly=True should be applied to one or more if they are
read-
only. For the less common case that foreign keyconstraints are
partially overlapping, the orm.foreign() annotation can be used to
isolate the columns that should be written towards. To silence
this
warning, add the parameter 'overlaps="builds"' to the
'Build.package'
relationship. (Background on this error at:
https://sqlalche.me/e/14/qzyx)
db.session.add(DistGitInstance(
Traceback (most recent call last):
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 1802, in _execute_context
self.dialect.do_execute(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "dist_git_instance" does
not
exist
LINE 1: INSERT INTO dist_git_instance (name, clone_url,
clone_packag...
^
The above exception was the direct cause of the following
exception:
Traceback (most recent call last):
File "/usr/bin/copr-frontend", line 125, in <module>
app.cli()
File "/usr/lib/python3.10/site-packages/click/core.py", line 1137,
in
__call__
return self.main(*args, **kwargs)
File "/usr/lib/python3.10/site-packages/click/core.py", line 1062,
in
main
rv = self.invoke(ctx)
File "/usr/lib/python3.10/site-packages/click/core.py", line 1668,
in
invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/lib/python3.10/site-packages/click/core.py", line 1404,
in
invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/lib/python3.10/site-packages/click/core.py", line 763,
in
invoke
return __callback(*args, **kwargs)
File "/usr/bin/copr-frontend", line 99, in wrapper
sys.exit(bool(function(*args, **kwargs)))
File "/usr/share/copr/coprs_frontend/commands/create_db.py", line
18,
in create_db
db.create_all()
File "/usr/lib/python3.10/site-
packages/flask_sqlalchemy/__init__.py",
line 1094, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/usr/lib/python3.10/site-
packages/flask_sqlalchemy/__init__.py",
line 1086, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/sql/schema.py",
line 4785, in create_all
bind._run_ddl_visitor(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 3117, in _run_ddl_visitor
conn._run_ddl_visitor(visitorcallable, element, **kwargs)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 2113, in _run_ddl_visitor
visitorcallable(self.dialect, self,
**kwargs).traverse_single(element)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/sql/visitors.py",
line 524, in traverse_single
return meth(obj, **kw)
File "/usr/lib64/python3.10/site-packages/sqlalchemy/sql/ddl.py",
line
849, in visit_metadata
self.traverse_single(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/sql/visitors.py",
line 524, in traverse_single
return meth(obj, **kw)
File "/usr/lib64/python3.10/site-packages/sqlalchemy/sql/ddl.py",
line
915, in visit_table
table.dispatch.after_create(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/event/attr.py",
line 343, in __call__
fn(*args, **kw)
File "/usr/share/copr/coprs_frontend/coprs/models.py", line 2451,
in
insert_fedora_distgit
db.session.commit()
File "<string>", line 2, in commit
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/session.py",
line 1431, in commit
self._transaction.commit(_to_root=self.future)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/session.py",
line 829, in commit
self._prepare_impl()
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/session.py",
line 808, in _prepare_impl
self.session.flush()
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/session.py",
line 3363, in flush
self._flush(objects)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/session.py",
line 3502, in _flush
with util.safe_reraise():
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/session.py",
line 3463, in _flush
flush_context.execute()
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/persistence.py", line 244, in save_obj
_emit_insert_statements(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/orm/persistence.py", line 1221, in
_emit_insert_statements
result = connection._execute_20(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 1614, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/sql/elements.py",
line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 1481, in _execute_clauseelement
ret = self._execute_context(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 1845, in _execute_context
self._handle_dbapi_exception(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 2026, in _handle_dbapi_exception
util.raise_(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/base.py",
line 1802, in _execute_context
self.dialect.do_execute(
File "/usr/lib64/python3.10/site-
packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable)
relation "dist_git_instance" does not exist
LINE 1: INSERT INTO dist_git_instance (name, clone_url,
clone_packag...
^