headless-obyte icon indicating copy to clipboard operation
headless-obyte copied to clipboard

Crashing on SQL error running as RPC service

Open Crypto2 opened this issue 7 years ago • 1 comments

I have tried deleting all of the sqlite DBs except for the -wal one with the same result. If the -wal is corrupt is there any way to recover the wallet without it?

Output is:

  [],
  [Function] ]
/home/gbyte/GBYTE/src/node_modules/byteballcore/sqlite_pool.js:101
                                                throw Error(err+"\n"+sql+"\n"+new_args[1].map(function(param){ if (param === null) return 'null'; if (param === undefined) return 'undefined'; return param;}).join(', '));
                                                ^

Error: Error: SQLITE_CORRUPT: database disk image is malformed
SELECT dependencies.unit, unhandled_joints.unit AS unit_for_json,
                                SUM(CASE WHEN units.unit IS NULL THEN 1 ELSE 0 END) AS count_missing_parents
                        FROM dependencies
                        JOIN unhandled_joints ON dependencies.unit=unhandled_joints.unit
                        LEFT JOIN units ON dependencies.depends_on_unit=units.unit

                        GROUP BY dependencies.unit
                        HAVING count_missing_parents=0
                        ORDER BY NULL

    at Error (native)
    at Statement.<anonymous> (/home/gbyte/GBYTE/src/node_modules/byteballcore/sqlite_pool.js:101:13)

Crypto2 avatar Feb 23 '18 05:02 Crypto2

All three .sqlite* files belong to the database. If you deleted some of them, the database definitely got corrupt.

tonyofbyteball avatar Feb 20 '19 16:02 tonyofbyteball