Author Topic: Optimize Problem (Read 20093 times)

jvic · « **on:** August 18, 2009, 10:24:01 pm »

I'm using 0.9.9.11 and when I try to Optimize the DB, I get the error 'Failed' by Create Backup and Garbage Collection. It then says 'Movies Deleted:0' and 'People Deleted:0'. It used to work. The DB doesn't appear to have any problems. Does anybody know what's wrong?

rick.ca · « **Reply #1 on:** August 18, 2009, 11:38:13 pm »

That's the behaviour I observe if I attempt to optimize when connect via server.

jvic · « **Reply #2 on:** August 18, 2009, 11:58:05 pm »

How do I change it to connect differently. I don't see a Preference setting. Thanks.

nostra · « **Reply #3 on:** August 19, 2009, 12:05:34 am »

Database -> Open

jvic · « **Reply #4 on:** August 19, 2009, 12:45:24 am »

Do you mean File -> Open? I don't see a Database menu. File -> Open doesn't have any options. Thanks.

rick.ca · « **Reply #5 on:** August 19, 2009, 01:03:40 am »

Use Open instead of Connect to server.

nostra · « **Reply #6 on:** August 19, 2009, 01:07:43 am »

Yes, I meant File -> Open

jvic · « **Reply #7 on:** August 19, 2009, 01:17:25 am »

I wasn't using Connect to Server. I use File -> Open. Is there something else? Thanks.

nostra · « **Reply #8 on:** August 19, 2009, 01:38:33 am »

What is the path for the backups and does pvd have access to this folder?

jvic · « **Reply #9 on:** August 19, 2009, 10:51:50 pm »

I'm using My Documents\Personal Video Database as the folder for the main DB file and the backup.

I installed Firebird Maestro. Could that be messing it up? Thanks.

nostra · « **Reply #10 on:** August 19, 2009, 11:53:48 pm »

Quote

I installed Firebird Maestro. Could that be messing it up? Thanks.

It could, theoretically, but should not...

What is the exact path (with filename) for the backup in "Optimize database" dialog?
Could you post your pvdconf.ini from "C:\Documents and Settings\%USERNAME%\Application Data\Personal Video Database\"

jvic · « **Reply #11 on:** August 20, 2009, 12:40:09 am »

Here is the path:
C:\Users\James\Documents\MOVIES.pvd.bak

[attachment deleted by admin]

nostra · « **Reply #12 on:** August 20, 2009, 01:27:40 am »

Strange, everything seems to be OK. I have only one explanation left: your database is corrupt

Is it possible for you to upload it to my FTP?

jvic · « **Reply #13 on:** August 20, 2009, 01:34:30 am »

It's 170 MB. Is there a way to repair it? Thanks.

nostra · « **Reply #14 on:** August 20, 2009, 02:05:55 am »

I can handle 170 MB.

Quote

Is there a way to repair it?

1. Download http://www.videodb.info/bin/fbtools.rar
2. Extract the package to the PVD directory
3. Create a backup copy of your database file
4. Execute in command line: gfix -v -f [database copy].pvd
5. If gfix reports that the file is corrupt, then execute: gfix -m -i [database copy].pvd
6. Do the 4. one more time to check if the database is fixed

rick.ca · « **Reply #15 on:** August 20, 2009, 02:53:43 am »

For us hopeless unilingual folk, I assume "[копия базы]" means "[copy of database]"?

jvic · « **Reply #16 on:** August 20, 2009, 02:54:44 am »

I'll give it a go. Thanks for the help.

nostra · « **Reply #17 on:** August 20, 2009, 03:43:34 pm »

Quote from: rick.ca on August 20, 2009, 02:53:43 am

For us hopeless unilingual folk, I assume "[копия базы]" means "[copy of database]"?

Ups, I have copied my answer from the Russian forum translating it in English, but forgot these two words

jvic · « **Reply #18 on:** August 20, 2009, 11:03:16 pm »

When I try 'gfix -v -f movies.pvd' at the command prompt nothing seems to happen. Just a new line appears

c:\Users\James\Documents\Personal Video Database\fbtools>gfix -v -f movies.pvd (I hit Enter here)

c:\Users\James\Documents\Personal Video Database\fbtools>

Any ideas? Thanks.

nostra · « **Reply #19 on:** September 02, 2009, 11:33:32 pm »

It should mean that everything is ok with the low level db structure...

News:

Author Topic: Optimize Problem (Read 20093 times)