server closed the connection unexpectedly

[BAnilKumar]

Hi All,

I am trying to update postgresSQL table with psycopg2, able to do when i run code manually but while calling in a function it is failing with below error.

**server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.**

Here is the code

from psycopg2 import pool

now  = datetime.now()
logoff_time = datetime(now.year, now.month, now.day, 15, 0, 0)                      
while True:            
	time.sleep(1)
	try:
		status = 'EXECUTED'
		exec_type1 = 'CANCELLED'
		exec_type2 = 'COMPLETED'
		
		try:
			postgreSQL_pool = pool.SimpleConnectionPool(1, 4, host = db_host,
										database = db_name,
										port = db_port,
										user = db_user,
										password = db_pwd)
			if postgreSQL_pool:
				print("Connection pool created successfully")
				conn = postgreSQL_pool.getconn()
		except (Exception, psycopg2.DatabaseError) as error:
			print(error)
		
		sql = """ UPDATE orders SET status = %s, executed_type = %s WHERE order_id = %s"""
		updated_rows = 0
		try:
			cur = conn.cursor()
			cur.execute(sql, (status, exec_type, order_id,))
			conn.commit()
			updated_rows = cur.rowcount
			cur.close()
		except (Exception, psycopg2.DatabaseError) as error:
			print(error)

		print(updated_rows)

psycopg2 version: '2.8.6 (dt dec pq3 ext lo64)'
Postgres: PostgreSQL 12.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit
and did not see any aborted status during error time (in server activity).

it is pretty much simple task but facing challenges. Can some one help me?

[dvarrazzo]

Are you using psycopg with multiprocessing, Celery, or some other job dispatcher?

[BAnilKumar]

i am not using multiprocessing, it is sequence execution (just using above code).