Since 0.65.5 hassio, recorder purge doesnt do anything and the db file is growing larger and larger. set the purge to run each 3 days.
together with 65.5 i installed the file sensor, and folder sensor. Might they be interfering with the recorder component, not releasing the folder/file for purging?
noticed a rather laggy situation just now, and went into the log file, with below section as result. What would this refer to and more importantly, what can we do about this. Ive checked the sql link at the end but that doesnt really give a clue to what could be done?:
2018-03-23 17:26:12 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) disk I/O error [SQL: 'DELETE FROM events WHERE events.time_fired < ? AND events.event_id NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'] [parameters: ('2018-03-20 16:18:08.140574', 7084669, 7109391, 7176760, 7428698, 7428700, 7469743, 7478104, 7478105, 7478106, 7481660, 7500175, 7570001, 7570817, 7570839, 7577277, 7587483, 7587520, 7587526, 7587532, 7587545, 7587546, 7587547, 7587548, 7587563, 7587564, 7587569, 7587572, 7587576, 7587579, 7587580, 7587585, 7587586, 7587591, 7587619, 7587624, 7587625, 7587636, 7587656, 7587659, 7587662, 7587664, 7587669, 7587672, 7587676, 7587677, 7587682, 7587684, 7587690, 7587694, 7587696, 7587702, 7587706, 7587708, 7587713, 7587715, 7587719, 7587723, 7587726, 7587736, 7587737, 7587738, 7587739, 7587740, 7587741, 7587743, 7587744, 7587745, 7587746, 7587747, 7587748, 7587749, 7587750, 7587751, 7587752, 7587753, 7587850, 7587851, 7587852, 7587853, 7587854, 7587855, 7587856, 7587857, 7587858, 7587859, 7587860, 7587862, 7587863, 7587864, 7587865, 7587867, 7587869, 7587870, 7587871, 7587898, 7587905, 7587906, 7587908, 7587909, 7587911, 7587912, 7587913, 7587914, 7587915, 7587917, 7587918, 7587919, 7587920, 7587921, 7587922, 7587924, 7587925, 7587926, 7587927, 7587928, 7587929, 7587930, 7587931, 7587932, 7587933, 7587934, 7587935, 7587936, 7587937, 7587938, 7587939, 7587943, 7588004, 7588005, 7588006, 7588007, 7588037, 7588038, 7588039, 7588040, 7588041, 7588042, 7588044, 7588045, 7588046, 7588048, 7588049, 7588050, 7588055, 7588094, 7588097, 7588098, 7588099, 7588104, 7588106, 7588109, 7588112, 7588116, 7588118, 7588119, 7588121, 7588125, 7588159, 7588160, 7588161, 7588165, 7588166, 7588168, 7588169, 7588170, 7588172, 7588174, 7588176, 7588177, 7588180, 7588184, 7588204, 7588205, 7588206, 7588207, 7588208, 7588210, 7588211, 7588212, 7588213, 7588215, 7588216, 7588217, 7588218, 7588220, 7588221, 7588222, 7588223, 7588225, 7588230, 7588231, 7588232, 7588236, 7588237, 7588352, 7588353, 7588354, 7588368, 7588371, 7588374, 7588375, 7588376, 7588377, 7588380, 7588382, 7588384, 7588387, 7588391, 7588392, 7588393, 7588396, 7588397, 7588398, 7588399, 7588400, 7588401, 7588402, 7588403, 7588404, 7588405, 7588406, 7588407, 7588408, 7588409, 7588410, 7588411, 7588412, 7588413, 7588414, 7588415, 7588418, 7588420, 7588421, 7588422, 7588423, 7588424, 7588429, 7588430, 7588431, 7588433, 7588434, 7588435, 7588442, 7588443, 7588496, 7588499, 7588506, 7588512, 7588525, 7588526, 7588542, 7588543, 7588545, 7588546, 7588548, 7588556, 7588568, 7588570, 7588583, 7588587, 7588590, 7588602, 7588611, 7588634, 7588635, 7588668, 7588716, 7588765, 7588766, 7588819, 7588829, 7588841, 7588853, 7588861, 7588874, 7588877, 7588890, 7588894, 7588899, 7588901, 7588906, 7588907, 7588908, 7588910, 7588911, 7588912, 7588913, 7588914, 7588915, 7588917, 7588918, 7588921, 7588922, 7588925, 7588926, 7588927, 7588928, 7588930, 7588931, 7588933, 7588935, 7588937, 7588940, 7588942, 7588943, 7588944, 7588945, 7588949, 7588952, 7588953, 7588954, 7588965, 7588968, 7588990, 7588991, 7588992, 7588993, 7588994, 7588995, 7589004, 7589005, 7589006, 7589007, 7589008, 7589010, 7589012, 7589314, 7589315, 7589317, 7589318, 7589319, 7589320, 7589322, 7589323, 7589324, 7589325, 7589327, 7589328, 7589329, 7589331, 7589333, 7589605, 7589847, 7589973, 7589978, 7590108, 7590576, 7590582, 7590842, 7590847, 7591115, 7591163, 7591166, 7591238, 7591239, 7591240, 7591287, 7591605, 7591606, 7591607, 7591608, 7591609, 7591610, 7591611, 7591612, 7591613, 7591614, 7591620, 7591621, 7591694, 7591695, 7591800, 7592265, 7592497, 7592623, 7592641, 7592768, 7592769, 7592855, 7592856, 7592857, 7592858, 7592859, 7592860, 7592862, 7592933, 7592934, 7592936, 7592971, 7593014, 7593031, 7593239, 7593241, 7593355, 7593394, 7593397, 7593400, 7593402, 7593403, 7593404, 7593405, 7593415, 7593416, 7593417, 7593418, 7593420, 7593503, 7593517, 7593571, 7593581, 7593629, 7593661, 7593717, 7593777, 7593778, 7593809, 7593811, 7593813, 7593839, 7593852, 7593853, 7593891, 7593896, 7593897, 7593898, 7593958, 7593959, 7593960, 7593962, 7593973, 7593976, 7593977, 7593979, 7593980, 7593981, 7593985, 7594005, 7594018, 7594022, 7594029, 7594035, 7594038, 7594039, 7594040, 7594041, 7594042, 7594043, 7594044, 7594046, 7594047, 7594048, 7594049, 7594050, 7594051, 7594052, 7594053, 7594054, 7594055, 7594056, 7594057, 7594058, 7594059, 7594060, 7594061, 7594062, 7594063, 7594064, 7594065, 7594066)] (Background on this error at: http://sqlalche.me/e/e3q8)