Failed TO CREATE LOGFILE GROUP解决
Error CODE : 1528 Failed TO CREATE LOGFILE GROUP问题的解决办法
调整了config.ini的一些参数,重新初始化ndb,然后创建LOGFILE GROUP的时候出错,SQL如下
CREATE LOGFILE GROUP lg_1
ADD UNDOFILE 'undo_1.log'
UNDO_BUFFER_SIZE 134217728
INITIAL_SIZE 5368709120
ENGINE=NDBCLUSTER;
报错如下:
Error CODE : 1528 Failed TO CREATE LOGFILE GROUP
使用SHOW WARNINGS; 查看错误代码,获得如下错误信息:
Got error 1504 'Out of logbuffer memory' FROM NDB
Failed TO CREATE LOGFILE GROUP
解决办法:
是因为SharedGlobalMemory的值比UNDO_BUFFER_SIZE小导致错误。把SharedGlobalMemory调大,
原来我的UNDO_BUFFER_SIZE为128,但是我的SharedGlobalMemory为80,将SharedGlobalMemory设置成384M后解决问题!