Typically if your OS runs, the mysql will too. You should only be worried with hardware if you are running large database apps on a slow system.
-----Original Message----- From: Stephen Hitchner [mailto:steve@;number41media.com] Sent: Friday, November 01, 2002 9:40 PM To: Mysql Subject: mysql dieing Hi I'm new to this list so forgive me if I break some rules with this first post. I have been receiving random mysql errors over the past few days where the server just dies. The server dies at various times, under various loads. I have included as much information as I can from various places on the server. I spent a bit of time looking around for possible known errors with little luck. I think I have narrowed this problem to hardware, but I was just wondering if anyone has experienced this. I'm using: FreeBSB 4.6 Mysql 3.23.51 Any help would be great! cheers steve /************************************************************************ * mysqlbug */ From: kosh To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description: <precise description of the problem (multiple lines)> >How-To-Repeat: <code/input/activities to reproduce the problem (multiple lines)> >Fix: <how to correct or work around the problem, if known (multiple lines)> >Submitter-Id: <submitter ID> >Originator: Number41Media Admin >Organization: <organization of PR author (multiple lines)> >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <synopsis of the problem (one line)> >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.51-max (Official MySQL-max binary) >Environment: <machine, os, target, libraries (multiple lines)> System: FreeBSD mail-sql.xxxxx.com 4.6-RELEASE FreeBSD 4.6-RELEASE #0: Tue Jun 11 06:14:12 GMT 2002 [EMAIL PROTECTED]:/usr/src/sys /compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions - fno-r tti' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1222232 Jun 10 21:18 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Aug 21 05:27 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 579412 Jun 10 21:18 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max -- enable-thread-safe-client --enable-local-infile --enable-assembler --with-na med-z-libs=not-used --disable-shared --with-berkeley-db --with-innodb 'CFLAGS=-O3 -fno-omit-frame-pointer' CXX=gcc CC=gcc 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions - fno-rtti' Perl: This is perl, version 5.005_03 built for i386-freebsd /*************************************************************************** * mysql mail-sql.xxxxx.err file */ mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=16 max_connections=100 threads_connected=5 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 021101 21:03:55 mysqld restarted 021101 21:06:49 bdb: Log sequence error: page LSN 70:7230244; previous LSN 375 1164233 021101 21:06:50 bdb: Log sequence error: page LSN 70:7378020; previous LSN 380 8564133 021101 21:06:50 bdb: Log sequence error: page LSN 70:7621572; previous LSN 383 3442355 021101 21:07:34 bdb: ./rogers_mail_berkeley_ah/customer_recipients.db: close: 1 blocks left pinned 021101 21:07:34 bdb: ./rogers_mail_berkeley_ah/customers.db: close: 2 blocks left pinned mysqld in free(): warning: chunk is already free 021101 21:07:34 Can't init databases 021101 21:07:34 mysqld ended /*************************************************************************** **** * My Mysql Log */ 01Nov2002 21:04:05 SELECT: SELECT customers.id as id, customers.account as account, customers.salutation as salutation, customers.firstname as firstname, customers.lastname as lastname, customers.address1 as address1, customers.address2 as address2, customers.city as city, customers.postalcode as postalcode, customers.phonearea as phonearea, customers.phonenumber as phonenumber, customers.company as company, customers.country_id as country_id, customers.province_out as province_out, customers.province_id as province_id, provinces.name as province, countries.code as country_code, countries.name as country_name FROM customers,countries,provinces WHERE customers.id = 3005011 AND customers.province_id = provinces.id AND customers.country_id = countries.id 01Nov2002 21:04:05 [select] Error with select: SELECT customer_recipients.id as id, customer_recipients.salutation as salutation, customer_recipients.firstname as firstname, customer_recipients.lastname as lastname, customer_recipients.address1 as address1, customer_recipients.address2 as address2, customer_recipients.city as city, customer_recipients.postalcode as postalcode, customer_recipients.country_id as country_id, customer_recipients.province_out as province_out, provinces.name as province, customer_recipients.province_id as province_id, countries.code as country_code, countries.name as country_name FROM customer_recipients,countries,provinces WHERE customer_recipients.customer_id = 3005011 AND customer_recipients.province_id = provinces.id AND customer_recipients.country_id = countries.id ORDER BY lastname,firstname [2013] Lost connection to MySQL server during query 01Nov2002 21:04:05 [get_numrows] No Rows Returned /************************************ * Stephen Hitchner * * Senior Developer * Number 41 Media Corporation * p 250.414.0410 * f 250.414.0411 * [EMAIL PROTECTED] * www.number41media.com * */ --------------------------------------------------------------------- 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