Solved

Error assertion failed: 31110 - file shorter than expected

Posted on 2004-09-01
11
1,968 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

IT certifications are a concrete representation of continual learning on the part of the candidate.  Continual learning is necessary for the long term success of an IT professional, but are IT certifications the right path for you?
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

861 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