Error: MongoDB error Server selection timeout: No available servers. #11929

BEDIRHANSAMSA · 2022-02-20T13:59:53Z

BEDIRHANSAMSA
Feb 20, 2022

Hi, I tried to run mongo on Docker, but when I type prisma db push I get this error, can you help?

Connectiong String:

mongodb://username:password@localhost:27017/akillisatici?authSource=admin&retryWrites=true&w=majority

docker-compose.yml

version: "3.8"

networks:
  akillisatici-net:
    name: akillisatici-net

volumes:
  akillisatici-2.mongo:
  akillisatici-1.mongo:
  akillisatici-0.mongo:

services:
  akillisatici-2.mongo:
    hostname: akillisatici-2.mongo
    container_name: akillisatici-2.mongo
    image: mongo
    entrypoint:
      [
        "/usr/bin/mongod",
        "--keyFile",
        "/data/file.key",
        "--replSet",
        "rs",
        "--journal",
        "--bind_ip_all",
      ]
    ports:
      - "27018:27017"
    restart: always
    networks:
      - akillisatici-net
    volumes:
      - "akillisatici-2.mongo:/data/db"
      - "./.docker/file.key:/data/file.key"

  akillisatici-1.mongo:
    hostname: akillisatici-1.mongo
    container_name: akillisatici-1.mongo
    image: mongo
    entrypoint:
      [
        "/usr/bin/mongod",
        "--keyFile",
        "/data/file.key",
        "--replSet",
        "rs",
        "--journal",
        "--bind_ip_all",
      ]
    ports:
      - "27019:27017"
    restart: always
    networks:
      - akillisatici-net
    volumes:
      - "akillisatici-1.mongo:/data/db"
      - "./.docker/file.key:/data/file.key"

  akillisatici-0.mongo:
    hostname: akillisatici-0.mongo
    container_name: akillisatici-0.mongo
    image: mongo
    command: bash -c "/usr/bin/mongod --keyFile /data/file.key --replSet rs --journal --bind_ip_all"
    ports:
      - "27017:27017"
    links:
      - akillisatici-1.mongo:akillisatici-1.mongo
      - akillisatici-2.mongo:akillisatici-2.mongo
    restart: always
    networks:
      - akillisatici-net
    volumes:
      - "akillisatici-0.mongo:/data/db"
      - "./.docker/setup.sh:/scripts/setup.sh"
      - "./.docker/file.key:/data/file.key"

setup.sh

#!/bin/bash

mongo <<EOF
   var cfg = {
        "_id": "rs",
        "version": 1,
        "members": [
            {
                "_id": 0,
                "host": "akillisatici-0.mongo:27017",
                "priority": 2
            },
            {
                "_id": 1,
                "host": "akillisatici-1.mongo:27017",
                "priority": 0
            },
            {
                "_id": 2,
                "host": "akillisatici-2.mongo:27017",
                "priority": 0
            }
        ]
    };
    rs.initiate(cfg, { force: true });
    //rs.reconfig(cfg, { force: true });
    rs.status();
EOF

After prisma db push command:

Error: MongoDB error
Server selection timeout: No available servers. Topology: { Type: ReplicaSetNoPrimary, Servers: [ { Address: akillisatici-1.mongo:27017, Type: Unknown, Error: No such host is known. (os error 11001) }, { Address: akillisatici-2.mongo:27017, Type: Unknown, Error: No such host is known. (os error 11001) }, { Address: akillisatici-0.mongo:27017, Type: Unknown, Error: No such host is known. (os error 11001) }, ] }
   0: migration_core::state::SchemaPush
             at migration-engine\core\src\state.rs:274

Answered by masterbater

Jul 17, 2023

directConnection true is the solution for that

View full answer

austincrim · 2022-02-21T22:52:25Z

austincrim
Feb 21, 2022

Hey @BEDIRHANSAMSA 👋,

It seems like Prisma is having trouble finding and connecting to the DB. Are you able to connect to the database using a Mongo UI or some other method using the same connection string?

Thanks!

5 replies

Jeh212 Apr 15, 2022

I got the same error here =(
I am connecting with a MongoUI, but prisma is having problems to connect with my primary MongoDB!

Jeh212 Apr 15, 2022

BEDIRHANSAMSA Apr 16, 2022
Author

Hello i got a solution for this, go to C:\Windows\System32\drivers\etc and edit hosts file. You can set the container name according to you and works fine :)

127.0.0.1 accounting-0.mongo accounting-1.mongo accounting-2.mongo

tyteen4a03 Jul 16, 2022

Hi, do you have a similar config option you can share for single node?

BEDIRHANSAMSA Jul 18, 2022
Author

Hi, do you have a similar config option you can share for single node?

Hi, you can do as below. I was on vacation so I couldn't answer. Sorry.

127.0.0.1 node_name

criejs · 2023-04-17T08:02:46Z

criejs
Apr 17, 2023

I have solved this question through these 3 steps.

delete (node_modules and prisma generate files)
npm install
prisma generate

0 replies

xunjianxiang · 2023-07-17T04:00:41Z

xunjianxiang
Jul 17, 2023

Same problem!
I can connect the Mongo Server via mongo-clients.

prisma: ^v5.0.0
DATABASE_URL="mongodb://192.168.99.149:27017/config"

0 replies

masterbater · 2023-07-17T06:16:11Z

masterbater
Jul 17, 2023

directConnection true is the solution for that

13 replies

u007 May 30, 2024

@AdelMohammed8 in your .env

Roshan6354 Jun 6, 2024

@AdelMohammed8 in your .env

Hi,
I'm still getting the error like database URL string is invalid when i type npx prisma db push can you please help !!
DATABASE_URL = "mongodb+srv://username:password@cluster0.vpcsk0a.mongodb.net/estate?replicaSet=rs0&retryWrites=true&w=majority&directConnection=true&appName=Cluster0"

janpio Jun 6, 2024
Maintainer

This exact string in an .env file works fine for me @Roshan6354. Do you maybe have weird characters in your username or password that might need to be esacped?

Roshan6354 Jun 6, 2024

replicaSet=rs0&retryWrites=true&w=majority&directConnection=true&appName=Cluster0

This exact string in an .env file works fine for me @Roshan6354. Do you maybe have weird characters in your username or password that might need to be esacped?

Yes, when i used npx prisma generate the env url got updated so this time its not giving and invalid error but still i am getting that Server selection timeout that was coming previously on command npx db push Error:
Kind: Server selection timeout: No available servers. Topology: { Type: ReplicaSetNoPrimary, Set Name: atlas-mr4ioz-shard-0, Servers: [ { Address: ac-4mc9bkq-shard-00-02.vpcsk0a.mongodb.net:27017, Type: Unknown, Error: Kind: I/O error: received fatal alert: InternalError, labels: {} },

please can you help this through i'm trying this from 2 days but still stuck at this

janpio Jun 6, 2024
Maintainer

No, that is an error message from MongoDB Atlas that indicates something is broken, but InternalError is not helpful to understand what that is. I would reach out to MongoDB.

oleandrosiq · 2023-08-06T00:26:19Z

oleandrosiq
Aug 6, 2023

I was also having this error, I managed to solve it by adding my ip address there in the network access configuration

1 reply

fabriciomg29 Mar 30, 2024

this works for me, thanks.

lordcetin · 2023-10-07T22:27:21Z

lordcetin
Oct 7, 2023

These types of problems usually have a simple solution. Add your own current IP address from the Network Access page from the Mongodb left sidebar menu. If the problem persists, enter 0.0.0.0 in the IP address section. The reason why I experienced this error was because my IP address was renewed when my modem was turned off and on. I reluctantly experienced that this security measure of mongodb was successful :)

3 replies

weitzz Feb 1, 2024

Updating...
This solved with me. I needed to run the: npx prisma db push command and it was giving this error: Error: MongoDB error I went to mongodb atlas and added my ip, I ran the command again and it worked.thank you

soni-canra-wiguna Mar 25, 2024

thank you

ChibuzoEkwue May 5, 2024

having the same error under have added my current ip address and whitelist and still getting the same response

daniel-gasparik · 2024-04-13T14:22:38Z

daniel-gasparik
Apr 13, 2024

For me the problem was using the monorepo setup with microservices, make sure when having different ports for the project in docker-compose to point to the same one, or have the other DB up on a different port.

0 replies

hoanghiep1x0 · 2024-05-22T10:14:58Z

hoanghiep1x0
May 22, 2024

mongodb://hoangnam1x0:131312htquynh@localhost:27017/site?directConnection=true

fix it with directConnection=true

Does anyone have a better solution?

0 replies

Yiin · 2024-05-28T03:17:40Z

Yiin
May 28, 2024

In my case I had different ports set for mongo service:

    ports:
      - '27019:27018'

and while I can connect to the database from host using 27019, when connecting from another service I had to use 27018, otherwise it fails to connect.

0 replies

u007 · 2024-05-30T02:21:21Z

BEDIRHANSAMSA Jun 6, 2024
Author

@u007 I think you can try my solution by editing the hosts file.

#11929 (comment)

u007 · 2024-06-06T07:10:12Z

u007
Jun 6, 2024

i think the directconnection is not supported

…

On Thu, 6 Jun 2024, 3:08 pm Roshan6354, ***@***.***> wrote: @AdelMohammed8 <https://github.com/AdelMohammed8> in your .env Hi, I'm still getting the error like database URL string is invalid when i type npx prisma db push can you please help !! DATABASE_URL = "mongodb+srv://:@ cluster0.vpcsk0a.mongodb.net/estate?replicaSet=rs0&retryWrites=true&w=majority&directConnection=true&appName=Cluster0 " — Reply to this email directly, view it on GitHub <#11929 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAC65TOWW7AXLV7G26ZO3YDZGADHFAVCNFSM5O4OMET2U5DIOJSWCZC7NNSXTOKENFZWG5LTONUW63SDN5WW2ZLOOQ5TSNRYGYYTCNY> . You are receiving this because you commented.Message ID: ***@***.***>

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error: MongoDB error Server selection timeout: No available servers. #11929

{{title}}

Replies: 11 comments 25 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Error: MongoDB error Server selection timeout: No available servers. #11929

Replies: 11 comments · 25 replies

BEDIRHANSAMSA Apr 16, 2022 Author

BEDIRHANSAMSA Jul 18, 2022 Author

janpio Jun 6, 2024 Maintainer

janpio Jun 6, 2024 Maintainer

BEDIRHANSAMSA Jun 6, 2024 Author

Replies: 11 comments 25 replies

BEDIRHANSAMSA Apr 16, 2022
Author

BEDIRHANSAMSA Jul 18, 2022
Author

janpio Jun 6, 2024
Maintainer

janpio Jun 6, 2024
Maintainer

BEDIRHANSAMSA Jun 6, 2024
Author