Ady, what version of MySQL you are running? In 3.23.44 there was a bug which could cause an assertion failure in trx0trx.c, line 178.
Please test with 3.23.45 or .46. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ >After having experience with InnoDB and MyISAM.......... >There's lack in MySQL engine with InnoDB comparing to MySQL with MyISAM >the problem exists when you do wrong with my.cnf configuration file >for example do wrong in max_connections, table_cache >Using MyISAM although with configuration >key_buffer_size + (record_buffer + sort_buffer)*max_connections >is greater than existing physical memory, MySQL server never crash >BUT using InnoDB when you do >key_buffer_size + (record_buffer + sort_buffer)*max_connections >greater than memory could use by MySQL, it will crash in very heavy load >for example here..... RAM 256 Mbyte, Swap 512 Mbyte >with the same configuration using MyISAM, never crash, but with InnoDB .... >crashed 011127 21:09:51 InnoDB: Started >/usr/sbin/mysqld-max: ready for connections >A mysqld process already exists at Wed Nov 28 13:45:03 EST 2001 >InnoDB: Assertion failure in thread 2096211 in file trx0trx.c line 178 >InnoDB: We intentionally generate a memory trap. >InnoDB: Send a detailed bug report to [EMAIL PROTECTED] --------------------------------------------------------------------- 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
