List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 1 2002 2:54pm
Subject:Re: bug?
View as plain text  
Did you dump the 24 records on both boxes and compare them?
Maybe someone updated the records on the slave, and now the dates don't 
match.


Vico Timmermans wrote:

>I think i stumbled upon a bug that's got something to do with join
>size. Detailed information below.
>
>Using 2 intel-linux platforms with replication the query stated
>below works fine on one machine:
>- mysql  Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686)
>- Linux deedee 2.2.16-SMP #1 SMP Wed Aug 16 05:07:06 GMT 2000 i686
>unknown
>and gives reduced results on the other:
>- mysql  Ver 11.15 Distrib 3.23.41, for suse-linux (i686)
>- Linux blossom 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown
>
>The query states as follows:
>SELECT isp.naam AS provider, MID(log.logtijd,1,10) AS datum,
>acties.adres AS adres, acties.omschrijving AS adres_omschrijving,
>SUM(log.data) AS bytes, SUM(log.duur)/10 AS seconden,
>SUM(log.data)*80/SUM(log.duur) AS kbs, COUNT(*) AS aantal,
>inbelpunten.id, inbelpunten.plaats, inbelpunten.netwerk FROM log, taken,
>deploy , acties , inbelpunten, isp WHERE log.taakID = taken.ID AND
>taken.deployID = deploy.ID AND log.actieID = acties.ID AND
>taken.inbelpuntid=inbelpunten.id AND inbelpunten.ispid=isp.id AND
>log.logtijd >= '2002-03-22' and log.logtijd < DATE_ADD('2002-03-28',
>INTERVAL 1 DAY) AND (deploy.keyword = 'STISDN') AND taken.medium='isdn'
>AND ((log.meldingid = 10) OR (log.meldingid = 11) OR (log.meldingid =
>12)) GROUP BY isp.ID ORDER BY kbs DESC
>


Thread
bug?Vico Timmermans29 Mar
  • Re: bug?Gerald Clark1 Apr