error cant open database

Question

error: {"code":-1,"message":"CDB : Error 28, can't open database "}
{"method":"issue","params":["1A62GjserKZWrsy5VqdtpuJqbKHan9xTXU6VL4","150knr147953-03-15-2016-19:35:00",1000,0.01000000],"id":1,"chain_name":"helga"}

error: {"code":-1,"message":"CDB : Error 28, can't open database "}
{"method":"issue","params":["1A62GjserKZWrsy5VqdtpuJqbKHan9xTXU6VL4","150knr147954-03-15-2016-19:35:00",1000,0.01000000],"id":1,"chain_name":"helga"}

usually before end of workday we let the program insert apsurd ammounts of assets over night just to see what happens in the morning and every time untill now we had the "error cant connect to the server" all over the terminal meaning the node crashed, but today we got this new error. what can cause this and how do we avoid it?

 

additional info:

the node did not crash

using getinfo as first command, after like 100 000 of those error messages, works

inserting assets manually also works

restarting the program that inserts assets also works.

so basically the problem really was that it couldnt connect to database, nothing else crashed, and this problem was gone when i tried to continue where we left off in the morning.

Comments

I've pointed the team to this and will let you know as well.

Answer 1

So it looks like the issue here is general wallet scalability, rather than something specific to asset creation. The built-in MultiChain wallet reaches its limit somewhere in the region of 50K-100K transactions. If you want to go past this point you need to either (a) wait for us to implement a more scalable wallet - it's on the roadmap, or (b) use an external database as the wallet, and just use MultiChain to broadcast and verify transactions.

Comments

How would you suggest connecting to external database and using it as the wallet? Can you explain it in detail, please?

---

You use the createrawtransaction / signrawtransaction / sendrawtransaction MultiChain APIs to build, sign and send your transactions. Don't store the private keys in the MultiChain wallet - instead pass them to signrawtransaction when needed (see https://en.bitcoin.it/wiki/Raw_Transactions for the full parameter list). If you want to make the transactions you generated searchable/queryable, store them in an external database in whichever way you need, with the appropriate indexes, etc...