RE: FW: URGENTE - Replication...... - mySql
Sasha, I tried the bug script to send the bug, but didn't have time to go thru the problems (looking for X, then couldn't open on vi). Reading that script I thought I saw support@..so I went ahead and send to that list. I knew it was a paid support list, but I didn't have any question, only let you know that it is a bug and I thought it justified the email to that list. - Regards, Rod~ -Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:56 PM To: Rodrigo Zerlotti; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: FW: URGENTE - Replication.. - mySql On Monday 10 September 2001 09:43, Rodrigo Zerlotti wrote: here it is... - Regards, Rodgrigo: Thanks for a bug report. We will try to get this fixed in 3.23.43. Next time, please write to [EMAIL PROTECTED] when you find a bug and have a test case for it. This address ([EMAIL PROTECTED]) is reserved for paying customers. Joshua and other users: Please do not advise others to use [EMAIL PROTECTED] to users without a support contract as a way to get personal help from MySQL AB when other methods do not work. We usually reply to such messages with a template, and in some near future will have a filter that will check for valid support contract info and reply with a template if it is not present. We have also had a problem with users asking a support question on [EMAIL PROTECTED] after they got no answer on [EMAIL PROTECTED] This is also against the rules. [EMAIL PROTECTED] is reserved for discussion of internal ( not client application) MySQL development, and should not be used as a way to get free support from developers from MySQL AB and experienced users that subscribe to the list. If you have sent a question to the general list [EMAIL PROTECTED]) and nobody answers it, you should do one or more of the following: * consider purchasing a support contract at https://order.mysql.com/ * re-state the question providing more relevant information, or in other words, make it easier to answer it * spend some time studying the manual, the source code, and doing some troubleshooting to try to understand how things work * if you think you have found a bug, follow instructions at http://www.mysql.com/doc/B/u/Bug_reports.html to create a repeatable bug report. Once you have a test case, you can write it to [EMAIL PROTECTED] - if you have a test case, we will work with you on the bug until it is fixed regardless of whether you have a support contract or not. The only difference is that without a support contract, we ask you to do the homework and give us a full test case. In short, we provide free code, but we cannot afford to give free support to go along. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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 again.....
It has been a interesting experience... but it is not reliable enough, unless I am doing something wrong... I have MySql() on Mandrake. Installed 1 master 2 slaves. One slave do a full backup and the other partial (some tables only). All work fine, except when I get an error and it tries to reconnect: 010911 12:12:33 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 010911 12:12:33 Slave: Failed reading log event, reconnecting to retry, log 'ear-bin.001' position 747 010911 12:12:34 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'earth-bin.001' at position 747 Seems like by looking at the last message the replication is fine. I check show slave status and all seems fine, BUT replication is stops to work, i.e. it won't move from that position anymore (in this case 747) Is it a bug on this version. Am I doing something wrong? How can I monitor if replication stops to work?? Any help would be very appreciated. - Regards, Rod~ - 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: URGENTE - Replication......
Ok, no answers yet, but more information: master log: 010909 3:15:36 failed in send_file() : Failed reading file name Should the same file used on the master for the load inline be already on the slave? Or MySql takes care of moving it for us... I try to move myself before the sql and didn't work... same error Also, ignore table doesn't work when table on the inline query. I tried that and the slave tried to run the sql Configuration: Mandrake + Mysql 3.23.36 Please help, I would hate to leave replication just because this... - Regards, Rod~ -Original Message- From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 08, 2001 7:58 PM To: Mysql@Lists. Mysql. Com Subject: URGENTE - Replication.. Importance: High Can not find the problem and we are down! Here the question again (Any advice on replication of LOAD DATA INFILE is very appreciated.) I setup a mster-slave. My master does a lot of : LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE TABLE-NAME FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; Notice i am not using LOCAL because the docs states: LOAD DATA INFILE will be handled properly as long as the file still resides on the master server at the time of update propagation. LOAD LOCAL DATA INFILE will be skipped. But on Slave I am getting: Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load data infile Ideas Where should I look??? - Regards, Rod~ - 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: URGENTE - Replication...... - mySql
Ok, got no emails, but I believe I found the problem , which I would consider a bug. My LOAD DATA INFILE query was running from a bash script, which was executing the query thru a command line mysql call. The LOAD DATA was loading the file into 2 tables on 2 different databases. Something like: LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE database1.TABLE-NAME1 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE database2.TABLE-NAME2 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; Notice that both tables was qualified by the database, 1 and 2. Of course, to run the command line, I had to logon, choosing one of the databases (they have permissions to update each other). The problem is that it would work on the master, but it was executing (looking at log-bin) the query not qualified. The second statement would look like: LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE TABLE-NAME2 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; and TABLE_NAME2 was not on database1, where I logged on. I believe this is bug. The replication engine should keep the qualification on the table name. - Regards, Rod~ -Original Message- From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 09, 2001 3:57 AM To: Mysql@Lists. Mysql. Com Subject: RE: URGENTE - Replication.. Importance: High Ok, no answers yet, but more information: master log: 010909 3:15:36 failed in send_file() : Failed reading file name Should the same file used on the master for the load inline be already on the slave? Or MySql takes care of moving it for us... I try to move myself before the sql and didn't work... same error Also, ignore table doesn't work when table on the inline query. I tried that and the slave tried to run the sql Configuration: Mandrake + Mysql 3.23.36 Please help, I would hate to leave replication just because this... - Regards, Rod~ -Original Message- From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 08, 2001 7:58 PM To: Mysql@Lists. Mysql. Com Subject: URGENTE - Replication.. Importance: High Can not find the problem and we are down! Here the question again (Any advice on replication of LOAD DATA INFILE is very appreciated.) I setup a mster-slave. My master does a lot of : LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE TABLE-NAME FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; Notice i am not using LOCAL because the docs states: LOAD DATA INFILE will be handled properly as long as the file still resides on the master server at the time of update propagation. LOAD LOCAL DATA INFILE will be skipped. But on Slave I am getting: Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load data infile Ideas Where should I look??? - Regards, Rod~ - 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 problem - infile
I setup a mster-slave. My master does a lot of : LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE TABLE-NAME FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; I changed from LOCAL because the docs states: LOAD DATA INFILE will be handled properly as long as the file still resides on the master server at the time of update propagation. LOAD LOCAL DATA INFILE will be skipped. But on Slave I am getting: Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load data infile Ideas - Regards, Rod~ - 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
URGENTE - Replication......
Can not find the problem and we are down! Here the question again (Any advice on replication of LOAD DATA INFILE is very appreciated.) I setup a mster-slave. My master does a lot of : LOAD DATA INFILE 'path-to-file' REPLACE INTO TABLE TABLE-NAME FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; Notice i am not using LOCAL because the docs states: LOAD DATA INFILE will be handled properly as long as the file still resides on the master server at the time of update propagation. LOAD LOCAL DATA INFILE will be skipped. But on Slave I am getting: Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load data infile Ideas Where should I look??? - Regards, Rod~ - 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
Delete ... where col not in (select...)
Is there a way to build a similar SQL that would work on mySql (I use this on Oracle): delete from TABLE_NAME where COL1 not in ( select distinct COL1 from TABLE_NAME where COL2 ='SOMETHING') - Regards, Rod~ - 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: Multiple column value
I don't see another way other than like since you build the value on a free form, i.e. you determined the separator ,. You can either get a dif. form to help on your selection or just do a: select ID from TABLE_NAME where ID = $value || ID like '$value,%' || ID like '%,$value,%' || ID like '%,$value' - Regards, Rod~ -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Tuesday, July 10, 2001 10:50 PM To: Rodrigo Zerlotti Cc: [EMAIL PROTECTED] Subject: Re: Multiple column value Thanks, but this won't work, we need an exact match of one of the multiple values, if there is one exact match of any of the values within the column, then we pull that row out to be displayed. so it has to be an exact match. On Tue, 10 Jul 2001 23:05:02 -0500, Rodrigo Zerlotti [EMAIL PROTECTED] wrote: select ID from TABLE_NAME where ID like '%value%' or I misunderstood the question. - Regards, Rod~ -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Tuesday, July 10, 2001 10:38 PM To: [EMAIL PROTECTED] Subject: Multiple column value Hi All, Quick question. We need to store a multiple value in a table column as we don't know how many values at the time of submission there could be. The column would be storing a group of values something like this: Column 'ID' IM34456,IM34485,IM34478 or it could be more or less. So if we put the data into one column what would be the best way to extract the row if there's is a match of one of the values in the column. We need to build a query to select a row that matches one of the values. They would enter a single value like IM34485 into a form, then I need to build a query that will check all values in the ID column so we can then extract the entire row if one of the ID values match. THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
bug report - docs
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: INSTALL-BIN file has errors: on the direction shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin/ shell bin/safe_mysqld --user=mysql : it should be chown -R mysql /usr/local/mysql/data instead "var" How-To-Repeat: see docs Fix: Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none Synopsis: docs wrong Severity: serious Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.36 (Official MySQL binary) - 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