642 |
|
Current memory = 960,760 |
643 |
|
Delta memory = 9,624 |
644 |
|
Max memory = 1,012,104 |
645 |
< |
Elapsed time= 0.033 sec |
645 |
> |
Elapsed time= 0.034 sec |
646 |
|
Cpu = 0.002 sec |
647 |
|
Buffers = 75 |
648 |
|
Reads = 3 |
1443 |
|
isc_dpb_lc_ctype = UTF8 |
1444 |
|
|
1445 |
|
Before Disconnect |
1446 |
< |
localhost:employee Disconnected after 21 ms |
1446 |
> |
localhost:employee Disconnected after 23 ms |
1447 |
|
Before Connect |
1448 |
|
Connected to localhost:employee |
1449 |
|
DPB: Item Count = 3 |
1452 |
|
isc_dpb_lc_ctype = UTF8 |
1453 |
|
|
1454 |
|
Before Disconnect |
1455 |
< |
localhost:employee Disconnected after 3989 ms |
1455 |
> |
localhost:employee Disconnected after 3949 ms |
1456 |
|
Idle Timer Expired for Test_Database_02 |
1457 |
|
Database Closed |
1458 |
|
Transaction Events |
1475 |
|
isc_tpb_read |
1476 |
|
|
1477 |
|
Transaction Ending |
1478 |
< |
Transaction Ended after 11 ms |
1478 |
> |
Transaction Ended after 7 ms |
1479 |
|
Transaction idle timer test |
1480 |
|
Requested TPB: Item Count = 3 |
1481 |
|
isc_tpb_concurrency |
1489 |
|
isc_tpb_read |
1490 |
|
|
1491 |
|
Transaction Ending |
1492 |
< |
Transaction Ended after 2012 ms |
1492 |
> |
Transaction Ended after 2007 ms |
1493 |
|
Idle Timer Expired for Test_Transaction_02 |
1494 |
|
Before Disconnect |
1495 |
< |
localhost:employee Disconnected after 2056 ms |
1495 |
> |
localhost:employee Disconnected after 2053 ms |
1496 |
|
SQL Dialect Downgrade test |
1497 |
|
Before Connect |
1498 |
|
Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb |
1504 |
|
|
1505 |
|
localhost:/tmp/ibx-testsuite/testsuite1.fdb created |
1506 |
|
Before Disconnect |
1507 |
< |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 28 ms |
1507 |
> |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 29 ms |
1508 |
|
Before Connect |
1509 |
|
Warning: SQL Dialect Downgrade of localhost:/tmp/ibx-testsuite/testsuite1.fdb |
1510 |
|
Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb |
1514 |
|
isc_dpb_lc_ctype = UTF8 |
1515 |
|
|
1516 |
|
Before Disconnect |
1517 |
< |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms |
1517 |
> |
localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 29 ms |
1518 |
|
|
1519 |
|
|
1520 |
|
------------------------------------------------------ |
3151 |
|
Current memory = 952,624 |
3152 |
|
Delta memory = 9,608 |
3153 |
|
Max memory = 1,013,496 |
3154 |
< |
Elapsed time= 0.032 sec |
3155 |
< |
Cpu = 0.001 sec |
3154 |
> |
Elapsed time= 0.026 sec |
3155 |
> |
Cpu = 0.002 sec |
3156 |
|
Buffers = 75 |
3157 |
|
Reads = 3 |
3158 |
|
Writes = 0 |
10048 |
|
Database Statistics for employee |
10049 |
|
|
10050 |
|
Database "/opt/firebird2.5.9/examples/empbuild/employee.fdb" |
10051 |
< |
Gstat execution time Thu Feb 18 16:54:16 2021 |
10051 |
> |
Gstat execution time Mon Feb 22 10:28:12 2021 |
10052 |
|
|
10053 |
|
Database header page information: |
10054 |
|
Flags 0 |
10055 |
|
Checksum 12345 |
10056 |
< |
Generation 3858 |
10056 |
> |
Generation 4475 |
10057 |
|
Page size 4096 |
10058 |
|
ODS version 11.2 |
10059 |
< |
Oldest transaction 2330 |
10060 |
< |
Oldest active 2331 |
10061 |
< |
Oldest snapshot 2331 |
10062 |
< |
Next transaction 2331 |
10059 |
> |
Oldest transaction 2730 |
10060 |
> |
Oldest active 2731 |
10061 |
> |
Oldest snapshot 2731 |
10062 |
> |
Next transaction 2731 |
10063 |
|
Bumped transaction 1 |
10064 |
|
Sequence number 0 |
10065 |
< |
Next attachment ID 761 |
10065 |
> |
Next attachment ID 918 |
10066 |
|
Implementation ID 24 |
10067 |
|
Shadow count 0 |
10068 |
|
Page buffers 0 |
10187 |
|
INET/inet_error: connect errno = 111 |
10188 |
|
|
10189 |
|
Online Validation |
10190 |
< |
16:54:17.46 Validation started |
10190 |
> |
10:28:13.55 Validation started |
10191 |
|
|
10192 |
< |
16:54:17.46 Relation 128 (COUNTRY) |
10193 |
< |
16:54:17.46 process pointer page 0 of 1 |
10194 |
< |
16:54:17.46 Index 1 (RDB$PRIMARY1) |
10195 |
< |
16:54:17.46 Relation 128 (COUNTRY) is ok |
10196 |
< |
|
10197 |
< |
16:54:17.46 Relation 129 (JOB) |
10198 |
< |
16:54:17.46 process pointer page 0 of 1 |
10199 |
< |
16:54:17.46 Index 1 (RDB$PRIMARY2) |
10200 |
< |
16:54:17.46 Index 2 (RDB$FOREIGN3) |
10201 |
< |
16:54:17.46 Index 3 (MAXSALX) |
10202 |
< |
16:54:17.46 Index 4 (MINSALX) |
10203 |
< |
16:54:17.46 Relation 129 (JOB) is ok |
10204 |
< |
|
10205 |
< |
16:54:17.46 Relation 130 (DEPARTMENT) |
10206 |
< |
16:54:17.46 process pointer page 0 of 1 |
10207 |
< |
16:54:17.46 Index 1 (RDB$4) |
10208 |
< |
16:54:17.46 Index 2 (RDB$PRIMARY5) |
10209 |
< |
16:54:17.46 Index 3 (RDB$FOREIGN6) |
10210 |
< |
16:54:17.46 Index 4 (BUDGETX) |
10211 |
< |
16:54:17.46 Index 5 (RDB$FOREIGN10) |
10212 |
< |
16:54:17.46 Relation 130 (DEPARTMENT) is ok |
10213 |
< |
|
10214 |
< |
16:54:17.46 Relation 131 (EMPLOYEE) |
10215 |
< |
16:54:17.46 process pointer page 0 of 1 |
10216 |
< |
16:54:17.46 Index 1 (RDB$PRIMARY7) |
10217 |
< |
16:54:17.46 Index 2 (RDB$FOREIGN8) |
10218 |
< |
16:54:17.46 Index 3 (RDB$FOREIGN9) |
10219 |
< |
16:54:17.46 Index 4 (NAMEX) |
10220 |
< |
16:54:17.46 Relation 131 (EMPLOYEE) is ok |
10221 |
< |
|
10222 |
< |
16:54:17.46 Relation 133 (PROJECT) |
10223 |
< |
16:54:17.46 process pointer page 0 of 1 |
10224 |
< |
16:54:17.46 Index 1 (RDB$11) |
10225 |
< |
16:54:17.46 Index 2 (RDB$PRIMARY12) |
10226 |
< |
16:54:17.47 Index 3 (RDB$FOREIGN13) |
10227 |
< |
16:54:17.47 Index 4 (PRODTYPEX) |
10228 |
< |
16:54:17.47 Relation 133 (PROJECT) is ok |
10229 |
< |
|
10230 |
< |
16:54:17.47 Relation 134 (EMPLOYEE_PROJECT) |
10231 |
< |
16:54:17.47 process pointer page 0 of 1 |
10232 |
< |
16:54:17.47 Index 1 (RDB$PRIMARY14) |
10233 |
< |
16:54:17.47 Index 2 (RDB$FOREIGN15) |
10234 |
< |
16:54:17.47 Index 3 (RDB$FOREIGN16) |
10235 |
< |
16:54:17.47 Relation 134 (EMPLOYEE_PROJECT) is ok |
10236 |
< |
|
10237 |
< |
16:54:17.47 Relation 135 (PROJ_DEPT_BUDGET) |
10238 |
< |
16:54:17.47 process pointer page 0 of 1 |
10239 |
< |
16:54:17.47 Index 1 (RDB$PRIMARY17) |
10240 |
< |
16:54:17.47 Index 2 (RDB$FOREIGN18) |
10241 |
< |
16:54:17.47 Index 3 (RDB$FOREIGN19) |
10242 |
< |
16:54:17.47 Relation 135 (PROJ_DEPT_BUDGET) is ok |
10243 |
< |
|
10244 |
< |
16:54:17.47 Relation 136 (SALARY_HISTORY) |
10245 |
< |
16:54:17.47 process pointer page 0 of 1 |
10246 |
< |
16:54:17.47 Index 1 (RDB$PRIMARY20) |
10247 |
< |
16:54:17.47 Index 2 (RDB$FOREIGN21) |
10248 |
< |
16:54:17.47 Index 3 (CHANGEX) |
10249 |
< |
16:54:17.47 Index 4 (UPDATERX) |
10250 |
< |
16:54:17.48 Relation 136 (SALARY_HISTORY) is ok |
10251 |
< |
|
10252 |
< |
16:54:17.48 Relation 137 (CUSTOMER) |
10253 |
< |
16:54:17.48 process pointer page 0 of 1 |
10254 |
< |
16:54:17.48 Index 1 (RDB$PRIMARY22) |
10255 |
< |
16:54:17.48 Index 2 (RDB$FOREIGN23) |
10256 |
< |
16:54:17.48 Index 3 (CUSTNAMEX) |
10257 |
< |
16:54:17.48 Index 4 (CUSTREGION) |
10258 |
< |
16:54:17.48 Relation 137 (CUSTOMER) is ok |
10259 |
< |
|
10260 |
< |
16:54:17.48 Relation 138 (SALES) |
10261 |
< |
16:54:17.48 process pointer page 0 of 1 |
10262 |
< |
16:54:17.48 Index 1 (RDB$PRIMARY24) |
10263 |
< |
16:54:17.48 Index 2 (RDB$FOREIGN25) |
10264 |
< |
16:54:17.48 Index 3 (RDB$FOREIGN26) |
10265 |
< |
16:54:17.48 Index 4 (NEEDX) |
10266 |
< |
16:54:17.48 Index 5 (QTYX) |
10267 |
< |
16:54:17.48 Index 6 (SALESTATX) |
10268 |
< |
16:54:17.48 Relation 138 (SALES) is ok |
10192 |
> |
10:28:13.55 Relation 128 (COUNTRY) |
10193 |
> |
10:28:13.55 process pointer page 0 of 1 |
10194 |
> |
10:28:13.56 Index 1 (RDB$PRIMARY1) |
10195 |
> |
10:28:13.56 Relation 128 (COUNTRY) is ok |
10196 |
> |
|
10197 |
> |
10:28:13.56 Relation 129 (JOB) |
10198 |
> |
10:28:13.56 process pointer page 0 of 1 |
10199 |
> |
10:28:13.56 Index 1 (RDB$PRIMARY2) |
10200 |
> |
10:28:13.56 Index 2 (RDB$FOREIGN3) |
10201 |
> |
10:28:13.56 Index 3 (MAXSALX) |
10202 |
> |
10:28:13.56 Index 4 (MINSALX) |
10203 |
> |
10:28:13.56 Relation 129 (JOB) is ok |
10204 |
> |
|
10205 |
> |
10:28:13.56 Relation 130 (DEPARTMENT) |
10206 |
> |
10:28:13.56 process pointer page 0 of 1 |
10207 |
> |
10:28:13.56 Index 1 (RDB$4) |
10208 |
> |
10:28:13.56 Index 2 (RDB$PRIMARY5) |
10209 |
> |
10:28:13.56 Index 3 (RDB$FOREIGN6) |
10210 |
> |
10:28:13.56 Index 4 (BUDGETX) |
10211 |
> |
10:28:13.56 Index 5 (RDB$FOREIGN10) |
10212 |
> |
10:28:13.56 Relation 130 (DEPARTMENT) is ok |
10213 |
> |
|
10214 |
> |
10:28:13.56 Relation 131 (EMPLOYEE) |
10215 |
> |
10:28:13.56 process pointer page 0 of 1 |
10216 |
> |
10:28:13.56 Index 1 (RDB$PRIMARY7) |
10217 |
> |
10:28:13.56 Index 2 (RDB$FOREIGN8) |
10218 |
> |
10:28:13.56 Index 3 (RDB$FOREIGN9) |
10219 |
> |
10:28:13.56 Index 4 (NAMEX) |
10220 |
> |
10:28:13.56 Relation 131 (EMPLOYEE) is ok |
10221 |
> |
|
10222 |
> |
10:28:13.56 Relation 133 (PROJECT) |
10223 |
> |
10:28:13.56 process pointer page 0 of 1 |
10224 |
> |
10:28:13.56 Index 1 (RDB$11) |
10225 |
> |
10:28:13.56 Index 2 (RDB$PRIMARY12) |
10226 |
> |
10:28:13.56 Index 3 (RDB$FOREIGN13) |
10227 |
> |
10:28:13.56 Index 4 (PRODTYPEX) |
10228 |
> |
10:28:13.56 Relation 133 (PROJECT) is ok |
10229 |
> |
|
10230 |
> |
10:28:13.56 Relation 134 (EMPLOYEE_PROJECT) |
10231 |
> |
10:28:13.56 process pointer page 0 of 1 |
10232 |
> |
10:28:13.56 Index 1 (RDB$PRIMARY14) |
10233 |
> |
10:28:13.56 Index 2 (RDB$FOREIGN15) |
10234 |
> |
10:28:13.57 Index 3 (RDB$FOREIGN16) |
10235 |
> |
10:28:13.57 Relation 134 (EMPLOYEE_PROJECT) is ok |
10236 |
> |
|
10237 |
> |
10:28:13.57 Relation 135 (PROJ_DEPT_BUDGET) |
10238 |
> |
10:28:13.57 process pointer page 0 of 1 |
10239 |
> |
10:28:13.57 Index 1 (RDB$PRIMARY17) |
10240 |
> |
10:28:13.57 Index 2 (RDB$FOREIGN18) |
10241 |
> |
10:28:13.57 Index 3 (RDB$FOREIGN19) |
10242 |
> |
10:28:13.57 Relation 135 (PROJ_DEPT_BUDGET) is ok |
10243 |
> |
|
10244 |
> |
10:28:13.57 Relation 136 (SALARY_HISTORY) |
10245 |
> |
10:28:13.57 process pointer page 0 of 1 |
10246 |
> |
10:28:13.57 Index 1 (RDB$PRIMARY20) |
10247 |
> |
10:28:13.57 Index 2 (RDB$FOREIGN21) |
10248 |
> |
10:28:13.57 Index 3 (CHANGEX) |
10249 |
> |
10:28:13.57 Index 4 (UPDATERX) |
10250 |
> |
10:28:13.57 Relation 136 (SALARY_HISTORY) is ok |
10251 |
> |
|
10252 |
> |
10:28:13.57 Relation 137 (CUSTOMER) |
10253 |
> |
10:28:13.57 process pointer page 0 of 1 |
10254 |
> |
10:28:13.57 Index 1 (RDB$PRIMARY22) |
10255 |
> |
10:28:13.57 Index 2 (RDB$FOREIGN23) |
10256 |
> |
10:28:13.57 Index 3 (CUSTNAMEX) |
10257 |
> |
10:28:13.57 Index 4 (CUSTREGION) |
10258 |
> |
10:28:13.57 Relation 137 (CUSTOMER) is ok |
10259 |
> |
|
10260 |
> |
10:28:13.57 Relation 138 (SALES) |
10261 |
> |
10:28:13.58 process pointer page 0 of 1 |
10262 |
> |
10:28:13.58 Index 1 (RDB$PRIMARY24) |
10263 |
> |
10:28:13.58 Index 2 (RDB$FOREIGN25) |
10264 |
> |
10:28:13.58 Index 3 (RDB$FOREIGN26) |
10265 |
> |
10:28:13.58 Index 4 (NEEDX) |
10266 |
> |
10:28:13.58 Index 5 (QTYX) |
10267 |
> |
10:28:13.58 Index 6 (SALESTATX) |
10268 |
> |
10:28:13.58 Relation 138 (SALES) is ok |
10269 |
|
|
10270 |
< |
16:54:17.48 Validation finished |
10270 |
> |
10:28:13.58 Validation finished |
10271 |
|
|
10272 |
|
|
10273 |
|
Normal Validation |
11555 |
|
Current memory = 966,728 |
11556 |
|
Delta memory = 9,344 |
11557 |
|
Max memory = 1,012,400 |
11558 |
< |
Elapsed time= 0.005 sec |
11559 |
< |
Cpu = 0.001 sec |
11558 |
> |
Elapsed time= 0.004 sec |
11559 |
> |
Cpu = 0.000 sec |
11560 |
|
Buffers = 75 |
11561 |
|
Reads = 2 |
11562 |
|
Writes = 0 |
11733 |
|
*Monitor* |
11734 |
|
[Application: IBX Test Suite] |
11735 |
|
Test_Database_13: [Disconnect] |
11736 |
+ |
*Monitor* |
11737 |
+ |
[Application: IBX Test Suite] |
11738 |
+ |
Monitoring Disabled |
11739 |
|
33 ISQL Monitor Messages Received |
11740 |
|
|
11741 |
|
|
11777 |
|
Current memory = 966,728 |
11778 |
|
Delta memory = 9,344 |
11779 |
|
Max memory = 1,012,400 |
11780 |
< |
Elapsed time= 0.104 sec |
11780 |
> |
Elapsed time= 0.103 sec |
11781 |
|
Cpu = 0.000 sec |
11782 |
|
Buffers = 75 |
11783 |
|
Reads = 2 |
11954 |
|
*Monitor* |
11955 |
|
[Application: IBX Test Suite] |
11956 |
|
Test_Database_14: [Disconnect] |
11957 |
+ |
*Monitor* |
11958 |
+ |
[Application: IBX Test Suite] |
11959 |
+ |
Monitoring Disabled |
11960 |
|
33 ISQL Monitor Messages Received |
11961 |
|
|
11962 |
|
|
13116 |
|
MyText VarChar(1024), |
13117 |
|
Primary Key (RowID) |
13118 |
|
); |
13119 |
< |
Loading data into database table. Started at 18/2/2021 16:55:02.151 |
13120 |
< |
Data load completed at 18/2/2021 16:58:00.820 Elapsed Time = 178669 ms, 100000 records loaded |
13121 |
< |
MD5 checksum = 17ea6e3376ac304ecab02428b4872b52 |
13122 |
< |
Database Read started at 18/2/2021 16:58:00.841 |
13123 |
< |
Read Dataset completed at 18/2/2021 16:58:31.837 Elapsed Time = 30997 ms, 100000 records read |
13124 |
< |
MD5 checksum = 17ea6e3376ac304ecab02428b4872b52 |
13119 |
> |
Loading data into database table. Started at 22/2/2021 10:29:05.094 |
13120 |
> |
Data load completed at 22/2/2021 10:31:52.887 Elapsed Time = 167794 ms, 100000 records loaded |
13121 |
> |
MD5 checksum = 2bd6187c4b844d60db96a46a04785c20 |
13122 |
> |
Database Read started at 22/2/2021 10:31:52.899 |
13123 |
> |
Read Dataset completed at 22/2/2021 10:32:25.605 Elapsed Time = 32706 ms, 100000 records read |
13124 |
> |
MD5 checksum = 2bd6187c4b844d60db96a46a04785c20 |
13125 |
|
Test Completed successfully |
13126 |
+ |
22/2/2021 10:32:25.605Test 21 passes as long as the MD5 sums are identical |
13127 |
|
|
13128 |
|
|
13129 |
|
------------------------------------------------------ |