471,092 Members | 1,542 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Problems with two clients on the same DB

I have a simple database that contains only Berkeley tables. MySQL v.
3.23.47 on Linux Mandrake 8.2.

Now I try to explain what happens when I'm connecting with two

1) Establish one connection with Client 1
2) "Set Autocommit=0" for Client 1
3) Connect to a DB (for example DB Y)
4) Perform a simple SELECT to a Berkeley table (for example X) and
read the result of query
5) Establish a second connection with Client 2
6) "Set Autocommit=0" for Client 2
7) Connect to a DB Y (the same of Client 1)
8) Attempt to perform an INSERT of one record to table X

At this point the Client 2 waits until the Client 1 issues "commit;"
(or rollback;").

In the other words you cannot perform an INSERT in the tables even if
the Client 1 has done a simple SELECT.
It seems that there is a transaction still active in the connection of
Client 1.

I have done the same test also with MySQL 4.0.11-Max on Linux Mandrake
9.1 and I have obtained the same result.

Any kind of help, will be appreciated.
Jul 19 '05 #1
0 1348

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Dennis Roberts | last post: by
2 posts views Thread by John Glista | last post: by
5 posts views Thread by Matthew Speed | last post: by
1 post views Thread by Rayearth | last post: by
29 posts views Thread by DFS | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.