#376 problem with graph generation
Closed 5 years ago Opened 5 years ago by clime.

/etc/cron.hourly/copr-frontend:

Traceback (most recent call last):
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1193, in _execute_context
    context)
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line
509, in do_execute
    cursor.execute(statement, parameters)
psycopg2.IntegrityError: duplicate key value violates unique constraint
"builds_statistics_pkey"
DETAIL:  Key ("time", stat_type)=(1527724800, 24h) already exists.


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/share/copr/coprs_frontend/manage.py", line 512, in <module>
    manager.run()
  File "/usr/lib/python3.6/site-packages/flask_script/__init__.py", line
412, in run
    result = self.handle(sys.argv[0], sys.argv[1:])
  File "/usr/lib/python3.6/site-packages/flask_script/__init__.py", line
383, in handle
    res = handle(*args, **config)
  File "/usr/lib/python3.6/site-packages/flask_script/commands.py", line
216, in __call__
    return self.run(*args, **kwargs)
  File "/usr/share/copr/coprs_frontend/manage.py", line 472, in run
    builds_logic.BuildsLogic.get_tasks_histogram('24h', curr_time -
90*86400, curr_time, 86400)
  File "/usr/share/copr/coprs_frontend/coprs/logic/builds_logic.py",
line 201, in get_tasks_histogram
    db.session.commit()
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/scoping.py",
line 153, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 943, in commit
    self.transaction.commit()
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 467, in commit
    self._prepare_impl()
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 447, in _prepare_impl
    self.session.flush()
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2254, in flush
    self._flush(objects)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2380, in _flush
    transaction.rollback(_capture_exception=True)
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
line 66, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 249, in reraise
    raise value
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2344, in _flush
    flush_context.execute()
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line
391, in execute
    rec.execute(self)
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line
556, in execute
    uow
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line
181, in save_obj
    mapper, table, insert)
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line
830, in _emit_insert_statements
    execute(statement, multiparams)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 948, in execute
    return meth(self, multiparams, params)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py",
line 269, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1060, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1200, in _execute_context
    context)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1413, in _handle_dbapi_exception
    exc_info
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 265, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 248, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 1193, in _execute_context
    context)
  File
"/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line
509, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) duplicate key
value violates unique constraint "builds_statistics_pkey"
DETAIL:  Key ("time", stat_type)=(1527724800, 24h) already exists.
 [SQL: 'INSERT INTO builds_statistics (time, stat_type, running,
pending) VALUES (%(time)s, %(stat_type)s, %(running)s, %(pending)s)']
[parameters: {'time': 1527724800, 'stat_type': '24h', 'running': 0,
'pending': 0}] (Background on this error at: http://sqlalche.me/e/gkpj)

Metadata Update from @clime:
- Issue assigned to dturecek

5 years ago

Metadata Update from @msuchy:
- Issue tagged with: bug

5 years ago

Metadata Update from @clime:
- Issue status updated to: Closed (was: Open)

5 years ago

Login to comment on this ticket.

Metadata