Announcement

Announcement Module
Collapse
No announcement yet.

Percona shuts down and gives error regarding china IPs

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Percona shuts down and gives error regarding china IPs

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

    1407294: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)1407295:10:42[Warning] IP address '119.84.123.195' could not be resolved: Name or service not known 1407296:39:48[Warning] IP address '23.228.238.30' has been resolved to the host name '16551.kitcommercialline.com', which resembles IPv4-address itself.14072908:01:44 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql 1407298:01:45[Note] Plugin 'FEDERATED'is disabled.1407298:01:45 InnoDB: The InnoDB memory heap is disabled 1407298:01:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins 1407298:01:45 InnoDB: Compressed tables use zlib 1.2.31407298:01:45 InnoDB:Using Linux native AIO 1407298:01:45 InnoDB: Initializing buffer pool, size =128.0M 1407298:01:45 InnoDB: Completed initialization of buffer pool 1407298:01:45 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does notmatch InnoDB: the log sequence number in the ib_logfiles!1407298:01:45 InnoDB:Database was not shut down normally!

  • #2
    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.

    140729 08:01:44 mysqld_safe Starting mysqld daemon with databases from/var/lib/mysql

    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.

    Comment

    Working...
    X