percona - mysql restarted occassionally -

-

at night our mysql server restarted occassionally(innodb engine) , in log see following:

150921  1:58:44  innodb: page checksum 2064838754 (32bit_calc:  866699801), prior-to-4.0.14-form checksum 400856538 innodb:stored checksum 1847129036, prior-to-4.0.14-form stored checksum 42278670 innodb: page lsn 0 3564194321, low 4 bytes of lsn @ page end 2315587073 innodb: page number (if stored page already) 80945,  innodb: space id (if created >= mysql-4.1.1 , stored already) 0 innodb: page may index page index id 116 innodb: (index "idx_cru_type" of table "fisheyedb"."cru_login_cookie") 150921  1:58:44  innodb: assertion failure in thread 139799134877440 in file rem0rec.c line 569  innodb: intentionally generate memory trap.  innodb: submit detailed bug report http://bugs.mysql.com.  innodb: if repeated assertion failures or crashes,  innodb: after mysqld startup, there may  innodb: corruption in innodb tablespace. please refer

at http://bugs.percona.com/ key_buffer_size=33554432

is possible reveal happened , should avoid behavior further?

i think table corrupted. can use mysql repair command: first backup! https://dev.mysql.com/doc/refman/5.0/en/rebuilding-tables.html


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more