Data base error

5 posts / 0 new
Last post
tarek
Data base error

Hi all,

I ran a refinement this morning and suddenly in the afternoon got the following message:

SQL Error: disk I/O error
Trying to execute the following command :-

BEGIN IMMEDIATE;
From core/database.cpp:33
int Database::ExecuteSQL(const char *)

 

Is there any chance to recover my data?

All of my 3 projects are corrupted, despite being stored in separate databases...

 

Best,

Tarek

 

timgrant
Hi Tarek,

Hi Tarek,

My guess is that your have just run out of disk space.  I don't think all your projects will be corrupted.  If you can free up disk space - you should be able to open them again.

Cheers,

Tim

tarek
I will go for this, thanks

I will go for this, thanks Tim!

Space is plenty, maybe some hidden quota...

For sanity backups: is it sufficient to archive the *.db files or are there additional "hidden" files needed?

timgrant
Hi Tarek,

Hi Tarek,

Only the .db file is needed, but you should probably make sure the database is not open when backing it up.

Did you manage to fix the issue in the end?

Tim

 

tarek
Hey Tim,

Hey Tim,

After that first shock I will routineously backup my db files. Maybe this is something you could implement in the next version?

Indeed your first guess was correct, I was read-only due to file number quota limits. Lucky me...

 

Best,

Tarek

Log in or register to post comments