> I had the same problem with my MySQL replication until I changed the
> default timeout settings.
> Here is my my.cnf. Note the slave-net-timeout and master-connect-retry
> options.
>
>
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> # Default to using old password forma
/mysqld/mysqld.pid
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Maik Fuss
Sent: 16 April 2007 08:59 PM
To: pdns-users@mailman.powerdns.com
Subject: Re: [Pdns-users] mysql timeout
> Thank you for verifying, but please remain polite.
>
> Is your
> Thank you for verifying, but please remain polite.
>
> Is your server a very quiet one?
>
> Bert
>
>
Excuse my impolitely, but... :)
The server is quiet (few domains) for the WAN, but for the VPN he is the
mainserver and so its a slow working with this problem atm.
_
On Mon, Apr 16, 2007 at 06:59:55PM +0200, Maik Fuss wrote:
> > Can you verify the problem also exists with
> > http://svn.powerdns.com/snapshots/1029/
> same shit ...
Thank you for verifying, but please remain polite.
Is your server a very quiet one?
Bert
--
http://www.PowerDNS.com
> There are different MySQL client libraries in use for different versions of
> PowerDNS. Which version do you run, and where did you get it from
> (distribution, self-compiled, deb or rpm from our website) etc.
>
> Can you verify the problem also exists with
> http://svn.powerdns.com/snapshots/10
> There are different MySQL client libraries in use for different versions of
> PowerDNS. Which version do you run, and where did you get it from
> (distribution, self-compiled, deb or rpm from our website) etc.
>
> Can you verify the problem also exists with
> http://svn.powerdns.com/snapshots/10
On Sun, Apr 15, 2007 at 03:27:38AM +0200, Maik Fuss wrote:
> if i connect the pdnsd (srv4) over vpn to srv1-mysql(replicate) it works
> fine...
> if i connect the pdnsd (srv4) over the IP from the vpn-iface or over
> socket directly, i become a timeout on every second query
There are different My
> You need to use a reasonable timeout, not 60 seconds which might
> work for a web app. Try the default 43200 (12h) or 86400 (24h)
> or more instead.
>
>
nope, that isn't the problem...
i think its anything with the tcp connection over vpn...
layout from my vpn-server network:
srv1 = vpn-cl
Maik,
You need to use a reasonable timeout, not 60 seconds which might
work for a web app. Try the default 43200 (12h) or 86400 (24h)
or more instead.
Ken
On Thu, Apr 12, 2007 at 10:50:28AM +0200, maik wrote:
> hi,
> anybody knows how to fix this problem?
>
>
> pdns[19733]: Backend error: Fail
hi,
anybody knows how to fix this problem?
pdns[19733]: Backend error: Failed to execute mysql_query, perhaps
connection died? Err=1: MySQL server has gone away
pdns[19733]: gmysql Connection succesful
pdns[19733]: Backend error: Failed to execute mysql_query, perhaps
connection died? Err=1: MySQ
10 matches
Mail list logo