MYSQL无法启动。

noqcom 2015-12-14 2160

Digitalocean 好像装appnode很多问题,其他面板都很正常的说。

Initializing MySQL database: WARNING: The host 'centos-512mb-sgp1-06'

could not be looked up with /usr/bin/resolveip. This probably means that

your libc libraries are not 100 % compatible with this binary MySQL

version. The MySQL daemon, mysqld, should work normally with the exception

that host name resolving will not work. This means that you should use IP

addresses instead of hostnames when specifying MySQL privileges !

Installing MySQL system tables...2015-12-13 22:05:25 0 [Warning] option

'relay_log_space_limit': unsigned value 17179869184 adjusted to 4294967295

2015-12-13 22:05:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is

deprecated. Please use --explicit_defaults_for_timestamp server option

(see documentation for more details). 2015-12-13 22:05:25 0 [Note]

/usr/libexec/mysqld (mysqld 5.6.27) starting as process 1768 ... 2015-12-

13 22:05:25 1768 [Note] InnoDB: Using atomics to ref count buffer pool

pages 2015-12-13 22:05:25 1768 [Note] InnoDB: The InnoDB memory heap is

disabled 2015-12-13 22:05:25 1768 [Note] InnoDB: Mutexes and rw_locks use

GCC atomic builtins 2015-12-13 22:05:25 1768 [Note] InnoDB: Memory barrier

is not used 2015-12-13 22:05:25 1768 [Note] InnoDB: Compressed tables use

zlib 1.2.3 2015-12-13 22:05:25 1768 [Note] InnoDB: Using Linux native AIO

2015-12-13 22:05:25 1768 [Note] InnoDB: Not using CPU crc32 instructions

2015-12-13 22:05:25 1768 [Note] InnoDB: Initializing buffer pool, size =

128.0M 2015-12-13 22:05:25 1768 [Note] InnoDB: Completed initialization of

buffer pool 2015-12-13 22:05:25 1768 [Note] InnoDB: The first specified

data file ./ibdata1 did not exist: a new database to be created! 2015-12-

13 22:05:25 1768 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2015

-12-13 22:05:25 1768 [Note] InnoDB: Database physically writes the file

full: wait... 2015-12-13 22:05:25 1768 [Note] InnoDB: Setting log file

./ib_logfile101 size to 48 MB 2015-12-13 22:05:25 1768 [Note] InnoDB:

Setting log file ./ib_logfile1 size to 48 MB 2015-12-13 22:05:26 1768

[Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2015-12

-13 22:05:26 1768 [Warning] InnoDB: New log files created, LSN=45781 2015

-12-13 22:05:26 1768 [Note] InnoDB: Doublewrite buffer not found: creating

new 2015-12-13 22:05:26 1768 [Note] InnoDB: Doublewrite buffer created

2015-12-13 22:05:26 1768 [Note] InnoDB: 128 rollback segment(s) are

active. 2015-12-13 22:05:26 1768 [Warning] InnoDB: Creating foreign key

constraint system tables. 2015-12-13 22:05:26 1768 [Note] InnoDB: Foreign

key constraint system tables created 2015-12-13 22:05:26 1768 [Note]

InnoDB: Creating tablespace and datafile system tables. 2015-12-13

22:05:26 1768 [Note] InnoDB: Tablespace and datafile system tables

created. 2015-12-13 22:05:26 1768 [Note] InnoDB: Waiting for purge to

start 2015-12-13 22:05:26 1768 [Note] InnoDB: 5.6.27 started; log sequence

number 0 2015-12-13 22:05:26 1768 [Note] RSA private key file not found:

/var/lib/mysql//private_key.pem. Some authentication plugins will not

work. 2015-12-13 22:05:26 1768 [Note] RSA public key file not found:

/var/lib/mysql//public_key.pem. Some authentication plugins will not work.

2015-12-13 22:05:26 1768 [Note] Binlog end 2015-12-13 22:05:26 1768 [Note]

InnoDB: FTS optimize thread exiting. 2015-12-13 22:05:26 1768 [Note]

InnoDB: Starting shutdown... 2015-12-13 22:05:28 1768 [Note] InnoDB:

Shutdown completed; log sequence number 1625977 OK Filling help

tables...2015-12-13 22:05:28 0 [Warning] option 'relay_log_space_limit':

unsigned value 17179869184 adjusted to 4294967295 2015-12-13 22:05:28 0

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use

--explicit_defaults_for_timestamp server option (see documentation for

more details). 2015-12-13 22:05:28 0 [Note] /usr/libexec/mysqld (mysqld

5.6.27) starting as process 1790 ... 2015-12-13 22:05:28 1790 [Note]

InnoDB: Using atomics to ref count buffer pool pages 2015-12-13 22:05:28

1790 [Note] InnoDB: The InnoDB memory heap is disabled 2015-12-13 22:05:28

1790 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-12-

13 22:05:28 1790 [Note] InnoDB: Memory barrier is not used 2015-12-13

22:05:28 1790 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-12-13

22:05:28 1790 [Note] InnoDB: Using Linux native AIO 2015-12-13 22:05:28

1790 [Note] InnoDB: Not using CPU crc32 instructions 2015-12-13 22:05:28

1790 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-12-13

22:05:28 1790 [Note] InnoDB: Completed initialization of buffer pool 2015

-12-13 22:05:28 1790 [Note] InnoDB: Highest supported file format is

Barracuda. 2015-12-13 22:05:28 1790 [Note] InnoDB: 128 rollback segment(s)

are active. 2015-12-13 22:05:28 1790 [Note] InnoDB: Waiting for purge to

start 2015-12-13 22:05:28 1790 [Note] InnoDB: 5.6.27 started; log sequence

number 1625977 2015-12-13 22:05:28 1790 [Note] RSA private key file not

found: /var/lib/mysql//private_key.pem. Some authentication plugins will

not work. 2015-12-13 22:05:28 1790 [Note] RSA public key file not found:

/var/lib/mysql//public_key.pem. Some authentication plugins will not work.

2015-12-13 22:05:28 1790 [Note] Binlog end 2015-12-13 22:05:28 1790 [Note]

InnoDB: FTS optimize thread exiting. 2015-12-13 22:05:28 1790 [Note]

InnoDB: Starting shutdown... 2015-12-13 22:05:30 1790 [Note] InnoDB:

Shutdown completed; log sequence number 1625987 OK To start mysqld at boot

time you have to copy support-files/mysql.server to the right place for

your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To

do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u

root -h 127.0.0.1 password 'new-password' Alternatively you can run:

/usr/bin/mysql_secure_installation which will also give you the option of

removing the test databases and anonymous user created by default. This is

strongly recommended for production servers. See the manual for more

instructions. You can start the MySQL daemon with: cd /usr ;

/usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-

run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems

at http://bugs.mysql.com/ The latest information about MySQL is available

on the web at http://www.mysql.com Support MySQL by buying

support/licenses at http://shop.mysql.com Note: new default config file

not created. Please make sure your config file is current WARNING: Default

config file /etc/my.cnf exists on the system This file will be read by

default by the MySQL server If you do not want to use this, either remove

it, or use the --defaults-file argument to mysqld_safe when starting the

server [ OK ]
MySQL Daemon failed to start. Starting mysqld: [FAILED]


最新回复 (3)
  • appnode 2015-12-14
    引用 2
    尝试手工美化日志格式,10分钟过去了仍然没完成……

    麻烦把错误日志按人类能看懂的格式粘贴出来。

    节约别人的时间就是节约自己的时间~~
  • noqcom 2015-12-14
    引用 3
    本帖最后由 noqcom 于 2015-12-14 12:53 编辑

    按下立即启动就输出之前那些,原字原味....就是这麽多,多到还要用浏览器慢慢滑。
    有很多log可以输出,appnode面板选择人类看不懂的来显示。
    既然不是给使用者看的,也不是给appnode开发者看的,我也不知道显示给谁看的....。

    算了,是要 mysqld.log?
    151213 23:15:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    151213 23:18:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    2015-12-13 23:18:12 0 [Warning] option 'relay_log_space_limit': unsigned value 17179869184 adjusted to 4294967295
    2015-12-13 23:18:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-12-13 23:18:12 0 [Note] /usr/libexec/mysqld (mysqld 5.6.27) starting as process 3277 ...
    2015-12-13 23:18:12 3277 [Warning] Buffered warning: Performance schema disabled (reason: init failed).

    151213 23:18:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended



    还有,光是进:8888首页似乎很容易卡在 "AppNode正在启动中,请稍候" 一卡就是卡死..进入软件列表也是容易卡住。
    一预装好没经过任何设定直装appnode就这样,重装无数次更换不同节点VPS
    一样容易卡死 "AppNode正在启动中,请稍候" ,MYSQL没办法一键无错启动。

    另外...Digitalocean 的Centos版本是 6.7 只有这个...

    VPSMATE都没这问题的说。

  • appnode 2015-12-14
    引用 4
    Quotenoqcom 发表于 2015-12-14 12:43
    按下立即启动就输出之前那些,原字原味....就是这麽多,多到还要用浏览器慢慢滑。
    有很多log可以输出,appn ...


    如果有卡死 "AppNode正在启动中,请稍候"的情况,可以入群找下管理员看看。
返回
发新帖