Page 3 of 4
Re: Rename the service problem
Posted: Tue Mar 03, 2015 10:29 am
by phyo
lmiltchev wrote:phyo, I believe Andy meant:
I am sorry about that! Can you show us the output of the command above?
Here is the output!
Code: Select all
[root@nagios01 /]# tail -10 /var/log/mysqld.log
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='859' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='857' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='858' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='860' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='850' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='851' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='852' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='853' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='854' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='866' LIMIT 1
[root@nagios01 /]#
Re: Rename the service problem
Posted: Tue Mar 03, 2015 12:29 pm
by abrist
Can you post a much bigger tail of the mysql log? (in code wraps please)
Re: Rename the service problem
Posted: Tue Mar 03, 2015 8:53 pm
by phyo
abrist wrote:Can you post a much bigger tail of the mysql log? (in code wraps please)
Here is the output file.
Code: Select all
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='813' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='815' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='826' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='829' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='912' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='840' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='913' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='846' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='847' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='864' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='862' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='865' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='861' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='863' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='841' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='842' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='843' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='844' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='845' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='855' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='783' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='774' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='797' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='777' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='792' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='772' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='806' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='769' LIMIT 1
150225 11:39:22 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='785' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='775' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='799' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='551' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='868' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='869' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='867' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='882' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='883' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='884' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='885' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='550' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='870' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='871' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='874' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='872' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='873' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='547' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='548' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='875' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='879' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='880' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='881' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='556' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='557' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='558' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='559' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='560' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='561' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='562' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='563' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='564' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='565' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='566' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='567' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='568' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='569' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='513' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='526' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='705' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='696' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='687' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='701' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='692' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='683' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='700' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='691' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='682' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='708' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='699' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='690' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='703' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='694' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='685' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='702' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='693' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='684' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='704' LIMIT 1
150225 11:39:23 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='695' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='686' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='706' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='697' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='688' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='707' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='698' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='689' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='732' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='723' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='714' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='728' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='719' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='710' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='727' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='718' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='709' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='735' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='726' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='717' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='730' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='721' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='712' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='729' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='720' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='711' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='731' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='722' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='713' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='733' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='724' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='715' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='734' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='725' LIMIT 1
150225 11:39:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='716' LIMIT 1
150225 11:41:08 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='738' LIMIT 1
150225 11:41:08 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='808' LIMIT 1
150225 11:41:08 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='739' LIMIT 1
150225 11:41:08 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='818' LIMIT 1
150225 11:41:08 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='819' LIMIT 1
150225 11:41:09 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='820' LIMIT 1
150225 11:41:09 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='821' LIMIT 1
150225 11:41:09 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='822' LIMIT 1
150225 11:41:09 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='823' LIMIT 1
150225 11:41:09 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='810' LIMIT 1
150225 11:41:09 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='812' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='814' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='816' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='817' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='740' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='849' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='741' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='848' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='856' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='859' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='857' LIMIT 1
150225 11:42:32 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='858' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='860' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='850' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='851' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='852' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='853' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='854' LIMIT 1
150225 11:42:33 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='866' LIMIT 1
Thanks.
Re: Rename the service problem
Posted: Wed Mar 04, 2015 10:01 am
by lmiltchev
Unfortunately, this didn't provide us with any new info. Are you using mysql replication in your environment? It is possible that this issue is caused by a known bug:
https://dev.mysql.com/doc/refman/5.1/en ... limit.html
Re: Rename the service problem
Posted: Thu Mar 05, 2015 1:12 pm
by phyo
Yes we use mysql replication with another server which is standby server.
After restarting the master server, all of the old services are gone.
But there is same issue. Currently there are one warning and one critical services. Then i acknowledge and disable the notification. But after a few minutes later, it seem remove the acknowledge and appear in the operation center page. A few minutes later, it back to ack disappear from operation center again. So these two situation are keep changing.
any suggestion?
Re: Rename the service problem
Posted: Thu Mar 05, 2015 4:45 pm
by tgriep
Can you go to "Admin" > "Manage Components" and post back the version of the Operations Center Component?
Re: Rename the service problem
Posted: Fri Mar 06, 2015 10:21 am
by phyo
tgriep wrote:Can you go to "Admin" > "Manage Components" and post back the version of the Operations Center Component?
Operations Center Component version is 1.0.2
Re: Rename the service problem
Posted: Fri Mar 06, 2015 2:28 pm
by lmiltchev
Operations Center Component version is 1.0.2
This looks good - your Operations Center Component is up to date.
Can you try stopping/starting the services to see if this is going to fix the issue?
Code: Select all
service nagios stop
killall nagios
service ndo2db stop
killall ndo2db
service ndo2db start
service nagios start
Re: Rename the service problem
Posted: Mon Mar 09, 2015 4:16 am
by phyo
lmiltchev wrote:Operations Center Component version is 1.0.2
This looks good - your Operations Center Component is up to date.
Can you try stopping/starting the services to see if this is going to fix the issue?
Code: Select all
service nagios stop
killall nagios
service ndo2db stop
killall ndo2db
service ndo2db start
service nagios start
This one also can't fix our issue.
Actually there is no issue on nagios core. Then we stop mysql db replication and monitoring the status. Everything is fine when we stop mysql db replication. Seems there is the issue on xi if we have mysql db replication.
Re: Rename the service problem
Posted: Mon Mar 09, 2015 1:30 pm
by abrist
Your replication setup is most likely not updating both databases correctly. Could you possibly be running into max connection limits on the secondary db?
What method of replication are you using?