log_error_verbosity set to terse but error log has entire query

[Nipun Kanade]

Hi, 

I have a postgres function which is returning an error to my application if the data is old and i have a newer version already in db (idempotency check). 

for one execution of this function it is generating a log message that is spread to over 50 individual logs. 

This is polluting my db-logs and there is no way to filter it out in stack-trace

I tried enabling  log_error_verbosity flag and set it to 'terse' but this is not helping as well. still I am seeing these logs.

Is it a bug or I am doing something wrong?

three issues . 

1. log message spread to ~ 50 log entries
2. log_error_verbosity not working as expected
   
3. log message is also coming as info and not error 
4. 

[George (Cloud Platform Support)]

Hello Nipun, 

log_error_verbosity flag controls the amount of detail written in the server log for each message that is logged. Valid values are TERSE, DEFAULT, and VERBOSE, each adding more fields to displayed messages. TERSE excludes the logging of DETAIL, HINT, QUERY, and CONTEXT error information, as mentioned on the "Error Reporting and Logging" page. Did you notice any of these error information headers populated with actual values, in your logs? 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching the app engine. For coding and database set up, as well as PostgreSQL flags usage, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

[Nipun]

Hi George. thanks for the reply. setting value to terse in flag has no change on the logs. 

I will raise a question on stack overflow

thanks.

Regards, Nipun Kanade
Application Developer
Email	nip...@thoughtworks.com
Telephone	+919977893993

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8f8f18d2-57cf-4013-92a2-046ca1ca43d9%40googlegroups.com.

[Ben Hizak]

H Nipun,

I suspect that your flag log_statement=all .

• https://www.postgresql.org/docs/9.6/runtime-config-logging.html#GUC-LOG-STATEMENT
  
• https://cloud.google.com/sql/docs/postgres/flags