From: | "Philip Graham" <philip(at)lightbox(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5244: Attempting to rollback to a savepoint after receiving an error with state 55000 the process hangs |
Date: | 2009-12-15 04:15:45 |
Message-ID: | 200912150415.nBF4FjKx045437@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5244
Logged by: Philip Graham
Email address: philip(at)lightbox(dot)org
PostgreSQL version: 8.3.8
Operating system: Linux
Description: Attempting to rollback to a savepoint after receiving an
error with state 55000 the process hangs
Details:
This may be a PHP so please excure me if it is.
<?php
$pdo = new PDO('pgsql:host=localhost;dbname=a_db', 'a_user', 'my_pass');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo 'Creating test objects'."\n";
$pdo->query('CREATE SEQUENCE test_seq');
echo 'Setup complete'."\n";
$pdo->beginTransaction();
try {
echo 'Setting savepoint'."\n";
$pdo->query('SAVEPOINT pre_id_fetch');
echo 'Fetching value'."\n";
$stmt = $pdo->query('SELECT currval(\'test_seq\');');
$curId = $stmt->fetchColumn();
echo 'Releasing savepoint'."\n";
$pdo->query('RELEASE SAVEPOINT pre_id_fetch');
} catch (PDOException $e) {
echo 'Rolling back'."\n";
$pdo->query('ROLLBACK TO pre_id_fetch');
$curId = 0;
}
echo 'Cur Id: ',$curId,"\n";
Running this code it hangs after echoing 'Rolling back', but only hangs
every other execution (assuming the sequence was deleted first).
Thanks for any help,
Philip
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Williamson | 2009-12-15 04:35:45 | statement_timeout is not cancelling query |
Previous Message | Robert Haas | 2009-12-15 03:06:52 | Re: Invalid explain output for multi-plan statements |