Forum OpenACS Development: Re: Can two ns_schedule procs hose a server?

Posted by Dan Lieberman on
Thx for the response:
"Spontaneously dies" means this:
19:18 - end of schedule proc, excessive time taken (61 seconds)

19:22 - ns_getform select user_id etc...from users
(Somebody trying to login)
19:22 select passwd
19:22 update sec_sessions
19:22 select from wt_users (our extension to users)
19:22 update users set last_visit

The user logging in then gets a msg - page not available
when you do ps ax | grep nsd - all the nsd threads are gone.

I agree with you - with such simple queries - it is definitely not a db issue (Ora vs PG)