[erlang-questions] Problem with pgsql and prepared statement usign UPDATE

Daniel Caune <>
Fri Dec 21 00:56:05 CET 2007


Hi,

I face a timeout after executing a prepared statement using UPDATE
clause against PostgreSQL.  I don't have any problem with any SELECT
clause, but UPDATE clause only.

()2> matchmaking_configuration:disable_revision(1).
** exited: {{case_clause,timeout},
            [{edbc_postgresql,execute_prepared_statement,3},
             {rdbms_helper,execute_prepared_statement,3},
             {erl_eval,do_apply,5},
             {shell,exprs,6},
             {shell,eval_loop,3}]} **

=ERROR REPORT==== 20-Dec-2007::18:41:26 ===
Error in process <0.36.0> on node '' with exit value:
{{case_clause,t
imeout},[{edbc_postgresql,execute_prepared_statement,3},{rdbms_helper,ex
ecute_pr
epared_statement,3},{erl_eval,do_apply,5},{shell,exprs,6},{shell,eval_lo
op,3}]}

The PostgreSQL log file doesn't reveal any problem.

2007-12-20 18:41:52 EST LOG:  execute <unnamed>: UPDATE
matchmaking_metadata
                 SET status = $1
                 WHERE revision_number = $2
2007-12-20 18:41:52 EST DETAIL:  parameters: $1 = '2', $2 = '1'
2007-12-20 18:41:52 EST LOG:  duration: 0.255 ms

The UPDATE has been successfully executed.  The timeout is raised
somewhere in the pgsql library for some reason.  Any idea before I dive
into the pgsql code?

Regards,

--
Daniel



More information about the erlang-questions mailing list