<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Courier New, Courier, monospace">Just to add a bit more,
I found this exact issue listed on github but have applied the
proposed fix and am still experiencing the daemon failure.<br>
<br>
<a href="https://github.com/PowerDNS/pdns/issues/11892"
class="moz-txt-link-freetext">https://github.com/PowerDNS/pdns/issues/11892</a><br>
<br>
Cheers,<br>
-Chris<br>
</font><br>
<div class="moz-cite-prefix">On 8/8/24 4:58 PM, Chris Moody via
Pdns-users wrote:<br>
</div>
<blockquote type="cite"
cite="mid:64485326-d584-45ec-ad25-222ece3a60b9@node-nine.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<font face="Courier New, Courier, monospace">Hello all.<br>
<br>
I'm scratching my head a bit on this one. Just upgraded a node
from Debian 11.x to 12.6 and thus have upgraded pdns-server to
the 4.7.3 version that comes with. I also ran some ALTER TABLE
commands to get the new mysql/mariadb schema up to par with this
new version...in particular adding in the 'options' column to
the 'domains' table.<br>
<a
href="https://docs.powerdns.com/authoritative/backends/generic-mysql.html"
class="moz-txt-link-freetext" moz-do-not-send="true">https://docs.powerdns.com/authoritative/backends/generic-mysql.html</a><br>
<br>
My 'domains' table now is this:<br>
==========<br>
MariaDB [pdns]> desc domains;<br>
+-----------------+------------------+------+-----+---------+----------------+<br>
| Field | Type | Null | Key | Default |
Extra |<br>
+-----------------+------------------+------+-----+---------+----------------+<br>
| id | int(11) | NO | PRI | NULL |
auto_increment |<br>
| name | varchar(255) | NO | UNI | NULL
| |<br>
| master | varchar(128) | YES | | NULL
| |<br>
| last_check | int(11) | YES | | NULL
| |<br>
| type | varchar(6) | NO | | NULL
| |<br>
| notified_serial | int(10) unsigned | YES | | NULL
| |<br>
| account | varchar(40) | YES | | NULL
| |<br>
| options | varchar(64000) | YES | | NULL
| |<br>
| catalog | varchar(255) | YES | | NULL
| |<br>
+-----------------+------------------+------+-----+---------+----------------+<br>
9 rows in set (0.001 sec)<br>
<br>
<br>
Where I am having issue however is the pdns daemon is in a
restart loop throwing the following error... but I can run the
exact SQL query it is claiming it cannot run and am getting
results returned.<br>
<br>
===[ Error ]=====<br>
pdns_server[1760]: Exiting because communicator thread died with
error: virtual void
GSQLBackend::getUpdatedMasters(std::vector<DomainInfo>&,
std::unordered_set<DNSName>&, 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'<br>
=====<br>
<br>
===[ SQL working... some rows redacted from public mailinglist
chatter ]=====<br>
MariaDB [pdns]> 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');<br>
+----+------------------------------------------------------------------------+--------+-----------------+---------+---------+------------------------------------------------------------------------+<br>
| id |
name
| type | notified_serial | options | catalog |
content
|<br>
+----+------------------------------------------------------------------------+--------+-----------------+---------+---------+------------------------------------------------------------------------+<br>
| 1 | xxxyyyzzz.com
|
MASTER | 1622659014 | NULL | NULL | ns1.xxxyyyzzz.com
postmaster.xxxyyyzzz.com 1622659019 60 120 3600 3600 |<br>
| 14 |
30.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 15 |
255.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 16 |
60.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 17 |
31.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 18 |
240.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 19 |
0.0.10.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 29 |
90.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 30 |
89.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 31 |
aaabbbcccddd.com
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 32 |
88.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 36 |
2.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 37 |
50.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 38 |
27.8.10.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 39 |
25.8.10.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 40 |
10.16.172.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 41 |
99.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 46 |
254.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 47 |
20.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 48 |
21.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 49 |
61.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 50 |
200.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
| 51 |
32.168.192.in-addr.arpa
| MASTER | 1622659014 | NULL | NULL |
ns1.xxxyyyzzz.com postmaster.xxxyyyzzz.com 1622659014 60 120
3600 3600 |<br>
+----+------------------------------------------------------------------------+--------+-----------------+---------+---------+------------------------------------------------------------------------+<br>
<br>
If a manual SQL query via the user that pdns is assigned to
connect via is returning valid responses to the stated 'select'
query that the log mentions is failing... why does the process
believe the query is failing? The daemon is restarting every
second stating this failure.<br>
<br>
Any insights are greatly appreciated.<br>
<br>
Thanks,<br>
-Chris<br>
<br>
</font>
<pre class="moz-signature" cols="72">--
Node-Nine, Inc.
<a class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:chris@node-nine.com" moz-do-not-send="true">chris@node-nine.com</a>
619.354.6463</pre>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Pdns-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a>
<a class="moz-txt-link-freetext" href="https://mailman.powerdns.com/mailman/listinfo/pdns-users">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Node-Nine, Inc.
<a class="moz-txt-link-abbreviated" href="mailto:chris@node-nine.com">chris@node-nine.com</a>
619.354.6463</pre>
</body>
</html>