Fw: Linking to cygwin1.dll and msvcrt.dll

Fw: Linking to cygwin1.dll and msvcrt.dll

[eCommerce Software Solutions Inc.]

BUG: cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000 with
SP1


Hi Corinna, Mo and Mumit,

I am a brand new Cygwin user, who started using it basically to postgresql
on WIN2000.

The situation is this:

I have cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000
with SP1.

I use Java and JDBC to connect from a Windows to Postgresql server to do a
very simple select:

select count(*) from table1; // returns count of 2

It works fine.

Now I run this on 10 threads in my Java program. Each thread loops for
100000000 times.

When I do this every thing appears to be ok at first. Then, I realize that I
am loosing free memory really fast.

I go in the "task manager" in windows 2000 and look at the memory usage for
each process. It is fine i.e not growing.

But Available physical memory is going down really fast. I have no clue at
first.

Then I notice that in Performance tab of Windows task manager, under Totals,
the handles is running very fast.

I discovered that it begins from 4080 and goes on incrimenting ( to a very
large number ) until I run out of memory.

I have a feeling that this is related to close of handles problem you are
discussing under subject
"Linking to cygwin1.dll and msvcrt.dll"

Mo has provided a patch. But I don't know how to apply this ( I am very good
at Unix and C++ but fear screwing something up

as the diff lookcomplicated).

Could you folks guide me. I can use Postgresql on Win2000 only if Cygwin is
stable in this regard.

Again, I am not very aware of protocol ( being new), so please ignore any
deficiency.

Thanks all.

Vinay

PS: Admire you folks. You are Heroes.


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Fw: Linking to cygwin1.dll and msvcrt.dll

[Christopher Faylor]

On Fri, Jul 20, 2001 at 10:43:31PM -0700, eCommerce Software Solutions Inc. wrote:
>
>
>BUG: cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000 with
>SP1
>
>
>Hi Corinna, Mo and Mumit,
>
>I am a brand new Cygwin user, who started using it basically to postgresql
>on WIN2000.
>
>The situation is this:
>
>I have cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000
>with SP1.
>
>I use Java and JDBC to connect from a Windows to Postgresql server to do a
>very simple select:
>
>select count(*) from table1; // returns count of 2
>
>It works fine.
>
>Now I run this on 10 threads in my Java program. Each thread loops for
>100000000 times.
>
>When I do this every thing appears to be ok at first. Then, I realize that I
>am loosing free memory really fast.
>
>I go in the "task manager" in windows 2000 and look at the memory usage for
>each process. It is fine i.e not growing.
>
>But Available physical memory is going down really fast. I have no clue at
>first.
>
>Then I notice that in Performance tab of Windows task manager, under Totals,
>the handles is running very fast.
>
>I discovered that it begins from 4080 and goes on incrimenting ( to a very
>large number ) until I run out of memory.
>
>I have a feeling that this is related to close of handles problem you are
>discussing under subject
>"Linking to cygwin1.dll and msvcrt.dll"
>
>Mo has provided a patch. But I don't know how to apply this ( I am very good
>at Unix and C++ but fear screwing something up
>
>as the diff lookcomplicated).
>
>Could you folks guide me. I can use Postgresql on Win2000 only if Cygwin is
>stable in this regard.

I don't see how this could have anything to do with Mo's patch.  His patch
was for tcl.  You are not using tcl.

It sounds like you have an old-fashioned handle leak in your program, although
it is not clear if it is your program or Postgres which is having the problem.

cgf


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win 2000 SP1

[eCommerce Software Solutions Inc.]

Subject: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win 2000

The situation is this:

I have cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000
with SP1.

I use Java and JDBC to connect from a Windows to Postgresql server to do a
very simple select:
select count(*) from table1; // returns count of 2

It works fine.

Now I run this on 10 threads in my Java program. Each thread loops for
100000000 times.

When I do this every thing appears to be ok at first. Then, I realize that I
am loosing free memory really fast.

I go in the "task manager" in windows 2000 and look at the memory usage for
each process. It is fine i.e not growing.

But Available physical memory is going down really fast. I have no clue at
first.

Then I notice that in Performance tab of Windows task manager, under Totals,
the handles is running very fast.

I discovered that it begins from 4080 and goes on incrimenting ( to a very
large number ) until I run out of memory.

Since both client and DB server are on the same machine it is hard to tell
which is leaking handles!

Now I moved the client to another machine.  The client uses JDBC to connect
to the PG Database running in Win2000 Cygwin environment on another Machine.
I looked at the Windows Task Monitor to notice that there are no leaking
handles on the client Machine. Therefore leak is not in my Program.

The handles are being leaked by PG on the Machine acting as DB Server in
Cygwin environment.

I hope this isolates the problem further to PG and Cygwin and not JDBC and
Client code.

Lets fix this problem.

Thanks,

Vinay




--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win 2000 SP1

[Jason Tishler]

Vinay,

On Sat, Jul 21, 2001 at 09:07:31PM -0700, eCommerce Software Solutions wrote:
> The situation is this:
> 
> I have cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000
> with SP1.
> 
> [snip]
> 
> The handles are being leaked by PG on the Machine acting as DB Server in
> Cygwin environment.
> 
> I hope this isolates the problem further to PG and Cygwin and not JDBC and
> Client code.
> 
> Lets fix this problem.

It has been reported that this problem has been fixed in a post Cygwin
1.3.2 snapshot:

    http://fts.postgresql.org/db/mw/msg.html?mid=1025694

Please repeat your test with the latest snapshot (i.e., 2001-Jul-19):

    http://www.cygwin.com/snapshots/

and report back to the list whether or not your problem has already
been solved.

Thanks,
Jason

-- 
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win 2000 SP1

[eCommerce Software Solutions Inc.]

Hi Jason,

Yes the problem seems to be fixed with the latest Cygwin.

Thanks All.

Vinay


----- Original Message -----
From: "Jason Tishler" <jason@tishler.net>
To: "eCommerce Software Solutions Inc." <vinaysoni1@home.com>
Cc: <cygwin@cygwin.com>; "Pgsql-Cygwin" <pgsql-cygwin@postgresql.org>
Sent: Saturday, July 21, 2001 6:23 PM
Subject: Re: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win
2000 SP1


> Vinay,
>
> On Sat, Jul 21, 2001 at 09:07:31PM -0700, eCommerce Software Solutions
wrote:
> > The situation is this:
> >
> > I have cygwin with ( dll 1.3.2 ) and latest Postgresql 7.1.2 on Win 2000
> > with SP1.
> >
> > [snip]
> >
> > The handles are being leaked by PG on the Machine acting as DB Server in
> > Cygwin environment.
> >
> > I hope this isolates the problem further to PG and Cygwin and not JDBC
and
> > Client code.
> >
> > Lets fix this problem.
>
> It has been reported that this problem has been fixed in a post Cygwin
> 1.3.2 snapshot:
>
>     http://fts.postgresql.org/db/mw/msg.html?mid=1025694
>
> Please repeat your test with the latest snapshot (i.e., 2001-Jul-19):
>
>     http://www.cygwin.com/snapshots/
>
> and report back to the list whether or not your problem has already
> been solved.
>
> Thanks,
> Jason
>
> --
> Jason Tishler
> Director, Software Engineering       Phone: 732.264.8770 x235
> Dot Hill Systems Corp.               Fax:   732.264.8798
> 82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
> Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/