Solved

Error assertion failed: 31110 - file shorter than expected

Posted on 2004-09-01
11
1,982 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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

Question has a verified solution.

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

If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
Microsoft is moving in-place eDiscovery & hold from ECP to EOP console under Content Search in Search and Investigation Options.  In this post, I will be showing you how to export emails to a PST file using the Content Search Options.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

734 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