Skip to content

Instantly share code, notes, and snippets.

@edulix
Created November 21, 2014 00:39
Show Gist options
  • Select an option

  • Save edulix/995fba50e6510d261f01 to your computer and use it in GitHub Desktop.

Select an option

Save edulix/995fba50e6510d261f01 to your computer and use it in GitHub Desktop.
7
ERROR:frestq.app:Exception on /public_api/election [POST]
Traceback (most recent call last):
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "./public_api.py", line 166, in post_election
db.session.commit()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 149, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 765, in commit
self.transaction.commit()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 370, in commit
self._prepare_impl()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 350, in _prepare_impl
self.session.flush()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1879, in flush
self._flush(objects)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1997, in _flush
transaction.rollback(_capture_exception=True)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1961, in _flush
flush_context.execute()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 370, in execute
rec.execute(self)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 523, in execute
uow
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
mapper, table, insert)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 562, in _emit_insert_statements
execute(statement, multiparams)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 717, in execute
return meth(self, multiparams, params)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 814, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 927, in _execute_context
context)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
exc_info
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
context)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute
cursor.execute(statement, parameters)
IntegrityError: (IntegrityError) duplicate key value violates unique constraint "election_pkey"
DETAIL: Key (id)=(141652996059) already exists.
'INSERT INTO election (id, is_recurring, num_parties, threshold_parties, created_at, last_updated_at, title, url, description, questions_data, voting_start_date, voting_end_date, status, callback_url) VALUES (%(id)s, %(is_recurring)s, %(num_parties)s, %(threshold_parties)s, %(created_at)s, %(last_updated_at)s, %(title)s, %(url)s, %(description)s, %(questions_data)s, %(voting_start_date)s, %(voting_end_date)s, %(status)s, %(callback_url)s)' {'status': 'creating', 'is_recurring': False, 'description': u'election description', 'num_parties': 2, 'last_updated_at': datetime.datetime(2014, 11, 21, 0, 32, 40, 732886), 'url': u'https://example.com/election/url', 'created_at': datetime.datetime(2014, 11, 21, 0, 32, 40, 732878), 'title': u'Test election', 'questions_data': '[{"max": 1, "tally_type": "ONE_CHOICE", "question": "Who Should be President?", "answers": [{"a": "ballot/answer", "details": "", "value": "Alice"}, {"a": "ballot/answer", "details": "", "value": "Bob"}], "min": 0}]', 'voting_end_date': datetime.datetime(2013, 12, 9, 18, 17, 14, 457000), 'callback_url': u'http://wadobo-auth1:8000/key_done', 'id': u'141652996059', 'voting_start_date': datetime.datetime(2013, 12, 6, 18, 17, 14, 457000), 'threshold_parties': 2}
[pid: 14687|app: 0|req: 159/157] 192.168.0.2 () {46 vars in 2827 bytes} [Fri Nov 21 01:32:40 2014] POST /public_api/election => generated 291 bytes in 48 msecs (HTTP/1.1 500) 2 headers in 84 bytes (1 switches on core 3)
ERROR:frestq.app:Exception on /public_api/election [POST]
Traceback (most recent call last):
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "./public_api.py", line 166, in post_election
db.session.commit()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 149, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 765, in commit
self.transaction.commit()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 370, in commit
self._prepare_impl()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 350, in _prepare_impl
self.session.flush()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1879, in flush
self._flush(objects)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1997, in _flush
transaction.rollback(_capture_exception=True)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1961, in _flush
flush_context.execute()
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 370, in execute
rec.execute(self)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 523, in execute
uow
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
mapper, table, insert)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 562, in _emit_insert_statements
execute(statement, multiparams)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 717, in execute
return meth(self, multiparams, params)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 814, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 927, in _execute_context
context)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1076, in _handle_dbapi_exception
exc_info
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 920, in _execute_context
context)
File "/home/eorchestra/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 425, in do_execute
cursor.execute(statement, parameters)
IntegrityError: (IntegrityError) duplicate key value violates unique constraint "election_pkey"
DETAIL: Key (id)=(141652996059) already exists.
'INSERT INTO election (id, is_recurring, num_parties, threshold_parties, created_at, last_updated_at, title, url, description, questions_data, voting_start_date, voting_end_date, status, callback_url) VALUES (%(id)s, %(is_recurring)s, %(num_parties)s, %(threshold_parties)s, %(created_at)s, %(last_updated_at)s, %(title)s, %(url)s, %(description)s, %(questions_data)s, %(voting_start_date)s, %(voting_end_date)s, %(status)s, %(callback_url)s)' {'status': 'creating', 'is_recurring': False, 'description': u'election description', 'num_parties': 2, 'last_updated_at': datetime.datetime(2014, 11, 21, 0, 32, 40, 710560), 'url': u'https://example.com/election/url', 'created_at': datetime.datetime(2014, 11, 21, 0, 32, 40, 710547), 'title': u'Test election', 'questions_data': '[{"max": 1, "tally_type": "ONE_CHOICE", "question": "Who Should be President?", "answers": [{"a": "ballot/answer", "details": "", "value": "Alice"}, {"a": "ballot/answer", "details": "", "value": "Bob"}], "min": 0}]', 'voting_end_date': datetime.datetime(2013, 12, 9, 18, 17, 14, 457000), 'callback_url': u'http://wadobo-auth1:8001/key_done', 'id': u'141652996059', 'voting_start_date': datetime.datetime(2013, 12, 6, 18, 17, 14, 457000), 'threshold_parties': 2}
[pid: 14687|app: 0|req: 159/158] 192.168.0.2 () {46 vars in 2827 bytes} [Fri Nov 21 01:32:40 2014] POST /public_api/election => generated 291 bytes in 45 msecs (HTTP/1.1 500) 2 headers in 84 bytes (2 switches on core 2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment