Troubleshooting Error: Query Request Timed Out in Queue

If you're experiencing dashboard timeouts or seeing the "There was a problem with your query, Query request timed out in Queue" error message, this is typically related to database connection pooling and query queuing. Here's what you need to know and how to resolve it.

Understanding the Issue

The system maintains a connection pool for each registered database data source. When all connections in the pool are busy, new queries are queued. If a queued query exceeds the timeout threshold, you'll receive an error message.

Default Configuration

By default, the system maintains approximately 6 connections in the connection pool per registered database. This configuration is designed to work efficiently with most standard database instances.

Resolving Timeout Issues

If you're experiencing timeout issues, there are two main approaches to resolve them:

1. Scale Your Database Instance

   • Increase the database instance size to improve query processing time

2. Adjust Connection Pool Size

   • Contact support to adjust the connection pool size based on your database specifications

   • The optimal pool size depends on your database's CPU cores and overall capacity