David, ----- Original Message ----- From: "David Bernick" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, July 22, 2003 8:02 PM Subject: mysql crashing regularly
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 your database is corrupt. It is trying to access a page at 8 TB. What Linux distro you are using? What is the complete query? If you resolve the stack dump, what does it say? If the table is not huge, run CHECK TABLE on it, and post the .err log output here. > We're doing a select query on our INNODB database. > Linux 2.4.21 on x86 (Athlon). Mysql is 4.0.13. Anyone seen this problem before? > - ----- > InnoDB: Error: trying to access page number 538587904 in space 0 > InnoDB: which is outside the tablespace bounds. > InnoDB: Byte offset 0, len 16384, i/o type 10 > 030722 12:49:11 InnoDB: Assertion failure in thread 40970 in file fil0fil.c > line 1176 > InnoDB: Failing assertion: 0 > 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 against 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=16777216 > read_buffer_size=131072 > sort_buffer_size=524280 > max_used_connections=0 > max_connections=100 > threads_connected=1 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 80383 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > > - -- > David Bernick Regards, Heikki > Senior Engineer - Legal Computer Solutions > [EMAIL PROTECTED] > > "The combination of a number of things to make existence worthwhile." > "Yes, the philosophy of 'none,' meaning 'all.'" > -- Spock and Lincoln, "The Savage Curtain", stardate 5906.4 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.7 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQE/HWypzR9WeS6DURURAmnIAJ9RU+e0/knlSVP1iSPjdNDCnJJ+HQCfdKay > 5JA4S5dFESq4f4HIMkBS8D0= > =ECfl > -----END PGP SIGNATURE----- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
