Description:
When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and
having 640 or more Databases produces the following error:
DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not found
(Errcode: 24) at ./bin/mysqlhotcopy line 432.
The file exists though.
If i create a table alphabetically before the one with the error, then the next time i
use mysqlhotcopy it also produces the error on the next table alphabetically before,
but always on the 640. table.
Line 432 of mysqlhotcopy 1.15 is:
$dbh->do("LOCK TABLES $hc_locks");
Commenting that line makes the error go away.
mysqlhotcopy also works fine if i use it only on the single database where the error
occurs with --regexp='mydatabase.*' since there are less than 640 Tables then.
How-To-Repeat:
Use mysqlhotcopy 1.15 on a MySQL Server with 640 or more Tables
Syntax:
mysql/bin/mysqlhotcopy --regexp='.*' /somedir
Fix:
?
Submitter-Id: <submitter ID>
Originator: Simon Pabst
Organization: Siemens Business Services
MySQL support: none
Synopsis: mysqlhotcopy regexp problem with 640 and more Databases
Severity: serious
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.49 (Official MySQL binary)
Environment:
System: SunOS 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-Enterprise-10000
Architecture: sun4
Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1749356 Jul 20 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 6 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /lib/libc.so.1
-rw-r--r-- 1 root bin 1749356 Jul 20 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 6 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/lvol1/mysql '--with-comment=Official MySQL
binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared
Perl: This is perl, v5.6.1 built for sun4-solaris-multi
DBI 1.20
DBD-mysql-2.1017
Sincerely
Simon Pabst
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
