List:General Discussion« Previous MessageNext Message »
From:Pabst Simon Date:June 5 2002 2:43pm
Subject:mysqlhotcopy regexp problem with 640 and more Databases
View as plain text  
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:simon.pabst@stripped

Thread
mysqlhotcopy regexp problem with 640 and more DatabasesPabst Simon5 Jun
  • Re: mysqlhotcopy regexp problem with 640 and more DatabasesDan Nelson5 Jun