Krishna Chandra Prajapati wrote:
Hi All,
I am using mysql-client 5.0.15 on fedora system. Server is a Debian box with
mysql 5.0.32
After getting connected to the server(192.168.1.7) using the command below
mysql -h 192.168.1.7 -D dip -u dip -p
When a record deleted from a table on server (192.168.1.7) Then that changes
are not reflected on the client session. If i log out and then reconnect to
server then the changes are reflected. Earlier it was working fine.
This is not a bug in the client. It sounds like you are seeing the
effects of REPEATABLE READ transaction isolation level. Did you upgrade
the server or reconfigure it? Did you change your storage engine from
MyISAM to InnoDB?
The next time this happens, try running COMMIT and then run the SELECT
again. Do you see the changed data? If so, it's the transaction
isolation level.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]