Ken,
On Wed, Apr 10, 2002 at 01:24:46PM -0400, Ken Menzel wrote:
> 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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
If I run: mysqldump --result-file="oweek.dump" sched oweek
I works every time.
If I run: mysqldump -q -K -t --tab='.' \
--fields-optionally-enclosed-by='"' \
--fields-terminated-by=',' sched oweek
It works the first time, when it is not query cached.
Any subsequent executions, when it is cached, do not.
If I clear the cache with: mysql -e "reset query cache" it will
write data on the first execution but then stops writing data on
any other tries.
---( Nick )---
> 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
