Jay, please send me the error log, the queries, and the table definitions.
What is your my.cnf like? Are your sure memory consumption does not approach 2 GB? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: "Jay Thorne" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, May 03, 2002 9:24 AM Subject: memcpy segfaults from store_record_in_cache under load on p4, 3.23.41 and .49 > 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 > --------------------------------------------------------------------- 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
