Thanks for all of you for responding and clarifying things. Really
appreciate it.
We finally confirmed that it is a SET command issue where the AWX
application is firing the query without quotes and it's a known bug from
their end.
Thank you once again.
Regards
Mukesh Tanuku
On Mon, Feb 10, 2025
Mukesh Tanuku writes:
> Is this issue specifically reported in only the PG 15 version? more syntax
> sensitivity.
PG 15 and up report the syntax error differently.
regression=# set foo = 15min;
ERROR: trailing junk after numeric literal at or near "15min"
LINE 1: set foo = 15min;
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
wrote:
> Thanks for clarifying, got it.
> Is this issue specifically reported in only the PG 15 ve
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 wrote:
>
>
> On Mon, 2025-02-10 at 16:06 +0530, Mukesh Tanuku wrote:
> > Thanks for your quick responses.
> >
> > I have just added the
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', 8, 10s, '10s', '10 s')
>
> but i
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', 8, 10s, '10s', '10 s')
but i get an immediate error after reloading the configuration file.
*postgre
On Sunday, February 9, 2025, Tom Lane wrote:
> Mukesh Tanuku writes:
> > We unabled the postgres timeout parameters in the postgresql.conf file
>
> > *idle_in_transaction_session_timeout = '1min'idle_session_timeout =
> '5min'*
>
Did you actually run them together on one line like that?
>
I th
Mukesh Tanuku writes:
> We unabled the postgres timeout parameters in the postgresql.conf file
> *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'*
Did you actually run them together on one line like that? The normal
thing is one setting per line. It might be that the
On Mon, 10 Feb 2025 at 17:34, Mukesh Tanuku wrote:
> 2025-02-10 04:22:00.823 GMT [2468337] ERROR: trailing junk after numeric
> literal at or near "5m" at character 28
> 2025-02-10 04:22:00.823 GMT [2468337] STATEMENT: SET idle_session_timeout =
> 5min
> 2025-02-10 04:22:03.487 GMT [2468342] E
On Sunday, February 9, 2025, Mukesh Tanuku
wrote:
>
>
>
> *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'*
>
I suspect our docs may need an update. They say you may include white
space before the unit; it probably needs to be changed to “must”. I
believe we’ve recentl
10 matches
Mail list logo
