brazilio
09-22-2008, 11:59 PM
Hi,
in the process of moving my UB database from pt2 to hem. I've got a million to a million and a half hands with a lot of duplicates to import. I've had repeated problems doing the import and getting database corruption.
C:\Documents and Settings\thatguy\Desktop\data\hh\hh-9-15-08\0614200801431652_Leppersdorf.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
Is my standard repeated error for all text files after a period of time. Some files import correctly, but almost all of them do not.
C:\Documents and Settings\thatguy\Desktop\data\hh\stars\06202007142 9514_HH20070517 Kunigunde no all-in - $0.25-$0.50 - No Limit Hold'em.txt Connection establishment timeout. Increase Timeout value in ConnectionString.
C:\Documents and Settings\thatguy\Desktop\data\hh\stars\06202007142 9515_HH20070517 Leo Minor V fast, no all-in - $0.25-$0.50 - No Limit Hold'em.txt This stream does not support seek operations.
C:\Documents and Settings\thatguy\Desktop\data\hh\02202008160545486 _ub $5-$10 49036559-9570 to 49042783-38550.txt ERROR: 42501: could not write block 3738 of relation 1663/33142/33210: Permission denied
C:\Documents and Settings\thatguy\Desktop\data\hh\061520081803327_H avana.53823469-16139.txt ERROR: 42501: could not read block 1754 of relation 1663/33142/33242: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File186.txt ERROR: 42501: could not write block 0 of relation 1663/33142/33175: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File229.txt ERROR: 42501: could not open relation 1663/33142/2840: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File250.txt ERROR: 42501: could not open relation 1663/33142/33220: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File280.txt ERROR: XX002: index "playerhandsturn_pkey" is not a btree
are the initial errors outputted from ImportErrors.txt
After that, it spews out the original error ERROR 25P02 for almost every table session for a billion more lines.
I'm using 1.06.03h, and it was repeatable with a 1.05 install I had previously along with the current version.
Thanks for any help and tell me if I need to supply any more information or I missed something, nothing in the faq covered this and other than people on stars who were having problems with the new hh format they switched to, I didn't see any forum posts covering it.
I'm using pg 8.2, but I have 8.3 installed as well and can try that if necessary.
Also I prolly posted this in the wrong forum, if somebody could move this to HEM bugs I'd appreciate it.
in the process of moving my UB database from pt2 to hem. I've got a million to a million and a half hands with a lot of duplicates to import. I've had repeated problems doing the import and getting database corruption.
C:\Documents and Settings\thatguy\Desktop\data\hh\hh-9-15-08\0614200801431652_Leppersdorf.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
Is my standard repeated error for all text files after a period of time. Some files import correctly, but almost all of them do not.
C:\Documents and Settings\thatguy\Desktop\data\hh\stars\06202007142 9514_HH20070517 Kunigunde no all-in - $0.25-$0.50 - No Limit Hold'em.txt Connection establishment timeout. Increase Timeout value in ConnectionString.
C:\Documents and Settings\thatguy\Desktop\data\hh\stars\06202007142 9515_HH20070517 Leo Minor V fast, no all-in - $0.25-$0.50 - No Limit Hold'em.txt This stream does not support seek operations.
C:\Documents and Settings\thatguy\Desktop\data\hh\02202008160545486 _ub $5-$10 49036559-9570 to 49042783-38550.txt ERROR: 42501: could not write block 3738 of relation 1663/33142/33210: Permission denied
C:\Documents and Settings\thatguy\Desktop\data\hh\061520081803327_H avana.53823469-16139.txt ERROR: 42501: could not read block 1754 of relation 1663/33142/33242: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File186.txt ERROR: 42501: could not write block 0 of relation 1663/33142/33175: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File229.txt ERROR: 42501: could not open relation 1663/33142/2840: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File250.txt ERROR: 42501: could not open relation 1663/33142/33220: Permission denied
C:\Documents and Settings\thatguy\Desktop\HandHistoryExport_HoldemM anager\HandHistoryExport_HoldemManager\File280.txt ERROR: XX002: index "playerhandsturn_pkey" is not a btree
are the initial errors outputted from ImportErrors.txt
After that, it spews out the original error ERROR 25P02 for almost every table session for a billion more lines.
I'm using 1.06.03h, and it was repeatable with a 1.05 install I had previously along with the current version.
Thanks for any help and tell me if I need to supply any more information or I missed something, nothing in the faq covered this and other than people on stars who were having problems with the new hh format they switched to, I didn't see any forum posts covering it.
I'm using pg 8.2, but I have 8.3 installed as well and can try that if necessary.
Also I prolly posted this in the wrong forum, if somebody could move this to HEM bugs I'd appreciate it.