Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Crashing on SQL error running as RPC service #18

Open
Crypto2 opened this issue Feb 23, 2018 · 1 comment
Open

Crashing on SQL error running as RPC service #18

Crypto2 opened this issue Feb 23, 2018 · 1 comment

Comments

@Crypto2
Copy link

Crypto2 commented Feb 23, 2018

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)
@tonyofbyteball
Copy link
Member

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants