I'm not using the iBeacon parts at the moment but might if I can find the moving box I tossed the beacons I have in.
My logs are blowing up with SQL Logger and beacon stuff, and it's definitely increased the CPU load on my Indigo i3 Mac mini.
Here's what I see flooding the log:
- Code: Select all
Dec 18, 2020 at 3:43:41 PM
SQL Logger creating table device_history_1938907366 for "beacon_05:24:3C:C8:FE:2C"
SQL Logger modifying column "txpowerreceived" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "txpowerset" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger adding column "onoffstate_ui" to table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C")
SQL Logger creating table device_history_1426355854 for "beacon_4F:20:94:94:46:C5"
SQL Logger modifying column "txpowerreceived" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "txpowerset" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger adding column "onoffstate_ui" to table device_history_1426355854 ("beacon_4F:20:94:94:46:C5")
SQL Logger creating table device_history_141179452 for "beacon_5C:8E:33:DB:73:E1"
SQL Logger modifying column "txpowerreceived" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "txpowerset" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger adding column "onoffstate_ui" to table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1")
SQL Logger creating table device_history_793955583 for "beacon_60:45:37:88:07:B2"
SQL Logger modifying column "txpowerreceived" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "txpowerset" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger adding column "onoffstate_ui" to table device_history_793955583 ("beacon_60:45:37:88:07:B2")
SQL Logger modifying column "pi_01_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
SQL Logger modifying column "pi_01_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
SQL Logger modifying column "pi_01_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
SQL Logger modifying column "pi_01_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
SQL Logger modifying column "pi_01_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
SQL Logger modifying column "pi_01_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
SQL Logger modifying column "pi_01_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_02_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_03_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_04_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_05_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_06_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_07_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_08_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_09_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_10_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_11_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_12_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_13_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_14_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_15_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_16_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_17_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_18_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger modifying column "pi_19_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
SQL Logger creating table device_history_4543171 for "beacon_75:7D:79:84:4F:87"
SQL Logger modifying column "txpowerreceived" type of table device_history_4543171 ("beacon_75:7D:79:84:4F:87") from integer to REAL
SQL Logger modifying column "txpowerset" type of table device_history_4543171 ("beacon_75:7D:79:84:4F:87") from integer to REAL
SQL Logger adding column "onoffstate_ui" to table device_history_4543171 ("beacon_75:7D:79:84:4F:87")
SQL Logger creating table device_history_29127195 for "beacon_50:E8:94:2D:A7:10"
SQL Logger modifying column "txpowerreceived" type of table device_history_29127195 ("beacon_50:E8:94:2D:A7:10") from integer to REAL
SQL Logger modifying column "txpowerset" type of table device_history_29127195 ("beacon_50:E8:94:2D:A7:10") from integer to REAL
SQL Logger adding column "onoffstate_ui" to table device_history_29127195 ("beacon_50:E8:94:2D:A7:10")
I thought I had turned off the SQL Logger stuff for it, as in screenshot attached.
What am I doing wrong?
Thanks
Ross