[REBOL] Re: [SDK] [ODB] Memory leak? Frozen DB Calls?
From: greggirwin::mindspring::com at: 27-Apr-2004 16:06
AJ> I have a little reblet that makes several DB Calls (50-100) every hour on
AJ> the hour. Some of these calls get kinda large (~50k records each) If I run
AJ> the reblet every now and then closing it after it runs its process then
AJ> everything runs smoothly but if I leave it running on one of the servers
AJ> then a particular one of the DB programs freeze on that server. If I leave
AJ> it running on another machine then the program freezes on both servers. I
AJ> open a fresh DB connection and close it when it is done so it isn't leaving
AJ> a connection open but I don't UNSET any variables. Any ideas?
Without trying tests against different DBs (you're using ODBC I'm
guessing), the first thing that comes to mind (after adding logging to
see exactly what's going on when it freezes and sending that info to
RT), is to run the DB access scripts from a controller process, or
just cron/AT them; let them run and go away.
Could locking in the DB cause you to hang? Not sure exactly what
your scripts are doing, so it's hard to say if it's a REBOL bug or