ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/testsuite/FB4reference.log
(Generate patch)

Comparing ibx/trunk/testsuite/FB4reference.log (file contents):
Revision 319 by tony, Thu Feb 25 12:05:40 2021 UTC vs.
Revision 323 by tony, Thu Feb 25 12:14:35 2021 UTC

# Line 1445 | Line 1445 | DPB: Item Count = 3
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 16 ms
1448 > inet://localhost/employee Disconnected after 17 ms
1449   Before Connect
1450   Connected to inet://localhost/employee
1451   DPB: Item Count = 3
# Line 1454 | Line 1454 | DPB: Item Count = 3
1454    isc_dpb_lc_ctype = UTF8
1455  
1456   Before Disconnect
1457 < inet://localhost/employee Disconnected after 4023 ms
1457 > inet://localhost/employee Disconnected after 4027 ms
1458   Idle Timer Expired for Test_Database_02
1459   Database Closed
1460   Transaction Events
# Line 1477 | Line 1477 | TPB: Item Count = 3
1477    isc_tpb_read
1478  
1479   Transaction Ending
1480 < Transaction Ended after 1 ms
1480 > Transaction Ended after 0 ms
1481   Transaction idle timer test
1482   Requested TPB: Item Count = 3
1483    isc_tpb_concurrency
# Line 1491 | Line 1491 | TPB: Item Count = 3
1491    isc_tpb_read
1492  
1493   Transaction Ending
1494 < Transaction Ended after 2001 ms
1494 > Transaction Ended after 2000 ms
1495   Idle Timer Expired for Test_Transaction_02
1496   Before Disconnect
1497 < inet://localhost/employee Disconnected after 2042 ms
1497 > inet://localhost/employee Disconnected after 2035 ms
1498   SQL Dialect Downgrade test
1499   Before Connect
1500   Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
# Line 1516 | Line 1516 | DPB: Item Count = 3
1516    isc_dpb_lc_ctype = UTF8
1517  
1518   Before Disconnect
1519 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 3300 | Line 3300 | DEPT_KEY_PATH = 000;600;620;622 (Charset
3300   Current memory = 19,651,184
3301   Delta memory = 16,416
3302   Max memory = 19,746,848
3303 < Elapsed time= 0.024 sec
3303 > Elapsed time= 0.009 sec
3304   Cpu = 0.000 sec
3305   Buffers = 2048
3306   Reads = 2
# Line 11779 | Line 11779 | Message File Location = /opt/firebird4rc
11779   Database Statistics for employee
11780  
11781   Database "/opt/firebird4rc1/examples/empbuild/employee.fdb"
11782 < Gstat execution time Thu Feb 18 17:07:27 2021
11782 > Gstat execution time Mon Feb 22 10:41:04 2021
11783  
11784   Database header page information:
11785   Flags                   0
11786 < Generation              1016
11786 > Generation              1138
11787   System Change Number    0
11788   Page size               8192
11789   ODS version             13.0
11790 < Oldest transaction      1192
11791 < Oldest active           1193
11792 < Oldest snapshot         1193
11793 < Next transaction        1193
11790 > Oldest transaction      1346
11791 > Oldest active           1347
11792 > Oldest snapshot         1347
11793 > Next transaction        1347
11794   Sequence number         0
11795 < Next attachment ID      899
11795 > Next attachment ID      1067
11796   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
11797   Shadow count            0
11798   Page buffers            0
# Line 11940 | Line 11940 | Fill distribution:
11940   60 - 79% = 0
11941   80 - 99% = 0
11942  
11943 < Gstat completion time Thu Feb 18 17:07:28 2021
11943 > Gstat completion time Mon Feb 22 10:41:04 2021
11944  
11945  
11946  
# Line 11950 | Line 11950 | zeus   Thu Feb 11 14:23:45 2021
11950   firebird4rc1/bin/fbguard: guardian starting /opt/firebird4rc1/bin/firebird
11951  
11952   Online Validation
11953 < 17:07:32.35 Validation started
11953 > 10:41:08.75 Validation started
11954  
11955 < 17:07:32.35 Relation 128 (COUNTRY)
11956 < 17:07:32.35   process pointer page    0 of    1
11957 < 17:07:32.35 Index 1 (RDB$PRIMARY1)
11958 < 17:07:32.35 Relation 128 (COUNTRY) is ok
11959 <
11960 < 17:07:32.35 Relation 129 (JOB)
11961 < 17:07:32.35   process pointer page    0 of    1
11962 < 17:07:32.35 Index 1 (RDB$PRIMARY2)
11963 < 17:07:32.35 Index 2 (RDB$FOREIGN3)
11964 < 17:07:32.35 Index 3 (MAXSALX)
11965 < 17:07:32.35 Index 4 (MINSALX)
11966 < 17:07:32.35 Relation 129 (JOB) is ok
11967 <
11968 < 17:07:32.35 Relation 130 (DEPARTMENT)
11969 < 17:07:32.35   process pointer page    0 of    1
11970 < 17:07:32.35 Index 1 (RDB$4)
11971 < 17:07:32.35 Index 2 (RDB$PRIMARY5)
11972 < 17:07:32.35 Index 3 (RDB$FOREIGN6)
11973 < 17:07:32.35 Index 4 (BUDGETX)
11974 < 17:07:32.35 Index 5 (RDB$FOREIGN10)
11975 < 17:07:32.35 Relation 130 (DEPARTMENT) is ok
11976 <
11977 < 17:07:32.35 Relation 131 (EMPLOYEE)
11978 < 17:07:32.35   process pointer page    0 of    1
11979 < 17:07:32.35 Index 1 (RDB$PRIMARY7)
11980 < 17:07:32.35 Index 2 (RDB$FOREIGN8)
11981 < 17:07:32.35 Index 3 (RDB$FOREIGN9)
11982 < 17:07:32.35 Index 4 (NAMEX)
11983 < 17:07:32.35 Relation 131 (EMPLOYEE) is ok
11984 <
11985 < 17:07:32.35 Relation 133 (PROJECT)
11986 < 17:07:32.35   process pointer page    0 of    1
11987 < 17:07:32.35 Index 1 (RDB$11)
11988 < 17:07:32.35 Index 2 (RDB$PRIMARY12)
11989 < 17:07:32.35 Index 3 (RDB$FOREIGN13)
11990 < 17:07:32.35 Index 4 (PRODTYPEX)
11991 < 17:07:32.35 Relation 133 (PROJECT) is ok
11992 <
11993 < 17:07:32.35 Relation 134 (EMPLOYEE_PROJECT)
11994 < 17:07:32.35   process pointer page    0 of    1
11995 < 17:07:32.35 Index 1 (RDB$PRIMARY14)
11996 < 17:07:32.35 Index 2 (RDB$FOREIGN15)
11997 < 17:07:32.35 Index 3 (RDB$FOREIGN16)
11998 < 17:07:32.35 Relation 134 (EMPLOYEE_PROJECT) is ok
11999 <
12000 < 17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET)
12001 < 17:07:32.35   process pointer page    0 of    1
12002 < 17:07:32.35 Index 1 (RDB$PRIMARY17)
12003 < 17:07:32.35 Index 2 (RDB$FOREIGN18)
12004 < 17:07:32.35 Index 3 (RDB$FOREIGN19)
12005 < 17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET) is ok
12006 <
12007 < 17:07:32.35 Relation 136 (SALARY_HISTORY)
12008 < 17:07:32.35   process pointer page    0 of    1
12009 < 17:07:32.35 Index 1 (RDB$PRIMARY20)
12010 < 17:07:32.36 Index 2 (RDB$FOREIGN21)
12011 < 17:07:32.36 Index 3 (CHANGEX)
12012 < 17:07:32.36 Index 4 (UPDATERX)
12013 < 17:07:32.36 Relation 136 (SALARY_HISTORY) is ok
12014 <
12015 < 17:07:32.36 Relation 137 (CUSTOMER)
12016 < 17:07:32.36   process pointer page    0 of    1
12017 < 17:07:32.36 Index 1 (RDB$PRIMARY22)
12018 < 17:07:32.36 Index 2 (RDB$FOREIGN23)
12019 < 17:07:32.36 Index 3 (CUSTNAMEX)
12020 < 17:07:32.36 Index 4 (CUSTREGION)
12021 < 17:07:32.36 Relation 137 (CUSTOMER) is ok
12022 <
12023 < 17:07:32.36 Relation 138 (SALES)
12024 < 17:07:32.36   process pointer page    0 of    1
12025 < 17:07:32.36 Index 1 (RDB$PRIMARY24)
12026 < 17:07:32.36 Index 2 (RDB$FOREIGN25)
12027 < 17:07:32.36 Index 3 (RDB$FOREIGN26)
12028 < 17:07:32.36 Index 4 (NEEDX)
12029 < 17:07:32.36 Index 5 (QTYX)
12030 < 17:07:32.36 Index 6 (SALESTATX)
12031 < 17:07:32.36 Relation 138 (SALES) is ok
11955 > 10:41:08.75 Relation 128 (COUNTRY)
11956 > 10:41:08.75   process pointer page    0 of    1
11957 > 10:41:08.75 Index 1 (RDB$PRIMARY1)
11958 > 10:41:08.75 Relation 128 (COUNTRY) is ok
11959 >
11960 > 10:41:08.75 Relation 129 (JOB)
11961 > 10:41:08.75   process pointer page    0 of    1
11962 > 10:41:08.75 Index 1 (RDB$PRIMARY2)
11963 > 10:41:08.75 Index 2 (RDB$FOREIGN3)
11964 > 10:41:08.75 Index 3 (MAXSALX)
11965 > 10:41:08.75 Index 4 (MINSALX)
11966 > 10:41:08.75 Relation 129 (JOB) is ok
11967 >
11968 > 10:41:08.75 Relation 130 (DEPARTMENT)
11969 > 10:41:08.75   process pointer page    0 of    1
11970 > 10:41:08.75 Index 1 (RDB$4)
11971 > 10:41:08.75 Index 2 (RDB$PRIMARY5)
11972 > 10:41:08.75 Index 3 (RDB$FOREIGN6)
11973 > 10:41:08.75 Index 4 (BUDGETX)
11974 > 10:41:08.75 Index 5 (RDB$FOREIGN10)
11975 > 10:41:08.75 Relation 130 (DEPARTMENT) is ok
11976 >
11977 > 10:41:08.75 Relation 131 (EMPLOYEE)
11978 > 10:41:08.75   process pointer page    0 of    1
11979 > 10:41:08.75 Index 1 (RDB$PRIMARY7)
11980 > 10:41:08.75 Index 2 (RDB$FOREIGN8)
11981 > 10:41:08.75 Index 3 (RDB$FOREIGN9)
11982 > 10:41:08.75 Index 4 (NAMEX)
11983 > 10:41:08.75 Relation 131 (EMPLOYEE) is ok
11984 >
11985 > 10:41:08.75 Relation 133 (PROJECT)
11986 > 10:41:08.75   process pointer page    0 of    1
11987 > 10:41:08.75 Index 1 (RDB$11)
11988 > 10:41:08.75 Index 2 (RDB$PRIMARY12)
11989 > 10:41:08.75 Index 3 (RDB$FOREIGN13)
11990 > 10:41:08.76 Index 4 (PRODTYPEX)
11991 > 10:41:08.76 Relation 133 (PROJECT) is ok
11992 >
11993 > 10:41:08.76 Relation 134 (EMPLOYEE_PROJECT)
11994 > 10:41:08.76   process pointer page    0 of    1
11995 > 10:41:08.76 Index 1 (RDB$PRIMARY14)
11996 > 10:41:08.76 Index 2 (RDB$FOREIGN15)
11997 > 10:41:08.76 Index 3 (RDB$FOREIGN16)
11998 > 10:41:08.76 Relation 134 (EMPLOYEE_PROJECT) is ok
11999 >
12000 > 10:41:08.76 Relation 135 (PROJ_DEPT_BUDGET)
12001 > 10:41:08.76   process pointer page    0 of    1
12002 > 10:41:08.76 Index 1 (RDB$PRIMARY17)
12003 > 10:41:08.76 Index 2 (RDB$FOREIGN18)
12004 > 10:41:08.76 Index 3 (RDB$FOREIGN19)
12005 > 10:41:08.76 Relation 135 (PROJ_DEPT_BUDGET) is ok
12006 >
12007 > 10:41:08.76 Relation 136 (SALARY_HISTORY)
12008 > 10:41:08.76   process pointer page    0 of    1
12009 > 10:41:08.76 Index 1 (RDB$PRIMARY20)
12010 > 10:41:08.76 Index 2 (RDB$FOREIGN21)
12011 > 10:41:08.76 Index 3 (CHANGEX)
12012 > 10:41:08.76 Index 4 (UPDATERX)
12013 > 10:41:08.76 Relation 136 (SALARY_HISTORY) is ok
12014 >
12015 > 10:41:08.76 Relation 137 (CUSTOMER)
12016 > 10:41:08.76   process pointer page    0 of    1
12017 > 10:41:08.76 Index 1 (RDB$PRIMARY22)
12018 > 10:41:08.76 Index 2 (RDB$FOREIGN23)
12019 > 10:41:08.76 Index 3 (CUSTNAMEX)
12020 > 10:41:08.76 Index 4 (CUSTREGION)
12021 > 10:41:08.76 Relation 137 (CUSTOMER) is ok
12022 >
12023 > 10:41:08.76 Relation 138 (SALES)
12024 > 10:41:08.76   process pointer page    0 of    1
12025 > 10:41:08.76 Index 1 (RDB$PRIMARY24)
12026 > 10:41:08.76 Index 2 (RDB$FOREIGN25)
12027 > 10:41:08.76 Index 3 (RDB$FOREIGN26)
12028 > 10:41:08.76 Index 4 (NEEDX)
12029 > 10:41:08.76 Index 5 (QTYX)
12030 > 10:41:08.76 Index 6 (SALESTATX)
12031 > 10:41:08.76 Relation 138 (SALES) is ok
12032  
12033 < 17:07:32.36 Validation finished
12033 > 10:41:08.76 Validation finished
12034  
12035  
12036   Normal Validation
# Line 13542 | Line 13542 | Test_Transaction_13: [Commit (Hard commi
13542   *Monitor*  
13543   [Application: IBX Test Suite]
13544   Test_Database_13: [Disconnect]
13545 + *Monitor*  
13546 + [Application: IBX Test Suite]
13547 + Monitoring Disabled
13548   33 ISQL Monitor Messages Received
13549  
13550  
# Line 13583 | Line 13586 | Rows printed = 2
13586   Current memory = 19,649,408
13587   Delta memory = 16,032
13588   Max memory = 19,744,992
13589 < Elapsed time= 0.102 sec
13589 > Elapsed time= 0.105 sec
13590   Cpu = 0.000 sec
13591   Buffers = 2048
13592   Reads = 2
# Line 13806 | Line 13809 | Test_Transaction_14: [Commit (Hard commi
13809   *Monitor*  
13810   [Application: IBX Test Suite]
13811   Test_Database_14: [Disconnect]
13812 + *Monitor*  
13813 + [Application: IBX Test Suite]
13814 + Monitoring Disabled
13815   33 ISQL Monitor Messages Received
13816  
13817  
# Line 15198 | Line 15204 | Create Table LotsOfData (
15204      MyText VarChar(1024),
15205      Primary Key (RowID)
15206    );                
15207 < Loading data into database table. Started at 18/2/2021 17:08:20.034
15208 < Data load completed at 18/2/2021 17:09:56.119 Elapsed Time = 96085 ms, 100000 records loaded
15209 < MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024
15210 < Database Read started at 18/2/2021 17:09:56.141
15211 < Read Dataset completed at 18/2/2021 17:10:29.759 Elapsed Time = 33618 ms, 100000 records read
15212 < MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024
15207 > Loading data into database table. Started at 22/2/2021 10:42:05.275
15208 > Data load completed at 22/2/2021 10:43:41.417 Elapsed Time = 96143 ms, 100000 records loaded
15209 > MD5 checksum = 7887a4d19dd095ad551ca8b5dc788e29
15210 > Database Read started at 22/2/2021 10:43:41.438
15211 > Read Dataset completed at 22/2/2021 10:44:12.873 Elapsed Time = 31435 ms, 100000 records read
15212 > MD5 checksum = 7887a4d19dd095ad551ca8b5dc788e29
15213   Test Completed successfully
15214 + 22/2/2021 10:44:12.873 Test 21 passes as long as the MD5 sums are identical
15215  
15216  
15217   ------------------------------------------------------

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines