Re: MYSQL CLIENT PROBLEM

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/mysql?unsub=lists@pantek.com