Skip to content
This repository has been archived by the owner on Feb 3, 2022. It is now read-only.

SQL error with block #2688181 of Kusama #12

Open
alanchchen opened this issue Jun 18, 2020 · 1 comment
Open

SQL error with block #2688181 of Kusama #12

alanchchen opened this issue Jun 18, 2020 · 1 comment

Comments

@alanchchen
Copy link

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)

@alanchchen alanchchen changed the title Block #2688181 of Kusama SQL error with block #2688181 of Kusama Jun 18, 2020
@arjanz
Copy link
Member

arjanz commented Jun 22, 2020

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants