Skip to content

Instantly share code, notes, and snippets.

@mfulgo

mfulgo/buggy.log Secret

Created October 21, 2022 19:44
Show Gist options
  • Save mfulgo/368cd5a45f48fcfdf0502c6faae3d713 to your computer and use it in GitHub Desktop.
Save mfulgo/368cd5a45f48fcfdf0502c6faae3d713 to your computer and use it in GitHub Desktop.
Download ZIP
Query Logs for sqlalchemy_continuum/#172
Raw
buggy.log
2022-10-21T19:33:41.300742Z 21 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:33:41.287634', NULL)
2022-10-21T19:33:41.301563Z 23 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:33:41.286827', NULL)
2022-10-21T19:33:41.302350Z 20 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:33:41.289363', NULL)
2022-10-21T19:33:41.302442Z 22 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:33:41.288477', NULL)
2022-10-21T19:33:41.303704Z 21 Query INSERT INTO article (name) VALUES ('Article 2-0001')
2022-10-21T19:33:41.304037Z 22 Query INSERT INTO article (name) VALUES ('Article 3-0001')
2022-10-21T19:33:41.304410Z 23 Query INSERT INTO article (name) VALUES ('Article 0-0001')
2022-10-21T19:33:41.304446Z 20 Query INSERT INTO article (name) VALUES ('Article 1-0001')
2022-10-21T19:33:41.306959Z 21 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 436 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:33:41.307592Z 23 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 437 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:33:41.308127Z 20 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 438 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:33:41.308603Z 22 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 439 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:33:41.314999Z 20 Query UPDATE article_version SET end_transaction_id=438 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 438 AND article_version_1.id = 231) AS subquery) AND article_version.id = 231
2022-10-21T19:33:41.315024Z 21 Query UPDATE article_version SET end_transaction_id=436 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 436 AND article_version_1.id = 229) AS subquery) AND article_version.id = 229
2022-10-21T19:33:41.315051Z 23 Query UPDATE article_version SET end_transaction_id=437 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 437 AND article_version_1.id = 232) AS subquery) AND article_version.id = 232
2022-10-21T19:33:41.316243Z 22 Query UPDATE article_version SET end_transaction_id=439 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 439 AND article_version_1.id = 230) AS subquery) AND article_version.id = 230
2022-10-21T19:33:41.317069Z 20 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (231, 'Article 1-0001', 438, NULL, 0)
2022-10-21T19:33:41.317331Z 21 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (229, 'Article 2-0001', 436, NULL, 0)
2022-10-21T19:33:41.317705Z 22 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (230, 'Article 3-0001', 439, NULL, 0)
2022-10-21T19:33:41.317997Z 23 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (232, 'Article 0-0001', 437, NULL, 0)
2022-10-21T19:33:41.320635Z 20 Query INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (438, 'Article')
2022-10-21T19:33:41.320664Z 22 Query ROLLBACK
2022-10-21T19:33:41.320688Z 21 Query ROLLBACK
2022-10-21T19:33:41.320954Z 23 Query ROLLBACK
2022-10-21T19:33:41.323341Z 20 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 438 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:33:41.324552Z 20 Query COMMIT
Raw
works.log
2022-10-21T19:41:39.210546Z 30 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.198466', NULL)
2022-10-21T19:41:39.211620Z 32 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.197710', NULL)
2022-10-21T19:41:39.211635Z 33 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.199475', NULL)
2022-10-21T19:41:39.212310Z 31 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.200475', NULL)
2022-10-21T19:41:39.213722Z 30 Query INSERT INTO article (name) VALUES ('Article 2-0001')
2022-10-21T19:41:39.214139Z 33 Query INSERT INTO article (name) VALUES ('Article 0-0001')
2022-10-21T19:41:39.214530Z 32 Query INSERT INTO article (name) VALUES ('Article 1-0001')
2022-10-21T19:41:39.214985Z 31 Query INSERT INTO article (name) VALUES ('Article 3-0001')
2022-10-21T19:41:39.217439Z 33 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 3 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.218041Z 32 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 2 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.219154Z 30 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 1 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.219376Z 31 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 4 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.221841Z 32 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (3, 'Article 1-0001', 2, NULL, 0)
2022-10-21T19:41:39.224670Z 33 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (2, 'Article 0-0001', 3, NULL, 0)
2022-10-21T19:41:39.224670Z 30 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (1, 'Article 2-0001', 1, NULL, 0)
2022-10-21T19:41:39.228721Z 32 Query UPDATE article_version SET end_transaction_id=2 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 2 AND article_version_1.id = 3) AS subquery) AND article_version.id = 3
2022-10-21T19:41:39.228953Z 33 Query UPDATE article_version SET end_transaction_id=3 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 3 AND article_version_1.id = 2) AS subquery) AND article_version.id = 2
2022-10-21T19:41:39.229434Z 31 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (4, 'Article 3-0001', 4, NULL, 0)
2022-10-21T19:41:39.229471Z 30 Query UPDATE article_version SET end_transaction_id=1 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 1 AND article_version_1.id = 1) AS subquery) AND article_version.id = 1
2022-10-21T19:41:39.230733Z 31 Query UPDATE article_version SET end_transaction_id=4 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 4 AND article_version_1.id = 4) AS subquery) AND article_version.id = 4
2022-10-21T19:41:39.231512Z 30 Query INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (1, 'Article')
2022-10-21T19:41:39.232812Z 30 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 1 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.233983Z 30 Query COMMIT
2022-10-21T19:41:39.237801Z 30 Query SELECT article.id AS article_id, article.name AS article_name
FROM article
WHERE article.id = 1
2022-10-21T19:41:39.238261Z 33 Query INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (3, 'Article')
2022-10-21T19:41:39.239986Z 30 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.227661', NULL)
2022-10-21T19:41:39.240009Z 33 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 3 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.242361Z 33 Query COMMIT
2022-10-21T19:41:39.242374Z 30 Query UPDATE article SET name='Article 2-0001.2' WHERE article.id = 1
2022-10-21T19:41:39.243949Z 30 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 5 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.246269Z 30 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (1, 'Article 2-0001.2', 5, NULL, 1)
2022-10-21T19:41:39.246688Z 33 Query SELECT article.id AS article_id, article.name AS article_name
FROM article
WHERE article.id = 2
2022-10-21T19:41:39.247116Z 32 Query INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (2, 'Article')
2022-10-21T19:41:39.248292Z 33 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.236429', NULL)
2022-10-21T19:41:39.248879Z 32 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 2 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.249644Z 33 Query UPDATE article SET name='Article 0-0001.2' WHERE article.id = 2
2022-10-21T19:41:39.250249Z 32 Query COMMIT
2022-10-21T19:41:39.251154Z 33 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 6 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.253640Z 33 Query INSERT INTO article_version (id, name, transaction_id, end_transaction_id, operation_type) VALUES (2, 'Article 0-0001.2', 6, NULL, 1)
2022-10-21T19:41:39.253657Z 32 Query SELECT article.id AS article_id, article.name AS article_name
FROM article
WHERE article.id = 3
2022-10-21T19:41:39.254111Z 31 Query INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (4, 'Article')
2022-10-21T19:41:39.254686Z 30 Query UPDATE article_version SET end_transaction_id=5 WHERE article_version.transaction_id = (SELECT max_1
FROM (SELECT max(article_version_1.transaction_id) AS max_1
FROM article_version AS article_version_1
WHERE article_version_1.transaction_id < 5 AND article_version_1.id = 1) AS subquery) AND article_version.id = 1
2022-10-21T19:41:39.255348Z 32 Query INSERT INTO transaction (issued_at, remote_addr) VALUES ('2022-10-21 19:41:39.243531', NULL)
2022-10-21T19:41:39.255898Z 31 Query SELECT transaction_changes.transaction_id AS transaction_changes_transaction_id, transaction_changes.entity_name AS transaction_changes_entity_name
FROM transaction_changes
WHERE transaction_changes.transaction_id = 4 AND transaction_changes.entity_name = 'Article'
2022-10-21T19:41:39.256317Z 30 Query INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (5, 'Article')
2022-10-21T19:41:39.256732Z 32 Query UPDATE article SET name='Article 1-0001.2' WHERE article.id = 3
2022-10-21T19:41:39.257045Z 31 Query COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment