Page 1 of 2

PT3 v.3.08.1 cannot connect to database

PostPosted: Sun Mar 13, 2011 3:58 pm
by B_ing
Hello

just a fwe minutes ago PT was running well. after ending my session I used one of my filters and PT now says "unable to connect to database: Pocker Tracker 3 database".

Pls help!

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Sun Mar 13, 2011 4:41 pm
by WhiteRider
That indicates that the PostgreSQL service probably isn't running.

The first thing to try is a reboot - that will often get it going again.
If not, read our Firewall Guide.

If it still won't connect, click Start (if you're running Windows XP click Run), type services.msc and hit enter. Locate the PostgreSQL service - is it running? If not, can you start it?

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Mon Mar 14, 2011 5:08 am
by B_ing
reboot didnt work.

I didnt change a thing about my firewall and it worked just minutes before the problem.
EDIT: just allowed FULL acces again. solved the problem.

Postgres SQL Database server 8.3 is running.

I remember that yesterday after housekeeping PT3 told me that there was a file missing (forgot to write down which).

EDIT: PROBLEM SOLVED! GREAT SUPPORT!!

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Mon Mar 14, 2011 2:56 pm
by B_ing
just happened again! worked fine for a few hours.

when I try housekeeping in get prompted that file "pg_clog/0F75" is missing.

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Mon Mar 14, 2011 3:16 pm
by kraada
Try performing just a REINDEX via the housekeeping menu and see if that helps.

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Mon Mar 14, 2011 7:21 pm
by B_ing
How long should the reindexing take??

my DB is about 20k hands and is now reinexing for about 3.5 hours. Fine??

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Tue Mar 15, 2011 4:31 am
by WhiteRider
No, the reindex should not take anywhere near that long. Are any of the postgres.exe processes still using any CPU (in Task Manager > Processes)?

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Tue Mar 15, 2011 5:18 am
by B_ing
No SQL-Process is running at all. After restart PC and Housekeeping.

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Tue Mar 15, 2011 8:49 am
by kraada
If postgres.exe isn't running while reindex is attempting to work, something else is going wrong. Can you please attach the 5 most recent files in the C:\Program Files\PostgreSQL\8.3\data\pg_log folder to a support ticket and we'll investigate further for you.

Re: PT3 v.3.08.1 cannot connect to database

PostPosted: Sat Apr 09, 2011 6:13 am
by B_ing
Sorry.

Had to work an Awful lot in the past.

Same problems as described are still there with v 3.10.

I will sent whole file to support.