Closed m0ngr31 closed 4 years ago
rakeshkky
commented
4 years ago Hi @m0ngr31, ~Please try upgrading to beta.8 first and then to beta.10~.
The upgrade to beta.10 from any version should be possible. Please give us the error message the server is throwing when upgrading.
Thank you.
m0ngr31
commented
4 years ago No error in the logs this time, but it fails to load the console with a 502 error.
rakeshkky
commented
4 years ago @m0ngr31 A small question, while being on beta.6 do you have any inconsistent objects? Upgrades won't possible if there are any inconsistent objects.
m0ngr31
commented
4 years ago What do you mean "inconsistent objects"?
rakeshkky
commented
4 years ago What do you mean "inconsistent objects"?
@m0ngr31 The "items" in inconsistent metadata. You'll find them under Metadata status if you click on right top :gear: in the console. Also, make sure you Reload before in Metadata Actions.
Edit 1:- Follow the above steps while being in beta.6
m0ngr31
commented
4 years ago I reloaded the metadata and it's saying this: GraphQL Engine metadata is consistent with database
rakeshkky
commented
4 years ago @m0ngr31 Thank you for the information.
Please provide the logs of beta.10 server. I need to look at the error messages thrown before crashing.
m0ngr31
commented
4 years ago I get this from the logs after it updates:
Attaching to hasura_graphql-engine_1
graphql-engine_1 | {"timestamp":"2019-12-09T18:24:35.103+0000","level":"info","type":"startup","detail":{"kind":"server_configuration","info":{"live_query_options":{"batch_size":100,"refetch_delay":1},"transaction_isolation":"ISOLATION LEVEL READ COMMITTED","enabled_log_types":["unstructured","jwk-refresh-log","ws-server","http-log","schema-sync-thread","websocket-log","startup","webhook-log","pg-client","telemetry-log","metadata","event-trigger"],"server_host":"HostAny","enable_allowlist":false,"log_level":"info","auth_hook_mode":null,"use_prepared_statements":false,"unauth_role":"anonymous","stringify_numeric_types":false,"enabled_apis":["metadata","graphql","config","pgdump"],"enable_telemetry":false,"enable_console":true,"auth_hook":null,"jwt_secret":{"audience":null,"claims_format":null,"claims_namespace":null,"jwk_url":"https://www.googleapis.com/service_accounts/v1/jwk/securetoken@system.gserviceaccount.com","type":"RS512","issuer":null},"cors_config":{"allowed_origins":"*","disabled":false,"ws_read_cookie":null},"console_assets_dir":null,"admin_secret_set":true,"port":8080}}}
graphql-engine_1 | {"timestamp":"2019-12-09T18:24:35.103+0000","level":"info","type":"jwk-refresh-log","detail":{"http_error":null,"message":"refreshing JWK from endpoint: https://www.googleapis.com/service_accounts/v1/jwk/securetoken@system.gserviceaccount.com"}}
graphql-engine_1 | {"timestamp":"2019-12-09T18:24:35.103+0000","level":"info","type":"startup","detail":{"kind":"postgres_connection","info":{"retries":1,"database_url":"postgresql://doadmin:...@goodrich-postgres-db-do-user-6048335-0.db.ondigitalocean.com:25061/goodrichpool?sslmode=require"}}}
graphql-engine_1 | {"internal":{"statement":"DO $$ DECLARE r RECORD; BEGIN FOR r IN (SELECT viewname FROM pg_views WHERE schemaname = 'hdb_views' ORDER BY viewname) LOOP EXECUTE 'DROP VIEW IF EXISTS hdb_views.' || quote_ident(r.viewname) || ' CASCADE'; END LOOP; END $$; DO $$ DECLARE r RECORD; BEGIN FOR r IN (SELECT routine_name FROM information_schema.routines WHERE specific_schema = 'hdb_views' ORDER BY routine_name) LOOP EXECUTE 'DROP FUNCTION hdb_views.' || quote_ident(r.routine_name) || '() CASCADE'; END LOOP; END $$; ","prepared":false,"error":{"exec_status":"FatalError","hint":"You might need to increase max_locks_per_transaction.","message":"out of shared memory","status_code":"53200","description":null},"arguments":[]},"path":"$.args[32].args","error":"postgres query error","code":"unexpected"}
graphql-engine_1 | {"timestamp":"2019-12-09T18:24:52.229+0000","level":"info","type":"startup","detail":{"kind":"server_configuration","info":{"live_query_options":{"batch_size":100,"refetch_delay":1},"transaction_isolation":"ISOLATION LEVEL READ COMMITTED","enabled_log_types":["unstructured","jwk-refresh-log","ws-server","http-log","schema-sync-thread","websocket-log","startup","webhook-log","pg-client","telemetry-log","metadata","event-trigger"],"server_host":"HostAny","enable_allowlist":false,"log_level":"info","auth_hook_mode":null,"use_prepared_statements":false,"unauth_role":"anonymous","stringify_numeric_types":false,"enabled_apis":["metadata","graphql","config","pgdump"],"enable_telemetry":false,"enable_console":true,"auth_hook":null,"jwt_secret":{"audience":null,"claims_format":null,"claims_namespace":null,"jwk_url":"https://www.googleapis.com/service_accounts/v1/jwk/securetoken@system.gserviceaccount.com","type":"RS512","issuer":null},"cors_config":{"allowed_origins":"*","disabled":false,"ws_read_cookie":null},"console_assets_dir":null,"admin_secret_set":true,"port":8080}}}
graphql-engine_1 | {"timestamp":"2019-12-09T18:24:52.229+0000","level":"info","type":"jwk-refresh-log","detail":{"http_error":null,"message":"refreshing JWK from endpoint: https://www.googleapis.com/service_accounts/v1/jwk/securetoken@system.gserviceaccount.com"}}
graphql-engine_1 | {"timestamp":"2019-12-09T18:24:52.229+0000","level":"info","type":"startup","detail":{"kind":"postgres_connection","info":{"retries":1,"database_url":"postgresql://doadmin:...@xxxxxxxxxx:25061/xxxxxxpool?sslmode=require"}}}
marionschleifer
commented
4 years ago @m0ngr31 I hope this issue is resolved. If you upgrade to the latest stable version and still encounter problems, please re-open this issue 🙂
Trying to upgrade from beta6 to beta10, and I get this message when I try to start the docker. I got the same error going to beta9 too.
I'm guessing I need to post my metadata so someone can tell me what the issue is with my config?