executing batch insert query: FATAL:

executing batch insert query: FATAL: terminating connection due to idle-in-transaction timeout (SQLSTATE 25P03)

5 Replies

continuing-cyan•8mo ago

Hi. Just shared this with team. Are you able to open a support ticket or share your project id on raouf@neon.tech? We will need your endpoint id to investigate the issue. We will get back to you as soon as we know more. And sorry for your trouble

grumpy-cyan•8mo ago

got it. i just created the support ticken or here is the project id ancient-surf-69236862 @raoufchebri

continuing-cyan•8mo ago

@syko idle_in_transaction_session_timeout is set to 5min by default.

neondb=> show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout 
-------------------------------------
 5min
(1 row)

neondb=> show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout 
-------------------------------------
 5min
(1 row)

You can you set it to a higher value:

neondb=> set idle_in_transaction_session_timeout='600000';
SET
neondb=> show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout 
-------------------------------------
 10min
(1 row)

neondb=> set idle_in_transaction_session_timeout='600000';
SET
neondb=> show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout 
-------------------------------------
 10min
(1 row)

Let me know if this helps

grumpy-cyan•8mo ago

ok. i will try let me know all possible configurations that would help us + where is your doc mentioning all these params? @raoufchebri @raoufchebri

continuing-cyan•8mo ago

Hi @syko thanks for pointing that out. It was in fact mentioned in one of the examples but not properly documented. We will add this asap. Have you tried to set it to 10min?

Gaming

Programming

executing batch insert query: FATAL:

Did you find this page helpful?