Postgres Pro
Downloads
Home   >   mailing lists

auto_explain logs ERROR: 08P01 for every query using bind variable - Mailing list pgsql-bugs

From Ted Liu
Subject auto_explain logs ERROR: 08P01 for every query using bind variable
Date
Msg-id 1854294856.1773708.1580425497239@mail.yahoo.com
Whole thread Raw
Responses Re: auto_explain logs ERROR: 08P01 for every query using bind variable  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
Tree view
To whom it may concern,

For performance and security, most of our queries use bind variables. We also implemented auto_explain for tracking down un-optimized queries. Our database supports a large application. During the work-hours, there are 30,000+ queries executed every hour. PostgreSQL logs rotates every hour and each log contains 30,000+ error message like below.

2020-01-27 00:00:03 UTC:xxx.xx.0.189(35556):xxxxxx@xxxxxxdb:[130756]:ERROR:  ERROR: 08P01: bind message supplies 0 parameters, but prepared statement "..." requires 1 
2020-01-27 00:00:03 UTC:xxx.xx.0.189(35558):xxxxxx@xxxxxxdb:[130756]:LOCATION:  exec_bind_message, postgres.c:1601
2020-01-27 00:00:03 UTC:xxx.xx.0.189(35558):xxxxxx@xxxxxxdb:[130756]:STATEMENT:  EXPLAIN select ...,...,..,... from ... where ....=$1

These error messages are really overwhelming to us and they are not useful at all. In our opinion, these error messages should not be logged. 

Best Regards,

Ted Liu

 

pgsql-bugs by date:

Previous
From: Nick Memos
Date:
Subject: Re: BUG #16238: Function " to_char(timestamp, text) " doesn't workproperly
Next
From: PG Bug reporting form
Date:
Subject: BUG #16239: It is not possible to upgrade the password from md5 to SCRAM