Message-ID: <002701bfec31$570bb180$c93b0dd8@webnet.qc.ca>
From: "Jonathan Marchand" <jonathanm@webnet.qc.ca>
To: <pgsql-interfaces@postgresql.org>
References: <20000712180556.7929.qmail@web120.yahoomail.com>
Subject: Re: Re: Subject: IIS4 ODBC LOGGING TO POSTGRES - CRASH HELP :) 
Date: Wed, 12 Jul 2000 14:45:23 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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/
>