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.
Born in Arizona, moved to Babylonia.
