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@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
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
