Hi Asmaa,
Just to give you some context, Pipelines builds that run on Atlassian infrastructure use Docker containers. For every step of your build, a Docker container starts (the build container) using the image you have specified in your bitbucket-pipelines.yml file. If you use a service for a step, then a second Docker container will start for the service which will share a network adapter with your build container. The repo is cloned in the build container, and then the commands of the step's script are executed. When the step finishes the Docker containers get destroyed.
The first error in the log you shared is the following:
2023-10-18 04:28:55.452 UTC [85] ERROR: relation "public.databasechangeloglock" does not exist at character 22
59
2023-10-18 04:28:55.452 UTC [85] STATEMENT: SELECT COUNT(*) FROM public.databasechangeloglock
The error indicates that the table public.databasechangeloglock doesn't exist in the database. Pipelines doesn't create any tables, you will need to populate the pipelines database with your tables and schema.
I would suggest checking your code to see if the table public.databasechangeloglock is created before the SELECT statement with this table runs.
You can also try debugging this build locally with Docker. You can use the following guide (please ensure that you use the same Docker image you have in your yml file for the build container and any service containers):
There is a section on this guide titled "Testing with build services" that you can use if your step has services.
Kind regards,
Theodora
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.