OutOfMemoryException when trying to display 197k hands in Reports
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Apr 2010
    Posts
    10

    Default OutOfMemoryException when trying to display 197k hands in Reports

    Hi,

    I'm trying to list all hands I played this year at Microgaming, so I can export them to my HD. There's about 198k hands. When I try to list them all in Reports, I get the following error:

    System.OutOfMemoryException: Exceção do tipo 'System.OutOfMemoryException' foi acionada.
    em System.Array.InternalCreate(Void* elementType, Int32 rank, Int32* pLengths, Int32* pLowerBounds)
    em System.Array.CreateInstance(Type elementType, Int32 length)
    em System.Collections.ArrayList.ToArray(Type type)
    em DevComponents.DotNetBar.៬.៴()
    em DevComponents.DotNetBar.៬.ൃ(IntPtr ୲, IntPtr ୳, IntPtr ୴)
    em DevComponents.DotNetBar.៶.PreFilterMessage(Message & m)
    em System.Windows.Forms.Application.ThreadContext.Pro cessFilters(MSG& msg, Boolean& modified)
    em System.Windows.Forms.Application.ThreadContext.Pre TranslateMessage(MSG& msg)
    em System.Windows.Forms.Application.ThreadContext.Sys tem.Windows.Forms.UnsafeNativeMethods.IMsoComponen t.FPreTranslateMessage(MSG& msg)
    em System.Windows.Forms.Application.ComponentManager. System.Windows.Forms.UnsafeNativeMethods.IMsoCompo nentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
    em System.Windows.Forms.Application.ThreadContext.Run MessageLoopInner(Int32 reason, ApplicationContext context)
    em System.Windows.Forms.Application.ThreadContext.Run MessageLoop(Int32 reason, ApplicationContext context)
    em System.Windows.Forms.Application.RunDialog(Form form)
    em System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
    em System.Windows.Forms.Form.ShowDialog()
    em System.Windows.Forms.Application.ThreadContext.OnT hreadException(Exception t)
    em System.Windows.Forms.Control.InvokeMarshaledCallba cks()
    em System.Windows.Forms.Control.WndProc(Message& m)
    em System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
    em System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
    em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    I also tried exporting the hands by month (about 30k hands/month), but I still get an OutOfMemory exception.

    I've seen this error before when trying to graph all hands in my database (about 3.8 million hands).

    Any clues? I'm using version 1.12.10b

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Update:
    http://www.holdemmanager.com/Downloa..._26Jul2013.exe


    Which PostgreSQL version are you using?
    Try editing your PostgreSQL.config file (read:
    http://forums.holdemmanager.com/mana...ease-tips.html)

    How much RAM does your computer have?
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  3. #3
    Junior Member
    Join Date
    Apr 2010
    Posts
    10

    Default

    I'll update HM and try it again.
    UPDATE: Got the same error.

    I have PostgreSQL 8.3. I've already modified the *.conf file.

    16GB of RAM.

    One thing I forgot to mention, I also get an error when trying to optimize my DB.

    30/07/2013 20:55] error: ERROR: XX001: invalid page header in block 284 of relation "compiledplayerresultspositionaction_month"[30/07/2013 20:55] error: em Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3> d__a.MoveNext()
    em Npgsql.ForwardsOnlyDataReader.GetNextResponseObjec t()
    em Npgsql.ForwardsOnlyDataReader.GetNextRowDescriptio n()
    em Npgsql.ForwardsOnlyDataReader.NextResult()
    em Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
    em Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
    em Npgsql.NpgsqlCommand.ExecuteNonQuery()
    em HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
    em HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[30/07/2013 20:55] Error...please contact support@holdemmanager.com
    Last edited by Ivan Miwa; 07-31-2013 at 01:59 PM.

  4. #4
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    1) Please close HM

    2) Please open PGAdminIII

    It is in the Start -> Postgres folder.

    3) Enter your postgres password. The default password is typically postgrespass.

    4) Open the databases.

    5) Highlight your database.

    6) Right click, click maintenance.

    7) Run the vacuum and analyze and reindex functions.

    http://faq.holdemmanager.com/questio...lyze+Database+

    Please try again.
    Regards udbrky (Chris)

  5. #5
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    And if that doesn't resolve it, reimport all your hands into a new empty database.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

Similar Threads

  1. HEM PRoblem: System.OutOfMemoryException
    By kibkar in forum Manager General
    Replies: 1
    Last Post: 04-27-2012, 07:41 PM
  2. System.OutOfMemoryException error
    By etay0330 in forum Manager General
    Replies: 13
    Last Post: 08-22-2011, 09:16 AM
  3. UB Cash Hands do Not Display In Reports
    By walter82 in forum Manager General
    Replies: 5
    Last Post: 10-01-2010, 03:52 AM
  4. How to display the VPP of Stars in the reports?
    By Kohni in forum Manager General
    Replies: 1
    Last Post: 05-14-2009, 01:47 PM
  5. System.OutOfMemoryException
    By PingPongTjong in forum Manager General
    Replies: 24
    Last Post: 11-22-2008, 12:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •