Error running task decksite.scrapers.gatherling

[vorpal-buildbot]

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException

[vorpal-buildbot]

Error running task decksite.scrapers.gatherling

Reported on CLI by CLI

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, decklist_hash, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE )` with `[1599174000, 4419, 2, 'https://gatherling.com/deck.php?mode=view&id=93546', '93546', 'Penny_B-Devotion', 3319, 9, None, None, None, None, None, 3, '8df3f30717a9e56f7ad7c4b6d4989f75c345f664']` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`

Stack Trace: ``` Python traceback File "run.py", line 174, in cli() File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 829, in __call__ return self.main(*args, **kwargs) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/discord/.local/lib/python3.8/site-packages/click/core.py", line 610, in invoke return callback(*args, **kwargs) File "run.py", line 68, in scraper task(['scraper', source]) File "run.py", line 154, in run_all_tasks s.scrape() # type: ignore File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 27, in scrape i = tournament(url, name) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 55, in tournament n = add_decks(dt, competition_id, final, s) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 95, in add_decks d = tournament_deck(cells, competition_id, dt, final) File "/home/discord/decksite/decksite/scrapers/gatherling.py", line 189, in tournament_deck return deck.add_deck(d) File "/home/discord/decksite/decksite/data/deck.py", line 383, in add_deck deck_id = db().insert(sql, values) File "/home/discord/decksite/shared/database.py", line 92, in insert self.execute(sql, args) File "/home/discord/decksite/shared/database.py", line 48, in execute [n, _] = self.execute_anything(sql, args, False) File "/home/discord/decksite/shared/database.py", line 63, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```

Exception_hash: 3558f37a25b1e3f648bd58c435fbe9434c78f06d

Labels: CLI; DatabaseException