It is possible that the bug might be fixed in the 3.0.3-STABLE tree. So you might want to try extract source from the 3.0.3-STABLE CVS tree. If you are sure what to do with CVS, I can send you the tar ball personally.
-- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > 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
