Show Posts
I keep getting this error when trying to run Node on Windows: execute(227) Retrying database execute due to no such table: transactions
I've tried removing and reinstalling the latest version (3.926). I also tried installing it on a different machine and I still get that same error. ledger.db & mempool.db both exist, but are only 1kb & 2kb, respectively. I'm guessing they just aren't updating. Any ideas?
I've tried removing and reinstalling the latest version (3.926). I also tried installing it on a different machine and I still get that same error. ledger.db & mempool.db both exist, but are only 1kb & 2kb, respectively. I'm guessing they just aren't updating. Any ideas?
I got same error once. The problem was in the mempool.db, it was empty.
I added the table using sqliteadmin:
Code:
CREATE TABLE transactions (timestamp, address, recipient, amount, signature, public_key, keep, openfield)
If it difficult, you can ask devs in the slack to upload a correct mempool.db to github.
Or you should try move ledger.db to another place (or delete it if it empty) and run node. Maybe it's work, but I don't not sure.
At least in the sources there is a file genesis.py which check only ledger.db and if it found the mempool.db will not be initialized.
But I don't know the node use this code or not.
P.S. https://ufile.io/z0q0g - mempool.db with table, 2KB - press "slow download (free)"
Thank you so much for the help! I checked mempool.db and the transactions table was in there. I ended up deleting ledger.db and mempool.db again. I'm not sure what changed, but this time it was able to rebuild.
Thanks again!
