Postgres Pro
Downloads
Home   >   mailing lists

Thread: Timeout Issue

Timeout Issue

From
SOzcn
Date:
Hello, I am getting an error like the one below in a cluster. 

==SQL Error [57014]: ERROR: canceling statement due to statement timeout

The system generally works normally, but whenever I try to create or drop an index, I get this error.

Frankly, I tried many methods to fix the error. 

Like changing the index name and trying to instantly delete it. 
I stopped all applications connected to the database and tried again. But the result was the same. 
I did not understand how I got this error even though there was no session.

I also examined the Postgresql Logs, but there was nothing enough. When I started this progress there is no any load on my database server.

I using Postgresql v13.9 

2023-10-04 18:32:56.669 +03 [1339952] [user=user,db=dbname=DBeaver 21.2.1 - SQLEditor <Console>] ERROR:  canceling statement due to statement timeout

2023-10-04 18:32:56.669 +03 [1339952] [user=user,db=dbname,app=DBeaver 21.2.1 - SQLEditor <Console>] STATEMENT:  drop index dbname."indexname"

Any advice?

Re: Timeout Issue

From
Ron
Date:
On 10/4/23 13:13, SOzcn wrote:
Hello, I am getting an error like the one below in a cluster. 

==SQL Error [57014]: ERROR: canceling statement due to statement timeout

The system generally works normally, but whenever I try to create or drop an index, I get this error.

Frankly, I tried many methods to fix the error. 

Like changing the index name and trying to instantly delete it. 
I stopped all applications connected to the database and tried again. But the result was the same. 
I did not understand how I got this error even though there was no session.

I also examined the Postgresql Logs, but there was nothing enough. When I started this progress there is no any load on my database server.

I using Postgresql v13.9 

2023-10-04 18:32:56.669 +03 [1339952] [user=user,db=dbname=DBeaver 21.2.1 - SQLEditor <Console>] ERROR:  canceling statement due to statement timeout

2023-10-04 18:32:56.669 +03 [1339952] [user=user,db=dbname,app=DBeaver 21.2.1 - SQLEditor <Console>] STATEMENT:  drop index dbname."indexname"

Any advice?


Look at what the statement_timeout value is set to.  For example:
postgres=# SHOW STATEMENT_TIMEOUT;
 statement_timeout
-------------------
 0
(1 row)


--
Born in Arizona, moved to Babylonia.

RE: Timeout Issue

From
Date:

Hello,

 

What is your current statement_timeout?, I want to suggest to for SET statement_timeout = 60000; -- 60 seconds.

 

You can run the ANALYZE and VACUUM commands to optimize the table.

 

Regards,

Tayyab

 

 

 

 

 

From: SOzcn <selahattinozcnma@gmail.com>
Sent: Wednesday, October 4, 2023 11:14 AM
To: pgsql-admin@lists.postgresql.org
Subject: Timeout Issue

 

Hello, I am getting an error like the one below in a cluster. 

==SQL Error [57014]: ERROR: canceling statement due to statement timeout

 

The system generally works normally, but whenever I try to create or drop an index, I get this error.

Frankly, I tried many methods to fix the error. 

Like changing the index name and trying to instantly delete it. 

I stopped all applications connected to the database and tried again. But the result was the same. 

I did not understand how I got this error even though there was no session.

 

I also examined the Postgresql Logs, but there was nothing enough. When I started this progress there is no any load on my database server.

 

I using Postgresql v13.9 

2023-10-04 18:32:56.669 +03 [1339952] [user=user,db=dbname=DBeaver 21.2.1 - SQLEditor <Console>] ERROR:  canceling statement due to statement timeout

2023-10-04 18:32:56.669 +03 [1339952] [user=user,db=dbname,app=DBeaver 21.2.1 - SQLEditor <Console>] STATEMENT:  drop index dbname."indexname"

Any advice?