Testy JXColl_3.1

Scenar 1 - Toky

-pri testoch bezalo naraz 5 torrentov (debian, ubuntu9.10, ubuntu9.04, fedora, mint7)

-v konfiguracii exportera bol nasteveny passive timeout = active timeout = 0

TEST 14.11.2009 20:15

JXColl.conf: loglevel = ALL

20:15
count: 3761703
java: 3%/3%   (CPU/RAM)
beem: 10%/19.2%
connections: 61
total download/upload (per second): 5600/20

20:43
count: 3768620
java: 0.3%/3.2%   (CPU/RAM)
beem: 8.3%/19.2%
connections: 56
total download/upload (per second): 6370/42
total CPU/RAM: 55%/1017MB

21:51
connections: 120

23:22
connections: 142

15.11. 12:12
count: 3881857
java: 0.3%/4.8%
beem: 0.0%/19.2%

18:53
count: 4180793 (dalej nepribuda)

-tu sa prestali pridavat zaznamy do databazy, kolektor poslednych 12 hodin vypisoval toto:

140295943 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140295945 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140295945 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140295945 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140315946 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140315947 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140315949 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140315949 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140315949 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140335950 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140335950 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140335953 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140335953 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140335953 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140355954 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140355954 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140355957 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140355957 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140355957 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140375958 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140375958 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140375961 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140375961 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140375961 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140395962 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140395962 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140395965 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140395965 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140395965 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140415966 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140415966 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140415969 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140415969 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140415969 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140435970 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140435970 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140435973 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140435973 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140435973 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140455974 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140455974 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140455977 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140455977 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140455977 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140475978 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140475978 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140476006 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140476006 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140476006 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140496008 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140496008 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140496011 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140496011 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140496011 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.
140516013 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Connecting to DB for Accounting.
140516013 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Connecting to bm@jdbc:postgresql://127.0.0.1:5432/bm2...
140516016 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - ok.
140516016 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.export.DBExport  - Disconnected from bm@jdbc:postgresql://127.0.0.1:5432/bm2.
140516016 [Timer-0] DEBUG sk.tuke.cnl.bm.JXColl.accounting.AccountingRecordsExporter  - Disconnecting from DB for Accounting.

-vsetky vypisy kolektora su ulozene v subore, kt. je k dispozicii v mojom priecinku na qos-meter.cnl.tuke.sk: /home/RastislavKudla/testlogy/14112015

- kedze loglevel bol nastaveny na ALL, subor ma az okolo 1300MB

TEST 21.11.2009 00:36

JXColl.conf: loglevel = ERROR

00:36
count: 4229278
java: 10.3%/2.9%
beem: 0.3%/19.2%
connections: 70

12:02
count: 4640415
java: 0.3%/8.9%
beem: 0.3%/19.2%

22.11. 13:06
count: 4652912 (dalej nepribuda)

-posledne riadky:

42060569 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060575 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060580 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060586 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060592 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060657 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060663 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060668 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060674 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060680 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060685 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060733 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060774 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060780 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060785 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060791 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060797 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060869 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060895 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060901 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060906 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060912 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060918 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060923 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060961 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060967 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060973 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060979 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060985 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060991 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42060999 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".
42061055 [Timer-0] ERROR sk.tuke.cnl.bm.JXColl.export.DBExport  - org.postgresql.util.PSQLException: ERROR: insert or update on table "acc_record" violates foreign key constraint "$1"
  Detail: Key (user_id)=(2) is not present in table "acc_user".

-podla casu poslednej zmeny logovacieho suboru zastal kolektor 21.11.2009 12:09

- logsubor je k dispozicii na stiahnutie v mojom priecinku na qos-meter.cnl.tuke.sk: /home/RastislavKudla/testlogy/21110036

- tento error sa vypisoval od zaciatku spustenia kolektora, nie len na konci predtym ako prestal posielat udaje do databazy

Scenar 2 - Pakety

...

Scenar 3 - Rozne objemy

...