Timeout Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux