Forum OpenACS Improvement Proposals (TIPs): Re: TIP #29: Tree_sortkey improvements for performance and concurrency on postgresql

Can you elaborate on what the remaining concurrency problem is?
Its possible it's not really a concurrency bug and just a bug that manifested itself because unchanged null context_ids where falling through (I really did not investigate it once I realized it should not have been running at all in this case). I don't think thats the case though since running a single thread should have the same codepath and I didn't get the error there.

Anyway, here is the postgresql error log.....

2003-11-15 15:53:10 LOG:  query:
            select acs__add_user(
2003-11-15 15:53:10 ERROR:  Cannot insert a duplicate key into unique index acs_object_context_index_pk
2003-11-15 15:53:10 WARNING:  Error occurred while executing PL/pgSQL function acs_objects_context_id_up_tr
2003-11-15 15:53:10 WARNING:  line 28 at SQL statement