Re: MySQLdMax crashed (for unknown reasons), please help
Jonathan, the bug is probably the SHOW CREATE TABLE bug which was fixed in 3.23.48. Please upgrade to 3.23.49a. 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: JW [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Tuesday, February 26, 2002 7:05 PM Subject: MySQLdMax crashed (for unknown reasons), please help Hello, We're been running a pretty large MySQLd with InnoDB support, last night it crashed on us in the middle of the night. I have never sent in a bug report like this before so please give me a little slack. I do not have any clue as to what actually caused the crash, I only have the logs and confs. In order: 1. System specs 2. my.cnf directives and 3. MySQL error log = 1. System Specs Dell PowerEdge 2450 Dual PIII 850 2G RAM 5-disk RAID5 for a total of 67G in / (27 used, 39 free) I think swap is also 2GB but I'm not sure (1060258+ blocks). SuSE Linux 7.3 ccs012:~ # uname -a Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686 unknown ccs012:~ # free -m total used free sharedbuffers cached Mem: 2013 2007 5 0 23695 -/+ buffers/cache: 1288724 Swap: 1035 0 1035 Not running any major service except MySQL, standalone sshd and inetd (for telnet) = 2. my.cnf ccs012:~ # grep -v # /etc/my.cnf [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= max_connections=150 set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 innodb_data_file_path = ibdata1:2G innodb_data_home_dir = /var/lib/mysql/ innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=156M set-variable = innodb_log_buffer_size=12M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=1024M set-variable = innodb_additional_mem_pool_size=8M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout [safe_mysqld] open-files-limit=256 = 3. MySQLd-Max error log output ccs012:~ # less /var/lib/mysql/ccs012.err 020216 19:46:15 mysqld started 020216 19:46:20 InnoDB: Started /usr/sbin/mysqld-max: ready for connections InnoDB: Error: undo-id is 137339008 InnoDB: Assertion failure in thread 27591729 in file trx0undo.c line 1316 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] 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=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=150 max_connections=150 threads_connected=68 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1007010 K bytes of memory Hope that's ok, if not, decrease some variables in the equation InnoDB: Thread 27614285 stopped in file btr0pcur.c line 202 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806c9b9 0x8249998 0x81acb51 0x81a27d4 0x81949f3 0x817d565 0x817d949 0x817dc42 0x8170a1d 0x80baff9 0x809b855 0x80749a5 0x8076548 0x80725d4 0x8071ac7 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump
Re: MySQLdMax crashed (for unknown reasons), please help
Hi, On Wed, 2002-02-27 at 02:55, JW wrote: Hello, We're been running a pretty large MySQLd with InnoDB support, last night it crashed on us in the middle of the night. I have never sent in a bug report like this before so please give me a little slack. I do not have any clue as to what actually caused the crash, I only have the logs and confs. Unfortunately, your report lacked some vital info, like which version of the server you were using, and which distribution (binary or source, which compile options), etc Could you please re-send your report through the 'mysqlbug' tool? That will ensure that these basics are present. Thanks. Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.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