View Issue Details

IDProjectCategoryView StatusLast Update
0000818Pgpool-IIBugpublic2023-11-27 09:41
Reportergaryqiu Assigned Topengbo  
PrioritynormalSeverityminorReproducibilityhave not tried
Status feedbackResolutionopen 
Product Version4.4.3 
Summary0000818: pgpool generate warn mesage Unable to parse the query
DescriptionHi Support
I am using edb-pgpool44-4.4.3-1.el8.x86_64 as a front-end and edb-as14-server-14.9.1-1.el8.x86_64 as back-end.
Now we have a problem:
1. pgpool log generate many wan message 'Unable to parse the query' , even we are creating a table with one column for testing
   but actually that sql statement is right and DB can return query result
2. pgpool also reports this error when user login by pgadmin
3. current log level is default(#log_min_messages = warning )
4. I also find there are some users have same problem on google.
Could you help to review and help on this?

Thanks
Gary
Steps To Reproduce1. connect with pgadmin(version 7)
2. pgpool log file will generate a warn message something like Unable to parse the query
TagsNo tags attached.

Activities

pengbo

2023-11-27 09:41

developer   ~0004443

> I am using edb-pgpool44-4.4.3-1.el8.x86_64 as a front-end and edb-as14-server-14.9.1-1.el8.x86_64 as back-end.

It seems your are using pgpool provided by EDB.
If possible, could you try using Pgpool-II provided by the Pgpool-II development community to see if the same issue occurs?

Could you enable "log_per_node_statement = on" to log all statements and share the log?

Issue History

Date Modified Username Field Change
2023-11-15 18:09 garyqiu New Issue
2023-11-27 09:21 pengbo Assigned To => pengbo
2023-11-27 09:21 pengbo Status new => assigned
2023-11-27 09:41 pengbo Note Added: 0004443
2023-11-27 09:41 pengbo Status assigned => feedback