Post
Topic
Board Announcements (Altcoins)
Re: BYTEBALL: Totally new consensus algorithm + private untraceable payments
by
HCP
on 14/07/2017, 23:35:37 UTC
Is anyone else getting an Uncaught Exception... looks like an SQLite Error of some description... but no idea what is causing it? Huh

Quote
Uncaught exception: Error: Error: SQLITE_CONSTRAINT: FOREIGN KEY constraint failed INSERT INTO unit_authors (unit, address, definition_chash) VALUES(?,?,?) FDIOwPxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxO2/yE=, HZTYxxxxxxxxxxxxxxxxxxxxxxxxxxxxxCUE,
In case anyone else is getting the same error... I figured out a workaround.

The error would appear to be a race condition as suggested by come-from-behind. For some reason, the app is attempting to insert a record into the "unit_authors" table for an address that doesn't exist in the "addresses" table... I suspect because the app is processing things in the wrong order during syncing.

Anyway, to get around this error, First, make sure you have a backup! (specifically the C:\Users\YOURUSERNAME\AppData\Local\byteball directory) Then make sure the Byteball app is not running so the DB is not locked. Then use a SQLite DB browser/editor and simply insert a new record into the "addresses" table with the missing address from the exception... this is the 2nd value shown... so in my case the "HZTYxxxxxxxxxxxxxxxxxxxxxxxxxxxxxCUE" record... Start the Byteball app and it should continue Smiley

For an SQLite DB browser... I used: http://sqlitebrowser.org
DB file location: C:\Users\YOURUSERNAME\AppData\Local\byteball\byteball.sqlite