WhatPulse Forums
Corrupted Database - Printable Version

+- WhatPulse Forums (http://whatpulse.org/forums)
+-- Forum: Support (/forumdisplay.php?fid=38)
+--- Forum: Client software (/forumdisplay.php?fid=58)
+--- Thread: Corrupted Database (/showthread.php?tid=5062)



Corrupted Database - Thewsomeguy - 06-13-2014 02:22 PM

How does the backup database become corrupted (or whatever) when the main database does? I had this message come up, but I just hit "no" until the message went away. When I opened the client, my stats were still there. Maybe the client got confused about the databases becoming corrupted?


RE: Corrupted Database - pyoung9348 - 06-13-2014 04:55 PM

Are you serious? I hit yes because I thought it was a legitamate problem and now my database is wiped..


RE: Corrupted Database - smitmartijn - 06-13-2014 05:26 PM

There will be some data in there, but there is a spot that is corrupted, otherwise it won't give a message. Using a corrupted database can lead to client crashes and very weird data output, that is why it asks you to refresh it.

For as how they can both be corrupted..a few reasons; when running the client with a corrupted database, it will backup that corrupted database. Most common reason is antivirus type programs messing with the database files.


RE: Corrupted Database - Thewsomeguy - 06-15-2014 06:59 PM

(06-13-2014 05:26 PM)smitmartijn Wrote:  There will be some data in there, but there is a spot that is corrupted, otherwise it won't give a message. Using a corrupted database can lead to client crashes and very weird data output, that is why it asks you to refresh it.

For as how they can both be corrupted..a few reasons; when running the client with a corrupted database, it will backup that corrupted database. Most common reason is antivirus type programs messing with the database files.

I haven't gotten any weird output, nor any client crashes.


RE: Corrupted Database - MiniGod - 07-01-2014 03:43 PM

Code:
01-07-2014 15:07:22.156  INFO "Starting WhatPulse 2.4..."
01-07-2014 15:07:22.180 DEBUG Installed CrashRpt!
01-07-2014 15:07:22.424 DEBUG Database file:  "C:/Users/xxx/AppData/Local/WhatPulse/whatpulse.db"
01-07-2014 15:07:22.708 DEBUG Database check:  "*** in database main ***
On tree page 24785 cell 109: Rowid 378363 out of order (previous was 378392)
On tree page 24959 cell 106: Rowid 381389 out of order (previous was 381501)"
01-07-2014 15:07:22.986 DEBUG Database integrity check:  "*** in database main ***
On tree page 24785 cell 109: Rowid 378363 out of order (previous was 378392)
On tree page 24959 cell 106: Rowid 381389 out of order (previous was 381501)"
01-07-2014 15:07:22.987 DEBUG Detected a database failure..trying to restore!
01-07-2014 15:07:23.003 DEBUG Copied:  "C:/Users/xxx/AppData/Local/WhatPulse/whatpulse.db.backup"  to:  "C:/Users/xxx/AppData/Local/WhatPulse/whatpulse.db"
01-07-2014 15:07:23.285 DEBUG Database integrity check:  "*** in database main ***
On tree page 24785 cell 109: Rowid 378363 out of order (previous was 378392)
On tree page 24959 cell 106: Rowid 381389 out of order (previous was 381501)"
01-07-2014 15:07:23.285 DEBUG Unable to recover from database backup file!
01-07-2014 15:07:24.777 DEBUG User declined fresh database
01-07-2014 15:07:25.370 DEBUG User declined fresh database
01-07-2014 15:07:25.370 FATAL Unable to open database: failed database integrity check ( " " )

I get this error sometimes when I boot. Selecting no twice, and getting fatal error, and what pulse refuses to start. I have to create a new database now :\
Rows out of order?


RE: Corrupted Database - Advil - 10-17-2019 12:39 AM

Is there a way to heal the database?