From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Timeout Issue
Date: Wed, 4 Oct 2023 13:56:40 -0500
Message-ID: <86c77066-b696-9c0f-a4e9-8f9bc5b48048@gmail.com> (raw)
In-Reply-To: <CAJyV5Abk28zTXF_44hRW-TFV5X3GMrU-=s9qQv5fX1UFjafFsA@mail.gmail.com>
References: <CAJyV5Abk28zTXF_44hRW-TFV5X3GMrU-=s9qQv5fX1UFjafFsA@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Timeout Issue
In-Reply-To: <86c77066-b696-9c0f-a4e9-8f9bc5b48048@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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