🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.sysadmin
Article #1420

SYBASE crashes 3.0 - and SOLUTION !

#1420
From: Thomas Funke
Date: Sat, 10 Oct 1992 14:04
38 lines
2100 bytes
It's almost 1 year ago since several people have noticed, that Sybase would  
eventually crash the NeXT. It happened always after about 1000 logins into  
the server. I had some discussion with 'ask_next' and it came out, that it  
was a bug in NeXT-networking software. Anyway, nobody at NeXT could give a  
solution, so I waited for 3.0. Now, running the crash program showed the  
same behaviour: after 1000 logins the NeXT would come to a complete stop. 

Because several people have reported this bug, it is not understandable,  
nor acceptable that the responsible people at Next didn't care about it at  
all, even if I had given them my short program which verified the crash.  

Because the DB-Kit is one of the big improvements of 3.0, it's a mjor  
annoyance. Today I have tried again to find out what happens. And the  
solution is so simple:

Sybase (in the standard installation) uses port numbers 3696 and 4696 for  
communication with the server. NeXT internally assignes portnumbers  
1024-5000. This is standard BSD behaviour, btw.

And a 'netstat' just before crash-time showed: The NeXT tries to assign the  
same port Sybase is using !

So after changing the Sybase-installation to use portnumbers greater than  
5000, everything worked fine !

So for every tcp/ip-User/Programmer:

	NEVER USE PORT-NUMBERS <= 5000 !

Perhabs this should become part of the FAQ !


-- 
------------------------------------------------------------------
Thomas Funke  ** E-mail: thf@zelator.in-berlin.de
NeXT-Developer * Unix-Consultant
------------------------------------------------------------------
Technical Details
Message-ID: <1992Oct10.140419.6063@gamelan>
Path: arc1-ca.pugleaf.net!sparky!uunet!math.fu-berlin.de!news.netmbx.de!zelator!gamelan!thomas

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.sysadmin,comp.sys.next.programmer
Path: arc1-ca.pugleaf.net!sparky!uunet!math.fu-berlin.de!news.netmbx.de!zelator!gamelan!thomas
From: thf@zelator.in-berlin.de (Thomas Funke)
Subject: SYBASE crashes 3.0  - and SOLUTION !
Message-ID: <1992Oct10.140419.6063@gamelan>
Sender: thomas@gamelan (thomas)
Reply-To: thf@zelator.in-berlin.de (Thomas Funke)
Organization: NNU Corp. - NeXT is Not UN*X
Date: Sat, 10 Oct 1992 14:04:19 GMT
Lines: 38