Mailing List Archive


Back to the month index Back to the list index
Dean Karres (karres@southwind.net)
Thu, 20 Nov 1997 13:43:13 -0600 (CST) 

From: Dean Karres <karres@southwind.net>
Message-Id: <199711201943.NAA15418@onyx.southwind.net>
Subject: Re: MSQL-LIST digest 130
Date: Thu, 20 Nov 1997 13:43:13 -0600 (CST)

> Date: Wed, 19 Nov 1997 18:23:17 -0600
> From: Bill Harris <billh@airmail.net>
> To: msql-list@services.bunyip.com
> Subject: Re: corrupted "real" and "money" values in 2.0.3
> Message-ID: <347382F5.31DFF4F5@airmail.net>
>
> Well, it appears after spending a bit more time, that it is only
> the money datatype that isn't being initialized correctly on a
> query cursor, and then only if the value is 0.00.

Thanks Bill,

I could have *sworn* that it affected "real" fields too but I have not
made it fail today using them. Thanks again.

Dean...K... 

-- 
Dean Karres               | http://www2.southwind.net/~karres
     karres@southwind.net |
Southwind Internet Access | Programmer / Systems Administrator
Wichita, KS               | <Troll 2nd Class /w Clusters>
From grantt@nortel.ca  Thu Nov 20 14:49:24 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA18070
	for <msql-list@services.bunyip.com>; Thu, 20 Nov 1997 14:49:23 -0500 (EST)
Received: from bcarsde4.localhost (mailgate.nortel.ca [192.58.194.74])
	by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA00549
	for <msql-list@Bunyip.Com>; Thu, 20 Nov 1997 14:49:20 -0500 (EST)
Message-Id: <199711201949.OAA00549@mocha.bunyip.com>
Received: from bcarsfba.ca.nortel.com (actually bcarsfba.bnr.ca) 
          by bcarsde4.localhost; Thu, 20 Nov 1997 12:19:53 -0500
Received: from bnr.ca by bcarsfba.bnr.ca id <26877-0@bcarsfba.bnr.ca>;
          Thu, 20 Nov 1997 12:19:13 -0500
Date: 20 Nov 1997 12:19 EST
Sender: "Grant Totten" <grantt@nortel.ca>
To: cybrghst@tir.com
Cc: msql-list@Bunyip.Com
From: "Grant Totten" <grantt@nortel.ca>
Subject: Re: Error Condition Re: Bad Hand Shakes Too Many Connections

Hello,

I remember reporting this problem a long time ago.  I didn't receive
any solutions. 

So I guess I'm seconding the question: is there any news on this issue?

In the system i'm developing, I included a loop that checks if the
msql connect was successful.  If it wasn't, the routine sleeps for a
second or two, then it re-attempts the connection.  This loop keeps
trying 10 times.

Grant Totten
Nortel Public Data Networks

In message "Re: Error Condition Re: Bad Hand Shakes Too Many Connections", 
you write:

> Hello,
> 
> I was wondering if anyone knew if the latest version off mSQL
> (msql2.0.3 i think) has taken care of the "To many connections"
> problem that i am having.  After reading the mail archive I found
> others who were having exactly the same problem as i am.  I am
> running msql2.0.1 on a sparc 20.  A few days ago my database
> locked up with "Too many connections". I had to restart it.
> 
> Since then I have been watch the connections and they keep climbing.
> Acorrding to the archive mail, the connections that stay
> are ones that were generated from "Bad Handshakes".  A common
> problem on sparc 20's.  Does any know  of a patch or will
> upgrading to 2.0.3 be good enough ??  Below is a stats on the server.
> -thanx
> 
> 
>  Config file      : /usr/local/Hughes/msql.conf
> Max connections  : 214
> Cur connections  : 163
> Running as user  : http
> Connection table :
>   Sock    Username       Hostname        Database    Connect   Idle
> Queries
> 
> +-----+------------+-----------------+------------+---------+------+--------
> +
> |   7 | root       | earth.tir.com   | tir_ips    | 42H  4M |    0 | 348726
> |
> |  20 | root       | UNIX Sock       | No DB      |  0H  0M |    0 |      1
> |
> |  23 | root       | uranus.tir.com  | tir_ips    | 42H  0M |    0 |  52163 | 
> +-----+------------+-----------------+------------+---------+------+--------
>     
>
From corrado@mail.clio.it  Thu Nov 20 17:21:58 1997
Received: from mail.clio.it ([195.60.128.2])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id RAA19874
	for <msql-list@services.bunyip.com>; Thu, 20 Nov 1997 17:21:56 -0500 (EST)
Received: from md4.clio.it (195.60.141.14) by mail.clio.it
 with SMTP (Eudora Internet Mail Server 1.2); Thu, 20 Nov 1997 23:24:24 +0100
From: "Corrado Agusto" <corrado@mail.clio.it>
To: "msql-list@services.bunyip.com" <msql-list@services.bunyip.com>
Date: Thu, 20 Nov 97 23:22:16 
Reply-To: "Corrado Agusto" <corrado@mail.clio.it>
Priority: Normal
X-Mailer: PMMail 1.95a For OS/2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Subject: os2 porting
Message-ID: <1332054232-2496840@mail.clio.it>

Hi there, 
does anyone know where os2 porting of mSQL 2.03 is located ?

Contributed software on hughes.com doesn't report anything about, and link to Dirk's 
homepage is not active :-(

Thank you very much.
corrado agusto \\___ corrado@mail.clio.it