RE: Timeout Issue
| От | |
|---|---|
| Тема | RE: Timeout Issue |
| Дата | |
| Msg-id | 003201d9f6f5$7d741400$785c3c00$@gmail.com обсуждение исходный текст |
| Ответ на | Timeout Issue (SOzcn <selahattinozcnma@gmail.com>) |
| Список | pgsql-admin |
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?
В списке pgsql-admin по дате отправления: