>Description:
I have installed MySQL version 3.23.36 (having previously used 3.23.34a)
After I restarted the daemon, I ran the mysql 'monitor' program to check on the
existing databases and tables. Mysql reported for each table: "Didn't find any fields
in table 'table-name'". This error had shown up in 3.23.34a for tables that had no
records (which, since we weren't using them, were removed, which resolved that issue).
I thought that the tables may have become 'corrupt', so I used "mysql" to
recreate/reload the tables. The 'index' files were created (and appeared to be
'filled'), but the 'data' files had only been 'created' when I recieved the error "Can
not locate file "/index/customer.MYD". "/index" is where the "customer.MYI" is located
(and pointed to by a symbolic link), while the data portion ("customer.MYD") is in
"/data" (pointed to by a symbolic link). I would assume that a bug has been
introduced where the same value of the 'realpath' call for the 'index' portion of the
f!
ile, is being re-used to locate the data portion (instead of another call to get the
'realpath' of the data portion).
>How-To-Repeat:
Create a table, and place the index portion (.MYI) in one directory, and the
'form' (.frm) and data portion (.MYD) in another. Create 'symbolic' links to the
files from your "/var/databasename" directory, and restart "mysql". Also, create the
'symbolic' links first (no existing table) pointing to the 2 different directories,
and try to use 'mysql < load_script' to create the actual files....
>Fix:
I have place all 3 parts of each table (.frm, .MYD, .MYI) in the same
directory for now (so I could use the latest version of the "mysql" engine) and
redirected all 'symbolic' links to that area.
>Submitter-Id: [EMAIL PROTECTED]
>Originator: root
>Organization: YubbyDubby
>MySQL support: none
>Synopsis: MySQL 3.23.36 not resolving 'realpath' to .MYD files.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Source distribution)
>Server: lt-mysqladmin Ver 8.18 Distrib 3.23.36, 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 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 16 hours 10 min 27 sec
Threads: 1 Questions: 787 Slow queries: 0 Opens: 22 Flush tables: 1 Open tables:
15 Queries per second avg: 0.014
>Environment:
System: Linux uxdb1 2.2.17-14smp #1 SMP Mon Feb 5 18:40:03 EST 2001 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/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Sep 29 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101836 Jan 15 07:49 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20273324 Jan 15 07:49 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 15 07:49 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
