Description:
i'm using mysql 4.1.12 version on linux redhat 4
====================================================
when connecting from remote clinent to Mysql server show error messages as like
====================================================
[root@admin manger]# mysql -u dbadmin -p -hldb -Dka_test
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'addr_group'
Didn't find any fields in table 'addr_group_user'
Didn't find any fields in table 'addr_main'
====================================================
but connection from local clien to server then clearly show
===================================================
[root@ldb mysql]# mysql -udbadmin -p -Dka_test
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2346 to server version: 4.1.12-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use ka_test;
Database changed
=================================
show tables from remote clent server
===============================
mysql> show tables;
+--------------------------+
| Tables_in_kaatal_test |
+--------------------------+
| addr_group |
| addr_group_user |
| addr_main |
| arreo_sms |
| bulletin_attach |
| bulletin_category_item |
| bulletin_category_master |
| bulletin_contents |
| bulletin_master |
| bulletin_pool |
| c3p0testtable |
| cart_master |
| cart_product_detail |
[NEXT]
===============================
show tables from local database
===============================
mysql> show tables;
+-----------------------+
| Tables_in_kaatal_test |
+-----------------------+
| store_groups |
| store_users |
+-----------------------+
2 rows in set (0.00 sec)
i'm delete all tables except store_groups , store_users
but Server information dosn't applied that they were deleted.
(what about Sared memory err ? )
so, client and server enviroment have unsynced information .
what is problem ?
who can fixed it.
How to repeat:
[remote client to server ]
==========================
create table atab ...
create table btab ...
create table ctab ...
create table dtab ...
create table etab ...
exit;
[local client to server ]
==========================
drop table atab;
drop table btab;
drop table ctab;
drop table dtab;
[remote client to server ]
==========================
show tables;
insert into atab values (....0);
insert into atab values (....0);
commit;
exit;
[local client to server ]
==========================
show tables;
create table atab;
[remote client to server ]
==========================
show tables;
