search

Zondax / namadexer

Namada indexer
39 stars 57 forks source link

Error: "Operator does not exist" after hard fork #173

Closed gnosed closed 5 months ago

gnosed commented 5 months ago

After the hard fork, I tried to update the indexer to the v1.0.0. Updated the checksums and restarted it. I get the following error:

  2024-03-27T16:17:32.906334Z  INFO namadexer::database: Creating tables if they don't exist
    at src/database.rs:125
    in namadexer::database::create_tables

Error: DB(Database(PgDatabaseError { severity: Error, code: "42883", message: "operator does not exist: bytea ->> unknown", detail: None, hint: Some("No operator matches the given name and argument types. You might need to add explicit type casts."), position: Some(Original(92)), where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: Some("parse_oper.c"), line: Some(647), routine: Some("op_error") }))
Makefile:49: recipe for target 'run_indexer' failed
make: *** [run_indexer] Error 1
hkey0 commented 5 months ago

Same here!

rllola commented 5 months ago

Ok I am sorry you have a database which is incompatible. You will need to erase the db and relaunch for a fresh start.

In case you don't have access to the pre-hardfork node and need it to re-index you can use temporarly this one : http://51.159.167.32:26657

You then switch to yours at block 237906 and keep indexing