Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

[Andrej Pintar]

any warnings in the logs. timeouts. connects. had same thing... just 
can't remember what was it.

-> never upgrade if the system works with no errors.

did you test and simulate in the development environment?

-- 
Andrej Pintar
email : api984@stripped
            andrej@stripped
            api984@stripped
web: http://www.api984.net
contact cell: 00385 98 790 639
home server: http://api984.ath.cx
ICQ: 191748772
Skype: api9841
MSN: fatallord@stripped
IRC: api984, freenode.net
FACEBOOK: www.facebook.com/api984
Hometown Site: www.skrad.com
::Software is like sex: it's better when it's free::--


On 4.9.2011. 19:12, Adam PAPAI wrote:
>
>
> Adam PAPAI wrote:
>> Dear List,
>>
>> I have a Master -> [ Slave 1, Slave 2 ] setup for years.
>
>
> I have the db under /var/db/mysql
>
> it shows:
>
> -rw-rw----   1 mysql  mysql  149765008 Sep  4 18:37 
> tungsten-relay-bin.000214
> -rw-rw----   1 mysql  mysql         67 Sep  4 18:38 relay-log.info
> -rw-rw----   1 mysql  mysql         73 Sep  4 18:38 master.info
>
> but the date is:
>
> [root@tungsten /var/db/mysql]# date
> Sun Sep  4 19:11:13 CEST 2011
>
>
>
> And it's delayed 1 hour. No data is transferred to the slave. It says: 
> Secords behind master 0.
>
> What the hell is going on here?
>