codechain-dashboard
codechain-dashboard copied to clipboard
Cannot install the server
I tried to install server but generate-schema
failed with the following messages.
Running `target/debug/generate-schema`
#2019-06-05 13:39:13 main INFO agent-hub Create agent_extra table
#2019-06-05 13:39:13 main INFO agent-hub Create logs table
#2019-06-05 13:39:13 main INFO agent-hub Create logs_timestamp index
#2019-06-05 13:39:13 main INFO agent-hub Create logs_target index
#2019-06-05 13:39:13 main INFO agent-hub Create network_usage table
#2019-06-05 13:39:13 main INFO agent-hub Create network_usage_time_index
#2019-06-05 13:39:13 main INFO agent-hub Create materialized views
thread 'main' panicked at 'called `Result::unwrap()` on an `Err` value: Error(Db(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState("42P01"), message: "relation \"peer_count\" does not exist", detail: None, hint: None, position: Some(Normal(259)), where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("parse_relation.c"), line: Some(1180), routine: Some("parserOpenTable") }))', src/libcore/result.rs:997:5
note: Run with `RUST_BACKTRACE=1` environment variable to display a backtrace.
I used PostgreSQL 10.8.
psql (PostgreSQL) 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1)
You should give NETWORK_ID
environment variable. I'll update README.md and error message.
I updated README.md file and the error message. https://github.com/CodeChain-io/codechain-dashboard/pull/50
I executed NETWORK_ID=cc generate-schema
, but the same error message shows.
It seems that I found the reason.
The materialized view time_5min_avg_report_view_materialized
depending on peer_count
is created before creating peer_count
.
I'll make a PR.