search

clicepfl / infra

Infrastructure as Code and deployment repository for CLIC web services
2 stars 0 forks source link

Deployment failed on commit 0a2a53cfbefa5c4b0492e0c44c185a9652b21b50 #82

Closed Thechi2000 closed 9 hours ago

Thechi2000 commented 10 hours ago 
        Deployment for directus failed.
        Triggered by the push of 1 commits on https://github.com/clicepfl/directus-config. HEAD after the push is 0a2a53cfbefa5c4b0492e0c44c185a9652b21b50

        Logs: 
        ```
        2024-10-30T11:59:12.246632Z  INFO webhook::routes: Triggered restart for service directus

2024-10-30T11:59:12.246645Z INFO service{name="directus"}: webhook::restart: Restarting... 2024-10-30T11:59:12.246651Z DEBUG service{name="directus"}:stop_command: webhook::restart: Command is empty, skipping 2024-10-30T11:59:12.246657Z DEBUG service{name="directus"}:pre_start_command: webhook::restart: Command is empty, skipping 2024-10-30T11:59:12.246660Z DEBUG service{name="directus"}:start_command: webhook::restart: command="ansible-pull -U git@github.com:clicepfl/clic-infra.git -e @/var/secrets.yaml deploy.yaml --extra-vars SERVICE=$SERVICE" 2024-10-30T11:59:50.176723Z ERROR service{name="directus"}:start_command: webhook::restart: Failed with status exit status: 2 2024-10-30T11:59:50.176756Z ERROR service{name="directus"}:start_command: webhook::restart: STDOUT: [WARNING]: Could not match supplied host pattern, ignoring: ov-13b459 localhost | SUCCESS => { "after": "0c57e3fd70a60e0b60a43962003e11a35a9f3ed4", "before": "0c57e3fd70a60e0b60a43962003e11a35a9f3ed4", "changed": false, "remote_url_changed": false } [WARNING]: No inventory was parsed, only implicit localhost is available [WARNING]: provided hosts list is empty, only localhost is available. Note that the implicit localhost does not match 'all' [WARNING]: Could not match supplied host pattern, ignoring: ov-13b459

PLAY [Deploy all services] *****

TASK [Gathering Facts] ***** ok: [localhost]

TASK [Set full service list] *** ok: [localhost]

TASK [Compute list of services to deploy] ** ok: [localhost]

TASK [Deploy] **

TASK [directus : Validating arguments against arg spec 'main'] ***** ok: [localhost]

TASK [directus : Using default deploy method] ** ok: [localhost]

TASK [directus : Wait for directus to be available] **** ok: [localhost]

TASK [directus : Get container id] ***** ok: [localhost]

TASK [directus : Compute container name] *** ok: [localhost]

TASK [directus : Download schema] ** changed: [localhost]

TASK [directus : Copy schema into container] *** changed: [localhost]

TASK [directus : Apply schema] ***** fatal: [localhost]: FAILED! => {"changed": true, "rc": 1, "stderr": "", "stderr_lines": [], "stdout": "[11:59:48.940] ERROR: Failed to delete field \"languages.code\"\n[11:59:48.945] ERROR: alter table \"languages\" drop column \"code\" - cannot drop column code of table languages because other objects depend on it\n err: {\n \"type\": \"DatabaseError\",\n \"message\": \"alter table \\"languages\\" drop column \\"code\\" - cannot drop column code of table languages because other objects depend on it\",\n \"stack\":\n error: alter table \"languages\" drop column \"code\" - cannot drop column code of table languages because other objects depend on it\n at Parser.parseErrorMessage (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/parser.js:283:98)\n at Parser.handlePacket (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/parser.js:122:29)\n at Parser.parse (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/parser.js:35:38)\n at Socket. (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/index.js:11:42)\n at Socket.emit (node:events:517:28)\n at addChunk (node:internal/streams/readable:368:12)\n at readableAddChunk (node:internal/streams/readable:341:9)\n at Readable.push (node:internal/streams/readable:278:10)\n at TCP.onStreamRead (node:internal/stream_base_commons:190:23)\n \"length\": 862,\n \"name\": \"error\",\n \"severity\": \"ERROR\",\n \"code\": \"2BP01\",\n \"detail\": \"constraint news_translations_languages_code_foreign on table news_translations depends on column code of table languages\nconstraint partner_category_translations_languages_code_foreign on table partner_category_translations depends on column code of table languages\nconstraint save_the_date_translations_languages_code_foreign on table save_the_date_translations depends on column code of table languages\nconstraint std_cell_translations_languages_code_foreign on table std_cell_translations depends on column code of table languages\nconstraint save_the_date_language_button_target_foreign on table save_the_date depends on column code of table languages\",\n \"hint\": \"Use DROP ... CASCADE to drop the dependent objects too.\",\n \"file\": \"dependency.c\",\n \"line\": \"1189\",\n \"routine\": \"reportDependentObjects\"\n }", "stdout_lines": ["[11:59:48.940] ERROR: Failed to delete field \"languages.code\"", "[11:59:48.945] ERROR: alter table \"languages\" drop column \"code\" - cannot drop column code of table languages because other objects depend on it", " err: {", " \"type\": \"DatabaseError\",", " \"message\": \"alter table \\"languages\\" drop column \\"code\\" - cannot drop column code of table languages because other objects depend on it\",", " \"stack\":", " error: alter table \"languages\" drop column \"code\" - cannot drop column code of table languages because other objects depend on it", " at Parser.parseErrorMessage (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/parser.js:283:98)", " at Parser.handlePacket (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/parser.js:122:29)", " at Parser.parse (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/parser.js:35:38)", " at Socket. (/directus/node_modules/.pnpm/pg-protocol@1.7.0/node_modules/pg-protocol/dist/index.js:11:42)", " at Socket.emit (node:events:517:28)", " at addChunk (node:internal/streams/readable:368:12)", " at readableAddChunk (node:internal/streams/readable:341:9)", " at Readable.push (node:internal/streams/readable:278:10)", " at TCP.onStreamRead (node:internal/stream_base_commons:190:23)", " \"length\": 862,", " \"name\": \"error\",", " \"severity\": \"ERROR\",", " \"code\": \"2BP01\",", " \"detail\": \"constraint news_translations_languages_code_foreign on table news_translations depends on column code of table languages\nconstraint partner_category_translations_languages_code_foreign on table partner_category_translations depends on column code of table languages\nconstraint save_the_date_translations_languages_code_foreign on table save_the_date_translations depends on column code of table languages\nconstraint std_cell_translations_languages_code_foreign on table std_cell_translations depends on column code of table languages\nconstraint save_the_date_language_button_target_foreign on table save_the_date depends on column code of table languages\",", " \"hint\": \"Use DROP ... CASCADE to drop the dependent objects too.\",", " \"file\": \"dependency.c\",", " \"line\": \"1189\",", " \"routine\": \"reportDependentObjects\"", " }"]}

PLAY RECAP ***** localhost : ok=10 changed=2 unreachable=0 failed=1 skipped=0 rescued=0 ignored=0

Starting Ansible Pull at 2024-10-30 11:59:13 /usr/bin/ansible-pull -U git@github.com:clicepfl/clic-infra.git -e @/var/secrets.yaml deploy.yaml --extra-vars SERVICE=directus

2024-10-30T11:59:50.176767Z ERROR service{name="directus"}:start_command: webhook::restart: STDOUT: 

        ```
Thechi2000 commented 9 hours ago

Fixed (see #81)