Re: Problem related to Installation of MYSQL 4.0.2
Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html >Lms.Bmc Bmc wrote: >hi, > i am Installing My Sql -Standard-4.0.26-pc-linux-gnu-i686 Of Linux >Machine >But Facing some Problem > i am Getting thius Error " ERROR 2002: Can't connect to local MySQL >server >through socket '/var/lib/mysql/mysql.sock' (2)" > while i start MYSQl > Plzz Reply me Giving t he Solution For it -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem related to Installation of MYSQL 4.0.2
hi, i am Installing My Sql -Standard-4.0.26-pc-linux-gnu-i686 Of Linux Machine But Facing some Problem i am Getting thius Error " ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" while i start MYSQl Plzz Reply me Giving t he Solution For it
Re: Date Conversion on Mysql 4.0.2
Minh La wrote: Hi, Can some help me with a date conversion problme that I am having. I have a date data in the following format: 'Month Days Year Hour:Minute AM/PM' Example: 'Aug 21, 2004 2:00 PM' So far the hours that I have spent have been in vain. I tried using str_to_date, but it keeps failing. Looks like it's not in version 4.0.2? Minh: Your options are: * upgrade to 4.1 * parse and convert the date in your applications * use an ugly combination of SUBSTRING() and CASE to parse out the date * write a UDF implementing STR_TO_DATE() * backport STR_TO_DATE() to 4.0 -- Sasha Pachev AskSasha Linux Consulting http://www.asksasha.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Date Conversion on Mysql 4.0.2
Minh La wrote: So far the hours that I have spent have been in vain. Next time a couple of minutes with the Fine Manual instead? :-) I tried using str_to_date, but it keeps failing. Looks like it's not in version 4.0.2? Quoting the FM: "STR_TO_DATE() is available as of MySQL 4.1.1." FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Date Conversion on Mysql 4.0.2
Hi, Can some help me with a date conversion problme that I am having. I have a date data in the following format: 'Month Days Year Hour:Minute AM/PM' Example: 'Aug 21, 2004 2:00 PM' So far the hours that I have spent have been in vain. I tried using str_to_date, but it keeps failing. Looks like it's not in version 4.0.2? TIA. Minh = Minh La __ Do you Yahoo!? All your favorites on one personal page Try My Yahoo! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.0.2 is topping out at 1024 threads!
FIXED! Ok Thanks to Eric on this one, the wait_timeout configuration was what fixed my sleepy connection problems! Thanks ERIC! Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Eric Gunnett [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 11:37 AM To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0.2 is topping out at 1024 threads! wait_timeout Will set the maximum amout of time a thread will be in the Sleep state before MySQL drops it. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] >>> "Matt Babineau" <[EMAIL PROTECTED]> 11/17/04 11:35AM >>> Ok, this is making a bit more sense now, I took a look at show processlist and this is what I found: | 25687 | inetusr | 62.13.102.133:48206 | protected | Sleep | 454 | | NULL The screen scrolls up with these sleeping connections, any way I can get these guys dumped if they've been sleeping too long? I already have a connection_timeout in the my.cnfis there another option? Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Alvaro Avello [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 11:28 AM To: Matt Babineau Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0.2 is topping out at 1024 threads! threads or connections ? if the problem is about connection maybe change the parameter in your my.cnf : max_connections = 1024 to a higher value ... Hope this helps... Saludos / Regards, Alvaro. On Wed, 2004-11-17 at 11:18 -0800, Matt Babineau wrote: > From: > Matt Babineau > <[EMAIL PROTECTED]> >To: > [EMAIL PROTECTED] > Subject: > RE: MySQL 4.0.2 is topping out at > 1024 threads! > Date: > Wed, 17 Nov 2004 11:18:04 -0800 > (16:18 CLST) > > This is a very strange problem. As you can see there isn't a lot going > on, under a million queries. No problem right? This is a dual cpu 2.8 > Ghz server. Ok Great. I am also including my.cnf so you can see my > configuration. > > Here is some more info on the problem I am experiencing: > > mysql> status > -- > mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) > > Connection id: 25394 > Current database: > Current user: [EMAIL PROTECTED] > SSL:Not in use > Current pager: stdout > Using outfile: '' > Server version: 4.0.20-standard-log > Protocol version: 10 > Connection: 63.12.130.192 via TCP/IP > Client characterset:latin1 > Server characterset:latin1 > TCP port: 3306 > Uptime: 19 hours 40 min 2 sec > > Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush > tables: > 1 Open tables: 27 Queries per second avg: 11.044 > -- > > mysql> > > > == > > # Example mysql config file for very large systems. > # > # This is for large system with memory of 1G-2G where the system runs > mainly # MySQL. > # > # You can copy this file to > # /etc/my.cnf to set global options, > # mysql-data-dir/my.cnf to set server-specific options (in this # > installation this directory is /var/lib/mysql) or # ~/.my.cnf to set > user-specific options. > # > # One can in this file use all long options that the program supports. > # If you want to know which options a program support, run the program > # with --help option. > > # The following options will be passed to all MySQL clients [client] > #password = your_password > port= 3306 > socket = /var/lib/mysql/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port= 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer = 384M > max_allowed_packet = 1M > table_cache = 512 > connect_timeout = 10 > sort_buffer_size = 2M > read_buffer_size = 2M > myisam_sort_buffer_size = 64M > thread_cache = 8 > query_cache_size = 32M > # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 > max_connections = 1024 max_user_connections = 1024 > > # Don't listen on a TCP/IP port at all. This can be a security > enhancement, # if all processes that need to connect to mysqld run on > the same host. > # All interaction with mysqld must be made via Unix sockets or named > pipes. > # Note that using this option without enabling named pipes on Windows > # (via the "enable-named-pipe" option) will render mysqld useless! >
RE: MySQL 4.0.2 is topping out at 1024 threads!
Ok, this is making a bit more sense now, I took a look at show processlist and this is what I found: | 25687 | inetusr | 62.13.102.133:48206 | protected | Sleep | 454 | | NULL The screen scrolls up with these sleeping connections, any way I can get these guys dumped if they've been sleeping too long? I already have a connection_timeout in the my.cnfis there another option? Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Alvaro Avello [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 11:28 AM To: Matt Babineau Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0.2 is topping out at 1024 threads! threads or connections ? if the problem is about connection maybe change the parameter in your my.cnf : max_connections = 1024 to a higher value ... Hope this helps... Saludos / Regards, Alvaro. On Wed, 2004-11-17 at 11:18 -0800, Matt Babineau wrote: > From: > Matt Babineau > <[EMAIL PROTECTED]> >To: > [EMAIL PROTECTED] > Subject: > RE: MySQL 4.0.2 is topping out at > 1024 threads! > Date: > Wed, 17 Nov 2004 11:18:04 -0800 > (16:18 CLST) > > This is a very strange problem. As you can see there isn't a lot going > on, under a million queries. No problem right? This is a dual cpu 2.8 > Ghz server. Ok Great. I am also including my.cnf so you can see my > configuration. > > Here is some more info on the problem I am experiencing: > > mysql> status > -- > mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) > > Connection id: 25394 > Current database: > Current user: [EMAIL PROTECTED] > SSL:Not in use > Current pager: stdout > Using outfile: '' > Server version: 4.0.20-standard-log > Protocol version: 10 > Connection: 63.12.130.192 via TCP/IP > Client characterset:latin1 > Server characterset:latin1 > TCP port: 3306 > Uptime: 19 hours 40 min 2 sec > > Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush > tables: > 1 Open tables: 27 Queries per second avg: 11.044 > -- > > mysql> > > > == > > # Example mysql config file for very large systems. > # > # This is for large system with memory of 1G-2G where the system runs > mainly # MySQL. > # > # You can copy this file to > # /etc/my.cnf to set global options, > # mysql-data-dir/my.cnf to set server-specific options (in this # > installation this directory is /var/lib/mysql) or # ~/.my.cnf to set > user-specific options. > # > # One can in this file use all long options that the program supports. > # If you want to know which options a program support, run the program > # with --help option. > > # The following options will be passed to all MySQL clients [client] > #password = your_password > port= 3306 > socket = /var/lib/mysql/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port= 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer = 384M > max_allowed_packet = 1M > table_cache = 512 > connect_timeout = 10 > sort_buffer_size = 2M > read_buffer_size = 2M > myisam_sort_buffer_size = 64M > thread_cache = 8 > query_cache_size = 32M > # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 > max_connections = 1024 max_user_connections = 1024 > > # Don't listen on a TCP/IP port at all. This can be a security > enhancement, # if all processes that need to connect to mysqld run on > the same host. > # All interaction with mysqld must be made via Unix sockets or named > pipes. > # Note that using this option without enabling named pipes on Windows > # (via the "enable-named-pipe" option) will render mysqld useless! > # > #skip-networking > > # Replication Master Server (default) > # binary logging is required for replication log-bin > > # required unique id between 1 and 2^32 - 1 # defaults to 1 if > master-host is not set # but will not function as a master if omitted > server-id = 1 > > # Replication Slave (comment out master section to use this) # # To > configure this host as a replication slave, you can choose between # > two methods : > # > # 1) Use the CHANGE MASTER TO command (fully described in our manual) > - > #the syntax is: > # > #CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, > #MASTER_USER=, MASTER_PASSWORD
Re: MySQL 4.0.2 is topping out at 1024 threads!
In the last episode (Nov 17), Matt Babineau said: > This is a very strange problem. As you can see there isn't a lot going on, > under a million queries. No problem right? This is a dual cpu 2.8 Ghz > server. Ok Great. I am also including my.cnf so you can see my > configuration. > > Here is some more info on the problem I am experiencing: > > mysql> status > -- > mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) > > > Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush tables: > 1 Open tables: 27 Queries per second avg: 11.044 > -- So your real problem is not really the one you originally asked about? You now seem more interested in reducing the number of threads instead of raising the limit. Just run "show processlist", see what's taking up all your connections, and fix the clients :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.0.2 is topping out at 1024 threads!
threads or connections ? if the problem is about connection maybe change the parameter in your my.cnf : max_connections = 1024 to a higher value ... Hope this helps... Saludos / Regards, Alvaro. On Wed, 2004-11-17 at 11:18 -0800, Matt Babineau wrote: > From: > Matt Babineau > <[EMAIL PROTECTED]> >To: > [EMAIL PROTECTED] > Subject: > RE: MySQL 4.0.2 is topping out at > 1024 threads! > Date: > Wed, 17 Nov 2004 11:18:04 -0800 > (16:18 CLST) > > This is a very strange problem. As you can see there isn't a lot going > on, > under a million queries. No problem right? This is a dual cpu 2.8 Ghz > server. Ok Great. I am also including my.cnf so you can see my > configuration. > > Here is some more info on the problem I am experiencing: > > mysql> status > -- > mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) > > Connection id: 25394 > Current database: > Current user: [EMAIL PROTECTED] > SSL:Not in use > Current pager: stdout > Using outfile: '' > Server version: 4.0.20-standard-log > Protocol version: 10 > Connection: 63.12.130.192 via TCP/IP > Client characterset:latin1 > Server characterset:latin1 > TCP port: 3306 > Uptime: 19 hours 40 min 2 sec > > Threads: 1023 Questions: 781971 Slow queries: 0 Opens: 33 Flush > tables: > 1 Open tables: 27 Queries per second avg: 11.044 > -- > > mysql> > > > == > > # Example mysql config file for very large systems. > # > # This is for large system with memory of 1G-2G where the system runs > mainly > # MySQL. > # > # You can copy this file to > # /etc/my.cnf to set global options, > # mysql-data-dir/my.cnf to set server-specific options (in this > # installation this directory is /var/lib/mysql) or > # ~/.my.cnf to set user-specific options. > # > # One can in this file use all long options that the program supports. > # If you want to know which options a program support, run the program > # with --help option. > > # The following options will be passed to all MySQL clients > [client] > #password = your_password > port= 3306 > socket = /var/lib/mysql/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port= 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer = 384M > max_allowed_packet = 1M > table_cache = 512 > connect_timeout = 10 > sort_buffer_size = 2M > read_buffer_size = 2M > myisam_sort_buffer_size = 64M > thread_cache = 8 > query_cache_size = 32M > # Try number of CPU's*2 for thread_concurrency > thread_concurrency = 4 > max_connections = 1024 > max_user_connections = 1024 > > # Don't listen on a TCP/IP port at all. This can be a security > enhancement, > # if all processes that need to connect to mysqld run on the same > host. > # All interaction with mysqld must be made via Unix sockets or named > pipes. > # Note that using this option without enabling named pipes on Windows > # (via the "enable-named-pipe" option) will render mysqld useless! > # > #skip-networking > > # Replication Master Server (default) > # binary logging is required for replication > log-bin > > # required unique id between 1 and 2^32 - 1 > # defaults to 1 if master-host is not set > # but will not function as a master if omitted > server-id = 1 > > # Replication Slave (comment out master section to use this) > # > # To configure this host as a replication slave, you can choose > between > # two methods : > # > # 1) Use the CHANGE MASTER TO command (fully described in our manual) > - > #the syntax is: > # > #CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, > #MASTER_USER=, MASTER_PASSWORD= ; > # > #where you replace , , by quoted strings > and > # by the master's port number (3306 by default). > # > #Example: > # > #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, > #MASTER_USER='joe', MASTER_PASSWORD='secret'; > # > # OR > # > # 2) Set the variables below. However, in case you choose this method, > then > #start replication for the first time (even unsuccessfully, for > example > #if you mistyped the password in master-password and the slave > fails to > #connect), the s
RE: MySQL 4.0.2 is topping out at 1024 threads!
he_size = 384M #bdb_max_lock = 10 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Thanks All! Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 8:26 AM To: Gleb Paharenko Cc: [EMAIL PROTECTED] Subject: Re: MySQL 4.0.2 is topping out at 1024 threads! In the last episode (Nov 17), Gleb Paharenko said: > > Help! I can't figure out a way to stop my server from topping out at > > 1024 threads. This is a very strange behavoir. I have tons of legit > > use on my database server but I don't think the threads are dying > > does anyone have any suggestions for this? > > Similar problems are often found in lists. Usually they are solved by > increasing file limits. You likely need to increase open-files-limit. If you're running Linux, you may need to recompile your linuxthreads library also: http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.2 is topping out at 1024 threads!
In the last episode (Nov 17), Gleb Paharenko said: > > Help! I can't figure out a way to stop my server from topping out > > at 1024 threads. This is a very strange behavoir. I have tons of > > legit use on my database server but I don't think the threads are > > dying does anyone have any suggestions for this? > > Similar problems are often found in lists. Usually they are solved by > increasing file limits. You likely need to increase open-files-limit. If you're running Linux, you may need to recompile your linuxthreads library also: http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.2 is topping out at 1024 threads!
Hello. Similar problems are often found in lists. Usually they are solved by increasing file limits. You likely need to increase open-files-limit. >Help! I can't figure out a way to stop my server from topping out at 1024 >threads. This is a very strange behavoir. I have tons of legit use on my >database server but I don't think the threads are dying does anyone have any >suggestions for this? > >Thanks, > >Matt Babineau >Web Developer >Criticalcode - http://www.criticalcode.com >"Matt Babineau" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.2 is topping out at 1024 threads!
Help! I can't figure out a way to stop my server from topping out at 1024 threads. This is a very strange behavoir. I have tons of legit use on my database server but I don't think the threads are dying does anyone have any suggestions for this? Thanks, Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com
Re: mysql 4.0.2 preoblem
If you want them ordered by autoinc_field then add ORDER BY autoinc_field. Otherwise expect them to be returned in any order. Cres Justado wrote: can anyone help me with my problem regarding mysql 4.0.2. I'm having a problem with the sequencing of the auto incremnt field. if my application makes an insert mysql inserts the new row somewhere in the middle of the sequence. example autoinc_field data_field 1 qwe 2 ert 3 ou 20 oiu 4 ngf 5 ljn . . . . 18okj 19thd in my example the row 20 was inserted in the middle of the sequence instead of inserting it in the last row. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0.2 preoblem
That's how dbs work. When rows are deleted, they reclaim that space when new rows are inserted. Hence, there is no "last row" (in fact, no order at all) unless you explicitly order the results in your select. That's what ORDER BY is for. Try SELECT autoinc_field, data_field FROM yourtable ORDER BY autoinc_field; By the way, if you are really using mysql 4.0.2, you should consider an upgrade. 4.0.2 is over 2 years old. The current version is 4.0.20, and there have been a lot of improvements and bug fixes since 4.0.2. Michael Cres Justado wrote: can anyone help me with my problem regarding mysql 4.0.2. I'm having a problem with the sequencing of the auto incremnt field. if my application makes an insert mysql inserts the new row somewhere in the middle of the sequence. example autoinc_field data_field 1 qwe 2 ert 3 ou 20 oiu 4 ngf 5 ljn . . . . 18okj 19thd in my example the row 20 was inserted in the middle of the sequence instead of inserting it in the last row. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.0.2 preoblem
can anyone help me with my problem regarding mysql 4.0.2. I'm having a problem with the sequencing of the auto incremnt field. if my application makes an insert mysql inserts the new row somewhere in the middle of the sequence. example autoinc_field data_field 1 qwe 2 ert 3 ou 20 oiu 4 ngf 5 ljn . . . . 18okj 19thd in my example the row 20 was inserted in the middle of the sequence instead of inserting it in the last row. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.2 RPM install on RED HAT Fedora Core 1
I am trying to install the RPM and get a couple of errors saying the libsqlclient.so.10 RPM is missing. I have tried to search for this but cannot find the proper package for it. Any help would be appreciated! Sincerely, Chris Dietzler AT&T Enhanced Network Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multi-table delete is broken in MySQL 4.0.2
Hi! On Friday 01 November 2002 15:03, Jon Frisby wrote: > Why not just do: > DELETE FROM MyChannels; > DELETE FROM MyPackages; > > If you're concerned about atomicity, simply acquire a lock on both > tables at once first. Exactly, it was my concern. I'm not using MySQL tables with transaction support (need maximium speed and in my case transactions are usually not needed). Thank you for advice, I'll try to use locks. Alexei - 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 is broken in MySQL 4.0.2
If you do: SELECT * FROM MyChannels, MyPackages; Then you should also get nothing because what you're asking the database to do is to perform a cartesian cross of the rows in both tables. Since there's no row in one of the tables, the cross will contain no rows. Ideally one could do: DELETE FROM MyChannels, MyPackages USING MyChannels FULL OUTER JOIN MyPackages; Which would delete all rows from both tables even if either table was empty. However, MySQL does not support the FULL OUTER JOIN syntax. If you know that only one table is going to be empty then you can do a LEFT OUTER JOIN and simply place the possibly-empty table on the right. However, more broadly there's the issue of why you want to delete all rows from two tables in one query. It strikes me as odd that you'd do an unbounded JOIN just to empty two tables... Why not just do: DELETE FROM MyChannels; DELETE FROM MyPackages; If you're concerned about atomicity, simply acquire a lock on both tables at once first. -JF > -Original Message- > From: [EMAIL PROTECTED] [mailto:adets@;idsk.com] > Sent: Friday, August 02, 2002 1:04 PM > To: [EMAIL PROTECTED] > Subject: Multi-table delete is broken in MySQL 4.0.2 > > > >Description: > Multi-table delete is not working if one of the tables in the > delete statement is empty. > In my case I tried: > > DELETE FROM MyChannels, MyPackages USING MyChannels, MyPackages > > According to documentation this should delete all data in both tables. > In my case table MyPackages was empty (later I tried with > empty MyChannels and full MyPackages - got the same result). > In this case delete does NOTHING! > Only if _both_ tables contain at least one row all works as expected. > Tables are very simple: MyChannels contains two int columns, > MyPackages - just one int column. > > > >How-To-Repeat: > > >Fix: > > > >Submitter-Id: > >Originator: > >Organization: > > >MySQL support: none > >Synopsis:Multi-table delete is broken in MySQL 4.0.2 > >Severity:serious > >Priority:high > >Category:mysql > >Class: sw-bug > >Release: mysql-4.0.2-alpha (Official MySQL RPM) > >Server: /usr/bin/mysqladmin Ver 8.35 Distrib 4.0.2-alpha, > for pc-linux-gnu on i686 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free > software, > and you are welcome to modify and redistribute it under the > GPL license > > Server version4.0.2-alpha-Max > Protocol version 10 > ConnectionLocalhost via UNIX socket > UNIX socket /var/lib/mysql/mysql.sock > Uptime: 10 days 22 hours 20 min 26 sec > > Threads: 4 Questions: 439864 Slow queries: 1 Opens: 896 > Flush tables: 1 Open tables: 36 Queries per second avg: 0.466 > >Environment: > > System: Linux monacan 2.4.9-31 #1 Tue Feb 26 07:11:02 EST > 2002 i686 unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake > /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs > gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110) > Compilation info: CC='gcc' CFLAGS='-O6 > -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 > -fno-omit-frame-pointer -felide-constructors > -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' > LIBC: > lrwxrwxrwx1 root root 13 Mar 20 16:26 > /lib/libc.so.6 -> libc-2.2.4.so > -rwxr-xr-x2 root root 1285820 Jul 22 05:28 > /lib/libc-2.2.4.so > -rw-r--r--1 root root 27335606 Jul 22 04:58 > /usr/lib/libc.a > -rw-r--r--1 root root 178 Jul 22 04:58 > /usr/lib/libc.so > lrwxrwxrwx1 root root 10 Mar 5 13:10 > /usr/lib/libc-client.a -> c-client.a > Configure command: ./configure --disable-shared > --with-mysqld-ldflags=-all-static > --with-client-ldflags=-all-static > --with-other-libc=/usr/local/mysql-glibc > --without-berkeley-db --without-innodb --enable-assembler > --enable-local-infile --with-mysqld-user=mysql > --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ > --with-extra-charsets=complex --exec-prefix=/usr > --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share > --localstatedir=/var/lib/mysql --infodir=/usr/share/info > --includedir=/usr/include --mandir=/usr/share/man > --with-embedded-server --enable-thread-safe-client > '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 > -fno-omit-
Multi-table delete is broken in MySQL 4.0.2
>Description: Multi-table delete is not working if one of the tables in the delete statement is empty. In my case I tried: DELETE FROM MyChannels, MyPackages USING MyChannels, MyPackages According to documentation this should delete all data in both tables. In my case table MyPackages was empty (later I tried with empty MyChannels and full MyPackages - got the same result). In this case delete does NOTHING! Only if _both_ tables contain at least one row all works as expected. Tables are very simple: MyChannels contains two int columns, MyPackages - just one int column. >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: none >Synopsis: Multi-table delete is broken in MySQL 4.0.2 >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-4.0.2-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.35 Distrib 4.0.2-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.2-alpha-Max Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 10 days 22 hours 20 min 26 sec Threads: 4 Questions: 439864 Slow queries: 1 Opens: 896 Flush tables: 1 Open tables: 36 Queries per second avg: 0.466 >Environment: System: Linux monacan 2.4.9-31 #1 Tue Feb 26 07:11:02 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 20 16:26 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x2 root root 1285820 Jul 22 05:28 /lib/libc-2.2.4.so -rw-r--r--1 root root 27335606 Jul 22 04:58 /usr/lib/libc.a -rw-r--r--1 root root 178 Jul 22 04:58 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Mar 5 13:10 /usr/lib/libc-client.a -> c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - 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.2, 4.0.3,4.0.4 replication circle broken.
At 12:09 +0400 9/10/02, Artem V. Ryabov wrote: >Hello Victoria, > > As far as I see bug of muliple log files still not fixed regardless > of last change in 4.0.4: > 'FLUSH LOGS removed numerical extension for all future update logs.' This bugfix affects the update log, not the binary update log. It has no effect on replication. > >-- >Best regards, > Artem mailto:[EMAIL PROTECTED] > >sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.
Hello Victoria, As far as I see bug of muliple log files still not fixed regardless of last change in 4.0.4: 'FLUSH LOGS removed numerical extension for all future update logs.' -- Best regards, Artem mailto:[EMAIL PROTECTED] sql query - 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: MySQL 4.0.2, 4.0.3 replication circle broken.
Artem, Monday, September 02, 2002, 12:44:30 PM, you wrote: AVR> Thursday, August 15, 2002, you wrote: AVR>>> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR>>> this servers create endless loop, with creating new binary log file AVR>>> on each iteration. (about 30 new files every second in my case) >> Thanks for bug report! >> I tested it yesterday and also have got thousands of log files :( AVR> 4.0.3 Already out, but bug is still exists. AVR> Does anybody something to fix this bus? Hi! No, this bug is not fixed yet. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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.2, 4.0.3 replication circle broken.
Hello Victoria, Thursday, August 15, 2002, you wrote: AVR>> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR>> this servers create endless loop, with creating new binary log file AVR>> on each iteration. (about 30 new files every second in my case) > Thanks for bug report! > I tested it yesterday and also have got thousands of log files :( 4.0.3 Already out, but bug is still exists. Does anybody something to fix this bus? -- Best regards, Artem mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delete with join in mysql 4.0.2
Christian Longberg wrote: > I have just upgraded to mysql 4 to be able to perform delete queries > with join statement. I have a simple query where I would like to delete > a number of rows in tabel t1 depending on id's found in table t2. This > doesn't seem to work and I just don't understand why!? > > mysql> delete icl from ca_x_ind_com_lvl as icl, ca_individual as ind > where icl.ind_id = ind.ind_id and ind.acc_id_id = @acc_id; > ERROR 1066: Not unique table/alias: 'icl' > > Where @acc_id is set by: set @acc_id = 2; > > What am I doing wrong? > > BR > Christian You have a column named "icl" and have aliased a table as "icl". MySQL can't figure out which icl to use. You should use a different alias for ca_x_ind_com_lvl, or fully-specify the icl column as tablename.columnname. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ 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: Delete with join in mysql 4.0.2
Christian, Saturday, August 31, 2002, 11:09:47 AM, you wrote: CL> I have just upgraded to mysql 4 to be able to perform delete queries CL> with join statement. I have a simple query where I would like to delete CL> a number of rows in tabel t1 depending on id's found in table t2. This CL> doesn't seem to work and I just don't understand why!? CL> mysql> delete icl from ca_x_ind_com_lvl as icl, ca_individual as ind CL> where icl.ind_id = ind.ind_id and ind.acc_id_id = @acc_id; CL> ERROR 1066: Not unique table/alias: 'icl' CL> Where @acc_id is set by: set @acc_id = 2; CL> What am I doing wrong? Use real table name after DELETE, i.e. DELETE ca_x_ind_com_lvl FROM ca_x_ind_com_lvl AS icl, ca_individual AS ind WHERE icl.ind_id = ind.ind_id AND ind.acc_id_id = @acc_id; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete with join in mysql 4.0.2
I have just upgraded to mysql 4 to be able to perform delete queries with join statement. I have a simple query where I would like to delete a number of rows in tabel t1 depending on id's found in table t2. This doesn't seem to work and I just don't understand why!? mysql> delete icl from ca_x_ind_com_lvl as icl, ca_individual as ind where icl.ind_id = ind.ind_id and ind.acc_id_id = @acc_id; ERROR 1066: Not unique table/alias: 'icl' Where @acc_id is set by: set @acc_id = 2; What am I doing wrong? BR Christian === Christian Longberg | Tel: +46 8 730 16 74 Råsundavägen 150 | Mob: +46 70 547 53 67 169 36 Solna | Fax: +46 8 660 96 08 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2 doesn't unlock certain tables
The MySQL database we use is a 4.0.2 source RPM on a RedHat 7.3 MySQL locks tables while they are being updated and unlocks the table when the update is finished. But sometimes MySQL doesn't unlock certain tables. And in the process list their is nothing being processed. Does anybody know why or how I can fix this? Regards Jacob Friis Larsen [ JFL WebCom | www.sharksforum.com | www.eksperten.dk | +45 7027 0767 ] - 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.2 problems
Heh...ya I knew I fogot to do something. You would think that would be an install step. Next task is recompilling the apache httpd as it doesnt like not having the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11 thx for the tip. =D -Nick louie miranda said: > Add the mysql lib path on /etc/ld.so.conf > and type ldconfig. > > :) > > > = > Thanks, > Louie Miranda... > > WebUrl: http://axis0.endofinternet.org > Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] > > - Original Message - > From: "Nick Stuart" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 20, 2002 12:23 PM > Subject: mysql 4.0.2 problems > > >> Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My >> problem is that when I go to connect to it I get the error: >> error while loading shared libraries: libmysqlclient.so.11: cannot >> open shared object file: No such file or directory >> >> Actually (just fixed it). All I had to do was and a soft link the the >> /lib directory. Anyone know if this is normal or not? >> >> -Nick >> >> >> - >> Before posting, please check: >>http://www.mysql.com/manual.php (the manual) >>http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> To >> unsubscribe, e-mail > <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.0.2 problems
Add the mysql lib path on /etc/ld.so.conf and type ldconfig. :) = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Original Message - From: "Nick Stuart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 12:23 PM Subject: mysql 4.0.2 problems > Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My > problem is that when I go to connect to it I get the error: > error while loading shared libraries: libmysqlclient.so.11: cannot open > shared object file: No such file or directory > > Actually (just fixed it). All I had to do was and a soft link the the > /lib directory. Anyone know if this is normal or not? > > -Nick > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 4.0.2 problems
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My problem is that when I go to connect to it I get the error: error while loading shared libraries: libmysqlclient.so.11: cannot open shared object file: No such file or directory Actually (just fixed it). All I had to do was and a soft link the the /lib directory. Anyone know if this is normal or not? -Nick - 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.2, 4.0.3 replication circle broken.
Artem, Thursday, August 15, 2002, 12:06:07 PM, you wrote: AVR> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR> this servers create endless loop, with creating new binary log file AVR> on each iteration. (about 30 new files every second in my case) Thanks for bug report! I tested it yesterday and also have got thousands of log files :( -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2, 4.0.3 replication circle broken.
Hello mysql, In case of repliacation circle (A->B->A) query 'flush log' on any of this servers create endless loop, with creating new binary log file on each iteration. (about 30 new files every second in my case) -- Best regards, Artem mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.2 replication circle broken?
Hello all, I was check up 4.0.3 (from the Development Source Tree), bug still exist. >>Description: aor> I use replication circle (A->B, B->A) with 3.23.51 - all ok. aor> But I got problem, when upgrade both my servers to 4.0.2. aor> Mysqld create 30 new bin-log files every second at both servers: aor> --- aor> [www2:/opt/mysql-dev/var]:1303# ls -1 www2-bin.* | wc -l aor>2268 aor> [www2:/opt/mysql-dev/var]:1306# l www2-bin.00* aor> -rw-rw1 mysqlmysql 137 Aug 12 16:31 www2-bin.001 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.002 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.003 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.004 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.005 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.006 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.007 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.008 aor> -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.009 aor> [www2:/opt/mysql-dev/var]:1304# ../bin/mysqlbinlog www2-bin.001 aor> # at 4 aor> #020812 16:29:30 server id 1 log_pos 4 Start: binlog v 3, server v 4.0. aor> 2-alpha-log created 020812 16:29:30 aor> # at 79 aor> #020812 16:31:13 server id 2 log_pos 79Rotate to www2-bin.002 pos: 4 aor> # at 118 aor> #020812 16:31:13 server id 1 log_pos 118 Stop aor> [www2:/opt/mysql-dev/var]:1305# ../bin/mysqlbinlog www2-bin.002 aor> # at 4 aor> #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.003 pos: 4 aor> # at 43 aor> #020812 16:31:13 server id 1 log_pos 43Stop aor> [www2:/opt/mysql-dev/var]:1307# ../bin/mysqlbinlog www2-bin.003 aor> # at 4 aor> #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.004 pos: 4 aor> # at 43 aor> #020812 16:31:13 server id 1 log_pos 43Stop aor> [www2:/opt/mysql-dev/var]:1308# aor> -- aor> and so on. aor> Will be fixed this error in 4.0.3? >>How-To-Repeat: >>Fix: >>Submitter-Id: >>Originator:Artem Ryabov >>Organization: >>MySQL support: none >>Synopsis: too many bin-log files >>Severity: serious >>Priority: medium >>Category: mysql >>Class: sw-bug >>Release: mysql-4.0.2-alpha (Source distribution) >>Environment: aor> System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown aor> Architecture: i686 aor> Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc aor> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs aor> gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) aor> Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' aor> LIBC: aor> lrwxrwxrwx1 root root 11 Nov 25 2000 /lib/libc.so.6 -> libc-2.2.so aor> -rwxr-xr-x1 root root 5155229 Jan 11 2001 /lib/libc-2.2.so aor> -rw-r--r--1 root root 24498288 Jan 11 2001 /usr/lib/libc.a aor> -rw-r--r--1 root root 178 Jan 11 2001 /usr/lib/libc.so aor> configure command: ./configure --with-mysqld-ldflags=-all-static --disable-shared --prefix=/opt/mysql-dev --with-charset=cp1251 -- Best regards, Artemmailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2 replication circle broken?
>Description: I use replication circle (A->B, B->A) with 3.23.51 - all ok. But I got problem, when upgrade both my servers to 4.0.2. Mysqld create 30 new bin-log files every second at both servers: --- [www2:/opt/mysql-dev/var]:1303# ls -1 www2-bin.* | wc -l 2268 [www2:/opt/mysql-dev/var]:1306# l www2-bin.00* -rw-rw1 mysqlmysql 137 Aug 12 16:31 www2-bin.001 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.002 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.003 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.004 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.005 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.006 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.007 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.008 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.009 [www2:/opt/mysql-dev/var]:1304# ../bin/mysqlbinlog www2-bin.001 # at 4 #020812 16:29:30 server id 1 log_pos 4 Start: binlog v 3, server v 4.0. 2-alpha-log created 020812 16:29:30 # at 79 #020812 16:31:13 server id 2 log_pos 79Rotate to www2-bin.002 pos: 4 # at 118 #020812 16:31:13 server id 1 log_pos 118 Stop [www2:/opt/mysql-dev/var]:1305# ../bin/mysqlbinlog www2-bin.002 # at 4 #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.003 pos: 4 # at 43 #020812 16:31:13 server id 1 log_pos 43Stop [www2:/opt/mysql-dev/var]:1307# ../bin/mysqlbinlog www2-bin.003 # at 4 #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.004 pos: 4 # at 43 #020812 16:31:13 server id 1 log_pos 43Stop [www2:/opt/mysql-dev/var]:1308# -- and so on. Will be fixed this error in 4.0.3? >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Artem Ryabov >Organization: >MySQL support: none >Synopsis: too many bin-log files >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.2-alpha (Source distribution) >Environment: System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Nov 25 2000 /lib/libc.so.6 -> libc-2.2.so -rwxr-xr-x1 root root 5155229 Jan 11 2001 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 11 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 11 2001 /usr/lib/libc.so configure command: ./configure --with-mysqld-ldflags=-all-static --disable-shared --prefix=/opt/mysql-dev --with-charset=cp1251 - 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.2 startup problems
Hi, it's a bit late reply, to my original mail sent to bugs list. Now the problem reappeared as the box got rebooted. I was receiving in $hostname.err: 020812 11:34:20 mysqld started 020812 11:34:20 Can't find messagefile 'mysql-4.0.2-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 020812 11:34:20 Aborting 020812 11:34:20 mysqld ended $ diff -u -w mysql-4.0.2-alpha-pc-linux-gnu-i686/support-files/mysql.server /etc/init.d/mysql --- mysql-4.0.2-alpha-pc-linux-gnu-i686/support-files/mysql.server Mon Jul 1 14:52:15 2002 +++ /etc/init.d/mysql Mon Aug 12 11:42:30 2002 @@ -29,11 +29,11 @@ # If you want to affect other MySQL variables, you should make your changes # in the /etc/my.cnf or other configuration files. -PATH=/sbin:/usr/sbin:/bin:/usr/bin +PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/mysql/bin export PATH # Set some defaults -datadir=/usr/local/mysql/data +datadir=/data1/mysql basedir= pid_file= if test -z "$basedir" @@ -45,7 +45,7 @@ fi if test -z "$pid_file" then - pid_file=$datadir/`@HOSTNAME@`.pid + pid_file=$datadir/jerboas.pid else case "$pid_file" in /* ) ;; @@ -116,7 +116,7 @@ then # Give extra arguments to mysqld with the my.cnf file. This script may # be overwritten at next upgrade. - $bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file & + $bindir/mysqld_safe --skip-innodb --datadir=$datadir --pid-file=$pid_file & # Make lock for RedHat / SuSE if test -w /var/lock/subsys then On Wed, 17 Jul 2002, Alexander Keremidarski wrote: > > Martin MOKREJŠ wrote: > > How-To-Repeat: > > > > /usr/local/mysql/log# cp /dev/null jerboas.log > > /usr/local/mysql/log# cp /dev/null jerboas.err > > /usr/local/mysql/log# /etc/rc3.d/S98mysql start > > /usr/local/mysql/log# Starting mysqld daemon with databases from /data1/mysql > > 020716 20:21:26 mysqld ended > > Use mysql.server script from 4.0.2 tree. It knows where to find mysqld_safe Thanks, I copied that file over. See above the diff. > cp mysql.server /etc/rc.d/initd/mysql > chmod +x /etc/rc.d/initd/mysql > chkconfig --add mysql > > or use your favorite method to link it in appropriate runlevel dirs. I've suspected that mysqld operates in unexpected current directory, and this really helped: cd /usr/local/mysql (which is a symlink to /usr/local/mysql-4.0.2-alpha-pc-linux-gnu-i686) ln -s . mysql-4.0.2-alpha-pc-linux-gnu-i686 Now when mysqld is in /usr/local/mysql and want's to see mysql-4.0.2-alpha-pc-linux-gnu-i686/share*, it can get it. Please note that I dod not re-set "$bindir" inside /etc/my.cnf. However, $basedir is reported by 'mysqladmin variables' to be set to 'mysql-4.0.2-alpha-pc-linux-gnu-i686/'. Maybe that's my problem? TIA Please Cc: me in replies, if possible. -- Martin Mokrejs <[EMAIL PROTECTED]> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3683 , fax: +49-89-3187 3585 - 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
FreeBSD/MySQL 4.0.2 and UNION buggy?
Is anyone else seeing odd problems with heavy use of UNIONs on a MySQL 4.0.x server on FreeBSD? I seem to be able to induce the problem on FreeBSD but not Linux. I have a lot more testing to do yet, but if someone else is seeing it that would really help to narrow the bug down. Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 63 days, processed 1,333,225,384 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Issues with MySQL 4.0.2
DBs(ML), Saturday, July 20, 2002, 3:50:48 PM, you wrote: DM> 2) Nope, I have nothing on the end of the line. DM> eg. DM> set-variable = back_log = 200 DM> this works under 4.0.1 but not under 4.0.2 DM> back_log = 200 DM> this works under 4.0.2 DM> Error: (from 4.0.2 when using set-variable = back_log = 200) DM> 020710 09:42:31 mysqld started DM> /usr/local/mysql4/libexec/mysqld: ERROR: unknown variable 'back_log = 200' DM> 020710 09:42:31 mysqld ended Try to remove blanks around '=' in the my.cnf. Does mysqld start? DM> Like I said earlier, if I remove the set-variable it works and actually sets DM> the value correctly. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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.2 replication going bonkers?
Jeremy, - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: "Jon Frisby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 19, 2002 7:17 AM Subject: Re: MySQL 4.0.2 replication going bonkers? > On Wed, Jul 17, 2002 at 12:02:08PM +0300, Heikki Tuuri wrote: > > Jon, > > > > replication 4.0.1 -> 4.0.2 does not work because the format in the 4.0 > > series has evolved. Currently, if your master of the 4.0 series, your slave > > must be of the exact same release. > > How likely is that to happen again? I just upgraded my last slave to > 4.0.3 and all the othres are running various builds of 4.0.2. The master > is running 3.23.51. I'm planning to upgrade it to 4.0.x after OSCON. But > if this is likely to happen a few more times, I'll wait. I don't want > upgrades to be an "all servers or no servers" situation. 4.0.1 was 6 months old when 4.0.2 came. I guess no changes, except bug fixes, in the 4.0 series happen any more; they are put to to the 4.1 branch. > Thanks, > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 50 days, processed 1,073,978,230 queries (247/sec. avg) Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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.2 replication going bonkers?
On Wed, Jul 17, 2002 at 12:02:08PM +0300, Heikki Tuuri wrote: > Jon, > > replication 4.0.1 -> 4.0.2 does not work because the format in the 4.0 > series has evolved. Currently, if your master of the 4.0 series, your slave > must be of the exact same release. How likely is that to happen again? I just upgraded my last slave to 4.0.3 and all the othres are running various builds of 4.0.2. The master is running 3.23.51. I'm planning to upgrade it to 4.0.x after OSCON. But if this is likely to happen a few more times, I'll wait. I don't want upgrades to be an "all servers or no servers" situation. Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,073,978,230 queries (247/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error in Windows download of MySQL-Max-4.0.2; download MySQL-4.0.2 instead
Hi! There is an error in the Windows download of MySQL-Max-4.0.2. It is a wrong file, the same as MySQL-Max-4.0.1. If you do not need BDB tables, please download the Windows version of MySQL-4.0.2 (without the 'Max') instead. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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.2 replication going bonkers?
Jon, replication 4.0.1 -> 4.0.2 does not work because the format in the 4.0 series has evolved. Currently, if your master of the 4.0 series, your slave must be of the exact same release. All 3.23 versions after 3.23.33 can be replicated from each other 4.0.0 can only replicate to/from 4.0.0. 4.0.1 slave can replicate from a 3.23.33 and newer 3.23 master, and can only replicate from a 4.0.1 master in the 4.0 branch. 4.0.2 slave can replicate from a 3.23 master, and can only replicate from a 4.0.2 master in the 4.0 branch. || Master || 3.23.33 and up | 4.0.0 | 4.0.1 | 4.0.2 Slave | 3.23.33 and up | yes| no| no| no | 4.0.0 | no | yes | no| no | 4.0.1 | yes| no| yes | no | 4.0.2 | yes| no| no| yes Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: ""Jon Frisby"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, July 16, 2002 4:30 AM Subject: RE: MySQL 4.0.2 replication going bonkers? > This seems to have not gotten through... Perhaps the spam filter ate it? > (sql, query) > > -JF > > > -Original Message- > > From: Jon Frisby [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 15, 2002 4:27 PM > > To: [EMAIL PROTECTED] > > Subject: MySQL 4.0.2 replication going bonkers? > > > > > > We recently set up a 4.0.2 slave, which worked fine -- we loaded > > our data snapshot (taken via mysqldump) and were able to perform > > complex queries without problems... > > > > However, as soon as we tried to get this machine to act as a > > slave to a 4.0.1 server it crashed. Immediately upon executing > > "SLAVE START", we get messages like this in the error log: > > > > 020714 01:32:03 mysqld started > > 020714 1:32:05 InnoDB: Started > > /usr/sbin/mysqld-max: ready for connections > > 020714 8:00:28 Slave SQL thread initialized, starting > > replication in log 'server2-bin.035' at position 579285542, relay > > log './db1-relay-bin.001' position: 4 > > 020714 8:00:29 Slave I/O thread: connected to master > > '[EMAIL PROTECTED]:3306', replication started in log > > 'server2-bin.035' at position 579285542 ERROR: 1146 Table > > 'test.response' doesn't exist > > 020714 8:00:30 Slave: error 'Table 'test.response' doesn't > > exist' on query 'INSERT INTO response SET > > connect_time=0.073868989944458, page_time=1.53695404529572, > > site_id='Apt'', error_code=1146 > > 020714 8:00:30 Error running query, slave SQL thread aborted. > > Fix the problem, and restart the slave SQL thread with "SLAVE > > START". We stopped at log 'server2-bin.035' position 579285542 > > 020714 8:00:30 Slave SQL thread exiting, replication stopped in > > log 'server2-bin.035' at position 579285542 > > 020714 8:00:54 Error reading packet from server: (server_errno=1159) > > 020714 8:00:54 Slave I/O thread killed while reading event > > 020714 8:00:54 Slave I/O thread exiting, read up to log > > 'server2-bin.035', position 579993154 > > 020714 8:01:58 /usr/sbin/mysqld-max: Normal shutdown > > > > 020714 8:01:58 InnoDB: Starting shutdown... > > 020714 8:02:05 InnoDB: Shutdown completed > > 020714 8:02:06 /usr/sbin/mysqld-max: Shutdown Complete > > > > 020714 08:02:06 mysqld ended > > > > 020714 08:02:16 mysqld started > > 020714 8:02:17 InnoDB: Started > > /usr/sbin/mysqld-max: ready for connections > > 020714 8:02:34 Slave SQL thread initialized, starting > > replication in log 'FIRST' at position 0, relay log > > './db1-relay-bin.001' position: 4 > > ERROR: 1146 Table 'test.response' doesn't exist > > 020714 8:02:34 Slave: error 'Table 'test.response' doesn't > > exist' on query 'INSERT INTO response SET > > connect_time=0.073868989944458, page_time=1.53695404529572, site_id='Apt > > '', error_code=1146 > > 020714 8:02:34 Error running query, slave SQL thread aborted. > > Fix the problem, and restart the slave SQL thread with "SLAVE > > START". We stopped at log 'FIRST' position 0 > > 020714 8:02:34 Slave SQL thread exiting, replication stopped in > > log 'FIRST' at
RE: MySQL 4.0.2 replication going bonkers?
This seems to have not gotten through... Perhaps the spam filter ate it? (sql, query) -JF > -Original Message- > From: Jon Frisby [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 4:27 PM > To: [EMAIL PROTECTED] > Subject: MySQL 4.0.2 replication going bonkers? > > > We recently set up a 4.0.2 slave, which worked fine -- we loaded > our data snapshot (taken via mysqldump) and were able to perform > complex queries without problems... > > However, as soon as we tried to get this machine to act as a > slave to a 4.0.1 server it crashed. Immediately upon executing > "SLAVE START", we get messages like this in the error log: > > 020714 01:32:03 mysqld started > 020714 1:32:05 InnoDB: Started > /usr/sbin/mysqld-max: ready for connections > 020714 8:00:28 Slave SQL thread initialized, starting > replication in log 'server2-bin.035' at position 579285542, relay > log './db1-relay-bin.001' position: 4 > 020714 8:00:29 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log > 'server2-bin.035' at position 579285542 ERROR: 1146 Table > 'test.response' doesn't exist > 020714 8:00:30 Slave: error 'Table 'test.response' doesn't > exist' on query 'INSERT INTO response SET > connect_time=0.073868989944458, page_time=1.53695404529572, > site_id='Apt'', error_code=1146 > 020714 8:00:30 Error running query, slave SQL thread aborted. > Fix the problem, and restart the slave SQL thread with "SLAVE > START". We stopped at log 'server2-bin.035' position 579285542 > 020714 8:00:30 Slave SQL thread exiting, replication stopped in > log 'server2-bin.035' at position 579285542 > 020714 8:00:54 Error reading packet from server: (server_errno=1159) > 020714 8:00:54 Slave I/O thread killed while reading event > 020714 8:00:54 Slave I/O thread exiting, read up to log > 'server2-bin.035', position 579993154 > 020714 8:01:58 /usr/sbin/mysqld-max: Normal shutdown > > 020714 8:01:58 InnoDB: Starting shutdown... > 020714 8:02:05 InnoDB: Shutdown completed > 020714 8:02:06 /usr/sbin/mysqld-max: Shutdown Complete > > 020714 08:02:06 mysqld ended > > 020714 08:02:16 mysqld started > 020714 8:02:17 InnoDB: Started > /usr/sbin/mysqld-max: ready for connections > 020714 8:02:34 Slave SQL thread initialized, starting > replication in log 'FIRST' at position 0, relay log > './db1-relay-bin.001' position: 4 > ERROR: 1146 Table 'test.response' doesn't exist > 020714 8:02:34 Slave: error 'Table 'test.response' doesn't > exist' on query 'INSERT INTO response SET > connect_time=0.073868989944458, page_time=1.53695404529572, site_id='Apt > '', error_code=1146 > 020714 8:02:34 Error running query, slave SQL thread aborted. > Fix the problem, and restart the slave SQL thread with "SLAVE > START". We stopped at log 'FIRST' position 0 > 020714 8:02:34 Slave SQL thread exiting, replication stopped in > log 'FIRST' at position 0 > 020714 8:02:34 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log > 'server2-bin.035' at position 579993154 > 020714 8:03:02 Error reading packet from server: (server_errno=1159) > 020714 8:03:02 Slave I/O thread killed while reading event > 020714 8:03:02 Slave I/O thread exiting, read up to log > 'server2-bin.035', position 579993478 > 020714 8:03:25 /usr/sbin/mysqld-max: Normal shutdown > > 020714 8:03:25 InnoDB: Starting shutdown... > 020714 8:03:28 InnoDB: Shutdown completed > 020714 8:03:28 /usr/sbin/mysqld-max: Shutdown Complete > > 020714 08:03:28 mysqld ended > > 020714 08:03:36 mysqld started > 020714 8:03:38 InnoDB: Started > /usr/sbin/mysqld-max: ready for connections > 020714 8:04:02 Slave SQL thread initialized, starting > replication in log 'FIRST' at position 0, relay log > './db1-relay-bin.001' position: 4 > mysqld got signal 11; > This could be because you hit a bug. It is also possible that > this binary or one of the libraries it was linked against is > corrupt, improperly built, or misconfigured. This error can also > be caused by malfunctioning hardware. We will try our best to > scrape up some info that will hopefully help diagnose the > problem, but since we have already crashed, something is > definitely wrong and this may fail. > > key_buffer_size=67104768 > record_buffer=16773120 > sort_buffer=16777208 > max_used_connections=0 > max_connectio
MySQL 4.0.2 replication going bonkers?
We recently set up a 4.0.2 slave, which worked fine -- we loaded our data snapshot (taken via mysqldump) and were able to perform complex queries without problems... However, as soon as we tried to get this machine to act as a slave to a 4.0.1 server it crashed. Immediately upon executing "SLAVE START", we get messages like this in the error log: 020714 01:32:03 mysqld started 020714 1:32:05 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 020714 8:00:28 Slave SQL thread initialized, starting replication in log 'server2-bin.035' at position 579285542, relay log './db1-relay-bin.001' position: 4 020714 8:00:29 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'server2-bin.035' at position 579285542 ERROR: 1146 Table 'test.response' doesn't exist 020714 8:00:30 Slave: error 'Table 'test.response' doesn't exist' on query 'INSERT INTO response SET connect_time=0.073868989944458, page_time=1.53695404529572, site_id='Apt'', error_code=1146 020714 8:00:30 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'server2-bin.035' position 579285542 020714 8:00:30 Slave SQL thread exiting, replication stopped in log 'server2-bin.035' at position 579285542 020714 8:00:54 Error reading packet from server: (server_errno=1159) 020714 8:00:54 Slave I/O thread killed while reading event 020714 8:00:54 Slave I/O thread exiting, read up to log 'server2-bin.035', position 579993154 020714 8:01:58 /usr/sbin/mysqld-max: Normal shutdown 020714 8:01:58 InnoDB: Starting shutdown... 020714 8:02:05 InnoDB: Shutdown completed 020714 8:02:06 /usr/sbin/mysqld-max: Shutdown Complete 020714 08:02:06 mysqld ended 020714 08:02:16 mysqld started 020714 8:02:17 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 020714 8:02:34 Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './db1-relay-bin.001' position: 4 ERROR: 1146 Table 'test.response' doesn't exist 020714 8:02:34 Slave: error 'Table 'test.response' doesn't exist' on query 'INSERT INTO response SET connect_time=0.073868989944458, page_time=1.53695404529572, site_id='Apt '', error_code=1146 020714 8:02:34 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'FIRST' position 0 020714 8:02:34 Slave SQL thread exiting, replication stopped in log 'FIRST' at position 0 020714 8:02:34 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'server2-bin.035' at position 579993154 020714 8:03:02 Error reading packet from server: (server_errno=1159) 020714 8:03:02 Slave I/O thread killed while reading event 020714 8:03:02 Slave I/O thread exiting, read up to log 'server2-bin.035', position 579993478 020714 8:03:25 /usr/sbin/mysqld-max: Normal shutdown 020714 8:03:25 InnoDB: Starting shutdown... 020714 8:03:28 InnoDB: Shutdown completed 020714 8:03:28 /usr/sbin/mysqld-max: Shutdown Complete 020714 08:03:28 mysqld ended 020714 08:03:36 mysqld started 020714 8:03:38 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 020714 8:04:02 Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './db1-relay-bin.001' position: 4 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=67104768 record_buffer=16773120 sort_buffer=16777208 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 3341931 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x85204a0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe3f248, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80722d8 0x82de908 0x82cb534 0x80e9a58 0x80af595 0x80b04f4 0x80ebf71 0x80ece8f 0x82dbf1c 0x831193a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=3 Successfully dumpe
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
Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDSincl., but need help with FIXes
ar -d [-TLv] archive file ... ar -m [-TLv] archive file ... ar -m [-abiTLv] position archive file ... ar -p [-TLv] archive [file ...] ar -q [-cTLv] archive file ... ar -r [-cuTLv] archive file ... ar -r [-abciuTLv] position archive file ... ar -t [-TLv] archive [file ...] ar -x [-ouTLv] archive [file ...] make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory `/usr/ports/mysql-4.0.2-alpha/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/ports/mysql-4.0.2-alpha' make: *** [all-recursive-am] Error 2 [root@server] __ Richard S. Blake Foster City, CA ph 650 571 0225 fx 240 525 2666 [EMAIL PROTECTED] __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyCC-0.8.4 and MySQL-4.0.2
Hi all. I just upgraded to MySQL-4.0.2 (great work guys) and noticed that MyCC's user administration isn't displaying privileges properly, ie doesn't show them at all. (When I say upgrade, I mean a full uninstall & new install, and import from mysqldump backups). Granting seems to work OK (I think) but anyway I'm a bit scared to use it at the moment... I assume this is because of the updates to MySQL's grant tables relating to the 'create temp table' privileges, but I'm just guessing here. Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl., but need help with FIXes
In the last episode (Jul 14), R Blake said:
> --On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Jul 13), R Blake said:
> >>BUG #1:
> >> does not seem to exist in BSD variants (cref:
> >>http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but
> >>nonetheless, "./configure" sets HAVE_POLL as defined, causing make to
> >>fail with sys/poll.h "not found".
> >>
> >
> > The correct thing to do is probably to fix include/my_net.h. poll
> > requires , not . In addition, there should be
> > an autoconf check for , instead of assuming that because
> > you have a poll function there is also a poll.h.
>
> that may be the case, assuming poll.h exists ANYWHERE on the system
> that unfortunately is the problem here
> (http://www.netsys.com/bsdi-users/2001-11/msg00093.html)
It does exist on FreeBSD, NetBSD, and OpenBSD. So "man poll" doesn't
come up with anything on your system? I wonder where it's picking up
the poll function from, then. HAVE_POLL means it was able to link a
dummy program consisting of "main(){ poll(); }" .
> i think your autoconf check suggestion makes sense, but where should
> the change be made in the autoconf or mysql distribution?
mysql, since it's the one using poll. If there were an AC_FUNC_POLL
macro that did all the work for you, then it would go into autoconf,
but there isn't.
--
Dan Nelson
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDSincl., but need help with FIXes
dan, thx for your reply! --On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Jul 13), R Blake said: >> BUG #1: >> does not seem to exist in BSD variants (cref: >> http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but >> nonetheless, "./configure" sets HAVE_POLL as defined, causing make to >> fail with sys/poll.h "not found". >> >> WORKAROUND: >> == >> (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in >> (CHANGE) >> /* Define if you have the poll function. */ >> # define HAVE_POLL 1 >> (TO) >> /* Define if you have the poll function. */ >> /* #define HAVE_POLL 1 */ >> == > > The correct thing to do is probably to fix include/my_net.h. poll > requires , not . In addition, there should be an > autoconf check for , instead of assuming that because you have > a poll function there is also a poll.h. > > http://www.opengroup.org/onlinepubs/007904975/functions/poll.html > > --- include/my_net.h~ Mon Jul 1 06:16:44 2002 > +++ include/my_net.hSun Jul 14 13:43:49 2002 > @@ -38,7 +38,7 @@ > #include > #endif > #ifdef HAVE_POLL > -#include > +#include > #endif > #ifdef HAVE_SYS_IOCTL_H > #include > that may be the case, assuming poll.h exists ANYWHERE on the system that unfortunately is the problem here (http://www.netsys.com/bsdi-users/2001-11/msg00093.html) i think your autoconf check suggestion makes sense, but where should the change be made in the autoconf or mysql distribution? >> BUG #2: >> a subsequent "make" fails with: >> >> ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o >> rltty.o complete.o bind.o isearch.o display.o signals.o util.o kill.o >> undo.o macro.o input.o callback.o terminal.o xmalloc.o history.o >> histsearch.o histexpand.o histfile.o nls.o search.o shell.o tilde.o >> ranlib libreadline.a >> make[2]: Leaving directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/readline' >> Making all in pstack >> make[2]: Entering directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' >> Making all in aout >> make[3]: Entering directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' >> make[3]: Nothing to be done for `all'. >> make[3]: Leaving directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' >> make[3]: Entering directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' >> make[3]: Nothing to be done for `all-am'. >> make[3]: Leaving directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' >> make[2]: Leaving directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' >> Making all in libmysql >> make[2]: Entering directory >> `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' >> /bin/sh ../libtool --mode=compile cc >> -DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\"" >> -DDATADIR="\"/private/var/mysql\"" >> -DSHAREDIR="\"/usr/local/var/mysql/mysql\"" -DUNDEF_THREADS_HACK >> -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. >> -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include >> -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 >> -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib >> -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib >> -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE >> -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH >> -c libmysql.c >> cc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\" >> -DDATADIR=\"/private/var/mysql\" >> -DSHAREDIR=\"/usr/local/var/mysql/mysql\" -DUNDEF_THREADS_HACK >> -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. >> -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include >> -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 >> -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib >> -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib >> -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE >> -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH >> -c libmysql.c -o libmysql.o >> libmysql.c: In function `mysql_real_connect': >> libmysql.c:1663: sizeof applied to an incomplete type >> make[2]:
Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl., but need help with FIXes
In the last episode (Jul 13), R Blake said: > BUG #1: > does not seem to exist in BSD variants (cref: > http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless, > "./configure" sets HAVE_POLL as defined, causing make to fail with > sys/poll.h "not found". > > WORKAROUND: > ====== > (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in > (CHANGE) > /* Define if you have the poll function. */ > #define HAVE_POLL 1 > (TO) > /* Define if you have the poll function. */ > /* #define HAVE_POLL 1 */ > == The correct thing to do is probably to fix include/my_net.h. poll requires , not . In addition, there should be an autoconf check for , instead of assuming that because you have a poll function there is also a poll.h. http://www.opengroup.org/onlinepubs/007904975/functions/poll.html --- include/my_net.h~ Mon Jul 1 06:16:44 2002 +++ include/my_net.hSun Jul 14 13:43:49 2002 @@ -38,7 +38,7 @@ #include #endif #ifdef HAVE_POLL -#include +#include #endif #ifdef HAVE_SYS_IOCTL_H #include > > BUG #2: > a subsequent "make" fails with: > > ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o > rltty.o complete.o bind.o isearch.o display.o signals.o util.o kill.o > undo.o macro.o input.o callback.o terminal.o xmalloc.o history.o > histsearch.o histexpand.o histfile.o nls.o search.o shell.o tilde.o > ranlib libreadline.a > make[2]: Leaving directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/readline' > Making all in pstack > make[2]: Entering directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' > Making all in aout > make[3]: Entering directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' > make[3]: Nothing to be done for `all'. > make[3]: Leaving directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' > make[3]: Entering directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' > make[3]: Nothing to be done for `all-am'. > make[3]: Leaving directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' > make[2]: Leaving directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' > Making all in libmysql > make[2]: Entering directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' > /bin/sh ../libtool --mode=compile cc > -DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\"" > -DDATADIR="\"/private/var/mysql\"" > -DSHAREDIR="\"/usr/local/var/mysql/mysql\"" -DUNDEF_THREADS_HACK > -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. > -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include > -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 > -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib > -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib > -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE > -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c > libmysql.c > cc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\" > -DDATADIR=\"/private/var/mysql\" -DSHAREDIR=\"/usr/local/var/mysql/mysql\" > -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include > -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include > -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include > -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks > -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib > -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE > -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c > libmysql.c -o libmysql.o > libmysql.c: In function `mysql_real_connect': > libmysql.c:1663: sizeof applied to an incomplete type > make[2]: *** [libmysql.lo] Error 1 > make[2]: Leaving directory > `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha' > make: *** [all-recursive-am] Error 2 > [root@server] > > i don't have a FIX, but commenting out the offending code (also in > 'manager.c') seems to do the trick The error is because GETHOSTBYNAME_BUFF_SIZE expands to sizeof(struct hostent_data) and hostent_data is not defined. I think that should be "struct hostent" instead (I can't find "struct hostent_data" defined anywhere on the systems I have access to). --- include/my_net.h~ Sun Jul 14 13:43:49 2002 +++
rpm of plain MySQL-4.0.2 does not contain InnoDB; download rpm of MySQL-Max-4.0.2 instead
Hi! Due to an error in the build process, the rpm of plain MySQL-4.0.2 does not contain InnoDB. Please download the rpm of MySQL-Max-4.0.2 instead. The error in the build of the plain MySQL-4.0.2 rpm will be fixed in the coming days. Best regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl.,but need help with FIXes
three BUGS are reported here that have cropped up in mysql-4.0.2-alpha current system has a SUCCESSFUL install of: >Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for apple-darwin5.4 on powerpc the 3 bugs: (1) poll.h not present in BSD variants; HAVE_POLL set to #define (2) "sizeof applied to an incomplete type" in libmysql/libmysql.c & libmysql/manager.c (3) thread-safe-client & with-pthreads are breaking all over the place (haven't tracked it down yet ...) DL: http://mysql.he.net/Downloads/MySQL-4.0/mysql-4.0.2-alpha.tar.gz ENV: setenv CFLAGS "-O3 -fno-omit-frame-pointer $myLIBS";\ setenv CXXFLAGS "-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti $myINCLUDES";\ setenv LDFLAGS "-flat_namespace -undefined suppress $myLIBS";\ setenv LDDLFLAGS "-flat_namespace -undefined suppress $myLIBS";\ setenv CPPFLAGS "$myINCLUDES";\ setenv LD cc;\ setenv CXX cc @ SHELL: gnutar zxf mysql-4.0.2-alpha.tar.gz cd mysql-4.0.2-alpha glibtoolize --force --copy fix the obsoleted AC_PROG_RANLIB (for libtool 1.4d +) == (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in (CHANGE) AC_PROG_RANLIB (TO) AC_PROG_LIBTOOL == aclocal ./configure \ --disable-shared --enable-static \ --prefix=/usr/local/mysql \ --sysconfdir=/private/etc/mysql --datadir=/usr/local/var/mysql \ --localstatedir=/private/var/mysql --sharedstatedir=/private/com/mysql \ --mandir=/usr/local/man \ --enable-assembler \ --with-unix-socket-path=/usr/local/tmp/mysql.sock --with-mysqld-user=mysql --with-tcp-port=3306 \ --x-includes=/usr/X11R6/include --x-libraries=/usr/X11R6/lib \ --enable-thread-safe-client --with-libwrap --with-vio \ --with-openssl=/usr/local/ssl --with-innodb --enable-local-infile \ --with-extra-charsets=complex \ --with-named-z-libs=not-used BUG #1: does not seem to exist in BSD variants (cref: http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless, "./configure" sets HAVE_POLL as defined, causing make to fail with sys/poll.h "not found". WORKAROUND: == (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in (CHANGE) /* Define if you have the poll function. */ #define HAVE_POLL 1 (TO) /* Define if you have the poll function. */ /* #define HAVE_POLL 1 */ == BUG #2: a subsequent "make" fails with: ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o complete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o input.o callback.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile.o nls.o search.o shell.o tilde.o ranlib libreadline.a make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/readline' Making all in pstack make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in aout make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in libmysql make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' /bin/sh ../libtool --mode=compile cc -DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\"" -DDATADIR="\"/private/var/mysql\"" -DSHAREDIR="\"/usr/local/var/mysql/mysql\"" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c libmysql.c cc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\" -DDATADIR=\"/private/var/mysql\" -DSHAREDIR=\"/usr/local/var/mysql/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_
mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl.,but need help with FIXes
hi all, three BUGS are reported here that have cropped up in mysql-4.0.2-alpha on OSX 10.1.4 Server current system has a SUCCESSFUL install of: >Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for apple-darwin5.4 on powerpc the 3 bugs: (1) poll.h not present in BSD variants; HAVE_POLL set to #define (2) "sizeof applied to an incomplete type" in libmysql/libmysql.c & libmysql/manager.c (3) libtool chokes on a long command line argument during piecwise archive linking (no workaround yet ) Any thoughts/insights are MUCH appreciated . DL: http://mysql.he.net/Downloads/MySQL-4.0/mysql-4.0.2-alpha.tar.gz ENV: setenv CFLAGS "-O3 -fno-omit-frame-pointer $myLIBS";\ setenv CXXFLAGS "-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti $myINCLUDES";\ setenv LDFLAGS "-flat_namespace -undefined suppress $myLIBS";\ setenv LDDLFLAGS "-flat_namespace -undefined suppress $myLIBS";\ setenv CPPFLAGS "$myINCLUDES";\ setenv LD cc;\ setenv CXX cc @ SHELL: gnutar zxf mysql-4.0.2-alpha.tar.gz cd mysql-4.0.2-alpha glibtoolize --force --copy fix the obsoleted AC_PROG_RANLIB (for libtool 1.4d +) == (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in (CHANGE) AC_PROG_RANLIB (TO) AC_PROG_LIBTOOL == aclocal ./configure \ --disable-shared --enable-static \ --prefix=/usr/local/mysql \ --sysconfdir=/private/etc/mysql --datadir=/usr/local/var/mysql \ --localstatedir=/private/var/mysql --sharedstatedir=/private/com/mysql \ --mandir=/usr/local/man \ --enable-assembler \ --with-unix-socket-path=/usr/local/tmp/mysql.sock --with-mysqld-user=mysql --with-tcp-port=3306 \ --x-includes=/usr/X11R6/include --x-libraries=/usr/X11R6/lib \ --enable-thread-safe-client --with-libwrap --with-vio \ --with-openssl=/usr/local/ssl --with-innodb --enable-local-infile \ --with-extra-charsets=complex \ --with-named-z-libs=not-used BUG #1: does not seem to exist in BSD variants (cref: http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless, "./configure" sets HAVE_POLL as defined, causing make to fail with sys/poll.h "not found". WORKAROUND: == (EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in (CHANGE) /* Define if you have the poll function. */ #define HAVE_POLL 1 (TO) /* Define if you have the poll function. */ /* #define HAVE_POLL 1 */ == BUG #2: a subsequent "make" fails with: ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o complete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o input.o callback.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile.o nls.o search.o shell.o tilde.o ranlib libreadline.a make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/readline' Making all in pstack make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in aout make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack/aout' make[3]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[3]: Nothing to be done for `all-am'. make[3]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' make[2]: Leaving directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/pstack' Making all in libmysql make[2]: Entering directory `/Volumes/ServerSystem/ports/mysql-4.0.2-alpha/libmysql' /bin/sh ../libtool --mode=compile cc -DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\"" -DDATADIR="\"/private/var/mysql\"" -DSHAREDIR="\"/usr/local/var/mysql/mysql\"" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/BerkeleyDB/lib -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -c libmysql.c cc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\" -DDATADIR=\"/private/var/mysql\" -DSHAREDIR=\"/usr/local/var/mysql/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I./../include -I../include -I./.. -I.. -I.. -I/System/Library/Frameworks -I/usr/include -I/usr/local/include -I/usr/X11R6/include -I/usr/local/BerkeleyDB/include -O -DDBUG_OFF -O3 -fno-omit-frame-pointer -L/System/Library/Frameworks -L/usr/lib -L/usr/local/lib -L/usr/X11R6/l
MySQL 4.0.2 & my.cnf
Hi! I recently took a test drive for MySQL 4.0.2. Installation was a breeze as always. However, when I tried to start MySQL server using the same old my.cnf which 4.0.1 had no problems with, 4.0.2 complained about the following and refused to start. 020713 07:24:55 mysqld started Unknown suffix '.' used for variable 'bind-address' (value '192.168.0.2') /usr/local/mysql-4.0.2-alpha-source/libexec/mysqld: Error while setting value '192.168.0.2' to 'bind-address' 020713 07:24:56 mysqld ended As soon as I commented out bind-address option in my.cnf, it began to run without a problem. Am I doing something wrong or is this a known/hidden bug in 4.0.2? Yours, Jindo - 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
Full Text Index and MySQL 4.0.2
Now that MySQL 4.0.2 has been released, does anyone know if Support for "always-index words" is available? This is mentioned in the todo: http://www.mysql.com/doc/F/u/Fulltext_TODO.html 'Support for "always-index words". They could be any strings the user wants to treat as words, examples are "C++", "AS/400", "TCP/IP", etc.' If this feature is supported, I would appreciate any help in getting this to work. Thanks in advance, Steve - 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.2
Arul, Monday, July 01, 2002, 1:25:38 PM, you wrote: A> As i already stated , i am not able to insert a null value in a child table A> in 4.0.1 which i was able to do in 3.23.51 A> I have created a table parent and also another table child where parentid A> column in child is a foreign key to the id column in parent table A> It was possible that i have no entries in parent table , and i was able to A> insert null values for parentid in child table.. A> This was a feature in 3.23.51 whereas this was not available in 3.23.49 A> Any idea whether this will be supported in 4.0.2 A> and where i can get that from.. A> In the MySQL site i could see only upto 4.0.1 alpha release.. Yes, it will be in 4.0.2, too . At present time you can get 4.0.2 from development source tree: http://www.mysql.com/doc/I/n/Installing_source_tree.html Binary distribution will come very soon. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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.2
Unless I've misread your post, this was not so much a feature in .51 as it was a bug. If you have a FK contraint then you should never be able to insert a record into the child table that does not have a matching FK in the parent table. (Null does not mean no matching record.) Either remove the constraint, add a dummy record into the parent table or re-think what you are trying to do. (You've put on a constraint and now you are trying to break it!) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Arul [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 9:14 AM To: MySQL Subject: Mysql 4.0.2 Hi As i already stated , i am not able to insert a null value in a child table in 4.0.1 which i was able to do in 3.23.51 I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 Any idea whether this will be supported in 4.0.2 and where i can get that from.. In the MySQL site i could see only upto 4.0.1 alpha release.. -Arul sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql 4.0.2
Hi As i already stated , i am not able to insert a null value in a child table in 4.0.1 which i was able to do in 3.23.51 I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 Any idea whether this will be supported in 4.0.2 and where i can get that from.. In the MySQL site i could see only upto 4.0.1 alpha release.. -Arul sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 4.0.2
Hi As i already stated , i am not able to insert a null value in a child table in 4.0.1 which i was able to do in 3.23.51 I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 Any idea whether this will be supported in 4.0.2 and where i can get that from.. In the MySQL site i could see only upto 4.0.1 alpha release.. -Arul sql,query - 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: Bug in fulltext search in latest mysql-4.0.2 source
Hi! > "Vadim" == Vadim P <[EMAIL PROTECTED]> writes: Vadim> Sergei Golubchik wrote: >>> rebuild your indexes (the proper way to do it is to issue >>> REPAIR table_name USE_FRM Vadim> Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? Yes, this would do the same thing as REPAIR, but a bit slower. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ 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 fulltext search in latest mysql-4.0.2 source
Hi, Sorry, I finally found I also have to add set-variable = ft_min_word_len=3 in my.cnf. Regards, Jocelyn Fournier - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Sergei Golubchik" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:58 PM Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > Hi, > > I don't understand, I modified ulong ft_min_word_len=3; in > myisam/ft_static.c, and then recompiled MySQL using > BUILD/compile-pentium --without-innodb script, but show variables still > displays after restarting mysql : > > | ft_min_word_len | 4 > | > | ft_max_word_len | 254 > | > | ft_max_word_len_for_sort| 20 > > Any idea of what could be wrong ? > > Thanks and regards, > Jocelyn Fournier > > - Original Message - > From: "Sergei Golubchik" <[EMAIL PROTECTED]> > To: "Jocelyn Fournier" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, May 16, 2002 12:58 PM > Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > > > > Hi! > > > > On May 15, Jocelyn Fournier wrote: > > > A small question : > > > > > > I have : > > > > > > CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) > > > > > > in the field 'nom' . > > > How could I match BCI-11N for exemple ? (BCI* return nothing :( ) > > > > > > Thanks, > > > Jocelyn > > > > Actually, it's a question for [EMAIL PROTECTED], not for bugs@, > > but anyway - you need to decrease ft_min_word_len variable and > > rebuild your indexes (the proper way to do it is to issue > > REPAIR table_name USE_FRM > > but be sure to use the latest sources, as I've just fixed a crash in > > this code). > > > > Regards, > > Sergei > > > > -- > > MySQL Development Team > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > ><___/ > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in fulltext search in latest mysql-4.0.2 source
Hi! On May 16, Jocelyn Fournier wrote: > Hi, > > I don't understand, I modified ulong ft_min_word_len=3; in > myisam/ft_static.c, and then recompiled MySQL using > BUILD/compile-pentium --without-innodb script, but show variables still > displays after restarting mysql : > > | ft_min_word_len | 4 > | ft_max_word_len | 254 > | ft_max_word_len_for_sort| 20 > > Any idea of what could be wrong ? > > Thanks and regards, > Jocelyn Fournier In 4.0 it's a true variable - you don't need to recompile MySQL - just add to /etc/my.cnf ft_min_word_len=3 :) Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - 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 fulltext search in latest mysql-4.0.2 source
Hi, I don't understand, I modified ulong ft_min_word_len=3; in myisam/ft_static.c, and then recompiled MySQL using BUILD/compile-pentium --without-innodb script, but show variables still displays after restarting mysql : | ft_min_word_len | 4 | | ft_max_word_len | 254 | | ft_max_word_len_for_sort| 20 Any idea of what could be wrong ? Thanks and regards, Jocelyn Fournier - Original Message - From: "Sergei Golubchik" <[EMAIL PROTECTED]> To: "Jocelyn Fournier" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 12:58 PM Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > Hi! > > On May 15, Jocelyn Fournier wrote: > > A small question : > > > > I have : > > > > CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) > > > > in the field 'nom' . > > How could I match BCI-11N for exemple ? (BCI* return nothing :( ) > > > > Thanks, > > Jocelyn > > Actually, it's a question for [EMAIL PROTECTED], not for bugs@, > but anyway - you need to decrease ft_min_word_len variable and > rebuild your indexes (the proper way to do it is to issue > REPAIR table_name USE_FRM > but be sure to use the latest sources, as I've just fixed a crash in > this code). > > Regards, > Sergei > > -- > MySQL Development Team >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ><___/ > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in fulltext search in latest mysql-4.0.2 source
Sergei Golubchik wrote: > rebuild your indexes (the proper way to do it is to issue > REPAIR table_name USE_FRM Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? TIA, Vadim. /* sql, mysql to satisfy the spam police */ - 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 fulltext search in latest mysql-4.0.2 source
Hi! On May 15, Jocelyn Fournier wrote: > A small question : > > I have : > > CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) > > in the field 'nom' . > How could I match BCI-11N for exemple ? (BCI* return nothing :( ) > > Thanks, > Jocelyn Actually, it's a question for [EMAIL PROTECTED], not for bugs@, but anyway - you need to decrease ft_min_word_len variable and rebuild your indexes (the proper way to do it is to issue REPAIR table_name USE_FRM but be sure to use the latest sources, as I've just fixed a crash in this code). Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in multi-table delete in MySQL-4.0.2 ?
Hi, I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if I'm doing something wrong with this query : mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 21 rows affected (0.34 sec) (I want to delete rows from searchmainhardwarefr2 and searchjoinhardwarefr2 which match the join) As you can see, MySQL display 21 row affected, but I tried the following : mysql> SELECT COUNT(*) FROM searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; +--+ | COUNT(*) | +--+ | 1744709 | +--+ 1 row in set (1 min 19.34 sec) That's not 21 rows :) The delete seems to erase nothing since the select was issued AFTER the delete. Moreover, the returned number of rows seems to be random : mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 21 rows affected (0.34 sec) mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 24 rows affected (0.38 sec) mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 28 rows affected (0.31 sec) mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'; Query OK, 19 rows affected (0.44 sec) Tell me if I'm doing something wrong, and if not I will try to send a testcase ASAP at bugs mailing list. Regards, Jocelyn Fournier - 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.2 core file uploaded...
On Tuesday 12 February 2002 09:23 pm, you wrote: > Sasha, > > I compressed it first, 'cause it was nearly 400MB in size. ?It's on > the FTP site as mysqld.core.bz2. Jeremy: Can you upload the binary itself also? I need it to be able to study the core. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: information on mysql 4.0.2
Hi, No problem so far with mysql 4.0.x, no crash at all on a production server with a really high load. If you want to use mysql 4.0.2, take a look here : http://www.mysql.com/doc/I/n/Installing_source_tree.html Best Regards, Jocelyn Fournier Presence-PC - Original Message - From: "Jean-Francois Dionne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 16, 2002 2:03 AM Subject: information on mysql 4.0.2 > I see people speaking about mysql 4.0.2... but where you get it? they write > some thing about it on web page but 4.0.2 is not in the download list... > maybe someone can say if mysql 4 is stable? I mean if I can use it without > 100 crash in 1 hour :) > Sorry for bad english :) > Jean-Francois Dionne > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: information on mysql 4.0.2
So it's better using 4.0.1 of 4.0.2? Jean-Francois Dionne - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Jean-Francois Dionne" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 15, 2002 8:12 PM Subject: Re: information on mysql 4.0.2 > On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote: > > > I see people speaking about mysql 4.0.2... but where you get it? > > they write some thing about it on web page but 4.0.2 is not in the > > download list... > > It's from the MySQL source tree. See this url: > > http://www.mysql.com/doc/I/n/Installing_source_tree.html > > for instructions. > > > maybe someone can say if mysql 4 is stable? I mean if I can use it > > without 100 crash in 1 hour :) > > Parts of it are. But parts are not, and that's what we're talking > about. In my case, we're testing the new replication code in 4.0.2 to > make sure it is stable. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 8 days, processed 278,746,500 queries (381/sec. avg) > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: information on mysql 4.0.2
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote: > I see people speaking about mysql 4.0.2... but where you get it? > they write some thing about it on web page but 4.0.2 is not in the > download list... It's from the MySQL source tree. See this url: http://www.mysql.com/doc/I/n/Installing_source_tree.html for instructions. > maybe someone can say if mysql 4 is stable? I mean if I can use it > without 100 crash in 1 hour :) Parts of it are. But parts are not, and that's what we're talking about. In my case, we're testing the new replication code in 4.0.2 to make sure it is stable. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 8 days, processed 278,746,500 queries (381/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
information on mysql 4.0.2
I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Sorry for bad english :) Jean-Francois Dionne - 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.2 core file uploaded...
On Tuesday 12 February 2002 09:23 pm, you wrote: > Sasha, > > I compressed it first, 'cause it was nearly 400MB in size. It's on > the FTP site as mysqld.core.bz2. Jeremy - in case you are wondering why it is taking me so long to reply - we've made a mess on our Linux build machine before the release of 3.23.48 and it got linked against a problematic library. Because of that, we've decided to redo the Linux build system to make it more fool-proof, and I've been busy with that in the last couple of days. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
