errors

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

errors

Postby storman99 » Tue Apr 29, 2008 4:08 pm

I was loading hand histories and all these errors can up.
The ptrack2.exe Fatal Application can up first,
so i closed PT, tried loading hands again and the other three errors can up at the same time.
My computer is
Windows Vista Home Premium
Processer; Intel(r) core(TM)2 Quad CPU @2.40GHz 2.40GHz
Menory (RAM) 3070 MB
System type 32-bit Operating System


[ img ]


PT seems like it's still running
do i let it run or close it
storman99
 
Posts: 14
Joined: Wed Mar 19, 2008 3:18 pm

Re: errors

Postby ptrack pat » Tue Apr 29, 2008 4:55 pm

Restart the computer and try it again.
Make sure you are running all poker software using 'run as administrator'.

If you still get the error, how are you importing hands? Are you using the auto-import window? If so, for what site?
What version of PT are you using?
Are you also using PokerAce or any other program that is accessing the database at the same time that PT is importing?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: errors

Postby storman99 » Tue Apr 29, 2008 5:51 pm

yes, auto-import window
Fulltilt
PT V2
not using PokerAce
storman99
 
Posts: 14
Joined: Wed Mar 19, 2008 3:18 pm

Re: errors

Postby ptrack pat » Tue Apr 29, 2008 7:02 pm

What version # exactly? Is it v2.17.02?

Are there a lot of hand history files in the folder that PT is reading from?

Are you using any other programs at the time besides Poker Tracker and Full Tilt?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: errors

Postby storman99 » Tue Apr 29, 2008 9:48 pm

It's version v2.17.01e

Are there a lot of hand history files in the folder that PT is reading from? Yes 125md file
(my old windows XP computer is running this size every day)


Are you using any other programs at the time besides Poker Tracker and Full Tilt? No

My old windows XP computer PT files look like this and is running fine.
Intel(r) core (TM)2CPU
6300 @ 1.86GHz
1.86GHz, 3.24,GB of RAM

[ img ]


My new computer
Windows Vista Home Premium
Processer; Intel(r) core(TM)2 Quad CPU @2.40GHz 2.40GHz
Menory (RAM) 3070 MB
System type 32-bit Operating System

PT files look like this and runs like ****

[ img ]
storman99
 
Posts: 14
Joined: Wed Mar 19, 2008 3:18 pm

Re: errors

Postby ptrack pat » Tue Apr 29, 2008 10:26 pm

You posted this in the PostgreSQL folder. Are you using PostgreSQL or not? The files you are showing are Access databases.

Are there a lot of hand history files in the folder that PT is reading from? Yes 125md file


What does this mean?? Are you trying to import a huge file containing a bunch of hand histories? If so, you cannot do this, you need to use the Utilities > File Splitter window and split the big file into a number of smaller files and then import the smaller files.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: errors

Postby storman99 » Tue Apr 29, 2008 10:59 pm

yes using PostgreSQL

What does this mean??
I was just showing PT file sizes.
windows XP PT file is 12.2gb and is still running fine with PostgreSQL file size 105gb.

vista PT files is only 224MD and runs like crap with PostgreSQL file size 29gb

I started out importing 1.3gb files and they imported fine. now if i try to import more then 100MD file all those errors come up.
storman99
 
Posts: 14
Joined: Wed Mar 19, 2008 3:18 pm

Re: errors

Postby ptrack pat » Wed Apr 30, 2008 8:55 am

I'm not asking about the size of the database files, I'm asking about the size of the hand history files.

RESTART THE COMPUTER.

Open PT again when it comes back using 'run as administrator' - Vista should prompt you to cancel/allow PT to run. If it doesn't you aren't running it correctly.

Open the FT auto-import window.
Click the Enable Logging box.
Click the Force Import button.
Does it give the same error message again now?
If so, find the file called autoimplog.txt in the c:\program files\poker tracker v2 folder and open it. Copy/paste the text of the log file into a reply.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: errors

Postby storman99 » Wed Apr 30, 2008 9:16 am

It just took over 6 hours to import 102.000 hands. Vista (no errors)

XP took less then 2 hours to import 148.000 hands
storman99
 
Posts: 14
Joined: Wed Mar 19, 2008 3:18 pm

Re: errors

Postby storman99 » Thu May 01, 2008 11:58 am

The errors came up about 15min into imports

heres the autoimplog


Logging started: 05/01/2008 09:58:07 AM
FTP HH Folder: E:\1-2nl store fulltilt\New Folder (20)
Main Settings: Database: 1-2nl 3-17-08 (PostgreSQL) TS=off MV=off AR=off TMR=2
Observed Settings: 1-2nl 3-17-08 (PostgreSQL) PTPGSQL2 0 0 1 2
==============================
12 new or updated file(s) found since last import.
Processing file: E:\1-2nl store fulltilt\New Folder (20)\LHS133B.tmp - last hand read/imported from this file = 0
Processing file: E:\1-2nl store fulltilt\New Folder (20)\LHS133B.tmp - processing starting at line 0
Processed file: E:\1-2nl store fulltilt\New Folder (20)\LHS133B.tmp : (0 hand(s) loaded).
Processing file: E:\1-2nl store fulltilt\New Folder (20)\LHS345F.tmp - last hand read/imported from this file = 0
Processing file: E:\1-2nl store fulltilt\New Folder (20)\LHS345F.tmp - processing starting at line 0
storman99
 
Posts: 14
Joined: Wed Mar 19, 2008 3:18 pm

Next

Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests