Обсуждение: Re: Subject: IIS4 ODBC LOGGING TO POSTGRES - CRASH HELP :)
Jonathan, I think you would see improved performance and stability if you dump the IIS log to a regular file (the default setting) and then run a nightly process to dump the old files to the database. This has the advantage of being more reliable (fewer points of failure) and also faster, since the speed of logging affects the web server speed. -Mark Radulovich ================= Jonathan Marchand writes: Hi there, Anyone has experience with IIS4 (SP6a) and ODBC logging for websites? I'm logging about 150 websites to an SQL (postgres/linux) database thru ODBC. But for some reasons, IIS sometimes crash. I get a Dr. Watson screen and it just tells me that inetinfo has died. I get some very strange errors in event viewer too. I get: IIS ODBC Logging failed to log data to data source iis_logging. many many times :) and sometimes it just resumes: IIS ODBC Logging resumed logging to data source iis_logging. But the thing is that I did not stop my SQL server in the meantime. I really can't find what is the problem. And it is the only thing I found out that might cause IIS to hang. I checked on the linux box, and I have lots of postgres process doing nothing... They were started at the exact same time I get the errors in Event Viewer. I just kill them from time to time. (making a script to do so now) The SQL server is on the same 100mb ethernet segment. The connectivity between the hosts is just fine. And basically, the SQL just does that: iis logging :) I think this might be a problem with the ODBC driver on the NT box. I've been told that the ODBC driver runs into the same memory space as IIS. I'm running version 6.50.0000 of the ODBC driver. I'd like to be able to supply more informations (traces, memory dumps or whatever), if you can provide me with some instructions on how to do these, I'll do it :) So please, if you have any workaround for this, I'd appreciate your input :) Or maybe, just a hint :) ODBC logging works really nice other than that, we wrote a set of scripts that generate stats from the logs etc :) Regards, Jonathan Marchand Network Administrator WebNet Inc. - ISP jonathanm@webnet.qc.ca __________________________________________________ Do You Yahoo!? Get Yahoo! Mail � Free email you can access from anywhere! http://mail.yahoo.com/
Yes, but it would have the drawback (in addition to the loss of real-time access to the information) of losing the ability to log the web activity in chronological sequence, unless he has *very* tight control over the clocks on all 150 web servers. Of course, this may or may not be important to the original poster. On Wed, 12 Jul 2000, Mark Radulovich wrote: > Jonathan, > > I think you would see improved performance and stability if you dump > the IIS log to a regular file (the default setting) and then run a > nightly process to dump the old files to the database. > > This has the advantage of being more reliable (fewer points of > failure) and also faster, since the speed of logging affects the web > server speed. > > -Mark Radulovich > > ================= > Jonathan Marchand writes: > > Hi there, > > Anyone has experience with IIS4 (SP6a) and ODBC logging for websites? I'm > logging about 150 websites to an SQL (postgres/linux) database thru ODBC. > But for some reasons, IIS sometimes crash. I get a Dr. Watson screen and it > just tells me that inetinfo has died. -- Bob Kline mailto:bkline@rksystems.com http://www.rksystems.com
Mark, Yeah, that is what we are doing now... we are setting it up. We ran the setup of direct SQL/ODBC logging for about a week... it is way too unstable. We have no choice now but to do it that way. I don't really know which component to blame thought... IIS or PostODBC? :) Hehe, think I'll go for IIS :) Because we are not having much troubles with PostODBC with other applications. Regards, - Jonathan Marchand > Jonathan, > > I think you would see improved performance and stability if you dump the IIS > log to a regular file (the default setting) and then run a nightly process to > dump the old files to the database. > > This has the advantage of being more reliable (fewer points of failure) and > also faster, since the speed of logging affects the web server speed. > > -Mark Radulovich > > ================= > Jonathan Marchand writes: > > Hi there, > > Anyone has experience with IIS4 (SP6a) and ODBC logging for websites? I'm > logging about 150 websites to an SQL (postgres/linux) database thru ODBC. > But for some reasons, IIS sometimes crash. I get a Dr. Watson screen and it > just tells me that inetinfo has died. > > I get some very strange errors in event viewer too. I get: > > IIS ODBC Logging failed to log data to data source iis_logging. > > many many times :) and sometimes it just resumes: > > IIS ODBC Logging resumed logging to data source iis_logging. > > But the thing is that I did not stop my SQL server in the meantime. I really > can't find what is the problem. And it is the only thing I found out that > might cause IIS to hang. I checked on the linux box, and I have lots of > postgres process doing nothing... They were started at the exact same > time I get the errors in Event Viewer. I just kill them from time to time. > (making a script to do so now) > > The SQL server is on the same 100mb ethernet segment. The connectivity > between the hosts is just fine. And basically, the SQL just does that: iis > logging :) > > I think this might be a problem with the ODBC driver on the NT box. I've > been told that the ODBC driver runs into the same memory space as IIS. I'm > running version 6.50.0000 of the ODBC driver. > > I'd like to be able to supply more informations (traces, memory dumps or > whatever), > if you can provide me with some instructions on how to do these, I'll do it :) > > So please, if you have any workaround for this, I'd appreciate your input :) > Or maybe, just a hint :) ODBC logging works really nice other than that, we > wrote a set of scripts that generate stats from the logs etc :) > > Regards, > > Jonathan Marchand > Network Administrator > WebNet Inc. - ISP > jonathanm@webnet.qc.ca > > __________________________________________________ > Do You Yahoo!? > Get Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/ >