Re: Need help after the upgrade

"Peter Zoltan Keresztes \(zozo\) via Pdns-users" <[email protected]> Thu, 27 Feb 2025 17:12:42 +0200
Newsgroups	gmane.network.dns.powerdns.user
Message-ID	<[email protected]>
8bit-dns=yes
api=yes
api-key=changeme
cache-ttl=20
config-dir=/etc/pdns
daemon=yes
default-api-rectify=yes
default-ksk-algorithm=ecdsa256
default-ksk-size=0
default-ttl=3600
direct-dnskey=yes
disable-axfr=yes
distributor-threads=3
dname-processing=yes
dnssec-key-cache-ttl=30
dnsupdate=yes
domain-metadata-cache-ttl=60
guardian=no
launch=gmysql
gmysql-user=powerdns
gmysql-password=Password
gmysql-dbname=powerdns
gmysql-host=10.100.2.9
gmysql-dnssec=yes
local-address=0.0.0.0,::
local-port=53
log-dns-details=yes
log-dns-queries=yes
log-timestamp=yes
loglevel=9
loglevel-show=yes
max-tcp-connection-duration=0
max-tcp-connections=20
max-tcp-connections-per-client=0
max-tcp-transactions-per-conn=0
query-cache-ttl=20
query-local-address=0.0.0.0::
queue-limit=1500
receiver-threads=1
rng=auto
server-id=dns2
setgid=pdns
setuid=pdns
tcp-fast-open=0
tcp-idle-timeout=5
version-string=anonymous
webserver-address=0.0.0.0
webserver-allow-from=0.0.0.0,::
webserver-loglevel=detailed
webserver-max-bodysize=2
webserver-port=8082
webserver-print-arguments=no
write-pid=yes

> On 27 Feb 2025, at 16:30, [email protected] wrote:
> 
> I just noticed something wierd in your query.
> 
> >  SELECT content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM records WHERE (disabled=0 OR ?) and domain_id=? order by name, type
> 
> That "disabled=0 or ?" construct seems off to me. Can you please post your full and unedited (only mask the passwords, nothing else) PowerDNS config file?
> 
> Frank
> 
>> On 27 Feb 2025, at 15:23, Peter Zoltan Keresztes (zozo) <[email protected]> wrote:
>> 
>> Just did that increased it to 128M no change whatsoever.
>> 
>> Peter
>> 
>>> On 27 Feb 2025, at 16:22, [email protected] wrote:
>>> 
>>> Try increasing max_allowed_packet in your mysqld config, see if that helps...
>>> 
>>> 
>>> Frank
>>> 
>>>> On 27 Feb 2025, at 15:10, Peter Zoltan Keresztes (zozo) via Pdns-users <[email protected]> wrote:
>>>> 
>>>> This is really strange situation. 
>>>> I have the list of records added to the domain. I can check pdnsutil check-zone zozoo.io <http://zozoo.io/> works with no issue. I edit the zone with pdnsutil edit-zone zozoo.io <http://zozoo.io/> I add yet another boring A record nothing strange, when to apply I get
>>>> Error: GSQLBackend unable to list domain 'zozoo.io': Could not execute mysql statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM records WHERE (disabled=0 OR ?) and domain_id=? order by name, type: Lost connection to server during query
>>>> I added the record directly into the mysql database. Running a dnsutil check-zone zozoo.io <http://zozoo.io/> same error. I removed the record from the backend via mysql I can run dnsutil check-zone zozoo.io <http://zozoo.io/> with no issues.
>>>> 
>>>> Note I am running powerdns 4.9.4
>>>> 
>>>> 
>>>>> On 27 Feb 2025, at 13:58, Peter Zoltan Keresztes (zozo) <[email protected]> wrote:
>>>>> 
>>>>> I have reinstalled the pdns exported the zones to csv files and readied the used one using pdnsutil however when I try to save sometimes I am getting the same errors.
>>>>> 
>>>>> mysql> explain select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0
>>>>>     -> ;
>>>>> +----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+
>>>>> | id | select_type | table   | partitions | type | possible_keys            | key            | key_len | ref                         | rows | filtered | Extra       |
>>>>> +----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+
>>>>> |  1 | SIMPLE      | domains | NULL       | ALL  | PRIMARY,name_index       | NULL           | NULL    | NULL                        |    1 |   100.00 | NULL        |
>>>>> |  1 | SIMPLE      | records | NULL       | ref  | nametype_index,domain_id | nametype_index | 271     | powerdns.domains.name,const |    1 |    10.00 | Using where |
>>>>> +----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+
>>>>> 2 rows in set, 1 warning (0.01 sec)
>>>>> 
>>>>> 
>>>>> 
>>>>>> On 27 Feb 2025, at 11:04, frank--- via Pdns-users <[email protected]> wrote:
>>>>>> 
>>>>>> explain select domains.id <http://domains.id/>, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id <http://domains.id/> AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0
>>>>>> 
>>>>> 
>>>> 
>>>> _______________________________________________
>>>> Pdns-users mailing list
>>>> [email protected]
>>>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>>> 
>> 
>

_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users
signature.asc (application/pgp-signature, 228 B)