Sorry for my mails, but i'm blocked with my work from several days. Last info about my problem.
The webserver.bin is not updated after insert operation in db. I've found a Delayed_insert... If i do on the master >SHOW PROCESSLIST; +----+----------+-----------------------------+------+----------------+- -----+---------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+----------+-----------------------------+------+----------------+- -----+---------------------------------------------+------------------+ | 2 | baldomax | localhost | NULL | Sleep | 2 | | NULL | | 6 | ODBC | localhost | zope | Query | 0 | N | show processlist | | 17 | ODBC | localhost | zope | Sleep | 720 | | NULL | | 18 | ODBC | localhost | zope | Sleep | 28 | | NULL | | 19 | ODBC | localhost | zope | Sleep | 24 | | NULL | | 24 | repl | ppp-XXXXX.inwind.it | NULL | Binlog Dump | 257 | Slave connection: waiting for binlog update | NULL | | 25 | DELAYED | localhost | zope | Delayed_insert | 129 | Waiting on cond | log | +----+----------+-----------------------------+------+----------------+- -----+---------------------------------------------+------------------+ 7 rows in set (0.00 sec) Massi -----Messaggio originale----- Da: trashMan [mailto:[EMAIL PROTECTED] Inviato: marted́ 1 aprile 2003 11.31 A: [EMAIL PROTECTED] Oggetto: R: R: Replication don't work. I've found the error, but now i must solve it! The master, when i execute an insert operation in db, don't update the 'webserver-bin.010'. If i do >SHOW MASTER STATUS; The pos is the same as before and webserver-bin.010 is not updated. I've tried to do the operation >SET SQL_LOG_BIN = 1 But the result is the same. What can i do now?? Massi -----Original Message----- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 3:19 PM To: 'Scott Helms'; [EMAIL PROTECTED] Subject: R: R: Replication don't work. Sigh..... Master.err MySql: Pronto per le connessioni (ready for connection) Slave.err 030401 1:04:17 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webserver-bin.010' at position 73 Master.info of slave webserver-bin.010 73 xx.xx.xx.x replica pwdreplica 3306 60 My.ini of master [mysqld] skip-innodb basedir=C:/mysql datadir=C:/mysql/data log-bin server-id=1 language=C:/mysql/share/italian binlog-do-db=Zope My.ini of slave [mysqld] skip-innodb port=3306 language=c:/programmi/mysql/share/italian server-id=12 master-host=xx.xx.x.xx master-user=replica master-password=pwdreplica master-port=3306 basedir=C:/Programmi/mysql/ datadir=C:/Programmi/mysql/data/ replicate-do-db=Zope -----Messaggio originale----- Da: Scott Helms [mailto:[EMAIL PROTECTED] Inviato: marted́ 1 aprile 2003 0.46 A: trashMan Cc: 'Jennifer Goodie'; mysql Oggetto: Re: R: Replication don't work. Massi, You will get much better results if you provide the following: Copies of: my.cnf file from both master and slave (look in $MYSQL/data or /etc) $HOSTNAME.err logs from master and slave master.info file from slave (look in $MYSQL/data directory) and check that one does not exist on the master, this gave me fits for several hours one day while moving a slave to being the master when the then current master died of a bad hard drive. No guarantees, but this will greatly improve your chances of an intelligent answer. ;p Scott Helms On Mon, 2003-03-31 at 17:04, trashMan wrote: > The error.log on the master dont' report anything... > > MySql: ready for connections > > Other info > > >Show master status; > > ******************************************* > Header answer note > ******************************************* > File webserver-bin.008 > Position 73 > > > > >SHOW PROCESSLIST > > *************** > Header answer > *************** > User userreplica > Host XXXXX > Db NULL > Command Binlog dump > Time XXXX (the time passed from the mysql > start) > Query connect > Time XXXX (the time passed from the mysql > State slave connection: waiting for binlog update > > > :-/ > > Massi > > > > > > -----Messaggio originale----- > Da: Jennifer Goodie [mailto:[EMAIL PROTECTED] > Inviato: luned́ 31 marzo 2003 23.41 > A: trashMan; [EMAIL PROTECTED] > Oggetto: RE: Replication don't work. > > > It the master actually writting to the binlog? What does the master > say when you run SHOW MASTER STATUS? Is the size of the binlog > growing? > > -----Original Message----- > From: trashMan [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 1:29 PM > To: [EMAIL PROTECTED] > Subject: Replication don't work. > > > There are two weeks i try it...but...the replication don't start!! > > I've follow the istruction > http://www.mysql.com/doc/en/Replication_HOWTO.html without success. > > In the slave i have: > > >Show slave status; > > ******************************************* > Header answer note > ******************************************* > Slave_Running YES > Last_Error none > > > >SHOW PROCESSLIST > > *************** > Header answer > *************** > User system user > Host none > Db NULL > Query connect > Time XXXX (the time passed from the mysql > start) > State Reading master update > > > I think the database is in updating...but the table are the same....i > don't have new data!! What can i do??? :-( > > Help! > > Massi > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
