shakes808 | https://www.raspberrypi.org/blog/free-aiy-projects-voice-kit-magpi-57/ | 11:08 |
---|---|---|
cmaloney | morning | 12:17 |
_stink_ | yo | 12:17 |
rick_h | Morning | 12:23 |
shakes808 | morning | 12:42 |
cmaloney | How is the day so far? | 12:45 |
rick_h | zzzz | 12:48 |
* shakes808 wants to go back to bed | 12:48 | |
cmaloney | I can understand that | 12:51 |
shakes808 | has anyone come across MySQL error code 126: Incorrect key file for table... try to repair it | 15:20 |
shakes808 | 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:22 |
shakes808 | 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:23 |
shakes808 | i ran myisamchk on it and it says it doesn't exist there too. | 15:25 |
shakes808 | I look int the /var/lib/mysql/db/ and see that it is there | 15:25 |
shakes808 | i can query it in mysql workbench and command line mysql | 15:26 |
shakes808 | 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:55 |
shakes808 | 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 |
shakes808 | ¯\_(ツ)_/¯ | 17:56 |
cmaloney | shakes808: That's a strange way to complain about not-enough-space | 18:06 |
cmaloney | but good to know | 18:07 |
shakes808 | haha right?! | 18:07 |
jrwren | i'm surprised greg-g hasn't moved all to postgresql yet ;p | 20:20 |
cmaloney | I'm sre if he could he would. | 20:22 |
greg-g | hrmm? | 21:11 |
gamerchick02 | evening everyone | 21:30 |
greg-g | jrwren: I missed the context? | 21:31 |
jrwren | greg-g: just shakes808 having mysql issues :) | 22:50 |
shakes808 | Stupid temp files getting too large :-( | 22:51 |
greg-g | jrwren: why would I move all to postgresql? | 23:03 |
jrwren | greg-g: because mysql is bad ;] | 23:22 |
greg-g | why is it my responsibility?! | 23:51 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!