PDA

View Full Version : System.OutOfMemoryException error



etay0330
08-18-2011, 08:34 PM
Hi I'm getting this error quite a lot. Usually it happens when I try to open lots of hands in the hand column. For example when I view my graph for the last 200k hands, and then I highlight part of the graph to view the graphed hands, and when the hands exceed let's say 20-30k hands or so. When I try to view the hands in the graphed hands section and show all hands, that's when I get the error. I think I've gotten the same error when I try to see bunch of hands in the reports section too.

I have Core2Duo E8400, 4G ram, Windows 7 HP 64bit.

Any help is appreciated. Thank you.

Patvs
08-18-2011, 08:50 PM
Which PostgreSQL version are you using?
Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

and edit the postgresql.conf file and/or update PostgreSQL.

etay0330
08-18-2011, 08:55 PM
How do I find out what version of Postgres I'm using? And how do I update it if it's out of date?

etay0330
08-18-2011, 08:57 PM
By the way, I just saw that my postgres program folder reads Postgres 8.4.
Is that the most updated version?

Patvs
08-18-2011, 08:59 PM
Update it to 8.4.8 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org), edit the postgresql.conf file and reboot.

If that doesn't resolve it, install SQL 9.0.4 to port 5433, edit the postgresql.conf file and reboot.

etay0330
08-18-2011, 10:08 PM
I'm trying to install 8.4.8 now. I can't seem to find a installation guide on the FAQ section. I'm at the Password step and I can't seem to put in the right password for some reason. Is there anyway to find out what the password is?

Patvs
08-19-2011, 12:00 AM
Password is postgrespass.
If it doesn't accept that delete the postgres user.

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

/

etay0330
08-21-2011, 04:44 AM
I've installed both 8.4.8 and 9.0.4 but still having the same problem. I see both postgres versions running in Task Manager by the way. What do I do now?

netsrak
08-21-2011, 06:03 AM
Both are active in the windows services? It is not possible to run both on the same port so i guess only one of them is really active.
More than one postgres process in the task manager is normal.
But back to your original problem: did you try editing the conf file as posted above. If that doesn't help there is not much else we can do.
How much hands do you have in your database? http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+

etay0330
08-21-2011, 06:16 AM
Ok, couple of things. I think I might have messed something up.

First of all 8.4 is on port 5432, and 9.0 is on 5433, according to pgAdmin. And yes I see both versions running in the Task Manager processes, as well as Services. Did I mess up the installation of 9.0.4?

While in pgAdmin, my database is 'with' 8.4, not 9.0.

I have about 700k hands in my database.

etay0330
08-21-2011, 06:29 AM
By the way, I installed the 64bit version of 9.0.4 (I'm running Windows 7 Home Premium 64 bit) and I have edited the conf file in both versions.

Patvs
08-21-2011, 01:52 PM
Options--> Database Management--> Change the port to 5433--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager


Then reimport your hands.

etay0330
08-22-2011, 08:08 AM
It's still not working even with 9.0.4.

Is this a hardware problem? Do I not have enough RAM for this function to work? In one of your replies earlier you mentioned that there's nothing else you can do. Can you at least point me in the right direction in order to fix this problem?

netsrak
08-22-2011, 09:16 AM
I don't think its a problem of your hardware as it seems to be sufficient. This error comes directly from the postgresql installation. You may find more help in a postgresql related forum (PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)).