Content-Type: multipart/alternative;
 boundary="------------jEjBX0O7N4aExCB25ER44RoM"
Message-ID: <86c77066-b696-9c0f-a4e9-8f9bc5b48048@gmail.com>
Date: Wed, 4 Oct 2023 13:56:40 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: Timeout Issue
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJyV5Abk28zTXF_44hRW-TFV5X3GMrU-=s9qQv5fX1UFjafFsA@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAJyV5Abk28zTXF_44hRW-TFV5X3GMrU-=s9qQv5fX1UFjafFsA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/86c77066-b696-9c0f-a4e9-8f9bc5b48048%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------jEjBX0O7N4aExCB25ER44RoM
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.
--------------jEjBX0O7N4aExCB25ER44RoM
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 10/4/23 13:13, SOzcn wrote:<br>
    <blockquote type="cite"
cite="mid:CAJyV5Abk28zTXF_44hRW-TFV5X3GMrU-=s9qQv5fX1UFjafFsA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hello, I am getting an error like the one below in
        a cluster. <br>
        <br>
        ==SQL Error [57014]: ERROR: canceling statement due to statement
        timeout<br>
        <div><br>
        </div>
        <div>The system generally works normally, but whenever I try to
          create or drop an index, I get this error.<br>
          <br>
          Frankly, I tried many methods to fix the error. <br>
          <br>
          Like changing the index name and trying to instantly delete
          it. </div>
        <div>I stopped all applications connected to the database and
          tried again. But the result was the same. <br>
        </div>
        <div>I did not understand how I got this error even though there
          was no session.</div>
        <div><br>
        </div>
        <div>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.</div>
        <div><br>
        </div>
        <div>I using Postgresql v13.9 <br>
          <br>
          <p class="MsoNormal" style="margin:0in 0in
            0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><b>2023-10-04
              18:32:56.669 +03 [1339952] [user=user,db=dbname=DBeaver
              21.2.1 - SQLEditor &lt;Console&gt;] ERROR: 
              canceling statement due to statement timeout</b></p>
          <p class="MsoNormal" style="margin:0in 0in
            0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><b>2023-10-04
              18:32:56.669 +03 [1339952]
              [user=user,db=dbname,app=DBeaver
              21.2.1 - SQLEditor &lt;Console&gt;] STATEMENT: 
              drop index dbname."indexname"<br>
              <br>
              Any advice?</b></p>
        </div>
      </div>
    </blockquote>
    <br>
    Look at what the statement_timeout value is set to.  For example:<br>
    <font face="monospace">postgres=# SHOW STATEMENT_TIMEOUT;<br>
       statement_timeout <br>
      -------------------<br>
       0<br>
      (1 row)<br>
    </font><br>
    <br>
    <div class="moz-signature">-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </body>
</html>

--------------jEjBX0O7N4aExCB25ER44RoM--