SOLVED: Unable to add undofile to DEFAULT-LG

[Thomas Waibel]

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.