[Pkg-dns-devel] Bug#851586: pdns-backend-mysql: fails to upgrade from 'jessie': mysql said: ERROR 1074 (42000) at line 15: Column length too big for column 'comment' (max = 21845); use BLOB or TEXT instead

[Christian Hofstaedtler]

Control: severity -1 wishlist
Control: tag -1 + wontfix

* Andreas Beckmann <anbe at debian.org> [170116 17:39]:
>   creating database backup in /var/cache/dbconfig-common/backups/pdns-backend-mysql_3.4.1-4+deb8u6.2017-01-14-15.05.20.
>   applying upgrade sql for 3.4.1-4+deb8u6 -> 4.0.1-6.
>   error encountered processing /usr/share/dbconfig-common/data/pdns-backend-mysql/upgrade/mysql/4.0.1-6:
>   mysql said: ERROR 1074 (42000) at line 15: Column length too big for column 'comment' (max = 21845); use BLOB or TEXT instead

> This was observed during a jessie->sid upgrade which picked a mysql-5.5 -> mysql-5.7 upgrade for the database server.
> Feel free to downgrade the severity if this bug is specific to that weird combination.

The SQL upgrade scripts have been patched to work with MariaDB
instead. As long as MySQL 5.7 and MariaDB 10.x do not align their
limitations, this will stay as is (or until Debian picks MySQL
again).

I'd welcome help in making those scripts work with all versions of
MariaDB/MySQL though...

Best,
-- 
christian hofstaedtler <zeha at debian.org>