v55 titan kein import von händen

    • SirWeyroth
      SirWeyroth
      Bronze
      Dabei seit: 26.10.2005 Beiträge: 75
      Hallo,

      folgendes Problem:

      Der Elephant importiert mir keine Handhistorys. (PP, PS, und TP HH versucht)
      Er liest die dateien aus aber danach macht er nicht weiter, der analyse schritt erfolgt also nicht. Der Elephant stürzt dabei nicht ab sondern er arbeitet einfach nicht weiter. Jeder Versuch auf eine andere komponente zuzugreifen verhindert er mit "bitte warten bis import abgeschlossen". Um den Elephant zu schließen musste ich jedesmal den Prozess selbst killen.
      Dazu kommt noch das der Elephant deutlich langsamer zu sein scheint als auf meinem Laptop, obwohl mein PC ca 1GHz mehr hat. (beides DualCore CPUs)
      Auf meinem Laptop hatte ich das Problem das mir der Elephant zwar Hände Importiert, aber schon bei einer Datenbank von 50k Händen und 4 geöffneten Tischen andauernd freezt. Die in den entsprechenden Threats geposteten vorschläge gegen Freezes haben nichts gebracht.

      noch die Daten zu meinem Laptop und PC:

      Laptop:
      2,4 GHz DualCore (Intel)
      2GB RAM

      PC:
      3,2 GHz DualCore (Intel)
      2GB RAM

      hier noch das Logfile von meinem PC:

      OS: Microsoft Windows NT 5.1.2600 Service Pack 2
      .NET Runtime: 2.0.50727.1433
      RAM: 2GB
      Processors: 2
      CPU: x86 Family 15 Model 6 Stepping 4: 0/32/2, 3211
      x86 Family 15 Model 6 Stepping 4: 0/32/2, 3211

      Software version: 0.55

      (10) 16:48:38.53 -- Logfile cleared: C:\Dokumente und Einstellungen\MMotH\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) 16:49:12.28 -- CREATE or REPLACE FUNCTION update_unreviewed_count_delete () RETURNS trigger AS $BODY$ DECLARE gplayer RECORD; BEGIN IF OLD.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=OLD.game_id AND site_id=OLD.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed -1 WHERE dateonly=''' || OLD.dateonly || ''' AND game_type_id=' || OLD.game_type_id || ' AND site_id=' || OLD.site_id || ' AND num_players=' || OLD.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; RETURN OLD; END; $BODY$ LANGUAGE 'plpgsql';
      (10) 16:49:12.29 -- , line 0: Npgsql.NpgsqlException:
      (10) language "plpgsql" does not exist
      (10) Severity: ERROR
      (10) Code: 42704
      (10) Hint: Use CREATE LANGUAGE to load the language into the database.
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.35 -- CREATE or REPLACE FUNCTION update_unreviewed_count_insert () RETURNS trigger AS $BODY$ DECLARE gplayer RECORD; BEGIN IF NEW.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=NEW.game_id AND site_id=NEW.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed +1 WHERE dateonly=''' || NEW.dateonly || ''' AND game_type_id=' || NEW.game_type_id || ' AND site_id=' || NEW.site_id || ' AND num_players=' || NEW.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql';
      (10) 16:49:12.35 -- , line 0: Npgsql.NpgsqlException:
      (10) language "plpgsql" does not exist
      (10) Severity: ERROR
      (10) Code: 42704
      (10) Hint: Use CREATE LANGUAGE to load the language into the database.
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.43 -- CREATE or REPLACE FUNCTION update_unreviewed_count_update () RETURNS trigger AS $BODY$ DECLARE gplayer RECORD; BEGIN IF NEW.marked<>OLD.marked THEN IF OLD.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=OLD.game_id AND site_id=OLD.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed -1 WHERE dateonly=''' || OLD.dateonly || ''' AND game_type_id=' || OLD.game_type_id || ' AND site_id=' || OLD.site_id || ' AND num_players=' || OLD.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; IF NEW.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=OLD.game_id AND site_id=OLD.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed +1 WHERE dateonly=''' || OLD.dateonly || ''' AND game_type_id=' || OLD.game_type_id || ' AND site_id=' || OLD.site_id || ' AND num_players=' || OLD.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; END IF; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql';
      (10) 16:49:12.43 -- , line 0: Npgsql.NpgsqlException:
      (10) language "plpgsql" does not exist
      (10) Severity: ERROR
      (10) Code: 42704
      (10) Hint: Use CREATE LANGUAGE to load the language into the database.
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.50 -- CREATE or REPLACE FUNCTION insert_or_replace_playercache() RETURNS trigger AS $BODY$ BEGIN DELETE FROM playercache WHERE playercache.player_id = new.player_id AND playercache.site_id = new.site_id AND playercache.num_players = new.num_players AND playercache.game_type_id = new.game_type_id AND playercache.dateonly = new.dateonly; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql';
      (10) 16:49:12.50 -- , line 0: Npgsql.NpgsqlException:
      (10) language "plpgsql" does not exist
      (10) Severity: ERROR
      (10) Code: 42704
      (10) Hint: Use CREATE LANGUAGE to load the language into the database.
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.56 -- ALTER FUNCTION update_unreviewed_count_delete() OWNER TO "Poker";
      (10) 16:49:12.56 -- , line 0: Npgsql.NpgsqlException:
      (10) function update_unreviewed_count_delete() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.62 -- ALTER FUNCTION update_unreviewed_count_insert() OWNER TO "Poker";
      (10) 16:49:12.62 -- , line 0: Npgsql.NpgsqlException:
      (10) function update_unreviewed_count_insert() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.68 -- ALTER FUNCTION update_unreviewed_count_update() OWNER TO "Poker";
      (10) 16:49:12.68 -- , line 0: Npgsql.NpgsqlException:
      (10) function update_unreviewed_count_update() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.75 -- ALTER FUNCTION insert_or_replace_playercache() OWNER TO "Poker";
      (10) 16:49:12.75 -- , line 0: Npgsql.NpgsqlException:
      (10) function insert_or_replace_playercache() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.81 -- CREATE TRIGGER unreviewed_delete AFTER DELETE ON game FOR EACH ROW EXECUTE PROCEDURE update_unreviewed_count_delete();
      (10) 16:49:12.81 -- , line 0: Npgsql.NpgsqlException:
      (10) function update_unreviewed_count_delete() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.87 -- CREATE TRIGGER unreviewed_insert AFTER INSERT ON game FOR EACH ROW EXECUTE PROCEDURE update_unreviewed_count_insert();
      (10) 16:49:12.89 -- , line 0: Npgsql.NpgsqlException:
      (10) function update_unreviewed_count_insert() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:12.93 -- CREATE TRIGGER unreviewed_update AFTER UPDATE ON game FOR EACH ROW EXECUTE PROCEDURE update_unreviewed_count_update();
      (10) 16:49:12.95 -- , line 0: Npgsql.NpgsqlException:
      (10) function update_unreviewed_count_update() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:13.01 -- CREATE TRIGGER insert_into_playercache BEFORE INSERT ON playercache FOR EACH ROW EXECUTE PROCEDURE insert_or_replace_playercache();
      (10) 16:49:13.01 -- , line 0: Npgsql.NpgsqlException:
      (10) function insert_or_replace_playercache() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:13.07 -- CREATE or REPLACE FUNCTION deflag_archive() RETURNS trigger AS $BODY$ BEGIN EXECUTE 'DELETE FROM triggstop'; IF NEW.actiontype='imported' THEN EXECUTE 'UPDATE archive SET imported=''true'' WHERE imported=''false'''; RETURN OLD; ELSE RETURN NEW; END IF; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE;
      (10) 16:49:13.07 -- , line 0: Npgsql.NpgsqlException:
      (10) language "plpgsql" does not exist
      (10) Severity: ERROR
      (10) Code: 42704
      (10) Hint: Use CREATE LANGUAGE to load the language into the database.
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) 16:49:13.20 -- CREATE TRIGGER deflag_archive BEFORE INSERT ON triggstop FOR EACH ROW EXECUTE PROCEDURE deflag_archive();
      (10) 16:49:13.21 -- , line 0: Npgsql.NpgsqlException:
      (10) function deflag_archive() does not exist
      (10) Severity: ERROR
      (10) Code: 42883
      (10) bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      (10) bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      (10) bei Npgsql.ForwardsOnlyDataReader.NextResult()
      (10) bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      (10) bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      (10) bei Npgsql.NpgsqlCommand.ExecuteNonQuery()
      (10) bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)

      Herzlichen Dank für die sicherlich schnelle Antwort.

      SirWeyroth

      PS: Das Programm ist wirklich gut. Nur bitte bringt schnell die Kinderkrankheiten weg.
  • 11 Antworten