Hi Nick, I am seeing some rather strange problem here with mysqldump, after trying very hard to reproduce the problem on a test server, I gave up. Do the options make any difference when you run it? Can you send a trace of the actual dump? I was seeing mysqldump terminate in my case, now it just seems to loop, and I am not sure why the behavior changed.
If we could reproduce this reliably maybe we could get a fix! Can you do this everytime? Ken ----- Original Message ----- From: "Nick Pasich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 12:27 PM Subject: Problem with mysqldump when using query caching > > >Description: > I'm using Mysql 4.0.1 with query caching: > > set-variable = query_cache_limit=10M > set-variable = query_cache_size=10M > set-variable = query_cache_startup_type=1 > > The Command: > mysqldump -q -K -t --tab='.' \ > --fields-optionally-enclosed-by='"' \ > --fields-terminated-by=',' sched oweek > > The first execution of the command writes the expected > data to oweek.txt. > > Any subsequent executions do not. This is because of query caching. > I can run --> mysql -e "reset query cache" <-- which will enable > the next call to mysqldump to write data. > > I believe that mysqldump should write data whether query caching > is enabled/disabled or not-flushed/flushed. > > >How-To-Repeat: > Execute a mysqldump command more than once. > >Fix: > > >Submitter-Id: <submitter ID> > >Originator: Nick Pasich > >Organization: > >MySQL support: email support > >Synopsis: Problem with mysqldump when using query caching > >Severity: serious > >Priority: medium > >Category: mysql > >Class: sw-bug > >Release: mysql-4.0.1-alpha (Source distribution) > >Server: /usr/local/MYSQL/bin/mysqladmin Ver 8.23 Distrib 4.0.1-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.1-alpha-log > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /usr/local/MYSQL/mysql.sock > Uptime: 13 hours 49 min 48 sec > > Threads: 2 Questions: 1653 Slow queries: 2 Opens: 135 Flush tables: 15 Open tables: 3 Queries per second avg: 0.033 > >Environment: > > System: Linux NICK 2.4.18-ac3 #1 Mon Mar 4 12:38:33 PST 2002 i586 unknown > Architecture: i586 > > Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from /usr/local/GCC/gcc-2.95.3/lib/gcc-lib/i586-pc-linux-gnulibc1/2.95.3/sp ecs > gcc version 2.95.3 20010315 (release) > Compilation info: CC='gcc' CFLAGS='-O3 -march=i586' CXX='gcc' CXXFLAGS='-O3 -march=i586 -felide-constructors -fno-exceptions -fno-rt ti' LDFLAGS='' > LIBC: > lrwxrwxrwx 1 root root 13 Feb 24 20:49 /lib/libc.so.4 -> libc.so.4.7.6 > -rwxr-xr-x 1 root root 623620 Feb 26 1996 /lib/libc.so.4.5.26 > -rwxr-xr-x 1 bin bin 634880 Aug 13 1996 /lib/libc.so.4.7.5 > -rwxr-xr-x 1 root wheel 634880 Apr 29 1996 /lib/libc.so.4.7.6 > lrwxrwxrwx 1 root root 14 Feb 24 20:49 /lib/libc.so.5 -> libc.so.5.4.46 > -rwxr > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > 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