An update. I'm now running the debug version on the slave. I could not trace out 'info' since it wrote way too much to the trace file.
What I did find that was unique when the table crashed is this: handle_slave_sql: query: insert into forums_posts_new_3 ( .... w_search: error: Got errno: 0 from key_cache_read mi_write: error: Got error: 126 on write my_message_sql: error: Message: 'Incorrect key file for table: 'forums_posts_new_3'. Try to repair it' sql_print_error: error: Slave: error 'Incorrect key file for table: 'forums_posts_new_3'. Try to repair it' on query 'insert into forums_posts_new_3 .... I don't know why it had a problem with error zero from key_cache_read -- that seems to be the oddest thing in the log. It appears no where else. I'll keep digging. Does no one else have a problem with a slave stopping and corrupting its own tables? The only thing about the insert query that may be seen as odd is that it has binary data in it. That is one of the fields is like this: 'xÚÍTKoã6^P¾÷W~L}ÉÅÕf~K^B^EÚÝ,~\®~Qm7Û\0qÐ`~O#~S~R^HQ¤AÒQÕ_ßoH%V^N=ôP`~Q~Ge~ J3ó=ffKIó¡Ó~AZ~Ò$^O~MiRGm`¥é`9FbGø0^[´K?Ó~MN~T:m^B^]9à$RòHc~\^NÄ^T~S^O^S~M ^Fi~X^F^_Ø^Rç^PÒN~QoȤ~J^^ðÕé¿^R)~^ò»Þ¨H^G^^4Õ|èQ^TW^]¾LåC·~@±(~DòRÇèX½»¾¿ú. ÿûÌ©~[(²Q^[Z^?~Y¨Áw^].@^A~Oa\0;I;~B¨°e²> ^^ݶß[~^~Lk¡~@~K^UÝ¡b2~@2ÊoÀ^Wîå?^E¹~\^Y^O^\z(a ^N^PGyö.3i~Bw~I¢æ~\\\N~NæÐ~_~N4\"{®n~R^D~]~F£~DË~EàYel\\Ø~U*#Ô¥Æf`ò²^N¾×ùi^P w ®~N±Z~_ù¯·B¯ã^DÊ~R¥~H?~Cȶ|X~S`Uùdö~!àú£w^W~I~N§~T~QL/~D~A3Û~P~I®~V%ÿÔ0»õ^mÖ Yù^?Éü~GxmMJVÓíé0Q`^S~A~Cá~E+ÜgßîP³áÁØ~IÐ_³qq^CÍ}E×@^F^Es0^]:è èñ¡ð^UÍ~K1^U=~JÍR@ù¿¡{¦ágc7P?^U?^P7áb^BÞÜ^ZÞYá~C~FÅKk~^æ21C<~K*Ø~Y87»^A>~U ¥;ø^SL˽ÀÃ~IɶN^WA?×zåÛ^C^NiäܨÆÍ^e~]*úÝwÎM~R_Ò>·n¹^A^T±~CJ^_~Vɾj| ^Yø~B~G^Ua^H^T+%7-ÚF/Así!Â0ÑV ^?áÐê~Jö`8^C±¦í^Rf¶^E\"~L~N:^EiÄ~O:ê~Ph~O^TCÖD~VÆÑ2P~Kj~]^L·$^Qí^A¯fP~W:þ ÷´Ó¨~Wt^HF l^z>Î^Q¥tís~_| qGÀíµ\\^D#^H*UN®~D^A2~DL^BÚWU%)T`×g~WæÀç~Y^\±e~T^_^]E~OõC£?Y%vÕAs~_·~QË^XÀC¡ ^OB¦>^Oç`~T*hÞ^^>S^HÞ^_caÚ^[k^QóÓå<iCÙ}9t~A¹t^A~J^CcQ¤A^W\"4ÅÕ^YÀ~\ì~GKé3ý:^ S¸¢{ç^MQ[Ù^Ay%ü\"^G¯ÂS¦^R^S^P~W^TbR͹û~\ÂÎ| E¿Ü`xq^A}åâr~H;^O~[^Z#éÊ8c8e¹| HÙãe^R^T®ç~~_^[M~WÅ!kp@^^ÜÏ~Ijû²~B^Vµ÷i^ÿ~_$~LŦ^\wnÉ2¥à~F~]Vk<*´¡lãå\0ÝÞå~_ ^U½3CK1^\Þ¯ß~X~A[^]ßt|<NUk~Z58~Jïßþ^HMTêðpõÿ^G~\AþçRtïc\\Ä×á*ÿ}s^\éáÓ~N®w;º ÙíöôøÛí-mo^_·_÷t^?÷ëçÕê~[õå^_-:^G^W' I'm starting to run out of ideas... -steve- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php