Page 1 of 2

cluster problem

PostPosted: Sat Jan 09, 2010 7:05 am
by petike2222
Hi! I always get this error when I want to cluster my database:
2010/01/09 04:41:46.067: [00000B08][PostgresConnection (Error)] Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
2010/01/09 04:41:46.068: [00000B08][PostgresConnection] Cluster complete.
I have 12Gb memory, what could be the problem?

Re: cluster problem

PostPosted: Sat Jan 09, 2010 8:53 am
by petike2222
here is my complete log file:
2010/01/09 12:08:17.024: [- Main -][System] PokerTracker v3.00 beta 30.1
2010/01/09 12:08:17.024: [- Main -][SystemInfo] OS: Windows NT 6.1 (build 7600)
2010/01/09 12:08:17.024: [- Main -][SystemInfo] Windows Version: 6.1 build 7600 (platform 2)
2010/01/09 12:08:17.024: [- Main -][SystemInfo] Current Code Page: 1250
2010/01/09 12:08:17.024: [- Main -][SystemInfo] Total Physical Processors or Cores: 8
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 1: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 2: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 3: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 4: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 5: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 6: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 7: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Processor 8: Speed: 3.00 GHz Name: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
2010/01/09 12:08:17.040: [- Main -][SystemInfo] C:\ Disk Space: 122,096 mb total; 24,298 mb used; 97,797 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] D:\ Disk Space: 1,430,796 mb total; 681,568 mb used; 749,228 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] E:\ Disk Space: 4,673,445 mb total; 4,362,158 mb used; 311,287 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] F:\ Disk Space: 1,049,597 mb total; 268,770 mb used; 780,827 mb free
2010/01/09 12:08:17.040: [- Main -][SystemInfo] Physical Memory: 4,096 mb (4,096 mb available) Virtual Memory: 2,048 mb (1,935 mb available) Page File: 4,096 mb (4,096 mb available)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[0]: ATI Radeon HD 4800 Series (\\.\DISPLAY1)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[1]: ATI Radeon HD 4800 Series (\\.\DISPLAY2)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[2]: ATI Radeon HD 4800 Series (\\.\DISPLAY3)
2010/01/09 12:08:17.040: [- Main -][System Info] Video[3]: ATI Radeon HD 4800 Series (\\.\DISPLAY4)
2010/01/09 12:08:17.059: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=4,0\nMainSize=1142,1052\nMainMaximized=N\n\n\n[General]\nLogging=Y\nRegistrationCode=*** REG CODE REMOVED ***\nMinimizeToTray=Y\nBestHudPerformance=N\nInvalidText=#C0C0C0:NA\nUseCardImages=Y\nColorPositiveText=009900\nColorPositiveRow=EBFFEB\nColorNegativeText=AA0000\nColorNegativeRow=FFEBEB\n\n\n[Import]\nBeepOnCompletion=N\nClusterOnCompletion=N\nVacuumOnCompletion=N\nAnalyzeOnCompletion=N\nUpCacheOnCompletion=N\nMoveProcessedFilesDirectory=C:\Program Files (x86)\PokerTracker 3\Processed\nHidden.700=Y\nHidden.800=Y\nHidden.1000=Y\nHidden.500=Y\nHidden.300=Y\nHidden.400=Y\nHidden.1100=Y\nHidden.900=Y\nHidden.200=Y\nHidden.100=Y\nPlayedHandsDatabase=bwin import\nObservedHandsDatabase=bwin import\nImportObservedHands=N\nAutoTreatAs=Y\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nPriority=2\nMoveProcessedFiles=Y\nHidden.1200=Y\nHidden.1300=Y\nForceSetupWizard=N\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=handhq\nDB1.Default=Y\nDB1.Type=postgres\nDB1.Postgres.Database=pt3_newdb\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=bwinimport\nDB2.Type=postgres\nDB2.Postgres.Database=bwinimport\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=dbpass\n\n\n[ReportInfo]\n\n\n[HandReplayer]\nShowKnownCards=N\nAutoPlayHands=N\nShowHeroCards=Y\nShowHud=N\n\n[Messages]\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:ad6300733bb6909ea7d83b5733db3707=Y\nOptOut:b71d4740984682c07fbd139aa8cdcd3d=Y\nOptOut:aad7cd88ddec40ed2d4224a0db99936b=Y\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:f797b1cf4942ae8efd07f03a31b21636=Y\nOptOut:6d2da8f6c67067ecf0b2c21163a52862=Y\nOptOut:29398a871f8fe720b2de9674dcfd1a8d=Y\nOptOut:1b9775a152c0353de5fd74d94ea1f85c=Y\nOptOut:1e7272f2d3bafb73474900e3f7ffff06=Y\nOptOut:8c65f8d2c26c7f927b774865217277a3=Y\nOptOut:5da3f2678b14dcf5969d16bb05c79aa2=Y\nOptOut:fd55256395b90147908c33cc01783305=Y\nOptOut:e00c5c279663e243636e9c43fe17ffb8=Y\nOptOut:f826b4ff568c257d7b48e4c82c33f210=Y\nOptOut:ca181ba850dd86852eda807cab29b1d4=Y\n[Tabs]\nLast:WindowMain=2\nLast:WindowImport=1\nLast:WindowStats:Holdem=0\nLast:WindowStatsTab:holdem-cash=0\nLast:WindowStatsTab:holdem-tourney=0\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=0\nLast:WindowStatsTab:omaha-tourney=0\n[TableTracker]\nHideTablesNoStats=N\nLaunch.OnGame=bwin,C:\Program Files (x86)\bwinPoker\StartbwinPoker.exe;\nMinHands=100\nCurrentLimitOnly=N\nMinPlayers=1\nMaxPlayers=4\nShow10Max=N\nShow6Max=Y\nShow2Max=N\nBeepOnSearchComplete=Y\nScoring=0\nFilters.1.Type=0\nFilters.1.Result=100\nFilters.1.Color=15461375\nFilters.1.Rules.1=IFRUOiBTY29yZQkzCTAJMA==\t\nFilters.2.Type=0\nFilters.2.Result=100\nFilters.2.Color=15466475\nFilters.2.Rules.1=IFRUOiBTY29yZQkxCTAuMDAJMC4wMA==\t\nFilters.Count=2\nLimits=$2 NL;\nLaunch.Full Tilt=Full Tilt,C:\Program Files (x86)\Full Tilt Poker\FullTiltPoker.exe;\nSites=OnGame;\n[Directories]\nManualImportFile=D:\____POKER\statisztikák\bwin\vasarolt\nl200 5000k 090726ig\petike2222_ONG_NLH200_3-6plrs_x5000k_1a77a\*\nHudImportExportDirectory=C:\Users\manfer\Desktop\\nManualImportDirectory=D:\____POKER\statisztikák\bwin\vasarolt\nl400 2010-01-06ig\nDatabaseExportDirectory=D:\____POKER\statisztikák\bwin\most\nBackupDirectory=D:\____POKER\n[Hud]\nPerformanceOption=0\nMuckedCards.Display=N\nMuckedCards.Length=3\nMuckedCards.Translucency=53\nNotes.Translucency=49\nMinHands=1\nCurrentLimit=N\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nPlayerRanges=1,2|3,5|\nRefreshRates=1,30,1|30,100,5|101,1000,10|1001,100000000,30|\nDefaultProfile.51ead1bea03db760525d57dae204191f=Tournament - tour\nDefaultProfile.b17e98b7cedb7d079f657e88a4d3fb3d=Cash - cash uj\nDatabases=handhq\nbwinimport\n[Site.OnGame]\nHandHistoryDirectories=C:\Users\ManFer\AppData\Local\P5\bwin\handhistory;\n
2010/01/09 12:08:17.133: [- Main -][System] Getting String: 1059-C98F-D5EA-D02E-3D54-3919-21B8-0325
2010/01/09 12:08:17.135: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2010/01/09 12:08:17.135: [- Main -][wxThreadedRead] Starting read thread ...
2010/01/09 12:08:17.135: [00001640][ConnectorReadThread] Thread [0x00001640]: Begin
2010/01/09 12:08:17.135: [00001640][ConnectorReadThread::Entry] Beginning thread.
2010/01/09 12:08:17.136: [- Main -][wxThreadedRead] Waiting for completion ...
2010/01/09 12:08:17.136: [00001640][ConnectorReadThread] Creating socket...
2010/01/09 12:08:17.136: [00001640][ConnectorReadThread] DNS lookup...
2010/01/09 12:08:17.143: [00001640][ConnectorReadThread] Socket connect...
2010/01/09 12:08:17.749: [00001640][ConnectorReadThread] Sending request...
2010/01/09 12:08:18.069: [00001640][ConnectorReadThread] Reading response...
2010/01/09 12:08:18.070: [00001640][ConnectorReadThread] Read complete.
2010/01/09 12:08:18.070: [00001640][ConnectorReadThread] Returning.
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Checking for Completion ...
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Waiting on the thread ...
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Getting data ...
2010/01/09 12:08:18.136: [- Main -][wxThreadedRead] Calling return ...
2010/01/09 12:08:18.140: [- Main -][Registration] License written to C:\Program Files (x86)\PokerTracker 3/Data/Config/PokerTracker.lic
2010/01/09 12:08:18.143: [- Main -][System] Registered: true
2010/01/09 12:08:18.143: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/content/He ... _v1.01.cfg
2010/01/09 12:08:18.144: [- Main -][wxThreadedRead] Starting read thread ...
2010/01/09 12:08:18.144: [000017F8][ConnectorReadThread] Thread [0x000017F8]: Begin
2010/01/09 12:08:18.144: [000017F8][ConnectorReadThread::Entry] Beginning thread.
2010/01/09 12:08:18.144: [000017F8][ConnectorReadThread] Creating socket...
2010/01/09 12:08:18.145: [- Main -][wxThreadedRead] Waiting for completion ...
2010/01/09 12:08:18.145: [000017F8][ConnectorReadThread] DNS lookup...
2010/01/09 12:08:18.146: [000017F8][ConnectorReadThread] Socket connect...
2010/01/09 12:08:18.552: [000017F8][ConnectorReadThread] Sending request...
2010/01/09 12:08:18.853: [000017F8][ConnectorReadThread] Reading response...
2010/01/09 12:08:19.222: [000017F8][ConnectorReadThread] Read complete.
2010/01/09 12:08:19.222: [000017F8][ConnectorReadThread] Returning.
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Checking for Completion ...
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Waiting on the thread ...
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Getting data ...
2010/01/09 12:08:19.395: [- Main -][wxThreadedRead] Calling return ...
2010/01/09 12:08:19.414: [- Main -][WindowSplash] Beginning load process
2010/01/09 12:08:19.416: [000017C0][WindowSplash::Worker::Entry] Beginning thread.
2010/01/09 12:08:19.416: [000017C0][WindowSplash::Worker] Thread [0x000017C0]: Begin
2010/01/09 12:08:19.416: [000017C0][QueryManager] Loading queries
2010/01/09 12:08:19.419: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Aliases.xml.pte
2010/01/09 12:08:19.422: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2010/01/09 12:08:19.445: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2010/01/09 12:08:19.455: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Notes.xml.pte
2010/01/09 12:08:19.458: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2010/01/09 12:08:19.482: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2010/01/09 12:08:19.493: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Players.xml.pte
2010/01/09 12:08:19.497: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2010/01/09 12:08:19.507: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2010/01/09 12:08:19.511: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.520: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2010/01/09 12:08:19.529: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2010/01/09 12:08:19.530: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2010/01/09 12:08:19.535: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2010/01/09 12:08:19.543: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2010/01/09 12:08:19.543: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2010/01/09 12:08:19.549: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.578: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2010/01/09 12:08:19.594: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2010/01/09 12:08:19.596: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2010/01/09 12:08:19.597: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.605: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2010/01/09 12:08:19.606: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2010/01/09 12:08:19.611: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2010/01/09 12:08:19.618: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.646: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2010/01/09 12:08:19.662: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2010/01/09 12:08:19.672: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2010/01/09 12:08:19.675: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.684: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2010/01/09 12:08:19.693: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2010/01/09 12:08:19.694: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2010/01/09 12:08:19.699: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2010/01/09 12:08:19.707: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2010/01/09 12:08:19.708: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2010/01/09 12:08:19.713: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.746: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2010/01/09 12:08:19.762: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2010/01/09 12:08:19.764: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2010/01/09 12:08:19.765: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2010/01/09 12:08:19.773: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2010/01/09 12:08:19.774: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2010/01/09 12:08:19.779: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2010/01/09 12:08:19.786: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2010/01/09 12:08:19.818: [000017C0][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2010/01/09 12:08:19.835: [000017C0][QueryManager] Queries loaded.
2010/01/09 12:08:19.835: [000017C0][StatManager] Loading stats and reports...
2010/01/09 12:08:20.782: [000017C0][StatManager] Stats and reports loaded.
2010/01/09 12:08:20.782: [000017C0][FilterManager] Loading filters...
2010/01/09 12:08:22.915: [000017C0][FilterManager] Filters loaded.
2010/01/09 12:08:22.915: [000017C0][LayoutManager] Loading layouts...
2010/01/09 12:08:23.167: [000017C0][StatManager] Loading stats and reports...
2010/01/09 12:08:24.113: [000017C0][StatManager] Stats and reports loaded.
2010/01/09 12:08:24.113: [000017C0][LayoutManager] Layouts loaded.
2010/01/09 12:08:24.116: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.150: [000017C0][PostgresConnection] [0x067b87d8] Successfully connected to: pt3_newdb [82176056] (PostgreSQL version 80402)
2010/01/09 12:08:24.164: [000017C0][ConnectionManager] Database Version: 300038
2010/01/09 12:08:24.167: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.200: [000017C0][PostgresConnection] [0x06806c18] Successfully connected to: pt3_newdb [82177096] (PostgreSQL version 80402)
2010/01/09 12:08:24.206: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.238: [000017C0][PostgresConnection] [0x06806e10] Successfully connected to: pt3_newdb [82176576] (PostgreSQL version 80402)
2010/01/09 12:08:24.244: [000017C0][PostgresConnection] Connecting to database: pt3_newdb
2010/01/09 12:08:24.277: [000017C0][PostgresConnection] [0x06806eb8] Successfully connected to: pt3_newdb [82177616] (PostgreSQL version 80402)
2010/01/09 12:08:24.282: [000017C0][WindowSplash::Worker::Entry] Ending thread.
2010/01/09 12:08:24.283: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2010/01/09 12:08:24.283: [- Main -][WindowSplash::checkProgress] Worker complete.
2010/01/09 12:08:24.471: [- Main -][Players] Buddies: 600:true:"----soy yo--";600:true:"---___Leon";600:true:"---alexandre";600:true:"---MIKKO---";600:true:"-- Z 91";600:true:"Zsld101";600:true:"zsmiki71";600:true:"Zsobo663";600:true:"Zsolt19";600:true:"Zsolt789";600:true:"zsoltF123";600:true:"zsoltmyy";600:true:"zsoszti";600:true:"ZSotol2";600:true:"zsozsozso";
2010/01/09 12:08:24.547: [- Main -][Players] 34239 buddies found
2010/01/09 12:08:27.264: [- Main -][System] Getting String:
2010/01/09 12:08:27.380: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:27.419: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:27.451: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:27.490: [- Main -][WindowStatsTab] Refreshing active player: false
2010/01/09 12:08:28.324: [- Main -][WindowMain] Database: handhq Size: 200 GB
2010/01/09 12:08:28.349: [00001508][ThreadPool] New thread created
2010/01/09 12:08:28.374: [00001508][Query::QueryThread] Thread [0x00001508]: Begin
2010/01/09 12:08:28.374: [00001508][Query] Connecting to database: handhq
2010/01/09 12:08:28.375: [00001508][Query] Executing SQL (Thread): SELECT player.id_player, player.id_site, player.player_name, player.val_icon FROM player WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player in ( SELECT DISTINCT omaha_table_session_summary.id_player FROM omaha_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2010/01/09 12:08:28.380: [00001508][Query] Query execution time: 4.90559495 ms :
2010/01/09 12:08:28.555: [00001508][QueryReportCtrl::Populate] Thread [0x00001508]: Begin
2010/01/09 12:08:28.555: [00001508][QueryReportCtrl] Query 1: Populate: 0.1870 ms, 0 rows, 6 cols, 0.0000 ms/col (time log: Query 1: t0: 0.0683 ms, t1: 0.0573 ms, t2: 0.0051 ms, t3: 0.0007 ms, t4: 0.0355 ms, t5: 0.0031 ms, t6: 0.0010 ms)
2010/01/09 12:08:38.432: [00000DE0][WindowDialogDatabaseHouseKeepProgress::Worker] Thread [0x00000DE0]: Begin
2010/01/09 12:08:38.433: [00000DE0][PostgresConnection] Beginning analyze.
2010/01/09 12:18:33.026: [00000DE0][PostgresConnection] Analyze complete.
2010/01/09 12:18:33.026: [00000DE0][PostgresConnection] Beginning cluster.
2010/01/09 12:53:11.031: [00000DE0][PostgresConnection (Error)] Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
2010/01/09 12:53:11.031: [00000DE0][PostgresConnection] Cluster complete.
2010/01/09 12:53:11.031: [00000DE0][WindowDialogDatabaseHouseKeepProgress (Error)] Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
2010/01/09 12:53:11.399: [000013D8][WindowDialogDatabaseHouseKeepProgress::Worker] Thread [0x000013D8]: Begin
2010/01/09 12:53:11.402: [000013D8][PostgresConnection] Beginning vacuum.

Re: cluster problem

PostPosted: Sat Jan 09, 2010 9:58 am
by kraada
That error normally means you're running out of hard drive space - did you purge a lot of hands recently? If so, try running vacuum first (expect it to take a long time), then cluster.

Re: cluster problem

PostPosted: Sat Jan 09, 2010 10:07 am
by petike2222
yes I have a big database, about 20-30 million hand. It's about 200 GB. But my hard drive is 1Tb and there is a 700 GB free space on it. I have never had problem earlier with clustering.It's usually running about 2-3 days but it's not a problem to me. The pt3 log file says I have 4 gb memory but really I have 12gb, why it's only see 4?

Re: cluster problem

PostPosted: Sat Jan 09, 2010 10:23 am
by kraada
Hrm that's a good question - try running the memory diagnostic tool and see if it comes up with anything.

Re: cluster problem

PostPosted: Sat Jan 09, 2010 11:51 am
by WhiteRider
Do you have 64-bit Windows?
Which drive is PostgreSQL itself installed on? (not necessarily where the database is stored?)

Re: cluster problem

PostPosted: Sat Jan 09, 2010 9:12 pm
by petike2222
I have win 7 64bit, the newest 8.4 postgres version on the System partition, but my database is on another raid0 partition. I run holdem manager and it says the same problem when I import hands, but the 2nd try I can Import all hands. The log say I have 2gb virtual memory and 4 gb page file, but I switched off both of them. Can I run 2 versions of postgres at the same time? Perhaps I install the 8.3 and check whats happen. The hands import only takes 30 hours:).

Re: cluster problem

PostPosted: Sun Jan 10, 2010 12:03 am
by petike2222
I had run the memory test but it didn't find any problem.

Re: cluster problem

PostPosted: Sun Jan 10, 2010 5:21 am
by WhiteRider
It's possible that the cluster is using the drive that postgres is installed on, rather than the drive that the database is saved on. When you get the message have a look at the amount of space you have on the c: drive (I assume that's where your system is?).

Re: cluster problem

PostPosted: Sun Jan 10, 2010 6:11 pm
by tarix
Did you modify any settings in your postgres.conf file?

highfalutin