AliSQL icon indicating copy to clipboard operation
AliSQL copied to clipboard

安装后启动报错,求指导解决方案

Open Zoey-zheng opened this issue 7 years ago • 7 comments

系统版本:cent os 7

报错内容: Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid)

Zoey-zheng avatar Nov 02 '18 05:11 Zoey-zheng

同样碰到编译alisql,mysqld启动不起来 命令如下 sudo bin/mysqld -uvagrant 输出日志

Couldn't start tokuft because some other tokuft process is using the same directory [/opt/alisql/data/] for [environment] 2019-04-03 08:32:14 27471 [ERROR] TokuDB unknown error 13 2019-04-03 08:32:14 27471 [ERROR] Plugin 'TokuDB' init function returned error. 2019-04-03 08:32:14 27471 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed. 2019-04-03 08:32:14 27471 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-04-03 08:32:14 27471 [Note] InnoDB: The InnoDB memory heap is disabled 2019-04-03 08:32:14 27471 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-03 08:32:14 27471 [Note] InnoDB: Memory barrier is not used 2019-04-03 08:32:14 27471 [Note] InnoDB: Compressed tables use zlib 1.2.3 2019-04-03 08:32:14 27471 [Note] InnoDB: Using CPU crc32 instructions 2019-04-03 08:32:14 27471 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2019-04-03 08:32:14 27471 [Note] InnoDB: Completed initialization of buffer pool 2019-04-03 08:32:14 27471 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode 2019-04-03 08:32:14 27471 [ERROR] InnoDB: The system tablespace must be writable! 2019-04-03 08:32:14 27471 [ERROR] Plugin 'InnoDB' init function returned error. 2019-04-03 08:32:14 27471 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2019-04-03 08:32:14 27471 [ERROR] Failed to initialize plugins. 2019-04-03 08:32:14 27471 [ERROR] Aborting

my.cnf [mysqld] mysqld=/opt/alisql/bin/mysqld port=3306 datadir=/home/vagrant/alisql innodb_data_file_path=/home/vagrant/alsql/innodb

XUZHOUWANG avatar Apr 03 '19 08:04 XUZHOUWANG

这不写了么,占用资源,之前是不是装过啊,目录下资源占用了

以上,祝好~ 郑英俊 研发及应用中心 东软睿道教育信息技术有限公司 沈阳市浑南新区新秀街2号A9417室 Postcode:110000 Tel:13904942764 Email:[email protected] Http://www.neusoft.com


在2019年04月03日 16:34,守拙 写道:

同样碰到编译alisql,mysqld启动不起来 命令如下 sudo bin/mysqld -uvagrant 输出日志 Couldn't start tokuft because some other tokuft process is using the same directory [/opt/alisql/data/] for [environment] 2019-04-03 08:32:14 27471 [ERROR] TokuDB unknown error 13 2019-04-03 08:32:14 27471 [ERROR] Plugin 'TokuDB' init function returned error. 2019-04-03 08:32:14 27471 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed. 2019-04-03 08:32:14 27471 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-04-03 08:32:14 27471 [Note] InnoDB: The InnoDB memory heap is disabled 2019-04-03 08:32:14 27471 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-03 08:32:14 27471 [Note] InnoDB: Memory barrier is not used 2019-04-03 08:32:14 27471 [Note] InnoDB: Compressed tables use zlib 1.2.3 2019-04-03 08:32:14 27471 [Note] InnoDB: Using CPU crc32 instructions 2019-04-03 08:32:14 27471 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2019-04-03 08:32:14 27471 [Note] InnoDB: Completed initialization of buffer pool 2019-04-03 08:32:14 27471 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode 2019-04-03 08:32:14 27471 [ERROR] InnoDB: The system tablespace must be writable! 2019-04-03 08:32:14 27471 [ERROR] Plugin 'InnoDB' init function returned error. 2019-04-03 08:32:14 27471 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2019-04-03 08:32:14 27471 [ERROR] Failed to initialize plugins. 2019-04-03 08:32:14 27471 [ERROR] Aborting

my.cnf [mysqld] mysqld=/opt/alisql/bin/mysqld port=3306 datadir=/home/vagrant/alisql innodb_data_file_path=/home/vagrant/alsql/innodb

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

Zoey-zheng avatar Apr 03 '19 11:04 Zoey-zheng

这个问题解决了,现在碰到的是另一个 image

感谢

XUZHOUWANG avatar Apr 04 '19 01:04 XUZHOUWANG

你先看下是不是跟这个一样没有权限 http://stackoverflow.com/questions/31813552/linux-antergos-install-mysql 另外我有配置好的cent os 的alisql 备份,需要的话联系我,免费

Zoey-zheng avatar Apr 04 '19 01:04 Zoey-zheng

嗯,不是权限问题。手机能加微信吗?

XUZHOUWANG avatar Apr 04 '19 06:04 XUZHOUWANG

可以,你微信多少

以上,祝好~ 郑英俊 研发及应用中心 东软睿道教育信息技术有限公司 沈阳市浑南新区新秀街2号A9417室 Postcode:110000 Tel:13904942764 Email:[email protected] Http://www.neusoft.com


在2019年04月04日 14:54,守拙 写道:

嗯,不是权限问题。手机能加微信吗?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

Zoey-zheng avatar Apr 04 '19 07:04 Zoey-zheng

18867130113

XUZHOUWANG avatar Apr 04 '19 07:04 XUZHOUWANG