Solved

Assertion Error Sybase Adaptive Server Anywhere

Posted on 2004-10-06
8
1,292 Views
Last Modified: 2010-05-19

Does anyone know what causes a Sybase Adaptive Server Anywhwere Database version 8.02 to stop servicing all
odbc requests and produce a select error s1000 Internal database error assertion failed 200601 (8.0.2.4322) Page for requested record not a table page or record not present on page. The dbase continues to run and if a run a validation on the databse it returns ok.

I have 10 + ODBC connections to this database. I use task scheduler to run the dbbackup application every 10 minutes on the database. The crash occurs both during the dbbackup and inbetween so I feel it is not related.

Jim



0
Comment
Question by:Jffishbones
  • 4
  • 4
8 Comments
 
LVL 19

Expert Comment

by:grant300
ID: 12242956
Why are you running the dbbackup app every ten minutes?  If you are maintaining the transaction logs correctly, you can use the last full backup and the log to get up-to-the-second recovery and you aren't beating the snot out of the system every 10..

Bill
0
 

Author Comment

by:Jffishbones
ID: 12247242
Bill

My environment requires a recovery process with a database that is out of date almost immediately which is why I backup everything
every 10 minutes. Are you saying that I can just backup the transaction log and not the entire dbase every 10 minutes. Just backup the dbase say once a day on off hours. If so what is the best way to do this? I thought the transaction log writes back to the database at configurable times? If so the database would be out of date every time this write back occurs? Thanks for any help.

Jim
0
 
LVL 19

Expert Comment

by:grant300
ID: 12250245
Tell me about your recovery requirements.
- Are you protecting the system against disk/system failure?
- Are you worried about complete system loss (disaster recovery)?
- Is the application so unstable that it sometimes corrupts things to the point you just want to recover the last valid state?

If you are worried about disk failure, you can do a nightly full backup, create transaction log(s) large enough to handle a complete days worth of work, and mirror the logs on two physical devices.  You get up-to-the second recovery and only have to backup the system once a day.  This is how banks and every other organizations who can't afford to loose any data setup their systems.

Disaster recovery is generally not expected to operate up-to-the-minute unless you are a very large organization with at least two physical sites and can afford the network bandwidth to either replicate the database or use high-end storage arrays that replicate writes remotely.  Doesn't sound like your situation.

Application corruption is a whole different kettle of fish.  The obvious solution here is to fix the application.  If you do not have control of the application or cannot convince the powers that be to fix the sucker, then your technology solution is to use a storage array or filer that alllows you to take regular snapshots.  If/when things get screwed up, you can simply recover the storage array or filer to the last snapshot that was O.K. and pick up from there.

Hope that helps,
Bill
0
 

Author Comment

by:Jffishbones
ID: 12269986
Bill

Recently we had our transaction log file get corrupt, we lost the database.
I am trying to prevent this from happening again. I know asa does not have real time replication so I came up with backing
up the datbase regularly as a solution using the dbbackup application.

My goal it to be able to recover from the last stable state. The database is mission critical, if it is down more than 2 hours it could cost big bucks in fines from our customer. I am looking for the best solution to be able to recover the database from it's most current stable state.

Thanks again.

Jim
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 19

Expert Comment

by:grant300
ID: 12273815
Well, we have a couple of issues here.

1)  How and why did the transaction log file get corrupted?  Was it a bad sector on the disk, or did something happen programatically with the database?

2)  You have to come up with a system that is architected adequately for your mission critical service level requirements.

I don't have enough information to address item 1 but it does need to be addressed.

I have some thoughts on item 2.

In order to meet enterprise grade service level agreements you have to have the proper hardware and software environment.  There is no way to cheap out here and be succesful.  How big is the database and how many simultaneous users are there?  It may be you have simply outgrown ASA and should consider moving to ASE.

Even if you stay with ASA, there are two areas you can shore up.  The first is to do periodic backups of the LOG, rather than the whole database.  Less load on the system and less likely to cause probelms by itself.  The other is to look at some enterprise grade disk technology.  Look at something like a NETAPP filer.  It (and some similar products) has all kinds neat software inside that can do things like take regular snapshots of the filesystem.  You could set it up to take a snapshot every 10 to 30 minutes.  It really just keeps track of the changed sectors since the last snapshot.  The other slick thing about it is that you can rollback to a snapshot very quickly.  It sounds as if that would address your issues in a bullet-proof way.

Another step I would take soon is to upgrade to a newer release of ASA.  9.0.1 is current and the 10 User Server Upgrade cost is only $499.

Bill.
0
 

Author Comment

by:Jffishbones
ID: 12296535

Not sure how the transaction log got corrupt. Database would just not open.

Item 2 - we have redundant database servers but the powers to be will not spend the money for MS sql for real time replication so I am
trying to find the best way to recover from either a database or server failure.

Jim
0
 
LVL 19

Accepted Solution

by:
grant300 earned 500 total points
ID: 12309239
I think you are just hosed.  You can't meet contractually-specified Service Level Agreements just by wishing (or in this case, badgering the poor system admin).  Clearly they are trying to wring every last penny out of whatever this business deal is and don't care to "do it right".

Realistically, your only choice is to:
1) document the problems with the existing setup
2) make recommendations on one or more solutions
3) get/make some estimates on the cost of those solutions
4) quantify the cost of downtime and or needless disaster recovery
5) hope that an obvious cost-benefit analysis will open their eyes.
6) if it doesn't, look for a job that does not involve working for in-duh-viduals.

Even if you are sure they won't be swayed by your arguments, you have built an airtight cover for your ass when they finally have a major outage.

TANSTAFL  (There Ain't No Such Thing As a Free Lunch)
0
 

Author Comment

by:Jffishbones
ID: 12333113
I agree Thansk, I am opening anther question on live dbbackup / recovery.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We need a new way to communicate time sensitive or critical info.   The best part of my role at xMatters is visiting our clients all over the world to learn about how they operate their businesses, share insights that xMatters has gleaned across…
A customer recently asked me about anti-malware and the different deployment options available for his business. Daily news about cyberattacks, zero-day vulnerabilities, and companies that suffered a security breach made him wonder if the endpoint a…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now