<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<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">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" href="mailto:chris@node-nine.com">chris@node-nine.com</a>
619.354.6463</pre>
</body>
</html>