PDA

View Full Version : Crashing when trying to view all hands



Polar_Bears
07-25-2010, 03:07 AM
HEM crashes on me any time I try to look at "all" of "my" hands in my database. Here is the error message:

http://i651.photobucket.com/albums/uu238/Polar_Bears/AllHandsError.jpg

Here is actual error message inside window:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Softelvdm.Controls.CellBaseClass.set_Text(String value)
at d7.d()
at d7.a(Object A_0, RunWorkerCompletedEventArgs A_1)
at System.ComponentModel.BackgroundWorker.OnRunWorker Completed(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperat ionCompleted(Object arg)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.11.3.2515
Win32 Version: 1.11.03.2515
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 8.3.0.0
Win32 Version: 8.3.0.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/DevComponents.DotNetBar2.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
DeployLX.Licensing.v3
Assembly Version: 3.2.2000.0
Win32 Version: 3.2.2000.3813
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/DeployLX.Licensing.v3.DLL
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
WindowsFormsIntegration
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4902 built by: NetFXw7
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsFormsIntegration/3.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
----------------------------------------
PresentationCore
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.5001 built by: Win7RTMGDR
CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
WindowsBase
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.5001 built by: Win7RTMGDR
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Softelvdm.SftTreeNET
Assembly Version: 2.0.13.0
Win32 Version: 2.0.13.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/Softelvdm.SftTreeNET.DLL
----------------------------------------
Softelvdm.Controls
Assembly Version: 1.0.0.17
Win32 Version: 1.0.0.17
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/Softelvdm.Controls.DLL
----------------------------------------
Npgsql
Assembly Version: 2.0.6.0
Win32 Version: 2.0.6.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/Npgsql.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/Mono.Security.DLL
----------------------------------------
ZedGraph
Assembly Version: 5.1.4.31904
Win32 Version: 5.1.4.31904
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/ZedGraph.DLL
----------------------------------------
PresentationFramework
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.5001 built by: Win7RTMGDR
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
SitNGoWizard.1.1
Assembly Version: 1.0.2.12
Win32 Version: 1.0.2.012
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/SitNGoWizard.1.1.EXE
----------------------------------------
SitNGoWizard.Localization.2.0
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/SitNGoWizard.Localization.2.0.DLL
----------------------------------------
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/log4net.DLL
----------------------------------------
HoldemVision
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/HoldemVision.DLL
----------------------------------------
LeakBuster2.5
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/LeakBuster2.5.DLL
----------------------------------------
LeakBuster2.5 Limit
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/LeakBuster2.5%20Limit.DLL
----------------------------------------
HEMGUI
Assembly Version: 1.0.9.150
Win32 Version: 1.0.9.150
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/HEMGUI.DLL
----------------------------------------
Acid Library
Assembly Version: 1.3.2734.23020
Win32 Version: 1.3.2734.23020
CodeBase: file:///F:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/Acid%20Library.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

_Loki_
07-25-2010, 04:31 AM
###
Short of buying a new setup...

1] Edit your "postgresql.conf" file
On my machine it's here:
>> "C:\Program Files\PostgreSQL\8.4\data\postgresql.conf"

2] Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
>> FAQ - Hold'em Manager Poker Tracking Software :: Hands View Column Selection (http://faq.holdemmanager.com/questions/192/Hands+View+Column+Selection)

3] Make DB as small as possible

Instructions are here (& other things you could do too)
>> FAQ - Hold'em Manager Poker Tracking Software :: Holdem Manager Performance & Speed Tweaks (http://faq.holdemmanager.com/questions/373/Holdem+Manager+Performance+%26+Speed+Tweaks)

###

Polar_Bears
07-31-2010, 03:51 PM
###
Short of buying a new setup...

1] Edit your "postgresql.conf" file
On my machine it's here:
>> "C:\Program Files\PostgreSQL\8.4\data\postgresql.conf"

###

Short of buying a new setup?? What is that suppose to mean?? My system is not powerful enough for this??

Edit the postgresql.conf file and do what with it?? Doesn't make any sense...you say edit this file, but you don't tell me what I am editing.

Polar_Bears
07-31-2010, 04:30 PM
I am assuming you wanted me to do this:

Recommended changes:
shared_buffers = MB (set this to 20% of your system memory, but not more than 1000 MB.... round it off to 128 MB, 256 MB, 512 MB or 768 MB)
effective_cache_size = MB (set this to 2x the size of the shared_buffers)

I just bought and installed 8 gigs of 1066 DDR2 memory specifically to help with HEM. I changed the above to:
shared_buffers = 768MB
effective_cache_size = 1536MB

I did everything else listed above, minus the dump and restore. Only reason I didn't do it is because the instructions you point to are not even close to being "detailed" like you mentioned. From the link provided, I have no idea where to go do the things it mentions. The directions look like they are SQL queries, but it doesn't tell you where you are suppose to go and put these commands in.

So I did everything you said and now I am getting:
http://i651.photobucket.com/albums/uu238/Polar_Bears/memoryHEM.jpg

What now?

_Loki_
07-31-2010, 04:53 PM
edit - cross post

###

instructions are here (& other things you could do too)

>> faq - hold'em manager poker tracking software :: Holdem manager performance & speed tweaks (http://faq.holdemmanager.com/questions/373/holdem+manager+performance+%26+speed+tweaks)


###

Polar_Bears
07-31-2010, 05:15 PM
I am pretty clear on how to follow links to where the instructions you provided are.

They look like this:

1. log in as pmx - we'll do everything as pmx, superuser privileges are not needed.
2. pmx-database stop - we need to stop database before the next step, to capture consistent data.
3. cp -av ~pmx/../postgres /somewhere - this is the most important step of all, so you need to do it carefully. If anything goes wrong with the following steps, you'll always be able to recover your database from the backup we made by doing this recursive copy.
4. edit pg_hba.conf - you need to remove all lines that allow access through the IPv4 sockets. That's because we'll need to have database up & running to made a dump of it, but we must not allow other services to use it (change the data in it) and thus make the dump/reload step inconsistent.
5. pmx-database start - start the database.
6. pmx-database dump dumpfile - dump the contents of the database to dumpfile.
7. dropdb pmx_quarantine - drop the old database.
8. createdb pmx_quarantine - recreate the database. It will be empty after this step.
9. pmx-database import dumpfile - finally, with this command we're importing the old data, but after this command finishes, the database will be compacted and will take much less space on disk. This will also have positive effect on the performance of the whole system.
10. pmx-database stop - stop the database to reconfigure it once again.
11. restore original pg_hba.conf - allow all users of the database to connect.
12. pmx-database start - start it.
13. (optional) pmx-httpd restart - if you encounter problems accessing your quarantine, restart the EUWI service and everything will work once again.

Let's start with step 1...what the hell is pmx?

Step 2 pmx-database stop...where does this go?!?!?

I can't believe you point non technical people here as a service....I AM EXTREMELY TECHNICAL and I don't even know what all this is suppose to mean!!!!!!

Instead of pointing people to an advanced SQL site, why don't you make step by step instructions THAT ARE CLEAR with pictures on how to do this!

So going back to my original point, your instructions aren't clear enough on what people are suppose to do.

_Loki_
07-31-2010, 05:55 PM
###
In post #2: I gave 3 options with a link at the bottom where those options were explained
In post #3: You said I didn't tell you what to edit in postgresql.config file
I replied in what I thought would be post #4, but we cross-posted so post #5 is in reply to post #3

OK ?

###
Moving on...
If your last post is directed at me - then pull your horns in & stop SHOUTING
I am not a moderator
I am a HM user just like you
Please bear that in mind & be more courteous towards me - I didn't write or design the FAQ's & mostly they are pretty good - though there can be difficulties in ensuring the up-to-date nature of links-inside-links

OK ?

###
I suppose that you're referring to this link-inside-link ?
>> How to optimize PostgreSQL database size | LinuxInsight (http://www.linuxinsight.com/optimize_postgresql_database_size.html#comment-538)

Did you notice it was a Linux site ?
Those instructions are not in the main body of the link, but in the user posts
& those instructions are I think dump/restore in Linux & I only know this because of the user post further down by 'Nooob' entitled 'Sry, beginner question' where 'nooob' asks about Windows

###
I can find out what you need to know because I would like to know for myself. Would you like me to research this ?

###