php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #58124 Autocommit state machine seems to be borked with multiple links
Submitted: 2008-03-27 07:40 UTC Modified: 2017-10-24 08:41 UTC
From: alexander dot thiem at ingres dot com Assigned:
Status: Suspended Package: ingres (PECL)
PHP Version: 5.2.4 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
37 - 5 = ?
Subscribe to this entry?

 
 [2008-03-27 07:40 UTC] alexander dot thiem at ingres dot com
Description:
------------
When using multiple connections switching on and off autocommit seems to confuse the drivers internal state machine. Autocommit stays off even when it shouldn't.
The code pasted below SHOULD deadlock with the two concurrent inserts but it doesn't.
If you leave out all the lines above it will hang as expected.

Reproduce code:
---------------
$link1 = ingres2_connect( ... );
$link2 = ingres2_connect( ... );

ingres2_autocommit($link1);
ingres2_autocommit($link2);

$res1 = ingres2_query($link1, "select * from table");
$res2 = ingres2_query($link2, "select * from table");

ingres2_autocommit($link1);
ingres2_autocommit($link2);

$res1 = ingres2_query($link1, "insert into table values ( ... )");
$res2 = ingres2_query($link2, "insert into table values ( ... )");


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2017-10-24 08:41 UTC] kalle@php.net
-Status: Open +Status: Suspended
 [2017-10-24 08:41 UTC] kalle@php.net
The ingres package has not had any activity for 4 years, so its safe to say that its no longer in active development, if activity picks backup then the maintainer can re-open this report
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat May 18 04:01:34 2024 UTC