Cant import hands from network

Any support related posts should go here.

Cant import hands from network

Postby TROM » Sat Mar 03, 2012 9:20 am

Have PT3 on Windows 7 64-bit and PostgreSQL 9.1 64-bit
All hands have on other computer

when start import PT3 see all files with hands (Ipoker) but dont import any hands

in PostgreSQL logs I have this errors (logs takes many gigs of space)

2012-03-03 18:13:04 NOVT ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "hhs-unique_hand_no"
2012-03-03 18:13:04 NOVT ПОДРОБНОСТИ: Ключ "(id_site, hand_no)=(400, 3188072188)" уже существует.
2012-03-03 18:13:04 NOVT КОНТЕКСТ: COPY holdem_hand_summary, строка 1: "2051556 400 454 501 3188072188 2012/03/03 03:32:07 2012/03/03 18:10:07 4 2 2 2 0.61 0.98 0.98 0.94 0..."
2012-03-03 18:13:04 NOVT ОПЕРАТОР: COPY holdem_hand_summary FROM STDIN;
2012-03-03 18:13:04 NOVT ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "hhs-unique_hand_no"
2012-03-03 18:13:04 NOVT ПОДРОБНОСТИ: Ключ "(id_site, hand_no)=(400, 3178655633)" уже существует.
2012-03-03 18:13:04 NOVT КОНТЕКСТ: COPY holdem_hand_summary, строка 1: "2051592 400 454 495 3178655633 2012/02/25 13:32:45 2012/03/03 18:11:53 5 2 2 2 0.96 0.97 0.95 0.91 0..."
2012-03-03 18:13:04 NOVT ОПЕРАТОР: COPY holdem_hand_summary FROM STDIN;
2012-03-03 18:13:04 NOVT ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "hhs-unique_hand_no"
2012-03-03 18:13:04 NOVT ПОДРОБНОСТИ: Ключ "(id_site, hand_no)=(400, 3188072188)" уже существует.
2012-03-03 18:13:04 NOVT КОНТЕКСТ: COPY holdem_hand_summary, строка 1: "2051556 400 454 501 3188072188 2012/03/03 03:32:07 2012/03/03 18:10:07 4 2 2 2 0.61 0.98 0.98 0.94 0..."
2012-03-03 18:13:04 NOVT ОПЕРАТОР: COPY holdem_hand_summary FROM STDIN;
2012-03-03 18:13:04 NOVT ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "hhs-unique_hand_no"
2012-03-03 18:13:04 NOVT ПОДРОБНОСТИ: Ключ "(id_site, hand_no)=(400, 3178655633)" уже существует.
2012-03-03 18:13:04 NOVT КОНТЕКСТ: COPY holdem_hand_summary, строка 1: "2051592 400 454 495 3178655633 2012/02/25 13:32:45 2012/03/03 18:11:53 5 2 2 2 0.96 0.97 0.95 0.91 0..."
2012-03-03 18:13:04 NOVT ОПЕРАТОР: COPY holdem_hand_summary FROM STDIN;


What can I do to fix this problem ?
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Cant import hands from network

Postby WhiteRider » Sat Mar 03, 2012 1:19 pm

For future reference please post PT3 questions in the PT3 section - this section is for PT2:Stud.

What version of PT3 are you using?
If it isn't v3.11.11 Beta please update and see if that helps.

Download page
PT3 Build History / Release Notes

If you still get this error please check the FAQ: Importing to PT3 before you report your problem so that we can check your logs and see what is going on.

You should also note that we don't officially support PostgreSQL 9.1 yet as it's still pretty new and in our initial tests there were problems with some functionality PT3 uses. This may have been sorted out now and may not be the cause of your problem, but we currently recommend v9.0.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PTS Support

Who is online

Users browsing this forum: No registered users and 6 guests

cron