This script causes a hang issue

[cuteDen-ECNU]

This is a bug tracker If you have a question, such has "how do you do X with Python/PostgreSQL/psycopg2" please write to the mailing list or open a question instead.

Please complete the following information:

• OS: Linux
• Psycopg version: GitHub latest version (hash: 5fb59cd6eebd96e2c8a69a3a9d606534eb95abf0)
• Python version: Python 3.10.12 (main, Jun 11 2023, 05:26:28)
• PostgreSQL version: GitHub latest version (hash b19890d49d122257ddcdb7ab2c5038f5075906c1)
• pip version

Describe the bug Please let us know:

Executing the following script will cause a hang issue:

$ cat test.py
import psycopg2
db_params = {
            'host': "localhost",
            'port': "5432",
            'database': "nyc",
            'user': "postgres",
        }
conn1 = psycopg2.connect(**db_params)
cursor1 = conn1.cursor()

conn = psycopg2.connect(**db_params)

cursor = conn.cursor()
cursor.execute('DROP TABLE IF EXISTS tableB;' )
cursor.execute('CREATE TABLE tableB (id int);' )
cursor.execute('DROP TABLE IF EXISTS tableB;' )
cursor1.execute('DROP TABLE IF EXISTS tableB;' )

$ timeout 30 python3 test.py

$ echo $?
124

124 is a timeout error code. It executed without returning results, which seems a bug.

[dvarrazzo]

It's definitely not a bug. Most likely you have database locks that stops these operations to complete. You can look at the pg_locks table to figure out what is locking your statement.