Record 8381 has bad transaction, Record 16281 is marked as damaged in table

Posted on 2003-03-25
Medium Priority
Last Modified: 2013-12-09
I did validation on my interbase databas. It said there are some errors. I checked the interbase.log file.
I found there ware some information like these below:
PETER1 (Server)     Tue Mar 25 13:25:11 2003
     Database: D:\CCOSDATA\PERCY.GDB
     Record 8381 has bad transaction 1539829 in table APPTS (157)

PETER1 (Server)     Tue Mar 25 13:25:11 2003
     Database: D:\CCOSDATA\PERCY.GDB
     Record 16281 is marked as damaged in table APPTS (157)

I am a delphi programmer. I wish to trace what is going wrong. So I wish to know more information about these error, for instance, on which day these errors occurred, can I still see these records in ibConsole? if I can, then how can I locate these? How these may happen?
I found the record number here (Record 8381) was not the sequence number in my appts table, because the table hasn't got the amount of records.

Thank u

Question by:petershaw8
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
  • 2

Assisted Solution

netwolfds earned 180 total points
ID: 8514447
if the application freezes or your computer'power off when you are writing data to the interbase database,maybe these errors occurred.
you can locate these in ibconsole.use the mouse right_click
on your database,and you can see "Validation".
My English is poor,and hope you can understand.

Accepted Solution

Deesy earned 320 total points
ID: 8618958
just fix your database when everybody is disconnected.
gfix -v -f -user sysdba -password masterkey localhost:D:\CCOSDATA\PERCY.GDB
gfix -m -user sysdba -password masterkey localhost:D:\CCOSDATA\PERCY.GDB
then do backup/restore
gbak -b -i -v -g -user sysdba -password masterkey localhost:D:\CCOSDATA\PERCY.GDB D:\CCOSDATA\PERCY.Gbk
gbak -r -v -page 4096 -user sysdba -password masterkey D:\CCOSDATA\PERCY.Gbk localhost:D:\CCOSDATA\PERCY.GDB
that's it. Could be anything. power cut off, OS crashed and did not save cache etc...

LVL 10

Expert Comment

ID: 9795329
Hi petershaw8,

if you got the needed answer, please accept it by clicking on Accept in the header of the good answer. By this way you can express thanks for expert's support

with best regards

LVL 10

Expert Comment

ID: 10340292
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
       to split points between netwolfds (45) and Deesy (80)
Please leave any comments here within the next four (4) days.


If you will get a useful answer to your newer question next time, please accept it after evaluating. By this way the experts will get sooner his expert points for supporting you. If you have question about, please look at  http://www.experts-exchange.com/help.jsp.

EE Cleanup Volunteer

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

764 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