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 |
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 |
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 |
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 |
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 |
|
------------------------------------------------------ |
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 |
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 |
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 |
|
|
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 |
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 |
|
|
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 |
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 |
|
|
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 |
|
------------------------------------------------------ |