Solved

Error assertion failed: 31110 - file shorter than expected

Posted on 2004-09-01
11
1,973 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
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
In order to fulfill our mission of inspiring learning in the technology community, Experts Exchange is launching a Course of the Month program. Premium and Team Account members will have access to one course per month as a part of their membership, …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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