Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot install the server #49

Open
sgkim126 opened this issue Jun 5, 2019 · 4 comments
Open

Cannot install the server #49

sgkim126 opened this issue Jun 5, 2019 · 4 comments
Labels
question Further information is requested

Comments

@sgkim126
Copy link
Contributor

sgkim126 commented Jun 5, 2019

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 sgkim126 added the question Further information is requested label Jun 5, 2019
@majecty
Copy link
Contributor

majecty commented Jun 5, 2019

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

@majecty
Copy link
Contributor

majecty commented Jun 5, 2019

I updated README.md file and the error message.
#50

@sgkim126
Copy link
Contributor Author

sgkim126 commented Jun 5, 2019

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

@sgkim126
Copy link
Contributor Author

sgkim126 commented Jun 5, 2019

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants