Bug #63343 [Ver->Ana]: Commit failure for repeated persistent connection
Edit report at https://bugs.php.net/bug.php?id=63343&edit=1
ID: 63343
Updated by: cmb@php.net
Reported by: brn at macrovita dot com dot br
Summary: Commit failure for repeated persistent connection
-Status: Verified
+Status: Analyzed
Type: Bug
Package: PDO Core
Operating System: Mixed
PHP Version: Irrelevant
Block user comment: N
Private report: N
New Comment:
This is a memory management issue, as setting $st = null hints
at. Furthermore, assigning the second $db->query() to something
else than $st (e.g. $st1) also lets the script succeed.
The fix for PHP-7.0+ appears to be trivial (see PR #2112), but I
don't know how to solve the problem for PHP-5.6.
Previous Comments:
------------------------------------------------------------------------
[2016-08-31 23:30:55] cmb@php.net
Confirmed: <https://3v4l.org/iTsHt>.
------------------------------------------------------------------------
[2014-12-17 19:51:42] brn at macrovita dot com dot br
Note: This bug is NOT specific to SQLite.
The original test case uses SQLite just because it makes it simpler to reproduce the problem.
Originally, we ran into this bug with connections against MySQL.
------------------------------------------------------------------------
[2012-10-24 00:06:25] brn at macrovita dot com dot br
Description:
------------
Repeated transaction on repeated persistent PDO connection fails on commit with
'There is no active transaction'.
Reproduced on:
- Fedora 14 32bit PHP 5.3.6
- Gentoo 64bit PHP 5.3.14
We'll work around the bug in application code, but we thought developers might
like to know about this.
// BTM5282
Test script:
---------------
# Should work, but does not:
cat <<'EOD' | php -d display_errors=1 && echo OK
<?php
$db = new PDO('sqlite::memory:', '', '', array(PDO::ATTR_PERSISTENT
=> true));
$db->beginTransaction();
$st = $db->query('select 1');
echo $st->fetchColumn()."\n";
$db->commit();
//$st = null;
$db = new PDO('sqlite::memory:', '', '', array(PDO::ATTR_PERSISTENT
=> true));
$db->beginTransaction();
$st = $db->query('select 2');
echo $st->fetchColumn()."\n";
$db->commit();
EOD
# INTERESTING? -> Works OK with uncommented $st = null;
# Works OK with PDO::ATTR_PERSISTENT => false .
Expected result:
----------------
1
2
OK
Actual result:
--------------
Fatal error: Uncaught exception 'PDOException'
with message 'There is no active transaction' in -:11 ...
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=63343&edit=1
Thread (9 messages)