Message-ID: <30E7B49F378ED711AC0F00E02917CD8B10E6A8@POLLY> From: Vilmos Branyik <email@example.com> Subject: RE: [Emerald] Call online Date: Tue, 3 Feb 2004 16:25:25 -0700
Thanks for the link. I had already found that.
I have been able to truncate my database and at least have some room. I'm
trying to delete old call records and cannot do so. I've tried using the
Emerald Maint function and running an SQL query. Neither works.
I see this error in the logs:
RA_AsyncReadioComplete: Operating system error 23 (Data error (cyclic
redundancy check)) encountered
RS_Service_IO [Bucket: 0][slot 5]; Process 5 generated access violation; SQL
server is terminating this process
Then I go right back to the bufwait timout errors
I can find the locking SPID and kill the process but that doesn't seem to
The only thing I found regarding this in a Google search was a link to a
question in the Emerald mailing list that appears to be unanswered.
Any suggestions on where to look?
> -----Original Message-----
> From: Glen Harvy [mailto:firstname.lastname@example.org]
> Sent: Monday, February 02, 2004 8:05 PM
> To: email@example.com
> Subject: RE: [Emerald] Call online
> Importance: High
> Detailed help is at:-
> Glen Harvy
> Aquarius Communications
> for all your Internet Needs.
> Phone 9977 3788 Fax 9977 3844
> > -----Original Message-----
> > From: firstname.lastname@example.org
> > [mailto:email@example.com]On Behalf Of Vilmos Branyik
> > Sent: Tuesday, 3 February 2004 12:35
> > To: 'firstname.lastname@example.org'
> > Subject: [Emerald] Call online
> > I'm running Emerald 2.5.342 with SQL 6.5.
> > My database quit responding this afternoon and quit authenticating.
> > It looks like it's because my error log is filling up. When
> I look in the
> > error logs they are filing up which is why I think the service died.
> > I see a bunch of errors beginning with:
> > bufwait timeout: BUF_IO
> > Following that:
> > Error: 17824
> > Unable to write to ListenOn connection
> "\\...\pipe\sql\guery, Loginname
> > 'sa', hostname"
> > OS Error: 232, the pipe is being closed
> > Error: 1608, Severity 21, state 2
> > I can't run database maint from the Emerald Administrator.
> It asks me to
> > truncate the log file then just freezes.
> > I ran dbcc checkdb and it completes but doesn't help.
> > I cannot trim my call online.
> > The system is not updating the on-line users so even if
> someone logs off
> > they still show on and cannot log on again. Everyone else can still
> > authenticate but do not show up on the on-line view when they do.
> > I can't seem to find anything in the archives.
> > Can someone point me in the right direction?
> > Thanks,
> > Matt Branyik
> > www.piopc.net