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