Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Error assertion failed: 31110 - file shorter than expected

Posted on 2004-09-01
11
Medium Priority
?
2,000 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

In this article, WatchGuard's Director of Security Strategy and Research Teri Radichel, takes a look at insider threats, the risk they can pose to your organization, and the best ways to defend against them.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

722 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