Re: MySQL Replication Error
- Original Message - > From: "Néstor" > > I spoke to soon!!! > Here is the error about 1.5 hours after replication has started. > 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' > for Yes, that's what you get for running SQL_SLAVE_SKIP_COUNTER without knowing what the problem is. Your database is now nicely out of sync, and hopefully it's just the watchdog. The *proper* way of resolving this is to resync the entire database. You *may* get away with deleting watchdog entry 3468897 and restarting replication as someone has suggested, but I suspect you'll find another half-million of them. Look at the Percona Toolkit, specifically mk-table-checksum and mk-table-sync, understand how they work and then apply them. If there's too many differences by now, your only recourse will be to completely reprovision the slave, though. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Replication Error
Yes that's correct. it needs to be added on the slave side under [mysqld] section usually close to the place where you define your replication settings (for convenience only). The reason why server failed to start difficult to guess without error log. this will prevent all tables under parallax db with watchdog bit in the name to be replicated. another option *|replicate-ignore-table=/|parallax.watchdog|/| <http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate-ignore-table>* and restart server On 07/12/12 00:56, Néstor wrote: I added those line to the slave's my.cnf and mysql would not start replicate-wild-ignore-table=parallax%.watchdog% replicate-wild-ignore-table=parallax%.cache% Nestor On Thu, Dec 6, 2012 at 4:39 PM, Néstor wrote: HI Igor, Are you saying to add these lines to the my.cnf file: replicate-wild-ignore-table=dbname%.watchdog% replicate-wild-ignore-table=dbname%.cache% Correct? Thanks, Nestor :-) On Thu, Dec 6, 2012 at 3:07 PM, Igor Shevtsov wrote: In regards to the second part of your email. You don't have errors in your mysql.err log. Those are notes saying that you started IO and SQL replication threads after you skipped an replication error and run start slave command. I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command either as it makes your tables inconsistent. I'd rather deleted offending row on the slave and started replication. In this case insert would've succeed and tables would become consistent again. On 06/12/12 21:59, Néstor wrote: I spoke to soon!!! Here is the error about 1.5 hours after replication has started. 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'images/internet_explorer/** borderTopLeft.png', 'N;', 4, '',' http://www.sdcwa.org/es/**images/internet_explorer/**borderTopLeft.png<http://www.sdcwa.org/es/images/internet_explorer/borderTopLeft.png>', '', '10.20.141.24', 1354754352)', Error_code: 1062 121205 16:39:51 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000289' position 86451409 --**-- Sorry for the long message, below are the steps use to create my replication. When I created the replication, I followed the steps here : http://crazytoon.com/2008/01/**29/mysql-how-do-you-set-up-** masterslave-replication-in-**mysql-centos-rhel-fedora/<http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/> I am on a red hat server. --- I set my firewall to accept info from server1 on server2 SERVER1: tcp0 0 wahoo.sdcwa.org:mysql wahooesc.sdcwa.org:52131 ESTABLISHED 30145/mysqld SERVER2: tcp0 0 wahooesc.sdcwa.org:52131www.sdcwa.org:mysql ESTABLISHED 30875/mysqld - I have try using the SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; I have also done these steps where in SERVER1 FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; +--+--**+--+--**+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +--+--**+--+--**+ | mysql-bin.000289 | 42394063 | | | +--+--**+--+--**+ Then Dump SERVER1 database then you unlock SERVER1 database and copy it to SERVER2 then FLUSH TABLES WITH READ LOCK; I proceed to STOP SLAVE then add the database to SERVER2 then CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.**000289', MASTER_LOG_POS=42394063; to synch with the SERVER1 Then I start SERVER2 and the output of slave status is: mysql> SHOW SLAVE STATUS\G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: 10.168.1.21 Master_User: sdcwa_slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000289 Read_Master_Log_Pos: 55848766 Relay_Log_File: mysql-relay-bin.02 Relay_Log_Pos: 13454938 Relay_Master_Log_File: mysql-bin.000289 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: La
Re: MySQL Replication Error
I added those line to the slave's my.cnf and mysql would not start replicate-wild-ignore-table=parallax%.watchdog% replicate-wild-ignore-table=parallax%.cache% Nestor On Thu, Dec 6, 2012 at 4:39 PM, Néstor wrote: > HI Igor, > > Are you saying to add these lines to the my.cnf file: > replicate-wild-ignore-table=dbname%.watchdog% > replicate-wild-ignore-table=dbname%.cache% > > Correct? > > Thanks, > > Nestor :-) > > > > On Thu, Dec 6, 2012 at 3:07 PM, Igor Shevtsov wrote: > >> In regards to the second part of your email. >> You don't have errors in your mysql.err log. Those are notes saying that >> you started IO and SQL replication threads after you skipped an replication >> error and run start slave command. >> >> I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command either as >> it makes your tables inconsistent. >> I'd rather deleted offending row on the slave and started replication. In >> this case insert would've succeed and tables would become consistent again. >> >> >> >> >> >> >> On 06/12/12 21:59, Néstor wrote: >> >>> I spoke to soon!!! >>> Here is the error about 1.5 hours after replication has started. >>> 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for >>> key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO >>> watchdog >>> (uid, type, message, variables, severity, link, location, referer, >>> hostname, timestamp) >>> VALUES >>> (0, 'page not found', 'images/internet_explorer/** >>> borderTopLeft.png', >>> 'N;', 4, '',' >>> http://www.sdcwa.org/es/**images/internet_explorer/**borderTopLeft.png<http://www.sdcwa.org/es/images/internet_explorer/borderTopLeft.png>', >>> '', >>> '10.20.141.24', 1354754352)', Error_code: 1062 >>> 121205 16:39:51 [ERROR] Error running query, slave SQL thread aborted. >>> Fix >>> the problem, and restart the slave SQL thread with "SLAVE START". We >>> stopped at log 'mysql-bin.000289' position 86451409 >>> >>> --**-- >>> Sorry for the long message, below are the steps use to create my >>> replication. >>> >>> >>> When I created the replication, I followed the steps here : >>> http://crazytoon.com/2008/01/**29/mysql-how-do-you-set-up-** >>> masterslave-replication-in-**mysql-centos-rhel-fedora/<http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/> >>> I am on a red hat server. >>> --- >>> I set my firewall to accept info from server1 on server2 >>> SERVER1: >>> tcp0 0 wahoo.sdcwa.org:mysql wahooesc.sdcwa.org:52131 >>> ESTABLISHED 30145/mysqld >>> SERVER2: >>> tcp0 0 wahooesc.sdcwa.org:52131www.sdcwa.org:mysql >>> ESTABLISHED 30875/mysqld >>> - >>> >>> I have try using the SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; >>> >>> I have also done these steps where in SERVER1 >>> FLUSH TABLES WITH READ LOCK; >>> SHOW MASTER STATUS; >>> +--+--**+--+--**+ >>> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | >>> +--+--**+--+--**+ >>> | mysql-bin.000289 | 42394063 | | | >>> +--+--**+--+--**+ >>> >>> Then Dump SERVER1 database then you unlock SERVER1 database >>> and copy it to SERVER2 then FLUSH TABLES WITH READ LOCK; >>> >>> I proceed to STOP SLAVE then add the database to SERVER2 then >>> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.**000289', >>> MASTER_LOG_POS=42394063; to synch with the SERVER1 >>> Then I start SERVER2 and the output of slave status is: >>> >>> mysql> SHOW SLAVE STATUS\G >>> *** 1. row *** >>> Slave_IO_State: Waiting for master to send event >>> Master_Host: 10.168.1.21 >>> Master_User: sdcwa_slave >>> Master_Port: 3306 >>>Connect_Retry: 60 >>> Master_Log_File: mysql-bin.000
Re: MySQL Replication Error
In regards to the second part of your email. You don't have errors in your mysql.err log. Those are notes saying that you started IO and SQL replication threads after you skipped an replication error and run start slave command. I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command either as it makes your tables inconsistent. I'd rather deleted offending row on the slave and started replication. In this case insert would've succeed and tables would become consistent again. On 06/12/12 21:59, Néstor wrote: I spoke to soon!!! Here is the error about 1.5 hours after replication has started. 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'images/internet_explorer/borderTopLeft.png', 'N;', 4, '',' http://www.sdcwa.org/es/images/internet_explorer/borderTopLeft.png', '', '10.20.141.24', 1354754352)', Error_code: 1062 121205 16:39:51 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000289' position 86451409 Sorry for the long message, below are the steps use to create my replication. When I created the replication, I followed the steps here : http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ I am on a red hat server. --- I set my firewall to accept info from server1 on server2 SERVER1: tcp0 0 wahoo.sdcwa.org:mysql wahooesc.sdcwa.org:52131 ESTABLISHED 30145/mysqld SERVER2: tcp0 0 wahooesc.sdcwa.org:52131www.sdcwa.org:mysql ESTABLISHED 30875/mysqld - I have try using the SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; I have also done these steps where in SERVER1 FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; +--+--+--+--+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +--+--+--+--+ | mysql-bin.000289 | 42394063 | | | +--+--+--+--+ Then Dump SERVER1 database then you unlock SERVER1 database and copy it to SERVER2 then FLUSH TABLES WITH READ LOCK; I proceed to STOP SLAVE then add the database to SERVER2 then CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000289', MASTER_LOG_POS=42394063; to synch with the SERVER1 Then I start SERVER2 and the output of slave status is: mysql> SHOW SLAVE STATUS\G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: 10.168.1.21 Master_User: sdcwa_slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000289 Read_Master_Log_Pos: 55848766 Relay_Log_File: mysql-relay-bin.02 Relay_Log_Pos: 13454938 Relay_Master_Log_File: mysql-bin.000289 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 55848766 Relay_Log_Space: 13454938 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 1 row in set (0.00 sec) --- I get the folllowing on my mysql.err: 121205 15:09:56 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000289' at position 42394063, relay log '/var/log/mysql/mysql-relay-bin.01' position: 4 121205 15:09:56 [Note] Slave I/O thread: connected to master ' sdcwa_slave@192.168.1.21:3306', replication started in log 'mysql-bin.000289' at position 42394063 Everything is GOOD, for a little while and then I get an error on mysql.err: - Now if I do the SKIP FLAG many times, I will error after error... I do not see how replication works so well for others if I am using the steps in the link on top of this message. THANKS!!! On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote: 2012/11/30 Néstor
Re: MySQL Replication Error
I spoke to soon!!! Here is the error about 1.5 hours after replication has started. 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'images/internet_explorer/borderTopLeft.png', 'N;', 4, '', ' http://www.sdcwa.org/es/images/internet_explorer/borderTopLeft.png', '', '10.20.141.24', 1354754352)', Error_code: 1062 121205 16:39:51 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000289' position 86451409 Sorry for the long message, below are the steps use to create my replication. When I created the replication, I followed the steps here : http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ I am on a red hat server. --- I set my firewall to accept info from server1 on server2 SERVER1: tcp0 0 wahoo.sdcwa.org:mysql wahooesc.sdcwa.org:52131 ESTABLISHED 30145/mysqld SERVER2: tcp0 0 wahooesc.sdcwa.org:52131www.sdcwa.org:mysql ESTABLISHED 30875/mysqld - I have try using the SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; I have also done these steps where in SERVER1 FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; +--+--+--+--+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +--+--+--+--+ | mysql-bin.000289 | 42394063 | | | +--+--+--+--+ Then Dump SERVER1 database then you unlock SERVER1 database and copy it to SERVER2 then FLUSH TABLES WITH READ LOCK; I proceed to STOP SLAVE then add the database to SERVER2 then CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000289', MASTER_LOG_POS=42394063; to synch with the SERVER1 Then I start SERVER2 and the output of slave status is: mysql> SHOW SLAVE STATUS\G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: 10.168.1.21 Master_User: sdcwa_slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000289 Read_Master_Log_Pos: 55848766 Relay_Log_File: mysql-relay-bin.02 Relay_Log_Pos: 13454938 Relay_Master_Log_File: mysql-bin.000289 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 55848766 Relay_Log_Space: 13454938 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 1 row in set (0.00 sec) --- I get the folllowing on my mysql.err: 121205 15:09:56 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000289' at position 42394063, relay log '/var/log/mysql/mysql-relay-bin.01' position: 4 121205 15:09:56 [Note] Slave I/O thread: connected to master ' sdcwa_slave@192.168.1.21:3306', replication started in log 'mysql-bin.000289' at position 42394063 Everything is GOOD, for a little while and then I get an error on mysql.err: - Now if I do the SKIP FLAG many times, I will error after error... I do not see how replication works so well for others if I am using the steps in the link on top of this message. THANKS!!! On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote: > > > 2012/11/30 Néstor > >> I am trying to set up mysql replication on 2 systems but Once I get it >> going, I get the following an error 1062, >> > > > >> >> I have re-installed the database on the slave also to see if this fixes >> the >> problem >> but after a few minutes I get the same error. I have repeated the >> replication from the >> beginning but I get the same problem after a while. >> >> Does anyone know a way to fix this? >> >> > Hello, > > How did you build the slave from the master? How did you decide in which > position the slave should start replicating from? > You might want to try pt-table-checksum ( > http://www.percona.com/doc/percona-toolkit/2.1/pt-table-checksum.html) to > see what else do you have broken. > > Manuel. > > > -- > Manuel Aróstegui > Systems Team
Re: MySQL Replication Error
Hi Néstor, You might want to put those lines into your my.cnf under replication section and restart the slave: replicate-wild-ignore-table=dbname%.watchdog% and may be this as well: replicate-wild-ignore-table=dbname%.cache% Do you really need to replicate cache and session tables? Cheers, Igor On 06/12/12 21:59, Néstor wrote: I spoke to soon!!! Here is the error about 1.5 hours after replication has started. 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', 'images/internet_explorer/borderTopLeft.png', 'N;', 4, '',' http://www.sdcwa.org/es/images/internet_explorer/borderTopLeft.png', '', '10.20.141.24', 1354754352)', Error_code: 1062 121205 16:39:51 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000289' position 86451409 Sorry for the long message, below are the steps use to create my replication. When I created the replication, I followed the steps here : http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ I am on a red hat server. --- I set my firewall to accept info from server1 on server2 SERVER1: tcp0 0 wahoo.sdcwa.org:mysql wahooesc.sdcwa.org:52131 ESTABLISHED 30145/mysqld SERVER2: tcp0 0 wahooesc.sdcwa.org:52131www.sdcwa.org:mysql ESTABLISHED 30875/mysqld - I have try using the SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; I have also done these steps where in SERVER1 FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; +--+--+--+--+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +--+--+--+--+ | mysql-bin.000289 | 42394063 | | | +--+--+--+--+ Then Dump SERVER1 database then you unlock SERVER1 database and copy it to SERVER2 then FLUSH TABLES WITH READ LOCK; I proceed to STOP SLAVE then add the database to SERVER2 then CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000289', MASTER_LOG_POS=42394063; to synch with the SERVER1 Then I start SERVER2 and the output of slave status is: mysql> SHOW SLAVE STATUS\G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: 10.168.1.21 Master_User: sdcwa_slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000289 Read_Master_Log_Pos: 55848766 Relay_Log_File: mysql-relay-bin.02 Relay_Log_Pos: 13454938 Relay_Master_Log_File: mysql-bin.000289 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 55848766 Relay_Log_Space: 13454938 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 1 row in set (0.00 sec) --- I get the folllowing on my mysql.err: 121205 15:09:56 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000289' at position 42394063, relay log '/var/log/mysql/mysql-relay-bin.01' position: 4 121205 15:09:56 [Note] Slave I/O thread: connected to master ' sdcwa_slave@192.168.1.21:3306', replication started in log 'mysql-bin.000289' at position 42394063 Everything is GOOD, for a little while and then I get an error on mysql.err: - Now if I do the SKIP FLAG many times, I will error after error... I do not see how replication works so well for others if I am using the steps in the link on top of this message. THANKS!!! On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote: 2012/11/30 Néstor I am trying to set up mysql replication on 2 systems but Once I get it going, I get the following an error 1062, I have re-installed the database on the slave also to see if this fixes the problem but after a few minutes I get the same error. I have repeated the replication from the beginning but I get the same problem after a while. Does anyone know a way to fix this? Hello, How did y
Re: MySQL Replication Error
I was about to reply with a long message of all the steps I followed to create replication but I did my steps about an hour ago and I have not seen the replication fail so far. BTW, I created my replication following the info on this web page: http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ THANKS!!! Nestor On Wed, Dec 5, 2012 at 3:35 AM, Johan De Meersman wrote: > - Original Message - > > From: "divesh kamra" > > > > slave-skip-errors=1062 ---> in my.cnf and restart mysql > > Really? Just like that? Without even knowing what it does or what the > problem is? > > If you have replication errors, this kind of stuff is only going to break > it further. "It exists" is not an indication of fitness for any specific > use, and that kind of option is really only for use in very very specific > cases where you KNOW what's wrong and KNOW that it's not harmful in your > highly specific situation. > > > -- > Linux Bier Wanderung 2012, now also available in Belgium! > August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > >
Re: MySQL Replication Error
2012/11/30 Néstor > I am trying to set up mysql replication on 2 systems but Once I get it > going, I get the following an error 1062, > > > I have re-installed the database on the slave also to see if this fixes the > problem > but after a few minutes I get the same error. I have repeated the > replication from the > beginning but I get the same problem after a while. > > Does anyone know a way to fix this? > > Hello, How did you build the slave from the master? How did you decide in which position the slave should start replicating from? You might want to try pt-table-checksum ( http://www.percona.com/doc/percona-toolkit/2.1/pt-table-checksum.html) to see what else do you have broken. Manuel. -- Manuel Aróstegui Systems Team tuenti.com
Re: MySQL Replication Error
- Original Message - > From: "divesh kamra" > > slave-skip-errors=1062 ---> in my.cnf and restart mysql Really? Just like that? Without even knowing what it does or what the problem is? If you have replication errors, this kind of stuff is only going to break it further. "It exists" is not an indication of fitness for any specific use, and that kind of option is really only for use in very very specific cases where you KNOW what's wrong and KNOW that it's not harmful in your highly specific situation. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Replication Error
Hi first check this thought application end or There is another way slave-skip-errors=1062 ---> in my.cnf and restart mysql On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald wrote: > > > Am 30.11.2012 23:52, schrieb Rick James: > > Possible causes: > > * Someone is writing to the Slave > > that is why the option "read-only" exists for my.cnf > > > * The Slave was not in synch with the Master. > > * Schemas are different between Master and Slave > > should not happen if the slave is properly cloned > as a binary copy of the stopped master and secured > with "read-only" > > > > > > >
Re: MySQL Replication Error
Am 30.11.2012 23:52, schrieb Rick James: > Possible causes: > * Someone is writing to the Slave that is why the option "read-only" exists for my.cnf > * The Slave was not in synch with the Master. > * Schemas are different between Master and Slave should not happen if the slave is properly cloned as a binary copy of the stopped master and secured with "read-only" signature.asc Description: OpenPGP digital signature
RE: MySQL Replication Error
Possible causes: * Someone is writing to the Slave. * The Slave was not in synch with the Master. * Schemas are different between Master and Slave. * Someone is changing the POS for replication. After you have eliminated those possibilities, provide SHOW SLAVE STATUS \G SHOW MASTER STATUS; SHOW CREATE TABLE (for a table that is in trouble) > -Original Message- > From: Néstor [mailto:rot...@gmail.com] > Sent: Friday, November 30, 2012 1:24 PM > To: mysql@lists.mysql.com > Subject: MySQL Replication Error > > I am trying to set up mysql replication on 2 systems but Once I get it > going, I get the following an error 1062, which is a duplicate entry > and my 'slave status' shows: > Slave_IO_Running: Yes > Slave_SQL_Running: No > > And this is the error on my mysql.err file: > 121130 12:41:53 [Note] Slave I/O thread killed while reading event > 121130 12:41:53 [Note] Slave I/O thread exiting, read up to log 'mysql- > bin.000266', position 76841310 > 121130 12:41:57 [Note] Slave SQL thread initialized, starting > replication in log 'mysql-bin.000265' at position 99071761, relay log > '/var/log/mysql/mysql-relay-bin.06' position: 98589371 > 121130 12:41:57 [Note] Slave I/O thread: connected to master ' > sdcwa_slave@10.168.1.21:3306', replication started in log 'mysql- > bin.000266' at position 76841310 > 121130 12:41:57 [ERROR] Slave: Error 'Duplicate entry 'links:primary- > links:tree-data:7b7216a15969aa93e5dfb9aaa24bfc32' for key 1' > on query. Default database: 'parallax'. Query: 'INSERT INTO cache_menu > (cid, data, created, expire, headers, serialized) VALUES > ('links:primary-links:tree-data:7b7216a15969aa93e5dfb9aaa24bfc32', > 'a:2:{s:4:\"tree\";a:19:{i:310;a:2:{s:4:\"link\";a:38:{s:14:\"load_func > tions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\" > ;s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_a > rguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callbac > k\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1 > ;}\";s:5:\"title\";s:0:\"\";s:14:\"title_callback\";s:15:\"node_page_ti > tle\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1 > :\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary- > links\";s:4:\"mlid\";s:3:\"310\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path > \";s:7:\"node/14\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_titl > e\";s:11:\"Wh > 121130 12:41:57 [ERROR] Error running query, slave SQL thread aborted. > Fix the problem, and restart the slave SQL thread with "SLAVE START". > We stopped at log 'mysql-bin.000265' position 99451408 > > I done searches on google and I look at several sites and basically > they say to do the following: > mysql> stop slave; > mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave; show slave > mysql> status\G > > But after doing this a couple of minutes later I get the same situation > > I have re-installed the database on the slave also to see if this fixes > the problem but after a few minutes I get the same error. I have > repeated the replication from the beginning but I get the same problem > after a while. > > Does anyone know a way to fix this? > > Thanks, > > Néstor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL Replication Error
I am trying to set up mysql replication on 2 systems but Once I get it going, I get the following an error 1062, which is a duplicate entry and my 'slave status' shows: Slave_IO_Running: Yes Slave_SQL_Running: No And this is the error on my mysql.err file: 121130 12:41:53 [Note] Slave I/O thread killed while reading event 121130 12:41:53 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000266', position 76841310 121130 12:41:57 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000265' at position 99071761, relay log '/var/log/mysql/mysql-relay-bin.06' position: 98589371 121130 12:41:57 [Note] Slave I/O thread: connected to master ' sdcwa_slave@10.168.1.21:3306', replication started in log 'mysql-bin.000266' at position 76841310 121130 12:41:57 [ERROR] Slave: Error 'Duplicate entry 'links:primary-links:tree-data:7b7216a15969aa93e5dfb9aaa24bfc32' for key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO cache_menu (cid, data, created, expire, headers, serialized) VALUES ('links:primary-links:tree-data:7b7216a15969aa93e5dfb9aaa24bfc32', 'a:2:{s:4:\"tree\";a:19:{i:310;a:2:{s:4:\"link\";a:38:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_arguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:0:\"\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"310\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:7:\"node/14\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:11:\"Wh 121130 12:41:57 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000265' position 99451408 I done searches on google and I look at several sites and basically they say to do the following: mysql> stop slave; mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; mysql> start slave; mysql> show slave status\G But after doing this a couple of minutes later I get the same situation I have re-installed the database on the slave also to see if this fixes the problem but after a few minutes I get the same error. I have repeated the replication from the beginning but I get the same problem after a while. Does anyone know a way to fix this? Thanks, Néstor
Re: Replication Error on Slave
All, Thanks for your replies and as per the advise I switched to row-based replication but replication ended with below error. *Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default database: 'b. Query: 'drop table sdefrent'* above error is due to non existence of database and table. However bit confused on the error I got, if its row based replication why its taking as statement. Please help me here. Thank you -Naga On Thu, Jan 27, 2011 at 3:23 PM, Johan De Meersman wrote: > On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote: > >> **On Slave Server I replicate database *A alone* and my replication not >> working due to data fetching happen on B database. >> > > Well, yes. Statement-based replication does what it says on the box: it > executes the exact same statement on the slave. If database B is not there, > then insert into A select from B will not work. > > You may switch to row-based replication (which of course has it's own > caveats, see the online manuals); or you can simply choose to also replicate > database B. > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel >
Re: Replication Error on Slave
> **On master server I have two databases *A and B*. App team use database B > temporarily for there application to compute calculation and insert the > values on A database. For certain statements you could start with "SET SQL_BIN_LOG=0" so it doesn't log that statement, and it won't be replicated. -Kristian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Replication Error on Slave
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote: > **On Slave Server I replicate database *A alone* and my replication not > working due to data fetching happen on B database. > Well, yes. Statement-based replication does what it says on the box: it executes the exact same statement on the slave. If database B is not there, then insert into A select from B will not work. You may switch to row-based replication (which of course has it's own caveats, see the online manuals); or you can simply choose to also replicate database B. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Replication Error on Slave
I have setup mysql replication with below scenario **On master server I have two databases *A and B*. App team use database B temporarily for there application to compute calculation and insert the values on A database. **On Slave Server I replicate database *A alone* and my replication not working due to data fetching happen on B database. Kindly help me out to resolve this issue. -Naga
Re: Replication error 1236
See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of a User HI, first check the error log and find the position where the replication was terminated.Now run the mysqlbinlog utility on the binarylogs file. Now when you run the query will get the text format as a result.serch for the position and see as to which query was ran on that position.check if that qurey ran on the slave before bcoz we dont need a duplication of thr query.If not plz run the query on the slave.Stop/start the slave.You sholud get the Slave back to SYNC. Anup In Response To: Hi All, Once a week or so I get the following error: 080801 8:18:35 [ERROR] Error reading packet from server: error reading log entry ( server_errno=1236) 080801 8:18:35 [ERROR] Got fatal error 1236: 'error reading log entry' from master when reading data from binary log Stopping the slave and restart at its current postion does not help here (the same error happens again with next entry in bin log), the only way I know how to fix this is to flush the logs and restart the slave with the new log file (changes in between are manually synched). I would appreciate any pointers about where to start looking for the problem. E.g. is the bin log file corrupt? And if so why does this happen so often Thanks Olaf - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication Error
you need to be sure you have everything the server needs to be a slave defined in your my.cnf file, especially the relay logs and that the replication slave user is created properly. On Tue, Aug 19, 2008 at 2:37 AM, Krishna Chandra Prajapati < [EMAIL PROTECTED]> wrote: > Hi, > > I am setting up replication and got the error below > > mysql> change master to master_host='172.20.1.189', master_user='repl', > master_password='pass'; > Query OK, 0 rows affected (0.01 sec) > > mysql> start slave; > ERROR 1200 (HY000): The server is not configured as slave; fix in config > file or with CHANGE MASTER TO > mysql> exit > Bye > [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log > 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown > > 080819 12:53:31 InnoDB: Starting shutdown... > 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 > 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete > > 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 > 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. > Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 > Source distribution > 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were > used; so replication may break when this MySQL server acts as a slave and > has his hostname changed!! Please use > '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. > > > -- > Krishna Chandra Prajapati > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: Replication Error
u need to set those parameters On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Server_id is set but not relay_log and relay_index. > > On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > >> is the server_id and relay_log and relay_index parameter set in my.cnf >> >> >> On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >>> >>> Hi, >>> >>> I am setting up replication and got the error below >>> >>> mysql> change master to master_host='172.20.1.189', master_user='repl', >>> master_password='pass'; >>> Query OK, 0 rows affected (0.01 sec) >>> >>> mysql> start slave; >>> ERROR 1200 (HY000): The server is not configured as slave; fix in config >>> file or with CHANGE MASTER TO >>> mysql> exit >>> Bye >>> [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log >>> 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown >>> >>> 080819 12:53:31 InnoDB: Starting shutdown... >>> 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 >>> 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete >>> >>> 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 >>> 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. >>> Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 >>> Source distribution >>> 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were >>> used; so replication may break when this MySQL server acts as a slave and >>> has his hostname changed!! Please use >>> '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. >>> >>> >>> -- >>> Krishna Chandra Prajapati >>> >> >> >> > > > > -- > Krishna Chandra Prajapati > > >
Re: Replication Error
Server_id is set but not relay_log and relay_index. On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > is the server_id and relay_log and relay_index parameter set in my.cnf > > > On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I am setting up replication and got the error below >> >> mysql> change master to master_host='172.20.1.189', master_user='repl', >> master_password='pass'; >> Query OK, 0 rows affected (0.01 sec) >> >> mysql> start slave; >> ERROR 1200 (HY000): The server is not configured as slave; fix in config >> file or with CHANGE MASTER TO >> mysql> exit >> Bye >> [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log >> 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown >> >> 080819 12:53:31 InnoDB: Starting shutdown... >> 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 >> 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete >> >> 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 >> 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. >> Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 >> Source distribution >> 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were >> used; so replication may break when this MySQL server acts as a slave and >> has his hostname changed!! Please use >> '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. >> >> >> -- >> Krishna Chandra Prajapati >> > > -- Krishna Chandra Prajapati
Re: Replication Error
is the server_id and relay_log and relay_index parameter set in my.cnf On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi, > > I am setting up replication and got the error below > > mysql> change master to master_host='172.20.1.189', master_user='repl', > master_password='pass'; > Query OK, 0 rows affected (0.01 sec) > > mysql> start slave; > ERROR 1200 (HY000): The server is not configured as slave; fix in config > file or with CHANGE MASTER TO > mysql> exit > Bye > [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log > 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown > > 080819 12:53:31 InnoDB: Starting shutdown... > 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 > 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete > > 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 > 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. > Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 > Source distribution > 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were > used; so replication may break when this MySQL server acts as a slave and > has his hostname changed!! Please use > '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. > > > -- > Krishna Chandra Prajapati >
Replication Error
Hi, I am setting up replication and got the error below mysql> change master to master_host='172.20.1.189', master_user='repl', master_password='pass'; Query OK, 0 rows affected (0.01 sec) mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO mysql> exit Bye [EMAIL PROTECTED] ~]# tail /var/log/mysql/mysqld.log 080819 12:53:31 [Note] /usr/libexec/mysqld: Normal shutdown 080819 12:53:31 InnoDB: Starting shutdown... 080819 12:53:33 InnoDB: Shutdown completed; log sequence number 0 43665 080819 12:53:33 [Note] /usr/libexec/mysqld: Shutdown complete 080819 12:53:34 InnoDB: Started; log sequence number 0 43665 080819 12:53:34 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. -- Krishna Chandra Prajapati
Replication error 1236
Hi All, Once a week or so I get the following error: 080801 8:18:35 [ERROR] Error reading packet from server: error reading log entry ( server_errno=1236) 080801 8:18:35 [ERROR] Got fatal error 1236: 'error reading log entry' from master when reading data from binary log Stopping the slave and restart at its current postion does not help here (the same error happens again with next entry in bin log), the only way I know how to fix this is to flush the logs and restart the slave with the new log file (changes in between are manually synched). I would appreciate any pointers about where to start looking for the problem. E.g. is the bin log file corrupt? And if so why does this happen so often Thanks Olaf - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Master-Slave replication error: Last_Errno: 1146
On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud < [EMAIL PROTECTED]> wrote: > Hi all. > > I have 2 MySQL servers. > One master and one slave. > In order to add new slave server, and because i can't stop the master one, > i > have tried this: > > http://forums.mysql.com/read.php?26,99846,102058 > > " > *You don't have to modify the other slaves configuration. What you need to > do is obtain a snapshot of the data on those slaves with their current > position relative to the master. The easiest way to do this is to stop > mysql > on one of the slaves and copy it's data directory (except for the bin logs) > and my.cnf to the new slave. Then start the old slave so it doesn't get too > far behind in replication. On the new slave change the server-id in my.cnf > so it's unique from the other servers. Add skip-slave to my.cnf. Start > mysql, login and run show slave status\G Then run the following command > substituting the $values from the show slave status > > change master to master_log_file='$Relay_master_log_file', > master_log_pos=$Exec_master_log_pos; > > Then start the new slave; > > Once replication catches up it's good to go :)* > " > > The issue is when i do "START SLAVE;" i obtain this error: > > Slave_IO_Running: Yes > Slave_SQL_Running: No >Replicate_Do_DB: >Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: >Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 1146 > Last_Error: Error 'Table 'XX.y' doesn't exist' > on query. Default database: ''. Query: 'INSERT INTO >y ' > > MySQL Server version: version 5.0.32 . > > Any idea ? It looks like you started at a position that after an INSERT. So your position is wrong. > > Many Thanks. > -- > Salah NAIT-MOULOUD > Echovox - www.echovox.com > m-Boost - www.m-boost.com >
Master-Slave replication error: Last_Errno: 1146
Hi all. I have 2 MySQL servers. One master and one slave. In order to add new slave server, and because i can't stop the master one, i have tried this: http://forums.mysql.com/read.php?26,99846,102058 " *You don't have to modify the other slaves configuration. What you need to do is obtain a snapshot of the data on those slaves with their current position relative to the master. The easiest way to do this is to stop mysql on one of the slaves and copy it's data directory (except for the bin logs) and my.cnf to the new slave. Then start the old slave so it doesn't get too far behind in replication. On the new slave change the server-id in my.cnf so it's unique from the other servers. Add skip-slave to my.cnf. Start mysql, login and run show slave status\G Then run the following command substituting the $values from the show slave status change master to master_log_file='$Relay_master_log_file', master_log_pos=$Exec_master_log_pos; Then start the new slave; Once replication catches up it's good to go :)* " The issue is when i do "START SLAVE;" i obtain this error: Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1146 Last_Error: Error 'Table 'XX.y' doesn't exist' on query. Default database: ''. Query: 'INSERT INTO y ' MySQL Server version: version 5.0.32 . Any idea ? Many Thanks. -- Salah NAIT-MOULOUD Echovox - www.echovox.com m-Boost - www.m-boost.com
Replication error with stored proc and triggers
>Description: I am using MySQL server as backend database supporting a telecomm platform providing voice over ip services. tables involved: acc, cdr, account, location2 Partial processing flow: 1. When a phone call is started. A record will be inserted into table acc (method=INVITE). This will trigger an insert of a record into table cdr. 2. When the phone call is ended. Another record will be inserted into table acc (method=BYE). This will trigger an update of the cdr record (endtime and duration). 3. When table cdr is updated, a trigger will start. If cdr_duration is not null, the account table will be updated with adjusted balance. The process flow has been working fine. The database is replicated to another MySQL server instance running on another machine. Recently, I am encountering an error that caused the replication to stop. IN show slave status, I am getting an error message: Last_Error: Query caused different errors on master and slave. Error on master: 'Can't update table '%-.64s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.' (1442), Error on slave: 'no error' (0). Default database: 'opnser'. Query: 'insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,ani,did,dnis ) values ('BYE','3405618788-778336','516B0D10-1448','[EMAIL PROTECTED] hnl.aloha.net','200','OK','2007-12-02 21:14:23','8088646143','818084473408','14378288809164968574')' Skip counter: 0 Seconds_Behind_Master: NULL The transaction causing error was completed: cdr record updated, account balance adjusted. The only problem is that replication process is frozen. I have checked the application and it does not look like there is any deadlock situation. >How-To-Repeat: It would be difficult to reproduce the error. The creation of acc record is the result of a voip software 'openser'. The error condition is random and unpredictable. >Fix: When this happen I need to re-establish the replication by making a copy from master and do change master on the slave machine. >Submitter-Id: >Originator:Richard Siy >Organization: Quattro Broadband, Inc. >MySQL support: none >Synopsis: Error causing replication to stop. >Severity: <[ non-critical | serious | critical ] (one line)> serious >Priority: <[ low | medium | high ] (one line)> high >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> sw-bug >Release: mysql-5.0.27-standard (MySQL Community Edition - Standard (GPL)) >C compiler:gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2) >C++ compiler: gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2) >Environment: System: Linux qbdbm1.qbnet 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 athlon i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake Compilation info: CC='gcc' CFLAGS='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4' CXX='gcc' CXXFLAGS='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Aug 17 2006 /lib/libc.so.6 -> libc-2.3.4.so -rwxr-xr-x 1 root root 1439335 Dec 20 2004 /lib/libc-2.3.4.so Configure command: ./configure '--disable-shared' '--with-server-suffix=-standard' '--without- embedded-server' '--with-innodb' '--with-archive-storage-engine' '--without-bench' '--with-zlib- dir=bundled' '--with-big-tables' '--enable-assembler' '--enable-local-infile' '--with-mysqld- user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-pic' '--prefix=/' '--with- extra-charsets=complex' '--with-yassl' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '-- libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '-- infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe- client' '--with-comment=MySQL Community Edition - Standard (GPL)' '--with-readline' 'CC=gcc' 'CFLAGS= -O2 -g -pipe -m32 -march=i386 -mtune=pentium4' 'CXXFLAGS=-O2 -g -pipe -m32 -march=i386 - mtune=pentium4' 'CXX=gcc' 'LDFLAGS=' Looking forward to hear from you soon. Thanks, Richard Siy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication error with system's "mysql" db
Hi Jen, Jen mlists wrote: Hello members, When I do mysql replication,I didn't replicate the system's "mysql" database. but someone updated the mysql db in master,then I got the errors on slave. How to resolve it?Do I need to always replicate mysql db?thanks. ERROR: 1146 Table 'mysql.mobilearea' doesn't exist 070717 15:23:46 Slave: Error 'Table 'mysql.mobilearea' doesn't exist' on query. Default database: ''. Query: 'DELETE FROM `mysql`.`mobilearea`', Error_code: 1146 070717 15:23:46 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB3-bin.185' position 39946 You can avoid replicating it, but the rules are complex. You should be careful to read this section of the manual: http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html Some of the replication options don't do what you think they will from their names. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication error with system's "mysql" db
Hello members, When I do mysql replication,I didn't replicate the system's "mysql" database. but someone updated the mysql db in master,then I got the errors on slave. How to resolve it?Do I need to always replicate mysql db?thanks. ERROR: 1146 Table 'mysql.mobilearea' doesn't exist 070717 15:23:46 Slave: Error 'Table 'mysql.mobilearea' doesn't exist' on query. Default database: ''. Query: 'DELETE FROM `mysql`.`mobilearea`', Error_code: 1146 070717 15:23:46 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB3-bin.185' position 39946 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication error: Unable to get certificate
Master_SSL_Allowed: Yes Master_SSL_CA_File: /root/.mysql/cacert.pem Master_SSL_CA_Path: /root/.mysql/ Master_SSL_Cert: /root/.mysql/client-cert.pem Master_SSL_Cipher: Master_SSL_Key: /root/.mysql/client-key.pem Seconds_Behind_Master: 0 [...] SSL:3017771936:error:0200100D:system library:fopen:Permission denied:bss_file.c:352:fopen('/root/.mysql/client-cert.pem','r') MySQL (which runs as the "mysql" user) isn't going to be able to read the certificates out of root's home directory, which is only readable by root. Put the certificates somewhere where the "mysql" user can read them - your data directory would be a sensible place. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication error: Unable to get certificate
Hi I've followed the replication procedure, as instructed on the online manual. I want to use replication over SSL. I've followed this procedure to create test SSL certificates, keys, etc. http://dev.mysql.com/doc/refman/4.1/en/secure-create-certs.html On slave machine: mysql> show slave status\G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_User: repl Connect_Retry: 60 Master_Log_File: amit0-bin.60 Read_Master_Log_Pos: 79 Relay_Log_File: core1-relay-bin.03 Relay_Log_Pos: 337 Relay_Master_Log_File: amit0-bin.60 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: overdrive Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 79 Relay_Log_Space: 337 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: /root/.mysql/cacert.pem Master_SSL_CA_Path: /root/.mysql/ Master_SSL_Cert: /root/.mysql/client-cert.pem Master_SSL_Cipher: Master_SSL_Key: /root/.mysql/client-key.pem Seconds_Behind_Master: 0 # mysql --version mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using readline 5.1 Replication seems to work. It's even using SSL. However I'm getting the following error in log: 061123 10:30:53 [Note] Slave SQL thread initialized, starting replication in log 'amit0-bin.60' at position 79, relay log './core1-relay-bin.03' position: 294 Error when connection to server using SSL:3017771936:error:0200100D:system library:fopen:Permission denied:bss_file.c:352:fopen('/root/.mysql/client-cert.pem','r') 3017771936:error:20074002:BIO routines:FILE_CTRL:system lib:bss_file.c:354: 3017771936:error:140AD002:SSL routines:SSL_CTX_use_certificate_file:system lib:ssl_rsa.c:470: Unable to get certificate from '/root/.mysql/client-cert.pem' Why is this error message generated? How come replication is happening and IS secured after all? I've found this bug: http://bugs.mysql.com/bug.php?id=11169 Is this the same issue? As I'm currently using a lesser version than that for-which this bug is reported, can I assume an upgrade will solve it? Thanks, Amit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication error: max_allowed_packet (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE All, I'm getting the not-so-mysterious error in my slave log file as follows: [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) [ERROR] Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log What's puzzling is that I've increased the max_allowed_packet to various sizes (including 1GB+) in both master and slave my.cnf files and verified that both are set properly with show variables from within the mysql shell. The problem continues to exist however, despite any size change for that specific variable. I read the HYPERLINK http://dev.mysql.com/doc/mysql/en/packet-too-large.html http://dev.mysql.com/doc/mysql/en/packet-too-large.html post re: this issue and even tried modifying the net_buffer_length variable. I still continue to get this error and replication is, of course, not working. Running 2.4.9-e.49smp Linux (RH AS 2.1) and mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686). Any insight greatly appreciated. Tate Classification: UNCLASSIFIED Caveats: NONE
Re: Replication error
"Ugo Bellavance" <[EMAIL PROTECTED]> wrote: > Hi, > >I'm trying to do a replication of two servers (one is mysql version = > 4.1.0-alpha-debug-debug (slave) on debian and the other is = > 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for = > now. > > What I've done is that I stopped the master, copied the data folder to = > the slave. I got the data from SHOW MASTER STATUS and input it in the = > slave, and created the user on the master, as directed. > > The problem is that when I START SLAVE, I get this error: ERROR 1200: = > The server is not configured as slave, fix in config file or with CHANGE = > MASTER TO > > The problem might be caused by the fact that I have a firewall with nat = > between them, but I set up the user accordingly ([EMAIL PROTECTED] = > name of the firewall]. The slave is able to reach port 3306 on the = > master and port-forwarding is enabled on the firewall, forwarding port = > 3306 to the slave. > > SHOW MASTER STATUS on the master: > > mysql> show master status; > +--+--+--+--+ > | File | Position | Binlog_do_db | Binlog_ignore_db | > +--+--+--+--+ > | bobby-bin.23 | 79 | | | > +--+--+--+--+ > 1 row in set (0.00 sec) > > Did you put replication option to the my.cnf or use CHANGE MASTER TO command to configure your slave? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Replication error
Hi, I'm trying to do a replication of two servers (one is mysql version 4.1.0-alpha-debug-debug (slave) on debian and the other is 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for now. What I've done is that I stopped the master, copied the data folder to the slave. I got the data from SHOW MASTER STATUS and input it in the slave, and created the user on the master, as directed. The problem is that when I START SLAVE, I get this error: ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO The problem might be caused by the fact that I have a firewall with nat between them, but I set up the user accordingly ([EMAIL PROTECTED] name of the firewall]. The slave is able to reach port 3306 on the master and port-forwarding is enabled on the firewall, forwarding port 3306 to the slave. SHOW MASTER STATUS on the master: mysql> show master status; +--+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--+--+--+--+ | bobby-bin.23 | 79 | | | +--+--+--+--+ 1 row in set (0.00 sec) Thanks -- Ugo Bellavance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication error (1236 - impossible position on slave)
Hi, We have 2 MySQL 4.0.16 with replication enabled (M -> S), only InnoDB tables. We're getting "Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)" in the slave. The master server had a problem... when it came back (with success) the log have: "031210 15:19:24 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 4169000545 InnoDB: Doing recovery: scanned up to log sequence number 3 4171205097 031210 15:19:25 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 45866, file name ./SV07-bin.008 031210 15:19:43 InnoDB: Flushing modified pages from the buffer pool... 031210 15:19:51 InnoDB: Started" But in the slave log: "031210 17:02:36 Slave: connected to master '[EMAIL PROTECTED]:xxx',replication resumed in log 'SV07-bin.008' at position 45866 031210 17:02:36 Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236) 031210 17:02:36 Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log 031210 17:02:36 Slave I/O thread exiting, read up to log 'SV07-bin.008', position 45866" With "show master status" (on master) I get: File = SV07-bin.009 Position = 456371766 And with "show slave status" (on slave) I get: Master_log_file = SV07-bin.008 Read_master_log_pos = 45866 Relay_log_file = SV08-relay-bin.011 Relay_log_pos = 458600084 Relay_master_log = SV07-bin.008 Slave_io_running = no Slave_sql_running = yes Exec_master_log_pos = 45866 Relay_log_space = 458600084 Is SV07-bin.008 corrupted? How can I debug? Thanks, Eduardo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication Error 1053
Mysqlians, The sql_thread on our slave slave server has been stopping with error 1053 ERROR: 1053 Server shutdown in progress 031203 16:05:01 Slave: error 'Server shutdown in progress' on query 'INSERT INTO INTEREST ( ID, PERSON_ID, COMMENT, DATE_CREATED, INTEREST_ID ) VALUES ( 'fffc5074-fe83-4f2e-9d4b-3d6a761c3f60', '49ea2258-3f60-4337-82be-cb15012636be', '', '2003-12-03 16:04:59', '32' )', error_code=1053 I have seen this half a dozen times and one time was in fact the master being restarted. However I have seen this several times without the master being restarted or any error in the master log at all. In addition this error has occurred on relatively low machine loads ( top/1.0 -2.0) and high (4.0-6.0). However the master server does between 1000 - 4000 questions/second. Is this a bug or something about the insert statement or something else. Thanks, Trevor
replication error-code 1053 - what is it ?
Hi, I have a busy MySQL slave which is directly updated by a periodic "purge" script which throws away irrelevant data. Occassionally, (er, a few times a day, actually), the slave "quietly" falls over, but ITS slaves trip with "[SQL...] partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START;" Looking in the binlog, I find the affected SQL has error-code 1053 - about which perror knows nothing. I think this must be some timeout or locking issue or something. Does anyone know what the error means for certain ? Is there something I can tweak to alleviate the problem ? MySQL v3.23.51. regards, Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication error writing/creating master.info file
>Description: Attempts to start slave replication fail when MySQL attempts to write the bin-log location to the master.info file. Attempts to manually change master also fail when writing to master.info file. master.info file is created, but has zero length (no info written) >How-To-Repeat: With valid master.info file: issue slave start command. MySQL replies: Could not initialize master info structure, check permisions on master.info Removed master.info file restart mysql and issue: CHANGE MASTER TO MASTER_HOST = '...', MASTER_USER = '...', MASTER_PASSWORD = '...', MASTER_PORT = 3306 MySQL replies: Could not initialize master info master.info file -rw-rw1 mysqlmysql 0 Mar 18 14:53 /var/lib/mysql/master.info Occured in both 4.0.11 and 4.0.12 at least. Load data from master still works and transfers data correctly. I just cannot start the slave server. >Fix: ? >Submitter-Id: >Originator:John Ehrlinger >Organization: >MySQL support: none >Synopsis: >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-4.0.12 (Official MySQL RPM) >C compiler:2.95.3 >C++ compiler: 2.95.3 >Environment: System: Linux access5.ccf.org 2.4.18-27.8.0 #1 Fri Mar 14 06:45:49 EST 2003 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jan 7 12:55 /lib/libc.so.6 -> libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 2002 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 2002 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Replication error
On Wednesday 12 March 2003 20:05, trashMan wrote: > I've tried to setup a replication but ...i've several problem! I've > follow the manual istruction > http://www.mysql.com/doc/en/Replication_HOWTO.html > But the slave don't start the replica. > > SHOW SLAVE STATUS on SLAVE return SLAVE:running > > SHOW PROCESSLIST on SLAVE return reconnecting after a failed read > > Any suggestion about this?? Please, help me! I don't know what can i do! > > The master and the slave are not in the same network: the master is a > server located in a webfarm and the slave is my pc. If i try to connect > me to mysql MASTER from my pc via mysql --host= > --user=userforreplica --password=pwdforreplica i enter but i can not do > nothing. Look in the error logs. What versions of master and slave do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
R: Replication error
SHOW MASTER STATUS on the master say file: webserver-bin.003 Position:11345 Binlog_do_db: zopista Where zopista is the database i want replicate. :-/ Massi & samuela -Messaggio originale- Da: Jennifer Goodie [mailto:[EMAIL PROTECTED] Inviato: giovedì 13 marzo 2003 20.05 A: trashMan; [EMAIL PROTECTED] Oggetto: RE: Replication error What does it say when you run SHOW MASTER STATUS on the master? Are you sure the slave is the problem and not the master? -Original Message- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 7:29 AM To: [EMAIL PROTECTED] Subject: Replication error Please.seven days to try it!! Help me!! :-( -- Hello, I've tried to setup a replication but ...i've several problem! I've follow the manual istruction http://www.mysql.com/doc/en/Replication_HOWTO.html But the slave don't start the replica. SHOW SLAVE STATUS on SLAVE return SLAVE:running SHOW PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks Massimiliano and samuela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replication error
What does it say when you run SHOW MASTER STATUS on the master? Are you sure the slave is the problem and not the master? -Original Message- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 7:29 AM To: [EMAIL PROTECTED] Subject: Replication error Please.seven days to try it!! Help me!! :-( -- Hello, I've tried to setup a replication but ...i've several problem! I've follow the manual istruction http://www.mysql.com/doc/en/Replication_HOWTO.html But the slave don't start the replica. SHOW SLAVE STATUS on SLAVE return SLAVE:running SHOW PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks Massimiliano and samuela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication error
trashMan wrote: > Please.seven days to try it!! Help me!! :-( > > -- > > Hello, > I've tried to setup a replication but ...i've several problem! I've > follow the manual istruction > http://www.mysql.com/doc/en/Replication_HOWTO.html > But the slave don't start the replica. > > SHOW SLAVE STATUS on SLAVE return SLAVE:running > > SHOW PROCESSLIST on SLAVE return reconnecting after a failed read > > Any suggestion about this?? Please, help me! I don't know what can i do! > > The master and the slave are not in the same network: the master is a > server located in a webfarm and the slave is my pc. If i try to connect > me to mysql MASTER from my pc via mysql --host= > --user=userforreplica --password=pwdforreplica i enter but i can not do > nothing. > > Thanks > > Massimiliano and samuela > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.phpI I'm not sure I understand your email. Are you able to connect to the master? If so, the only Privileges you should have are replication unless other Privileges have been granted to userforreplica. walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error
Please.seven days to try it!! Help me!! :-( -- Hello, I've tried to setup a replication but ...i've several problem! I've follow the manual istruction http://www.mysql.com/doc/en/Replication_HOWTO.html But the slave don't start the replica. SHOW SLAVE STATUS on SLAVE return SLAVE:running SHOW PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks Massimiliano and samuela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error
Hello, I've tried to setup a replication but ...i've several problem! I've follow the manual istruction http://www.mysql.com/doc/en/Replication_HOWTO.html But the slave don't start the replica. SHOW SLAVE STATUS on SLAVE return SLAVE:running SHOW PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks and...sorry for my bad english Massimiliano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication "Error updateing slave list" in mysql 4.0.10
> Check the user 'repl' has REPLICATION SLAVE privilege. Ah. that fixed it. Actually, the real reason was that I had not yet updated the mysql tables and the new privileges did not take effect as a result. mysql_fix_privilege_tables , followed by the 'GRANT' command and 'flush privileges' fixed it. Thanks! -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: replication "Error updateing slave list" in mysql 4.0.10
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote: > I am having problems setting up replication between two 4.0.10 > servers. > > What I did so far: > > - generate a dump of the current state of the server using > 'mysqldump' (its a mix of mostly innodb tables and some MyISAM > tables) > - dropped all databases from the slave > - imported the dump into the slave using > mysql < dump > - updated the slave parameters using 'CHANGE MASTER' > > As I start the slave, it immediatly stops and I am getting the > following in the slave error log: > > > 030213 4:36:30 Slave I/O thread: connected to master 'repl@master:3399', > replication started in log 'slave-bin.005' at position 86967189 030213 > 4:36:30 Error updating slave list: Query error > 030213 4:36:30 Slave I/O thread exiting, read up to log 'slave-bin.005', > position 86967189 > > not that the master is running on port 3399 (ssh tunnel). > I can connect to the master as 'repl' from the slave. > looking at the source shows this error in conjunction with > 'show slave hosts'. This command returns an empty result on > master and host. Not sure what it is supposed to return. > > I did try a 4.0.5 master first with the same result. Now I upgraded > the master to 4.0.10 (slave ran 4.0.10 all along). Check the user 'repl' has REPLICATION SLAVE privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication "Error updateing slave list" in mysql 4.0.10
I am having problems setting up replication between two 4.0.10 servers. What I did so far: - generate a dump of the current state of the server using 'mysqldump' (its a mix of mostly innodb tables and some MyISAM tables) - dropped all databases from the slave - imported the dump into the slave using mysql < dump - updated the slave parameters using 'CHANGE MASTER' As I start the slave, it immediatly stops and I am getting the following in the slave error log: 030213 4:36:30 Slave I/O thread: connected to master 'repl@master:3399', replication started in log 'slave-bin.005' at position 86967189 030213 4:36:30 Error updating slave list: Query error 030213 4:36:30 Slave I/O thread exiting, read up to log 'slave-bin.005', position 86967189 not that the master is running on port 3399 (ssh tunnel). I can connect to the master as 'repl' from the slave. looking at the source shows this error in conjunction with 'show slave hosts'. This command returns an empty result on master and host. Not sure what it is supposed to return. I did try a 4.0.5 master first with the same result. Now I upgraded the master to 4.0.10 (slave ran 4.0.10 all along). -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication error (auto)
Hi "Oliver Schlag" <[EMAIL PROTECTED]>, I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Replication_FAQ.html * http://www.mysql.com/doc/en/Replication.html * http://www.mysql.com/doc/en/Replication_HOWTO.html * http://www.mysql.com/doc/en/Replication_SQL.html * http://www.mysql.com/doc/en/Replication_Options.html This was an automated response to your email 'Replication error'. Final search keyword used to query the manual was 'Replication error'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error
Hy, im trying to create a replication between two MySql Servers. The Master is running 4.0.6 (linux) and the slave ist 4.0.10 (solaris sparc 64-bit). If i try to start the replication process on the slave it prints the following error message in the message log : 030206 20:09:36 Slave I/O thread: error connecting to master 'T$REPLI@ip1:3306': Error: 'Access denied for user: 'T$REPLI@localhost' (Using password: YES)' errno: 1045 retry-time: 60 retries: 86400 The mysterious thing is, that it tells me an acces denied on the local machine and not on the remote. If i try to connect with the mysql tool to the remote server all works fine. Could anybody help me ? Thanks Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication error: 'Could not initialize master info'
Hi list, My original post concerning this issue is below - it was a week or so ago. No replies were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have figured it out, and my slave is now replicating from the master. The problem was that the mysql data directory was owned by root, not mysql. While the database directories within the data directory were owned by mysql, the data directory itself was root:root 755. Changing the data directory to be owned by mysql obviously allowed the master.info file to be written there when I did the 'change master to...' command. Original post here: * >Hi there, >I'm trying to set up replication between two RH7.2 Linux servers running MySQL >3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual >(section 4.10 Replication in MySQL), and when I do the following command on the slave: >change master to master_host='db1', master_user='', >master_password='', master_log_file='db1-binary-log.004', >master_log_pos=38456522; >, mysql tells me: >ERROR: >Could not initialize master info >I can't find anything in the error log, and I've set up the replication user on the >master as outlined in the manual. Both master and slave are currently using databases >with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of >course, MyISAM). I'm not using InnoDB tables. >Can anyone give me an idea of how to troubleshoot this one? >Thanks, >Guy. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error: 'Could not initialize master info'
Hi there, I'm trying to set up replication between two RH7.2 Linux servers running MySQL 3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual (section 4.10 Replication in MySQL), and when I do the following command on the slave: change master to master_host='db1', master_user='', master_password='', master_log_file='db1-binary-log.004', master_log_pos=38456522; , mysql tells me: ERROR: Could not initialize master info I can't find anything in the error log, and I've set up the replication user on the master as outlined in the manual. Both master and slave are currently using databases with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of course, MyISAM). I'm not using InnoDB tables. Can anyone give me an idea of how to troubleshoot this one? Thanks, Guy. -- Guy Waugh Unix Team Information Technology & Telecommunication Services Southern Cross University P.O. Box 157 Lismore NSW 2480 Ph: 61 2 6620 3196 Fax: 61 2 6620 3033 www.scu.edu.au/admin/it -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL 3.23.49 - strange replication error
It only happened the once, I've checked the history and no one executed any odd commands (that I noticed:-) Thanks Liz -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 26 November 2002 15:45 To: [EMAIL PROTECTED] Subject: re: MySQL 3.23.49 - strange replication error Liz, Monday, November 25, 2002, 6:47:35 PM, you wrote: LC> I've got a master database with 2 slaves. I've had them up and running for LC> quite a while now with no problems, but today I noticed an error - there was LC> a slave running on the master! LC> I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a LC> good while anyway). I looked everywhere else mysql looks for my.cnf files LC> but there were none. I tried to stop the slave by running SLAVE STOP - it LC> said 0 rows changed and SHOW SLAVE STATUS showed that the slave was still LC> running! I stopped mysql, moved the master.info and restarted mysql - this LC> fixed the problem (none of the proper slaves reported any errors at any LC> point) but I'm still a little worried why this happened. LC> The master.info created on the master is shown below (I've put in the \n's LC> so you can see where there were blank lines): LC> \n LC> 4\n LC> \n LC> test\n LC> \n LC> 3306\n LC> 60\n LC> Anyone have any ideas why this might have happened? This error first LC> started when one of my colleagues restarted mysql today, but we restart it LC> fairly regularly, I checked the command he used - it was fine. FYI - we run LC> Redhat 7.2. It happens each time when you restart the MySQL server? or just once? Did someone executed command like CHANGE MASTER TO .. ? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL 3.23.49 - strange replication error
Liz, Monday, November 25, 2002, 6:47:35 PM, you wrote: LC> I've got a master database with 2 slaves. I've had them up and running for LC> quite a while now with no problems, but today I noticed an error - there was LC> a slave running on the master! LC> I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a LC> good while anyway). I looked everywhere else mysql looks for my.cnf files LC> but there were none. I tried to stop the slave by running SLAVE STOP - it LC> said 0 rows changed and SHOW SLAVE STATUS showed that the slave was still LC> running! I stopped mysql, moved the master.info and restarted mysql - this LC> fixed the problem (none of the proper slaves reported any errors at any LC> point) but I'm still a little worried why this happened. LC> The master.info created on the master is shown below (I've put in the \n's LC> so you can see where there were blank lines): LC> \n LC> 4\n LC> \n LC> test\n LC> \n LC> 3306\n LC> 60\n LC> Anyone have any ideas why this might have happened? This error first LC> started when one of my colleagues restarted mysql today, but we restart it LC> fairly regularly, I checked the command he used - it was fine. FYI - we run LC> Redhat 7.2. It happens each time when you restart the MySQL server? or just once? Did someone executed command like CHANGE MASTER TO .. ? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.49 - strange replication error
Hi I've got a master database with 2 slaves. I've had them up and running for quite a while now with no problems, but today I noticed an error - there was a slave running on the master! I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a good while anyway). I looked everywhere else mysql looks for my.cnf files but there were none. I tried to stop the slave by running SLAVE STOP - it said 0 rows changed and SHOW SLAVE STATUS showed that the slave was still running! I stopped mysql, moved the master.info and restarted mysql - this fixed the problem (none of the proper slaves reported any errors at any point) but I'm still a little worried why this happened. The master.info created on the master is shown below (I've put in the \n's so you can see where there were blank lines): \n 4\n \n test\n \n 3306\n 60\n Anyone have any ideas why this might have happened? This error first started when one of my colleagues restarted mysql today, but we restart it fairly regularly, I checked the command he used - it was fine. FYI - we run Redhat 7.2. Kind regards Liz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Exciting new Replication Error -- more info
MASTER Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) SLAVE Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386) On my Master I am getting this: mysql> SHOW BINLOG EVENTS IN '/usr/local/var/www200-bin.008' FROM 38717800; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:6227106 Current database: *** NONE *** ERROR 2013: Lost connection to MySQL server during query Slave SQL thread initialized, starting replication in log 'www200-bin.008' at position 38717817, relay log './s142-17-103-3-relay-bin.056' position: 9212273 021114 16:34:12 Error in Log_event::read_log_event(): 'read error', data_len=161,event_type=2 021114 16:34:12 Slave SQL thread: I/O error reading event(errno: -1 cur_log->error: 122) 021114 16:34:12 Error reading relay log event: Aborting slave SQL thread because of partial event read 021114 16:34:12 Could not parse log event entry, check the master for binlog corruption This may also be a network problem, or just a bug in the master or slave code. 021114 16:34:12 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'www200-bin.008' position 38717817 021114 16:34:12 Slave SQL thread exiting, replication stopped in log 'www200-bin.008' at position 38717817 021114 16:34:17 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'www200-bin.008' at position 38748768 I don't have a clue what this could mean. I had a screw up where I made a unique index on the master, but the database table on the slave had data that was not unique while the master data was unique. I backed up the table on the slave, deleted the data from the master table, deleted the data from the slave table, restarted the slave, it worked, removed both indexes on the slave and master... Then I copied the data back to the slave table. Now I get the above messages, and typing either slave start, or slave stop hangs endlessly. Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Exciting new Replication Error
Slave SQL thread initialized, starting replication in log 'www200-bin.008' at position 38717817, relay log './s142-17-103-3-relay-bin.056' position: 9212273 021114 16:34:12 Error in Log_event::read_log_event(): 'read error', data_len=161,event_type=2 021114 16:34:12 Slave SQL thread: I/O error reading event(errno: -1 cur_log->error: 122) 021114 16:34:12 Error reading relay log event: Aborting slave SQL thread because of partial event read 021114 16:34:12 Could not parse log event entry, check the master for binlog corruption This may also be a network problem, or just a bug in the master or slave code. 021114 16:34:12 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'www200-bin.008' position 38717817 021114 16:34:12 Slave SQL thread exiting, replication stopped in log 'www200-bin.008' at position 38717817 021114 16:34:17 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'www200-bin.008' at position 38748768 I don't have a clue what this could mean. I had a screw up where I made a unique index on the master, but the database table on the slave had data that was not unique while the master data was unique. I backed up the table on the slave, deleted the data from the master table, deleted the data from the slave table, restarted the slave, it worked, removed both indexes on the slave and master... Then I copied the data back to the slave table. Now I get the above messages, and typing either slave start, or slave stop hangs endlessly. Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error?
Hi, I currently have my replication setup with 3 machines as such: A > B > C Machine A just died, so B is now my master. However, I want to re-adjust my setup so it looks like this: B > A > C So what I did was stop C and copy everything over to A. At this point, either A or C should be able to act as a slave reading from B. However, whenever I start A it starts to skip large chunks of the update log. C doesn't seem to have this problem. Does anyone know what is making this happen? Using: 3.23.49a-Max kernel: 2.4.9-34enterprise Thanks, Adrian mysql query __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql replication error
No ... I'm just setting up the replication for the first time. I make a dump of the master and i replaced it on the slave. thanks and bye. --- Victor Pendleton <[EMAIL PROTECTED]> ha scritto: > Has the replication worked previously for you? > If so, have you reset the master and the slave? > Was a snapshot of the master placed on the slave > before beginning > replication? > I hate to ask such simple questions but I am just > checking. > > Victor > > -Original Message- > From: Natale Babbo > To: [EMAIL PROTECTED] > Sent: 10/23/02 8:22 AM > Subject: mysql replication error > > i get the following error in the connection > slave->master while setting up a replication between > two MySQLServer(slave and master both windows XP): > > .err file on slave: > MySql: ready for connections > 021023 14:08:34 InnoDB: Started > 021023 14:08:35 Slave I/O thread: connected to > master > '[EMAIL PROTECTED]:3306', replication started in log > 'FIRST' at position 4 > 021023 14:08:35 Error updating slave list: Query > error > 021023 14:08:35 Slave I/O thread exiting, read up > to > log 'FIRST', position 4 > > what does it mean? > > My.ini on Master: > log-bin=C:\Programmi\MySQL\Logs\MySQL-bin > server-id=1 > > My.ini on Slave: > master-host=192.168.0.4 > master-user=repl > master-password= > master-port=3306 > server-id=2 > set-variable = slave_net_timeout=3600 > set-variable = net_read_timeout=3600 > > Show master status: > File : MySQL-bin.001 > Position : 79 > Binlog_do_db : > Binlog_inogne_db : > > ERROR > No query specified > > Show Slave status: > Master_Host : 192.168.0.04 > Master_User : repl > Master_Port : 3306 > Connect_retry: 60 > Master_Log_File : > Read_Master_Log_Pos : 4 > Relay_Log_File : MySQL-relay-bin.002 > Relay_Log_Pos: 4 > Relay_Master_Log_File: > Slave_IO_Running : Yes > Slave_SQL_Running: Yes > Replicate_do_db : > Replicate_ignore_db : > Last_errno : 0 > Last_error : > Skip_counter : 0 > Exec_master_log_pos : 0 > Relay_log_space : 0 > > ERROR: > No query specified > > What is wrong? > Why do I get the error ? Which > type of query should I specify? > > Thanks in advance. > Natale Babbo > > __ > Mio Yahoo!: personalizza Yahoo! come piace a te > http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql replication error
i get the following error in the connection slave->master while setting up a replication between two MySQLServer(slave and master both windows XP): .err file on slave: MySql: ready for connections 021023 14:08:34 InnoDB: Started 021023 14:08:35 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021023 14:08:35 Error updating slave list: Query error 021023 14:08:35 Slave I/O thread exiting, read up to log 'FIRST', position 4 what does it mean? My.ini on Master: log-bin=C:\Programmi\MySQL\Logs\MySQL-bin server-id=1 My.ini on Slave: master-host=192.168.0.4 master-user=repl master-password= master-port=3306 server-id=2 set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 Show master status: File : MySQL-bin.001 Position : 79 Binlog_do_db : Binlog_inogne_db : ERROR No query specified Show Slave status: Master_Host : 192.168.0.04 Master_User : repl Master_Port : 3306 Connect_retry: 60 Master_Log_File : Read_Master_Log_Pos : 4 Relay_Log_File : MySQL-relay-bin.002 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running : Yes Slave_SQL_Running: Yes Replicate_do_db : Replicate_ignore_db : Last_errno : 0 Last_error : Skip_counter : 0 Exec_master_log_pos : 0 Relay_log_space : 0 ERROR: No query specified What is wrong? Why do I get the error ? Which type of query should I specify? Thanks in advance. Natale Babbo __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Error
- Original Message - From: "walt" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 2:08 PM Subject: Re: Replication Error > Lewis Watson wrote: > > > Also, I am intersted in a way to reset the entire replication thing. In > > other words, just remove all hints of replication and start over... Is there > > a way I can do this? > > Thanks. > > Lewis > > > > Lewis, > As far as I've been able to see, there are only a few files that control > replication. > I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and > stopping mysql on both > the master and the slave. Then delete log files on the master including the > *.index file. I'd then delete > any files on the slave that deal with replication (master.info). > Once all this is done, try restarting the master > to see if it still has problems. > > walt Thanks Walt. I will try that... Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Error
Thats exactly what I did. Still the same error Show master status shows it running with a positive number. Slave is running. Netstat -na shows them connected. I read that one page for two hours last night... over and over and over :) Thanks. Lewis - Original Message - From: "Jeff Kilbride" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 2:45 PM Subject: Re: Replication Error > RESET MASTER > RESET SLAVE > > This is a handy page to bookmark, if you're doing replication: > http://www.mysql.com/doc/en/Replication_SQL.html > > --jeff > > - Original Message - > From: "walt" <[EMAIL PROTECTED]> > To: "Lewis Watson" <[EMAIL PROTECTED]> > Cc: "mysql" <[EMAIL PROTECTED]> > Sent: Tuesday, October 22, 2002 12:08 PM > Subject: Re: Replication Error > > > > Lewis Watson wrote: > > > > > Also, I am intersted in a way to reset the entire replication thing. In > > > other words, just remove all hints of replication and start over... Is > there > > > a way I can do this? > > > Thanks. > > > Lewis > > > > > > - Original Message - > > > From: "Lewis Watson" <[EMAIL PROTECTED]> > > > To: "mysql" <[EMAIL PROTECTED]> > > > Sent: Tuesday, October 22, 2002 12:06 PM > > > Subject: Replication Error > > > > > > > I had replication running fine between two mysql server machines on > linux. > > > > Then I added yet another slave but goofed and put in the same > server-id. > > > Now > > > > I am getting errors on the master server and proccesses being killed > and > > > > restarted. It comes with this error. > > > > > > > > ./bin/safe_mysqld: line 273: 12250 Segmentation fault > > > > $NOHUP_NICENESS $ledir/$MYSQLD > > > > $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR > > > > $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 > > > > > > > > I have tried flushing both master and slave. I have also reset eac. I > have > > > > also deleted the log files and the master.info file on the slave. > Nothing > > > is > > > > allowing these the master and original slave to communicate anymore. > Any > > > > ideas? > > > > Thanks, > > > > Lewis > > > > > > > > > > > > > > > > - > > > > Before posting, please check: > > > >http://www.mysql.com/manual.php (the manual) > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > Lewis, > > As far as I've been able to see, there are only a few files that control > > replication. > > I'd try removing replication stuff from my.cnf (server-id, log-bin, > etc..) and > > stopping mysql on both > > the master and the slave. Then delete log files on the master including > the > > *.index file. I'd then delete > > any files on the slave that deal with replication (master.info). > > Once all this is done, try restarting the master > > to see if it still has problems. > > > > walt > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Error
RESET MASTER RESET SLAVE This is a handy page to bookmark, if you're doing replication: http://www.mysql.com/doc/en/Replication_SQL.html --jeff - Original Message - From: "walt" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:08 PM Subject: Re: Replication Error > Lewis Watson wrote: > > > Also, I am intersted in a way to reset the entire replication thing. In > > other words, just remove all hints of replication and start over... Is there > > a way I can do this? > > Thanks. > > Lewis > > > > - Original Message - > > From: "Lewis Watson" <[EMAIL PROTECTED]> > > To: "mysql" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 22, 2002 12:06 PM > > Subject: Replication Error > > > > > I had replication running fine between two mysql server machines on linux. > > > Then I added yet another slave but goofed and put in the same server-id. > > Now > > > I am getting errors on the master server and proccesses being killed and > > > restarted. It comes with this error. > > > > > > ./bin/safe_mysqld: line 273: 12250 Segmentation fault > > > $NOHUP_NICENESS $ledir/$MYSQLD > > > $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR > > > $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 > > > > > > I have tried flushing both master and slave. I have also reset eac. I have > > > also deleted the log files and the master.info file on the slave. Nothing > > is > > > allowing these the master and original slave to communicate anymore. Any > > > ideas? > > > Thanks, > > > Lewis > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > Lewis, > As far as I've been able to see, there are only a few files that control > replication. > I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and > stopping mysql on both > the master and the slave. Then delete log files on the master including the > *.index file. I'd then delete > any files on the slave that deal with replication (master.info). > Once all this is done, try restarting the master > to see if it still has problems. > > walt > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Error
Lewis Watson wrote: > Also, I am intersted in a way to reset the entire replication thing. In > other words, just remove all hints of replication and start over... Is there > a way I can do this? > Thanks. > Lewis > > - Original Message - > From: "Lewis Watson" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Tuesday, October 22, 2002 12:06 PM > Subject: Replication Error > > > I had replication running fine between two mysql server machines on linux. > > Then I added yet another slave but goofed and put in the same server-id. > Now > > I am getting errors on the master server and proccesses being killed and > > restarted. It comes with this error. > > > > ./bin/safe_mysqld: line 273: 12250 Segmentation fault > > $NOHUP_NICENESS $ledir/$MYSQLD > > $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR > > $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 > > > > I have tried flushing both master and slave. I have also reset eac. I have > > also deleted the log files and the master.info file on the slave. Nothing > is > > allowing these the master and original slave to communicate anymore. Any > > ideas? > > Thanks, > > Lewis > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Lewis, As far as I've been able to see, there are only a few files that control replication. I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and stopping mysql on both the master and the slave. Then delete log files on the master including the *.index file. I'd then delete any files on the slave that deal with replication (master.info). Once all this is done, try restarting the master to see if it still has problems. walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Error
Also, I am intersted in a way to reset the entire replication thing. In other words, just remove all hints of replication and start over... Is there a way I can do this? Thanks. Lewis - Original Message - From: "Lewis Watson" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:06 PM Subject: Replication Error > I had replication running fine between two mysql server machines on linux. > Then I added yet another slave but goofed and put in the same server-id. Now > I am getting errors on the master server and proccesses being killed and > restarted. It comes with this error. > > ./bin/safe_mysqld: line 273: 12250 Segmentation fault > $NOHUP_NICENESS $ledir/$MYSQLD > $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR > $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 > > I have tried flushing both master and slave. I have also reset eac. I have > also deleted the log files and the master.info file on the slave. Nothing is > allowing these the master and original slave to communicate anymore. Any > ideas? > Thanks, > Lewis > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Error
I had replication running fine between two mysql server machines on linux. Then I added yet another slave but goofed and put in the same server-id. Now I am getting errors on the master server and proccesses being killed and restarted. It comes with this error. ./bin/safe_mysqld: line 273: 12250 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 I have tried flushing both master and slave. I have also reset eac. I have also deleted the log files and the master.info file on the slave. Nothing is allowing these the master and original slave to communicate anymore. Any ideas? Thanks, Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql replication (Error reading packet from server: Binary logis not open (read_errno 0,server_errno=2000)
Looks like you don't have binary logging turned on on the master. louie miranda wrote: >021009 12:56:49 mysqld started >/usr/sbin/mysqld: ready for connections >021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306', >replication started in log 'FIRST' at position 4 >021009 12:56:49 Error reading packet from server: Binary log is not open >(read_errno 0,server_errno=2000) >021009 12:56:49 Slave: Failed reading log event, reconnecting to retry, log >'FIRST' position 4 >021009 12:56:49 Slave: reconnected to master >'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 >021009 12:56:49 Error reading packet from server: Binary log is not open >(read_errno 0,server_errno=2000) > > >Im doing mysql replication, i cant figure this error "Binary log is not >open" ? > > > >-- >thanks, >louie miranda >chikka asia, inc. >noc +63-2(7535000-511) > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql replication (Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000)
021009 12:56:49 mysqld started /usr/sbin/mysqld: ready for connections 021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021009 12:56:49 Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000) 021009 12:56:49 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 021009 12:56:49 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 021009 12:56:49 Error reading packet from server: Binary log is not open (read_errno 0,server_errno=2000) Im doing mysql replication, i cant figure this error "Binary log is not open" ? -- thanks, louie miranda chikka asia, inc. noc +63-2(7535000-511) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication error 1159
At 01:48 PM 7/12/2002, Jeremy Zawodny wrote: >On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote: > > now instead of getting the error every 30 seconds, i get it every > > hour. is there a way to make it go away forever? > >Make the number really big? > >I wonder if you can set it to 0 to mean "don't timeout". But that >could be bad in some cases too. > > > why does it happen and what does it mean? > >It means that the slave closed the connection because it hadn't heard >from the master in a while. You must not be sending a lot of data to >the slave(s) regularly, huh? right, these machines are in test mode. the databases aren't being modified/used at all at the moment. i'm just setting them up for production use later. i sure would have been happier if the message wasn't phrased like some sort of network communication error! 020712 15:39:59 Error reading packet from server: (server_errno=1159) 020712 15:40:59 Slave: Failed reading log event, reconnecting to retry, log 'rs1-bin.004' position 215 020712 15:40:59 Slave: reconnected to master 'replica@rs1private:3306',replication resumed in log 'rs1-bin.004' i'll probably set it to 86400 (1 day) eventually. i just wanted to make sure that i wasn't masking the symptom of some deep problem. thanks for the speedy reply. -jsd- sql query purple monkey dishwasher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication error 1159
On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote: > i am having the "Error reading packet from server: (server_errno=1159)" > replication problem. > > in searching the archives for others experience replication problems, i > came across the suggestion of adding these lines to my.cnf > > set-variable = slave_net_timeout=3600 > set-variable = net_read_timeout=3600 > > now instead of getting the error every 30 seconds, i get it every > hour. is there a way to make it go away forever? Make the number really big? I wonder if you can set it to 0 to mean "don't timeout". But that could be bad in some cases too. > why does it happen and what does it mean? It means that the slave closed the connection because it hadn't heard from the master in a while. You must not be sending a lot of data to the slave(s) regularly, huh? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 43 days, processed 958,678,930 queries (252/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error 1159
i am having the "Error reading packet from server: (server_errno=1159)" replication problem. in searching the archives for others experience replication problems, i came across the suggestion of adding these lines to my.cnf set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 now instead of getting the error every 30 seconds, i get it every hour. is there a way to make it go away forever? why does it happen and what does it mean? replication still seems to work, but i'm anticipating putting these machines into a production environment soon and it makes me nervous. -jsd- sql query (for the filter) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error - failed reading log event (server_errno=1159)
>Description: i set up replication according to the directions in the manual. i have repeatedly ensured that all the tables are synced up and the logs are cleaned before restarting. it seems to work, but the slave is constantly generating these errors: 020711 17:18:10 Error reading packet from server: (server_errno=1159) 020711 17:18:10 Slave: Failed reading log event, reconnecting to retry, log 'rs1-bin.001' position 276 020711 17:18:10 Slave: reconnected to master 'replica@rs1private:3306',replication resumed in log 'rs1-bin.001' at position 276 eventually (30 seconds) it will reconnect and the replication will proceed successfully, but it's not supposed to work like this. how do i find out what server_errno=1159 is? perror doesn't say. >How-To-Repeat: set up replication as i have done. master: [mysqld] user= mysql port= 3306 socket = /tmp/mysql.sock bind-address= 192.168.1.5 datadir = /usr/local/mysql/data skip-locking set-variable= max_user_connections=325 set-variable= key_buffer=128M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 set-variable= thread_concurrency=8 log-bin server-id = 1 slave: [mysqld] user= mysql port= 3306 socket = /tmp/mysql.sock datadir = /usr/local/mysql/data skip-locking set-variable= max_user_connections=325 set-variable= key_buffer=128M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 set-variable= thread_concurrency=8 master-host=rs1private master-user=replica master-password= server-id=2 replicate-ignore-db=mysql >Fix: >Submitter-Id: jsd >Originator:Charlie & >Organization: gamespot >MySQL support: [none | licence | email support | extended email support ] >Synopsis: replication error - server errno 1159 >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.51 (Official MySQL binary) >Environment: System: FreeBSD rs1.gamespot.com 4.5-RELEASE FreeBSD 4.5-RELEASE #0: Mon Jan 28 14:31:56 GMT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1208074 Jan 28 13:11 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jun 28 15:25 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 573760 Jan 28 13:11 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --with-named-z-libs=not-used --disable-shared 'CFLAGS=-O3 -fno-omit-frame-pointer' CXX=gcc CC=gcc 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication - Error reading packet from server: (server_errno=1159)
On Wed, Jul 10, 2002 at 03:13:55PM -0700, Jeff Kilbride wrote: > > Is there a web-based interface for bug reporting? Or is there a way > to use the mysqlbug program when my database machine isn't connected > to the internet? You can submit a but directly to [EMAIL PROTECTED] If your message contains the string "How-To-Repeat:", it'll pass the filter. Just don't tell anyone. :-) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 41 days, processed 925,560,632 queries (255/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication - Error reading packet from server: (server_errno=1159)
Is there a web-based interface for bug reporting? Or is there a way to use the mysqlbug program when my database machine isn't connected to the internet? Thanks, --jeff - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Mark Hughes" <[EMAIL PROTECTED]> Cc: "Nilesh Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 11:39 AM Subject: Re: Replication - Error reading packet from server: (server_errno=1159) > On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote: > > Thanks, I had a look at that and it seems that slave_net_timeout is the > > variable that should be used and this is set to 3600 seconds - however it > > appears that the net_read_timeout is being used and by changing this from > > 30 to 3600 seconds the messages seem to have gone away. > > > > In the 3.23.38 version we are using with our other slaves they never > > timeout and the slave_new_timeout variable doesn't exist - it would > > seem that some code has been introduced to allow the slave connections to > > timeout but is using the net_read_timeout variable rather than the > > slave_net_timeout variable as I would expect. > > Please send in a bug report. Either the docs are wrong or the code > is. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.51: up 41 days, processed 921,560,254 queries (255/sec. avg) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication - Error reading packet from server: (server_errno=1159)
Yeah, I'm getting these errors all the time on 3.23.51, also. I agree that the slave_net_timeout variable is definitely not being paid any attention. However, I'm not comfortable just upping the net_read_timeout without knowing what other effects it might have. --jeff - Original Message - From: "Mark Hughes" <[EMAIL PROTECTED]> To: "Nilesh Shah" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 9:57 AM Subject: RE: Replication - Error reading packet from server: (server_errno=1159) > Thanks, I had a look at that and it seems that slave_net_timeout is the > variable that should be used and this is set to 3600 seconds - however it > appears that the net_read_timeout is being used and by changing this from > 30 to 3600 seconds the messages seem to have gone away. > > In the 3.23.38 version we are using with our other slaves they never > timeout and the slave_new_timeout variable doesn't exist - it would > seem that some code has been introduced to allow the slave connections to > timeout but is using the net_read_timeout variable rather than the > slave_net_timeout variable as I would expect. > > > On Wed, 10 Jul 2002, Nilesh Shah wrote: > > > Set variable net_read_timeout to some bigger value. > > > > http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html > > > > > > Nilesh Shah > > > > > > > > -----Original Message- > > From: Mark Hughes [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 10, 2002 3:36 AM > > To: [EMAIL PROTECTED] > > Subject: Replication - Error reading packet from server: > > (server_errno=1159) > > > > > > Hi, > > > > We updated one of our slave servers to 3.3.51 from 3.23.38 and in common > > with lots of other posts i've seen we're getting lots of errors where > > the > > slave loses the connection to the master: > > > > 020710 7:24:05 Error reading packet from server: (server_errno=1159) > > 020710 7:25:05 Slave: Failed reading log event, reconnecting to retry, > > log 'update.408' position 131306 > > 020710 7:25:05 Slave: reconnected to master > > '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' > > at > > position 131306 > > 020710 7:26:12 Error reading packet from server: (server_errno=1159) > > 020710 7:26:12 Slave: Failed reading log event, reconnecting to retry, > > log 'update.408' position 132434 > > 020710 7:26:12 Slave: reconnected to master > > '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' > > at > > position 132434 > > 020710 7:26:42 Error reading packet from server: (server_errno=1159) > > 020710 7:27:42 Slave: Failed reading log event, reconnecting to retry, > > log 'update.408' position 132434 > > 020710 7:27:42 Slave: reconnected to master > > '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' > > at > > position 132434 > > > > These are happening every 60 seconds or so. > > > > Some info on our architecture > > > > System: Linux int04948-2 2.2.19-6.2.16 #1 Wed Mar 13 13:03:05 EST 2002 > > i686 unknown > > Architecture: i686 > > > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc > > /usr/bin/cc > > GCC: Reading specs from > > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs > > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) > > Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 > > -felide-constructors -fno-exceptions -fno-rtti ' > > LDFLAGS='' > > LIBC: > > lrwxrwxrwx 1 root root 13 Jul 9 16:49 /lib/libc.so.6 -> > > libc-2.1.3.so > > -rwxr-xr-x 1 root root 4105868 Dec 8 2001 > > /lib/libc-2.1.3.so > > -rw-r--r-- 1 root root 20299228 Dec 8 2001 /usr/lib/libc.a > > -rw-r--r-- 1 root root 178 Dec 8 2001 /usr/lib/libc.so > > Configure command: ./configure --disable-shared > > --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static > > --without-berkeley-db --without-innodb --enable-assembler > > --enable-local-infile --with-mysqld-user=mysql > > --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ > > --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin > > --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql > > --infodir=/usr/info --includedir=/usr/include --mandir=/
Re: Replication - Error reading packet from server: (server_errno=1159)
On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote: > Thanks, I had a look at that and it seems that slave_net_timeout is the > variable that should be used and this is set to 3600 seconds - however it > appears that the net_read_timeout is being used and by changing this from > 30 to 3600 seconds the messages seem to have gone away. > > In the 3.23.38 version we are using with our other slaves they never > timeout and the slave_new_timeout variable doesn't exist - it would > seem that some code has been introduced to allow the slave connections to > timeout but is using the net_read_timeout variable rather than the > slave_net_timeout variable as I would expect. Please send in a bug report. Either the docs are wrong or the code is. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 41 days, processed 921,560,254 queries (255/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replication - Error reading packet from server: (server_errno=1159)
Thanks, I had a look at that and it seems that slave_net_timeout is the variable that should be used and this is set to 3600 seconds - however it appears that the net_read_timeout is being used and by changing this from 30 to 3600 seconds the messages seem to have gone away. In the 3.23.38 version we are using with our other slaves they never timeout and the slave_new_timeout variable doesn't exist - it would seem that some code has been introduced to allow the slave connections to timeout but is using the net_read_timeout variable rather than the slave_net_timeout variable as I would expect. On Wed, 10 Jul 2002, Nilesh Shah wrote: > Set variable net_read_timeout to some bigger value. > > http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html > > > Nilesh Shah > > > > -Original Message- > From: Mark Hughes [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 10, 2002 3:36 AM > To: [EMAIL PROTECTED] > Subject: Replication - Error reading packet from server: > (server_errno=1159) > > > Hi, > > We updated one of our slave servers to 3.3.51 from 3.23.38 and in common > with lots of other posts i've seen we're getting lots of errors where > the > slave loses the connection to the master: > > 020710 7:24:05 Error reading packet from server: (server_errno=1159) > 020710 7:25:05 Slave: Failed reading log event, reconnecting to retry, > log 'update.408' position 131306 > 020710 7:25:05 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' > at > position 131306 > 020710 7:26:12 Error reading packet from server: (server_errno=1159) > 020710 7:26:12 Slave: Failed reading log event, reconnecting to retry, > log 'update.408' position 132434 > 020710 7:26:12 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' > at > position 132434 > 020710 7:26:42 Error reading packet from server: (server_errno=1159) > 020710 7:27:42 Slave: Failed reading log event, reconnecting to retry, > log 'update.408' position 132434 > 020710 7:27:42 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' > at > position 132434 > > These are happening every 60 seconds or so. > > Some info on our architecture > > System: Linux int04948-2 2.2.19-6.2.16 #1 Wed Mar 13 13:03:05 EST 2002 > i686 unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc > /usr/bin/cc > GCC: Reading specs from > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) > Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 > -felide-constructors -fno-exceptions -fno-rtti ' > LDFLAGS='' > LIBC: > lrwxrwxrwx 1 root root 13 Jul 9 16:49 /lib/libc.so.6 -> > libc-2.1.3.so > -rwxr-xr-x 1 root root 4105868 Dec 8 2001 > /lib/libc-2.1.3.so > -rw-r--r-- 1 root root 20299228 Dec 8 2001 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Dec 8 2001 /usr/lib/libc.so > Configure command: ./configure --disable-shared > --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static > --without-berkeley-db --without-innodb --enable-assembler > --enable-local-infile --with-mysqld-user=mysql > --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ > --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin > --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql > --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man > '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3 > -felide-constructors -fno-exceptions -fno-rtti ' > CXX=gcc > Perl: This is perl, version 5.005_03 built for i386-linux > > I couldn't find a solution to this, is it a known problem with 3.3.51 ? > > Thanks, > Mark. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Replication - Error reading packet from server: (server_errno=1159)
Set variable net_read_timeout to some bigger value. http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Nilesh Shah -Original Message- From: Mark Hughes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:36 AM To: [EMAIL PROTECTED] Subject: Replication - Error reading packet from server: (server_errno=1159) Hi, We updated one of our slave servers to 3.3.51 from 3.23.38 and in common with lots of other posts i've seen we're getting lots of errors where the slave loses the connection to the master: 020710 7:24:05 Error reading packet from server: (server_errno=1159) 020710 7:25:05 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 131306 020710 7:25:05 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 131306 020710 7:26:12 Error reading packet from server: (server_errno=1159) 020710 7:26:12 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:26:12 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 020710 7:26:42 Error reading packet from server: (server_errno=1159) 020710 7:27:42 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:27:42 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 These are happening every 60 seconds or so. Some info on our architecture System: Linux int04948-2 2.2.19-6.2.16 #1 Wed Mar 13 13:03:05 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 9 16:49 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4105868 Dec 8 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20299228 Dec 8 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 8 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3 -felide-constructors -fno-exceptions -fno-rtti ' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux I couldn't find a solution to this, is it a known problem with 3.3.51 ? Thanks, Mark. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication - Error reading packet from server: (server_errno=1159)
Hi, We updated one of our slave servers to 3.3.51 from 3.23.38 and in common with lots of other posts i've seen we're getting lots of errors where the slave loses the connection to the master: 020710 7:24:05 Error reading packet from server: (server_errno=1159) 020710 7:25:05 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 131306 020710 7:25:05 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 131306 020710 7:26:12 Error reading packet from server: (server_errno=1159) 020710 7:26:12 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:26:12 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 020710 7:26:42 Error reading packet from server: (server_errno=1159) 020710 7:27:42 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:27:42 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 These are happening every 60 seconds or so. Some info on our architecture System: Linux int04948-2 2.2.19-6.2.16 #1 Wed Mar 13 13:03:05 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 9 16:49 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4105868 Dec 8 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20299228 Dec 8 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 8 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3 -felide-constructors -fno-exceptions -fno-rtti ' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux I couldn't find a solution to this, is it a known problem with 3.3.51 ? Thanks, Mark. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication error
Also, if you are doing any 'LOAD DATA INFILE' where the master has access to the file but the slave does not, then this could happen. On most errors, the slave stop replicating and slave status will be turned to OFF. The error file, hostname.err might tell you some thing too. Regards, Bhavin. - Original Message - From: "Cal Evans" <[EMAIL PROTECTED]> To: "Kannan R" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 9:26 AM Subject: RE: replication error > I think somewhere in the manual it warns against running slave and master as > different versions. > > =C= > > -Original Message- > From: Kannan R [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 22, 2002 7:15 AM > To: [EMAIL PROTECTED] > Subject: replication error > > > > Placed At : > > > Hi.. > > I run a replicated mysql server set up..The version i use on the master is > 3.23.49 and on the slave is 3.23.46. > following is the problem I'm facing.. > the binlog postion on the master and the slave are always in sync with each > other..whenever the master has an update then the change in the binlog pos > happens fine and the slave also picks up from the master. and the log > positions > are in sync..but the data never gets copied to the slave.. > > in short the log positions are always in sync with each other but the data > is > never replicated to the server. > > has anybody com across this wierd error..? > any help would be greatly appreciated > > regards > kannan > > > > ** > > Quality Policy > > "To be the best-in-class service provider by practising international > standards > in providing world-class services and end-to-end network solutions." > > ** > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: replication error
I think somewhere in the manual it warns against running slave and master as different versions. =C= -Original Message- From: Kannan R [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 7:15 AM To: [EMAIL PROTECTED] Subject: replication error Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error
Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Obscure replication error message
>Description: Replication stopped on our MySQL 4.0.1-alpha distribution with the error: Error executing query '%': got error 127 from table handler. (This may not be the exact text). Note the '%', which is what this bug report is referring to. Presumably the text of the query should be there. >How-To-Repeat: Unclear. Perhaps cause table corruption on master? >Fix: >Submitter-Id: >Originator:[EMAIL PROTECTED] >Organization: NewsNow Publishing Ltd >MySQL support: none >Synopsis: Obscure error message during replication >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.1-alpha (Source distribution) >Environment: Gigabyte GS-SR101 server, 2xPIII 1GHz processors, 2G RAM, IDE hardware RAID (Promise RAID controller). Debian Linux 'testing' distribution with custom-compiled 2.4.18 kernel. System: Linux pilger 2.4.18 #1 SMP Mon Mar 25 11:16:14 GMT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 18 11:08 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x1 root root 1153816 Mar 24 17:00 /lib/libc-2.2.5.so -rw-r--r--1 root root 2391274 Mar 24 17:00 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 24 17:01 /usr/lib/libc.so -rw-r--r--1 root root 716080 Jan 13 20:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr/local/mysql-3.23.49 --enable-assembler --with-raid --with-unix-socket-path=/tmp --with-innodb --with-libwrap --with-tcp-port=3306 --with-unix-socket-path=/var/run/mysql/mysqld.sock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the master and applied the dump on the slave.and all works fine when i do a show slave status and a show master status. both show me the same same log file position and logfile name.and when any insert happens in the master then the log file postions change on both slave and master.but the count on the slave never increases. i'm not able to find the newly inserted data on the slave even thought the logfile position is in sync with the master.. has anyone faced this problem?? or have I overlooked the obvious.. regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the master and applied the dump on the slave.and all works fine when i do a show slave status and a show master status. both show me the same same log file position and logfile name.and when any insert happens in the master then the log file postions change on both slave and master.but the count on the slave never increases. i'm not able to find the newly inserted data on the slave even thought the logfile position is in sync with the master.. has anyone faced this problem?? or have I overlooked the obvious.. regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication error
On Thu, May 23, 2002 at 10:10:26AM +0530, Kannan R wrote: > > I have come across a wierd error in my replication setup..I run > mysql 3.23.49 on two servers .one is the master and the other the > slave..I have jus one DB with jus a single table in it. I 'm getting > the follwoing error on my slave > > error 'unexpected success or fatal error' on query '' and replication stops.. > > I do a set SQL_SLAVE_SKIP_COUNTER=1; and then a slave start.then > replication starts and immediately after reading a few positions > replication stops with the same error..I hope somebody can thro some > light on this.. Run a "CHECK TABLE" on the problematic table(s) on the master and slave. It's busted on one and not the other. I just had this happen the other day... Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 0 days, processed 799,273 queries (275/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error
Placed At : Hi.. I have come across a wierd error in my replication setup..I run mysql 3.23.49 on two servers .one is the master and the other the slave..I have jus one DB with jus a single table in it. I 'm getting the follwoing error on my slave error 'unexpected success or fatal error' on query '' and replication stops.. I do a set SQL_SLAVE_SKIP_COUNTER=1; and then a slave start.then replication starts and immediately after reading a few positions replication stops with the same error..I hope somebody can thro some light on this.. regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL replication error
That's pretty strange in this situation, we have three slaves being updated from the master, the other two are moving along just fine. This one however can't seem to get past these "duplicate entries". I tried skip_counter=2 and got a different duplicate entry, the possition moving forward again. Incresed skip_counter again... Now the slave is running, but not going anywhere, slave position is like 2.5 million where the master is at about 17 million. Bah, I think i'll just start this slave over again from the base, unfortunately there is a great deal of catching up to do So in skipping these transactions, am I losing data? -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:57 AM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, The problem is that in the replication somewhere an update was taken twice. Adjust the skip to according to the position of the duplicate entry. I have had to skip 100 before in order to get the slave started. First check the binary log and see how many insert statements after the error "path to mysql/bin/mysqlbinlog QBSLIXDB1-bin.log". There had to be a reason why the rep stop syncing ( did you run a myisam check on the master and it removed something??). Check the log to see what transaction failed or duplicated itself. Normally you can skip that transaction on the slave and start up the slave. But if therea are other transaction out of sync after the first failed transaction you will have to keep skipping the transactions. Until the slave kicks up. It kinda hard to tell with out seeing the binary log file as to how many you have to skip or even which one to skip. But as soon as you hit the duplicate transaction witht he skip, the slave will start. Let me know the scoop... -chad On Fri, 22 Feb 2002 11:29:41 -0500 Luc Foisy <[EMAIL PROTECTED]> wrote: > > Chad, this did not work. Though it did do something, the Position jumped > ahead > > mysql> show slave status\G > *** 1. row *** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 >Log_File: QBSLXDB1-bin.029 > Pos: 2596608 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' >Skip_counter: 1 > 1 row in set (0.00 sec) > > mysql> set sql_slave_skip_counter = 1; > Query OK, 0 rows affected (0.01 sec) > > mysql> slave start; > Query OK, 0 rows affected (0.00 sec) > > mysql> show slave status\G > *** 1. row *** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 >Log_File: QBSLXDB1-bin.029 > Pos: 2596630 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' > Skip_counter: 0 > 1 row in set (0.00 sec) > > > -Original Message- > From: chad kellerman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 21, 2002 5:18 PM > To: Luc Foisy > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL replication error > > > > Luc, > > I new to this mailinglist ( this is my first posting) But I have worked a > little with replication. > > Try if the replicator is still down. > > set sql_slave_skip_counter = 1; slave start > > on the slave as long as you are sure the master is ok. > > Let me know is this worked. > > -chad > > > > On Thu, 21 Feb 2002 15:48:08 -0500 > Luc Foisy <[EMAIL PROTECTED]> wrote: > > > Would anyone be able to tell me why this happened, and how I could fix it? > > > > mysql> show slave status\G > > *** 1. row *** > > Master_Host: 209.217.92.34 > > Master_User: repslave2 > > Master_Port: 3306 > > Connect_retry: 60 > >Log_File: QBSLXDB1-bin.029 > > Pos: 2596608 > > Slave_Running: No > > Replicate_do_db: qbslive > > Replicate_ignore_db: > > Last_errno: 1062 > > Last_error: error 'Duplicate entry '1376034' for key 1' on query &g
Re: MySQL replication error
Luc, The problem is that in the replication somewhere an update was taken twice. Adjust the skip to according to the position of the duplicate entry. I have had to skip 100 before in order to get the slave started. First check the binary log and see how many insert statements after the error "path to mysql/bin/mysqlbinlog QBSLIXDB1-bin.log". There had to be a reason why the rep stop syncing ( did you run a myisam check on the master and it removed something??). Check the log to see what transaction failed or duplicated itself. Normally you can skip that transaction on the slave and start up the slave. But if therea are other transaction out of sync after the first failed transaction you will have to keep skipping the transactions. Until the slave kicks up. It kinda hard to tell with out seeing the binary log file as to how many you have to skip or even which one to skip. But as soon as you hit the duplicate transaction witht he skip, the slave will start. Let me know the scoop... -chad On Fri, 22 Feb 2002 11:29:41 -0500 Luc Foisy <[EMAIL PROTECTED]> wrote: > > Chad, this did not work. Though it did do something, the Position jumped > ahead > > mysql> show slave status\G > *** 1. row *** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 >Log_File: QBSLXDB1-bin.029 > Pos: 2596608 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' >Skip_counter: 1 > 1 row in set (0.00 sec) > > mysql> set sql_slave_skip_counter = 1; > Query OK, 0 rows affected (0.01 sec) > > mysql> slave start; > Query OK, 0 rows affected (0.00 sec) > > mysql> show slave status\G > *** 1. row *** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 >Log_File: QBSLXDB1-bin.029 > Pos: 2596630 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' >Skip_counter: 0 > 1 row in set (0.00 sec) > > > -Original Message- > From: chad kellerman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 21, 2002 5:18 PM > To: Luc Foisy > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL replication error > > > > Luc, > > I new to this mailinglist ( this is my first posting) But I have worked a > little with replication. > > Try if the replicator is still down. > > set sql_slave_skip_counter = 1; slave start > > on the slave as long as you are sure the master is ok. > > Let me know is this worked. > > -chad > > > > On Thu, 21 Feb 2002 15:48:08 -0500 > Luc Foisy <[EMAIL PROTECTED]> wrote: > > > Would anyone be able to tell me why this happened, and how I could fix it? > > > > mysql> show slave status\G > > *** 1. row *** > > Master_Host: 209.217.92.34 > > Master_User: repslave2 > > Master_Port: 3306 > > Connect_retry: 60 > >Log_File: QBSLXDB1-bin.029 > > Pos: 2596608 > > Slave_Running: No > > Replicate_do_db: qbslive > > Replicate_ignore_db: > > Last_errno: 1062 > > Last_error: error 'Duplicate entry '1376034' for key 1' on query > > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' > >Skip_counter: 0 > > > > err_log > > 020221 14:21:12 mysqld started > > /usr/local/libexec/mysqld: ready for connections > > 020221 14:21:14 Slave: connected to master > '[EMAIL PROTECTED]:3306', > > replication started in log 'QBSLXDB1-bin.029' at position > > 2596608 > > ERROR: 1062 Duplicate entry '1376034' for key 1 > > 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG > > (CreateStamp) VALUES (NOW())' > > 020221 14:21:14 Error running query, slave aborted. Fix the problem, and > > re-start the slave thread with "mysqladmin start-slave". We s > > topped at log 'QBSLXDB1-b
RE: MySQL replication error
Chad, this did not work. Though it did do something, the Position jumped ahead mysql> show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 1 1 row in set (0.00 sec) mysql> set sql_slave_skip_counter = 1; Query OK, 0 rows affected (0.01 sec) mysql> slave start; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596630 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 1 row in set (0.00 sec) -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:18 PM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu, 21 Feb 2002 15:48:08 -0500 Luc Foisy <[EMAIL PROTECTED]> wrote: > Would anyone be able to tell me why this happened, and how I could fix it? > > mysql> show slave status\G > *** 1. row *** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 >Log_File: QBSLXDB1-bin.029 > Pos: 2596608 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' >Skip_counter: 0 > > err_log > 020221 14:21:12 mysqld started > /usr/local/libexec/mysqld: ready for connections > 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.029' at position > 2596608 > ERROR: 1062 Duplicate entry '1376034' for key 1 > 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG > (CreateStamp) VALUES (NOW())' > 020221 14:21:14 Error running query, slave aborted. Fix the problem, and > re-start the slave thread with "mysqladmin start-slave". We s > topped at log 'QBSLXDB1-bin.029' position 2596608 > 020221 14:21:14 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.029' at position 2596608 > > > Luc Foisy > > Technical Magic - www.technical-magic.com > 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 > Phone: (613) 829-7117 Fax: (613) 596-5096 > E-Mail: [EMAIL PROTECTED] > > <<<<< Fulfilling the Promise of Technology >>>>> > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL replication error
Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu, 21 Feb 2002 15:48:08 -0500 Luc Foisy <[EMAIL PROTECTED]> wrote: > Would anyone be able to tell me why this happened, and how I could fix it? > > mysql> show slave status\G > *** 1. row *** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 >Log_File: QBSLXDB1-bin.029 > Pos: 2596608 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' >Skip_counter: 0 > > err_log > 020221 14:21:12 mysqld started > /usr/local/libexec/mysqld: ready for connections > 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.029' at position > 2596608 > ERROR: 1062 Duplicate entry '1376034' for key 1 > 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG > (CreateStamp) VALUES (NOW())' > 020221 14:21:14 Error running query, slave aborted. Fix the problem, and > re-start the slave thread with "mysqladmin start-slave". We s > topped at log 'QBSLXDB1-bin.029' position 2596608 > 020221 14:21:14 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.029' at position 2596608 > > > Luc Foisy > > Technical Magic - www.technical-magic.com > 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 > Phone: (613) 829-7117 Fax: (613) 596-5096 > E-Mail: [EMAIL PROTECTED] > > < Fulfilling the Promise of Technology > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL replication error
Would anyone be able to tell me why this happened, and how I could fix it? mysql> show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 err_log 020221 14:21:12 mysqld started /usr/local/libexec/mysqld: ready for connections 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.029' at position 2596608 ERROR: 1062 Duplicate entry '1376034' for key 1 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020221 14:21:14 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We s topped at log 'QBSLXDB1-bin.029' position 2596608 020221 14:21:14 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.029' at position 2596608 Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 829-7117 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] < Fulfilling the Promise of Technology > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error..
Placed At : Hi.. I have set up a new slave host for my mysql DB..I have just done a create DB on it and have setup all replication parameters in my /etc/my.cnf..but when i start the slave i get the following error..has anybody come across this..any help woukd be great.. 020207 18:47:15 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 48 020207 18:47:15 Slave: reconnected to master 'replicate@mysqlmaster.:3306',replication resumed in log 'FIRST' at position 48 020207 18:47:15 Error reading packet from server: bogus data in log event (read_errno 0,server_errno=65535) 020207 18:48:15 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 48 020207 18:48:15 Slave: reconnected to master 'replicate@mysqlmaster:3306',replication resumed in log 'FIRST' at position 48 020207 18:48:15 Error reading packet from server: bogus data in log event (read_errno 0,server_errno=65535) regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error..
Placed At : Hi.. I have set up a new slave host for my mysql DB..I have just done a create DB on it and have setup all replication parameters in my /etc/my.cnf..but when i start the slave i get the following error..has anybody come across this..any help woukd be great.. 020207 18:47:15 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 48 020207 18:47:15 Slave: reconnected to master 'replicate@mysqlmaster.:3306',replication resumed in log 'FIRST' at position 48 020207 18:47:15 Error reading packet from server: bogus data in log event (read_errno 0,server_errno=65535) 020207 18:48:15 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 48 020207 18:48:15 Slave: reconnected to master 'replicate@mysqlmaster:3306',replication resumed in log 'FIRST' at position 48 020207 18:48:15 Error reading packet from server: bogus data in log event (read_errno 0,server_errno=65535) regards kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win32 - replication - Error 1133
Hi everybody, I use Replication on a windows NT4 Server. There are 1 master and 2 slaves, all on the same machine. One slave is started with the option skip-name-resolve, not the other. For the 2 slaves : master-host=localhost When adding a user (MYSQL.User), the replication is OK but, when I use GRANT, I get a 1133 error. Let's have a look on a slave : MYSQL.User table : localhost | jkasas | 1896f443280395b3 And what I do and get : mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; ERROR 1133: Can't find any matching row in the user table Personnally, I don't understand why. Does anyone understand ? Thx for the answers. -- Frederic BALU - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win32 - replication - Error 1133
Hi everybody, I use Replication on a windows NT4 Server. There are 1 master and 2 slaves, all on the same machine. One slave is started with the option skip-name-resolve, not the other. For the 2 slaves : master-host=localhost When adding a user (MYSQL.User), the replication is OK but, when I use GRANT, I get a 1133 error. Let's have a look on a slave : MYSQL.User table : localhost | jkasas | 1896f443280395b3 And what I do and get : mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; ERROR 1133: Can't find any matching row in the user table Personnally, I don't understand why. Does anyone understand ? Thx for the answers. -- Frederic BALU - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Errant (Replication) error: "ERROR 1200: The server is not configured as slave"
Hi All, Sorry if I'm missing something totally daft here... I've got my master and slave hosts (both runng MySQL 3.23.36) configured roughly as-per the HOWTO, ( as follows ) to replicate the "test" database, but not the "mysql" database [btw. it's not clear from the docs that if you omit both binlog-ignore-db and binlog-do-db whether all, or none of the databases are replicated.. what is the actual case there? ] Now, I'm not sure I've got the 'master-port' setting on the slave right, infact I think it's wrong, because that's the client connection port, but netstat or the docs wouldn't tell me a more likely port number, so I guessed. (is that the wrong port?). So either I have the wrong port, or there's a bug, because (and nothing appears in the .err file on the slave or master about this) when I do a "SLAVE START" on the slave, it goes: "mysql> slave start; ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO" ... even when I've configured the slave just as it suggests... So, could someone please let me know if I'm being stupid, or if it's MySQL that's at fault here? Thanks in advance. Yours, Kev. Master: cat /etc/my.cnf [mysqld] log-bin=/var/lib/mysql/replication server-id=2 binlog-do-db=test binlog-ignore-db=mysql mysql> show full processlist; +-+--+---+--+-+--+---+-- -+ | Id | User | Host | db | Command | Time | State | Info | +-+--+---+--+-+--+---+-- -+ | 117 | sendmail | localhost | sendmail | Sleep | 28 | | NULL | | 118 | sendmail | localhost | sendmail | Sleep | 28 | | NULL | | 121 | sendmail | localhost | sendmail | Sleep | 28 | | NULL | | 127 | root | localhost | NULL | Query | 0| NULL | show full pro cesslist | +-+--+---+--+-+--+---+-- -+ 4 rows in set (0.00 sec) mysql> show master status; +-+--+--+--+ | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | replication.002 | 147 | test,test| mysql,mysql | +-+--+--+--+ 1 row in set (0.00 sec) mysql> exit Bye Slave: [mysql] server-id=4 master-host=lestat.ore.org master-user=replicate master-password=splitter log-slave-updates=/var/lib/mysql/slave-updates.log master-port=3306 mysql> show full processlist; ++--+---+--+-+--+---+--- + | Id | User | Host | db | Command | Time | State | Info | ++--+---+--+-+--+---+--- + | 1 | root | localhost | test | Query | 0| NULL | show full processlist | ++--+---+--+-+--+---+--- + 1 row in set (0.00 sec) mysql> show slave status -> ; ++-+-+---+-+ -+---+-+-++- ---+--+ | Master_Host| Master_User | Master_Port | Connect_retry | Log_File| Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last _error | Skip_counter | ++-+-+---+-+ -+---+-+-++- ---+--+ | lestat.ore.org | replicate | 3306| 60| replication.002 | 73 | No| | | 0 | | 0| ++-+-+---+-+ -+---+-+-++- ---+--+ 1 row in set (0.00 sec) mysql> -- "Life is the sieve through which my anarchy strains, resolving itself into words" Kev Green, aka. Kyrianwww.ore.org -- Bad Religion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication error message question
I have two mysql servers, setup to replicate each other. However, every so often, one or both starts logging; 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec and this quickly fills up the disk. Is this a bug, or could I have things setup incorrectly ? Usually, the only fix is to remove all .bin and .err and the master.info, and copy /var/lib/mysql to the client, and restart both mysql servers (not ideal, as you can imagine). John -- When I say 'free', I mean 'free': free from bond, of chain or command: to go where you will, even to Mordor, Saruman, if you desire. " -- Gandalf, paraphrasing the choice between Free and Non-free software - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php