Has no one else on this list encountered this issue at all?
On 05/13/2011 01:00 PM, Berthold Alheit wrote:
Hey,
We are experiencing an issue with our release environment. I have
posted a thread on stackoverflow relating to this, but I will repeat
the post content in this mail. The thread can be accessed at
http://stackoverflow.com/questions/5959907/cursor-error-with-postgresql-pgpool-and-php
. I suspect that this is an pgpool bug/error that only manifests under
very particular circumstances. The error defies duplication using the
same sources and setup in a test environment so far.
Regards,
Berthold Alheit
stackoverflow post body follows:
Hey, I am struggling a bit to determine the exact cause of an error
that has been popping up in our release environment. There does not
seem to be much dealing with this particular error on Google.
This is the error message we are getting:
SQLSTATE[34000]: Invalid cursor name: 7 ERROR: portal "" does not
exist
The error only pops up when we are using PDO prepared statements.
This is the setup for our release environment:
1. pgpool 3.0.1 (The postgresql backend is in Streaming Replication
mode!)
2. PHP 5.3.5
3. PostgreSQL 9.0
The same error does not manifest in our test environment (Edit: forgot
to mention, the standard test environment uses Postgresql 9.0 without
pgpool). Thus, I am led to suspect that pgpool is at least partly
suspect.
Does anyone know what the probable causes for this error are?
Edit: ok, here is an example of the kind of code that causes the error.
|$sql= 'SELECT *';
$sql.= 'FROM "myTable" as "myStuff"';
$sql.= 'WHERE "myTable"."status" = 1';
$sql.= 'AND "myTable"."myTableId" = :tableId';
$sth= $this->_db->prepare($sql);
$sth->bindParam(':tableId', $tableId, PDO::PARAM_INT);
$sth->execute();
|
Edit: Some log file output;
|postgresql-Sun.log-129- ORDER BY"id"
postgresql-Sun.log:130:ERROR: portal"" doesnot exist
postgresql-Sun.log-131-ERROR: prepared statement"pdo_stmt_00000011" doesnot
exist
postgresql-Sun.log-132-STATEMENT: DEALLOCATE pdo_stmt_00000011
postgresql-Mon.log-82- where "id" = 32024
postgresql-Mon.log:83:ERROR: portal"" doesnot exist
postgresql-Mon.log-84-ERROR: prepared statement"pdo_stmt_00000002" doesnot
exist
postgresql-Mon.log-85-STATEMENT: DEALLOCATE pdo_stmt_00000002|
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
--
-------------------------------------------
シーツー株式会社
Berthold Alheit
〒980-8485
仙台市青葉区中央1-2-3
仙台マークワン14F
TEL：022-212-3663
FAX：022-212-3664
E-mail：[email protected]
URL： http://www.cybc.jp
-----------------------------------------
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
