Forum OpenACS Q&A: DB handle error met in filter

I'm not exactly sure by what you mean by trace filter but I've seen this error in cases where I've done something dumb like adding the ns_db gethandle call in a loop. Or in a long page tried to aquire the handle twice.

I think that the main page/function you are calling the filtering code from already has a handle to the log pool and then the filter function tries to aquire one too.

One solution is to aquire the db handle in the main function/page and pass it into your trace filtering function as an argument.

I have an old version of OpenACS running and am also not sure which one you're running so I'll tell you what I would do if I had the same problem.

If you go to the main tcl directory for your OpenACS site. (probably /web/your_server/tcl)

From that directory do a grep on ns_register_proc (If you want to get a more in depth explanation of the function you can check out this url: Sites That Are Really Programs or the AOLServer documentation). In essence it registers a tcl procedure to handle a certain url. Within the system there are various procedures that handle various things. Eg. on my system ad_server_html_page is registered to html pages.

It's possible that, that registered function or any number of other registered functions grabs a "log" pool db handle and doesn't release it.

Now just as an aside.... if you just want debug logging you can use the ns_log functionality to print stuff into you server log.