[Pdns-users] Issues with DB upgrade from 3.3 to 3.4
vdchuyen at live.com
Wed Dec 17 04:30:41 UTC 2014
As we have some name-servers running 3.3 and we are rolling out testing upgrade to 3.4. I followed the instruction DB schema here: http://doc.powerdns.com/md/authoritative/upgrading/
When we add more fields such as ordername with size:
ALTER TABLE records ADD ordername VARCHAR(255) BINARY DEFAULT NULL;
MySQL will encounter error:
ERROR 1118 (42000) at line 6: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
So you should update the upgrade document such as:
ALTER TABLE records MODIFY content VARCHAR(62000) DEFAULT NULL;
to prevent MySQL row-size limit itself.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pdns-users