Solved

Error assertion failed: 31110 - file shorter than expected

Posted on 2004-09-01
11
1,936 Views
Last Modified: 2008-03-06
Hi all,

my pc crashed and we lost the drive, we had a backup(network app not sybase) of our db and db.log file that msut have been taken while the dbeng was running. When I try and start sybase up again I get the error message :

Error assertion failed: 31110 - file shorter than expected.

I have tried starting the db with out the log file with no success, as well as dbvalid, using asa 7. Getting nowhere very fast with this!

thanks

0
Comment
Question by:deanvanrooyen
  • 6
  • 2
11 Comments
 
LVL 12

Author Comment

by:deanvanrooyen
ID: 11954404
ps when I try and start sybase with the db and log file that was taken with the backup
0
 
LVL 5

Expert Comment

by:dgroscost
ID: 12002718
Try starting off with a new log file.  If that doesn't work, try this:

Dbstart file.db -ho
0
 
LVL 12

Author Comment

by:deanvanrooyen
ID: 12004290
I'll try that -ho, I have tried without a log using -f which has worked in the past but I think the issue is with the db file and not the log...
0
 
LVL 12

Author Comment

by:deanvanrooyen
ID: 12004401
I tried that as well with dbeng as well as dbstart and I still get the assertion.

the exact messages in dbstart are:
2048k of memeroy used for caching
Database recovery in progress
    Last checkpoint "on the day it last ran ok"
    Checkpoint log...

and then the message box:
Error assertion failed: 31110 - file shorter than expected


any other ideas thanks... I have also tried dbvalid and unlaoding the db with no success
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 5

Expert Comment

by:dgroscost
ID: 12005445
If the -ho option doesn't work, try to apply and log files you have to backup databases.  If you can't start it, you can't reload it.  Might be out of luck...
0
 
LVL 12

Author Comment

by:deanvanrooyen
ID: 12005670
I think I am out of luck here,

I will leave this open for a bit longer as possibly one of the sybase techies might read this, they have resolved this on the sybase site but to view the solution I need to have a support contract with them :(
0
 
LVL 12

Author Comment

by:deanvanrooyen
ID: 12250247
how do I refund?
0
 
LVL 12

Author Comment

by:deanvanrooyen
ID: 12253931
please close this
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12280258
PAQed, with points refunded (150)

Computer101
E-E Admin
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

757 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