php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #58671 user sessions are not released on faulty insert
Submitted: 2009-05-14 08:23 UTC Modified: 2009-05-16 04:13 UTC
From: erik at ibuildings dot nl Assigned: grantc@php.net (profile)
Status: Closed Package: ingres (PECL)
PHP Version: 5.2.6 OS: ubuntu 9.04
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: erik at ibuildings dot nl
New email:
PHP Version: OS:

 

 [2009-05-14 08:23 UTC] erik at ibuildings dot nl 
Description:
------------
I was trying out ingres and tried to insert a record which failed because of missing ID in query.

This resulted in a cascade of problems resulting in the session not being freed. 


Reproduce code:
---------------
error_reporting(E_ALL);
ini_set("ingres.scrollable", FALSE);
ini_set("ingres.utf8", TRUE);

ini_set("ingres.describe", TRUE);
$link = ingres_connect("demodb", "ingres", "demo")
    or die("Could not connect");
echo "Connected successfully";

$result = ingres_query($link, "INSERT INTO user_profile (up_last, up_first, up_email, up_airport)VALUES(?,?,?,?)",array('Snoeijs','Erik','erik@example.org','FLU'));
print ingres_error();

ingres_close($link);


Expected result:
----------------
Connected successfully

No value specified for mandatory column 'up_id'.

Actual result:
--------------
Warning: ingres_query() [function.ingres-query]: An error occurred when preparing a query for DESCRIBE INPUT in /var/www/index.php on line 141

Warning: ingres_query() [function.ingres-query]: An error occurred whilst trying to describe the query in /var/www/index.php on line 141

Notice: ingres_close() [function.ingres-close]: _rollback_transaction : IIAPI_ST_FAILURE: 13172740 - The requested operation cannot be performed with active queries. in /var/www/index.php on line 145

Notice: ingres_close() [function.ingres-close]: _close_ii_link : 13172739 - The requested operation cannot be performed with active transactions. in /var/www/index.php on line 145

Warning: ingres_close() [function.ingres-close]: _close_ii_link : Unable to close statement in /var/www/index.php on line 145

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-05-14 11:15 UTC] grant dot croker at ingres dot com 
Confirmed - the sessions are not being aborted at the end of a request.
 [2009-05-16 04:13 UTC] grant dot croker at ingres dot com 
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.

Hi Erik,

The handling of the bad SQL has not been corrected however sessions are now terminated.

regards

grant
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Tue Apr 30 02:01:31 2024 UTC