codechain-dashboard icon indicating copy to clipboard operation
codechain-dashboard copied to clipboard

Cannot install the server

Open sgkim126 opened this issue 5 years ago • 4 comments

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)

sgkim126 avatar Jun 05 '19 04:06 sgkim126

You should give NETWORK_ID environment variable. I'll update README.md and error message.

majecty avatar Jun 05 '19 04:06 majecty

I updated README.md file and the error message. https://github.com/CodeChain-io/codechain-dashboard/pull/50

majecty avatar Jun 05 '19 04:06 majecty

I executed NETWORK_ID=cc generate-schema, but the same error message shows.

sgkim126 avatar Jun 05 '19 05:06 sgkim126

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.

sgkim126 avatar Jun 05 '19 05:06 sgkim126