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 vegiv...@tuxera.bewrote: On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S nagaraj@gmail.comwrote: **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 nagaraj@gmail.com 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 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
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
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
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
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 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]
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]
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]
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
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
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 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
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 (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
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='not shown here', master_password='not shown here', 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
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 21 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
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 21 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
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 21 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
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 21 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
- 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 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
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 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
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)
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)
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=/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
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)
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
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
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
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