[Pdns-users] Error after upgrade

[Markus Ehrlicher]

Hello Jorge,

I stumbled upon the same problem a few months ago. Here you can find the schema-updates:
https://github.com/PowerDNS/pdns/tree/master/modules/gmysqlbackend

best regards,
Markus

Von: Pdns-users <pdns-users-bounces at mailman.powerdns.com> Im Auftrag von Jorge Arenas via Pdns-users
Gesendet: Montag, 19. Oktober 2020 05:42
An: pdns-users at mailman.powerdns.com
Betreff: [Pdns-users] Error after upgrade

I have a Centos 7 running PowerDNS

after a update to

 mysql-community-server-8.0.22-1.el7.x86_64
 mysql-community-devel-8.0.22-1.el7.x86_64
 pdns-4.3.1-1pdns.el7.x86_64
 pdns-backend-mysql-4.3.1-1pdns.el7.x86_64
 pdns-tools-4.3.1-1pdns.el7.x86_64

I am receiving this messages


ct 18 22:38:14 pdns_server: Backend error: GSQLBackend unable to find before/after (after) for domain_id 48 and qname 'xxxx': Could not execute mysql statement: select ordername from records where ordername > ? and domain_id=? and disabled=0 and ordername is not null order by 1 asc limit 1: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '>'

Oct 18 22:38:16 pdns_server: Backend reported permanent error which prevented lookup (GSQLBackend unable to find before/after (after) for domain_id 48 and qname 'xxxx': Could not execute mysql statement: select ordername from records where ordername > ? and domain_id=? and disabled=0 and ordername is not null order by 1 asc limit 1: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '>'), aborting

Oct 18 22:38:16 pdns_server: Backend error: GSQLBackend unable to find before/after (after) for domain_id 48 and qname 'xxxxxx': Could not execute mysql statement: select ordername from records where ordername > ? and domain_id=? and disabled=0 and ordername is not null order by 1 asc limit 1: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '>'


I do not know if there some bug or requirement of the updated software

I had and old version of pdns and I do not know if i need to update my database schema

Can someone help me or point me in the right direction?

thanks in advance

Jorge Arenas








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20201019/104e50f4/attachment.htm>