Recently I started to see some "Info" messages in the log, about failing SELECT statements. I didn't pay much attention to it, assuming it was an incident. Just not I restarted the plugin, and I have hundreds of those messages in the log. Should I be worried? Is my database corrupt? A few examples:
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteScalar SELECT count(Source) as extant FROM MQTT_MESSAGE WHERE (Source='stat/SlaapkamerKast/STATUS11:StatusSTS:Wifi:0�tele/SlaapkamerKast/STATE{Time') Line 0 SQLite error unrecognized token: "'stat/SlaapkamerKast/STATUS11:StatusSTS:Wifi:0�"
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteCommand INSERT INTO MQTT_MESSAGE (Source, Topic, Payload, Template, Pattern, Replace, Match, LastDate, Reject, Express, Elevate, ElevateKeys, URIEncode, Accept, RetainFlag, PluginDevice, Subscribe, History, StorePayload, Ref, Misc, QOS, StatusType, Chart, ChangeType, Broker, RefList, Energy, VgpMax) Values ('stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�&stat/SlaapkamerRolluikZijkant/STATUS11{StatusSTS:UptimeSec','','98785','','','','0','2021-01-31 17:16:56',0,0,0,'',0,0,0,1,0,0,0,-1,4112,0,0,0,1,0,'',0,12) Line 0 SQLite error unrecognized token: "'stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�"
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteScalar SELECT count(Source) as extant FROM MQTT_MESSAGE WHERE (Source='stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�&stat/SlaapkamerRolluikZijkant/STATUS11{StatusSTS:UptimeSec') Line 0 SQLite error unrecognized token: "'stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�"
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteCommand INSERT INTO MQTT_MESSAGE (Source, Topic, Payload, Template, Pattern, Replace, Match, LastDate, Reject, Express, Elevate, ElevateKeys, URIEncode, Accept, RetainFlag, PluginDevice, Subscribe, History, StorePayload, Ref, Misc, QOS, StatusType, Chart, ChangeType, Broker, RefList, Energy, VgpMax) Values ('stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�&stat/SlaapkamerRolluikZijkant/STATUS11{StatusSTS:Uptime','','1T03:26:25','','','','0','202 1-01-31 17:16:56',0,0,0,'',0,0,0,1,0,0,0,-1,4112,0,0,0,1,0,'',0,12) Line 0 SQLite error unrecognized token: "'stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�"
Thanks!
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteScalar SELECT count(Source) as extant FROM MQTT_MESSAGE WHERE (Source='stat/SlaapkamerKast/STATUS11:StatusSTS:Wifi:0�tele/SlaapkamerKast/STATE{Time') Line 0 SQLite error unrecognized token: "'stat/SlaapkamerKast/STATUS11:StatusSTS:Wifi:0�"
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteCommand INSERT INTO MQTT_MESSAGE (Source, Topic, Payload, Template, Pattern, Replace, Match, LastDate, Reject, Express, Elevate, ElevateKeys, URIEncode, Accept, RetainFlag, PluginDevice, Subscribe, History, StorePayload, Ref, Misc, QOS, StatusType, Chart, ChangeType, Broker, RefList, Energy, VgpMax) Values ('stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�&stat/SlaapkamerRolluikZijkant/STATUS11{StatusSTS:UptimeSec','','98785','','','','0','2021-01-31 17:16:56',0,0,0,'',0,0,0,1,0,0,0,-1,4112,0,0,0,1,0,'',0,12) Line 0 SQLite error unrecognized token: "'stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�"
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteScalar SELECT count(Source) as extant FROM MQTT_MESSAGE WHERE (Source='stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�&stat/SlaapkamerRolluikZijkant/STATUS11{StatusSTS:UptimeSec') Line 0 SQLite error unrecognized token: "'stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�"
1-31-2021 22:02:34
mcsMQTT
Info
ExecuteCommand INSERT INTO MQTT_MESSAGE (Source, Topic, Payload, Template, Pattern, Replace, Match, LastDate, Reject, Express, Elevate, ElevateKeys, URIEncode, Accept, RetainFlag, PluginDevice, Subscribe, History, StorePayload, Ref, Misc, QOS, StatusType, Chart, ChangeType, Broker, RefList, Energy, VgpMax) Values ('stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�&stat/SlaapkamerRolluikZijkant/STATUS11{StatusSTS:Uptime','','1T03:26:25','','','','0','202 1-01-31 17:16:56',0,0,0,'',0,0,0,1,0,0,0,-1,4112,0,0,0,1,0,'',0,12) Line 0 SQLite error unrecognized token: "'stat/SlaapkamerRolluikZijkant/STATUS10:StatusSNS:ENERGY:Factor0�"
Thanks!
Comment