FATAL Unrecoverable error {“error”: “Error creating tables for master database on storagenode: migrate: storage node database error: migrate tables:: attempt to write a readonly database

Node Operators troubleshooting
21

As I supposed, the permission issue was in the sqlite database itselfm not in the filesystem.

I got it working following next steps:

  • Backup info.db
  • Dump all info.db sql tables to a file
  • Open new info.db
  • Increase page size to 4096: PRAGMA page_size=4096;
  • read previously dumped tables.
  • Save

Love all the vacuums and split in several dbs (one per satellite would be enough tho).
Cheers!

1 Like