Repository navigation
Cannot install the server #49
Description
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)
Activity
majecty commentedon Jun 5, 2019
You should give
NETWORK_IDenvironment variable. I'll update README.md and error message.majecty commentedon Jun 5, 2019
I updated README.md file and the error message.
#50
sgkim126 commentedon Jun 5, 2019
I executed
NETWORK_ID=cc generate-schema, but the same error message shows.sgkim126 commentedon Jun 5, 2019
It seems that I found the reason.
The materialized view
time_5min_avg_report_view_materializeddepending onpeer_countis created before creatingpeer_count.I'll make a PR.