Closed Jolly-Pirate closed 6 years ago
A lot of duplicate entries in several tables after the database is synched. Here's a few examples.
{"levelname": "INFO", "asctime": "2017-11-01T15:36:34.1509550594GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 158, "msecs": 43.68782043457031, "message": "safe_insert_many failed (_mysql_exceptions.IntegrityError) (1062, \"Duplicate entry '16843957-4-1' for key 'PRIMARY'\") [SQL: 'INSERT INTO sbds_tx_limit_order_cancels (block_num, transaction_num, operation_num, timestamp, owner, orderid, operation_type) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: (16843957, 4, 1, datetime.datetime(2017, 11, 1, 15, 20, 18), 'teamsmooth-mm', 2000, 'limit_order_cancel')]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 17, "processName": "MainProcess", "threadName": "MainThread"} {"levelname": "INFO", "asctime": "2017-11-01T16:10:27.1509552627GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 158, "msecs": 925.5707263946533, "message": "safe_insert_many failed (_mysql_exceptions.IntegrityError) (1062, \"Duplicate entry '16844944' for key 'PRIMARY'\") [SQL: 'INSERT INTO sbds_core_blocks (raw, block_num, previous, timestamp, witness, witness_signature, transaction_merkle_root) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: ('{\"signing_key\": \"STM8WtG3BskaEyfUjEmLpUWKZtDuy77FV28YG1r9DAWnJy9DFPWgw\", \"block_id\": \"010108901cdfd3acdfa84158c9bf5ff657cb8fec\", \"extensions\": [], \"t ... (17821 characters truncated) ... dea189623e45293471e7d15391f152a869a04dfb489b2e4cce6624d582f17c5c973a190147aeb6ddb99\"], \"ref_block_prefix\": 4193594025}], \"witness\": \"thecryptodrive\"}', 16844944, '0101088f5db94880caa242a7fc0ebf8968c9a519', datetime.datetime(2017, 11, 1, 16, 9, 39), 'thecryptodrive', '20111e6df4248ef5260edd485a580ed44d1cc5512792adec1cfb55388c0fa0d75c5b97d156b58f3af3c01b7952c69d09ed2e2b0d316a2e39bdc1977508febc99a7', 'bbf70717caf3ee69bc59392c4a07f13f2cf87d56')]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 17, "processName": "MainProcess", "threadName": "MainThread"} {"levelname": "INFO", "asctime": "2017-11-01T16:13:12.1509552792GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 158, "msecs": 367.94328689575195, "message": "safe_insert_many failed (_mysql_exceptions.IntegrityError) (1062, \"Duplicate entry '16844994-1-1' for key 'PRIMARY'\") [SQL: 'INSERT INTO sbds_tx_votes (block_num, transaction_num, operation_num, timestamp, voter, author, permlink, weight, operation_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: ((16844994, 1, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'altanov', 'riskdebonair', 'mass-psychosis', 10000, 'vote'), (16844994, 2, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'edrivegom', 'badchistes', 'chiste-8', 10, 'vote'), (16844994, 3, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'jeanjiru', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 4, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'mamasusa', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 5, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'saburovva', 'naughtyinvestor', 'cointed-ico', 10000, 'vote'), (16844994, 7, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'cijarovi', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 8, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'givemedatsteem', 'anime-addict', '6-strongest-rurouni-kenshin-characters-part-2', 6000, 'vote'), (16844994, 9, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'dualreso', 'badchistes', 'chiste-8', 1000, 'vote') ... displaying 10 of 21 total bound parameter sets ... (16844994, 26, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'edgargimagi', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 27, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'steemprentice', 'badchistes', 'chiste-8', 10, 'vote'))]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 17, "processName": "MainProcess", "threadName": "MainThread"}
{"levelname": "INFO", "asctime": "2017-11-01T15:36:34.1509550594GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 158, "msecs": 43.68782043457031, "message": "safe_insert_many failed (_mysql_exceptions.IntegrityError) (1062, \"Duplicate entry '16843957-4-1' for key 'PRIMARY'\") [SQL: 'INSERT INTO sbds_tx_limit_order_cancels (block_num, transaction_num, operation_num, timestamp, owner, orderid, operation_type) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: (16843957, 4, 1, datetime.datetime(2017, 11, 1, 15, 20, 18), 'teamsmooth-mm', 2000, 'limit_order_cancel')]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 17, "processName": "MainProcess", "threadName": "MainThread"}
{"levelname": "INFO", "asctime": "2017-11-01T16:10:27.1509552627GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 158, "msecs": 925.5707263946533, "message": "safe_insert_many failed (_mysql_exceptions.IntegrityError) (1062, \"Duplicate entry '16844944' for key 'PRIMARY'\") [SQL: 'INSERT INTO sbds_core_blocks (raw, block_num, previous, timestamp, witness, witness_signature, transaction_merkle_root) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: ('{\"signing_key\": \"STM8WtG3BskaEyfUjEmLpUWKZtDuy77FV28YG1r9DAWnJy9DFPWgw\", \"block_id\": \"010108901cdfd3acdfa84158c9bf5ff657cb8fec\", \"extensions\": [], \"t ... (17821 characters truncated) ... dea189623e45293471e7d15391f152a869a04dfb489b2e4cce6624d582f17c5c973a190147aeb6ddb99\"], \"ref_block_prefix\": 4193594025}], \"witness\": \"thecryptodrive\"}', 16844944, '0101088f5db94880caa242a7fc0ebf8968c9a519', datetime.datetime(2017, 11, 1, 16, 9, 39), 'thecryptodrive', '20111e6df4248ef5260edd485a580ed44d1cc5512792adec1cfb55388c0fa0d75c5b97d156b58f3af3c01b7952c69d09ed2e2b0d316a2e39bdc1977508febc99a7', 'bbf70717caf3ee69bc59392c4a07f13f2cf87d56')]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 17, "processName": "MainProcess", "threadName": "MainThread"}
{"levelname": "INFO", "asctime": "2017-11-01T16:13:12.1509552792GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 158, "msecs": 367.94328689575195, "message": "safe_insert_many failed (_mysql_exceptions.IntegrityError) (1062, \"Duplicate entry '16844994-1-1' for key 'PRIMARY'\") [SQL: 'INSERT INTO sbds_tx_votes (block_num, transaction_num, operation_num, timestamp, voter, author, permlink, weight, operation_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: ((16844994, 1, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'altanov', 'riskdebonair', 'mass-psychosis', 10000, 'vote'), (16844994, 2, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'edrivegom', 'badchistes', 'chiste-8', 10, 'vote'), (16844994, 3, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'jeanjiru', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 4, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'mamasusa', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 5, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'saburovva', 'naughtyinvestor', 'cointed-ico', 10000, 'vote'), (16844994, 7, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'cijarovi', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 8, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'givemedatsteem', 'anime-addict', '6-strongest-rurouni-kenshin-characters-part-2', 6000, 'vote'), (16844994, 9, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'dualreso', 'badchistes', 'chiste-8', 1000, 'vote') ... displaying 10 of 21 total bound parameter sets ... (16844994, 26, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'edgargimagi', 'badchistes', 'chiste-8', 1000, 'vote'), (16844994, 27, 1, datetime.datetime(2017, 11, 1, 16, 12, 9), 'steemprentice', 'badchistes', 'chiste-8', 10, 'vote'))]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 17, "processName": "MainProcess", "threadName": "MainThread"}
A lot of duplicate entries in several tables after the database is synched. Here's a few examples.