Hello.
>My conclusion so far: The data is in the relay-log on C but it's not put >into the database for some reason. I simply have no clue what reason it >could be. In fact i'm a little bit confused right now.... so any help is >very welcome. In you original message you told you were working with MySQL 4.0. It is an old release. Check if the problem exists on the latest release. "Frank Fischer" <[EMAIL PROTECTED]> wrote: >Hi all > >I followed Gleb's advice (see below), removed all filters, restarted the db >servers -> same behaviour. Still replications work if there are changes made >on A. Then these changes are replicated A->B->C. When making changes on B, i >can see them in the bin-log on B and the relay-log of C but they are not >written to the db on C. Since there are no filters on C (anymore) and the >replication with changes on A works, i just don't understand where the >problem could be. There also are no error messages in the err log. >Everything seems else to work fine. Is there any way to get a more detailed >logging of what is happening during the replication (kind of debug >information)? > >To make sure that the replicated SQL queries are ok i put them out of the >relay bin of C and issued them to the db on C using MySQLQueryBrowser. That >worked fine. > >Another funny thing is, when i issue "LOAD DATA FROM MASTER" on C it loads >all data from master B inclusive all changes that have been made on B which >were not "replicated" before. > >My conclusion so far: The data is in the relay-log on C but it's not put >into the database for some reason. I simply have no clue what reason it >could be. In fact i'm a little bit confused right now.... so any help is >very welcome. > >Greetings >Frank -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
