Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[REBOL] Re: [SDK] [ODB] Memory leak? Frozen DB Calls?

From: greggirwin::mindspring::com at: 27-Apr-2004 16:06

Hi Ammon, 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 not. -- Gregg