Rebuild and reindex database

[ionut214]

Hello,

I am new on forum but I use for a long time PT4.
So yesterday I try to rebuild full cashes my database but after 5 minutes the process not responding.I give up and then I have tried to play with HUD but importing don't work anymore and no hud on tables.After that I close the poker client and I made reindexing my databes but after 17 hours still not done.What should I do next?My database has 38gb.

[ionut214]

Still not done...What can I do???

[Flag_Hippo]

So yesterday I try to rebuild full cashes my database but after 5 minutes the process not responding.

Why are you rebuilding your database cache? It's not necessary unless you have a specific problem. It's also normal for PokerTracker 4 to not respond while the database cache is being rebuilt and if you check task manager you will see PostgreSQL is busy.

I give up and then I have tried to play with HUD but importing don't work anymore and no hud on tables.

That will happen when if rebuild was cancelled and the database cache will be in a bad state until the rebuild has been completed.

After that I close the poker client and I made reindexing my databes but after 17 hours still not done.What should I do next?My database has 38gb.

Still not done...What can I do???

That is a large database so it may take a day or two to complete especially if your database is not on an SSD.

[ionut214]

So yesterday I try to rebuild full cashes my database but after 5 minutes the process not responding.

Why are you rebuilding your database cache? It's not necessary unless you have a specific problem. It's also normal for PokerTracker 4 to not respond while the database cache is being rebuilt and if you check task manager you will see PostgreSQL is busy.

I give up and then I have tried to play with HUD but importing don't work anymore and no hud on tables.

That will happen when if rebuild was cancelled and the database cache will be in a bad state until the rebuild has been completed.

After that I close the poker client and I made reindexing my databes but after 17 hours still not done.What should I do next?My database has 38gb.

Still not done...What can I do???

That is a large database so it may take a day or two to complete especially if your database is not on an SSD.

I rebuild cahes because not all statistic load in hud

I don't cancelled rebuild cache .He intrerrupt by himself, the I try to reindex..


I have SSD and already are 25 hours and still not done.

[ionut214]

Is that a joke,I can't wait anymore so long...I uninstall PT4, postgress after that I deleted all the files from ;C.

Then reinstall both (include 9.6 pql) but hud don't work .Now what I do wrong?All my database was erase but I made backup.

Now answer is : How can import from backup files all my hands(with import from the disk? ) or another method?


The hud configuration in my poker client is ok but HUD don't appear.Why?

[Flag_Hippo]

I rebuild cahes because not all statistic load in hud

If you have a problem like this in future please report this to us via our support system with a log file as there can be other causes which wouldn't require any database housekeeping.

I don't cancelled rebuild cache .He intrerrupt by himself, the I try to reindex..

I have SSD and already are 25 hours and still not done.

I don't know why you would then switch to reindexing as that is something else entirely and that can potentially take longer than a cache rebuild. Reindexing is generally used to attempt to repair a database if it is corrupted/damaged but this would typically show up in PokerTracker 4 as error messages while importing hands or in PokerTracker 4 reports. Even after reindexing the database would still need a cache rebuild.

Then reinstall both (include 9.6 pql) but hud don't work .Now what I do wrong?

So we can see what's going on here please enable logging, reproduce this issue and send us your PokerTracker4.log file in a Support Ticket:

Guide: How to Create & Submit a PokerTracker4.log File

Now answer is : How can import from backup files all my hands(with import from the disk? ) or another method?

If your backup file contains a database backup you can restore that or you can reimport from hand history files. By default PokerTracker 4 moves your files to your 'Processed' folder which you can access via the 'File -> Open User Data Folder' option:

C:\Users\{Windows Login}\AppData\Local\PokerTracker 4\Processed

Guide: Processed Files

As you have alot of hands this import will take some time and import speeds can drop over large imports so I'd recommend breaking the import up into smaller chunks/folders.

[pt4pt4pt4]

Start a new database and test it on the poker sites to see if hands are importing, and you are seeing PT4 default hud working (not your own customized). That's a good start to see what's working and what is not.

[ionut214]

Start a new database and test it on the poker sites to see if hands are importing, and you are seeing PT4 default hud working (not your own customized). That's a good start to see what's working and what is not.

I do that.Hud working but after I imported millions of hand's crashed again with message"out of memory"....I have ram 16gb,SSD and HDD almost 3TB....and after hours and hours my all data was lost...again..No one respond to my message ..Something wrong with that soft.I use pt more than 5 years but I think I will give up..

[Flag_Hippo]

I do that.Hud working but after I imported millions of hand's crashed again with message"out of memory"....I have ram 16gb,SSD and HDD almost 3TB....and after hours and hours my all data was lost...again..

So we can find out what's causing the out of memory error please enable logging, reproduce this issue and send us your PokerTracker4.log file in Support Ticket. That wouldn't normally cause hands previously imported to be lost as they get saved to the database but if you open a ticket with your log file a technician can advise accordingly. Also as I recommended above try importing your hands in smaller batches instead of all at once but make sure logging is enabled in PokerTracker 4 (Configure -> Options) in case there is a problem so you can send us your log file if there is an out of memory error:

C:\Users\{Windows Login}\AppData\Local\PokerTracker 4\Logs\PokerTracker4.log

Everytime you start PokerTracker 4 it will begin a new log so you'll want to send that PokerTracker4.log file after any crash and before starting PokerTracker 4 again.

No one respond to my message ..

I've been replying to you here and you haven't opened a ticket on this subject yet from this account. Did you open a ticket using a different account/email address? If so what is the ticket number?