v69 buglog

    • smokinnurse
      smokinnurse
      Bronze
      Dabei seit: 26.03.2007 Beiträge: 14.745
      OS: Microsoft Windows NT 5.0.2195 Service Pack 4
      .NET Runtime: 2.0.50727.1433
      RAM: 0GB
      Processors: 1
      CPU: x86 Family 6 Model 10 Stepping 0: 0/32/29, 1150

      Software version: 0.69

      (10) Log: 15:12:20.75 -- Logfile set: C:\Dokumente und Einstellungen\Administrator\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) Log: 15:12:20.82 -- Logfile cleared: C:\Dokumente und Einstellungen\Administrator\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) Log: 21:27:43.95 -- SELECT player_id::bigint, site_id::integer, num_players::integer, game_type_id::integer, dateonly, position, num_games::integer, winner::integer, won_sd::integer, won_flop::integer, subject_to_steal::integer, folded_to_steal::integer, called_to_steal::integer, raised_to_steal::integer, preflop_raise::integer, bets_and_raises::integer, num_actions::integer, fa_pf_fold::integer, fa_pf_call::integer, fa_pf_bet::integer, bet_vs_steal_pre::numeric(10,4), bet_vs_steal_post::numeric(10,4), amount_won::numeric(10,4), rake_part::numeric(8,2), seen_flop::integer, seen_turn::integer, seen_river::integer, seen_showdown::integer, fold_preflop::integer, fold_flop::integer, fold_turn::integer, fold_river::integer, agg_inv_pot_bets_flop::numeric(10,4), agg_inv_pot_bets_turn::numeric(10,4), agg_inv_pot_bets_river::numeric(10,4), agg_inv_pot_bets_avg::numeric(10,4), pas_inv_pot_bets_flop::numeric(10,4), pas_inv_pot_bets_turn::numeric(10,4), pas_inv_pot_bets_river::numeric(10,4), pas_inv_pot_bets_avg::numeric(10,4), bb_pf_vs_husa::numeric(10,4), agg_inv_bb_flop::numeric(10,4), agg_inv_bb_turn::numeric(10,4), agg_inv_bb_river::numeric(10,4), pas_inv_bb_flop::numeric(10,4), pas_inv_bb_turn::numeric(10,4), pas_inv_bb_river::numeric(10,4), af_br_flop::integer, af_br_turn::integer, af_br_river::integer, af_br_total::integer, af_ca_flop::integer, af_ca_turn::integer, af_ca_river::integer, af_ca_total::integer, num_marked::integer, num_unreviewed::integer, pfm_fold::integer, pfm_call::integer, pfm_raise::integer, pfm_2bet::integer, pfm_3bet::integer, pfm_4bet::integer, pfm_2bet_poss::integer, pfm_3bet_poss::integer, pfm_4bet_poss::integer, pfm_rangeflop::integer, vpip::integer, cb_flop::integer, cb_turn::integer, cb_river::integer, fold_cb_flop::integer, fold_cb_turn::integer, fold_cb_river::integer, call_cb_flop::integer, call_cb_turn::integer, call_cb_river::integer, raise_cb_flop::integer, raise_cb_turn::integer, raise_cb_river::integer, cb_poss_flop::integer, cb_poss_turn::integer, cb_poss_river::integer, first_in_poss::integer, first_fold::integer, first_call::integer, first_raise::integer, sbfr_bbf::integer, sbfr_bbc::integer, sbfr_bbr::integer, sbfc_bbc::integer, sbfc_bbr::integer, fold_steal_vs_b3b_sb::integer, call_steal_vs_b3b_sb::integer, raise_steal_vs_b3b_sb::integer, fold_steal_vs_b3b_bb::integer, call_steal_vs_b3b_bb::integer, raise_steal_vs_b3b_bb::integer, pfm_or_poss::integer, pfm_or::integer, pfm_pfr::integer, pfm_rvsl::integer, pfm_rvsl_fold::integer, pfm_opencall::integer, pfm_fa_f2b::integer, pfm_fa_c2b::integer, pfm_fa_r2b::integer, pfm_fa_f3b::integer, pfm_fa_c3b::integer, pfm_fa_r3b::integer, pfm_lrr_poss::integer, pfm_lrr::integer, pfm_ol_poss::integer, pfm_ol::integer, wtsd_wrf::integer, wtsd_wrt::integer, wtsd_wrr::integer, won_sd_wrf::integer, won_sd_wrt::integer, won_sd_wrr::integer, db_vs_pfa_poss::integer, db_vs_pfa::integer, subject_to_db_pfa::integer, fold_db_pfa::integer, call_db_pfa::integer, raise_db_pfa::integer, amcb_cf::integer, amcb_bf::integer, amcb_ct::integer, amcb_bt::integer, amcb_cr::integer, amcb_br::integer, flop_3b_poss::integer, flop_3b::integer, turn_3b_poss::integer, turn_3b::integer, river_3b_poss::integer, river_3b::integer, fsdr_poss::integer, fsdr::integer, amcb_flop::integer, amcb_turn::integer, amcb_river::integer, crflop_poss::integer, crflop::integer, crturn_poss::integer, crturn::integer, crriver_poss::integer, crriver::integer, squeeze_poss::integer, squeeze::integer, std_dev_bb::numeric(10,4), money_per_hour::numeric(10,4), money_per_hh::numeric(10,4), db_vs_pfa_turn::integer, db_vs_pfa_turn_poss::integer, db_vs_pfa_river::integer, db_vs_pfa_river_poss::integer, check_from_bb::integer, amcb_cf_ip::integer, amcb_bf_ip::integer, amcb_ct_ip::integer, amcb_bt_ip::integer, amcb_cr_ip::integer, amcb_br_ip::integer, amcb_cf_oop::integer, amcb_cf_oop::integer, amcb_ct_oop::integer, amcb_bt_oop::integer, amcb_cr_oop::integer, amcb_cr_oop::integer, amcb_flop_ip::integer, amcb_turn_ip::integer, amcb_river_ip::integer, amcb_flop_oop::integer, amcb_turn_oop::integer, amcb_river_oop::integer, cb_flop_ip::integer, cb_turn_ip::integer, cb_river_ip::integer, fold_cb_flop_ip::integer, fold_cb_turn_ip::integer, fold_cb_river_ip::integer, call_cb_flop_ip::integer, call_cb_turn_ip::integer, call_cb_river_ip::integer, raise_cb_flop_ip::integer, raise_cb_turn_ip::integer, raise_cb_river_ip::integer, cb_flop_poss_ip::integer, cb_turn_poss_ip::integer, cb_river_poss_ip::integer, cb_flop_oop::integer, cb_turn_oop::integer, cb_river_oop::integer, fold_cb_flop_oop::integer, fold_cb_turn_oop::integer, fold_cb_river_oop::integer, call_cb_flop_oop::integer, call_cb_turn_oop::integer, call_cb_river_oop::integer, raise_cb_flop_oop::integer, raise_cb_turn_oop::integer, raise_cb_river_oop::integer, cb_flop_poss_oop::integer, cb_turn_poss_oop::integer, cb_river_poss_oop::integer, subj2db_turn::integer, fold_db_turn::integer, call_db_turn::integer, raise_db_turn::integer, subj2db_river::integer, fold_db_river::integer, call_db_river::integer, raise_db_river::integer, pfm_on3bet_fold::integer, pfm_on3bet_call::integer, pfm_on3bet_raise::integer, pfm_on4bet_fold::integer, pfm_on4bet_call::integer, pfm_on4bet_raise::integer, pfm_oncoor_bu3bet::integer, pfm_subj2coor_bu::integer FROM playercache WHERE game_type_id='10' AND player_id='6' AND site_id='3' AND dateonly='2009-08-27' AND num_players='9' AND position='BU'
      (10) Log: 21:27:45.14 -- , line 0: Npgsql.NpgsqlException:
      numeric field overflow
      Severity: ERROR
      Code: 22003
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      numeric field overflow
      Severity: ERROR
      Code: 22003
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      numeric field overflow
      Severity: ERROR
      Code: 22003
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      numeric field overflow
      Severity: ERROR
      Code: 22003
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      numeric field overflow
      Severity: ERROR
      Code: 22003
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      numeric field overflow
      Severity: ERROR
      Code: 22003
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
  • 8 Antworten
    • smokinnurse
      smokinnurse
      Bronze
      Dabei seit: 26.03.2007 Beiträge: 14.745
      21:27 gabs nur 2 hände, vielleicht hilfst ja, wenn ich die HHs dazu mit reinstelle
      (20:27 CET bei stars ist 21:27 im elephant)


      PokerStars Game #32122223210: Hold'em No Limit ($1/$2) - 2009/08/27 20:26:46 CET [2009/08/27 14:26:46 ET]
      Table 'Tournament 188959503 Table 126' 9-max Seat #7 is the button
      Seat 1: Ginsipower ($5190 in chips)
      Seat 2: pete235 ($4280 in chips)
      Seat 3: Yergsword ($6500 in chips)
      Seat 4: HARZ IV ($3775 in chips)
      Seat 5: nurse-gr ($3295 in chips)
      Seat 6: franjokoeln ($600 in chips)
      Seat 7: diceman-Jim ($15120 in chips)
      Seat 8: shaunberaldi ($10420 in chips)
      Seat 9: schmelleA ($5735 in chips)
      shaunberaldi: posts small blind $100
      schmelleA: posts big blind $200
      *** HOLE CARDS ***
      Dealt to nurse-gr [Ah 7s]
      Ginsipower: folds
      pete235: folds
      Yergsword: folds
      HARZ IV: folds
      nurse-gr: folds
      franjokoeln: folds
      diceman-Jim: calls $200
      shaunberaldi: folds
      schmelleA: checks
      *** FLOP *** [Kc 7h 3c]
      schmelleA: checks
      diceman-Jim: bets $200
      schmelleA: calls $200
      *** TURN *** [Kc 7h 3c] [2s]
      schmelleA: checks
      diceman-Jim: bets $400
      schmelleA: calls $400
      *** RIVER *** [Kc 7h 3c 2s] [6c]
      schmelleA: checks
      diceman-Jim: checks
      *** SHOW DOWN ***
      schmelleA: shows [Td As] (high card Ace)
      diceman-Jim: shows [9h Kh] (a pair of Kings)
      diceman-Jim collected $1700 from pot
      *** SUMMARY ***
      Total pot $1700 | Rake $0
      Board [Kc 7h 3c 2s 6c]
      Seat 1: Ginsipower folded before Flop (didn't bet)
      Seat 2: pete235 folded before Flop (didn't bet)
      Seat 3: Yergsword folded before Flop (didn't bet)
      Seat 4: HARZ IV folded before Flop (didn't bet)
      Seat 5: nurse-gr folded before Flop (didn't bet)
      Seat 6: franjokoeln folded before Flop (didn't bet)
      Seat 7: diceman-Jim (button) showed [9h Kh] and won (1700) with a pair of Kings
      Seat 8: shaunberaldi (small blind) folded before Flop
      Seat 9: schmelleA (big blind) showed [Td As] and lost with high card Ace



      PokerStars Game #32122249519: Hold'em No Limit ($1/$2) - 2009/08/27 20:27:28 CET [2009/08/27 14:27:28 ET]
      Table 'Tournament 188959503 Table 126' 9-max Seat #8 is the button
      Seat 1: Ginsipower ($5190 in chips)
      Seat 2: pete235 ($4280 in chips)
      Seat 3: Yergsword ($6500 in chips)
      Seat 4: HARZ IV ($3775 in chips)
      Seat 5: nurse-gr ($3295 in chips)
      Seat 6: franjokoeln ($600 in chips)
      Seat 7: diceman-Jim ($16020 in chips)
      Seat 8: shaunberaldi ($10320 in chips)
      Seat 9: schmelleA ($4935 in chips)
      schmelleA: posts small blind $100
      Ginsipower: posts big blind $200
      *** HOLE CARDS ***
      Dealt to nurse-gr [Th Jd]
      pete235: folds
      Yergsword: folds
      HARZ IV: folds
      nurse-gr: folds
      franjokoeln: folds
      diceman-Jim: folds
      shaunberaldi: folds
      schmelleA: calls $100
      Ginsipower: checks
      *** FLOP *** [6s 3h 3s]
      schmelleA: checks
      Ginsipower: checks
      *** TURN *** [6s 3h 3s] [5h]
      schmelleA: bets $400
      Ginsipower: folds
      Uncalled bet ($400) returned to schmelleA
      schmelleA collected $400 from pot
      schmelleA: doesn't show hand
      *** SUMMARY ***
      Total pot $400 | Rake $0
      Board [6s 3h 3s 5h]
      Seat 1: Ginsipower (big blind) folded on the Turn
      Seat 2: pete235 folded before Flop (didn't bet)
      Seat 3: Yergsword folded before Flop (didn't bet)
      Seat 4: HARZ IV folded before Flop (didn't bet)
      Seat 5: nurse-gr folded before Flop (didn't bet)
      Seat 6: franjokoeln folded before Flop (didn't bet)
      Seat 7: diceman-Jim folded before Flop (didn't bet)
      Seat 8: shaunberaldi (button) folded before Flop (didn't bet)
      Seat 9: schmelleA (small blind) collected ($400)
    • mrk1988
      mrk1988
      Bronze
      Dabei seit: 04.02.2007 Beiträge: 13.337
      Huch ?( Experten sind informiert =)
    • smokinnurse
      smokinnurse
      Bronze
      Dabei seit: 26.03.2007 Beiträge: 14.745
      ^^
    • PS.Markus
      PS.Markus
      Bronze
      Dabei seit: 12.05.2009 Beiträge: 455
      Moin,

      hab's nachgestellt, kann aber den Fehler nicht nachvollziehen. Wahrscheinlich liegt das Problem an einem aggregierten Wert ueber eine ganze Reihe von Haenden.

      Schick mir bitte mal das PostgreSQL Log (elephant@ps).

      Original von smokinnurse
      21:27 gabs nur 2 hände, vielleicht hilfst ja, wenn ich die HHs dazu mit reinstelle
      (20:27 CET bei stars ist 21:27 im elephant)
      CET ist Central European Time (GMT+1). Im Moment ist aber Sommerzeit (CEST, GMT+2), daher der Unterschied. Der Elephant rechnet das dementsprechend richtig um.

      Cheers,
      M.
    • smokinnurse
      smokinnurse
      Bronze
      Dabei seit: 26.03.2007 Beiträge: 14.745
      Original von PS.Markus
      Schick mir bitte mal das PostgreSQL Log (elephant@ps).
      wie heisst das file denn?


      was CET/CEST betrifft ... ich wollts nicht bemängeln, sondern nur erklären, woher die stunde unterschied kommt ;-)
    • PS.Markus
      PS.Markus
      Bronze
      Dabei seit: 12.05.2009 Beiträge: 455
      Original von smokinnurse
      Original von PS.Markus
      Schick mir bitte mal das PostgreSQL Log (elephant@ps).
      wie heisst das file denn?
      Die Logs liegen im PostgreSQL Installations-Ordner unter data\pg_log also wahrscheinlich C:\Program Files\PostgreSQL\8.3\data\pg_log. Die Dinger sollten nach Datum sortiert sein.

      ad CET/CEST: :)

      Cheers,
      M.
    • smokinnurse
      smokinnurse
      Bronze
      Dabei seit: 26.03.2007 Beiträge: 14.745
      jo, gefunden
      wollte es der einfachheit hier posten, geht aber nicht, kommt nur ein FDWDHF ... wtf?

      dann also doch geschickt
    • PS.Markus
      PS.Markus
      Bronze
      Dabei seit: 12.05.2009 Beiträge: 455
      Moin,

      hab's bekommen, ist leider auch nicht aussagekraeftiger.

      Das Problem ist jedenfalls einer dieser Werte:
      bet_vs_steal_pre
      bet_vs_steal_post
      amount_won
      agg_inv_pot_bets_flop
      agg_inv_pot_bets_turn
      agg_inv_pot_bets_river
      agg_inv_pot_bets_avg
      pas_inv_pot_bets_flop
      pas_inv_pot_bets_turn
      pas_inv_pot_bets_river
      pas_inv_pot_bets_avg
      bb_pf_vs_husa
      agg_inv_bb_flop
      agg_inv_bb_turn
      agg_inv_bb_river
      pas_inv_bb_flop
      pas_inv_bb_turn
      pas_inv_bb_river::numeric
      std_dev_bb
      money_per_hour
      money_per_hh

      Das Format wurde hier auf 6 Stellen vor und 4 Stellen nach dem Komma festgelegt (Frag mich bitte nicht wieso...). Bei Werten ueber 10^6 kracht's dann. Nunja.

      Ich schau mal, ob wir das ad hoc erweitern koennen...

      Cheers,
      M.