# Lots of show warnings is executing after each query to db.

**URL:** <https://forums.percona.com/t/lots-of-show-warnings-is-executing-after-each-query-to-db/4399>\
**Category:** Other MySQL® Questions\
**Created:** [September 16, 2015, 7:20am UTC](https://forums.percona.com/t/lots-of-show-warnings-is-executing-after-each-query-to-db/4399 "2015-09-16T07:20:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![singh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/singh/32/1058_2.png) [@singh](https://forums.percona.com/u/singh)\
**Post date:** [September 16, 2015, 7:20am UTC](https://forums.percona.com/t/lots-of-show-warnings-is-executing-after-each-query-to-db/4399/1 "2015-09-16T07:20:40Z")

</div>

Hi

I have noticed a strange stuff today when logged in the general\_log to true and was checking that is happening in the server , it shows up lot of SHOW WARNING being executed after each query though its because of hibernate so i suspected its because of this [URL=“[Why is 'SHOW WARNINGS' query issued here? (JPA/Hibernate/MySQL) - Stack Overflow](http://stackoverflow.com/questions/30926597/why-is-show-warnings-query-issued-here-jpa-hibernate-mysql)”][http://stackoverflow.com/questions/3...ibernate-mysql[/URL]](http://stackoverflow.com/questions/3...ibernate-mysql%5B/URL%5D) and affects 5.6 version

Has some one experienced the same.

This is setting related to warnings and general log

log\_warnings | 2 |  
| log\_warnings\_suppress | 1592 |  
| sql\_warnings | OFF

general\_log | OFF |  
| general\_log\_file | //dbs/localhost.log |

Br  
Chandu