List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:October 12 2013 11:07am
Subject:Re: Lost connection to MySQL server - need help.
View as plain text  
Could be a crash related to innodb data dictionary being out of sync. Could
be a bug.

http://bugs.mysql.com/bug.php?id=55277
On 12 Oct 2013 11:21, "Jørn Dahl-Stamnes" <sql07@stripped> wrote:

> On Saturday 12 October 2013 12:01, nixofortune wrote:
> > You might want to comment
> >
> > bind-address            = 127.0.0.1
> >
> > in your my.cnf and restart mysql server.
>
> It does not explain why it works under low load and not under high load.
>
> However, I seem to have found something. When I started phpMyAdmin and
> selected one of the database, the server went away again and I found this
> in /var/log/syslog:
>
> Oct 12 11:53:33 cebycny mysqld: 131012 11:53:33  InnoDB: Assertion failure
> in
> thread 140182892447488 in file
> ../../../storage/innobase/handler/ha_innodb.cc
> line
>  8066
> Oct 12 11:53:33 cebycny mysqld: InnoDB: Failing assertion: auto_inc > 0
> Oct 12 11:53:33 cebycny mysqld: InnoDB: We intentionally generate a memory
> trap.
> Oct 12 11:53:33 cebycny mysqld: InnoDB: Submit a detailed bug report to
> http://bugs.mysql.com.
> Oct 12 11:53:33 cebycny mysqld: InnoDB: If you get repeated assertion
> failures
> or crashes, even
> Oct 12 11:53:33 cebycny mysqld: InnoDB: immediately after the mysqld
> startup,
> there may be
> Oct 12 11:53:33 cebycny mysqld: InnoDB: corruption in the InnoDB
> tablespace.
> Please refer to
> Oct 12 11:53:33 cebycny mysqld: InnoDB:
> http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
> Oct 12 11:53:33 cebycny mysqld: InnoDB: about forcing recovery.
> Oct 12 11:53:33 cebycny mysqld: 09:53:33 UTC - mysqld got signal 6 ;
> Oct 12 11:53:33 cebycny mysqld: This could be because you hit a bug. It is
> also possible that this binary
> Oct 12 11:53:33 cebycny mysqld: or one of the libraries it was linked
> against
> is corrupt, improperly built,
> Oct 12 11:53:33 cebycny mysqld: or misconfigured. This error can also be
> caused by malfunctioning hardware.
> Oct 12 11:53:33 cebycny mysqld: We will try our best to scrape up some info
> that will hopefully help
> Oct 12 11:53:33 cebycny mysqld: diagnose the problem, but since we have
> already crashed,
> Oct 12 11:53:33 cebycny mysqld: something is definitely wrong and this may
> fail.
> Oct 12 11:53:33 cebycny mysqld:
> Oct 12 11:53:33 cebycny mysqld: key_buffer_size=2147483648
> Oct 12 11:53:33 cebycny mysqld: read_buffer_size=2097152
> Oct 12 11:53:33 cebycny mysqld: max_used_connections=8
> Oct 12 11:53:33 cebycny mysqld: max_threads=100
> Oct 12 11:53:33 cebycny mysqld: thread_count=2
> Oct 12 11:53:33 cebycny mysqld: connection_count=2
> Oct 12 11:53:33 cebycny mysqld: It is possible that mysqld could use up to
> Oct 12 11:53:33 cebycny mysqld: key_buffer_size + (read_buffer_size +
> sort_buffer_size)*max_threads = 3941387 K  bytes of memory
> Oct 12 11:53:33 cebycny mysqld: Hope that's ok; if not, decrease some
> variables in the equation.
> Oct 12 11:53:33 cebycny mysqld:
> Oct 12 11:53:33 cebycny mysqld: Thread pointer: 0x7f7f1bf997c0
> Oct 12 11:53:33 cebycny mysqld: Attempting backtrace. You can use the
> following information to find out
> Oct 12 11:53:33 cebycny mysqld: where mysqld died. If you see no messages
> after this, something went
> Oct 12 11:53:33 cebycny mysqld: terribly wrong...
> Oct 12 11:53:33 cebycny mysqld: stack_bottom = 7f7edf81fe88 thread_stack
> 0x30000
> Oct 12 11:53:33 cebycny mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29)
> [0x7f7edff62b59]
> Oct 12 11:53:33 cebycny mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x483)
> [0x7f7edfd774a3]
> Oct 12 11:53:33 cebycny mysqld: /lib/libpthread.so.0(+0xeff0)
> [0x7f7edf4c9ff0]
> Oct 12 11:53:33 cebycny mysqld: /lib/libc.so.6(gsignal+0x35)
> [0x7f7eddf6c1b5]
> Oct 12 11:53:33 cebycny mysqld: /lib/libc.so.6(abort+0x180)
> [0x7f7eddf6efc0]
> Oct 12 11:53:33 cebycny
> mysqld: /usr/sbin/mysqld(ha_innobase::innobase_peek_autoinc()+0x8f)
> [0x7f7edfe1fa2f]
> Oct 12 11:53:33 cebycny
> mysqld: /usr/sbin/mysqld(ha_innobase::info_low(unsigned int, bool)+0x18f)
> [0x7f7edfe2524f]
> Oct 12 11:53:33 cebycny
> mysqld:
> /usr/sbin/mysqld(ha_innobase::update_create_info(st_ha_create_information*)+0x29)
> [0x7f7edfe256b9]
> Oct 12 11:53:33 cebycny mysqld: /usr/sbin/mysqld(+0x49e3dc)
> [0x7f7edfd953dc]
> Oct 12 11:53:33 cebycny mysqld: /usr/sbin/mysqld(mysqld_show_create(THD*,
> TABLE_LIST*)+0x7a8) [0x7f7edfd9d388]
> Oct 12 11:53:33 cebycny
> mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x184a)
> [0x7f7edfc7cb0a]
> Oct 12 11:53:33 cebycny mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*,
> unsigned int, char const**)+0x3fb) [0x7f7edfc80dbb]
> Oct 12 11:53:33 cebycny
> mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*,
> unsigned int)+0x115a) [0x7f7edfc81f2a]
> Oct 12 11:53:33 cebycny mysqld: /usr/sbin/mysqld(do_command(THD*)+0xea)
> [0x7f7edfc8285a]
> Oct 12 11:53:33 cebycny mysqld:
> /usr/sbin/mysqld(handle_one_connection+0x235)
> [0x7f7edfc74435]
> Oct 12 11:53:33 cebycny mysqld: /lib/libpthread.so.0(+0x68ca)
> [0x7f7edf4c18ca]
> Oct 12 11:53:33 cebycny mysqld: /lib/libc.so.6(clone+0x6d) [0x7f7ede00992d]
> Oct 12 11:53:33 cebycny mysqld:
> Oct 12 11:53:33 cebycny mysqld: Trying to get some variables.
> Oct 12 11:53:33 cebycny mysqld: Some pointers may be invalid and cause the
> dump to abort.
> Oct 12 11:53:33 cebycny mysqld: Query (7f7f1c0dcbc0): SHOW CREATE TABLE
> `calculation`
> Oct 12 11:53:33 cebycny mysqld: Connection ID (thread ID): 92
> Oct 12 11:53:33 cebycny mysqld: Status: NOT_KILLED
> Oct 12 11:53:33 cebycny mysqld:
> Oct 12 11:53:33 cebycny mysqld: The manual page at
> http://dev.mysql.com/doc/mysql/en/crashing.html contains
> Oct 12 11:53:33 cebycny mysqld: information that should help you find out
> what
> is causing the crash.
> Oct 12 11:53:33 cebycny mysqld_safe: Number of processes running now: 0
> Oct 12 11:53:33 cebycny mysqld_safe: mysqld restarted
>
> --
> Jørn Dahl-Stamnes
> homepage: http://photo.dahl-stamnes.net/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
Lost connection to MySQL server - need help.Jørn Dahl-Stamnes12 Oct
  • Re: Lost connection to MySQL server - need help.nixofortune12 Oct
    • Re: Lost connection to MySQL server - need help.Jørn Dahl-Stamnes12 Oct
      • Re: Lost connection to MySQL server - need help.Andrew Moore12 Oct
        • Re: Lost connection to MySQL server - need help.Jørn Dahl-Stamnes12 Oct
          • Re: Lost connection to MySQL server - need help.Reindl Harald12 Oct
            • Re: Lost connection to MySQL server - need help.Jørn Dahl-Stamnes12 Oct
              • Re: Lost connection to MySQL server - need help.Reindl Harald12 Oct
                • Re: Lost connection to MySQL server - need help.Chris McKeever12 Oct
                  • Re: Lost connection to MySQL server - need help.Reindl Harald12 Oct