mysql - Yum updating Percona from 5.6.25-rel73.1 to 5.6.26-rel74.0 results in an unstartable server -


running under centos 6.7 yum updating percona server leaves in unstartable state.

this log /var/log/mysqld.log

150929 14:54:17 mysqld_safe starting mysqld daemon databases /srv/mysql 2015-09-29 14:54:18 0 [warning] timestamp implicit default value deprecated. please use --explicit_defaults_for_timestamp server option (see documentation more details). 2015-09-29 14:54:18 0 [note] /usr/sbin/mysqld (mysqld 5.6.26-74.0) starting process 17130 ... 2015-09-29 14:54:18 17130 [note] plugin 'federated' disabled. 2015-09-29 14:54:18 17130 [note] innodb: using atomics ref count buffer pool pages 2015-09-29 14:54:18 17130 [note] innodb: innodb memory heap disabled 2015-09-29 14:54:18 17130 [note] innodb: mutexes , rw_locks use gcc atomic builtins 2015-09-29 14:54:18 17130 [note] innodb: memory barrier not used 2015-09-29 14:54:18 17130 [note] innodb: compressed tables use zlib 1.2.3 2015-09-29 14:54:18 17130 [note] innodb: using linux native aio 2015-09-29 14:54:18 17130 [note] innodb: using cpu crc32 instructions 2015-09-29 14:54:18 17130 [note] innodb: initializing buffer pool, size = 3.0g 2015-09-29 14:54:18 17130 [note] innodb: completed initialization of buffer pool 2015-09-29 14:54:18 17130 [note] innodb: highest supported file format barracuda. 2015-09-29 14:54:18 17130 [error] innodb: tried read 4096 bytes @ offset 286720. able read 0. 2015-09-29 14:54:18 7fe0f5f847e0  innodb: operating system error number 22 in file operation. innodb: error number 22 means 'invalid argument'. innodb: operating system error numbers described @ innodb: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 2015-09-29 14:54:18 17130 [error] innodb: file (unknown): 'read' returned os error 122. cannot continue operation 150929 14:54:18 mysqld_safe mysqld pid file /var/run/mysqld/mysqld.pid ended

the my.cnf looks this:

[mysqld] socket=/var/lib/mysql/mysql.sock user=mysql # disabling symbolic-links recommended prevent assorted security risks symbolic-links=0 innodb_track_changed_pages = true pid-file=/var/run/mysqld/mysqld.pid  # use interleaved id creation during bulk inserts # w/o bulk inserts serialized innodb_autoinc_lock_mode=2  innodb_log_file_size = 2000m innodb_flush_method = o_direct #innodb_buffer_pool_size = 80g innodb_buffer_pool_size = 5g transaction-isolation=read-committed  innodb_file_per_table=1 default-storage-engine = innodb innodb_file_format = barracuda

the culprit seems line:

innodb_track_changed_pages = true

in order work around this...

  1. we changed innodb_track_changed_pages false
  2. stop server
  3. manually delete ib_modified_log* files in mysql directory
  4. start server
  5. change innodb_track_changed_pages true
  6. restart server

this seems bug.


Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more