search

polkascan / polkascan-pre-harvester

Polkascan PRE Harvester
GNU General Public License v3.0
26 stars 34 forks source link

SQL error with block #2688181 of Kusama #12

Open alanchchen opened 4 years ago

alanchchen commented 4 years ago

Got errors when processing Kusama block #2688181

sqlalchemy.exc.DataError: (mysql.connector.errors.DataError) 1406 (22001): Data too long for column 'signature' at row 1
[SQL: INSERT INTO data_extrinsic (block_id, extrinsic_idx, extrinsic_hash, extrinsic_length, extrinsic_version, signed, `unsigned`, signedby_address, signedby_index, address_length, address, account_index, account_idx, signature, nonce, era, `call`, module_id, call_id, params, success, error, spec_version_id, codec_error) VALUES (%(block_id)s, %(extrinsic_idx)s, %(extrinsic_hash)s, %(extrinsic_length)s, %(extrinsic_version)s, %(signed)s, %(unsigned)s, %(signedby_address)s, %(signedby_index)s, %(address_length)s, %(address)s, %(account_index)s, %(account_idx)s, %(signature)s, %(nonce)s, %(era)s, %(call)s, %(module_id)s, %(call_id)s, %(params)s, %(success)s, %(error)s, %(spec_version_id)s, %(codec_error)s)]
[parameters: {'block_id': 2688181, 'extrinsic_idx': 3, 'extrinsic_hash': '080c430e02dae3a765c7b737ce8602dcdcdc991ca38121ec3c599406afd96ac5', 'extrinsic_length': 143, 'extrinsic_version': '84', 'signed': True, 'unsigned': False, 'signedby_address': True, 'signedby_index': False, 'address_length': 'ff', 'address': '7bd437292fcdcfeba45c83aec26656f399954d9e38048ebd07a1922e31fc2270', 'account_index': None, 'account_idx': None, 'signature': 'c42b82d02bce3202f6a05d4b06d1ad46963d3be36fd0528bbe90e7f7a4e5fcd38d14234b1c9fcee920d76cfcf43b4ed5dd718e357c2bc1aae3a642975207e67f01', 'nonce': 0, 'era': '1503', 'call': '0400', 'module_id': 'balances', 'call_id': 'transfer', 'params': '[{"name": "dest", "type": "Address", "value": "0xf6b21d624832094b03aa672e016462a020e217cc67b1434785b99114a2b4fa5a", "valueRaw": ""}, {"name": "value", "type": "Compact<Balance>", "value": 10000000000, "valueRaw": "0700e40b5402"}]', 'success': 1, 'error': 0, 'spec_version_id': 2005, 'codec_error': 0}]
(Background on this error at: http://sqlalche.me/e/9h9h)

It seems that the length of signature is 130 and the field is varchar(128) (https://github.com/polkascan/polkascan-pre-harvester/blob/master/app/db/versions/38a7f29de7c7_initial_db_layout.py#L284)

arjanz commented 4 years ago

We just pushed an update upstream that should solve this issue..