MySQL Startup error

Source: Internet
Author: User

Before using my this machine to do the MySQL test, today started to build a set of line master and slave, the results do not come up ...

Error log:

                                                                                                                          ; Innodb:end of Page dump1708 11:37:02 innodb:page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432innodb:stored checksum 0, prior-to  -4.0.14-form stored checksum 0innodb:page LSN 0 0, low 4 bytes of LSN in page end 0innodb:page number (if stored to page already) 0,innodb:space ID (if created with >= MySQL-4.1.1 and stored already) 0innodb:page could be a freshly allocat Ed page170807 11:37:02innodb:error:trying to access a stray pointer 0x80007f66af393ff8innodb:buf pool start was at 0x7f6 6af384000, end at 0x7f66afb84000innodb:probable reason is database corruption or memoryinnodb:corruption. If this happens on an InnoDB database recovery, seeinnodb:http://dev.mysql.com/doc/refman/5.1/en/ Forcing-innodb-recovery.htmlinnodb:how to force recovery.170811:37:02 innodb:assertion failure in thread 140079112959968 in file. /.. /storage/innobase/include/buf0buf.ic Line 264innodb: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, E Veninnodb:immediately after the mysqld startup, there could beinnodb:corruption in the InnoDB tablespace. Please refer toinnodb:http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.htmlinnodb:about forcing Recovery.03:37:02 Utc-mysqld got signal 6; This could is because a bug. It's also possible that's binaryor one of the libraries it was linked against are corrupt, improperly built,or misconfi Gured. This error can also is caused by malfunctioning hardware. We'll try our best to scrape up some info that'll hopefully helpdiagnose the problem, but since we have already crashe D, something is definitely wrong and this may fail.key_buffer_size=8384512read_buffer_size=131072maX_used_connections=0max_threads=151thread_count=0connection_count=0it is possible this mysqld could use up to Key_ Buffer_size + (read_buffer_size + sort_buffer_size) *max_threads = 338336 K bytes of memoryhope that ' s OK; If not, decrease some variables in the equation. Thread pointer:0x0attempting BackTrace. You can use the following information to find Outwhere Mysqld died. If you see no messages after this, something wentterribly wrong...stack_bottom = 0 Thread_stack 0x40000/usr/libexec/mysqld (my_print_stacktrace+0x29) [0x850ca9]/usr/libexec/mysqld (handle_fatal_signal+0x483) [0x6a4143]/lib64/libpthread.so.0 () [0x3514e0f7e0]/lib64 /libc.so.6 (gsignal+0x35) [0x3514a32625]/lib64/libc.so.6 (abort+0x175) [0x3514a33e05]/usr/libexec/mysqld (Page_cur_ search_with_match+0x77b) [0x79855b]/usr/libexec/mysqld (BTR_CUR_SEARCH_TO_NTH_LEVEL+0X6EA) [0x73bd9a]/usr/libexec /mysqld (btr_pcur_open_on_user_rec+0x64) [0x7eab34]/usr/libexec/mysqld () [0x75a46f]/usr/libexec/mysqld (Dict_load_ sys_table+0x59) [0x7602d9]/usr/libexec/mysqld (dict_boot+0x91c) [0x7ebf6c]/usr/libexec/mysqld (INNOBASE_START_OR_CREATE_FOR_MYSQL+0X11F6) [ 0x7c8466]/usr/libexec/mysqld () [0x72f84b]/usr/libexec/mysqld (Ha_initialize_handlerton (st_plugin_int*) +0x31) [ 0x697b91]/usr/libexec/mysqld () [0x7177db]/usr/libexec/mysqld (Plugin_init (int*, char**, int) +0x6e4) [0x719ad4]/usr/ Libexec/mysqld () [0x5bf242]/usr/libexec/mysqld (MAIN+0X1B3) [0x5c1bb3]/lib64/libc.so.6 (__LIBC_START_MAIN+0XFD) [ 0x3514a1ed5d]/usr/libexec/mysqld () [0x509939]the manual page at http://dev.mysql.com/doc/mysql/en/crashing.html Containsinformation that should help you find out what's causing the crash.170807 11:37:02 mysqld_safe mysqld from pid fi Le/var/run/mysqld/mysqld.pid Ended

  

Look at the log information should be abnormal shutdown caused the library damage, looked for a post to solve:

[[email protected] mysql]# cd/var/lib/mysql[[email protected] mysql]# lltotal 20496drwx------2 mysql mysql     4096 Jul 05:49 hotel_cdn_control-rw-rw----1 mysql mysql 10485760  7 11:41 ibdata1-rw-rw----1 mysql mysql  5242880 Au G  7 11:41 ib_logfile0-rw-rw----1 mysql mysql  5242880  7 11:41 ib_logfile1drwx------2 mysql mysql     409 6 Jul 03:44 mysqlsrwxrwxrwx 1 mysql mysql        0  7 11:41 mysql.sockdrwxr-xr-x 2 root  root      4096 aug
   
    7 11:41 olddrwx------2 mysql mysql     4096 Jul 03:44 test[[email protected] mysql]# mkdir bcksql[[email protected] mysql]# MV *ib* bcksql[[email protected] mysql]# service mysqld start
   

has been resolved.

MySQL Startup error

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.