Re: mysql_prepare is not built in 4.1.1a?
Yueming Xu wrote: We downloaded 4.1.1a build, but all the new APIs for transaction and prepared statements are missing from the libmysql.dll. Is there a build for 4.1.x that we can use to test these APIs? Thanks. _ MSN Toolbar provides one-click access to Hotmail from any Web page FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/ HI! Prepared statements are definitely in libmysql.dll. Try to run our client_test.c program which is in our distro. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysterious can't connect error message in our logs(2)
Sasha Pachev writes: Jigal van Hemert wrote: It's a bug. I would recommend to patch libmysql.c for now until MySQL developers fix it. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ Our client side uses select() but only when waiting for data, and not on teh connections to the socket. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus Meet the MySQL at User Conference ! (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlgui problem - can't connect via tmp/mysql.sock
Dmitry Rusak writes: Hi! I have a problem using musqlgui-1.7.2 under FreeBSD 4.9 STABLE. It Can't connect to mysql server via tmp/mysql.sock My setup: 1) mysql is installed in /usr/local/mysql data base directory - /usr/local/mysql/data socket directory - /usr/local/mysql/tmp/mysql.sock 2) currenlty i am using FreeBSD 4.2 static binary of MySQLGUI 1.7.2 3) I have created: /etc/my.cnf /etc/.my.cnf ~/my.cnf ~/.my.cnf /usr/local/etc/my.cnf /usr/local/etc/.my.cnf with the same content: --- [client] port = 3306 host = localhost user = root [client_fltk] client_file=~/.mysql.options queries_file=~/.mysql_history history_length=100 database=my_db - (this db exists!) - The problem: When executing mysqlgui it first asks me for a password. I assume it should be the root password (or not? actually in my case mysql is configured to work under mysql user, but i tryed password for this user also). I am entering the password and then it says in Info line at the bottom of window that Can't connect to mysql server via tmp/mysql.sock. When i am pressing on + to see full message log it shows the lines that options are successifully read from options file and so on - so, no problem here. In options of mysqlgui i have localhost, port 3306. There is no problem with running ordinary mysql client. I think probably because mysql server has been installed not in standard directory, it can not find it. So, maybe there is a chance to configure the path to mysql? Or something other? Best regards, Dmitry First of all, please use version 1.7.5. 1.7.2 has too many bugs. You should add socket option under [client] and you should put /usr/local/mysql/tmp/mysql.sock there as well as under [mysqld] options header. You should also make /usr/local/mysql/tmp/ directory scannable etc .. by all, plus with temporary attribute. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus Meet the MySQL at User Conference ! (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SubQuery bug in 4.1
Daniel Kiss writes: Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should work. But it does not, and sets the Value fields to incorrect values. update main set Value = (select SubValue from sub where main.ID = sub.mainID order by KeyDate desc limit 1) Any ideas? Thanks, Dan Can you try (with 4.1.1 from our BK tree): update main set Value = (select max(SubValue) from sub); There should also be a WHERE clause for update statement or all rows will be updated. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySql BUG
Dyego Souza do Carmo writes: Hi, Try to do the following: [skip] - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into my eyes Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] Hi! Your attachment was stripped off. Please upload it to: ftp://support.mysql.com:/pub/mysql/secret and let us know it's filename. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re[2]: mySql BUG
Dyego Souza do Carmo writes: Sinisa: Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: ---[inicio]-- The FileName is l5.zip ---[cortar]-- - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into my eyes Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] Thanks. We shall take a look at it. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator ___/ www.mysql.com Larnaca, Cyprus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem starting mysql server
Rehaz Golamnobee writes: Hi I have just upgraded my MySQL from version 3.23 to 4.0.13. However I cannot start the server. When I type mysqld_safe I get the following : [1] 1730 Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql 030529 11:10:51 mysqld ended [1]+ Done mysqld_safe When I type mysql at the Linux:/# prompt, I get the following : Error 2002 : Can't connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock' (2). I looked for the file mysql.sock in /var/lib/mysql/ but it was not there. I used Find File in Linux and it could not find mysql.sock anywhere on the system. I remember that the file mysql.sock was found at /var/lib/mysql/ in version 3.23. Can you please help ? These are the details of my system : SuSe Linux O.S version 8.1 Professional Kernel version 2.4.19 Machine - Pentium 4 2.00 GHz (Dell optiplex GX260) Thank you Rehaz. This list, [EMAIL PROTECTED], is dedicated to repeatable test case, and this is not the one. You can not connect as the server is not running, and all possible causes for problems in starting MySQL server are fully explained in our manual. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Doing select @a does not work in replication.
Scott Wong writes: I'm not sure if this is a feature or not so i'll just report it as a possible bug. I couldnt find anything in the documentation. How to repeat: create table t1(id int); insert into t1 set id=0; select @a:max(id)+1 from t1; insert into t1 [EMAIL PROTECTED]; Result on master: mysql select * from t1; +--+ | id | +--+ |0 | |1 | +--+ 2 rows in set (0.00 sec) result on slave: mysql select * from t1; +--+ | id | +--+ |0 | | NULL | +--+ Binlog shows insert into t1 set [EMAIL PROTECTED]; on both master and slave. Fix:? Thank you for your time, Scott Wong Meiko America, INC Hi! It is actually neither. Replication with user variables is working only in version 4.1. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Alias Error in a select statement
[EMAIL PROTECTED] writes: Description: Hello, When I run the following query: Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10 I get the following error: 'The column 'MiCantidad' in field list is unknown' So, Can I reference to a column by its alias in a select statement? Thanks in advance, Rafa How-To-Repeat: Select Can as MiCantidad, MiCantidad * 2 from stocks limit 10 Hi! This is not a bug. You can not reference an alias in the select list. You can do it freely in WHERE, ON , GROUP BY and other clauses. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld dies
Sorry, we do not accept bug reports in HTML format. Please re-send it in plain text format. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql hangs on multi table update on innodb table.
Scott Wong writes:
Version: Mysql 4.0.10-gamma
Description: Mysql hangs and possibly can not recover from a query on an innodb
table.
How to Repeat :
drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT PRIMARY KEY, parent_id INT,
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE CASCADE
ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
update parent,child set parent.id=parent.id+1, child.parent_id=parent.id+1;
Thank you for your time.
Scott Wong,
Meiko America, INC
Hi!
Thank you for your bug report.
It helped us fix a bug in multi-table updates with InnoDB. A fix will
come in 4.0.12, which should come out in a week.
This is a patch:
= sql/sql_class.h 1.141 vs edited =
*** /tmp/sql_class.h-1.141-18011Wed Mar 5 19:43:53 2003
--- edited/sql/sql_class.h Tue Mar 11 18:34:13 2003
***
*** 831,837
uint table_count;
Copy_field *copy_field;
enum enum_duplicates handle_duplicates;
! bool do_update, trans_safe, transactional_tables, log_delayed;
public:
multi_update(THD *thd_arg, TABLE_LIST *ut, ListItem *fields,
--- 831,837
uint table_count;
Copy_field *copy_field;
enum enum_duplicates handle_duplicates;
! bool do_update, trans_safe, transactional_tables, log_delayed, on_the_fly;
public:
multi_update(THD *thd_arg, TABLE_LIST *ut, ListItem *fields,
= sql/sql_update.cc 1.75 vs edited =
*** /tmp/sql_update.cc-1.75-18011 Wed Feb 19 16:08:27 2003
--- edited/sql/sql_update.ccTue Mar 11 18:59:11 2003
***
*** 413,419
:all_tables(table_list), update_tables(0), thd(thd_arg), tmp_tables(0),
updated(0), found(0), fields(field_list), values(value_list),
table_count(0), copy_field(0), handle_duplicates(handle_duplicates_arg),
!do_update(1), trans_safe(0)
{}
--- 413,419
:all_tables(table_list), update_tables(0), thd(thd_arg), tmp_tables(0),
updated(0), found(0), fields(field_list), values(value_list),
table_count(0), copy_field(0), handle_duplicates(handle_duplicates_arg),
!do_update(1), trans_safe(0), on_the_fly(1)
{}
***
*** 538,549
main_table=join-join_tab-table;
trans_safe= transactional_tables= main_table-file-has_transactions();
log_delayed= trans_safe || main_table-tmp_table != NO_TMP_TABLE;
!
/* Create a temporary table for all tables after except main table */
for (table_ref= update_tables; table_ref; table_ref=table_ref-next)
{
TABLE *table=table_ref-table;
! if (table != main_table)
{
uint cnt= table_ref-shared;
ORDER group;
--- 538,552
main_table=join-join_tab-table;
trans_safe= transactional_tables= main_table-file-has_transactions();
log_delayed= trans_safe || main_table-tmp_table != NO_TMP_TABLE;
! #ifdef HAVE_INNOBASE_DB
! if (main_table-db_type == DB_TYPE_INNODB)
! on_the_fly=0;
! #endif
/* Create a temporary table for all tables after except main table */
for (table_ref= update_tables; table_ref; table_ref=table_ref-next)
{
TABLE *table=table_ref-table;
! if (!on_the_fly || table != main_table)
{
uint cnt= table_ref-shared;
ORDER group;
***
*** 623,629
uint offset= cur_table-shared;
table-file-position(table-record[0]);
! if (table == main_table)
{
table-status|= STATUS_UPDATED;
store_record(table,1);
--- 626,632
uint offset= cur_table-shared;
table-file-position(table-record[0]);
! if (on_the_fly table == main_table)
{
table-status|= STATUS_UPDATED;
store_record(table,1);
***
*** 716,722
for (cur_table= update_tables; cur_table ; cur_table= cur_table-next)
{
table = cur_table-table;
! if (table == main_table)
continue; // Already updated
org_updated= updated;
--- 719,725
for (cur_table= update_tables; cur_table ; cur_table= cur_table-next)
{
table = cur_table-table;
! if (on_the_fly table == main_table)
continue; // Already updated
org_updated= updated;
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.com
Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
RE: Mysql hangs on multi table update on innodb table.
Scott Wong writes: Hi, I havent received any response on this so i'll send this again. I did check again with 4.0.11-gamma and the problem is still there. Regards, Scott Hi! This will require a major re-write in multi table update's and will not come up very soon. But should come up with the end of this month. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: mysqld got signal 11; This could be because you hit a bug ....
Mariella Di Giacomo writes: Hello, I have followed your suggestion. I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. I have started the mysqld program as root I have specified the core-file in the /etc/my.cnf file. Other info that could be interesting in the /etc/my.cnf are HI! Causes of the crashes could be many, among the others: * using 2.9 binary on Solaris 2.8 !! Please use 2.8 binary, we have it * setting sort and record buffers to 1K !! Please set them at 1M There are many other things that could be improved, but that can be done when and if you become a registered customer. I have looked for the core file, but I couldn't find it, even though in the error log it says Writing a core file. Make sure all ulimit values are OK, including the one for core file. Does this give you any clue about what is causing the error ? Could you help please about the core file Do I need to specify the option differently ? Thanks in advance for your help, Mariella Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: mysqld got signal 11; This could be because you hit a bug ....
Mariella Di Giacomo writes: Hi, I will install the 2.8 debug version. The reason why I set setting sort and record buffers to 1K is because with a few tests I have noticed that I was getting a better response time for queries. The limit for the core file was unlimited. I will look into customer support. Mariella Please also make sure that mysqld is run under mysql user and that all UNIX permissions are fine. BTW 4.0.11 is out with some fixes for OPTIMIZE table. Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: mysqld got signal 11; This could be because you hit a bug ....
Mariella Di Giacomo writes: Hi, I would prefer the debug version which the latest I believe is the 4.0.10. The same error I get it when I run ALTER TABLES or I try to insert data into tables. I will try and let you know. Thanks, Mariella 4.0.11 will be quite soon, but your problems indicate that it is some system setup error, which would be very fast diagnosed if we would login to your system. Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Native XADataSource for MySQL
On Wed, 19 Feb 2003 10:43:49 -0600 Frank Gates [EMAIL PROTECTED] wrote: Hello, Earlier I asked Mark about XA and Connector/J. He said that it was dropped from the 3.0 releases because MySQL doesn't natively support XA, but when it does he will add it back in. Mark suggested that I ask for XA on these lists if I wish to expedite it in the pipeline. I am raising the flag here for XA, but not to exceed work on stored procedures and views. I believe that two-phase commit with XA should be natively supported so that it will compete effectively with other database providers in those instances where two-phase is valuable. My personal requirement for it is minimal at this time. I am developing an application server development framework (which is MySQL-centric) and so have need to support XA connection pooling and resources. I had already developed an XAResource-wrapper for PooledConnection's when I discovered that XA was dropped from Connector/J 3.0. It is a small task for me to wrap ConnectionPoolDataSource's with an XADataSource implementation for now. But I do express my desire for native XA in MySQL. (The app server framework is intended to build customizable containers as well as EJB containers. The motive for this framework is that there are some applications that fit the application server model but not the EJB model or only part of the J2EE model.) Frank Gates [EMAIL PROTECTED] HI! We shall definitely add support for XA, but I doubt it will be before 6.0. We have so many other features to implement first. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Bug with innodb multi-table delete and foreign keys.
Scott Wong writes: Hi sinisa, I tried this patch. It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on compile so i went ahead and added to include/mysqld_error.h for testing. i'm not sure if it's the right place or the right error code but it made mysql compile *** 256a257 #define ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB 1238 *** then ran the query again. drop table parent; drop table child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT PRIMARY KEY, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE ) TYPE=INNODB; insert into parent set id=1; insert into child set id=1, parent_id=1; delete parent,child from parent,child where parent.id=child.parent_id; now i get ERROR 2013: Lost connection to MySQL server during query mysql Number of processes running now: 0 030213 15:54:20 mysqld restarted regards, Scott Wong Yes, of course. I have sent just an excerpt. Full patch is rather big and is not appropriate for mail. Plus I am still improving it in order to work under all conditions. Full patch will be in 4.0.11. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: A bug with innodb and non innodb multi-table delete.
Scott Wong writes: Version: Mysql 4.0.10-gamma Description: Mysql client loses connection when doing a multi-table delete if one table is innodb and the other is myISAM. How to Repeat : drop table parent; drop table child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB ; CREATE TABLE child(id INT PRIMARY KEY, parent_id INT, INDEX par_ind (parent_id), ) ; insert into parent set id=1; insert into child set id=1, parent_id=1; delete parent,child from parent,child where parent.id=child.parent_id; fix ? Thank you for your time Scott Wong Meiko America, INC Hi! Thank you for your bug report, it was fixed one week ago in with the following patch which was committed, but is not yet pushed: = sql/sql_parse.cc 1.293 vs 1.294 = *** /tmp/sql_parse.cc-1.293-28756 Wed Jan 29 21:33:54 2003 --- 1.294/sql/sql_parse.cc Sat Feb 8 19:25:16 2003 *** *** 2038,2044 (ORDER *)NULL,(ORDER *)NULL,(Item *)NULL, (ORDER *)NULL, select_lex-options | thd-options | ! SELECT_NO_JOIN_CACHE, result); delete result; } --- 2038,2044 (ORDER *)NULL,(ORDER *)NULL,(Item *)NULL, (ORDER *)NULL, select_lex-options | thd-options | ! SELECT_NO_JOIN_CACHE | SELECT_NO_UNLOCK, result); delete result; } -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: Bug with innodb multi-table delete and foreign keys.
Scott Wong writes:
Version: Mysql 4.0.10-gamma
Description: ERROR 1105: Unknown error after issuing a multi-table delete on
parent/child table.
if there's no foreign keys .. works ok.
How to Repeat :
drop table parent;
drop table child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT PRIMARY KEY, parent_id INT,
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE CASCADE
) TYPE=INNODB;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
insert into grandchild set id=1, child_id=1;
delete parent,child from parent,child where parent.id=child.parent_id;
ERROR 1105: Unknown error
fix
?
Thank you for your time
Scott Wong
Meiko America, INC
You have got an error due to the fact that cascading deletes deleted
matching rows already.
I have fixed this by introducing a correct error message:
= sql/sql_delete.cc 1.91 vs edited =
*** /tmp/sql_delete.cc-1.91-1826Fri Nov 29 16:40:15 2002
--- edited/sql/sql_delete.ccThu Feb 13 21:28:24 2003
***
*** 429,436
deleted++;
}
end_read_record(info);
! if (local_error == -1)// End of file
! local_error = 0;
}
return local_error;
}
--- 429,441
deleted++;
}
end_read_record(info);
! if (local_error)
! {
! if (local_error == -1) // End of file
! local_error = 0;
! else if (table-db_type == DB_TYPE_INNODB local_error 1000)
! local_error = ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB;
! }
}
return local_error;
}
***
*** 475,487
/* Commit or rollback the current SQL statement */
if (transactional_tables)
if (ha_autocommit_or_rollback(thd,local_error 0))
! local_error=1;
if (deleted)
query_cache_invalidate3(thd, delete_tables, 1);
! if (local_error)
! ::send_error(thd-net);
else
::send_ok(thd-net,deleted);
return 0;
--- 480,492
/* Commit or rollback the current SQL statement */
if (transactional_tables)
if (ha_autocommit_or_rollback(thd,local_error 0))
! error=(error) ? error : local_error;
if (deleted)
query_cache_invalidate3(thd, delete_tables, 1);
! if (error)
! ::send_error(thd-net, error);
else
::send_ok(thd-net,deleted);
return 0;
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.com
Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/
-
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: The corrumpion detected on SELECT AFTER UPDATE ON BLOB COLUMN
Dyego Souza do Carmo writes: How-To-Repeat: create table teste ( id integer auto_increment unique,imagem LONGBLOB not null); insert into teste (id) values (1); update teste set image = (IMG OF 300K) where id = 1; select if(imagem is null, ERRO, OK) from escriba2.teste where id = 1; * My System is Linux 2.4.18 * Table table : MyISAM and InnoDB the crash is same. * With not null or without not null the crash is same. The MySQL 4.0.9 and 4.0.10 ( build from bk tree today ) crash and says this on .err file: sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] Hi! Thank you very much for your bug report. It helped us fix a bug in updating BLOB columns with long strings. Table was corrupted due to a crash, which is prevented with this patch: = sql/sql_update.cc 1.74 vs edited = *** /tmp/sql_update.cc-1.74-30953 Wed Dec 18 18:59:56 2002 --- edited/sql/sql_update.ccTue Feb 4 19:11:08 2003 *** *** 116,121 --- 116,122 // Don't count on usage of 'only index' when calculating which key to use table-used_keys=0; + table-copy_blobs=1; select=make_select(table,0,0,conds,error); if (error || (select select-check_quick(safe_update, limit)) || !limit) *** *** 474,479 --- 475,481 tl-shared= table_count++; table-no_keyread=1; table-used_keys=0; + table-copy_blobs=1; table-pos_in_table_list= tl; } } -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: mysqld got signal 11; This could be because you hit a bug ....
On Tue, 28 Jan 2003 17:12:14 -0700 Mariella Di Giacomo [EMAIL PROTECTED] wrote: Hello, I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site. The machine I am using has 32GB of RAM + 64GB of swap. Thanks in advance for your help, Mariella Hi! The reason why MySQL is crashing is not due to the fact that your memory is exhausted. It is possible that you have shell limits that are far below the available memory, but in your case even that is not a problem. What you should do is get a 4.0.10 debug binary for Solaris 2.8 from our site and send us a core file that is created on the crash. Also add --core-file to startup options. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: BUG:ALTER TABLE (MySQL 4.1)
Gelu Gogancea writes: Hi Sergei, I just finish to compile the latest source code (Jan 25) from http://mysql.bkbits.net/mysql-4.1 The problem persist. Georg has right i was trying to alter table when the primary key was already defined and i was trying: ALTER TABLE cmdlivrare MODIFY IDCMD INT(9) AUTO_INCREMENT; From mysqld.log: Best regards, Gelu _ G.NET SOFTWARE COMPANY Hi! Was it an empty table ir it had rows. Was it corrupt prior to being ALTERed ?? Please send us a dump of the table or if it is big, upload it to the usual place. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: Slow response with MRG tables.
On Wed, 08 Jan 2003 09:09:02 -0700 Mariella Di Giacomo [EMAIL PROTECTED] wrote: Hello, I would like to ask three questions related to MySQL and MERGE tables. Hi! This list is dedicated to the internal functioning of MySQL server. For the questions like above, please write to [EMAIL PROTECTED] -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup
On Thu, 12 Dec 2002 18:41:05 -0700 Mariella Di Giacomo [EMAIL PROTECTED] wrote: Hello, I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. The server used has 8 CPUs. MySQL DB has access (and menage) in that system 2DBs. The first DB is only is accessed only through SELECTS and the second one has been used for UPDATES and INSERTS. Initially I was running a process that was updating the tables. In the program there is no contention among tables and there is only one process that executes UPDATES AND INSERTS. Apparently as soon as people start accessing the other DB (quite heavily) the time spent by MySQL in lwp_mutex_wakeup lwp_mutex_lock increases a lot . This is a screen shot taken with truss of the process in a certain timeframe. As soon as all the shutdown all the users from the DB that is used for only SELECT, now the same process that runs MySQL updates on the other DB has hardly ever lwp_mutex_wakeup lwp_mutex_lock calls. Could someone, please, help me trying to understand why that is the behavior ? Thanks a lot, Mariella The above is not necessarily related to UPDATE's of DELETE's, but to the more frequent creation / destruction of threads. MySQL enforces quite a few locks in order to enable safe operation, safe statistics colletion, memory management etc. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: MySQL 4.0.5(a) is released
Stefan Hinz, iConnect \(Berlin\) writes: Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 Hi! Variable has been removed but the option --safe-show-database remain. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Tuning MySQL Full-text Search
On Wed, 27 Nov 2002 11:53:25 +0200 Nick Kostirya [EMAIL PROTECTED] wrote: Hi, All. How can I add additional characters (Ukrainian alphabet) to the source code for parse? Thanks, Nick. database,sql,query,table,handler,compile,ChangeSet Just add a charset. Take a look at sql/share/charsets/ -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Where is 4.1 source
On Fri, 22 Nov 2002 12:43:58 - Jocelyn Fournier [EMAIL PROTECTED] wrote: I just want to add that unlike what it is printed (Download BitKeeper from http://www.bitmover.com/cgi-bin/download.cgi. You will need Bitkeeper 2.0 or newer to access our repository.), Bitkeeper 3.x seems to be needed. Perhaps the manual should be updated :) Regards, Jocelyn Yes, manual should be updated. Bitkeeper 3.* is the minumum. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: MySQL Berkeley DB
On Mon, 4 Nov 2002 11:24:26 -0700 Wiley Jacobs [EMAIL PROTECTED] wrote: Hello Everyone, I have been going through the documentation on MySQL and on Berkeley DB looking for an answer for my question for several weeks and have yet to come up with one, so I figured I post it. I have a situation where the customer that I have wants to use their current Berkeley DB, although my system needs the SQL and schema definition that MySQL offers. Is there any way to apply these layers to the current Berkeley DB implementation by using MySQL or portions of it? I have to send out the proposal by tomorrow, so if anyone could answer me on this ASAP, that would be great! Wiley HI! This list is dedicated to the internal functioning of MySQL server. For the question like above, write to [EMAIL PROTECTED] or consider taking our support. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Problem with select.
On Wed, 23 Oct 2002 19:15:59 +0300 Andrey Hristov [EMAIL PROTECTED] wrote: I am not an expert but I think that when there is not order by the output is sorted on the primary key. So : select * from log_answers_index limit 0,10 and select * from log_ansers_index where log_entry_id between 1 and 10 are no different in the output. But yes as internal work (of mysql) it is quite different. I think that will be useful optimization done by the optimizer. Andrey HI! If there is an index on the column and if table is large enough, MySQL will use it for ORDERing. Do not forget that for a single table instance MySQL can use only one index. Can you provide us a case where MySQL does not use index ??? -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Bug with Query in MySQL 4.0.4/RedHat 8.0
Mark T. Dame writes: [EMAIL PROTECTED] wrote: Description: This query produces 16 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 But this query produces 0 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 LIMIT 400; I can also get the correct results set by removing the ORDER BY clause. How-To-Repeat: Hi! Thank you for your bug report. This bug looks conspicuously like the bug we have fixed recently in 4.0.5 (still under development). This is the entry from the ChangeLog: * Fixed a newly introduced bug that caused `ORDER BY ... LIMIT #' to not return all rows. You can check a fix by either waiting for 4.0.5 or by using our BK 4.0 repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Compiling mysql with correct libraries
On Mon, 21 Oct 2002 09:51:41 +0200 Iago Sineiro [EMAIL PROTECTED] wrote: Hi all. I want to compile MySQL statically with my own UDF and InnoDB support in one box and with make_binary_distribution install it in a RedHat 8.0 box. Which are the correct versions for gcc and glibc? And automake, autoconfig, and any another posible package needed for compile MySQL? Which is the best version of RedHat for compiling MySQL? Also which are the options used in compilation when is created MySQL-3.23.x-MAX.rpm? Thanks in advance. Iago. HI! This is a difficult question, as we learned recently that there are some problems with MySQL and glibc supplied with RH 8.0. You can use gcc 3.2, automake 1.5 and autoconf 2.54. The options used in creating our 3.23 RPM are described in our manusl. We currently build our RPM's on updated RH 6.2. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Fwd: Only half of the results shown when using order by on unindexed field
Victoria Reznichenko writes: SELECT COUNT(*) FROM question, listing, user ub, user us WHERE question.listing_id = listing.id AND question.buyer_id = ub.id AND listing.seller_id = us.id AND (ub.id = 2346 OR us.id = 2346) ORDER BY question.last_modified DESC; +--+ | COUNT(*) | +--+ |4 | +--+ SELECT question.id AS question_id, listing.id AS listing_id, ub.id AS buyer_id, ub.username AS buyer_name, us.id AS seller_id, us.username as seller_name FROM question, listing, user ub, user us WHERE question.listing_id = listing.id AND question.buyer_id = ub.id AND listing.seller_id = us.id AND (ub.id = 2346 OR us.id = 2346) ORDER BY question.last_modified DESC; +-++--++---+-+ | question_id | listing_id | buyer_id | buyer_name | seller_id | seller_name | +-++--++---+-+ |6850 | 12909 | 2346 | user2346 | 4879 | user4879| |4823 | 39039 | 2346 | user2346 | 14831 | user14831 | +-++--++---+-+ 2 rows in set (0.00 sec) Hi! Thank you for your test case and for the uploaded file. I have tested it with latest 4.0.5 build and I get correct results. Here they are: COUNT(*) 4 question_id listing_id buyer_id buyer_name seller_id seller_name 6850 12909 2346 user2346 4879 user4879 4823 39039 2346 user2346 14831 user14831 6084 49920 2346 user2346 14704 user14704 6223 48014 2346 user2346 7386 user7386 You can either wait for 4.0.5 or try to build from our current BK 4.0 repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: 3.22.52 log rotation crash
Hi! Our replication developers have recently fixed a bug that looks conspiciously like the one you reported. It will come up in 3.23.53 which should come up in 7 - 10 days. Would you please be so kind to check it out if it still persists. If you would like to test code sooner, you can fetch code from our BK repository, as explained in our manual. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: 3.22.52 log rotation crash
Matthew J. Francis writes: On Thu, 2002-10-10 at 13:23, Sinisa Milivojevic wrote: I've pulled the latest 3.23 code with BK and compiled it on the machine in question. Unfortunately the problem still seems to be there as I can still knock the server over with the test case I wrote. The backtrace that results also looks the same as in the initial report. Test case consists simply of one thread looping through INSERT INTO testtable VALUES(1), and another doing RESET MASTER;. (based on this, we're also testing a workaround of making log rotation do FLUSH TABLES WITH READ LOCK; ... ; UNLOCK TABLES; which seems to be effective) If there's any particular thing you'd like me to try in the way of debugging, or further information about the systems we're running that I can provide, please ask and I'd be happy to oblige. Cheers, -Matt. Thank you for your feedback and additional info. We will simply have to look deeper. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Fwd: Crash when adding field
Regarding the above crash after adding the ENUM column, I have tested it and it worked for me. Could you also verify this from our BK 4.0 repository ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Fwd: Crash when adding field
Victoria Reznichenko writes:
Hi!
Indeed I could repeat it :(
In addition, MySQL crushes if the table is not empty. Subscriber
provide ALTER TABLE .. with a column name that already exists.
So I modify test case a little to:
CREATE TABLE `users` (
`ID` int(10) unsigned NOT NULL auto_increment,
`FullName` char(50) NOT NULL default '',
`UserName` char(50) NOT NULL default '',
`Password` char(50) NOT NULL default '',
`Level` enum('1','2') NOT NULL default '1',
PRIMARY KEY (`ID`,`UserName`),
UNIQUE KEY `ID` (`ID`),
KEY `ID_2` (`ID`)
) TYPE=MyISAM;
Query OK, 0 rows affected (0.01 sec)
INSERT INTO users(ID) VALUES(NULL);
ALTER TABLE `users` ADD `Level1` ENUM('1','2') DEFAULT 1 NOT NULL;
This is a forwarded message
From: Matt Parlane [EMAIL PROTECTED]
To:
Date: Tuesday, September 03, 2002, 1:56:12 AM
Subject: Crash when adding field
Thank you for your bug report, but this bug is already fixed in 4.0.4.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: Strange behaviour of mysqld after dropping a column
Cams Ismael writes:
Description:
A time ago I reported next bug:
The ALTER TABLE command behaves very strange when stopping and
restarting the MySQL server afterwards. I noticed this after having
rebooted my PC (which means that the MySql server is stopped and
restarted). Before the reboot I dropped a column in one of my
tables.
After I had done this all the data was available in my table.
However after have been rebooting my PC all the data was gone !!! It
even
becomes crazier. After the second reboot the data was visisble
again.
The tests I have executed showed that this problem shows up for both
adding and deleting a column of a table. Also I noticed that when
you add
data after have beenstopping the MySQL server the first time
this data
is dissapeared after a second stop of the MySQL server.
This problem should be solved in mysql-3.23.52. I have checked this
and came
to the conclusion the problem is indeed solved when adding a column,
but after
dropping a column the problem still exists !!!
Kind regards,
Ismaël
Thank you for your test case. It helped us fix a bug in ALTER TABLE
with BDB handler.
Fix will come up in 3.23.53 and 4.0.4. This is a patch that fixes it:
= sql/sql_table.cc 1.103 vs edited =
*** /tmp/sql_table.cc-1.103-25819 Mon Aug 5 18:50:34 2002
--- edited/sql/sql_table.cc Wed Aug 28 15:10:52 2002
***
*** 1665,1675
VOID(pthread_cond_broadcast(COND_refresh));
goto err;
}
- #ifdef HAVE_BERKELEY_DB
- extern bool berkeley_flush_logs(void);
- if (old_db_type == DB_TYPE_BERKELEY_DB berkeley_flush_logs())
- goto err;
- #endif
thd-proc_info=end;
mysql_update_log.write(thd, thd-query,thd-query_length);
if (mysql_bin_log.is_open())
--- 1665,1670
***
*** 1679,1684
--- 1674,1687
}
VOID(pthread_cond_broadcast(COND_refresh));
VOID(pthread_mutex_unlock(LOCK_open));
+ #ifdef HAVE_BERKELEY_DB
+ extern bool berkeley_flush_logs(void);
+ if (old_db_type == DB_TYPE_BERKELEY_DB)
+ {
+ (void)berkeley_flush_logs();
+ table=open_ltable(thd,table_list,TL_READ);
+ }
+ #endif
end_temporary:
sprintf(tmp_name,ER(ER_INSERT_INFO),(ulong) (copied+deleted),
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: Fwd: Re: Re: [Bug in UNION clause]
Please, re-send me: * mysqldump of the tables * the exact UNION query that you ran -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot
Sergey S. Kostyliov writes: Description: Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege not working ERROR 1142 How-To-Repeat: 1) (under root) mysql GRANT CREATE TEMPORARY TABLES ON *.* TO test_user@localhost IDENTIFIED BY 'test_pass'; Query OK, 0 rows affected (0.01 sec) 2) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); Query OK, 0 rows affected (0.00 sec) 3) (under root) mysql CREATE TABLE t (i INT); Query OK, 0 rows affected (0.00 sec) mysql GRANT SELECT ON test.t TO test_user@localhost; Query OK, 0 rows affected (0.00 sec) 4) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); ERROR 1142: create command denied to user: 'test_user@localhost' for table 'tmp_table' Hi! Thank you for your bug report. Thanks to it, the above bug was fixed and fix will come up in 4.0.3. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Re: Fwd: urgent: problem in deleting multi table
Thank you for your fine bug report, thanks to which, I was able to fix a problem. Final fix will come up in 4.0.3, but this is a patch that fixes it temporarily : = /mnt/work/mysql-4.0/sql/sql_delete.cc 1.80 vs edited = *** /tmp/sql_delete.cc-1.80-1656Tue Jul 23 18:31:17 2002 --- edited//mnt/work/mysql-4.0/sql/sql_delete.ccMon Jul 29 15:26:47 2002 *** *** 227,233 table-used_keys=0; tempfiles[counter] = new Unique (refposcmp2, (void *) table-file-ref_length, !table-file-ref_length, MEM_STRIP_BUF_SIZE); } } --- 227,233 table-used_keys=0; tempfiles[counter] = new Unique (refposcmp2, (void *) table-file-ref_length, !table-file-ref_length + 1, MEM_STRIP_BUF_SIZE); } } -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: BUG report (select distinct...) 4.0.2 and latest bk snapshot
Sergey S. Kostyliov writes: At first I want to thank you for a fast answer, On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote: On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote: Description: ERROR 2013: Lost connection to MySQL server during query. snip Note: The same results with oficial mysql-4.0.2 and latest bk snapshot, mysql was compiled with both gcc-3.1 and gcc-295.3 Unfortunately we can't test this bug report as we do not have tables to run this query with. Please check tables you have at first to eliminate corrupted table is the source of the problem and if problem persist upload them into secret directory at ftp://support.mysql.com Sorry, but it doesn't looks like a table corruption. To be sure i've tested this with fresh tables created from a sql script. I can also add that this is easily reproducable on two of my boxes (UP SMP) If you are able to create small repeatable case you may send it in the mail. Unfortunately it's a kind of big test case (1.2Mb) I had uploaded a test case with name select_distinct-ssk.tar.gz to ftp://support.mysql.com/pub/mysql/secret -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc If the table names are : product_supplier route supplier shop_product_supplier then I have got them. I will test your case today. Is it one bug or two ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Fwd: MySQL 4.0.2 my.cnf
Hi!
Thank you for your test case, thanks to which a bug was fixed when
--bind-address option is used.
Fix will be implemented in next MySQL versions, but this is a patch
that fixes it:
= mysqld.cc 1.321 vs edited =
*** /tmp/mysqld.cc-1.321-14677 Mon Jul 1 11:38:44 2002
--- edited/mysqld.ccMon Jul 15 23:03:40 2002
***
*** 2871,2877
Tells the master that updates to the given database should not be logged tothe
binary log,
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
{bind-address, OPT_BIND_ADDRESS, Ip address to bind to,
!(gptr*) my_bind_addr, (gptr*) my_bind_addr, 0, GET_ULONG, REQUIRED_ARG, 0,
0, 0, 0, 0, 0},
{bootstrap, OPT_BOOTSTRAP, Used by mysql installation scripts, 0, 0, 0,
GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
--- 2871,2877
Tells the master that updates to the given database should not be logged tothe
binary log,
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
{bind-address, OPT_BIND_ADDRESS, Ip address to bind to,
!(gptr*) my_bind_addr, (gptr*) my_bind_addr, 0, GET_STR, REQUIRED_ARG, 0,
0, 0, 0, 0, 0},
{bootstrap, OPT_BOOTSTRAP, Used by mysql installation scripts, 0, 0, 0,
GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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
A bug in BDB ALTER TABLE
Hi! Thank you for your test case, thanks to which this bug was solved. Full fix will appear in the next 3.23 and 4.0 releases. This is a patch : = sql_table.cc 1.101 vs edited = *** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002 --- edited/sql_table.cc Mon Jul 8 22:05:06 2002 *** *** 1652,1658 VOID(pthread_mutex_unlock(LOCK_open)); goto err; } ! thd-proc_info=end; mysql_update_log.write(thd, thd-query,thd-query_length); if (mysql_bin_log.is_open()) --- 1652,1662 VOID(pthread_mutex_unlock(LOCK_open)); goto err; } ! #ifdef HAVE_BERKELEY_DB ! extern bool berkeley_flush_logs(void); ! if (old_db_type == DB_TYPE_BERKELEY_DB berkeley_flush_logs()) ! goto err; ! #endif thd-proc_info=end; mysql_update_log.write(thd, thd-query,thd-query_length); if (mysql_bin_log.is_open()) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: Hello Sinisa, have you already found the origin of the problem ? How does the bugs get fixed - are they solved in patch releases or are they solved in a next release of the MySQL server ? Kind regards, Ismaël Sorry to have lost your e-mail. If that is about BDB , thanks for the test case !! A fix will come in the next 3.23 and 4.0 releases. This is a patch: = sql_table.cc 1.101 vs edited = *** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002 --- edited/sql_table.cc Mon Jul 8 22:05:06 2002 *** *** 1652,1658 VOID(pthread_mutex_unlock(LOCK_open)); goto err; } ! thd-proc_info=end; mysql_update_log.write(thd, thd-query,thd-query_length); if (mysql_bin_log.is_open()) --- 1652,1662 VOID(pthread_mutex_unlock(LOCK_open)); goto err; } ! #ifdef HAVE_BERKELEY_DB ! extern bool berkeley_flush_logs(void); ! if (old_db_type == DB_TYPE_BERKELEY_DB berkeley_flush_logs()) ! goto err; ! #endif thd-proc_info=end; mysql_update_log.write(thd, thd-query,thd-query_length); if (mysql_bin_log.is_open()) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: Hello Sinisa, this has nothing to do with services. I have also tried this without creating a service and the result is the same. Normally the services are also stopped automatically when logging of, so I don't understand why I should stop it manually. Also I have tested this constantly by stopping and restarting the service without rebooting the PC (as I described in my bug report), with the same result. So this has nothing to do with services or with rebooting your PC (this was only how I found the bug). In my opinion this is a heavily bug, keeping in mind that restarting mysql after dropping/adding a column messes up your database ! Can you please check this ? Kind regards, Ismaël Yes, it looks like a bug. We shall inspect that. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Strange behaviour of mysqld after adding/dropping a column
Two questions : * have you installed MySQL as a service ?? * have you stopeed a service prior to rebooting ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: * I have indeed installed MySQL as a service. That's why I use 'net stop mysql' and 'net start mysql' to start and stop the MySQL server. * I have done nothing special before rebooting my PC. The problem doesn't seem to lay in rebooting the PC, but in stopping andstarting the MySQL service. Rebooting the PC causes this service to stop and to start. Kind regards, Ismaël Sorry, but this is not reliable enough on any Windows, including W2K. You have to stop a service before re-booting. Only then you will have no problems with MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Fwd: MySQL server completly dies on an UPDATE
Victoria Reznichenko writes: Hi! Description: I have an instance of MySQL v.4.0.1 Max with 11 children spawned running on a Linux (RedHat 7.0 guiness, 2.2.16-22) personal laptop (Dell Inspiron 5000e) and when I do a simple update on a table that is Full Text enabled, MySQL and all its children crash. I have absolutly no clue why it does that. I never had any problem before. How-To-Repeat: Create the following table: CREATE TABLE pmn_archive ( oid INT UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, mesg_id VARCHAR(255) NOT NULL, subject VARCHAR(255), senderVARCHAR(255), email VARCHAR(255), mdate DATETIME, reference VARCHAR(255) NOT NULL, idx INT DEFAULT '1' NOT NULL, headerTEXT, url VARCHAR(255), title VARCHAR(255), description TEXT, data TEXT, size INT, since DATETIME, last DATETIME, FULLTEXT(url,title,description,data,sender,email), status for thread purpose UNIQUE(mesg_id), PRIMARY KEY(oid) ); Add the following data: INSERT IGNORE INTO pmn_archive (mdate,reference,subject,idx,since,header,last,mesg_id,email,sender) VALUES(FROM_UNIXTIME(819511140),'','Simple message test','1',FROM_UNIXTIME(1025153882),'Return-Path: [EMAIL PROTECTED] Date: Wed, 20 Dec 95 19:59 CST From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Subject: Simple message test ',FROM_UNIXTIME(1025153882),'tgGtI1MTTcZTKycABjwMBg','[EMAIL PROTECTED]','[EMAIL PROTECTED] '); The, do the following update: UPDATE pmn_archive SET data='This is a dummy test for a very simple message This drive scripts are located in dev List Email Message Shoudl their be any problems pls do hesitate to contact me Thanks Moi je pense ca Oui mais je ne suis pas d accord Ah Bah dommage M enfin pourquoi tant de haine Mon titre est M E D I A S N E W S M E D I A S C O M Mon url est http cgi deguest jp u medias mailing list jp et LA JE GUEULE Best Regards Jacques Deguest jack deguest jp ', description='This dummy test for very simple message. This drive scripts are located ~/dev/List/Email/Message Shoudl their any problems, pls, hesitate contact ;-) Thanks, Moi, pense Oui,', url='/1995-12-21-.html', last=FROM_UNIXTIME(819511140), title='Simple message test ', size='582' WHERE oid='1'; Hi! Thank you for your bug report. I tested it with 4.0.2 and it works just fine. 4.0.2 will be released next week latest. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: [mysql option max_user_connections doesn't seem to work]
[EMAIL PROTECTED] writes: Description: I have the max_user_connections set to 150 on every one of my servers but a single user is still able to use up to 250 connections. (max_connections=250) How-To-Repeat: execute a huge query then send 250 updates separately to that same table. Fix: a code fix? Submitter-Id:submitter ID Originator: Organization: RightNow Technologies MySQL support: [ extended email support ] Synopsis:mysql option max_user_connections doesn't seem to work Severity: Priority: Category:mysql Class: Release: mysql-3.23.47 (Source distribution) Hi! I just tested it with 3.23.51 and it worked like a charm. If you have the same problem with our 3.23.51 binary, send us your my.cnf. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Load problems with 3.23.51
Jeremy Zawodny writes: On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: As another data point for you, I've got 3.23.51 running on our master quite well. The difference is that I built it from source (to get a critical InnoDB patch). I don't recall which compiler the MySQL folks used (and which glibc), but my source build used Debian Woody's gcc 2.95.4. That could have something to do with it... 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 24 days, processed 523,371,775 queries (248/sec. avg) Using 2.95.* or 3.* is just fine, with proper configuration, as explained in our fine manual. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Nasty LIMIT/multi-table DELETE bug?
Heikki Tuuri writes: Jon, - Original Message - From: Jon Frisby [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, June 22, 2002 12:51 AM Subject: Nasty LIMIT/multi-table DELETE bug? I just discovered a very scary behavior. We're using MySQL 4.0.1 on Linux, both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are being issues from the MySQL interactive console. If I do a query of the form: SELECT transaction_report.*, confirmed FROM transaction_report, user WHERE user_id = user.id AND DATE_FORMAT(when_reported, '%Y-%m-%d') = '2002-06-21' AND transaction_report.partner_id = 1 AND confirmed != 1 LIMIT 50; This bug was fixed meanwhile ... Now, with multi-table delete you get a syntax error with LIMIT. This has been done so as LIMIT is ambiguous in delete with more then one table involved. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Re[2]: heap tables
Victoria Reznichenko writes: Hi! SM Victoria Reznichenko writes: I have a question about heap tables :) Why does MySQL allow to insert more rows in the table than is specified in MAX_ROWS ? SM Send a test case ... mysql create table hp( - id int primary key)TYPE=HEAP MAX_ROWS=5; Query OK, 0 rows affected (0.00 sec) mysql insert into hp values - (1), - (2), - (3), - (4), - (5), - (6); Query OK, 6 rows affected (0.00 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql select 8 from hp; ERROR 1030: Got error 124 from table handler -- Victoria Reznichenko Thank you for your bug report, but this is truly no bug ... Some table handler, like HEAP, use info you specify for max_rows and avg_row_length to determine maxumum number of blocks that could be use for given table. So, your table would be able to accomodate as many rows as would fit in a single block, which in your case is about 12. Regarding last error, this was fixed few days ago already. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com For technical support contracts, go to https://order.mysql.com/?ref=msmi - 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: The report
Egor Egorov writes:
Zdravo!
Hi,
I'm trying to make use of the new(ish) merge table
type, and am running into two problems. The first is
unexpected behaviour, the second is a straight MySQL
server crash. I have tested 3.23.47, 3.23.49 and
3.23.51 with similar results. Details below refer to
3.23.51. I have also tested on Darwin (MacOS X 10.1.3)
and Linux (RedHat 7.3, kernel 2.4.18), with the same
results. Both deal with the same query type and
datasets.
[skip]
Thanks,
--
Paul Ripke
stixpjr @ yahoo . com . au
Hi!
Thank you for your bug report.
Regarding inconsistent values returned for MERGE tables, please refer
to our manual on how are UNIQUE values treated with MERGE.
Regarding a bug that crashes MySQL, this is a patch that fixes it:
= sql/opt_sum.cc 1.17 vs edited =
*** /tmp/opt_sum.cc-1.17-24218 Fri Apr 12 21:35:41 2002
--- edited/sql/opt_sum.cc Sat Jun 15 20:34:24 2002
***
*** 152,162
error=table-file-index_last(table-record[0]) !=0;
else
{
! (void) table-file-index_read(table-record[0], key_buff,
ref.key_length,
HA_READ_AFTER_KEY);
! error=table-file-index_prev(table-record[0]) ||
! key_cmp(table,key_buff,ref.key,ref.key_length);
}
if (table-key_read)
{
--- 152,163
error=table-file-index_last(table-record[0]) !=0;
else
{
! error= table-file-index_read(table-record[0], key_buff,
ref.key_length,
HA_READ_AFTER_KEY);
! if (!error)
! error=table-file-index_prev(table-record[0]) ||
! key_cmp(table,key_buff,ref.key,ref.key_length);
}
if (table-key_read)
{
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: Re[2]: counting rows ...
Victoria Reznichenko writes:
Hi!
SM Are you using our binaries ??
Yes.
SM If yes, send me a dump of the table and exact queries ...
It's a strange...
Seems, troubles occur when there is a fulltext index and the text
column is NOT NULL. Besides, when I do CREATE .. SELECT, new table works fine ...
The number of rows that appear in SELECT 8 FROM table_name doesn't
depend on number of rows in the table, i.e. I have 2 table with 3 rows
in each table:
mysql select 8 from qq;
Empty set (0.00 sec)
mysql select 8 from bb;
+---+
| 8 |
+---+
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
+---+
8 rows in set (0.00 sec)
8-[ ]
Table aa contains 4 rows, but in the result I get:
mysql select 8 from aa;
+---+
| 8 |
+---+
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
+---+
5 rows in set (0.00 sec)
I attached all three tables...
--
Victoria Reznichenko
Thank you for your bug report, which helped us fix a bug.
Here is a patch :
= /mnt/hdc/Sinisa/mysql-4.0/sql/sql_select.cc 1.173 vs edited =
*** /tmp/sql_select.cc-1.173-1672 Tue Jun 11 11:20:22 2002
--- edited//mnt/hdc/Sinisa/mysql-4.0/sql/sql_select.cc Fri Jun 14 14:42:01 2002
***
*** 257,263
--- 257,270
}
TABLE_LIST *table;
for (table=tables ; table ; table=table-next)
+ {
join.tables++;
+ if (!thd-used_tables)
+ {
+ TABLE *tbl=table-table;
+ tbl-keys_in_use_for_query=tbl-used_keys= tbl-keys_in_use=0;
+ }
+ }
}
procedure=setup_procedure(thd,proc_param,result,fields,error);
if (error)
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: Fwd: A column of the SELECT-part of a query returns allways NULL in some cases.
Victoria Reznichenko writes:
Hi!
Sinisa, i tested the following example on 4.0.1 and got the same
result. If I don't use ORDER BY in the SELECT statement all worked
fine:
mysql SELECT u.gender AS gender, count(DISTINCT u.id) AS dist_count,
(count(DISTINCT u.id)/5*100) AS percentage from users_table u, log_table l where
l.user_id = u.id GROUP BY u.gender;
++++
| gender | dist_count | percentage |
++++
| F | 3 | 60.00 |
| M | 1 | 20.00 |
++++
2 rows in set (0.02 sec)
But if I use ORDER BY
mysql SELECT u.gender AS gender, count(DISTINCT u.id) AS dist_count,
(count(DISTINCT u.id)/5*100) AS percentage from users_table u, log_table l where
l.user_id = u.id GROUP BY u.gender order by percentage;
++++
| gender | dist_count | percentage |
++++
| NULL | 1 | 20.00 |
| NULL | 3 | 60.00 |
++++
2 rows in set (0.01 sec)
Thank you for your bug report which helped us fix a bug. A fix will
appear in 4.0.2.
This is a temporary fix patch :
= sql/sql_select.cc 1.169 vs edited =
*** /tmp/sql_select.cc-1.169-6056 Sun May 26 16:11:27 2002
--- edited/sql/sql_select.ccSat Jun 8 19:37:29 2002
***
*** 135,141
static void calc_group_buffer(JOIN *join,ORDER *group);
static bool alloc_group_fields(JOIN *join,ORDER *group);
static bool make_sum_func_list(JOIN *join,ListItem fields);
! static bool change_to_use_tmp_fields(ListItem func);
static bool change_refs_to_tmp_fields(THD *thd, ListItem func);
static void init_tmptable_sum_functions(Item_sum **func);
static void update_tmptable_sum_func(Item_sum **func,TABLE *tmp_table);
--- 135,141
static void calc_group_buffer(JOIN *join,ORDER *group);
static bool alloc_group_fields(JOIN *join,ORDER *group);
static bool make_sum_func_list(JOIN *join,ListItem fields);
! static bool change_to_use_tmp_fields(ListItem func, bool change=false);
static bool change_refs_to_tmp_fields(THD *thd, ListItem func);
static void init_tmptable_sum_functions(Item_sum **func);
static void update_tmptable_sum_func(Item_sum **func,TABLE *tmp_table);
***
*** 788,794
tmp_table=tmp_table2;
join.join_tab[0].table=0; // Table is freed
! if (change_to_use_tmp_fields(all_fields)) // No sum funcs anymore
goto err;
join.tmp_table_param.field_count+=join.tmp_table_param.sum_func_count;
join.tmp_table_param.sum_func_count=0;
--- 788,794
tmp_table=tmp_table2;
join.join_tab[0].table=0; // Table is freed
! if (change_to_use_tmp_fields(all_fields,true)) // No sum funcs anymore
goto err;
join.tmp_table_param.field_count+=join.tmp_table_param.sum_func_count;
join.tmp_table_param.sum_func_count=0;
***
*** 6764,6770
*/
static bool
! change_to_use_tmp_fields(ListItem items)
{
List_iteratorItem it(items);
Item *item_field,*item;
--- 6764,6770
*/
static bool
! change_to_use_tmp_fields(ListItem items, bool change)
{
List_iteratorItem it(items);
Item *item_field,*item;
***
*** 6776,6781
--- 6776,6786
continue;
if (item-type() == Item::FIELD_ITEM)
{
+ if (change)
+ {
+ ((Item_field*) item)-result_field-null_ptr=0;
+ item-maybe_null=0;
+ }
((Item_field*) item)-field=
((Item_field*) item)-result_field;
}
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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
New additions on MySQL++ page
Hi! There have been some new additions on the MySQL++ page. First of all, thanks to the efforts of Clint Savage [[EMAIL PROTECTED]] and Arturs Aboltins [[EMAIL PROTECTED]] we have two new files : * mysql++1_7_1win32_borland_1_2.zip a new version of MySQL++ for Borland C++ with many bug fixes * Documentation for installing, configuring and using MySQL++ on Windows operating systems Beside that a patch that enables usage of MySQL++ with GNU 3.* series compiler has been updated with a proper one. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Fw: fault tolerance
On Sun, 2 Jun 2002 16:39:36 -0500 Khaled Elmeleegy [EMAIL PROTECTED] wrote: What if the MySQL server crashes during an Insert or delete or update statement, In what state would that leave the database, and would MySQL recover? If so how would it do that? If not what would happen, half of the statement would get executed before the crash while the rest is not? Would you please direct me to where i can find documentation about how MySQL handles recovery in case of normal queries (one sql statement) not transactions (as i know it uses journals for transactions, but not sure if it does the same with queries) Thanks, Khaled Hi! It depends on the table handler. With MyISAM you have to REPAIR TABLE(s) thereafter if they are corrupted. But why would MySQL server crash at all , when it is very stable. Also, keep in mind that this list is dedicated to the internal functioning of MySQL server, not to the general questions of this kind. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Bug with multi-table DELETE in MySQL 4.0.1
Leeuw van der, Tim writes: Hello, Thank you very much for your reply! I was hoping that this was indeed fixed in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to 4.0.1; I will retest the query with 4.0.2 as soon as it's released. Apologies btw for not mentioning the version I was using. With regards, --Tim Hi! Thank you for your bug report, thanks to which bug in multi-table delete was fixed. A fix will come up in 4.0.2. This is a patch for the bug: = sql/sql_parse.cc 1.228 vs edited = *** /tmp/sql_parse.cc-1.228-5440Wed May 29 21:20:27 2002 --- edited/sql/sql_parse.cc Sat Jun 1 21:23:55 2002 *** *** 1960,1965 --- 1960,1966 } auxi-lock_type=walk-lock_type=TL_WRITE; auxi-table= (TABLE *) walk;// Remember corresponding table + (void)add_item_to_list(new Item_field(auxi-db,auxi-real_name,*)); } tables-grant.want_privilege=(SELECT_ACL ~tables-grant.privilege); if (add_item_to_list(new Item_null())) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Bug with multi-table DELETE
Leeuw van der, Tim writes: Hello, Thank you very much for your reply! I was hoping that this was indeed fixed in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to 4.0.1; I will retest the query with 4.0.2 as soon as it's released. Apologies btw for not mentioning the version I was using. With regards, --Tim Hi! Thank you for your bug report, thanks to which bug in multi-table delete was fixed. A fix will come up in 4.0.2. This is a patch for the bug: = sql/sql_parse.cc 1.228 vs edited = *** /tmp/sql_parse.cc-1.228-5440Wed May 29 21:20:27 2002 --- edited/sql/sql_parse.cc Sat Jun 1 21:23:55 2002 *** *** 1960,1965 --- 1960,1966 } auxi-lock_type=walk-lock_type=TL_WRITE; auxi-table= (TABLE *) walk;// Remember corresponding table + (void)add_item_to_list(new Item_field(auxi-db,auxi-real_name,*)); } tables-grant.want_privilege=(SELECT_ACL ~tables-grant.privilege); if (add_item_to_list(new Item_null())) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: multi-table delete bug
Hi!
Thank you for your test case.
However, with latest 4.0.2 code I am getting correct results with
it. Difference in number of rows in select and delete are stemming
from the fact that select reports number of rows in result set, while
delete reports total number of rows deleted.
These are results that I get. If you still think that those are not
correct, please let me know.
I get this :
create database xx;
Query OK, 1 row affected (0.00 sec)
use xx;
Database changed
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime NOT NULL default '-00-00 00:00:00',
`auteur` char(35) NOT NULL default '',
`icone` tinyint(2) unsigned NOT NULL default '0',
`nbrep` mediumint(8) unsigned NOT NULL default '0',
`maxnumrep` int(10) unsigned NOT NULL default '0',
`vue` mediumint(8) unsigned NOT NULL default '0',
`lastauteur` char(35) NOT NULL default '',
`sondage` tinyint(1) NOT NULL default '0',
`next` int(10) NOT NULL default '0',
`prev` int(10) NOT NULL default '0',
`subcat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
KEY `date` (`date`),
KEY `maxnumrep` (`maxnumrep`),
KEY `auteur` (`auteur`),
KEY `sondage` (`sondage`),
KEY `subcat` (`subcat`)
) TYPE=MyISAM;
Query OK, 0 rows affected (0.01 sec)
CREATE TABLE `t2` (
`mot` char(30) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mot`,`numreponse`),
KEY `numreponse` (`numreponse`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
Query OK, 0 rows affected (0.00 sec)
CREATE TABLE `t3` (
`topic` mediumint(8) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '-00-00 00:00:00',
`pseudo` char(35) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`date`,`numreponse`,`topic`),
UNIQUE KEY `pseudo` (`pseudo`,`date`,`numreponse`,`topic`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `topic` (`topic`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
Query OK, 0 rows affected (0.00 sec)
INSERT INTO t1 (titre) VALUES ('test');
Query OK, 1 row affected (0.00 sec)
INSERT INTO t3 (topic,pseudo) VALUES (1,'joce');
Query OK, 1 row affected (0.00 sec)
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0
mot numreponse topic datepseudo numreponse titre numeropost
ouvert dateauteur icone nbrep maxnumrep vue lastauteur
sondage nextprevsubcat
test0 1 -00-00 00:00:00 joce0 test1 1
-00-00 00:00:00 0 0 0 0 0 0
0 0
joce0 1 -00-00 00:00:00 joce0 test1 1
-00-00 00:00:00 0 0 0 0 0 0
0 0
ouee0 1 -00-00 00:00:00 joce0 test1 1
-00-00 00:00:00 0 0 0 0 0 0
0 0
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
Query OK, 4 rows affected (0.01 sec)
SELECT * FROM t2 as
a,t3 as b,t1 as c WHERE
b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date'2002-01-01'
LIMIT 0,30;
Empty set (0.00 sec)
DELETE FROM t2,t3 USING
t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
Query OK, 0 rows affected (0.00 sec)
drop database xx;
Query OK, 0 rows affected (0.01 sec)
mysql quit
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: multi-table delete bug
Hi!
I still can not reproduce your case.
I first ran this script:
create database xx;
use xx;
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime NOT NULL default '-00-00 00:00:00',
`auteur` char(35) NOT NULL default '',
`icone` tinyint(2) unsigned NOT NULL default '0',
`nbrep` mediumint(8) unsigned NOT NULL default '0',
`maxnumrep` int(10) unsigned NOT NULL default '0',
`vue` mediumint(8) unsigned NOT NULL default '0',
`lastauteur` char(35) NOT NULL default '',
`sondage` tinyint(1) NOT NULL default '0',
`next` int(10) NOT NULL default '0',
`prev` int(10) NOT NULL default '0',
`subcat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
KEY `date` (`date`),
KEY `maxnumrep` (`maxnumrep`),
KEY `auteur` (`auteur`),
KEY `sondage` (`sondage`),
KEY `subcat` (`subcat`)
) TYPE=MyISAM;
CREATE TABLE `t2` (
`mot` char(30) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mot`,`numreponse`),
KEY `numreponse` (`numreponse`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
CREATE TABLE `t3` (
`topic` mediumint(8) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '-00-00 00:00:00',
`pseudo` char(35) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`date`,`numreponse`,`topic`),
UNIQUE KEY `pseudo` (`pseudo`,`date`,`numreponse`,`topic`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `topic` (`topic`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
INSERT INTO t1 (titre) VALUES ('test');
INSERT INTO t3 (topic,pseudo) VALUES (1,'joce');
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Then I ran `mysqladmin shutdown`.
Then I ran this script :
use xx;
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
I get 4 rows here
SELECT * FROM t2 as
a,t3 as b,t1 as c WHERE
b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date'2002-01-01'
LIMIT 0,30;
0 here .
DELETE FROM t2,t3 USING
t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date'2002-05-30';
and 0 here
I ran latest mysqld 4.0.2 with these options:
--one-thread --datadir=/usr/local/var --skip-stack-trace --core-file
I also tried without --one-thread and still have got the above result.
Please check if I did something wrong.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: Manual at mysql.com
Luc Foisy writes: the search query is broken Luc Foisy We shall notify our web team. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: link problem
adelpfe writes: hi every body i have succeed to compile source examples given with mysql++1.7.9. but i can't link them. i used gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz -all rigth but , i didn't succeed to link can you help me HI! First of all, you should use g++. Second, you should link in sqlplus too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: äÏÂÒÙÊ ÄÅÎØ. Hmm... I use mysql_init() in each thread but: 8.4.4.4 my_thread_init() . This is automatically called by my_init() and mysql_connect(). ~ And in manual: To get a threaded client where you can interrupt the client from other threads and set timeouts when talking with the MySQL server, you should use the -lmysys, -lstring, and -ldbug libraries... -lstring - where can I find it? Is it -lmystrings ? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 No, just -lstrings -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: How does DISTINCT really work ?
Fournier Jocelyn [Presence-PC] writes: Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch (13:29:52) # This is a BitKeeper generated patch for the following project: # Project Name: MySQL - fast and reliable SQL database # This patch format is intended for GNU patch command version 2.5 or higher. # This patch includes the following deltas: # ChangeSet1.1235 - 1.1236 # Docs/manual.texi1.865 - 1.866 # # The following is the BitKeeper ChangeSet Log # # 02/04/15 [EMAIL PROTECTED] 1.1236 # Documentation fix. # mysql SELECT DISTINCT topic FROM forum.searchmainpresencepc4,forum.searchjoinpresencepc4 WHERE searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND (mot='les') ORDER BY date DESC LIMIT 0,40; +---+ | topic | +---+ | 11462 | cut | 12313 | | 9673 | | 11462 | cut | 12282 | | 9673 | | 12224 | +---+ 40 rows in set (0.06 sec) Hi! Thank you for posting about the above problem and for uploading the tables. The above is not a bug. Due to the presence of date column in ORDER BY clause, MySQL (and any other RDBMS) has to do a silent addition to the select list, so your query truly looks like this (I had to change table names to check the ones you have sent us): SELECT DISTINCT topic, date FROM searchmainhardwarefr8,searchjoinhardwarefr8 WHERE searchmainhardwarefr8.numreponse=searchjoinhardwarefr8.numreponse AND (mot='les') ORDER BY date DESC LIMIT 0,40; And a true output is truly like this : topic date 21712002-04-19 20:13:10 21262002-04-19 04:54:38 21462002-04-18 21:39:12 21472002-04-18 12:44:30 21482002-04-18 09:41:56 21482002-04-17 15:13:44 21482002-04-16 15:59:50 18732002-04-15 10:02:20 21322002-04-13 18:18:44 21332002-04-13 15:56:57 21292002-04-12 17:43:29 21212002-04-12 17:00:03 20852002-04-12 15:07:49 21212002-04-12 13:26:14 16642002-04-12 00:45:30 21062002-04-10 00:33:03 741 2002-04-09 14:50:31 20932002-04-09 09:12:46 20452002-04-08 11:59:09 20892002-04-07 18:29:08 20892002-04-07 16:53:36 20672002-04-07 15:05:28 20792002-04-05 16:57:08 20212002-04-05 01:51:33 20542002-04-03 11:03:42 20492002-03-29 11:42:59 19932002-03-28 01:28:08 20402002-03-27 16:50:19 20212002-03-24 12:29:28 20052002-03-21 16:55:01 20052002-03-20 17:58:37 19352002-03-19 21:06:12 19352002-03-19 18:31:35 19982002-03-19 17:51:20 19902002-03-18 21:22:52 19342002-03-18 10:50:45 19832002-03-18 00:06:59 19342002-03-17 22:57:50 19682002-03-15 16:41:51 19712002-03-14 14:00:35 So, simply, everything is as it should be. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Michael Chang writes: For example, have you called mysql_thread_init() before calling mysql_real_connect() in all your threads ? However, to my understanding, mysql_thread_init() is not needed if only one database connection is used, and that database connection is established when the program starts, before any threads have been created. That is, if you call mysql_real_connect() at the top of main(), for example, and you let the connection persist for the lifetime of the program, then mysql_thread_init() is not necessary, and the only thing that you must worry about is to make sure that critical sections (like between mysql_real_query() and mysql_store_result()) are sandwiched in-between a mutex lock. If the above is incorrect, please let me know. Michael It is required in any case when multi-threaded program is made, which uses our C API. In 4.0 it is automatically invoked in my_init() if library is built thread-safe. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: mysqlgui
[EMAIL PROTECTED] writes: To whom it may concern, Where can i find the documentation for mysqlgui? thanks bd It comes with a package. Read MySQL.help , README and readme.* files. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: install mysql++ on linux
adel essafi writes: hi i have downloaded mysql++ on linux. i didn't find these files automake autoconfig so , i couldn't install mysql++. help plz On linux, you can skip first two steps and start from configure ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: Hi! I am not agree. I take _another program_ which work fine during ~2 year with previouse mysql version (mysql-3.23.44 for example). And I send dump from this program. Why I interested libmysqlclient_r? I have a program, which try to connect to mysql twice. But the second connection freeze in mysql_real_connect. I use libmysqlclient.so (mysql-3.23.42 FreeBSD-4.4RC) I try to upgrade to mysql-3.23.49 and use mysqlclient_r on test computer and have many problems (I write about their before). But now I attach to working process which freese and see: (gdb) bt #0 0x18237970 in _thread_kern_sched () from /usr/lib/libc_r.so.4 #1 0x182382d2 in _thread_kern_sched_state () from /usr/lib/libc_r.so.4 #2 0x1823b791 in _thread_fd_lock_debug () from /usr/lib/libc_r.so.4 #3 0x1826df86 in _close () from /usr/lib/libc_r.so.4 #4 0x1823eb72 in _res_close () from /usr/lib/libc_r.so.4 #5 0x1823dc49 in res_send () from /usr/lib/libc_r.so.4 #6 0x182418ad in res_query () from /usr/lib/libc_r.so.4 #7 0x18241d88 in res_querydomain () from /usr/lib/libc_r.so.4 #8 0x18241aca in res_search () from /usr/lib/libc_r.so.4 #9 0x1824d692 in _gethostbydnsname () from /usr/lib/libc_r.so.4 #10 0x1824c14c in gethostbyname2 () from /usr/lib/libc_r.so.4 #11 0x1824c0c9 in gethostbyname () from /usr/lib/libc_r.so.4 ~~~ #12 0x180e7cdc in mysql_real_connect () from /usr/local/mysql/lib/libmysqlclient.so.10 #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18, db=0x80fe8b0 zzz, host=0x80fb040 xxx.xxx.xxx, user=0x80fe910 xxx, passwd=0x80c26aa , port=3306, compress=1, connect_timeout=60, socket_name=0x80c26be , client_flag=0) at connection.cc:52 #14 0x808384f in QueueModule::Run (this=0x80c9c00) at QModule.cc:166 #15 0x8068a8b in start_Module (ptr=0x80c9c00) at Module.cc:23 #16 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4 #17 0x0 in ?? () Under FreeBSD gethostbyname is not thread-safe And there is no thread-safe gethostbyname_r (function exist but not thread-safe) Are mysql know about this!!! Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 The above crash is caused by using functions, like gethostbyname, which is not thread safe. This is explained in our fine manual. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: 3.23.50 client needs IP addresses
[EMAIL PROTECTED] writes: Description: mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id:submitter ID Originator: Rob Steele Organization: FatKat, Inc. MySQL support: none Synopsis:3.23.50 client needs IP addresses Severity:serious Priority:high Category:mysql Class: sw-bug Release: mysql-3.23.50 (Official MySQL RPM) Hi! The above problem is not caused by any changes in 3.23.50 source. It is caused by having glibc built statically with binaries. This solves many other problems, but may create DNS related problems. Solution to the above is to have all your hosts that access a server in hosts server and tune up name resolution on your Linux . -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: compile problem with 3.23.50
[EMAIL PROTECTED] writes: Description: I get the following error: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ - DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/includ e -I./../include -I./../regex - I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-except ions -fno-rtti -c mysqld.cc mysqld.cc: In function `void * handle_connections_sockets(void *)': /usr/include/tcpd.h:161: too few arguments to function `void sock_host(request_i nfo *)' mysqld.cc:2428: at this point in file /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request _info *)' mysqld.cc:2429: at this point in file /usr/include/tcpd.h:153: too few arguments to function `char * eval_client(reque st_info *)' mysqld.cc:2437: at this point in file make[4]: *** [mysqld.o] Error 1 make[4]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql' Hi! Problem that you are experiencing is caused by changes that were needed to solve problem building MySQL with libwrap on Linux. All Linux versions that we tested, had prototypes as in 3.23.50. Can you explain why is your Linux so different ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: Hi! % g++ -v Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] And libstdc++ is include in compiller How can I see version of libstdc++ ? In /usr/src/contrib/libstdc++/Makefile.in I see VERSION = 2.10.0 INTERFACE = 3 Is there right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Compiler is OK. But your program is multithreaded, so check with `ldd` whether you have linked in libstdc++ ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: mysqlgui and DNS
John Derrick writes: I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present [skip] Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client A fix is to use IP address in the host field. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Question about mysql++ and g++
Mike Holmquist writes:
Ok, i downloaded the mysql++-1.7.8-1.i386.rpm
ftp://ftp.rpmfind.net/linux/MySQL/mysql++/mysql++-1.7.8-1.i386.rpm rpm
file from RpmFind.net. I have mysql installed already on my machine, o
ya and im running linux. I have gcc installed, version 2.96, i think
everything installed correctly when i ran the rpm. But i am not sure. I
made a simple program, here it is:
#include sqlplus.hh
int main() {
return 0;
}
When i tried to compile it using g++ mysql.cpp i got a bunch of errors
saying mysql.h not found (errors are printed on bottom of email). So i
tried doing a locate mysql.h and it only found the mysql.h file from
my windows partition (i have mysql++ installed on windows...).
I am not sure if its my compiler, or the version of mysql++ i installed.
Another question i have is it says to reset my database using reset-db,
where would i do that? The mysql command line?
If anyone can help me, give me some ideas if my install went wrong, or
if i need to update gcc, or get a different compiler (i dont know any
for linux yet! ) id appreciate it very much!
~Mike
HI!
The errors are caused by MySQL++ not seeing MySQL++ include directory.
In your Makefile add -I.. directive for include directory and
-L.. directive for lib directory.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: Cant connect using socket ''(111) for Mysqlgui on linux
Krishna Kumar Sundara Moorthy writes: Hello All Is there any installation instructions for Mysqlgui1.7.5 on linux. Also i have installed it and while trying to connect it says couldnt connect using Socket''(111) and also can some one throw light on sql command on connet or Socket dialog in options window and what showuld really go in there thanks in advance Krishna Kumar S. Hi! There is README that comes with mysqlgui that contains all info. Click on Options, fill up all entrries. On Linux, in that field 'SQL command on ... enter a location of the socket file. If it is defined in any *my.cnf it should pop up there for itself. Then click on 'Save' and re-connect. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: my program crash in another plase (gdb) bt #0 _db_enter_ (_func_=0x280fe4dc mysql_ping, _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c, _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48) at dbug.c:712 #1 0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248 #2 0x80832d2 in QueueModule::Run (this=0x80c9c00) at /usr/local/mysql++/include/connection1.hh:80 #3 0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23 #4 0x282063af in _thread_start () from /usr/lib/libc_r.so.4 #5 0x0 in ?? () (gdb) p state $1 = (CODE_STATE *) 0x0 (gdb) why code_state() return NULL? Is this right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 Does not seem like our bug ! Because last time it crashed in a completely different place. Plus, it is unlikely that it would crash in ping. Check out your compiler version and whether libstdc++ got linked into the binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: table lock - which connection id own's it
Lopez David E-r9374c writes: Monty BTW, it's a thrill to hear from the CTO. The procedure for locking a table is more complex but will attempt to describe it further for you. Any of the 150 daemons can insert to the hash tables. The data in the row can be used by all 150 daemons. The primary key in hash table is the id field which is an auto-increment type. This id field is the hash value inserted in the main table as foreign key. When a daemon starts up, it reads the hash table with each entry a key-value pair. The value is the id field. During the course of logging info to the main table, it may find an entry that is not in it's local hash in RAM. When this occurs, it does a sql select on the hash. If a row is returned, it will insert the key-value pair into the it's hash and insert an entry into the main table. If no row is returned, then the following happens: 1) lock table ... 2) select ... 3) if no row is returned, 4)insert ... 5)use LAST_INSERT_ID() to get the value of the key 6) else get the key-value pair 7) unlock table 8) put key-value pair in RAM hash 9) insert row in main table (using new key-value pair) Since 99% of the time, the data hash table information is already stored in the daemon hash table on initial start up. We wanted to lock the table so two different daemons would not enter the same information in the hash tables. Extremely unlikely, but the boss is paranoid. Or is it more experienced. Hope that clears the insertion process on the hash tables. I'm glad that if a connection is lost in steps 2-6, mysql would automatically unlock the tables. That will satisfy the db specification nicely. The architecture for our db came from the optimization chapter in the manual. Thanks! David Hi! Still , locking a table is not necessary as MySQL server remembers LAST_INSERT_ID() value, for each connection (thread) separately. Simply, this value is not (only) remembered on per-table basis, but also for each thread (connection) separately. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: Hello, All! I have program which try to connect to different mysql servers twice at the same time. When I use libmysqlclient.so sometimes one or two mysql connection freeze in mysql_real_connect But when I try to use libmysqlclient_r.so program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 [skip] Hi! First of all, what version of limysql are you using ?? Second, please do : frame 1 and let us know the values for the following parameters : const char *dir, const char *config_file, const char *ext, TYPELIB *group) OS FreeBSD 4.4-RC mysql version 3.23.42, but I try to use 3.23.49 with the same effect Will anybody help me? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Inserting a BLOB using MySQL++
Thi Cao writes: All, I created a C++ class containing a variety of member variables of varying types such as float, int, char *, etc. If I instantiate an object of this class, how should I insert this object into my database table? I can retrieve the individual members and insert them that way, but I feel it would be more efficient to insert the object as a BLOB, but I don't exactly know how to do that. Basically, I want to insert the object as is so that I can retrieve it as is and not have to bother with calling the member setting functions to populate the class members. I looked at the MySQL++ example for loading a binary file, but am unsure how to apply that to my needs. I also looked through the mail archives and was unsuccessful in finding a solution, so any assistance would be much appreciated. Thanks in advance. Regards, Thi Hi! Take a look in reset_db.cc and load_file.cc example files. In any case, you always have to escape a binary string prior to inserting it. As it is seen in cgi_image.cc example, you will always get back from MySQL your BLOB in en-escaped, original form. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: äÏÂÒÙÊ ÄÅÎØ. #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 Will I need to compile mysql with --with-debug option to see parameters? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 Yes, including libmysys source files . -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Specifying Error Log
On Fri, 19 Apr 2002 16:03:44 -0500 (CDT) Russell E Glaue [EMAIL PROTECTED] wrote: I think it would be a good idea to be able to specify the error log on the command line when starting mysqld. Right now mysql users can only specify the following logs on the command line: log (access/activity log) log bin log bin index log update log isam log slow-queries innodb_log_* I would love to be able to specify the error log on the command line. log error ( by default-only it is $MYSQL_ROOT/var/`hostname`.err ) mysqld --log-error=/usr/mysql/logs/error.log Maybe some people don't like that it is flagged as an error log. I really don't care what it is referred to as long as I can actually specify the name and location of the log. Does anyone else have an opinion on this? -RG Hi! We have in our WorkLog an entry that would handle the above option, only this is not such a high priority for us and most of our users. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: licence
Klym writes: I hope I'm not out of line by asking a licensing question. I am working on a MySQL database for a web-based survey. We will be charging a fee to complete the survey and receive reports. Am I required to purchase a MySQL licence for this or does my hosting company who sold me the use of MySQL cover the licence? thanks Hi! This is a question for [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: My SQL ++ Bug and Port
Thank you for your report. Yes, I know about this leak in Windows version. It is due to it's stack limitations. Current developrment branch has this leask fixed already ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: licence
Neil Highley writes: Let me know about the answer to this one. [EMAIL PROTECTED] --- Life must be lived as play. - Plato (427 - 347 BC) You will be duly informed ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: bug in file ibmysql_r/libmysql.c
[EMAIL PROTECTED] writes: Description: enable-reads-from-master and repl-parse-query is mixed How-To-Repeat: . Fix: line 839: case 22: /* enable-reads-from-master */ options-rpl_parse = 1; break; case 23: /* repl-parse-query */ options-no_master_reads = 0; break; should be: case 22: /* enable-reads-from-master */ options-no_master_reads = 0; break; case 23: /* repl-parse-query */ options-rpl_parse = 1; break; or change static const char *default_options[]=.. and those comments; Hi! Thank you for spotting this. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: How does DISTINCT really work ?
Fournier Jocelyn [Presence-PC] writes: Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch (13:29:52) # This is a BitKeeper generated patch for the following project: # Project Name: MySQL - fast and reliable SQL database # This patch format is intended for GNU patch command version 2.5 or higher. # This patch includes the following deltas: # ChangeSet1.1235 - 1.1236 # Docs/manual.texi1.865 - 1.866 # # The following is the BitKeeper ChangeSet Log # # 02/04/15 [EMAIL PROTECTED] 1.1236 # Documentation fix. # mysql SELECT DISTINCT topic FROM forum.searchmainpresencepc4,forum.searchjoinpresencepc4 WHERE searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND (mot='les') ORDER BY date DESC LIMIT 0,40; +---+ | topic | +---+ | 11462 | cut | 12313 | | 9673 | | 11462 | cut | 12282 | | 9673 | | 12224 | +---+ 40 rows in set (0.06 sec) BTW I have a problem with the latest mysql client (12.1) : It seems to be locked when I make a 'use database' : mysql use forum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A locked Regards, Jocelyn Hi! Can you upload a gzipped dump of your table, so that we could check the above ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: regarding libmysqlclient and libmysqlclient_r
On Thu, 11 Apr 2002 20:10:15 -0400 (EDT) Shivam K Shah [EMAIL PROTECTED] wrote: Hi, I'm using the mysqlclient_r library to access the database. I have written some code as an interface to access the MYSQL databse and have written the following test code to test the library. I'm using Linux 2.4.4-4 as the platform. I'm putting locks around my entire test case so that two threads do not share the same connection at the same time. as suggested earlier I have also built the library with local pthreads i.e. --with-pthread=-pthread or --with-pthread=-lpthread This code still is not working when compiled with libmysqlclient_r but works with libmysqlclient. The following is the code with places of my_init(), my_init_thread(), and my_thread_end(). Since I'm new to using this library I would be grateful for any kind of guidance on where I'm going wrong. regards, Hi! Your code seems OK to me. What exactly is not working and which version of client API are you using ?? For the start, you might try using latest 4.0.1 and change my_thread_.. to mysql_thread.. calls. If that does not help, let us know exactly what is not working and send us the entire code. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Re: unkown table is full
Richard Clarke writes: There is plenty of space. In excess of 5 gigs. Ric Hi! The error message that you get is quite unlikely for temporary tables. Which release of MySQL 3.23 have you used ?? If not recent, then try the latest and see if problem reccurs. If this happens with last version, please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Re: unkown table is full
Richard Clarke writes: This is mysql 4.0.1-alpha. Ric Please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: VC++ Examples
Troy writes: Hi all, Just wondering if there are any examples on the web that will compile using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get the example to compile. Thanks in advance Troy HI! MySQL++ requires VC++ 6.0. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: mysqlgui crash caused by infinite loop
[EMAIL PROTECTED] writes:
Description:
mysqlgui crash caused by infinite loop in
mysql_read_default_options because strcend
never returns 0
How-To-Repeat:
Fix:
--- libmysql/libmysql.c.orig Thu Feb 14 18:30:17 2002
+++ libmysql/libmysql.c Tue Mar 19 15:52:49 2002
@@ -712,7 +712,7 @@ static void mysql_read_default_options(s
*end=0; /* Remove '=' */
}
/* Change all '_' in variable name to '-' */
- for (end= *option ; (end= strcend(end,'_')) ; )
+ for (end= *option ; (end= strcend(end,'_')) *end; )
*end= '-';
switch (find_type(*option+2,option_types,2)) {
case 1: /* port */
--- libmysql_r/libmysql.c.origThu Feb 14 18:30:17 2002
+++ libmysql_r/libmysql.c Tue Mar 26 22:52:17 2002
@@ -712,7 +712,7 @@ static void mysql_read_default_options(s
*end=0; /* Remove '=' */
}
/* Change all '_' in variable name to '-' */
- for (end= *option ; (end= strcend(end,'_')) ; )
+ for (end= *option ; (end= strcend(end,'_')) *end; )
*end= '-';
switch (find_type(*option+2,option_types,2)) {
case 1: /* port */
Hi!
Thank you, both for your mail fix.
This bug was fixed few weeks ago.
Fixed version will be released both with 3.23.50 and 4.0.2.
Thanks again.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: MySQL C API documentation
Konstantin Osipov writes: * Michael Widenius [EMAIL PROTECTED] [02/03/26 12:41]: But, according to MYSQL C API documentation, 8.4.2, (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_function_overview) I have to do this: An advantage of mysql_use_result() is that (...) (...) Furthermore, you must retrieve all the rows even if you determine in mid-retrieval that you've found the information you were looking for. Sorry thank you. -- WBW, Konstantin Osipov A small clarification. Monty has commented of your calling mysql_fetch_row() in Cursor destructor. As he said, you do not have to do that, as mysql_free_result will clear the remaining rows in the result set from the server. That is all. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: MYSQL NGPT
Peter Zaitsev writes: Hello mysql, I've found benchmark for MySQL on Linux with NGPT - the Solaris-like pthread compatible threads for Linux, the stable version 1.2.0 of which just was released. The user tested mysql server from binary distribution vs self compiled with NGPT. 2.4.19-pre3 kernel was used. fork_big.pl was used with --loop-cont=5000 MySQL-LinuxThreads 1 - 0m9.8s 10 - 1m24s 20 - 4m21s 50 -14m47s MySQL-NGPT 1 - 0m9.5s 10 - 0m51s 20 - 1m44s 50 - 4m29s 100- 9m50s So NGPT shows almost linear salability winning several times over MySQL optimized Linux threads in some cases. -- Best regards, Peter mailto:[EMAIL PROTECTED] Thanks Pjotr ! What about URL ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: MYSQL NGPT
Pjotr, have you tested a speed of mutexes and the availability of adaptive mutexes ... Testing can be done with super-smack ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Mysql 4.0.1-Alpha: Union + Limit bug.
[EMAIL PROTECTED] writes: Description: Take two tables (call them a and b), which have identical structures. Table a has no rows, table b has some (say 10) rows. If you do this: select * from a union select * from b limit 0,5 It works as expected. Now do this: select * from a union select * from b limit 5,5 Now you get _zero_ rows. In version 4.0.0, this worked as expected. Hi! Thank you for your bug report. This is a known bug and is already fixed. Fix will come up in 4.0.2 which should be out in two weeks or less. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: mysql bug
@@
for (; a b; a=a-next,b=b-next)
{
-if (!(*a-item)-eq(*b-item))
+if (!(*a-item)-eq(*b-item,1))
DBUG_RETURN(0);
map|=a-item[0]-used_tables();
}
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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: MySQL clients hang when network to server is disrupted!
On Wed, 20 Mar 2002 16:00:15 -0800 Lance Welsh [EMAIL PROTECTED] wrote: It is a big problem for us, and I can only imagine for anyone using MySQL, when a mysql client hangs on an established connection to the mysql server because the network to the server is disrupted (such as someone pulling power to a network hub or many other scenarios). We have changed the source code to fix this, but I'd sure like to hear comments from people that know MySQL. The mysql client can respond with an error if the server dies or is shutdown because the network will cleanup the broken connection. The mysql client can also respond with an error if the server is not available for a connection. But if the connection is already established and the network connection is disrupted, the client simply hangs. Someone please tell me if I am wrong, or if I am doing something wrong. Perhaps there is a feature or option I am overlooking (the option to set a timeout when connecting does not affect existing connections). Perhaps my change here could be incorporated into the source code control if someone will guide me. What we have done to get around this problem is to use poll with a timeout before blindly hanging on a read. I had to alter the vio_read method in the violite.c file: Hi! In some cases you can have a connection to timeout by setting network read and write timeouts on the server. For all other cases, network read and write timeouts will have to be established on the client side too. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: URGENT: Update Error with MySQL++
Thi Cao writes: All, I can't seem to perform an update on my database with MySQL++. The execution of the query always throws an exception. Here's a snippet of what I did. Query query(conn); query update employee set children = 3 where id = 9; query.execute(); The above code throws an exception everytime. What am I doing wrong? Thanks. Thi Don't use streams for commands that do not return result sets. Use exec() method instead. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: EXPLAIN feature request
Ken Menzel writes: Hi Guys, I would like to request an additional feature with EXPLAIN. EXPLAIN does not run the query guesses on how the query would be run. This is not always accurate. The slow-log however logs the actual information the query was run with (like explain only the truth!). Could we have an option with EXPLAIN to actually run the query and provide the true results? Maybe REXPLAIN, or EXPLAIN RUN query? Thanks Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] Hi! This is of course doable, but EXPLAIN will be more accurate if all tables involved were ANALYZE'd ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: AIX binary distribution bug
Mike Gahan writes: Description: mysql binaries from AIX binary distribution will not run. 1 % cd /tmp/mysql/bin 2 % ./mysql Could not load program ./mysql: Dependent module /usr/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive Hi! This is a known problem and will be fixed in 3.23.50 which should be out in two weeks. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
