Hem Import freezing comp

[fbg1919]

Since a couple months ago, can't remember which version update, my Win 7 64b PC started freezing intermittently during sessions (obv HEM working) and I couldn't figure out what was the source of this annoying behaviour

This lasted for several minutes w/ freezing /defreezing (word?) every 30sec and lasting 3-5 sec each time. After about 5min it would disappear and never happen again

I checked the memory/the vid card (all top of the line at the moment of the PC's purchase /bulit myself etc) everything was on par and working flawlessly

There's no shortage of "power" (intel quad core at 2.8ghz/8gb/2TB hard/ati 5770 vid etc) so I began a process of elimination to find the source

Obv , I ended up figuring this happens because of the Auto Import in HEM and I tired a lot of stuff (deleted it, updated older etc ) and nothing works

I play on FTP and PS FR and in my opinion there some errors (or the format of the hand history/summaries) in the FTP/PS files (mostly FTP) which will cause the HMImport to run very very hard when importing and cause this incredibly annoying lag(freezes tables out/player/skype/aim /browser etc)

As soon as I close down HEM that crap still happens .. so I wondered how come ? well, the HMImport is STILL running in Task Manager, 1min after I force shut it down , the lag disappears .

So, WTF is going on and how can I fix it ??

[fbg1919]

Oh I run 11.06c

[Patvs]

Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html


Update PostgreSQL, turn off logging, remove the three winner columns,
For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

Add exceptions to the windows firewall for those files, even if the firewall is turned off.

[fbg1919]

you listed all the noob / standard crap that I know about since at least 2 years ago

let me know something else cause this stuff was done last time I made a new DB, late 09


edit: for the sake of others who might have this problem too , I will redo all the optimization steps and let you know if something goes wrong

[fbg1919]

http://i441.photobucket.com/albums/qq138/fbg1919/hemerror.jpg


[28/3/2011 11:26 AM] Reading databases .done
[28/3/2011 11:26 AM] Starting optimization
[28/3/2011 11:26 AM] Optimizing holdemmanager...done
[28/3/2011 11:29 AM] error: ERROR: XX001: invalid page header in block

544 of relation base/16397/16435[28/3/2011 11:29 AM] error: at

Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.ForwardsOnlyDataReader.GetNextResponseObjec t()
at Npgsql.ForwardsOnlyDataReader.GetNextRowDescriptio n()
at Npgsql.ForwardsOnlyDataReader.NextResult()
at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1

dataEnumeration, CommandBehavior behavior, NpgsqlCommand command,

NotificationThreadBlock threadBlock, Boolean synchOnReadError)
at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteNonQuery()
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String

db, Int32 type)
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()

[28/3/2011 11:29 AM] Error...please contact support@holdemmanager.com


This happens the moment I try to start the optimizing process


Also, on the Import behaviour, it basically spikes the CPU(s) to close to 100% usage whenever it freezes for the 1-2 sec periods

[fbg1919]

as a ref note, the DB is 400mb in size, logging is off , it was optimized about a year ago

[fbg1919]

update: getting the same error while trying to vacuum/analyze the DB manually via the PGAdmin: (last lines in the messages box )

There were 12 unused item pointers.
Total free space (including removable row versions) is 141680 bytes.
0 pages are or will become empty, including 0 at the end of the table.
54 pages containing 131692 free bytes are potential move destinations.
CPU 0.00s/0.03u sec elapsed 0.27 sec.ERROR: invalid page header in block 544 of relation base/16397/16435

ERROR: invalid page header in block 544 of relation base/16397/16435


update: analyze went on fine

[fbg1919]

uhm I did a lot of tweaking/optimizing and now I get this when starting HEM:

License Failure Details
--------------------------------------------------
28/3/2011 15:26:47
cx
--------------------------------------------------

Errors connecting to the server.

DETAILS

Could not activate license at server.
No more activations allowed. You must first deactivate the software from the original machine before attempting to activate again.

System Info
--------------------------------------------------

Timestamp: 2011-03-28T15:26:47 / 2011-03-28T18:26:47
Entry Assembly: HoldemManager, Version=1.11.5.3869, Culture=neutral, PublicKeyToken=null
Base Directory: C:\POKER\RVG Software\Holdem Manager\
Platform: Windows Vista Media Center 64-bit [6.1 Build 7600]
OS Version: 6.1.7600.0
CLR Version: 2.0.50727.4952
Process Bitness: 32-bit
Culture: en-US / en-US
Encoding: Western European (Windows)
IIS Available: True
Machine Code: DC562-0TW9C-3GU33-DV1SL-CXNGJ-MXM0C

Assemblies
--------------------------------------------------

Accessibility *
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\Accessibility\2.0.0.0 __b03f5f7f11d50a3a\Accessibility.dll

DeployLX.Licensing.v3 *
3.2.2000.0 / 3.2 R 3813 for .NET 2.0
C:\POKER\RVG Software\Holdem Manager\DeployLX.Licensing.v3.dll

DevComponents.DotNetBar2 *
8.3.0.0 / 8.3.0.0 for .NET
C:\POKER\RVG Software\Holdem Manager\DevComponents.DotNetBar2.dll

HoldemManager *
1.11.5.3869 / 1.11.5.3869 for .NET
C:\POKER\RVG Software\Holdem Manager\HoldemManager.exe

-lliqpxb *
3.2.2000.0 / 2.0 R 4927 (NetFXspW7 050727-4900) for .NET 2.0 (NetFXspW7 050727-4900)


mscorlib
2.0.0.0 / 2.0 R 4952 for .NET 2.0
C:\Windows\Microsoft.NET\Framework\v2.0.50727\msco rlib.dll

System
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5 c561934e089\System.dll

System.Configuration
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\System.Configuration\ 2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll

System.Drawing
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0. 0__b03f5f7f11d50a3a\System.Drawing.dll

System.Web
2.0.0.0 / 2.0 R 4955 for .NET 2.0
C:\Windows\assembly\GAC_32\System.Web\2.0.0.0__b03 f5f7f11d50a3a\System.Web.dll

System.Web.Services
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\System.Web.Services\2 .0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll

System.Windows.Forms
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\System.Windows.Forms\ 2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll

System.Xml
2.0.0.0 / 2.0 R 4927 for .NET 2.0
C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__b 77a5c561934e089\System.Xml.dll

[fbg1919]

OK , I tried reseting the license key in HEM in order to re-activate it again.

No dice . What gives ?

[fbg1919]

I have to start my session in 1/2 hr and this is highly frustrating

[Patvs]

You have to reset your serial to get rid of the "no more activations allowed" error.

However, the "ERROR: invalid page header in block 544 of relation base/16397/16435" is a sign of a corrupt database.

Can you still connect to Database Management (dbcontrolpanel.exe)---> create a new database--> start HoldemManager.

---

If you still get the "no more activations allowed" error, read: http://faq.holdemmanager.com/questions/24/ICan%27tActivate%26RegisterHoldemManager (and check the Internet Explorer proxy settings)

[fbg1919]

Yah already done that, however when I try reseting the profiles (I only have HEM on my desktop - this, and my laptop which I rarely use (backup )) this script error shows up and it won't do anything further

http://i441.photobucket.com/albums/qq138/fbg1919/licenseerrors.jpg

My db is not too big, 400 some MB , and I think I will try and make a new one , do I just follow the FAQ for deleting the old DB, create a new empty one and just import all the hands exported from the old one ?

I don't want to use the backup/restore feature in fear of getting the bug to transfer over to the new DB

Thoughts ?

[fbg1919]

Accessed dbcontrolpanel.exe, made a new db , I will import old hands into that as soon as I can get p0ast the activation problem

I tried deleting the files specified however, I have no holdemmanager.exe.ldat file to delete

Did find the .lic file, deleted it, but this didnt help. Time for some TeamViewer help or we can fix this somehow ?

I will take a break today and try to fix this till tonite cause I need the HEM badly tomorrow.

Let me know

[fbg1919]

Oh and I run Goggle Chrome, no issues with the proxy bit.

[fbg1919]

emailed support with a request for TV session

[fbg1919]

managed to deactivate profiles from my laptop and re-activate normally on desktop and laptop :)

now to make the new db