error log available on request. Ezmlm rejected it. Its always in memcpy+49 just before it gets to the pthread handler and the segfault handler. This is pretty consistent.
I have a query that was 100% reliable, until the server went into production. Now its serving 15 queries/sec, and crashes pretty often. And for extra fun, the query that fails is NOT the one that seems to trigger it. This query is run constantly, mostly with no errors. When I run a report query, other simultaneous queries on the same data seem to get the errors. 0x806d85a handle_segfault__Fi + 406 0x82a81e2 pthread_sighandler + 162 0x82daa5f memcpy + 39 0x80951fb store_record_in_cache__FP13st_join_cache + 255 0x8092ad0 sub_select_cache__FP4JOINP13st_join_tableb + 156 Machine is 1.6 ghz p4, 512 megs ram, 2x IDE disks. OS is rh 7.2, all updates, glibc 2.2.4, though mysql-max does not use that, Server is mysql-max 3.23.49a, from the rpm from mysql.com. Tried a source recompile, exact same symptoms and error location. Tried also 3.23.41 from redhats's source tree, recompiled with --innodb, since I need the innodb consistent read handler, the performance under myISAM is disappointing under load. Errors under .41/using glibc are nearly identical, modulo different version and shared libc. (glibc 2.2.4): 0x80bf15f handle_segfault__Fi + 431 0x4002a4f3 _end + 936436875 0x4018863f _end + 937870807 0x80e8309 store_record_in_cache__FP13st_join_cache + 217 0x80e535f sub_select_cache__FP4JOINP13st_join_tableb + 159 0x80e54c2 sub_select__FP4JOINP13st_join_tableb + 258 -- Jay "yohimbe" Thorne [EMAIL PROTECTED] Mgr Sys & Tech, Userfriendly.org --------------------------------------------------------------------- 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