PowerDNS always restrat with mysqlbackend (Debian 12, PowerDNS 4.7.3-2, MariaDB-10.11.6)

[xxMAKCxx]

Hello, always restarted with this error:
2024-10-03T12:38:24.803144+03:00 ns0 pdns_server[15431]: Exiting because communicator thread died with error: virtual void GSQLBackend::getUpdatedMasters(std::vector&, std::unordered_set&, CatalogHashMap&) unable to retrieve list of master domains: Could not prepare statement: select d.id, d.name, d.type, d.notified_serial,d.options, d.catalog,r.content from records r join domains d on r.domain_id=d.id and r.name=d.name where r.type='SOA' and r.disabled=0 and d.type in ('MASTER', 'PRODUCER'): Unknown column 'd.options' in 'field list'

[omoerbeek]

Read the upgrade guide, your DB schema is out of date

[xxMAKCxx]

It is new install, used this schema for DB https://github.com/PowerDNS/pdns/blob/rel/rec-4.7.x/modules/gmysqlbackend/schema.mysql.sql.

[Habbie]

that is a very old schema, better use https://github.com/PowerDNS/pdns/blob/rel/auth-4.9.x/modules/gmysqlbackend/schema.mysql.sql or the (identical) one in our documentation.

[omoerbeek]

That is not the right schema. This is the right one: https://github.com/PowerDNS/pdns/blob/rel/auth-4.7.x/modules/gmysqlbackend/schema.mysql.sql

Recursor and auth version numbers do not go in-sync. BTW, the proper schema file is installed with the backend package. Look in /usr/share/doc/pdns-backend-mysql/

[xxMAKCxx]

Ok, thanks, will try it.