pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTimeout Issue
3+ messages / 3 participants
[nested] [flat]
* Timeout Issue
@ 2023-10-04 18:13 SOzcn <selahattinozcnma@gmail.com>
2023-10-04 18:56 ` Re: Timeout Issue Ron <ronljohnsonjr@gmail.com>
2023-10-04 19:03 ` RE: Timeout Issue tayyab.humayl@gmail.com
0 siblings, 2 replies; 3+ messages in thread
From: SOzcn @ 2023-10-04 18:13 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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?*
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Timeout Issue
2023-10-04 18:13 Timeout Issue SOzcn <selahattinozcnma@gmail.com>
@ 2023-10-04 18:56 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ron @ 2023-10-04 18:56 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Timeout Issue
2023-10-04 18:13 Timeout Issue SOzcn <selahattinozcnma@gmail.com>
@ 2023-10-04 19:03 ` tayyab.humayl@gmail.com
1 sibling, 0 replies; 3+ messages in thread
From: tayyab.humayl@gmail.com @ 2023-10-04 19:03 UTC (permalink / raw)
To: 'SOzcn' <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-10-04 19:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-04 18:13 Timeout Issue SOzcn <selahattinozcnma@gmail.com>
2023-10-04 18:56 ` Ron <ronljohnsonjr@gmail.com>
2023-10-04 19:03 ` tayyab.humayl@gmail.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox