[Pdns-users] Error after upgrade

[Jorge Arenas]

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/a6e9a131/attachment.htm>