Overflow error in Multichain explorer

+1 vote

Getting the following error while trying to run Multichain Explorer:

Failed to catch up {'blkfile_offset': 0, 'blkfile_number': 1, 'chain_id': 1, 'loader': u'default', 'conf': None, 'dirname': u'/root/.multichain/test-chain', 'id': 2}
Traceback (most recent call last):
  File "Mce/DataStore.py", line 2861, in catch_up
    if not store.catch_up_rpc(dircfg):
  File "Mce/DataStore.py", line 3093, in catch_up_rpc
    store.import_block(block, chain = chain)
  File "Mce/DataStore.py", line 1195, in import_block
    tx['tx_id'] = store.import_tx(tx, pos == 0, chain)
  File "Mce/DataStore.py", line 2048, in import_tx
    """, (balance, pubkey_id, asset_id))
  File "Mce/DataStore.py", line 262, in sql
    store._sql.sql(stmt, params)
  File "Mce/SqlAbstraction.py", line 426, in sql
    sql._execute(cached, params)
  File "Mce/SqlAbstraction.py", line 407, in _execute
    sql.cursor().execute(stmt, params)

OverflowError: Python int too large to convert to SQLite INTEGER


I believe that this error has happened because of the large quantities of assets I've issued. For ex., 9223372036854701056. Any fix that could get the explorer up and running for my blockchain?

asked Feb 16, 2017 by Cypher
edited Feb 17, 2017 by Cypher

1 Answer

+1 vote
Best answer

The maximum value for SQLite's INTEGER type appears to be 263-1, and I'm not sure if you're passing that limit. Perhaps you can stick to numbers up to a few billion?

answered Feb 17, 2017 by MultiChain
selected Apr 6, 2017 by Cypher