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

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

# Line 644 | Line 644 | Rows printed = 42
644   Current memory = 19,651,152
645   Delta memory = 13,040
646   Max memory = 19,779,424
647 < Elapsed time= 0.026 sec
648 < Cpu = 0.020 sec
647 > Elapsed time= 0.027 sec
648 > Cpu = 0.010 sec
649   Buffers = 2048
650   Reads = 2
651   Writes = 0
# Line 1445 | Line 1445 | DPB: Item Count = 3
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 24 ms
1448 > inet://localhost/employee Disconnected after 18 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 4005 ms
1457 > inet://localhost/employee Disconnected after 3952 ms
1458   Idle Timer Expired for Test_Database_02
1459   Database Closed
1460   Transaction Events
# Line 1494 | Line 1494 | Transaction Ending
1494   Transaction Ended after 2000 ms
1495   Idle Timer Expired for Test_Transaction_02
1496   Before Disconnect
1497 < inet://localhost/employee Disconnected after 2036 ms
1497 > inet://localhost/employee Disconnected after 2029 ms
1498   SQL Dialect Downgrade test
1499   Before Connect
1500   Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
# Line 1506 | Line 1506 | DPB: Item Count = 4
1506  
1507   inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created
1508   Before Disconnect
1509 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 24 ms
1509 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms
1510   Before Connect
1511   Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
1512   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 26 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 28 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 3171 | Line 3171 | DEPT_KEY_PATH = 000;600;620;622 (Charset
3171   Current memory = 19,653,504
3172   Delta memory = 13,072
3173   Max memory = 19,729,584
3174 < Elapsed time= 0.024 sec
3174 > Elapsed time= 0.023 sec
3175   Cpu = 0.010 sec
3176   Buffers = 2048
3177   Reads = 2
# Line 11659 | Line 11659 | Message File Location = /opt/firebird3.0
11659   Database Statistics for employee
11660  
11661   Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb"
11662 < Gstat execution time Thu Feb 18 17:01:35 2021
11662 > Gstat execution time Mon Feb 22 10:35:32 2021
11663  
11664   Database header page information:
11665   Flags                   0
11666 < Generation              1989
11666 > Generation              2198
11667   System Change Number    0
11668   Page size               8192
11669   ODS version             12.0
11670 < Oldest transaction      2191
11671 < Oldest active           2192
11672 < Oldest snapshot         2192
11673 < Next transaction        2192
11670 > Oldest transaction      2485
11671 > Oldest active           2486
11672 > Oldest snapshot         2486
11673 > Next transaction        2486
11674   Sequence number         0
11675 < Next attachment ID      1924
11675 > Next attachment ID      2248
11676   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
11677   Shadow count            0
11678   Page buffers            0
# Line 11819 | Line 11819 | Fill distribution:
11819   60 - 79% = 0
11820   80 - 99% = 0
11821  
11822 < Gstat completion time Thu Feb 18 17:01:35 2021
11822 > Gstat completion time Mon Feb 22 10:35:32 2021
11823  
11824  
11825  
# Line 11829 | Line 11829 | zeus   Tue Jun  9 15:11:28 2020
11829   bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird
11830  
11831   Online Validation
11832 < 17:01:36.08 Validation started
11832 > 10:35:32.67 Validation started
11833  
11834 < 17:01:36.08 Relation 128 (COUNTRY)
11835 < 17:01:36.08   process pointer page    0 of    1
11836 < 17:01:36.08 Index 1 (RDB$PRIMARY1)
11837 < 17:01:36.08 Relation 128 (COUNTRY) is ok
11838 <
11839 < 17:01:36.08 Relation 129 (JOB)
11840 < 17:01:36.08   process pointer page    0 of    1
11841 < 17:01:36.08 Index 1 (RDB$PRIMARY2)
11842 < 17:01:36.08 Index 2 (RDB$FOREIGN3)
11843 < 17:01:36.08 Index 3 (MAXSALX)
11844 < 17:01:36.08 Index 4 (MINSALX)
11845 < 17:01:36.08 Relation 129 (JOB) is ok
11846 <
11847 < 17:01:36.08 Relation 130 (DEPARTMENT)
11848 < 17:01:36.08   process pointer page    0 of    1
11849 < 17:01:36.08 Index 1 (RDB$4)
11850 < 17:01:36.08 Index 2 (RDB$PRIMARY5)
11851 < 17:01:36.08 Index 3 (RDB$FOREIGN6)
11852 < 17:01:36.08 Index 4 (BUDGETX)
11853 < 17:01:36.08 Index 5 (RDB$FOREIGN10)
11854 < 17:01:36.08 Relation 130 (DEPARTMENT) is ok
11855 <
11856 < 17:01:36.08 Relation 131 (EMPLOYEE)
11857 < 17:01:36.08   process pointer page    0 of    1
11858 < 17:01:36.08 Index 1 (RDB$PRIMARY7)
11859 < 17:01:36.08 Index 2 (RDB$FOREIGN8)
11860 < 17:01:36.08 Index 3 (RDB$FOREIGN9)
11861 < 17:01:36.08 Index 4 (NAMEX)
11862 < 17:01:36.08 Relation 131 (EMPLOYEE) is ok
11863 <
11864 < 17:01:36.08 Relation 133 (PROJECT)
11865 < 17:01:36.08   process pointer page    0 of    1
11866 < 17:01:36.08 Index 1 (RDB$11)
11867 < 17:01:36.08 Index 2 (RDB$PRIMARY12)
11868 < 17:01:36.08 Index 3 (RDB$FOREIGN13)
11869 < 17:01:36.08 Index 4 (PRODTYPEX)
11870 < 17:01:36.08 Relation 133 (PROJECT) is ok
11871 <
11872 < 17:01:36.08 Relation 134 (EMPLOYEE_PROJECT)
11873 < 17:01:36.08   process pointer page    0 of    1
11874 < 17:01:36.08 Index 1 (RDB$PRIMARY14)
11875 < 17:01:36.09 Index 2 (RDB$FOREIGN15)
11876 < 17:01:36.09 Index 3 (RDB$FOREIGN16)
11877 < 17:01:36.09 Relation 134 (EMPLOYEE_PROJECT) is ok
11878 <
11879 < 17:01:36.09 Relation 135 (PROJ_DEPT_BUDGET)
11880 < 17:01:36.09   process pointer page    0 of    1
11881 < 17:01:36.09 Index 1 (RDB$PRIMARY17)
11882 < 17:01:36.09 Index 2 (RDB$FOREIGN18)
11883 < 17:01:36.09 Index 3 (RDB$FOREIGN19)
11884 < 17:01:36.09 Relation 135 (PROJ_DEPT_BUDGET) is ok
11885 <
11886 < 17:01:36.09 Relation 136 (SALARY_HISTORY)
11887 < 17:01:36.09   process pointer page    0 of    1
11888 < 17:01:36.09 Index 1 (RDB$PRIMARY20)
11889 < 17:01:36.09 Index 2 (RDB$FOREIGN21)
11890 < 17:01:36.09 Index 3 (CHANGEX)
11891 < 17:01:36.09 Index 4 (UPDATERX)
11892 < 17:01:36.09 Relation 136 (SALARY_HISTORY) is ok
11893 <
11894 < 17:01:36.09 Relation 137 (CUSTOMER)
11895 < 17:01:36.09   process pointer page    0 of    1
11896 < 17:01:36.09 Index 1 (RDB$PRIMARY22)
11897 < 17:01:36.09 Index 2 (RDB$FOREIGN23)
11898 < 17:01:36.09 Index 3 (CUSTNAMEX)
11899 < 17:01:36.09 Index 4 (CUSTREGION)
11900 < 17:01:36.09 Relation 137 (CUSTOMER) is ok
11901 <
11902 < 17:01:36.10 Relation 138 (SALES)
11903 < 17:01:36.10   process pointer page    0 of    1
11904 < 17:01:36.10 Index 1 (RDB$PRIMARY24)
11905 < 17:01:36.10 Index 2 (RDB$FOREIGN25)
11906 < 17:01:36.10 Index 3 (RDB$FOREIGN26)
11907 < 17:01:36.10 Index 4 (NEEDX)
11908 < 17:01:36.10 Index 5 (QTYX)
11909 < 17:01:36.10 Index 6 (SALESTATX)
11910 < 17:01:36.10 Relation 138 (SALES) is ok
11834 > 10:35:32.67 Relation 128 (COUNTRY)
11835 > 10:35:32.67   process pointer page    0 of    1
11836 > 10:35:32.67 Index 1 (RDB$PRIMARY1)
11837 > 10:35:32.67 Relation 128 (COUNTRY) is ok
11838 >
11839 > 10:35:32.67 Relation 129 (JOB)
11840 > 10:35:32.67   process pointer page    0 of    1
11841 > 10:35:32.67 Index 1 (RDB$PRIMARY2)
11842 > 10:35:32.67 Index 2 (RDB$FOREIGN3)
11843 > 10:35:32.67 Index 3 (MAXSALX)
11844 > 10:35:32.67 Index 4 (MINSALX)
11845 > 10:35:32.67 Relation 129 (JOB) is ok
11846 >
11847 > 10:35:32.67 Relation 130 (DEPARTMENT)
11848 > 10:35:32.67   process pointer page    0 of    1
11849 > 10:35:32.67 Index 1 (RDB$4)
11850 > 10:35:32.67 Index 2 (RDB$PRIMARY5)
11851 > 10:35:32.67 Index 3 (RDB$FOREIGN6)
11852 > 10:35:32.67 Index 4 (BUDGETX)
11853 > 10:35:32.67 Index 5 (RDB$FOREIGN10)
11854 > 10:35:32.67 Relation 130 (DEPARTMENT) is ok
11855 >
11856 > 10:35:32.67 Relation 131 (EMPLOYEE)
11857 > 10:35:32.67   process pointer page    0 of    1
11858 > 10:35:32.67 Index 1 (RDB$PRIMARY7)
11859 > 10:35:32.67 Index 2 (RDB$FOREIGN8)
11860 > 10:35:32.67 Index 3 (RDB$FOREIGN9)
11861 > 10:35:32.67 Index 4 (NAMEX)
11862 > 10:35:32.67 Relation 131 (EMPLOYEE) is ok
11863 >
11864 > 10:35:32.67 Relation 133 (PROJECT)
11865 > 10:35:32.67   process pointer page    0 of    1
11866 > 10:35:32.67 Index 1 (RDB$11)
11867 > 10:35:32.67 Index 2 (RDB$PRIMARY12)
11868 > 10:35:32.67 Index 3 (RDB$FOREIGN13)
11869 > 10:35:32.67 Index 4 (PRODTYPEX)
11870 > 10:35:32.67 Relation 133 (PROJECT) is ok
11871 >
11872 > 10:35:32.67 Relation 134 (EMPLOYEE_PROJECT)
11873 > 10:35:32.67   process pointer page    0 of    1
11874 > 10:35:32.67 Index 1 (RDB$PRIMARY14)
11875 > 10:35:32.67 Index 2 (RDB$FOREIGN15)
11876 > 10:35:32.67 Index 3 (RDB$FOREIGN16)
11877 > 10:35:32.67 Relation 134 (EMPLOYEE_PROJECT) is ok
11878 >
11879 > 10:35:32.67 Relation 135 (PROJ_DEPT_BUDGET)
11880 > 10:35:32.67   process pointer page    0 of    1
11881 > 10:35:32.68 Index 1 (RDB$PRIMARY17)
11882 > 10:35:32.68 Index 2 (RDB$FOREIGN18)
11883 > 10:35:32.68 Index 3 (RDB$FOREIGN19)
11884 > 10:35:32.68 Relation 135 (PROJ_DEPT_BUDGET) is ok
11885 >
11886 > 10:35:32.68 Relation 136 (SALARY_HISTORY)
11887 > 10:35:32.68   process pointer page    0 of    1
11888 > 10:35:32.68 Index 1 (RDB$PRIMARY20)
11889 > 10:35:32.68 Index 2 (RDB$FOREIGN21)
11890 > 10:35:32.68 Index 3 (CHANGEX)
11891 > 10:35:32.68 Index 4 (UPDATERX)
11892 > 10:35:32.68 Relation 136 (SALARY_HISTORY) is ok
11893 >
11894 > 10:35:32.68 Relation 137 (CUSTOMER)
11895 > 10:35:32.68   process pointer page    0 of    1
11896 > 10:35:32.68 Index 1 (RDB$PRIMARY22)
11897 > 10:35:32.68 Index 2 (RDB$FOREIGN23)
11898 > 10:35:32.68 Index 3 (CUSTNAMEX)
11899 > 10:35:32.68 Index 4 (CUSTREGION)
11900 > 10:35:32.68 Relation 137 (CUSTOMER) is ok
11901 >
11902 > 10:35:32.68 Relation 138 (SALES)
11903 > 10:35:32.68   process pointer page    0 of    1
11904 > 10:35:32.68 Index 1 (RDB$PRIMARY24)
11905 > 10:35:32.68 Index 2 (RDB$FOREIGN25)
11906 > 10:35:32.68 Index 3 (RDB$FOREIGN26)
11907 > 10:35:32.68 Index 4 (NEEDX)
11908 > 10:35:32.68 Index 5 (QTYX)
11909 > 10:35:32.68 Index 6 (SALESTATX)
11910 > 10:35:32.68 Relation 138 (SALES) is ok
11911  
11912 < 17:01:36.10 Validation finished
11912 > 10:35:32.68 Validation finished
11913  
11914  
11915   Normal Validation
# Line 13421 | Line 13421 | Test_Transaction_13: [Commit (Hard commi
13421   *Monitor*  
13422   [Application: IBX Test Suite]
13423   Test_Database_13: [Disconnect]
13424 + *Monitor*  
13425 + [Application: IBX Test Suite]
13426 + Monitoring Disabled
13427   33 ISQL Monitor Messages Received
13428  
13429  
# Line 13462 | Line 13465 | Rows printed = 2
13465   Current memory = 19,651,616
13466   Delta memory = 12,688
13467   Max memory = 19,780,240
13468 < Elapsed time= 0.102 sec
13468 > Elapsed time= 0.103 sec
13469   Cpu = 0.000 sec
13470   Buffers = 2048
13471   Reads = 2
# Line 13685 | Line 13688 | Test_Transaction_14: [Commit (Hard commi
13688   *Monitor*  
13689   [Application: IBX Test Suite]
13690   Test_Database_14: [Disconnect]
13691 + *Monitor*  
13692 + [Application: IBX Test Suite]
13693 + Monitoring Disabled
13694   33 ISQL Monitor Messages Received
13695  
13696  
# Line 15077 | Line 15083 | Create Table LotsOfData (
15083      MyText VarChar(1024),
15084      Primary Key (RowID)
15085    );                
15086 < Loading data into database table. Started at 18/2/2021 17:02:23.963
15087 < Data load completed at 18/2/2021 17:04:01.973 Elapsed Time = 98010 ms, 100000 records loaded
15088 < MD5 checksum = e299f7080fd2afa5d1b70b92831668b0
15089 < Database Read started at 18/2/2021 17:04:01.983
15090 < Read Dataset completed at 18/2/2021 17:04:31.867 Elapsed Time = 29884 ms, 100000 records read
15091 < MD5 checksum = e299f7080fd2afa5d1b70b92831668b0
15086 > Loading data into database table. Started at 22/2/2021 10:36:29.554
15087 > Data load completed at 22/2/2021 10:38:03.989 Elapsed Time = 94435 ms, 100000 records loaded
15088 > MD5 checksum = c64feb9fc39310ba79ee10a629ac32ba
15089 > Database Read started at 22/2/2021 10:38:03.997
15090 > Read Dataset completed at 22/2/2021 10:38:36.093 Elapsed Time = 32096 ms, 100000 records read
15091 > MD5 checksum = c64feb9fc39310ba79ee10a629ac32ba
15092   Test Completed successfully
15093 + 22/2/2021 10:38:36.093 Test 21 passes as long as the MD5 sums are identical
15094  
15095  
15096   ------------------------------------------------------

Diff Legend

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