[Pdns-users] Need help after the upgrade

[Otto Moerbeek]

On Thu, Feb 27, 2025 at 08:04:05AM +0100, Otto Moerbeek via Pdns-users wrote:

> On Thu, Feb 27, 2025 at 12:22:07AM +0200, Peter Zoltan Keresztes (zozo) via Pdns-users wrote:
> 
> > I don’t see any issue with the database. I is working fine while the pdns constantly throws those errors I am connected to the database and running queries on it.
> > 
> > 
> > 
> > > On 27 Feb 2025, at 00:19, Kevin P. Fleming via Pdns-users <pdns-users at mailman.powerdns.com> wrote:
> > > 
> > > "Lost connection to server during query" means the database server shut down, or crashed, or soemthing.
> > > 
> > > On Wed, Feb 26, 2025, at 16:48, Peter Zoltan Keresztes (zozo) via Pdns-users wrote:
> > > 
> > 
> 
> Looks like the zone cache query is killed because it's taking too long.
> 
> As a possible quick workaround to get runnig again you can disable the
> zone cache by setting zone-cache-refresh-interval to 0.
> 
> Then investigate which parameter in your DB determines maximum query
> time, enlarge it and enable the zone cache again.
> 
> 	-Otto

Forgot to mention: it also might be your DB schema is missing an
index, making the zone cache query slow.

	-Otto