[Mason] Class::DBI dbdpg_2 error

[Kevin W. <ke...@th...>]

Hi Folks,

I am building a webapp using Class::DBI to a back end postgres DB and  
am running into some peculiar (and damnably intermittent) problems.

The error below and a similar one pop up now and again (I can't  
determine the trigger).  This is highly likely to be something in my  
webapp since I can take the webapp out of the equation and the  
problem does not occur. I also see a peculiarity in that trying to  
retrieve a column value results in undef but no error... and this too  
is intermittent.

Whilst I appreciate that this isn't much in the way of information I  
am curious if anyone else has come up against a similar issue? I can  
send through my App for people to look at if they are bored but  
unfortunately I can't do a cut down of the issue.

Thanks for any help

Kevin

error:       DBD::Pg::st execute failed: ERROR: prepared statement  
"dbdpg_2" already exists
[for Statement "SELECT name
FROM metadata_type
WHERE id=?
" with ParamValues: 1='1'] at /Library/Perl/5.8.6/DBIx/ 
ContextualFetch.pm line 51.
context:
...
47:      sub _untaint_execute {
48:      my $sth = shift;
49:      my $old_value = $sth->{Taint};
50:      $sth->{Taint} = 0;
51:      my $ret = $sth->SUPER::execute(@_);
52:      $sth->{Taint} = $old_value;
53:      return $ret;
54:      }
55:
...
code stack:      /Library/Perl/5.8.6/DBIx/ContextualFetch.pm:51
/Library/Perl/5.8.6/DBIx/ContextualFetch.pm:31
/Library/Perl/5.8.6/DBIx/ContextualFetch.pm:86
/Library/Perl/5.8.6/Class/DBI.pm:852
/Library/Perl/5.8.6/Class/DBI.pm:839
/Library/Perl/5.8.6/Class/Accessor.pm:350
/Library/Perl/5.8.6/EMS/DBI.pm:188
/Library/WebServer/Documents/Development/ems/test.html:9