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

Comparing ibx/trunk/testsuite/FB2reference.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 642 | Line 642 | Rows printed = 42
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
# Line 1443 | Line 1443 | DPB: Item Count = 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
# Line 1452 | Line 1452 | 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
# Line 1475 | Line 1475 | TPB: Item Count = 3
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
# Line 1489 | Line 1489 | TPB: Item Count = 3
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
# Line 1504 | Line 1504 | DPB: Item Count = 4
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
# Line 1514 | Line 1514 | DPB: Item Count = 3
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   ------------------------------------------------------
# Line 3151 | Line 3151 | DEPT_KEY_PATH = 000;600;620;622
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
# Line 10048 | Line 10048 | Message File Location = /opt/firebird2.5
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
# Line 10187 | Line 10187 | zeus   Tue Jun  9 14:31:01 2020
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
# Line 11555 | Line 11555 | Rows printed = 2
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
# Line 11733 | Line 11733 | Test_Transaction_13: [Commit (Hard commi
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  
# Line 11774 | Line 11777 | Rows printed = 2
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
# Line 11951 | Line 11954 | Test_Transaction_14: [Commit (Hard commi
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  
# Line 13110 | Line 13116 | Create Table LotsOfData (
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   ------------------------------------------------------

Diff Legend

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