vorpal-buildbot
commented
5 years ago 500 error at /signup/
Failed to execute INSERT INTO deck ( created_date, updated_date, person_id, source_id, url, identifier, name, competition_id, archetype_id, resource_uri, featured_card, score, thumbnail_url, small_thumbnail_url, finish, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE ) with [1550120500.8838058, 3137, 3, 'https://pennydreadfulmagic.com/competitions/848/', '["pika001", 848, "1550120501"]', 'PD-GB-5', 848, None, None, None, None, None, None, None] because of (1062, 'Duplicate entry \'3-["pika001", 848, "1550120501"]\' for key \'deck_source_id_identifier\'')
Reported on decksite by pika001
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'__cfduid': 'd89a72c132379bd5d006b30d452630d0e1546743544', '_ga': 'GA1.2.2076156038.1546743545', 'deck_id': '38609', '_gid': 'GA1.2.1475066708.1550120464', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UctuwjAQ_Jc9R5XzwoEbIKhQS0PhUKVVFZlkEwyJHWwH8RD_XgeJcqjU48ysZ3fGF0gbVDUTKAwMjGrRAZbXXMCgYJW2KMea1zJ_YK4zqfKUWwp8t0eI3_epG3iUeCTywYF_FJGWLa_y-6ZKliXm3QVaipuj7_rUgdqUMm01KsFqtGYN3zFCXOsgWWs2XqoNM51wOGxfkzgZZgXRjdbT8pPjqkrM4iWM6fQxb-QObaQLsCxDre8YYk--LWfnBR-Kdn3AkyHzs1zNw33sNscP-x6PDVeoU2bbccOgH0QkosGTS2kY9MKH3hXWI1YlDigsLLX5XbJ3BRXjEd3SSTJks8l6XC-bXf-5jd5V1IWyhTY2zZdtzn4DL06Wu_Wk4duBm01qTt0IjJApVHB14E9phqkS7ZmirarrD4i1l4Y.D0aHmw.en0ucmednH9fQUB8K3saGe59kWI'}
Endpoint: add_signup
View Args: {}
Person: 316003937142702083
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'pika001', 'name': 'PD-GB-5', 'decklist': '<?xml version="1.0" encoding="utf-8"?>\r\n<Deck xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">\r\n <NetDeckID>0</NetDeckID>\r\n <PreconstructedDeckID>0</PreconstructedDeckID>\r\n <Cards CatID="53846" Quantity="4" Sideboard="false" Name="Temple of Mystery" />\r\n <Cards CatID="22551" Quantity="3" Sideboard="false" Name="Early Harvest" />\r\n <Cards CatID="65418" Quantity="3" Sideboard="false" Name="Old-Growth Dryads" />\r\n <Cards CatID="50360" Quantity="3" Sideboard="false" Name="Dissolve" />\r\n <Cards CatID="31251" Quantity="4" Sideboard="false" Name="Jhessian Infiltrator" />\r\n <Cards CatID="57662" Quantity="1" Sideboard="false" Name="Gaea\'s Revenge" />\r\n <Cards CatID="28335" Quantity="2" Sideboard="false" Name="Wanderer\'s Twig" />\r\n <Cards CatID="69879" Quantity="2" Sideboard="false" Name="Chromatic Lantern" />\r\n <Cards CatID="69355" Quantity="6" Sideboard="false" Name="Forest" />\r\n <Cards CatID="69349" Quantity="8" Sideboard="false" Name="Island" />\r\n <Cards CatID="69907" Quantity="2" Sideboard="false" Name="Gateway Plaza" />\r\n <Cards CatID="39497" Quantity="4" Sideboard="false" Name="Cryptoplasm" />\r\n <Cards CatID="66839" Quantity="1" Sideboard="false" Name="Evolving Wilds" />\r\n <Cards CatID="45366" Quantity="1" Sideboard="false" Name="Evolving Wilds" />\r\n <Cards CatID="69475" Quantity="3" Sideboard="false" Name="Quasiduplicate" />\r\n <Cards CatID="58048" Quantity="4" Sideboard="false" Name="Honored Hierarch" />\r\n <Cards CatID="47759" Quantity="4" Sideboard="false" Name="Biovisionary" />\r\n <Cards CatID="58667" Quantity="3" Sideboard="false" Name="Undergrowth Champion" />\r\n <Cards CatID="50618" Quantity="3" Sideboard="false" Name="Prophet of Kruphix" />\r\n <Cards CatID="54482" Quantity="1" Sideboard="false" Name="Pearl Lake Ancient" />\r\n <Cards CatID="17614" Quantity="4" Sideboard="true" Name="Seedtime" />\r\n <Cards CatID="39806" Quantity="3" Sideboard="true" Name="Psychic Barrier" />\r\n <Cards CatID="66541" Quantity="2" Sideboard="true" Name="Negate" />\r\n <Cards CatID="62628" Quantity="1" Sideboard="true" Name="Negate" />\r\n <Cards CatID="20377" Quantity="2" Sideboard="true" Name="Oxidize" />\r\n <Cards CatID="32611" Quantity="3" Sideboard="true" Name="Giant Growth" />\r\n</Deck>'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 2001:558:600d:43:eda6:6170:26c2:5812, 162.158.75.48
Cf-Ray: 4a8cfa4b8b1dc56a-ORD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Cache-Control: max-age=0
Origin: https://pennydreadfulmagic.com
Upgrade-Insecure-Requests: 1
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: en-US,en;q=0.9
Cookie: __cfduid=d89a72c132379bd5d006b30d452630d0e1546743544; _ga=GA1.2.2076156038.1546743545; deck_id=38609; _gid=GA1.2.1475066708.1550120464; _gat_gtag_UA_109131120_1=1; session=.eJx9UctuwjAQ_Jc9R5XzwoEbIKhQS0PhUKVVFZlkEwyJHWwH8RD_XgeJcqjU48ysZ3fGF0gbVDUTKAwMjGrRAZbXXMCgYJW2KMea1zJ_YK4zqfKUWwp8t0eI3_epG3iUeCTywYF_FJGWLa_y-6ZKliXm3QVaipuj7_rUgdqUMm01KsFqtGYN3zFCXOsgWWs2XqoNM51wOGxfkzgZZgXRjdbT8pPjqkrM4iWM6fQxb-QObaQLsCxDre8YYk--LWfnBR-Kdn3AkyHzs1zNw33sNscP-x6PDVeoU2bbccOgH0QkosGTS2kY9MKH3hXWI1YlDigsLLX5XbJ3BRXjEd3SSTJks8l6XC-bXf-5jd5V1IWyhTY2zZdtzn4DL06Wu_Wk4duBm01qTt0IjJApVHB14E9phqkS7ZmirarrD4i1l4Y.D0aHmw.en0ucmednH9fQUB8K3saGe59kWI
Cf-Connecting-Ip: 2001:558:600d:43:eda6:6170:26c2:5812
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 3313DatabaseException
Failed to execute INSERT INTO deck ( created_date, updated_date, person_id, source_id, url, identifier, name, competition_id, archetype_id, resource_uri, featured_card, score, thumbnail_url, small_thumbnail_url, finish, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE ) with [1550120500.8838058, 3137, 3, 'https://pennydreadfulmagic.com/competitions/848/', '["pika001", 848, "1550120501"]', 'PD-GB-5', 848, None, None, None, None, None, None, None] because of (1062, 'Duplicate entry \'3-["pika001", 848, "1550120501"]\' for key \'deck_source_id_identifier\'')
Stack Trace:
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__
return self.wsgi_app(environ, start_response)
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2295, in wsgi_app
response = self.handle_exception(e)
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "./decksite/cache.py", line 79, in decorated_function
response = make_response(f(*args, **kwargs))
File "./decksite/main.py", line 351, in add_signup
d = lg.signup(form)
File "./decksite/league.py", line 180, in signup
return deck.add_deck(form)
File "./decksite/data/deck.py", line 356, in add_deck
deck_id = db().insert(sql, values)
File "./shared/database.py", line 89, in insert
self.execute(sql, args)
File "./shared/database.py", line 45, in execute
[n, _] = self.execute_anything(sql, args, False)
File "./shared/database.py", line 60, in execute_anything
raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e))
Exception_hash: 1c84d9886ebe0b811fde3c14436118b5c0bfba14
Labels: decksite; DatabaseException
Failed to execute
INSERT INTO deck ( created_date, updated_date, person_id, source_id, url, identifier, name, competition_id, archetype_id, resource_uri, featured_card, score, thumbnail_url, small_thumbnail_url, finish, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )with[1550014925.945496, 143, 3, 'https://pennydreadfulmagic.com/competitions/848/', '["bakert99", 848, "1550014926"]', 'UB Mid', 848, None, None, None, None, None, None, None]because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')Reported on decksite by bakert99
DatabaseException Failed to execute
INSERT INTO deck ( created_date, updated_date, person_id, source_id, url, identifier, name, competition_id, archetype_id, resource_uri, featured_card, score, thumbnail_url, small_thumbnail_url, finish, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )with[1550014925.945496, 143, 3, 'https://pennydreadfulmagic.com/competitions/848/', '["bakert99", 848, "1550014926"]', 'UB Mid', 848, None, None, None, None, None, None, None]because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')Stack Trace:Exception_hash: 1c84d9886ebe0b811fde3c14436118b5c0bfba14