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.

Frequent Database crashes

11 posts in General Discussion Last posting was on 2004-01-19 15:37:00.0Z
Thomas George Posted on 2004-01-14 16:50:49.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
Subject: Frequent Database crashes
Lines: 61
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
NNTP-Posting-Host: 66.243.22.98
X-Original-NNTP-Posting-Host: 66.243.22.98
Message-ID: <40057369$1@forums-1-dub>
Date: 14 Jan 2004 08:50:49 -0800
X-Trace: forums-1-dub 1074099049 66.243.22.98 (14 Jan 2004 08:50:49 -0800)
X-Original-Trace: 14 Jan 2004 08:50:49 -0800, 66.243.22.98
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2290
Article PK: 4495

I have an SQLAnywhere server 5.5.05 Build 2817 running on a Windows 2000
server. Some some strange reason, the server shutdows at once a day at
different times. I do not see any error message on the screen. Also, there
are no error messages in the server log.
Below is an extract of the sever log file from the end of the file:
09:15:31 dba:SQL_DBC_1770218 connected
09:16:39 dba:SQL_DBC_1770218 disconnected
09:16:39 dba:SQL_DBC_1770030 disconnected
09:19:23 dba:SQL_DBC_1770030 connected
09:19:23 dba:SQL_DBC_1770218 connected
09:20:29 dba:SQL_DBC_1770218 disconnected
09:21:09 dba:SQL_DBC_1770030 disconnected
09:21:09 dba:SQL_DBC_1770030 connected
09:21:10 dba:SQL_DBC_1771738 connected
09:22:39 dba:SQL_DBC_1770030 disconnected
09:22:49 dba:SQL_DBC_1771738 disconnected
09:27:39 dba:SQL_DBC_1770030 connected
09:27:39 dba:SQL_DBC_1770218 connected
09:28:39 dba:SQL_DBC_1770030 disconnected
09:28:39 dba:SQL_DBC_1770218 disconnected
09:40:35 dba:SQL_DBC_1770030 connected
09:40:36 dba:SQL_DBC_1770218 connected
09:42:49 dba:SQL_DBC_1770218 disconnected
09:43:09 dba:SQL_DBC_1770030 disconnected
09:44:12 dba:SQL_DBC_1770030 connected
09:44:23 dba:SQL_DBC_1770218 connected
09:45:19 dba:SQL_DBC_1770030 disconnected
09:45:39 dba:SQL_DBC_1770218 disconnected
09:45:45 dba:SQL_DBC_1770030 connected
09:46:49 dba:SQL_DBC_1770030 disconnected
09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
09:49:46 dba:SQL_DBC_773e40 connected
09:50:49 dba:SQL_DBC_773e40 disconnected
09:54:36 dba:SQL_DBC_773e40 connected
09:55:04 dba:SQL_DBC_1770030 connected
09:57:09 dba:SQL_DBC_1770030 disconnected
09:57:09 dba:SQL_DBC_773e40 disconnected
09:57:57 dba:SQL_DBC_1770030 connected
09:58:59 dba:SQL_DBC_1770030 disconnected
10:02:08 dba:SQL_DBC_773e40 connected
10:03:19 dba:SQL_DBC_773e40 disconnected
10:07:11 dba:SQL_DBC_773e40 connected
10:07:11 dba:SQL_DBC_1770030 connected
10:09:19 dba:SQL_DBC_1770030 disconnected
10:09:39 dba:SQL_DBC_773e40 disconnected
10:10:57 dba:__dbx398824651229612728 connected
10:11:29 dba:SQL_DBC_773e40 connected
10:11:31 dba:SQL_DBC_1770030 connected


The database is used by our intranet website. It is used to authenticate
user ids and passwords. It also has data tables which contains data for the
reports served on the intranet.
So it is mostly a read only database.
Can anyone tell me why its crashing
Thanks
Thomas


Robert Waywell Posted on 2004-01-14 19:31:28.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 93
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <40059910$1@forums-1-dub>
Date: 14 Jan 2004 11:31:28 -0800
X-Trace: forums-1-dub 1074108688 172.31.142.236 (14 Jan 2004 11:31:28 -0800)
X-Original-Trace: 14 Jan 2004 11:31:28 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2294
Article PK: 4500

As you mentioned, there is nothing in the server output that you posted to
show that the server 'crashed'. If you have also checked the server window
and seen that there are no error's there, then I start to get confused as to
what you mean when you say it 'crashed'. What are the actual symptoms you
are seeing?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Thomas George" <georgeth@phmns.com> wrote in message
news:40057369$1@forums-1-dub...
> I have an SQLAnywhere server 5.5.05 Build 2817 running on a Windows 2000
> server. Some some strange reason, the server shutdows at once a day at
> different times. I do not see any error message on the screen. Also, there
> are no error messages in the server log.
> Below is an extract of the sever log file from the end of the file:
> 09:15:31 dba:SQL_DBC_1770218 connected
> 09:16:39 dba:SQL_DBC_1770218 disconnected
> 09:16:39 dba:SQL_DBC_1770030 disconnected
> 09:19:23 dba:SQL_DBC_1770030 connected
> 09:19:23 dba:SQL_DBC_1770218 connected
> 09:20:29 dba:SQL_DBC_1770218 disconnected
> 09:21:09 dba:SQL_DBC_1770030 disconnected
> 09:21:09 dba:SQL_DBC_1770030 connected
> 09:21:10 dba:SQL_DBC_1771738 connected
> 09:22:39 dba:SQL_DBC_1770030 disconnected
> 09:22:49 dba:SQL_DBC_1771738 disconnected
> 09:27:39 dba:SQL_DBC_1770030 connected
> 09:27:39 dba:SQL_DBC_1770218 connected
> 09:28:39 dba:SQL_DBC_1770030 disconnected
> 09:28:39 dba:SQL_DBC_1770218 disconnected
> 09:40:35 dba:SQL_DBC_1770030 connected
> 09:40:36 dba:SQL_DBC_1770218 connected
> 09:42:49 dba:SQL_DBC_1770218 disconnected
> 09:43:09 dba:SQL_DBC_1770030 disconnected
> 09:44:12 dba:SQL_DBC_1770030 connected
> 09:44:23 dba:SQL_DBC_1770218 connected
> 09:45:19 dba:SQL_DBC_1770030 disconnected
> 09:45:39 dba:SQL_DBC_1770218 disconnected
> 09:45:45 dba:SQL_DBC_1770030 connected
> 09:46:49 dba:SQL_DBC_1770030 disconnected
> 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> 09:49:46 dba:SQL_DBC_773e40 connected
> 09:50:49 dba:SQL_DBC_773e40 disconnected
> 09:54:36 dba:SQL_DBC_773e40 connected
> 09:55:04 dba:SQL_DBC_1770030 connected
> 09:57:09 dba:SQL_DBC_1770030 disconnected
> 09:57:09 dba:SQL_DBC_773e40 disconnected
> 09:57:57 dba:SQL_DBC_1770030 connected
> 09:58:59 dba:SQL_DBC_1770030 disconnected
> 10:02:08 dba:SQL_DBC_773e40 connected
> 10:03:19 dba:SQL_DBC_773e40 disconnected
> 10:07:11 dba:SQL_DBC_773e40 connected
> 10:07:11 dba:SQL_DBC_1770030 connected
> 10:09:19 dba:SQL_DBC_1770030 disconnected
> 10:09:39 dba:SQL_DBC_773e40 disconnected
> 10:10:57 dba:__dbx398824651229612728 connected
> 10:11:29 dba:SQL_DBC_773e40 connected
> 10:11:31 dba:SQL_DBC_1770030 connected
>
>
> The database is used by our intranet website. It is used to authenticate
> user ids and passwords. It also has data tables which contains data for
the
> reports served on the intranet.
> So it is mostly a read only database.
> Can anyone tell me why its crashing
> Thanks
> Thomas
>
>
>


Thomas George Posted on 2004-01-14 21:18:34.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 104
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
NNTP-Posting-Host: 66.243.22.98
X-Original-NNTP-Posting-Host: 66.243.22.98
Message-ID: <4005b22a@forums-1-dub>
Date: 14 Jan 2004 13:18:34 -0800
X-Trace: forums-1-dub 1074115114 66.243.22.98 (14 Jan 2004 13:18:34 -0800)
X-Original-Trace: 14 Jan 2004 13:18:34 -0800, 66.243.22.98
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2296
Article PK: 4501

by "crashed" i meant to say that the Server simply terminated - the service
stopped running....the symptom is that users are unable to connect to the
intranet wesite as the database is not running anymore

Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
news:40059910$1@forums-1-dub...
> As you mentioned, there is nothing in the server output that you posted to
> show that the server 'crashed'. If you have also checked the server window
> and seen that there are no error's there, then I start to get confused as
to
> what you mean when you say it 'crashed'. What are the actual symptoms you
> are seeing?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Thomas George" <georgeth@phmns.com> wrote in message
> news:40057369$1@forums-1-dub...
> > I have an SQLAnywhere server 5.5.05 Build 2817 running on a Windows 2000
> > server. Some some strange reason, the server shutdows at once a day at
> > different times. I do not see any error message on the screen. Also,
there
> > are no error messages in the server log.
> > Below is an extract of the sever log file from the end of the file:
> > 09:15:31 dba:SQL_DBC_1770218 connected
> > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > 09:19:23 dba:SQL_DBC_1770030 connected
> > 09:19:23 dba:SQL_DBC_1770218 connected
> > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > 09:21:09 dba:SQL_DBC_1770030 connected
> > 09:21:10 dba:SQL_DBC_1771738 connected
> > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > 09:27:39 dba:SQL_DBC_1770030 connected
> > 09:27:39 dba:SQL_DBC_1770218 connected
> > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > 09:40:35 dba:SQL_DBC_1770030 connected
> > 09:40:36 dba:SQL_DBC_1770218 connected
> > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > 09:44:12 dba:SQL_DBC_1770030 connected
> > 09:44:23 dba:SQL_DBC_1770218 connected
> > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > 09:45:45 dba:SQL_DBC_1770030 connected
> > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > 09:49:46 dba:SQL_DBC_773e40 connected
> > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > 09:54:36 dba:SQL_DBC_773e40 connected
> > 09:55:04 dba:SQL_DBC_1770030 connected
> > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > 09:57:57 dba:SQL_DBC_1770030 connected
> > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > 10:02:08 dba:SQL_DBC_773e40 connected
> > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > 10:07:11 dba:SQL_DBC_773e40 connected
> > 10:07:11 dba:SQL_DBC_1770030 connected
> > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > 10:10:57 dba:__dbx398824651229612728 connected
> > 10:11:29 dba:SQL_DBC_773e40 connected
> > 10:11:31 dba:SQL_DBC_1770030 connected
> >
> >
> > The database is used by our intranet website. It is used to authenticate
> > user ids and passwords. It also has data tables which contains data for
> the
> > reports served on the intranet.
> > So it is mostly a read only database.
> > Can anyone tell me why its crashing
> > Thanks
> > Thomas
> >
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-01-15 05:25:02.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 145
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
NNTP-Posting-Host: vpn-concord-121.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-121.sybase.com
Message-ID: <4006242e@forums-1-dub>
Date: 14 Jan 2004 21:25:02 -0800
X-Trace: forums-1-dub 1074144302 158.159.8.121 (14 Jan 2004 21:25:02 -0800)
X-Original-Trace: 14 Jan 2004 21:25:02 -0800, vpn-concord-121.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2299
Article PK: 4504

Errors in an application running as a service are sent to the event viewer.
What is in the event viewer related to this service?
--

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:4005b22a@forums-1-dub...
> by "crashed" i meant to say that the Server simply terminated - the
service
> stopped running....the symptom is that users are unable to connect to the
> intranet wesite as the database is not running anymore
>
> Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> news:40059910$1@forums-1-dub...
> > As you mentioned, there is nothing in the server output that you posted
to
> > show that the server 'crashed'. If you have also checked the server
window
> > and seen that there are no error's there, then I start to get confused
as
> to
> > what you mean when you say it 'crashed'. What are the actual symptoms
you
> > are seeing?
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Thomas George" <georgeth@phmns.com> wrote in message
> > news:40057369$1@forums-1-dub...
> > > I have an SQLAnywhere server 5.5.05 Build 2817 running on a Windows
2000
> > > server. Some some strange reason, the server shutdows at once a day at
> > > different times. I do not see any error message on the screen. Also,
> there
> > > are no error messages in the server log.
> > > Below is an extract of the sever log file from the end of the file:
> > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > 10:10:57 dba:__dbx398824651229612728 connected
> > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > 10:11:31 dba:SQL_DBC_1770030 connected
> > >
> > >
> > > The database is used by our intranet website. It is used to
authenticate
> > > user ids and passwords. It also has data tables which contains data
for
> > the
> > > reports served on the intranet.
> > > So it is mostly a read only database.
> > > Can anyone tell me why its crashing
> > > Thanks
> > > Thomas
> > >
> > >
> > >
> >
> >
>
>


Thomas George Posted on 2004-01-15 15:44:55.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub> <4006242e@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 168
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: <4006b7a6$1@forums-2-dub>
X-Original-Trace: 15 Jan 2004 07:54:14 -0800, 66.243.22.98
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Jan 2004 07:29:37 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Jan 2004 07:44:55 -0800
X-Trace: forums-1-dub 1074181495 10.22.108.75 (15 Jan 2004 07:44:55 -0800)
X-Original-Trace: 15 Jan 2004 07:44:55 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2304
Article PK: 4509

at the very instant the database server went down, I noticed the following
in the Application Event Log:

"The application , , generated an application error The error occurred on
1/14/2004 at 10:11:31:687 The exception
generated was c0000005 at address77F9518B (ZwDeviceIOControlFile)"

I found a similar entry in the event log at all other times the database
server crashed.

Chris Keating (iAnywhere Solutions) <FightSpam_keating@iAnywhere.com> wrote
in message news:4006242e@forums-1-dub...
> Errors in an application running as a service are sent to the event
viewer.
> What is in the event viewer related to this service?
> --
>
> 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:4005b22a@forums-1-dub...
> > by "crashed" i meant to say that the Server simply terminated - the
> service
> > stopped running....the symptom is that users are unable to connect to
the
> > intranet wesite as the database is not running anymore
> >
> > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > news:40059910$1@forums-1-dub...
> > > As you mentioned, there is nothing in the server output that you
posted
> to
> > > show that the server 'crashed'. If you have also checked the server
> window
> > > and seen that there are no error's there, then I start to get confused
> as
> > to
> > > what you mean when you say it 'crashed'. What are the actual symptoms
> you
> > > are seeing?
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to all
> > >
> > > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> > >
> > > SQL Anywhere Studio Supported Platforms and Support Status
> > > http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > news:40057369$1@forums-1-dub...
> > > > I have an SQLAnywhere server 5.5.05 Build 2817 running on a Windows
> 2000
> > > > server. Some some strange reason, the server shutdows at once a day
at
> > > > different times. I do not see any error message on the screen. Also,
> > there
> > > > are no error messages in the server log.
> > > > Below is an extract of the sever log file from the end of the file:
> > > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > > 10:10:57 dba:__dbx398824651229612728 connected
> > > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > > 10:11:31 dba:SQL_DBC_1770030 connected
> > > >
> > > >
> > > > The database is used by our intranet website. It is used to
> authenticate
> > > > user ids and passwords. It also has data tables which contains data
> for
> > > the
> > > > reports served on the intranet.
> > > > So it is mostly a read only database.
> > > > Can anyone tell me why its crashing
> > > > Thanks
> > > > Thomas
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Robert Waywell Posted on 2004-01-15 16:09:25.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub> <4006242e@forums-1-dub> <4006b7a6$1@forums-2-dub>
Subject: Re: Frequent Database crashes
Lines: 216
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <4006bb35$1@forums-1-dub>
Date: 15 Jan 2004 08:09:25 -0800
X-Trace: forums-1-dub 1074182965 172.31.142.236 (15 Jan 2004 08:09:25 -0800)
X-Original-Trace: 15 Jan 2004 08:09:25 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2305
Article PK: 4510

This still doesn't point to the database server in anyway. It could be the
database server, but at this point the problem could just as well be at the
application level.

Have you tried connecting directly to the database from ISQL when the
website is down?
Does the dbsrv50 process still show in task manager when the website is
down?
Is there a Dr. Watson log generated?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Thomas George" <georgeth@phmns.com> wrote in message
news:4006b7a6$1@forums-2-dub...
> at the very instant the database server went down, I noticed the following
> in the Application Event Log:
>
> "The application , , generated an application error The error occurred on
> 1/14/2004 at 10:11:31:687 The exception
> generated was c0000005 at address77F9518B (ZwDeviceIOControlFile)"
>
> I found a similar entry in the event log at all other times the database
> server crashed.
>
>
>
> Chris Keating (iAnywhere Solutions) <FightSpam_keating@iAnywhere.com>
wrote
> in message news:4006242e@forums-1-dub...
> > Errors in an application running as a service are sent to the event
> viewer.
> > What is in the event viewer related to this service?
> > --
> >
> > 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:4005b22a@forums-1-dub...
> > > by "crashed" i meant to say that the Server simply terminated - the
> > service
> > > stopped running....the symptom is that users are unable to connect to
> the
> > > intranet wesite as the database is not running anymore
> > >
> > > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > > news:40059910$1@forums-1-dub...
> > > > As you mentioned, there is nothing in the server output that you
> posted
> > to
> > > > show that the server 'crashed'. If you have also checked the server
> > window
> > > > and seen that there are no error's there, then I start to get
confused
> > as
> > > to
> > > > what you mean when you say it 'crashed'. What are the actual
symptoms
> > you
> > > > are seeing?
> > > >
> > > > --
> > > > -----------------------------------------------
> > > > Robert Waywell
> > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > Sybase Certified Professional
> > > >
> > > > Sybase's iAnywhere Solutions
> > > >
> > > > Please respond ONLY to newsgroup
> > > >
> > > > EBF's and Patches: http://downloads.sybase.com
> > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > >
> > > > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> > > >
> > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > http://my.sybase.com/detail?id=1002288
> > > >
> > > > Whitepapers, TechDocs, and bug fixes are all available through the
> > > iAnywhere
> > > > Developer Community at www.ianywhere.com/developer
> > > >
> > > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > > news:40057369$1@forums-1-dub...
> > > > > I have an SQLAnywhere server 5.5.05 Build 2817 running on a
Windows
> > 2000
> > > > > server. Some some strange reason, the server shutdows at once a
day
> at
> > > > > different times. I do not see any error message on the screen.
Also,
> > > there
> > > > > are no error messages in the server log.
> > > > > Below is an extract of the sever log file from the end of the
file:
> > > > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > > > 10:10:57 dba:__dbx398824651229612728 connected
> > > > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > > > 10:11:31 dba:SQL_DBC_1770030 connected
> > > > >
> > > > >
> > > > > The database is used by our intranet website. It is used to
> > authenticate
> > > > > user ids and passwords. It also has data tables which contains
data
> > for
> > > > the
> > > > > reports served on the intranet.
> > > > > So it is mostly a read only database.
> > > > > Can anyone tell me why its crashing
> > > > > Thanks
> > > > > Thomas
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Thomas George Posted on 2004-01-15 16:46:47.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub> <4006242e@forums-1-dub> <4006b7a6$1@forums-2-dub> <4006bb35$1@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 1027
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: <4006c625@forums-2-dub>
X-Original-Trace: 15 Jan 2004 08:56:05 -0800, 66.243.22.98
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Jan 2004 08:31:28 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Jan 2004 08:46:47 -0800
X-Trace: forums-1-dub 1074185207 10.22.108.75 (15 Jan 2004 08:46:47 -0800)
X-Original-Trace: 15 Jan 2004 08:46:47 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2309
Article PK: 4514

thanks for your response...
dbsrv50 does not show up in the task list.
the service manager shows that the task has been stopped. Thats where i
restart the server from.
I could not connect to the database server from SQLCentral on my workstation
when the website was not letting users log in

I have attached the extract from the Dr. Watson log relating to the server
crash.
As evident from the Dr. Watson log, the error occured in dbsrv50

Thanks for your help

Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
news:4006bb35$1@forums-1-dub...
> This still doesn't point to the database server in anyway. It could be the
> database server, but at this point the problem could just as well be at
the
> application level.
>
> Have you tried connecting directly to the database from ISQL when the
> website is down?
> Does the dbsrv50 process still show in task manager when the website is
> down?
> Is there a Dr. Watson log generated?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Thomas George" <georgeth@phmns.com> wrote in message
> news:4006b7a6$1@forums-2-dub...
> > at the very instant the database server went down, I noticed the
following
> > in the Application Event Log:
> >
> > "The application , , generated an application error The error occurred
on
> > 1/14/2004 at 10:11:31:687 The exception
> > generated was c0000005 at address77F9518B (ZwDeviceIOControlFile)"
> >
> > I found a similar entry in the event log at all other times the database
> > server crashed.
> >
> >
> >
> > Chris Keating (iAnywhere Solutions) <FightSpam_keating@iAnywhere.com>
> wrote
> > in message news:4006242e@forums-1-dub...
> > > Errors in an application running as a service are sent to the event
> > viewer.
> > > What is in the event viewer related to this service?
> > > --
> > >
> > > 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:4005b22a@forums-1-dub...
> > > > by "crashed" i meant to say that the Server simply terminated - the
> > > service
> > > > stopped running....the symptom is that users are unable to connect
to
> > the
> > > > intranet wesite as the database is not running anymore
> > > >
> > > > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > > > news:40059910$1@forums-1-dub...
> > > > > As you mentioned, there is nothing in the server output that you
> > posted
> > > to
> > > > > show that the server 'crashed'. If you have also checked the
server
> > > window
> > > > > and seen that there are no error's there, then I start to get
> confused
> > > as
> > > > to
> > > > > what you mean when you say it 'crashed'. What are the actual
> symptoms
> > > you
> > > > > are seeing?
> > > > >
> > > > > --
> > > > > -----------------------------------------------
> > > > > Robert Waywell
> > > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > > Sybase Certified Professional
> > > > >
> > > > > Sybase's iAnywhere Solutions
> > > > >
> > > > > Please respond ONLY to newsgroup
> > > > >
> > > > > EBF's and Patches: http://downloads.sybase.com
> > > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > > >
> > > > > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> > > > >
> > > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > > http://my.sybase.com/detail?id=1002288
> > > > >
> > > > > Whitepapers, TechDocs, and bug fixes are all available through the
> > > > iAnywhere
> > > > > Developer Community at www.ianywhere.com/developer
> > > > >
> > > > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > > > news:40057369$1@forums-1-dub...
> > > > > > I have an SQLAnywhere server 5.5.05 Build 2817 running on a
> Windows
> > > 2000
> > > > > > server. Some some strange reason, the server shutdows at once a
> day
> > at
> > > > > > different times. I do not see any error message on the screen.
> Also,
> > > > there
> > > > > > are no error messages in the server log.
> > > > > > Below is an extract of the sever log file from the end of the
> file:
> > > > > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > > > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > > > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > > > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > > > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > > > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > > > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > > > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > > > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > > > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > > > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > > > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > > > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > > > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > > > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > > > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > > > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > > > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > > > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > > > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > > > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > > > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > > > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > > > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > > > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > > > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > > > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > > > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > > > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > > > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > > > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > > > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > > > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > > > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > > > > 10:10:57 dba:__dbx398824651229612728 connected
> > > > > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > > > > 10:11:31 dba:SQL_DBC_1770030 connected
> > > > > >
> > > > > >
> > > > > > The database is used by our intranet website. It is used to
> > > authenticate
> > > > > > user ids and passwords. It also has data tables which contains
> data
> > > for
> > > > > the
> > > > > > reports served on the intranet.
> > > > > > So it is mostly a read only database.
> > > > > > Can anyone tell me why its crashing
> > > > > > Thanks
> > > > > > Thomas
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Robert Waywell Posted on 2004-01-16 21:10:01.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub> <4006242e@forums-1-dub> <4006b7a6$1@forums-2-dub> <4006bb35$1@forums-1-dub> <4006c625@forums-2-dub>
Subject: Re: Frequent Database crashes
Lines: 300
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <40085329$1@forums-1-dub>
Date: 16 Jan 2004 13:10:01 -0800
X-Trace: forums-1-dub 1074287401 172.31.142.236 (16 Jan 2004 13:10:01 -0800)
X-Original-Trace: 16 Jan 2004 13:10:01 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2327
Article PK: 4532

Hi Thomas,
I agree that the Dr. Watson log points to dbsrv50.exe as the process in
which the exception occurred. There's always an off chance that some other
process is stomping on memory being used by dbsrv50, but the most likely
answer is a problem with the dbsrv50 itself. If you were using external
function calls, in which you coded a dll to be call from within the server,
then a bug in the external dll would show as being part of the dbsrv50
process. Since external function calls are fairly rare I'll assume that you
aren't using them.

You are already running the last ebf built for 5.5.05, at least on the
server side. As you asked in your other post, you could upgrade the clients
from 5.5.03 to 5.5.05 and the last ebf to see if it makes any difference. At
that point your next option would be to upgrade to at least 7.0.3 which is
the oldest version currently supported.


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Thomas George" <georgeth@phmns.com> wrote in message
news:4006c625@forums-2-dub...
> thanks for your response...
> dbsrv50 does not show up in the task list.
> the service manager shows that the task has been stopped. Thats where i
> restart the server from.
> I could not connect to the database server from SQLCentral on my
workstation
> when the website was not letting users log in
>
> I have attached the extract from the Dr. Watson log relating to the server
> crash.
> As evident from the Dr. Watson log, the error occured in dbsrv50
>
> Thanks for your help
>
>
>
>
>
>
> Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> news:4006bb35$1@forums-1-dub...
> > This still doesn't point to the database server in anyway. It could be
the
> > database server, but at this point the problem could just as well be at
> the
> > application level.
> >
> > Have you tried connecting directly to the database from ISQL when the
> > website is down?
> > Does the dbsrv50 process still show in task manager when the website is
> > down?
> > Is there a Dr. Watson log generated?
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Thomas George" <georgeth@phmns.com> wrote in message
> > news:4006b7a6$1@forums-2-dub...
> > > at the very instant the database server went down, I noticed the
> following
> > > in the Application Event Log:
> > >
> > > "The application , , generated an application error The error occurred
> on
> > > 1/14/2004 at 10:11:31:687 The exception
> > > generated was c0000005 at address77F9518B (ZwDeviceIOControlFile)"
> > >
> > > I found a similar entry in the event log at all other times the
database
> > > server crashed.
> > >
> > >
> > >
> > > Chris Keating (iAnywhere Solutions) <FightSpam_keating@iAnywhere.com>
> > wrote
> > > in message news:4006242e@forums-1-dub...
> > > > Errors in an application running as a service are sent to the event
> > > viewer.
> > > > What is in the event viewer related to this service?
> > > > --
> > > >
> > > > 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:4005b22a@forums-1-dub...
> > > > > by "crashed" i meant to say that the Server simply terminated -
the
> > > > service
> > > > > stopped running....the symptom is that users are unable to connect
> to
> > > the
> > > > > intranet wesite as the database is not running anymore
> > > > >
> > > > > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > > > > news:40059910$1@forums-1-dub...
> > > > > > As you mentioned, there is nothing in the server output that you
> > > posted
> > > > to
> > > > > > show that the server 'crashed'. If you have also checked the
> server
> > > > window
> > > > > > and seen that there are no error's there, then I start to get
> > confused
> > > > as
> > > > > to
> > > > > > what you mean when you say it 'crashed'. What are the actual
> > symptoms
> > > > you
> > > > > > are seeing?
> > > > > >
> > > > > > --
> > > > > > -----------------------------------------------
> > > > > > Robert Waywell
> > > > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > > > Sybase Certified Professional
> > > > > >
> > > > > > Sybase's iAnywhere Solutions
> > > > > >
> > > > > > Please respond ONLY to newsgroup
> > > > > >
> > > > > > EBF's and Patches: http://downloads.sybase.com
> > > > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > > > >
> > > > > > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> > > > > >
> > > > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > > > http://my.sybase.com/detail?id=1002288
> > > > > >
> > > > > > Whitepapers, TechDocs, and bug fixes are all available through
the
> > > > > iAnywhere
> > > > > > Developer Community at www.ianywhere.com/developer
> > > > > >
> > > > > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > > > > news:40057369$1@forums-1-dub...
> > > > > > > I have an SQLAnywhere server 5.5.05 Build 2817 running on a
> > Windows
> > > > 2000
> > > > > > > server. Some some strange reason, the server shutdows at once
a
> > day
> > > at
> > > > > > > different times. I do not see any error message on the screen.
> > Also,
> > > > > there
> > > > > > > are no error messages in the server log.
> > > > > > > Below is an extract of the sever log file from the end of the
> > file:
> > > > > > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > > > > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > > > > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > > > > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > > > > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > > > > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > > > > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > > > > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > > > > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > > > > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > > > > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > > > > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > > > > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > > > > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > > > > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > > > > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > > > > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > > > > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > > > > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > > > > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > > > > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > > > > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > > > > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > > > > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > > > > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > > > > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > > > > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > > > > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > > > > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > > > > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > > > > > 10:10:57 dba:__dbx398824651229612728 connected
> > > > > > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > > > > > 10:11:31 dba:SQL_DBC_1770030 connected
> > > > > > >
> > > > > > >
> > > > > > > The database is used by our intranet website. It is used to
> > > > authenticate
> > > > > > > user ids and passwords. It also has data tables which contains
> > data
> > > > for
> > > > > > the
> > > > > > > reports served on the intranet.
> > > > > > > So it is mostly a read only database.
> > > > > > > Can anyone tell me why its crashing
> > > > > > > Thanks
> > > > > > > Thomas
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>


Thomas George Posted on 2004-01-16 22:14:28.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub> <4006242e@forums-1-dub> <4006b7a6$1@forums-2-dub> <4006bb35$1@forums-1-dub> <4006c625@forums-2-dub> <40085329$1@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 348
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: <40086478$1@forums-2-dub>
X-Original-Trace: 16 Jan 2004 14:23:52 -0800, 66.243.22.98
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Jan 2004 13:59:04 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Jan 2004 14:14:28 -0800
X-Trace: forums-1-dub 1074291268 10.22.108.75 (16 Jan 2004 14:14:28 -0800)
X-Original-Trace: 16 Jan 2004 14:14:28 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2328
Article PK: 4533

Robert,
Thank you for your response.
As you rightly guessed, I am not using any external procedures (dlls). Also,
I upgraded dbclient to 5.5.05 #2817 but got the same situation this morning
( server crashed and got similar entry in the dr watson log)
In fact we have been facing this problem since Sep 15 of last year. I
thought that changing operating systems might solve the problem. So I
migrated the database from WinNT to a new Win2000 machine on Jan 2 of this
year. I also recreated the database before moving to Win2K by unloading the
database and re-loading it into the new database.
The database size is about 1.5 GB and some of the stored procedures used by
the website reports contain close to 100 variables, use several temporary
tables, call aggregate functions etc.

How do I go about upgrading to 7.0.3?
Thanks
Thomas

Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
news:40085329$1@forums-1-dub...
> Hi Thomas,
> I agree that the Dr. Watson log points to dbsrv50.exe as the process
in
> which the exception occurred. There's always an off chance that some other
> process is stomping on memory being used by dbsrv50, but the most likely
> answer is a problem with the dbsrv50 itself. If you were using external
> function calls, in which you coded a dll to be call from within the
server,
> then a bug in the external dll would show as being part of the dbsrv50
> process. Since external function calls are fairly rare I'll assume that
you
> aren't using them.
>
> You are already running the last ebf built for 5.5.05, at least on the
> server side. As you asked in your other post, you could upgrade the
clients
> from 5.5.03 to 5.5.05 and the last ebf to see if it makes any difference.
At
> that point your next option would be to upgrade to at least 7.0.3 which is
> the oldest version currently supported.
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Thomas George" <georgeth@phmns.com> wrote in message
> news:4006c625@forums-2-dub...
> > thanks for your response...
> > dbsrv50 does not show up in the task list.
> > the service manager shows that the task has been stopped. Thats where i
> > restart the server from.
> > I could not connect to the database server from SQLCentral on my
> workstation
> > when the website was not letting users log in
> >
> > I have attached the extract from the Dr. Watson log relating to the
server
> > crash.
> > As evident from the Dr. Watson log, the error occured in dbsrv50
> >
> > Thanks for your help
> >
> >
> >
> >
> >
> >
> > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > news:4006bb35$1@forums-1-dub...
> > > This still doesn't point to the database server in anyway. It could be
> the
> > > database server, but at this point the problem could just as well be
at
> > the
> > > application level.
> > >
> > > Have you tried connecting directly to the database from ISQL when the
> > > website is down?
> > > Does the dbsrv50 process still show in task manager when the website
is
> > > down?
> > > Is there a Dr. Watson log generated?
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to all
> > >
> > > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> > >
> > > SQL Anywhere Studio Supported Platforms and Support Status
> > > http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > news:4006b7a6$1@forums-2-dub...
> > > > at the very instant the database server went down, I noticed the
> > following
> > > > in the Application Event Log:
> > > >
> > > > "The application , , generated an application error The error
occurred
> > on
> > > > 1/14/2004 at 10:11:31:687 The exception
> > > > generated was c0000005 at address77F9518B (ZwDeviceIOControlFile)"
> > > >
> > > > I found a similar entry in the event log at all other times the
> database
> > > > server crashed.
> > > >
> > > >
> > > >
> > > > Chris Keating (iAnywhere Solutions)
<FightSpam_keating@iAnywhere.com>
> > > wrote
> > > > in message news:4006242e@forums-1-dub...
> > > > > Errors in an application running as a service are sent to the
event
> > > > viewer.
> > > > > What is in the event viewer related to this service?
> > > > > --
> > > > >
> > > > > 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:4005b22a@forums-1-dub...
> > > > > > by "crashed" i meant to say that the Server simply terminated -
> the
> > > > > service
> > > > > > stopped running....the symptom is that users are unable to
connect
> > to
> > > > the
> > > > > > intranet wesite as the database is not running anymore
> > > > > >
> > > > > > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > > > > > news:40059910$1@forums-1-dub...
> > > > > > > As you mentioned, there is nothing in the server output that
you
> > > > posted
> > > > > to
> > > > > > > show that the server 'crashed'. If you have also checked the
> > server
> > > > > window
> > > > > > > and seen that there are no error's there, then I start to get
> > > confused
> > > > > as
> > > > > > to
> > > > > > > what you mean when you say it 'crashed'. What are the actual
> > > symptoms
> > > > > you
> > > > > > > are seeing?
> > > > > > >
> > > > > > > --
> > > > > > > -----------------------------------------------
> > > > > > > Robert Waywell
> > > > > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > > > > Sybase Certified Professional
> > > > > > >
> > > > > > > Sybase's iAnywhere Solutions
> > > > > > >
> > > > > > > Please respond ONLY to newsgroup
> > > > > > >
> > > > > > > EBF's and Patches: http://downloads.sybase.com
> > > > > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > > > > >
> > > > > > > To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm
> > > > > > >
> > > > > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > > > > http://my.sybase.com/detail?id=1002288
> > > > > > >
> > > > > > > Whitepapers, TechDocs, and bug fixes are all available through
> the
> > > > > > iAnywhere
> > > > > > > Developer Community at www.ianywhere.com/developer
> > > > > > >
> > > > > > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > > > > > news:40057369$1@forums-1-dub...
> > > > > > > > I have an SQLAnywhere server 5.5.05 Build 2817 running on a
> > > Windows
> > > > > 2000
> > > > > > > > server. Some some strange reason, the server shutdows at
once
> a
> > > day
> > > > at
> > > > > > > > different times. I do not see any error message on the
screen.
> > > Also,
> > > > > > there
> > > > > > > > are no error messages in the server log.
> > > > > > > > Below is an extract of the sever log file from the end of
the
> > > file:
> > > > > > > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > > > > > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > > > > > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > > > > > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > > > > > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > > > > > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > > > > > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > > > > > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > > > > > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > > > > > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > > > > > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > > > > > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > > > > > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > > > > > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > > > > > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > > > > > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > > > > > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > > > > > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > > > > > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > > > > > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > > > > > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > > > > > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > > > > > > 10:10:57 dba:__dbx398824651229612728 connected
> > > > > > > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > > > > > > 10:11:31 dba:SQL_DBC_1770030 connected
> > > > > > > >
> > > > > > > >
> > > > > > > > The database is used by our intranet website. It is used to
> > > > > authenticate
> > > > > > > > user ids and passwords. It also has data tables which
contains
> > > data
> > > > > for
> > > > > > > the
> > > > > > > > reports served on the intranet.
> > > > > > > > So it is mostly a read only database.
> > > > > > > > Can anyone tell me why its crashing
> > > > > > > > Thanks
> > > > > > > > Thomas
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>


Robert Waywell Posted on 2004-01-19 15:37:00.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub> <4005b22a@forums-1-dub> <4006242e@forums-1-dub> <4006b7a6$1@forums-2-dub> <4006bb35$1@forums-1-dub> <4006c625@forums-2-dub> <40085329$1@forums-1-dub> <40086478$1@forums-2-dub>
Subject: Re: Frequent Database crashes
Lines: 407
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <400bf99c@forums-1-dub>
Date: 19 Jan 2004 07:37:00 -0800
X-Trace: forums-1-dub 1074526620 172.31.142.236 (19 Jan 2004 07:37:00 -0800)
X-Original-Trace: 19 Jan 2004 07:37:00 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2344
Article PK: 4549

As a starting point I would suggest downloading the 9.0 Developer Edition
from: http://www.ianywhere.com/products/sql_anywhere.html

In the documentation, take a look at the section "What's New in SQL
Anywhere Studio". The chapter on "Upgrading Version 5 Applications" will
cover the changes in the client-server communications but you will also want
to review the other behaviour changes.

9.x is the current version and given the size of the jump from 5.5.05 to
7.0.3 anyway, you will likely be just as well off going all the way to 9.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Thomas George" <georgeth@phmns.com> wrote in message
news:40086478$1@forums-2-dub...
> Robert,
> Thank you for your response.
> As you rightly guessed, I am not using any external procedures (dlls).
Also,
> I upgraded dbclient to 5.5.05 #2817 but got the same situation this
morning
> ( server crashed and got similar entry in the dr watson log)
> In fact we have been facing this problem since Sep 15 of last year. I
> thought that changing operating systems might solve the problem. So I
> migrated the database from WinNT to a new Win2000 machine on Jan 2 of this
> year. I also recreated the database before moving to Win2K by unloading
the
> database and re-loading it into the new database.
> The database size is about 1.5 GB and some of the stored procedures used
by
> the website reports contain close to 100 variables, use several temporary
> tables, call aggregate functions etc.
>
> How do I go about upgrading to 7.0.3?
> Thanks
> Thomas
>
>
>
>
>
> Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> news:40085329$1@forums-1-dub...
> > Hi Thomas,
> > I agree that the Dr. Watson log points to dbsrv50.exe as the process
> in
> > which the exception occurred. There's always an off chance that some
other
> > process is stomping on memory being used by dbsrv50, but the most likely
> > answer is a problem with the dbsrv50 itself. If you were using external
> > function calls, in which you coded a dll to be call from within the
> server,
> > then a bug in the external dll would show as being part of the dbsrv50
> > process. Since external function calls are fairly rare I'll assume that
> you
> > aren't using them.
> >
> > You are already running the last ebf built for 5.5.05, at least on
the
> > server side. As you asked in your other post, you could upgrade the
> clients
> > from 5.5.03 to 5.5.05 and the last ebf to see if it makes any
difference.
> At
> > that point your next option would be to upgrade to at least 7.0.3 which
is
> > the oldest version currently supported.
> >
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Thomas George" <georgeth@phmns.com> wrote in message
> > news:4006c625@forums-2-dub...
> > > thanks for your response...
> > > dbsrv50 does not show up in the task list.
> > > the service manager shows that the task has been stopped. Thats where
i
> > > restart the server from.
> > > I could not connect to the database server from SQLCentral on my
> > workstation
> > > when the website was not letting users log in
> > >
> > > I have attached the extract from the Dr. Watson log relating to the
> server
> > > crash.
> > > As evident from the Dr. Watson log, the error occured in dbsrv50
> > >
> > > Thanks for your help
> > >
> > >
> > >
> > >
> > >
> > >
> > > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
> > > news:4006bb35$1@forums-1-dub...
> > > > This still doesn't point to the database server in anyway. It could
be
> > the
> > > > database server, but at this point the problem could just as well be
> at
> > > the
> > > > application level.
> > > >
> > > > Have you tried connecting directly to the database from ISQL when
the
> > > > website is down?
> > > > Does the dbsrv50 process still show in task manager when the website
> is
> > > > down?
> > > > Is there a Dr. Watson log generated?
> > > >
> > > > --
> > > > -----------------------------------------------
> > > > Robert Waywell
> > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > Sybase Certified Professional
> > > >
> > > > Sybase's iAnywhere Solutions
> > > >
> > > > Please respond ONLY to newsgroup
> > > >
> > > > EBF's and Patches: http://downloads.sybase.com
> > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > >
> > > > To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
> > > >
> > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > http://my.sybase.com/detail?id=1002288
> > > >
> > > > Whitepapers, TechDocs, and bug fixes are all available through the
> > > iAnywhere
> > > > Developer Community at www.ianywhere.com/developer
> > > >
> > > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > > news:4006b7a6$1@forums-2-dub...
> > > > > at the very instant the database server went down, I noticed the
> > > following
> > > > > in the Application Event Log:
> > > > >
> > > > > "The application , , generated an application error The error
> occurred
> > > on
> > > > > 1/14/2004 at 10:11:31:687 The exception
> > > > > generated was c0000005 at address77F9518B (ZwDeviceIOControlFile)"
> > > > >
> > > > > I found a similar entry in the event log at all other times the
> > database
> > > > > server crashed.
> > > > >
> > > > >
> > > > >
> > > > > Chris Keating (iAnywhere Solutions)
> <FightSpam_keating@iAnywhere.com>
> > > > wrote
> > > > > in message news:4006242e@forums-1-dub...
> > > > > > Errors in an application running as a service are sent to the
> event
> > > > > viewer.
> > > > > > What is in the event viewer related to this service?
> > > > > > --
> > > > > >
> > > > > > 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:4005b22a@forums-1-dub...
> > > > > > > by "crashed" i meant to say that the Server simply
terminated -
> > the
> > > > > > service
> > > > > > > stopped running....the symptom is that users are unable to
> connect
> > > to
> > > > > the
> > > > > > > intranet wesite as the database is not running anymore
> > > > > > >
> > > > > > > Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in
message
> > > > > > > news:40059910$1@forums-1-dub...
> > > > > > > > As you mentioned, there is nothing in the server output that
> you
> > > > > posted
> > > > > > to
> > > > > > > > show that the server 'crashed'. If you have also checked the
> > > server
> > > > > > window
> > > > > > > > and seen that there are no error's there, then I start to
get
> > > > confused
> > > > > > as
> > > > > > > to
> > > > > > > > what you mean when you say it 'crashed'. What are the actual
> > > > symptoms
> > > > > > you
> > > > > > > > are seeing?
> > > > > > > >
> > > > > > > > --
> > > > > > > > -----------------------------------------------
> > > > > > > > Robert Waywell
> > > > > > > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > > > > > > Sybase Certified Professional
> > > > > > > >
> > > > > > > > Sybase's iAnywhere Solutions
> > > > > > > >
> > > > > > > > Please respond ONLY to newsgroup
> > > > > > > >
> > > > > > > > EBF's and Patches: http://downloads.sybase.com
> > > > > > > > choose SQL Anywhere Studio >> change 'time frame' to all
> > > > > > > >
> > > > > > > > To Submit Bug Reports:
> http://case-express.sybase.com/cx/cx.stm
> > > > > > > >
> > > > > > > > SQL Anywhere Studio Supported Platforms and Support Status
> > > > > > > > http://my.sybase.com/detail?id=1002288
> > > > > > > >
> > > > > > > > Whitepapers, TechDocs, and bug fixes are all available
through
> > the
> > > > > > > iAnywhere
> > > > > > > > Developer Community at www.ianywhere.com/developer
> > > > > > > >
> > > > > > > > "Thomas George" <georgeth@phmns.com> wrote in message
> > > > > > > > news:40057369$1@forums-1-dub...
> > > > > > > > > I have an SQLAnywhere server 5.5.05 Build 2817 running on
a
> > > > Windows
> > > > > > 2000
> > > > > > > > > server. Some some strange reason, the server shutdows at
> once
> > a
> > > > day
> > > > > at
> > > > > > > > > different times. I do not see any error message on the
> screen.
> > > > Also,
> > > > > > > there
> > > > > > > > > are no error messages in the server log.
> > > > > > > > > Below is an extract of the sever log file from the end of
> the
> > > > file:
> > > > > > > > > 09:15:31 dba:SQL_DBC_1770218 connected
> > > > > > > > > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > > > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:19:23 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:19:23 dba:SQL_DBC_1770218 connected
> > > > > > > > > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > > > > > > > > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:21:09 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:21:10 dba:SQL_DBC_1771738 connected
> > > > > > > > > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > > > > > > > > 09:27:39 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:27:39 dba:SQL_DBC_1770218 connected
> > > > > > > > > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > > > 09:40:35 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:40:36 dba:SQL_DBC_1770218 connected
> > > > > > > > > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > > > > > > > > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:44:12 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:44:23 dba:SQL_DBC_1770218 connected
> > > > > > > > > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > > > > > > > > 09:45:45 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > > > > > > > > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > > > > > > > > 09:49:46 dba:SQL_DBC_773e40 connected
> > > > > > > > > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > > > > > > > > 09:54:36 dba:SQL_DBC_773e40 connected
> > > > > > > > > 09:55:04 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > > > > > > > > 09:57:57 dba:SQL_DBC_1770030 connected
> > > > > > > > > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 10:02:08 dba:SQL_DBC_773e40 connected
> > > > > > > > > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > > > > > > > > 10:07:11 dba:SQL_DBC_773e40 connected
> > > > > > > > > 10:07:11 dba:SQL_DBC_1770030 connected
> > > > > > > > > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > > > > > > > > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > > > > > > > > 10:10:57 dba:__dbx398824651229612728 connected
> > > > > > > > > 10:11:29 dba:SQL_DBC_773e40 connected
> > > > > > > > > 10:11:31 dba:SQL_DBC_1770030 connected
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > The database is used by our intranet website. It is used
to
> > > > > > authenticate
> > > > > > > > > user ids and passwords. It also has data tables which
> contains
> > > > data
> > > > > > for
> > > > > > > > the
> > > > > > > > > reports served on the intranet.
> > > > > > > > > So it is mostly a read only database.
> > > > > > > > > Can anyone tell me why its crashing
> > > > > > > > > Thanks
> > > > > > > > > Thomas
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>


Thomas George Posted on 2004-01-14 21:20:09.0Z
From: "Thomas George" <georgeth@phmns.com>
Newsgroups: ianywhere.public.general
References: <40057369$1@forums-1-dub> <40059910$1@forums-1-dub>
Subject: Re: Frequent Database crashes
Lines: 104
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
NNTP-Posting-Host: 66.243.22.98
X-Original-NNTP-Posting-Host: 66.243.22.98
Message-ID: <4005b289$1@forums-1-dub>
Date: 14 Jan 2004 13:20:09 -0800
X-Trace: forums-1-dub 1074115209 66.243.22.98 (14 Jan 2004 13:20:09 -0800)
X-Original-Trace: 14 Jan 2004 13:20:09 -0800, 66.243.22.98
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2297
Article PK: 4502

and I end up having to restart the service ..the server them comes up and
gets into recovery mode before it again starts
accepting requests

Robert Waywell <nospam_rwaywell@ianywhere.com> wrote in message
news:40059910$1@forums-1-dub...
> As you mentioned, there is nothing in the server output that you posted to
> show that the server 'crashed'. If you have also checked the server window
> and seen that there are no error's there, then I start to get confused as
to
> what you mean when you say it 'crashed'. What are the actual symptoms you
> are seeing?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://case-express.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Thomas George" <georgeth@phmns.com> wrote in message
> news:40057369$1@forums-1-dub...
> > I have an SQLAnywhere server 5.5.05 Build 2817 running on a Windows 2000
> > server. Some some strange reason, the server shutdows at once a day at
> > different times. I do not see any error message on the screen. Also,
there
> > are no error messages in the server log.
> > Below is an extract of the sever log file from the end of the file:
> > 09:15:31 dba:SQL_DBC_1770218 connected
> > 09:16:39 dba:SQL_DBC_1770218 disconnected
> > 09:16:39 dba:SQL_DBC_1770030 disconnected
> > 09:19:23 dba:SQL_DBC_1770030 connected
> > 09:19:23 dba:SQL_DBC_1770218 connected
> > 09:20:29 dba:SQL_DBC_1770218 disconnected
> > 09:21:09 dba:SQL_DBC_1770030 disconnected
> > 09:21:09 dba:SQL_DBC_1770030 connected
> > 09:21:10 dba:SQL_DBC_1771738 connected
> > 09:22:39 dba:SQL_DBC_1770030 disconnected
> > 09:22:49 dba:SQL_DBC_1771738 disconnected
> > 09:27:39 dba:SQL_DBC_1770030 connected
> > 09:27:39 dba:SQL_DBC_1770218 connected
> > 09:28:39 dba:SQL_DBC_1770030 disconnected
> > 09:28:39 dba:SQL_DBC_1770218 disconnected
> > 09:40:35 dba:SQL_DBC_1770030 connected
> > 09:40:36 dba:SQL_DBC_1770218 connected
> > 09:42:49 dba:SQL_DBC_1770218 disconnected
> > 09:43:09 dba:SQL_DBC_1770030 disconnected
> > 09:44:12 dba:SQL_DBC_1770030 connected
> > 09:44:23 dba:SQL_DBC_1770218 connected
> > 09:45:19 dba:SQL_DBC_1770030 disconnected
> > 09:45:39 dba:SQL_DBC_1770218 disconnected
> > 09:45:45 dba:SQL_DBC_1770030 connected
> > 09:46:49 dba:SQL_DBC_1770030 disconnected
> > 09:48:00 Starting checkpoint: Wed Jan 14 2004 09:48
> > 09:48:00 Finished checkpoint: Wed Jan 14 2004 09:48
> > 09:49:46 dba:SQL_DBC_773e40 connected
> > 09:50:49 dba:SQL_DBC_773e40 disconnected
> > 09:54:36 dba:SQL_DBC_773e40 connected
> > 09:55:04 dba:SQL_DBC_1770030 connected
> > 09:57:09 dba:SQL_DBC_1770030 disconnected
> > 09:57:09 dba:SQL_DBC_773e40 disconnected
> > 09:57:57 dba:SQL_DBC_1770030 connected
> > 09:58:59 dba:SQL_DBC_1770030 disconnected
> > 10:02:08 dba:SQL_DBC_773e40 connected
> > 10:03:19 dba:SQL_DBC_773e40 disconnected
> > 10:07:11 dba:SQL_DBC_773e40 connected
> > 10:07:11 dba:SQL_DBC_1770030 connected
> > 10:09:19 dba:SQL_DBC_1770030 disconnected
> > 10:09:39 dba:SQL_DBC_773e40 disconnected
> > 10:10:57 dba:__dbx398824651229612728 connected
> > 10:11:29 dba:SQL_DBC_773e40 connected
> > 10:11:31 dba:SQL_DBC_1770030 connected
> >
> >
> > The database is used by our intranet website. It is used to authenticate
> > user ids and passwords. It also has data tables which contains data for
> the
> > reports served on the intranet.
> > So it is mostly a read only database.
> > Can anyone tell me why its crashing
> > Thanks
> > Thomas
> >
> >
> >
>
>