Hello.
MySQL 4.1.x has a lot of improvements in the framework of warnings, which MySQL 4.0.x might not have. So loading the data on the master (4.0.20) hasn't produced the warnings. You may want to get the files which was loaded to be able to reproduce the situation later and get the warnings using SHOW WARNINGS statement. Use mysqlbinlog utility. See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html http://dev.mysql.com/doc/mysql/en/slave-logs.html http://dev.mysql.com/doc/mysql/en/Binary_log.html http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html Francesco Dalla Ca' <[EMAIL PROTECTED]> wrote: > Master: 4.0.20-max > Slave: 4.1.14-max > Replication seems goes well. > > This morning i see the follow messages on error log: > > 050831 5:30:04 [Warning] Slave: load data infile on table 'Stage' at > log position 30438086 in log 'tana-bin.001' produced 5003 warning(s). > Default database: 'TSM' > 050831 6:00:10 [Warning] Slave: load data infile on table 'Day_Tape' at > log position 31499001 in log 'tana-bin.001' produced 10 warning(s). > Default database: 'TSM' > 050831 6:00:16 [Warning] Slave: load data infile on table > 'Day_Reclamation' at log position 31854414 in log 'tana-bin.001' > produced 4 warning(s). Default database: 'TSM' > 050831 6:00:16 [Warning] Slave: load data infile on table 'DB_Day' at > log position 32025985 in log 'tana-bin.001' produced 7 warning(s). > Default database: 'TSM' > 050831 6:31:58 [Warning] Slave: load data infile on table > 'Day_Occupancy' at log position 32080517 in log 'tana-bin.001' produced > 6 warning(s). Default database: 'TSM' > > What's happened? How i can see the "produced warning" on the slave? > > Thanks in advance, > Francesco Dalla Ca'. > -- 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]
