Resolving Ropsten fork issues

THE FOLLOWING PROCEDURES ARE TO BE FOLLOWED AT YOUR OWN RISK. FIEWS TAKES NO RESPONSIBILITY FOR ANY LOSS OF DATA OR FUNCTIONALITY OF YOUR CHAINLINK NODE. ALWAYS CREATE BACKUPS OF YOUR DATABASE

Procedures for users using local sqlite3 databases:

  1. Stop your Chainlink node.

  2. Change directories to your Ropsten node directory: cd ~/.chainlink-ropsten if the Chainlink node was deployed per the official documentation.

  3. Run the following command: sudo sqlite3 db.sqlite3

    If you do not have the sqlite3 package installed, do so with whatever method your OS recommends: For Debian based systems: sudo apt install sqlite

  4. Paste the following SQL statement into the "sqlite>" prompt: DELETE FROM heads;

  5. Quit sqlite by pasting the following into the "sqlite>" prompt: .quit

  6. Start your Chainlink node as you normally would.

Procedures for users using PostgreSQL databases:

  1. Stop your Chainlink node. If you are running failover Chainlink node instances, stop them as well.

  2. Connect to your Postgres database via: psql -h <hostname> -d <database_name> -U <username> You can find the correct values for these by looking at your DATABASE_URL entry in your .env file. The format is postgresql://<username>:<password>@<hostname>:<port>/<database_name> If you do not have the psql package installed, do so with whatever method your OS recommends: For Debian based systems: sudo apt install postgresql-client

  3. When prompted, enter the database password. This can be found in your DATABASE_URL as noted above.

  4. Once connected, your prompt should show your database name as the prompt. For example "ropsten_db=> "

  5. Paste the following SQL statement into the prompt: DELETE FROM heads; The command should return DELETE and a number, for example DELETE 100, and return you back to the prompt.

  6. Quit your psql session by typing \q and then return.

  7. Start your Chainlink node along with any failover instances if applicable.