[11:08] https://www.raspberrypi.org/blog/free-aiy-projects-voice-kit-magpi-57/ [12:17] morning [12:17] <_stink_> yo [12:23] Morning [12:42] morning [12:45] How is the day so far? [12:48] zzzz [12:48] * shakes808 wants to go back to bed [12:51] I can understand that [15:20] has anyone come across MySQL error code 126: Incorrect key file for table... try to repair it [15:22] i ran mysqlcheck on it and it comes back with a table with :: warning: found row where auto_increment column has the value 0 :: status: ok [15:23] i ran the mysqlcheck -r on that db table and it says it doesn't exist. i can run queries on it. so i know it is there [15:25] i ran myisamchk on it and it says it doesn't exist there too. [15:25] I look int the /var/lib/mysql/db/ and see that it is there [15:26] i can query it in mysql workbench and command line mysql [17:55] i think i found my issue. not enough space for the tmp file. tracked it down to a file that got up to ~1.7GB before stopping the query with that message. [17:56] probably because i have some history tables there. but wouldn't think that would happen since i was only pulling one order out. ... mpfh [17:56] ¯\_(ツ)_/¯ [18:06] shakes808: That's a strange way to complain about not-enough-space [18:07] but good to know [18:07] haha right?! [20:20] i'm surprised greg-g hasn't moved all to postgresql yet ;p [20:22] I'm sre if he could he would. [21:11] hrmm? [21:30] evening everyone [21:31] jrwren: I missed the context? [22:50] greg-g: just shakes808 having mysql issues :) [22:51] Stupid temp files getting too large :-( [23:03] jrwren: why would I move all to postgresql? [23:22] greg-g: because mysql is bad ;] [23:51] why is it my responsibility?!