PT3 v.3.08.1 cannot connect to database

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

PT3 v.3.08.1 cannot connect to database

Postby B_ing » Sun Mar 13, 2011 3:58 pm

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!
B_ing
 
Posts: 17
Joined: Tue Mar 04, 2008 12:16 pm

Re: PT3 v.3.08.1 cannot connect to database

Postby WhiteRider » Sun Mar 13, 2011 4:41 pm

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?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PT3 v.3.08.1 cannot connect to database

Postby B_ing » Mon Mar 14, 2011 5:08 am

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!!
B_ing
 
Posts: 17
Joined: Tue Mar 04, 2008 12:16 pm

Re: PT3 v.3.08.1 cannot connect to database

Postby B_ing » Mon Mar 14, 2011 2:56 pm

just happened again! worked fine for a few hours.

when I try housekeeping in get prompted that file "pg_clog/0F75" is missing.
B_ing
 
Posts: 17
Joined: Tue Mar 04, 2008 12:16 pm

Re: PT3 v.3.08.1 cannot connect to database

Postby kraada » Mon Mar 14, 2011 3:16 pm

Try performing just a REINDEX via the housekeeping menu and see if that helps.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT3 v.3.08.1 cannot connect to database

Postby B_ing » Mon Mar 14, 2011 7:21 pm

How long should the reindexing take??

my DB is about 20k hands and is now reinexing for about 3.5 hours. Fine??
B_ing
 
Posts: 17
Joined: Tue Mar 04, 2008 12:16 pm

Re: PT3 v.3.08.1 cannot connect to database

Postby WhiteRider » Tue Mar 15, 2011 4:31 am

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)?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PT3 v.3.08.1 cannot connect to database

Postby B_ing » Tue Mar 15, 2011 5:18 am

No SQL-Process is running at all. After restart PC and Housekeeping.
B_ing
 
Posts: 17
Joined: Tue Mar 04, 2008 12:16 pm

Re: PT3 v.3.08.1 cannot connect to database

Postby kraada » Tue Mar 15, 2011 8:49 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT3 v.3.08.1 cannot connect to database

Postby B_ing » Sat Apr 09, 2011 6:13 am

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.
B_ing
 
Posts: 17
Joined: Tue Mar 04, 2008 12:16 pm

Next

Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 16 guests

cron