public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mukesh Tanuku <[email protected]>
To: rob stone <[email protected]>
Cc: [email protected]
Subject: Re: PG-15.6: timeout parameters erroring out
Date: Mon, 10 Feb 2025 19:06:00 +0530
Message-ID: <CAJzgB-FbFXNCCBa1Yr10DY-n4wjptfacrzJNC5ZWp8FGGDm2SA@mail.gmail.com> (raw)
In-Reply-To: <CAJzgB-Fr+_4tEgHd9FPO_KbvnVSEMMiBjQxJ3TaJugS=hUgZCg@mail.gmail.com>
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
	<[email protected]>
	<CAKFQuwY6VqAAHxHK73oymxwg=nRpEnTnQQNBq+fTtjR+Fecp=A@mail.gmail.com>
	<CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg@mail.gmail.com>
	<[email protected]>
	<CAJzgB-Fr+_4tEgHd9FPO_KbvnVSEMMiBjQxJ3TaJugS=hUgZCg@mail.gmail.com>

I see there is some open PR in awx-operator (
https://github.com/ansible/awx/issues/15406) which is related to this. AWX
is connected to DB in my case.

On Mon, Feb 10, 2025 at 7:04 PM Mukesh Tanuku <[email protected]>
wrote:

> Thanks for clarifying, got it.
> Is this issue specifically reported in only the PG 15 version? more syntax
> sensitivity.
>
> On Mon, Feb 10, 2025 at 6:09 PM rob stone <[email protected]> wrote:
>
>>
>>
>> On Mon, 2025-02-10 at 16:06 +0530, Mukesh Tanuku wrote:
>> > Thanks for your quick responses.
>> >
>> > I have just added the session related timeout parameters in the
>> > postgresql.conf file also tried tweaking with different
>> > values/patterns like ('1min', '1 min', 80000, 10s, '10s', '10 s')
>> >
>> > but i get an immediate error after reloading the configuration file.
>> >
>> > postgres.log file
>> > 2025-02-10 10:27:10.748 GMT [934108] LOG:  received SIGHUP, reloading
>> > configuration files
>> > 2025-02-10 10:27:10.749 GMT [934108] LOG:  parameter
>> > "idle_in_transaction_session_timeout" changed to "80000"
>> > 2025-02-10 10:27:16.117 GMT [2531150] ERROR:  trailing junk after
>> > numeric literal at or near "80s" at character 43
>> > 2025-02-10 10:27:16.117 GMT [2531150] STATEMENT:  SET
>> > idle_in_transaction_session_timeout = 80s
>> >
>> > though we are not firing any SQL statements explicitly we see this
>> > error.
>> >
>> > i guess something else is the issue other than spacing.
>> >
>> >
>>
>> I'd say that 934108 is the config file reload and that 2531150 is from
>> somebody running psql from a shell or SQL code coming out from an
>> application.
>>
>>
>>
>> >
>>
>

view thread (6+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PG-15.6: timeout parameters erroring out
  In-Reply-To: <CAJzgB-FbFXNCCBa1Yr10DY-n4wjptfacrzJNC5ZWp8FGGDm2SA@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox