# Databases **URL:** https://discuss.circleci.com/c/environment/databases/18.md [Latest](https://discuss.circleci.com/latest.md) · [Categories](https://discuss.circleci.com/categories.md) · [Tags](https://discuss.circleci.com/tags.md) --- ## [About the Databases category](https://discuss.circleci.com/t/about-the-databases-category/42)
**Author:** [@circleci-community](https://discuss.circleci.com/u/circleci-community)\ **Replies:** 0\ **Last updated:** [October 7, 2015, 3:56pm UTC](https://discuss.circleci.com/t/about-the-databases-category/42 "2015-10-07T15:56:29Z")
MySQL, PostgreSQL, MongoDB, Redis, RabbitMQ and more - ask your database questions here --- ## [ActiveRecord::ConnectionNotEstablished: PQsocket() can't get socket descriptor](https://discuss.circleci.com/t/activerecord-pqsocket-cant-get-socket-descriptor/53161)
**Author:** [@kreintjes](https://discuss.circleci.com/u/kreintjes)\ **Replies:** 0\ **Last updated:** [April 24, 2025, 1:13pm UTC](https://discuss.circleci.com/t/activerecord-pqsocket-cant-get-socket-descriptor/53161 "2025-04-24T13:13:22Z")
Since yesterday we suddenly get PQsocket errors on (almost) all of our system tests for one of our applications. The exact error is: ActiveRecord::ConnectionNotEstablished: PQsocket() can't get socket descriptor … --- ## [Migrate DB via CircleCI test & build pipeline to AWS RDS](https://discuss.circleci.com/t/migrate-db-via-circleci-test-build-pipeline-to-aws-rds/52185)
**Author:** [@kmarshall008](https://discuss.circleci.com/u/kmarshall008)\ **Replies:** 0\ **Last updated:** [October 18, 2024, 9:52pm UTC](https://discuss.circleci.com/t/migrate-db-via-circleci-test-build-pipeline-to-aws-rds/52185 "2024-10-18T21:52:13Z")
We are trying to set up an automated pipeline in CircleCI to manage migrations for an AWS RDS instance using Alembic. Despite configuring jobs in .circleci/config.yml for building, testing database connectivity, and appl… --- ## [Powershell script skipping some users](https://discuss.circleci.com/t/powershell-script-skipping-some-users/50944)
**Author:** [@srikanthbollu](https://discuss.circleci.com/u/srikanthbollu)\ **Replies:** 0\ **Last updated:** [May 22, 2024, 2:35pm UTC](https://discuss.circleci.com/t/powershell-script-skipping-some-users/50944 "2024-05-22T14:35:38Z")
I have the following script that should run through all identities from Sailpoint IdentityIQ, and remove the membership, but it randomly don’t affect users, we saw in the logs that it process one user correctly and then … --- ## [Postgres container failing with initdb error: \`program "postgres" is needed by initdb but was not found\`](https://discuss.circleci.com/t/postgres-container-failing-with-initdb-error-program-postgres-is-needed-by-initdb-but-was-not-found/48470)
**Author:** [@kelvintaywl](https://discuss.circleci.com/u/kelvintaywl)\ **Replies:** 1\ **Last updated:** [June 26, 2023, 2:43am UTC](https://discuss.circleci.com/t/postgres-container-failing-with-initdb-error-program-postgres-is-needed-by-initdb-but-was-not-found/48470 "2023-06-26T02:43:34Z")
As of June 15th 2023, the official Postgres Docker images were published to be based on Debian 12.0 (Bookworm) rather than Debian 11.0 (Bullseye). See Issues · docker-library/postgres · GitHub CircleCI Support team has… --- ## [Daily incremental refresh and moving the Aurora DB cluster to Snowflake](https://discuss.circleci.com/t/daily-incremental-refresh-and-moving-the-aurora-db-cluster-to-snowflake/48310)
**Author:** [@mani0525](https://discuss.circleci.com/u/mani0525)\ **Replies:** 0\ **Last updated:** [June 9, 2023, 7:30am UTC](https://discuss.circleci.com/t/daily-incremental-refresh-and-moving-the-aurora-db-cluster-to-snowflake/48310 "2023-06-09T07:30:41Z")
I want to move several Aurora DB clusters, each with a few TBs of storage, to Snowflake while also executing a daily incremental refresh. I’m curious about the best procedures and resources to use to accomplish this goal… --- ## [Firestore connection with Alteryx](https://discuss.circleci.com/t/firestore-connection-with-alteryx/46367)
**Author:** [@pavanhkrs](https://discuss.circleci.com/u/pavanhkrs)\ **Replies:** 0\ **Last updated:** [December 16, 2022, 11:27am UTC](https://discuss.circleci.com/t/firestore-connection-with-alteryx/46367 "2022-12-16T11:27:52Z")
I have a requirement to extract data from firebase which is used to build serverless applications. Can we connect Firebase no-sql database(Firestore) to ETL tool Alteryx, could not find any relevant documentation on the… --- ## [ActiveRecord error when running db:schema:load - "NoMethodError: undefined method 'uuid'"](https://discuss.circleci.com/t/activerecord-error-when-running-dbload-nomethoderror-undefined-method-uuid/45241)
**Author:** [@ambreenhasan](https://discuss.circleci.com/u/ambreenhasan)\ **Replies:** 0\ **Last updated:** [August 30, 2022, 6:18pm UTC](https://discuss.circleci.com/t/activerecord-error-when-running-dbload-nomethoderror-undefined-method-uuid/45241 "2022-08-30T18:18:20Z")
I’m running into an issue when running bundle exec rake db:schema:load when setting up the test database before tests can be ran: “NoMethodError: undefined method \`uuid’ for ActiveRecord” This happens when a table that… --- ## [You might need to increase max\_locks\_per\_transaction](https://discuss.circleci.com/t/you-might-need-to-increase-max-locks-per-transaction/43502)
**Author:** [@allen-munsch](https://discuss.circleci.com/u/allen-munsch)\ **Replies:** 0\ **Last updated:** [March 31, 2022, 9:46pm UTC](https://discuss.circleci.com/t/you-might-need-to-increase-max-locks-per-transaction/43502 "2022-03-31T21:46:40Z")
Traceback (most recent call last): File "/home/circleci/project/venv\_3\_9\_10/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in \_execute return self.cursor.execute(sql, params) psycopg2.errors.Out… --- ## [Upgrading From Deprecated Docker Convenience Image openjdk Connecting To Postgres](https://discuss.circleci.com/t/upgrading-from-deprecated-docker-convenience-image-openjdk-connecting-to-postgres/43356)
**Author:** [@danielahedges](https://discuss.circleci.com/u/danielahedges)\ **Replies:** 1\ **Last updated:** [March 25, 2022, 6:00am UTC](https://discuss.circleci.com/t/upgrading-from-deprecated-docker-convenience-image-openjdk-connecting-to-postgres/43356 "2022-03-25T06:00:47Z")
I am trying to upgrade away from my deprecated Docker convenience images. This build works: version: 2.1 jobs: build: docker: - image: circleci/openjdk:11 environment: SPRING\_DATASOURCE\_US… --- ## [MySQL Container Wait Timeout](https://discuss.circleci.com/t/mysql-container-wait-timeout/43316)
**Author:** [@werks](https://discuss.circleci.com/u/werks)\ **Replies:** 0\ **Last updated:** [March 21, 2022, 2:03pm UTC](https://discuss.circleci.com/t/mysql-container-wait-timeout/43316 "2022-03-21T14:03:19Z")
When trying to wait for the mysql docker container, I’m met with: Problem with dial: dial tcp 127.0.0.1:3306: connect: connection refused. Sleeping 1s # This config is equivalent to both the '.circleci/extended/orb-free… --- ## [Can't connect to MySQL](https://discuss.circleci.com/t/cant-connect-to-mysql/39313)
**Author:** [@boriscy](https://discuss.circleci.com/u/boriscy)\ **Replies:** 1\ **Last updated:** [February 2, 2022, 4:13pm UTC](https://discuss.circleci.com/t/cant-connect-to-mysql/39313 "2022-02-02T16:13:33Z")
I have a this config version: 2.1 executors: default: working\_directory: ~/derekbarber\_mysql docker: - image: cimg/ruby:2.7-node environment: BUNDLE\_JOBS: 3 BUNDLE\_RETRY: 3 … --- ## [Rails Postgres - db:test:prepare - could not open extension control file pg\_stat\_statements](https://discuss.circleci.com/t/rails-postgres-dbprepare-could-not-open-extension-control-file-pg-stat-statements/41668)
**Author:** [@Cmarl](https://discuss.circleci.com/u/Cmarl)\ **Replies:** 2\ **Last updated:** [November 25, 2021, 12:22am UTC](https://discuss.circleci.com/t/rails-postgres-dbprepare-could-not-open-extension-control-file-pg-stat-statements/41668 "2021-11-25T00:22:21Z")
using image: cimg/postgres:12.7 and installing client/contrib via: - run: name: Install Postgresql Client command: sudo apt install postgresql-client postgresql-contrib Locally (and in other … --- ## [Container step shows 'Build was cancelled' and is a missing the green checkmark although all tests run and pass](https://discuss.circleci.com/t/container-step-shows-build-was-cancelled-and-is-a-missing-the-green-checkmark-although-all-tests-run-and-pass/37600)
**Author:** [@philosopher](https://discuss.circleci.com/u/philosopher)\ **Replies:** 8\ **Last updated:** [June 3, 2021, 11:30am UTC](https://discuss.circleci.com/t/container-step-shows-build-was-cancelled-and-is-a-missing-the-green-checkmark-although-all-tests-run-and-pass/37600 "2021-06-03T11:30:25Z")
I have integrated CircleCI into my app such that every branch that is pushed to Github gets tests run against it and can only be merged with master if all tests pass. It is working as expected but I observed some peculia… --- ## [MongoDB Up And Running](https://discuss.circleci.com/t/mongodb-up-and-running/39624)
**Author:** [@danielahedges](https://discuss.circleci.com/u/danielahedges)\ **Replies:** 5\ **Last updated:** [April 8, 2021, 2:34pm UTC](https://discuss.circleci.com/t/mongodb-up-and-running/39624 "2021-04-08T14:34:41Z")
I’ve tried to get up-and-running with a small MongoDB web application. I need to connect to a fresh mongodb on every CI run. I cannot connect. What am I missing? Here is my config.yml: version: 2.1 orbs: node: circle… --- ## [Azure Purview](https://discuss.circleci.com/t/azure-purview/39040)
**Author:** [@Pranjal199612](https://discuss.circleci.com/u/Pranjal199612)\ **Replies:** 1\ **Last updated:** [February 9, 2021, 11:02pm UTC](https://discuss.circleci.com/t/azure-purview/39040 "2021-02-09T23:02:27Z")
When will Azure Purview feature will be in General Availability? --- ## [Add a new database for MySQL container on a different port](https://discuss.circleci.com/t/add-a-new-database-for-mysql-container-on-a-different-port/39025)
**Author:** [@Jaace](https://discuss.circleci.com/u/Jaace)\ **Replies:** 1\ **Last updated:** [February 4, 2021, 5:09pm UTC](https://discuss.circleci.com/t/add-a-new-database-for-mysql-container-on-a-different-port/39025 "2021-02-04T17:09:45Z")
I am attempting to add a new database to a mysql container for a circleci test run. I already have a mysql container running on 3306. Is there an easy way to either: create a new database within the existing container… --- ## [CircleCi postgres rake db:create is failing](https://discuss.circleci.com/t/circleci-postgres-rake-db-create-is-failing/39031)
**Author:** [@chandanchoubey1](https://discuss.circleci.com/u/chandanchoubey1)\ **Replies:** 0\ **Last updated:** [February 4, 2021, 1:14pm UTC](https://discuss.circleci.com/t/circleci-postgres-rake-db-create-is-failing/39031 "2021-02-04T13:14:22Z")
I am trying to run docker file where rake db:create is there but its continuously failing with below error. below is DB configuration using YML. docker: - image: circleci/ruby:2.6.5-node-browsers-legacy environment… --- ## [CircleCIを使った データベース連携・活用 に関するCircleCI活用ブログご紹介](https://discuss.circleci.com/t/circleci-circleci/38749)
**Author:** [@Masahiko](https://discuss.circleci.com/u/Masahiko)\ **Replies:** 0\ **Last updated:** [January 9, 2021, 7:05am UTC](https://discuss.circleci.com/t/circleci-circleci/38749 "2021-01-09T07:05:25Z")
「CircleCI使ってみた」「CircleCI、自分はこんな風に活用している」というブログ記事をたくさんの方にポストいただき、ありがとうございます！ ここでは、そんな記事の中で、データベースがらみのものを紹介させていただきます。主にCircleCI Japan Twitter(@CircleCIJapan)でご紹介させていただいたものからピックアップしています。 参考になった記事があれば、記事の著者の方に敬意を表して、記事に対して… --- ## ["Build was cancelled" in database containers](https://discuss.circleci.com/t/build-was-cancelled-in-database-containers/34411)
**Author:** [@deeTEEcee](https://discuss.circleci.com/u/deeTEEcee)\ **Replies:** 2\ **Last updated:** [October 2, 2020, 3:07pm UTC](https://discuss.circleci.com/t/build-was-cancelled-in-database-containers/34411 "2020-10-02T15:07:10Z")
I’m guessing this is the same as "https://discuss.circleci.com/t/postgresql-always-reports-job-was-canceled/29208." After the entire build is done processing, it probably leads to these messages in the bottom of the cont… --- ## [Error when trying to connect MySQL with MariaDB driver (with hibernate)](https://discuss.circleci.com/t/error-when-trying-to-connect-mysql-with-mariadb-driver-with-hibernate/36503)
**Author:** [@gkorland](https://discuss.circleci.com/u/gkorland)\ **Replies:** 0\ **Last updated:** [June 30, 2020, 10:36am UTC](https://discuss.circleci.com/t/error-when-trying-to-connect-mysql-with-mariadb-driver-with-hibernate/36503 "2020-06-30T10:36:30Z")
I followed the docs here - https://circleci.com/docs/2.0/postgres-config/#example-mysql-project But, I’m getting the following error which I don’t get when running localy: https://app.circleci.com/pipelines/github/Redi… --- ## [Can not connect to postgres](https://discuss.circleci.com/t/can-not-connect-to-postgres/36253)
**Author:** [@paulvitic](https://discuss.circleci.com/u/paulvitic)\ **Replies:** 1\ **Last updated:** [June 11, 2020, 10:24am UTC](https://discuss.circleci.com/t/can-not-connect-to-postgres/36253 "2020-06-11T10:24:28Z")
I am trying to execute integration tests against a secondary Postgres service container and a RabbitMQ container. Here is my config file version: 2.1 jobs: integration-test: docker: - image: circleci/node:l… --- ## [Migrations complete successfully, test cannot access database](https://discuss.circleci.com/t/migrations-complete-successfully-test-cannot-access-database/35918)
**Author:** [@thomas379](https://discuss.circleci.com/u/thomas379)\ **Replies:** 4\ **Last updated:** [May 20, 2020, 1:19pm UTC](https://discuss.circleci.com/t/migrations-complete-successfully-test-cannot-access-database/35918 "2020-05-20T13:19:24Z")
When running a build of my Laravel project, the migrations to a sqlite database complete successfully. However, when it gets to the test, I get the following error: 1) NoAuthCest: Try to test Test tests/functional/No… --- ## [Is MongoDB really supported?](https://discuss.circleci.com/t/is-mongodb-really-supported/35750)
**Author:** [@chaim1221](https://discuss.circleci.com/u/chaim1221)\ **Replies:** 1\ **Last updated:** [May 2, 2020, 7:10pm UTC](https://discuss.circleci.com/t/is-mongodb-really-supported/35750 "2020-05-02T19:10:24Z")
It seems a lot of people have trouble with MongoDB. My particular issue right now is that I can’t get the container to stay up so that my NodeJS app can connect to it. I have tried specifying the ports as in the posts be… --- ## [PostgreSQL - Alpine version for 11.7 - any reason it does not exist?](https://discuss.circleci.com/t/postgresql-alpine-version-for-11-7-any-reason-it-does-not-exist/34787)
**Author:** [@tonydehnke](https://discuss.circleci.com/u/tonydehnke)\ **Replies:** 6\ **Last updated:** [March 16, 2020, 2:51pm UTC](https://discuss.circleci.com/t/postgresql-alpine-version-for-11-7-any-reason-it-does-not-exist/34787 "2020-03-16T14:51:17Z")
Hi, we have been using the Alpine version of PostgreSQL for a while. Our production environment has upgraded to v11.7 and I wanted to update the CircleCI version to the same. There is no Alpine version of 11.7 availabl… --- ## [circleCI test failing on postgres auto-increment column](https://discuss.circleci.com/t/circleci-test-failing-on-postgres-auto-increment-column/34791)
**Author:** [@yaboiwaffles](https://discuss.circleci.com/u/yaboiwaffles)\ **Replies:** 1\ **Last updated:** [March 6, 2020, 4:20pm UTC](https://discuss.circleci.com/t/circleci-test-failing-on-postgres-auto-increment-column/34791 "2020-03-06T16:20:18Z")
So I am having a hard time figuring out how to fix a failing test right now. I recently made a new branch on my project where I wrote a ruby migration that sets a column in one of my postgres tables to auto-increment. I’… --- ## [Postgres just stopped working](https://discuss.circleci.com/t/postgres-just-stopped-working/34511)
**Author:** [@brettpthomas](https://discuss.circleci.com/u/brettpthomas)\ **Replies:** 6\ **Last updated:** [February 18, 2020, 4:50pm UTC](https://discuss.circleci.com/t/postgres-just-stopped-working/34511 "2020-02-18T16:50:28Z")
Credit card failed, and soon after our django/postgres setup just stopped working: Error: Database is uninitialized and superuser password is not specified. You must specify POSTGRES\_PASSWORD for the superuser. Use … --- ## [POSTGRES - ERROR: unrecognized configuration parameter "default\_table\_access\_method"](https://discuss.circleci.com/t/postgres-error-unrecognized-configuration-parameter-default-table-access-method/34441)
**Author:** [@tonydehnke](https://discuss.circleci.com/u/tonydehnke)\ **Replies:** 2\ **Last updated:** [February 13, 2020, 11:19pm UTC](https://discuss.circleci.com/t/postgres-error-unrecognized-configuration-parameter-default-table-access-method/34441 "2020-02-13T23:19:33Z")
Running into a new issue that is causing my build to fail. Related to a line added to structure.sql SET default\_table\_access\_method = heap; This is new to me and a bit over my head. Here is the output of the error: #… --- ## [Using the circleci/mysql and circleci/postgres images simultaneously in the same job](https://discuss.circleci.com/t/using-the-circleci-mysql-and-circleci-postgres-images-simultaneously-in-the-same-job/34341)
**Author:** [@jonsibley](https://discuss.circleci.com/u/jonsibley)\ **Replies:** 2\ **Last updated:** [February 4, 2020, 7:42pm UTC](https://discuss.circleci.com/t/using-the-circleci-mysql-and-circleci-postgres-images-simultaneously-in-the-same-job/34341 "2020-02-04T19:42:35Z")
Hi, When I run both of these images at once, such as in my example project on Github, I get the following error when trying to connect to MySQL (example failure): Access denied for user ‘user’@‘127.0.0.1’ However, i… --- ## [Mysql max\_allowed\_packet configuration](https://discuss.circleci.com/t/mysql-max-allowed-packet-configuration/30436)
**Author:** [@claytron5000](https://discuss.circleci.com/u/claytron5000)\ **Replies:** 1\ **Last updated:** [January 13, 2020, 9:37am UTC](https://discuss.circleci.com/t/mysql-max-allowed-packet-configuration/30436 "2020-01-13T09:37:23Z")
This seems like something that should be obvious, but I haven’t been able to find anything. I’m inserting into a Mysql database and getting the ERROR 2006 (HY000) at line 163385: MySQL server has gone away error, which I… [Next page](https://discuss.circleci.com/c/environment/databases/18.md?page=1)