8000 Connection pool - Blocking operations · Issue #91 · mauricio/postgresql-async · GitHub
[go: up one dir, main page]
Skip to content
This repository was archived by the owner on Dec 3, 2019. It is now read-only.
This repository was archived by the owner on Dec 3, 2019. It is now read-only.
Connection pool - Blocking operations #91
Open
Open
Connection pool - Blocking operations#91
@fwbrasil

Description

@fwbrasil
fwbrasil
opened on May 10, 2014

The connection pool performs block operations to acquire and test connections using the connection factory [1] [2] [3] [4]. This characteristic makes the pool really sensible to database issues, like high latency or connection errors.

The workaround for me was:

I think that an ideal solution should be avoid having blocking operations inside connection pools.

[1]

postgresql-async/mysql-async/src/main/scala/com/github/mauricio/async/db/mysql/pool/MySQLConnectionFactory.scala

Line 53 in 2ab790d

Await.result(connection.connect, configuration.connectTimeout )

[2]

postgresql-async/mysql-async/src/main/scala/com/github/mauricio/async/db/mysql/pool/MySQLConnectionFactory.scala

Line 124 in 2ab790d

Await.result(item.sendQuery("SELECT 0"), configuration.testTimeout)

[3]

postgresql-async/postgresql-async/src/main/scala/com/github/mauricio/async/db/postgresql/pool/PostgreSQLConnectionFactory.scala

Line 53 in 2ab790d

Await.result(connection.connect, configuration.connectTimeout)

[4]

postgresql-async/postgresql-async/src/main/scala/com/github/mauricio/async/db/postgresql/pool/PostgreSQLConnectionFactory.scala

Line 90 in 2ab790d

Await.result( item.sendQuery("SELECT 0"), configuration.testTimeout )

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions
      0