Odd error with all-zones commands

James Cloos <[email protected]>
Newsgroups gmane.network.dns.powerdns.devel
Message-ID <[email protected]>
When I try:

  :; pdnssec rectify-all-zones

I get:

  Error: Database error trying to retrieve all domains:PostgreSQL failed to execute command: 

An strace shows that the sql was sent and the reply dies include the
requested data:

  send(5, "Q\0\0\0\327select records.domain_id, records.name,
  records.content, domains.type, domains.master,
  domains.notified_serial, domains.last_check from records, domains
  where records.domain_id=domains.id and records.type='SOA'\0", 216,
  MSG_NOSIGNAL) = 216

is followed by a correct recv(5,...) with valid data, but spgsql.cc:
SPgSQL::doCommand() still throws.

Should that call use doQuery() instead?  The difference, of course, is
that doQuery() expects PGRES_TUPLES_OK whereas doCommand() expects
PGRES_COMMAND_OK.

-JimC
-- 
James Cloos <[email protected]>         OpenPGP: 1024D/ED7DAEA6
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.