From: Jonathan Marchand <jonathanm@webnet.qc.ca>
To: pgsql-interfaces@postgresql.org
Subject: IIS4 ODBC LOGGING TO POSTGRES - CRASH HELP :)
Date: Tue, 11 Jul 2000 10:40:18 -0400
Message-ID: <004301bfeb45$ef496a60$c93b0dd8@webnet.qc.ca> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jonathanm@webnet.qc.ca
Subject: Re: IIS4 ODBC LOGGING TO POSTGRES - CRASH HELP :)
In-Reply-To: <004301bfeb45$ef496a60$c93b0dd8@webnet.qc.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox