Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

SQL 6.5 Error : 17832, Severity: 18, State: 0 Database keeps shutting down.

Our job ticket application uses SQL 6.5
After reboot everthing is fine for a few minutes.
After I reboot I can go to Enterprise Manger and look at the log:
It reads as follows:
Lots of startup and rebuild stuff
than
Launched startup procedure 'sp_sqlregistered'
Error : 17832, Severity: 18, State: 0
Unable to read login packet(s).

this repeats multiple times

than

EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump
intializing symptom dump and stack dump facilities
***BEGIN STACK TRACE****


How do I do a DB CheckDB?
or
What should I be doing?

Thanks in advance
scangroup
0
scangroup
Asked:
scangroup
  • 9
  • 5
  • 2
1 Solution
 
Atlanta_MikeCommented:
Wow, it's been many years since I've looked at 6.5. I dont' remember if DBCC checkdb existed for 6.5.

Why are you still using 6.5? Licensing, Application requirements?

Can you upgrade? Would it be possible to upgrade to SQL Express 2005? It's free.
0
 
Atlanta_MikeCommented:
Shoot, I even disposed of my 6.5 CD or I could have checked out the help.
0
 
scangroupAuthor Commented:
Wow Mike
Have you ever heard of the saying if it isn't broke don't fix it.
Thanks for the help
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
scangroupAuthor Commented:
Something is causing the SQL service to stop.
Is it possible for someone to stop my service remotely?
Could someone do that via the internet?
I will disable internet for a while to test.
0
 
Atlanta_MikeCommented:
Well... sometimes... you have to protect your assets by upgrading to a supported version. :-)

Besides, 6.5 was a complete pain to work with. 7.0 was such an improvement in management it was a dream compared. The performance improvements from 7 to 2000 and then 2005 have been well worth the risk.

I doubt it is someone remotely stopping the service. It's more likely the server is hitting an error causing the service to stop. Is there nothing in the event log describing an error?

0
 
Atlanta_MikeCommented:
I'll see if I can locate a copy of 6.5, but my guess is its long gone. I've tried to locate a copy of 6.5 books online, but haven't had any luck.

What changes have been made to the database or the server lately? This issue usually occurs when a patch is installed on the OS or SQL Sever. And since there haven't been any SPs for 6.5, it has to be related to the OS, or installed software on the server.

How big are the datafiles?
0
 
scangroupAuthor Commented:
No changes as of late.
I do have a 6.5 book.
I just realized I was typing it in wrong!
Was typing "DB CheckDB"
Now typing "DBCC CheckDB"
Really pounding the hard drive

Should I doing this in single user mode?
I do not rember how?


Data file 3.5 GB
Log file 250 MB
0
 
Atlanta_MikeCommented:
You can run it at anytime in 7.0 and above... not sure about 6.5

Wow, 3.5 GB. That's huge for 6.5. How much of that is dataspace?

0
 
scangroupAuthor Commented:
Database Size 3500MB
Data space available 145MB

Log Size 200MB
Log space available 200MB

DBCC CheckDB has been running for about 45 minutes now?
Service has not shut down while running the CheckDB
Server is very sluggish and hard drives are pounding.
I have also disabled internet access to this compluter, still wondering if someone was able to f with me and shut my SQL service down.
0
 
scangroupAuthor Commented:
Is there anything else I should run after the DBCC CheckDB ?
0
 
Atlanta_MikeCommented:
I hope that most of your users have gone home.... this is going to take awhile.

I highly recommend upgrading to at least 2000, although 2005 has some great new features.

3.5 gig is a lot for 6.5.
0
 
Atlanta_MikeCommented:
EXCEPTION_ACCESS_VIOLATION is rarely an issue with the database. It's usually a conflict with the operating system or another program. I've seen it where it was the SQL Server, but a service pack was usually the solution.

This is kind of a silly question, but are you on the latest service pack for 6.5?
0
 
imran_fastCommented:
Try increasing RAM


run this statement and it will take time
DBCC CHECKDB ('master', REPAIR_FAST)
GO
0
 
Atlanta_MikeCommented:
He already ran DBCC CHECKDB
0
 
imran_fastCommented:
Yeah but did he run it with repair fast option.
0
 
Atlanta_MikeCommented:
Scan when you ran DBCC, did it come up with any issues? I assume since it wasn't stated in the thread, that everything came out ok. If so, no need to run repair fast.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 9
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now