Skip to content

Instantly share code, notes, and snippets.

@gitanshu
Created September 26, 2020 02:59
Show Gist options
  • Save gitanshu/53ec39cce335b723c3d5d89c9ef9248c to your computer and use it in GitHub Desktop.
Save gitanshu/53ec39cce335b723c3d5d89c9ef9248c to your computer and use it in GitHub Desktop.
Pulling postgres ... done
Pulling hasura ... done
Pulling graphql ... done
Pulling apollo ... done
Pulling towel ... done
Pulling ui ... done
Creating network "prefect-server" with the default driver
Creating tmp_postgres_1 ... done
Creating tmp_hasura_1 ... done
Creating tmp_graphql_1 ... done
Creating tmp_towel_1 ... done
Creating tmp_apollo_1 ... done
Creating tmp_ui_1 ... done
Attaching to tmp_postgres_1, tmp_hasura_1, tmp_graphql_1, tmp_apollo_1, tmp_towel_1, tmp_ui_1
apollo_1 | {"status":"ok","version":"master"}
graphql_1 |
graphql_1 | Running Alembic migrations...
postgres_1 | The files belonging to this database system will be owned by user "postgres".
postgres_1 | This user must also own the server process.
postgres_1 |
postgres_1 | The database cluster will be initialized with locale "en_US.utf8".
postgres_1 | The default database encoding has accordingly been set to "UTF8".
postgres_1 | The default text search configuration will be set to "english".
postgres_1 |
postgres_1 | Data page checksums are disabled.
apollo_1 | GraphQL service healthy!
ui_1 | 👾👾👾 UI running at localhost:8080 👾👾👾
towel_1 | {"severity": "INFO", "name": "prefect-server.Lazarus", "message": "Lazarus will start after an initial delay of 124 seconds..."}
postgres_1 |
apollo_1 |
apollo_1 | > @ serve /apollo
apollo_1 | > node dist/index.js
apollo_1 |
graphql_1 | INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
towel_1 | {"severity": "INFO", "name": "prefect-server.Scheduler", "message": "Scheduler will start after an initial delay of 255 seconds..."}
towel_1 | {"severity": "INFO", "name": "prefect-server.ZombieKiller", "message": "ZombieKiller will start after an initial delay of 3 seconds..."}
graphql_1 | INFO [alembic.runtime.migration] Will assume transactional DDL.
postgres_1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
graphql_1 | INFO [alembic.runtime.migration] Running upgrade -> 27811b58307b, Create extensions and initial settings
apollo_1 | Building schema...
graphql_1 | INFO [alembic.runtime.migration] Running upgrade 27811b58307b -> 72e2cd3e0469, Initial database tables migration
graphql_1 | INFO [alembic.runtime.migration] Running upgrade 72e2cd3e0469 -> c4d792bdd05e, Add flow run idempotency key
postgres_1 | creating subdirectories ... ok
graphql_1 | INFO [alembic.runtime.migration] Running upgrade c4d792bdd05e -> 3398e4807bfb, Add traversal functions
graphql_1 | INFO [alembic.runtime.migration] Running upgrade 3398e4807bfb -> b9086bd4b962, Create message table
graphql_1 | INFO [alembic.runtime.migration] Running upgrade b9086bd4b962 -> c1f317aa658c, Remove state_id foreign keys
postgres_1 | selecting default max_connections ... 100
graphql_1 | INFO [alembic.runtime.migration] Running upgrade c1f317aa658c -> 6611fd0ccc73, Simplify run state update triggers
postgres_1 | selecting default shared_buffers ... 128MB
postgres_1 | selecting default timezone ... Etc/UTC
postgres_1 | selecting dynamic shared memory implementation ... posix
graphql_1 | INFO [alembic.runtime.migration] Running upgrade 6611fd0ccc73 -> 70528cee0d2b, Add agent persistence
graphql_1 | Applied Hasura metadata from /prefect-server/services/hasura/migrations/metadata.yaml
graphql_1 |
graphql_1 | Database upgraded!
postgres_1 | creating configuration files ... ok
postgres_1 | running bootstrap script ... ok
graphql_1 | INFO: Started server process [1]
graphql_1 | INFO: Waiting for application startup.
postgres_1 | performing post-bootstrap initialization ... ok
graphql_1 | INFO: Application startup complete.
postgres_1 | syncing data to disk ... ok
postgres_1 |
postgres_1 | Success. You can now start the database server using:
postgres_1 |
postgres_1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
postgres_1 |
graphql_1 | INFO: Uvicorn running on http://0.0.0.0:4201 (Press CTRL+C to quit)
graphql_1 | INFO: 192.168.192.5:35488 - "GET /health HTTP/1.1" 200 OK
postgres_1 |
postgres_1 | WARNING: enabling "trust" authentication for local connections
postgres_1 | You can change this by editing pg_hba.conf or using the option -A, or
postgres_1 | --auth-local and --auth-host, the next time you run initdb.
postgres_1 | waiting for server to start....2020-09-26 02:55:32.415 UTC [45] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2020-09-26 02:55:32.449 UTC [46] LOG: database system was shut down at 2020-09-26 02:55:32 UTC
postgres_1 | 2020-09-26 02:55:32.466 UTC [45] LOG: database system is ready to accept connections
postgres_1 | done
postgres_1 | server started
postgres_1 | CREATE DATABASE
postgres_1 |
postgres_1 |
postgres_1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgres_1 |
postgres_1 | 2020-09-26 02:55:32.763 UTC [45] LOG: received fast shutdown request
postgres_1 | waiting for server to shut down....2020-09-26 02:55:32.765 UTC [45] LOG: aborting any active transactions
postgres_1 | 2020-09-26 02:55:32.766 UTC [45] LOG: background worker "logical replication launcher" (PID 52) exited with exit code 1
postgres_1 | 2020-09-26 02:55:32.766 UTC [47] LOG: shutting down
postgres_1 | 2020-09-26 02:55:32.802 UTC [45] LOG: database system is shut down
postgres_1 | done
postgres_1 | server stopped
postgres_1 |
postgres_1 | PostgreSQL init process complete; ready for start up.
postgres_1 |
postgres_1 | 2020-09-26 02:55:32.878 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
postgres_1 | 2020-09-26 02:55:32.878 UTC [1] LOG: listening on IPv6 address "::", port 5432
postgres_1 | 2020-09-26 02:55:32.888 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2020-09-26 02:55:32.913 UTC [63] LOG: database system was shut down at 2020-09-26 02:55:32 UTC
postgres_1 | 2020-09-26 02:55:32.932 UTC [1] LOG: database system is ready to accept connections
graphql_1 | INFO: 192.168.192.5:38584 - "POST /graphql/ HTTP/1.1" 200 OK
apollo_1 | Building schema complete!
apollo_1 | Server ready at http://0.0.0.0:4200 🚀 (version: master)
apollo_1 | Sending telemetry to Prefect Technologies, Inc.: {"source":"prefect_server","type":"startup","payload":{"id":"31298222-d98b-4aa4-b386-c57af7ec3a33","prefect_server_version":"master","api_version":"0.2.0"}}
graphql_1 | INFO: 192.168.192.5:40698 - "POST /graphql/ HTTP/1.1" 200 OK
graphql_1 | INFO: 192.168.192.5:40722 - "POST /graphql/ HTTP/1.1" 200 OK
WELCOME TO
_____ _____ ______ ______ ______ _____ _______ _____ ______ _______ ________ _____
| __ \| __ \| ____| ____| ____/ ____|__ __| / ____| ____| __ \ \ / / ____| __ \
| |__) | |__) | |__ | |__ | |__ | | | | | (___ | |__ | |__) \ \ / /| |__ | |__) |
| ___/| _ /| __| | __| | __|| | | | \___ \| __| | _ / \ \/ / | __| | _ /
| | | | \ \| |____| | | |___| |____ | | ____) | |____| | \ \ \ / | |____| | \ \
|_| |_| \_\______|_| |______\_____| |_| |_____/|______|_| \_\ \/ |______|_| \_\
Visit http://localhost:8080 to get started, or check out the docs at https://docs.prefect.io
apollo_1 | PayloadTooLargeError: request entity too large
apollo_1 | at readStream (/apollo/node_modules/raw-body/index.js:155:17)
apollo_1 | at getRawBody (/apollo/node_modules/raw-body/index.js:108:12)
apollo_1 | at read (/apollo/node_modules/body-parser/lib/read.js:77:3)
apollo_1 | at jsonParser (/apollo/node_modules/body-parser/lib/types/json.js:135:5)
apollo_1 | at Layer.handle [as handle_request] (/apollo/node_modules/express/lib/router/layer.js:95:5)
apollo_1 | at trim_prefix (/apollo/node_modules/express/lib/router/index.js:317:13)
apollo_1 | at /apollo/node_modules/express/lib/router/index.js:284:7
apollo_1 | at Function.process_params (/apollo/node_modules/express/lib/router/index.js:335:12)
apollo_1 | at next (/apollo/node_modules/express/lib/router/index.js:275:10)
apollo_1 | at cors (/apollo/node_modules/cors/lib/index.js:188:7)
postgres_1 | 2020-09-26 02:55:41.296 UTC [75] ERROR: insert or update on table "log" violates foreign key constraint "log_flow_run_id_fkey"
postgres_1 | 2020-09-26 02:55:41.296 UTC [75] DETAIL: Key (flow_run_id)=(1bda3e8f-3fe0-402f-86fa-eee442e38961) is not present in table "flow_run".
postgres_1 | 2020-09-26 02:55:41.296 UTC [75] STATEMENT: WITH "log__mutation_result_alias" AS (INSERT INTO "public"."log" ( "created", "tenant_id", "is_loaded_from_archive", "task_run_id", "name", "id", "updated", "message", "timestamp", "level", "flow_run_id", "info" ) VALUES (DEFAULT, ($1)::uuid, DEFAULT, ($2)::uuid, ($3)::text, ($4)::uuid, DEFAULT, ($5)::text, ($6)::timestamptz, ($7)::text, ($8)::uuid, ($9)::jsonb) RETURNING * , CASE WHEN 'true' THEN NULL ELSE "hdb_catalog"."check_violation"('insert check constraint failed') END ), "log__all_columns_alias" AS (SELECT "flow_run_id" , "tenant_id" , "task_run_id" , "timestamp" , "name" , "level" , "message" , "info" , "id" , "created" , "updated" , "is_loaded_from_archive" FROM "log__mutation_result_alias" ) SELECT json_build_object('affected_rows', (SELECT COUNT(*) FROM "log__all_columns_alias" ) )
hasura_1 | {"type":"http-log","timestamp":"2020-09-26T02:55:41.049+0000","level":"error","detail":{"operation":{"user_vars":{"x-hasura-role":"admin"},"error":{"path":"$.selectionSet.insert_log.args.objects","error":"Foreign key violation. insert or update on table \"log\" violates foreign key constraint \"log_flow_run_id_fkey\"","code":"constraint-violation"},"request_id":"6021893d-fc65-4652-a40f-fdf70dbb86df","response_size":203,"query":{"variables":{"insert_objects":[{"tenant_id":null,"task_run_id":null,"name":"CloudHandler","id":"09cf1a68-964f-44f7-8cc3-3e9a7a91da99","message":"Failed to write log with error: 413 Client Error: Payload Too Large for url: http://localhost:4200/graphql","timestamp":"2020-09-26T02:55:41.284440+00:00","level":"CRITICAL","flow_run_id":"1bda3e8f-3fe0-402f-86fa-eee442e38961","info":{}}]},"query":"mutation($insert_objects: [log_insert_input!]!) {\n insert: insert_log(objects: $insert_objects) {\n affected_rows\n }\n}"}},"http_info":{"status":400,"http_version":"HTTP/1.1","url":"/v1alpha1/graphql","ip":"192.168.192.4","method":"POST","content_encoding":null}}}
graphql_1 | Foreign key violation.
graphql_1 |
graphql_1 | GraphQL request:2:3
graphql_1 | 1 | mutation ($input: write_run_logs_input!) {
graphql_1 | 2 | write_run_logs(input: $input) {
graphql_1 | | ^
graphql_1 | 3 | success
graphql_1 | Traceback (most recent call last):
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 85, in execute
graphql_1 | as_box=as_box,
graphql_1 | File "/prefect-server/src/prefect_server/utilities/graphql.py", line 80, in execute
graphql_1 | raise ValueError(result["errors"])
graphql_1 | ValueError: [{'extensions': {'path': '$.selectionSet.insert_log.args.objects', 'code': 'constraint-violation'}, 'message': 'Foreign key violation. insert or update on table "log" violates foreign key constraint "log_flow_run_id_fkey"'}]
graphql_1 |
graphql_1 | During handling of the above exception, another exception occurred:
graphql_1 |
graphql_1 | Traceback (most recent call last):
graphql_1 | File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 628, in await_result
graphql_1 | return await result
graphql_1 | File "/prefect-server/src/prefect_server/graphql/extensions.py", line 52, in resolve
graphql_1 | result = await result
graphql_1 | File "/prefect-server/src/prefect_server/graphql/logs.py", line 26, in resolve_write_run_logs
graphql_1 | await api.logs.create_logs(logs)
graphql_1 | File "/prefect-server/src/prefect_server/api/logs.py", line 46, in create_logs
graphql_1 | await models.Log.insert_many(model_logs, selection_set={"affected_rows"})
graphql_1 | File "/prefect-server/src/prefect_server/database/orm.py", line 303, in insert_many
graphql_1 | run_mutation=run_mutation,
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 256, in insert
graphql_1 | result = await self.execute_mutations_in_transaction(mutations=[graphql])
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 165, in execute_mutations_in_transaction
graphql_1 | as_box=as_box,
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 91, in execute
graphql_1 | raise ValueError("Foreign key violation.")
graphql_1 | ValueError: Foreign key violation.
graphql_1 |
graphql_1 | The above exception was the direct cause of the following exception:
graphql_1 |
graphql_1 | Traceback (most recent call last):
graphql_1 | File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 674, in await_completed
graphql_1 | return await completed
graphql_1 | File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 659, in await_result
graphql_1 | return_type, field_nodes, info, path, await result
graphql_1 | File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 733, in complete_value
graphql_1 | raise result
graphql_1 | File "/usr/local/lib/python3.7/site-packages/graphql/execution/execute.py", line 628, in await_result
graphql_1 | return await result
graphql_1 | File "/prefect-server/src/prefect_server/graphql/extensions.py", line 52, in resolve
graphql_1 | result = await result
graphql_1 | File "/prefect-server/src/prefect_server/graphql/logs.py", line 26, in resolve_write_run_logs
graphql_1 | await api.logs.create_logs(logs)
graphql_1 | File "/prefect-server/src/prefect_server/api/logs.py", line 46, in create_logs
graphql_1 | await models.Log.insert_many(model_logs, selection_set={"affected_rows"})
graphql_1 | File "/prefect-server/src/prefect_server/database/orm.py", line 303, in insert_many
graphql_1 | run_mutation=run_mutation,
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 256, in insert
graphql_1 | result = await self.execute_mutations_in_transaction(mutations=[graphql])
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 165, in execute_mutations_in_transaction
graphql_1 | as_box=as_box,
graphql_1 | File "/prefect-server/src/prefect_server/database/hasura.py", line 91, in execute
graphql_1 | raise ValueError("Foreign key violation.")
graphql_1 | graphql.error.graphql_error.GraphQLError: Foreign key violation.
graphql_1 |
graphql_1 | GraphQL request:2:3
graphql_1 | 1 | mutation ($input: write_run_logs_input!) {
graphql_1 | 2 | write_run_logs(input: $input) {
graphql_1 | | ^
graphql_1 | 3 | success
graphql_1 | INFO: 192.168.192.5:41560 - "POST /graphql/ HTTP/1.1" 200 OK
towel_1 | {"severity": "DEBUG", "name": "prefect-server.ZombieKiller", "message": "Sleeping for 120.0 seconds..."}
graphql_1 | INFO: 192.168.192.5:42000 - "POST /graphql/ HTTP/1.1" 200 OK
graphql_1 | INFO: 192.168.192.5:42448 - "POST /graphql/ HTTP/1.1" 200 OK
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment