>Description:
I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat
operating system. On 3 machines I only upgraded the RPMs and
everything worked. On only Linux Redhat 7.3 server RPM upgrade
also worked fine. The problem is that mysql server report no
tables in any database. When I run MySQL client "show tables;"
return empty dataset in databases. 3.23.5x work fine.
I am reporting this from the server where upgrade was successful.
The server where error occured is almost identical it only is
Redhat 7.3 instead of 7.2.
>How-To-Repeat:
I have downgraded to 3.23.56 where tables are seen. Every time I
upgrade I get the same error.
>Fix:
No idea.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Synopsis: Upgrade problem
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.12 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux 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.12
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 days 15 hours 11 min 33 sec
Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151 Flush tables: 1 Open
tables: 46 Queries per second avg: 0.010
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.2 2.96-112.7.2)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 20 09:15 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1285884 Mar 6 16:03 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27338566 Mar 6 15:05 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 6 15:05 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static'
'--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb'
'--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server'
'--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6
-fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
