[Pdns-users] Issues with DB upgrade from 3.3 to 3.4

[Chuyen Vo]

Hello list,

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.


Regards,

--Chuyen
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20141217/f87e0386/attachment.html>