Bug #69656 [Opn]: mysqli_commit does not commits with MYSQLI_ASYNC, mysqli_kill returns false
| From: | contact at sshilko dot com | Date: | Tue, 19 May 2015 13:38:54 +0000 |
| Subject: | Bug #69656 [Opn]: mysqli_commit does not commits with MYSQLI_ASYNC, mysqli_kill returns false | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-192763@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=69656&edit=1
ID: 69656
User updated by: contact at sshilko dot com
Reported by: contact at sshilko dot com
-Summary: mysqli_commit does not affect MYSQLI_ASYNC
+Summary: mysqli_commit does not commits with MYSQLI_ASYNC,
mysqli_kill returns false
Status: Open
Type: Bug
Package: MySQLi related
-Operating System: Linux
+Operating System: Ubuntu 12.04.5 LTS
-PHP Version: 5.5.25
+PHP Version: 5.5.24
Block user comment: N
Private report: N
New Comment:
One more observation: mysqli_kill() returns FALSE after MYSQLI_ASYNC query, whether same code w/o
MYSQLI_ASYNC returns TRUE
Previous Comments:
------------------------------------------------------------------------
[2015-05-18 16:02:41] contact at sshilko dot com
Description:
------------
mysqli_commit does not work when using mysqlnd + MYSQLI_ASYNC + autocommit=false.
The main transaction gets commited, but everything executed via MYSQLI_ASYNC does not get commited.
Test script:
---------------
https://gist.github.com/sshilko/2119c6b87ff4887142ab
Expected result:
----------------
$ time php async.php
Doing insert AUTOCOMMIT=FALSE:
INSERT INTO asynctest (
date, user_id) values ('2015-05-18',
'1431964720')
Insert done
Doing select:
Array
(
[0] => Array
(
[COUNT(*)] => 1
)
)
Doing insert AUTOCOMMIT=TRUE:
INSERT INTO asynctest (date, user_id) values ('2015-05-18',
'1431964720')
Insert done
Doing select:
Array
(
[0] => Array
(
[COUNT(*)] => 2
)
)
real 0m0.032s
user 0m0.013s
sys 0m0.003s
Actual result:
--------------
$ time php async.php
Doing insert AUTOCOMMIT=FALSE:
INSERT INTO asynctest (date, user_id) values ('2015-05-18',
'1431964720')
Insert done
Doing select:
Array
(
[0] => Array
(
[COUNT(*)] => 0
)
)
Doing insert AUTOCOMMIT=TRUE:
INSERT INTO asynctest (date, user_id) values ('2015-05-18',
'1431964720')
Insert done
Doing select:
Array
(
[0] => Array
(
[COUNT(*)] => 1
)
)
real 0m0.032s
user 0m0.013s
sys 0m0.003s
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=69656&edit=1