Error when Restoring my Database

Hold'em or Poker Tracker Hold'em related posts go here

Error when Restoring my Database

Postby Rikerslash » Mon Mar 10, 2008 9:42 am

Hello,

when i want to restore one of my PostgreSQL Databases i first got many of this errors
7-Sqlstate=S1000

ERROR:
could not open relation 1663/17253/xxxxx
X= Number
I made some 0 KB files with the name they look for, but after i made like 20 of them i get an other error

7-Sqlstate=S1000

ERROR:
could not open relation 1663/0/xxxxx

I don`t know what to do, because i don`t have a fodler called 0 and if I create one and put the searched file in i get the same error.
Rikerslash
 
Posts: 13
Joined: Mon Mar 10, 2008 9:34 am

Re: Error when Restoring my Database

Postby ptrack pat » Mon Mar 10, 2008 9:47 am

If you are getting these errors during the restore process then it means the .backup file is corrupted. I don't know any way to get around this kind of problem. Is this backup from another computer? Are you able to try to do another backup?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Error when Restoring my Database

Postby Rikerslash » Mon Mar 10, 2008 9:56 am

Iam sorry i mean while i do Vacuum/Analyze i was a bit confused. So while Compressing
Rikerslash
 
Posts: 13
Joined: Mon Mar 10, 2008 9:34 am

Re: Error when Restoring my Database

Postby ptrack pat » Mon Mar 10, 2008 1:26 pm

Do you run some kind of utility that scans your harddrive for 0kb files? Because that's the times I have seen this problem and the only way I know how to fix it is to restore from an old backup file. Do you have an old backup file?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Error when Restoring my Database

Postby Rikerslash » Mon Mar 10, 2008 6:43 pm

I have no backup files and i don`t use such files. I Made a new Database yesterday and now i can`t compress it today. between the time i didn`t use such programs. Or are there any Windowsprogramms or sth like that, deleting such files.
Rikerslash
 
Posts: 13
Joined: Mon Mar 10, 2008 9:34 am

Re: Error when Restoring my Database

Postby ptrack pat » Mon Mar 10, 2008 7:20 pm

The only time I've seen these files get deleted is when you have some sort of utility program that runs and cleans 0kb files off the hard drive.

Are you able to use the Utilities > Export Hand Histories To File option to export the hands to text files without error?

If so, I would create a new database and use those files to import into it.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PokerTracker Holdem

Who is online

Users browsing this forum: No registered users and 3 guests

cron