databasebigdataapache-doris

JDBC catalog query error: "Can not connect to jdbc due to error: wait millis 5000, active 10, maxActive 10, creating 0, Catalog"

I wanted to use JDBC catalog to connect to another database to perform a query, but I got a query error:

Can not connect to jdbc due to error: wait millis 5000, active 10, maxActive 10, creating 0, Catalog.

I searched Stack Overflow for related issues, but could not find anything. Therefore, I raised a question to see if anyone has encountered it

Solution

  • For JDBC catalog, the connection limit is 10 by default. You need to modify the maximum number of connections in the connection pool or rebuild the catalog with this parameter:

    alter catalog <catalog_name>
set properties (
  'connection_pool_max_size' = '100'
)

    For details, please refer to this Doris doc page: https://doris.apache.org/docs/lakehouse/database/jdbc?_highlight=connection_pool_max_size#connection-pool-properties