MySQL Forums
Forum List  »  NDB clusters

SOLVED: Unable to add undofile to DEFAULT-LG
Posted by: Thomas Waibel
Date: November 22, 2017 08:13AM

Forgot the back ticks in my panic mode.
ALTER LOGFILE GROUP `DEFAULT-LG` ADD UNDOFILE 'undo10.log' INITIAL_SIZE 1G ENGINE NDBCLUSTER;
works perfectly fine...

---
Hi,
we are getting
ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTER
from a normally working INSERT command.

select * from ndbinfo.logspaces where log_type='DD-UNDO';
gives
node_id log_type log_id log_part total used
3 DD-UNDO 4 0 10737418240 10416001844
4 DD-UNDO 4 0 10737418240 10417391216
5 DD-UNDO 4 0 10737418240 10737287232

Node 6 is currently down...

Config
...
InitialLogFileGroup=undo_buffer_size=128M;undo0.log:1G;undo1.log:1G;undo2.log:1G;undo3.log:1G;undo4.log:1G;undo5.log:1G;undo6.log:1G;undo7.log:1G;undo8.log:1G;undo9.log:1G
InitialTablespace=name=TS1;extent_size=1M;data00.dat:4G;data01.dat:4G;data02.dat:4G;data03.dat:4G;data04.dat:4G;data05.dat:4G;data06.dat:4G;data07.dat:4G;data08.dat:4G;data09.dat:4G;data10.dat:4G;data11.dat:4G
...

SELECT logfile_group_name FROM information_schema.files where tablespace_name = 'TS1' limit 1
gives DEFAULT-LG as result.

So the tablespace TS1 uses DEFAULT-LG as logfile group.

So now I try to increase the undo space by
ALTER LOGFILE GROUP DEFAULT-LG ADD UNDOFILE 'undo10.log' INITIAL_SIZE 1G ENGINE NDBCLUSTER;

Above command gives:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT-LG ADD UNDOFILE 'undo10.log' INITIAL_SIZE 1G ENGINE NDBCLUSTER' at line 1



Edited 1 time(s). Last edit at 11/22/2017 08:26AM by Thomas Waibel.

Options: ReplyQuote


Subject
Views
Written By
Posted
SOLVED: Unable to add undofile to DEFAULT-LG
290
November 22, 2017 08:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.