Not the answer you need?
Register and ask your own question!

Percona shuts down and gives error regarding china IPs

luckybabuluckybabu EntrantInactive User Role Beginner
My perconal server shuts down frequently. this was not happening before installing percona on centos, cpanel server i followed official documentation of cpanel.

140729 4:45:27 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.37-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 140729 5:10:42 [Warning] IP address '119.84.123.195' could not be resolved: Name or service not known 140729 6:39:48 [Warning] IP address '23.228.238.30' has been resolved to the host name '16551.kitcommercialline.com', which resembles IPv4-address itself. 140729 08:01:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140729 8:01:45 [Note] Plugin 'FEDERATED' is disabled. 140729 8:01:45 InnoDB: The InnoDB memory heap is disabled 140729 8:01:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140729 8:01:45 InnoDB: Compressed tables use zlib 1.2.3 140729 8:01:45 InnoDB: Using Linux native AIO 140729 8:01:45 InnoDB: Initializing buffer pool, size = 128.0M 140729 8:01:45 InnoDB: Completed initialization of buffer pool 140729 8:01:45 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140729 8:01:45 InnoDB: Database was not shut down normally!

Comments

  • psongpsong Contributor Inactive User Role Beginner
    The messages on IP addresses were just warnings, in the first case, the DNS lookup couldn't resolve the ip, in the second case, the host name looks like an IP address. Neither of these warnings would cause mysqld to shutdown.

    There is no error message around the timestamp of this restart. Either something was seriously wrong and mysqld didn't get a chance to leave any hint, or the mysqld process was killed abruptly.



    Can you please check error log for each restart and see if there was always no error logged before each restart? And please check if there could be any chance that some process kills mysqld.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.