Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

mysterious connection

2 posts in General Discussion Last posting was on 2004-01-10 14:51:34.0Z
Thomas George Posted on 2004-01-09 21:36:09.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
Subject: mysterious connection
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Original-NNTP-Posting-Host: 66.243.22.98
Message-ID: <3fff20e3$1@forums-2-dub>
X-Original-Trace: 9 Jan 2004 13:45:07 -0800, 66.243.22.98
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Jan 2004 13:21:25 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Jan 2004 13:36:09 -0800
X-Trace: forums-1-dub 1073684169 10.22.108.75 (9 Jan 2004 13:36:09 -0800)
X-Original-Trace: 9 Jan 2004 13:36:09 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2270
Article PK: 4475

I have been experience a database crash (server simply disappears) almost
every morning for the last 3 months. I have SQLA Server 5.5.05 Build 2817
running on Win NT.
When I checked the server logs, I noticed that for the last 3 months there
have been about 10 connections to the database around 2 AM. All the
connections come in at the same instant in time. If they all disconnect then
the database survies and if they all diconnect, they do so at the same
instant in time. However, whenever the database crashes, the last things I
see in the server log are the 10 connections and nothing after that.
I do not run any scheduled tasks on the NT server and neither do I have any
users or application connecting to the database at 2 in the morning. The
connections sometimes happen at 1:57 am, some days it is 2:01 am, 2:04 on
other days.
I will paste a sample of the end of the server log after the crash:

02:04:42 dba:SQL_DBC_8cf7658 connected
02:04:42 dba:SQL_DBC_8cf7a40 connected
02:04:42 dba:SQL_DBC_8d10c30 connected
02:04:42 dba:SQL_DBC_8d11030 connected
02:04:42 dba:SQL_DBC_8d112f8 connected
02:04:42 dba:SQL_DBC_8d115c0 connected
02:04:42 dba:SQL_DBC_8d11918 connected
02:04:42 dba:SQL_DBC_8d11c60 connected
02:04:42 dba:SQL_DBC_8d10030 connected


Is there anyway I can find out what IP address these connections are
originating from?
Please help.
Thanks
Thomas


Chris Keating (iAnywhere Solutions) Posted on 2004-01-10 14:51:34.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3fff20e3$1@forums-2-dub>
Subject: Re: mysterious connection
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: surfec007.sybase.com
Message-ID: <40001392$1@forums-2-dub>
X-Original-Trace: 10 Jan 2004 07:00:34 -0800, surfec007.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Jan 2004 06:36:45 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Jan 2004 06:51:34 -0800
X-Trace: forums-1-dub 1073746294 10.22.108.75 (10 Jan 2004 06:51:34 -0800)
X-Original-Trace: 10 Jan 2004 06:51:34 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2271
Article PK: 4476

sa_conn_info should provide you that information but only at the time of the
conenction. You may want to set -Z engine option which will capture the
communication requests at the server.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Thomas George" <georgeth@phmns.com> wrote in message
news:3fff20e3$1@forums-2-dub...
> I have been experience a database crash (server simply disappears) almost
> every morning for the last 3 months. I have SQLA Server 5.5.05 Build 2817
> running on Win NT.
> When I checked the server logs, I noticed that for the last 3 months there
> have been about 10 connections to the database around 2 AM. All the
> connections come in at the same instant in time. If they all disconnect
then
> the database survies and if they all diconnect, they do so at the same
> instant in time. However, whenever the database crashes, the last things I
> see in the server log are the 10 connections and nothing after that.
> I do not run any scheduled tasks on the NT server and neither do I have
any
> users or application connecting to the database at 2 in the morning. The
> connections sometimes happen at 1:57 am, some days it is 2:01 am, 2:04 on
> other days.
> I will paste a sample of the end of the server log after the crash:
>
> 02:04:42 dba:SQL_DBC_8cf7658 connected
> 02:04:42 dba:SQL_DBC_8cf7a40 connected
> 02:04:42 dba:SQL_DBC_8d10c30 connected
> 02:04:42 dba:SQL_DBC_8d11030 connected
> 02:04:42 dba:SQL_DBC_8d112f8 connected
> 02:04:42 dba:SQL_DBC_8d115c0 connected
> 02:04:42 dba:SQL_DBC_8d11918 connected
> 02:04:42 dba:SQL_DBC_8d11c60 connected
> 02:04:42 dba:SQL_DBC_8d10030 connected
>
>
> Is there anyway I can find out what IP address these connections are
> originating from?
> Please help.
> Thanks
> Thomas
>
>