I have post this issue in the dotlrn forum, but maybe someone in the openacs forum could help me on this problem.
The problem is that I can register a participant to 2 or 3 class and then it's hang the postgres process.
after some research I find that the posgres process stay waiting like that :
postgres 19720 0.1 0.8 14572 9096 pts/0 S 12:20 0:02 postgres: nsadmin dotlrn_head [local] idle in transaction
postgres 19721 0.0 0.4 10428 5016 pts/0 S 12:20 0:01 postgres: nsadmin dotlrn_head [local] SELECT waiting
and if I try once more time their is a second process waiting and so on till all my process are stuck then I have to restart may OACS system.
it seems to append in the acs_rel__new function (i've run the sql directly in the psql to reproduce the problem - after a ctrl-c he give the error below line 22)
dotlrn_head=# select dotlrn_member_rel__new(NULL,'dotlrn_member_rel',NULL,'21635','27103','needs approval','27103','192.168.1.18');
NOTICE: Adding missing FROM-clause entry for table "acs_object_id_seq"
NOTICE: identifier "acs_object__initialize_attributes" will be truncated to "acs_object__initialize_attribut"
NOTICE: identifier "acs_object_type_get_tree_sortkey" will be truncated to "acs_object_type_get_tree_sortke"
NOTICE: identifier "acs_object_type_get_tree_sortkey" will be truncated to "acs_object_type_get_tree_sortke"
Cancel request sent
NOTICE: Error occurred while executing PL/pgSQL function acs_rel__new
NOTICE: line 22 at SQL statement
Everything is ready to go in production, but with this problem open we can't go live !
If anybody has already experience this kind of problem ...
Thank you for you help
denis
