| From: | SOzcn <selahattinozcnma(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Timeout Issue |
| Date: | 2023-10-04 18:13:40 |
| Message-ID: | CAJyV5Abk28zTXF_44hRW-TFV5X3GMrU-=s9qQv5fX1UFjafFsA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2023-10-04 18:56:40 | Re: Timeout Issue |
| Previous Message | Goran Pulevic | 2023-10-04 16:23:22 | Re: Idle_session_timeout |