· 6 years ago · Jul 29, 2019, 11:34 AM
1addr=unix:/var/run/eg+/appenlight.sock upstream_status=200 bytes_sent=404 gzip_ratio=- request_time=0.009 upstream_response_time=0.012 pipe=.
2local3.info: Jul 29 11:28:56 celery: [2019-07-29 11:28:53,553: ERROR/ForkPoolWorker-174] appenlight.celery.tasks.add_metrics[eb19c854-46b5-437b-b270-576cb5000b08]: Traceback (most recent call last):
3local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/orm/session.py", line 2671, in bulk_save_objects
4local3.info: Jul 29 11:28:56 celery: False,
5local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/orm/session.py", line 2859, in _bulk_save_mappings
6local3.info: Jul 29 11:28:56 celery: transaction.rollback(_capture_exception=True)
7local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/util/langhelpers.py", line 67, in __exit__
8local3.info: Jul 29 11:28:56 celery: compat.reraise(exc_type, exc_value, exc_tb)
9local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/util/compat.py", line 277, in reraise
10local3.info: Jul 29 11:28:56 celery: raise value
11local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/orm/session.py", line 2853, in _bulk_save_mappings
12local3.info: Jul 29 11:28:56 celery: render_nulls,
13local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/orm/persistence.py", line 102, in _bulk_insert
14local3.info: Jul 29 11:28:56 celery: bookkeeping=return_defaults,
15local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/orm/persistence.py", line 1063, in _emit_insert_statements
16local3.info: Jul 29 11:28:56 celery: c = cached_connections[connection].execute(statement, multiparams)
17local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/engine/base.py", line 980, in execute
18local3.info: Jul 29 11:28:56 celery: return meth(self, multiparams, params)
19local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/sql/elements.py", line 273, in _execute_on_
20local3.info: Jul 29 11:28:56 celery: connection
21local3.info: Jul 29 11:28:56 celery: return connection._execute_clauseelement(self, multiparams, params)
22local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
23local3.info: Jul 29 11:28:56 celery: distilled_params,
24local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/engine/base.py", line 1240, in _execute_context
25local3.info: Jul 29 11:28:56 celery: e, statement, parameters, cursor, context
26local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/engine/base.py", line 1458, in _handle_dbapi_exception
27local3.info: Jul 29 11:28:56 celery: util.raise_from_cause(sqlalchemy_exception, exc_info)
28local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/util/compat.py", line 296, in raise_from_cause
29local3.info: Jul 29 11:28:56 celery: reraise(type(exception), exception, tb=exc_tb, cause=cause)
30local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/util/compat.py", line 276, in reraise
31local3.info: Jul 29 11:28:56 celery: raise value.with_traceback(tb)
32local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/engine/base.py", line 1216, in _execute_context
33local3.info: Jul 29 11:28:56 celery: cursor, statement, parameters, context
34local3.info: Jul 29 11:28:56 celery: File "sqlalchemy/dialects/postgresql/psycopg2.py", line 719, in do_executemany
35local3.info: Jul 29 11:28:56 celery: cursor.executemany(statement, parameters)
36local3.info: Jul 29 11:28:56 celery: sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "metrics_p_2019_7_27" already exists
37local3.info: Jul 29 11:28:56 celery: CONTEXT: SQL statement "CREATE TABLE IF NOT EXI
38local3.info: Jul 29 11:28:56 celery: STS metrics_p_2019_7_27 ( CHECK( timestamp >= DATE '2019-07-27' AND timestamp < DATE '2019-07-28 00:00:00')) INHERITS (metrics)"
39local3.info: Jul 29 11:28:56 celery: PL/pgSQL function partition_metrics() line 14 at EXECUTE
40local3.info: Jul 29 11:28:56 celery: [SQL: 'INSERT INTO metrics (resource_id, timestamp, tags, namespace) VALUES (%(resource_id)s, %(timestamp)s, %(tags)s, %(namespace)s)'] [parameters: ({'timestamp': datetime.datetime(2019, 7, 26, 23, 58
41), 'namespace': 'appenlight.request_metric', 'tags': '{"nosql": 0.0, "custom": 0.0, "remote_calls": 0, "tmpl": 0.03282, "nosql_calls": 2, "tmpl_calls": 8, "sql": 0.01438, "main": 0.05555, "custom_calls": 0, "server_name": "vm-scjshop.egplu
42sww.pl", "remote": 0.0, "requests": 1, "sql_calls": 3, "view_name": "axes/decorators:decorated_login.GET"}', 'resource_id': 10}, {'timestamp': datetime.datetime(2019, 7, 27, 0, 0), 'namespace': 'appenlight.request_metric', 'tags': '{"nosql
43": 0.0, "custom": 0.0, "remote_calls": 0, "tmpl": 0.03736, "nosql_calls": 4, "tmpl_calls": 8, "sql": 0.01335, "main": 0.05976, "custom_calls": 0, "server_name
44local3.info: Jul 29 11:28:56 celery: ": "vm-scjshop.egplusww.pl", "remote": 0.0, "requests": 1, "sql_calls": 5, "view_name": "axes/decorators:decorated_login.GET"}', 'resource_id': 10})] (Background on this error at: http://sqlalche.me/e/f
45405)