Public bug reported:
I got a error with my mysql-database Server... but there told me, that it is
not compiled with -fomit-frame-pointer?
ok.. tried also innodb_force_recovery = 4 in my.cnf, but is dosnt help.
I run mysql with gdb an make a backtrace.. hope that we can find what's
wrong...
Nov 7 19:59:45 nb mysqld_safe[18307]: started
Nov 7 19:59:45 nb mysqld[18310]: InnoDB: Log scan progressed past the
checkpoint lsn 0 1752709
Nov 7 19:59:45 nb mysqld[18310]: 081107 19:59:45 InnoDB: Database was not
shut down normally!
Nov 7 19:59:45 nb mysqld[18310]: InnoDB: Starting crash recovery.
Nov 7 19:59:45 nb mysqld[18310]: InnoDB: Reading tablespace information from
the .ibd files...
Nov 7 19:59:45 nb mysqld[18310]: InnoDB: Restoring possible half-written data
pages from the doublewrite
Nov 7 19:59:45 nb mysqld[18310]: InnoDB: buffer...
Nov 7 19:59:59 nb /etc/init.d/mysql[18776]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 7 19:59:59 nb /etc/init.d/mysql[18776]: ^G/usr/bin/mysqladmin: connect to
server at 'localhost' failed
Nov 7 19:59:59 nb /etc/init.d/mysql[18776]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 7 19:59:59 nb /etc/init.d/mysql[18776]: Check that mysqld is running and
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 7 19:59:59 nb /etc/init.d/mysql[18776]:
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: Error: tried to read 1048576 bytes at
offset 0 1048576.
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: Was only able to read 8192.
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: Fatal error: cannot read from file.
OS error number 17.
Nov 7 20:00:11 nb mysqld[18310]: 081107 20:00:11InnoDB: Assertion failure in
thread 140476003809008 in file os0file.c line 2211
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: We intentionally generate a memory
trap.
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: Submit a detailed bug report to
http://bugs.mysql.com.
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: If you get repeated assertion
failures or crashes, even
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: immediately after the mysqld startup,
there may be
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: corruption in the InnoDB tablespace.
Please refer to
Nov 7 20:00:11 nb mysqld[18310]: InnoDB:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
Nov 7 20:00:11 nb mysqld[18310]: InnoDB: about forcing recovery.
Nov 7 20:00:11 nb mysqld[18310]: 081107 20:00:11 - mysqld got signal 11 ;
Nov 7 20:00:11 nb mysqld[18310]: This could be because you hit a bug. It is
also possible that this binary
Nov 7 20:00:11 nb mysqld[18310]: or one of the libraries it was linked against
is corrupt, improperly built,
Nov 7 20:00:11 nb mysqld[18310]: or misconfigured. This error can also be
caused by malfunctioning hardware.
Nov 7 20:00:11 nb mysqld[18310]: We will try our best to scrape up some info
that will hopefully help diagnose
Nov 7 20:00:11 nb mysqld[18310]: the problem, but since we have already
crashed, something is definitely wrong
Nov 7 20:00:11 nb mysqld[18310]: and this may fail.
Nov 7 20:00:11 nb mysqld[18310]:
Nov 7 20:00:11 nb mysqld[18310]: key_buffer_size=0
Nov 7 20:00:11 nb mysqld[18310]: read_buffer_size=131072
Nov 7 20:00:11 nb mysqld[18310]: max_used_connections=0
Nov 7 20:00:11 nb mysqld[18310]: max_connections=100
Nov 7 20:00:11 nb mysqld[18310]: threads_connected=0
Nov 7 20:00:11 nb mysqld[18310]: It is possible that mysqld could use up to
Nov 7 20:00:11 nb mysqld[18310]: key_buffer_size + (read_buffer_size +
sort_buffer_size)*max_connections = 217599 K
Nov 7 20:00:11 nb mysqld[18310]: bytes of memory
Nov 7 20:00:11 nb mysqld[18310]: Hope that's ok; if not, decrease some
variables in the equation.
Nov 7 20:00:11 nb mysqld[18310]:
Nov 7 20:00:11 nb mysqld[18310]: thd=(nil)
Nov 7 20:00:11 nb mysqld[18310]: Attempting backtrace. You can use the
following information to find out
Nov 7 20:00:11 nb mysqld[18310]: where mysqld died. If you see no messages
after this, something went
Nov 7 20:00:11 nb mysqld[18310]: terribly wrong...
Nov 7 20:00:11 nb mysqld[18310]: frame pointer is NULL, did you compile with
Nov 7 20:00:11 nb mysqld[18310]: -fomit-frame-pointer? Aborting backtrace!
Nov 7 20:00:11 nb mysqld[18310]: The manual page at
http://dev.mysql.com/doc/mysql/en/crashing.html contains
Nov 7 20:00:11 nb mysqld[18310]: information that should help you find out
what is causing the crash.
Nov 7 20:00:11 nb mysqld_safe[19047]: ended
[EMAIL PROTECTED]:/~# gdb mysqld
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu"...
(no debugging symbols found)
(gdb) r --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
Starting program: /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql
--user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking
--port=3306 --socket=/var/run/mysqld/mysqld.sock
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
[Thread debugging using libthread_db enabled]
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
[New Thread 0x7fc59321c6f0 (LWP 12621)]
[New Thread 0x41efc950 (LWP 12627)]
[Thread 0x41efc950 (LWP 12627) exited]
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
[New Thread 0x41efc950 (LWP 12628)]
[New Thread 0x426fd950 (LWP 12629)]
[New Thread 0x40da1950 (LWP 12630)]
[New Thread 0x42efe950 (LWP 12631)]
InnoDB: Log scan progressed past the checkpoint lsn 0 1752709
081107 20:19:22 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Error: tried to read 1048576 bytes at offset 0 1048576.
InnoDB: Was only able to read 8192.
InnoDB: Fatal error: cannot read from file. OS error number 17.
081107 20:19:49InnoDB: Assertion failure in thread 140486553749232 in file
os0file.c line 2211
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fc59321c6f0 (LWP 12621)]
0x0000000000803ff7 in os_file_read ()
(gdb) bt
#0 0x0000000000803ff7 in os_file_read ()
#1 0x00000000007d0b5e in fil_io ()
#2 0x000000000078f241 in trx_sys_doublewrite_init_or_restore_pages ()
#3 0x00000000007b8cf2 in recv_scan_log_recs ()
#4 0x00000000007b96f6 in ?? ()
#5 0x00000000007b9cb6 in recv_recovery_from_checkpoint_start ()
#6 0x0000000000714d43 in innobase_start_or_create_for_mysql ()
#7 0x0000000000695e64 in innobase_init ()
#8 0x000000000068bbfa in ha_init ()
#9 0x00000000005d6085 in ?? ()
#10 0x00000000005d82aa in main ()
(gdb)
ProblemType: Bug
Architecture: amd64
DistroRelease: Ubuntu 8.10
NonfreeKernelModules: fglrx
Package: mysql-server 5.0.67-0ubuntu6
PackageArchitecture: all
ProcEnviron:
LANGUAGE=de
PATH=/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
LANG=de_DE.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-dfsg-5.0
Uname: Linux 2.6.27-7-generic x86_64
** Affects: mysql-dfsg-5.0 (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug
--
InnoDB: Assertion failure in thread...
https://bugs.launchpad.net/bugs/295293
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
