Replication Bug on 4.0.18 with HEAP Tables

Hi!

we use HEAP-Tables on our server for temporary data and so we create them with PHP, Insert Data INTO and do then DROP the Table in the same script.

on the slave it seams, that the DROP-Command was before the CREATE.

here is the error-log:

ERROR: 1146  Table 'WEB_BZ.OL_Kat_1091859321' doesn't exist
040807 12:05:10  Slave: Error 'Table 'WEB_BZ.OL_Kat_1091859321' doesn't exist' on query 'DELETE FROM `WEB_BZ`.`OL_Kat_1091859321`'. Default database: 'WEB_BZ', Error_code: 1146
040807 12:05:10  Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE$
ERROR: 1050  Table 'OL_Kat_1091859321' already exists
040807 12:06:16  Slave: Error 'Table 'OL_Kat_1091859321' already exists' on query 'CREATE TABLE OL_Kat_1091859321 TYPE=HEAP
                SELECT AID FROM ADRESSEN_ADRESSKATEGORIEN INNER JOIN ADRESSKATEGORIEN ON ADRESSEN_ADRESSKATEGORIEN.KID=ADRESS$
                WHERE (ADRESSEN_ADRESSKATEGORIEN.KID=2 OR ADRESSEN_ADRESSKATEGORIEN.KID=63) AND KStatus>=2
                GROUP BY AID
                HAVING COUNT(*)=2'. Default database: 'WEB_BZ', Error_code: 1050
040807 12:06:16  Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE$
ERROR: 1146  Table 'WEB_BZ.OL_Kat_1091863020' doesn't exist
040807 12:07:41  Slave: Error 'Table 'WEB_BZ.OL_Kat_1091863020' doesn't exist' on query 'DELETE FROM `WEB_BZ`.`OL_Kat_1091863$
040807 12:07:41  Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE$
ERROR: 1050  Table 'OL_Kat_1091863020' already exists
040807 12:09:13  Slave: Error 'Table 'OL_Kat_1091863020' already exists' on query 'CREATE TABLE OL_Kat_1091863020 TYPE=HEAP
                SELECT AID FROM ADRESSEN_ADRESSKATEGORIEN INNER JOIN ADRESSKATEGORIEN ON ADRESSEN_ADRESSKATEGORIEN.KID=ADRESS$
                WHERE (ADRESSEN_ADRESSKATEGORIEN.KID=24 OR ADRESSEN_ADRESSKATEGORIEN.KID=75) AND KStatus>=2
                GROUP BY AID
                HAVING COUNT(*)=2'. Default database: 'WEB_BZ', Error_code: 1050
040807 12:09:13  Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE$
ERROR: 1146  Table 'WEB_BZ.OL_Kat_1091864175' doesn't exist
040807 12:09:34  Slave: Error 'Table 'WEB_BZ.OL_Kat_1091864175' doesn't exist' on query 'DELETE FROM `WEB_BZ`.`OL_Kat_1091864$
040807 12:09:34  Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE$
ERROR: 1050  Table 'OL_Kat_1091864175' already exists
040807 12:10:04  Slave: Error 'Table 'OL_Kat_1091864175' already exists' on query 'CREATE TABLE OL_Kat_1091864175 TYPE=HEAP
                SELECT AID FROM ADRESSEN_ADRESSKATEGORIEN INNER JOIN ADRESSKATEGORIEN ON ADRESSEN_ADRESSKATEGORIEN.KID=ADRESS$
                WHERE (ADRESSEN_ADRESSKATEGORIEN.KID=23 OR ADRESSEN_ADRESSKATEGORIEN.KID=132) AND KStatus>=2
                GROUP BY AID
                HAVING COUNT(*)=2'. Default database: 'WEB_BZ', Error_code: 1050


the SHOW SLAVE STATUS says:
db3.edev.at repl 3306 60 alhambra-bin.001 43146529 bohnanza-relay-bin.001 28632351 alhambra-bin.001 Yes No     1146 Error 'Table 'WEB_BZ.OL_Kat_1091864184' doesn't ex... 0 42964863 28814017 

System is: 
Master and Slave are both with OpenBSD 3.5 Current
Master is P4 / 2.4 with 1GB RAM, Slave is Duron 1000 with 1GB

mysql 4.0.18 on OpenBSD3.5 build from the ports-tree.

OpenBSD bohnanza.edev.at 3.5 GENERIC#0 i386


Other information is attached

is it a bug or can you give us a hint ?

christian groesswang



------------------------------------------------------
P.I.C.S. GmbH.
EDV & Unternehmensberatung
Landsturmstrasse 18
A-5020 Salzburg
Tel: 0662 / 455 467
Fax: 0662 / 455 468
Email: [email protected]
------------------------------------------------------

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]