SELECT ALL FROM bogus_table LIMIT 0
Posted by: hazard four
Date: May 06, 2021 09:54AM

I'm not a developer but a system administrator,

I found this query `SELECT * FROM bogus_table LIMIT 0\G` in the MySQL-slow-query.log in the production server.

I asked the developer about this query and he has no idea where this query coming from.

Thank to this [post][1] i assume that `SELECT * FROM bogus_table LIMIT 0\G` is to clear the kill flag which mean this query will be trigger afterward if the previous query return an error. - please correct me if i'm wrong.

So here my question: How do i find/trace what query that running is triggering this query `SELECT * FROM bogus_table LIMIT 0\G` to be executed afterward (Based on my above assumption) ?

Thank you.

[1]: https://stackoverflow.com/questions/50407365/mysql-data-mysqlclient-mysqlexception-0x80004005-select-command-denied-to-use

Options: ReplyQuote


Subject
Written By
Posted
SELECT ALL FROM bogus_table LIMIT 0
May 06, 2021 09:54AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.