<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hello list,<br><br>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: <a href="http://doc.powerdns.com/md/authoritative/upgrading/" target="_blank">http://doc.powerdns.com/md/authoritative/upgrading/</a><br><br>When we add more fields such as ordername with size:<br><pre><code>ALTER TABLE records ADD ordername VARCHAR(255) BINARY DEFAULT NULL;<br><br>MySQL will encounter error:<br><br>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<br><br>So you should update the upgrade document such as:<br><br>ALTER TABLE records MODIFY content VARCHAR(62000) DEFAULT NULL;<br><br>to prevent MySQL row-size limit itself.<br><br><br>Regards,<br><br>--Chuyen<br></code></pre> </div></body>
</html>