View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000686Pgpool-IIBugpublic2021-01-22 11:522021-01-26 11:49
Reporter363568233@qq.com Assigned Topengbo  
PriorityhighSeveritymajorReproducibilityalways
Status assignedResolutionopen 
Platformpostgresql 12OSRed Hat Enterprise Linux Server OS Version7.6
Product Version3.7.10 
Summary0000686: load balance invalid
Descriptionpgpool primary态standby

execute('/*NO LOAD BALANCED*/select * from t_test') first

then execute a sql without comment , the sql load balance invalid
Steps To Reproduceimport psycopg2


conn = psycopg2.connect(dbname="dbtest", user="pgpool", password="pgpool", host=VIP, port="9999")

with conn.cursor() as cur:

    for i in range(10):

        cur.execute('/*NO LOAD BALANCED*/select * from t_test')

        cur.execute("select * from t_test where name = 'qqq{}'".format(i))

conn.close()
TagsNo tags attached.

Activities

363568233@qq.com

2021-01-22 11:52

reporter  

psycopg2_pgpool.png (96,760 bytes)   
psycopg2_pgpool.png (96,760 bytes)   

363568233@qq.com

2021-01-22 11:54

reporter   ~0003726

python psycopg2

363568233@qq.com

2021-01-22 18:25

reporter   ~0003727

it not a problem with JDBC, I guess it's a bug in psycopg2

pengbo

2021-01-26 09:27

developer   ~0003728

Sorry for late response.
Have you resolved this issue?

363568233@qq.com

2021-01-26 11:49

reporter   ~0003729

not yet
I guess psycopg2 has a cache internal that keeps comment statements so that all subsequent queries are commented.
In SQLAlchemy with psycopg2 , has similar problems but there are some differences

Issue History

Date Modified Username Field Change
2021-01-22 11:52 363568233@qq.com New Issue
2021-01-22 11:52 363568233@qq.com File Added: psycopg2_pgpool.png
2021-01-22 11:54 363568233@qq.com Note Added: 0003726
2021-01-22 18:25 363568233@qq.com Note Added: 0003727
2021-01-26 09:27 pengbo Note Added: 0003728
2021-01-26 09:27 pengbo Assigned To => pengbo
2021-01-26 09:27 pengbo Status new => feedback
2021-01-26 09:27 pengbo Description Updated
2021-01-26 09:27 pengbo Steps to Reproduce Updated
2021-01-26 11:49 363568233@qq.com Note Added: 0003729
2021-01-26 11:49 363568233@qq.com Status feedback => assigned