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 345 by tony, Mon Aug 23 14:22:29 2021 UTC

# Line 3 | Line 3 | Copyright MWA Software 2016-2021
3  
4   Starting Tests
5   Client API Version = 4.0
6 < Firebird Environment Variable = /opt/firebird4rc1
7 < Firebird Bin Directory = /opt/firebird4rc1/bin
8 < Firebird Conf Directory = /opt/firebird4rc1/
9 < Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so
6 > Firebird Environment Variable = /opt/firebird4.0.0
7 > Firebird Bin Directory = /opt/firebird4.0.0/bin
8 > Firebird Conf Directory = /opt/firebird4.0.0/
9 > Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so
10   Running Test 01: Open and read from Employee Database
11   Read dataset unidirectional buffering
12   Row No = 1
# Line 641 | Line 641 | DEPT_KEY_PATH = 000;900 (Charset = UTF8
641  
642   Rows printed = 42
643  
644 < Current memory = 19,670,464
644 > Current memory = 19,688,352
645   Delta memory = 16,384
646 < Max memory = 19,765,360
646 > Max memory = 19,783,248
647   Elapsed time= 0.027 sec
648   Cpu = 0.010 sec
649   Buffers = 2048
# 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 24 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 4024 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 1494 | Line 1494 | Transaction Ending
1494   Transaction Ended after 2001 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 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 26 ms
1509 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 13 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 22 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 18 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 1524 | Line 1524 | Running Test 03: Database Information
1524   Authentication Method = Srp256
1525   Remote Protocol = TCPv4
1526   Attachment SQLDialect = 3
1527 < Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
1528 < Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
1529 < Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
1527 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
1528 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
1529 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
1530   on disk structure version 13.0
1531 < FB Version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1", Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ", Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ", on disk structure version 13.0
1532 < Firebird Library Pathname = /opt/firebird4rc1/lib/libfbclient.so
1531 > FB Version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0", Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ", Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ", on disk structure version 13.0
1532 > Firebird Library Pathname = /opt/firebird4.0.0/lib/libfbclient.so
1533   DB SQLDialect = 3
1534 < Allocation = 346
1534 > Allocation = 1075
1535   Base Level = 4
1536 < DB File Name = /opt/firebird4rc1/examples/empbuild/employee.fdb
1536 > DB File Name = /opt/firebird4.0.0/examples/empbuild/employee.fdb
1537   DB Site Name = zeus
1538   DB Implementation No = 7
1539 < Database Created: 01/2/2021 14:57:08
1539 > Database Created: 29/5/2021 16:47:30
1540   DB Implementation Class = 0
1541   Space is Reserved
1542   ODS Minor Version = 0
1543   ODS Major Version = 13
1544   Page Size = 8192
1545 < Version = LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1
1546 < Current Memory = 19485440
1545 > Version = LI-V6.3.0.2496 Firebird 4.0
1546 > Current Memory = 19503040
1547   Forced Writes Enabled
1548 < Max Memory = 19612048
1548 > Max Memory = 19629648
1549   Number of Buffers = 2048
1550   Sweep Interval = 20000
1551   User Names: SYSDBA
1552 < Fetches = 1840
1552 > Fetches = 1855
1553   Marks = 8
1554 < Reads = 99
1554 > Reads = 100
1555   Writes = 2
1556 < Pages Free = 310
1557 < Pages Used = 36
1556 > Pages Free = 313
1557 > Pages Used = 762
1558   Transaction Count = 1
1559  
1560   Read Idx Count
# Line 1565 | Line 1565 | Read Idx Count
1565    RDB$SECURITY_CLASSES = 8
1566    RDB$TYPES = 2
1567    RDB$TRIGGERS = 25
1568 <  RDB$USER_PRIVILEGES = 805
1568 >  RDB$USER_PRIVILEGES = 816
1569    RDB$GENERATORS = 5
1570    RDB$CHARACTER_SETS = 2
1571    RDB$COLLATIONS = 2
1572    RDB$ROLES = 1
1573  
1574   Read Seq Count
1575 <  RDB$PAGES = 98
1575 >  RDB$PAGES = 100
1576    RDB$DATABASE = 25
1577 <  RDB$RELATIONS = 65
1577 >  RDB$RELATIONS = 66
1578  
1579   Database is Read/Write
1580   Hex Dump of Database Page 100:
# Line 3297 | Line 3297 | SALARY = 32,000.00
3297   FULL_NAME = Guckenheimer, Mark
3298   DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance (Charset Id = 4 Codepage = 65001)
3299   DEPT_KEY_PATH = 000;600;620;622 (Charset Id = 4 Codepage = 65001)
3300 < Current memory = 19,651,184
3300 > Current memory = 19,669,072
3301   Delta memory = 16,416
3302 < Max memory = 19,746,848
3303 < Elapsed time= 0.024 sec
3304 < Cpu = 0.000 sec
3302 > Max memory = 19,764,736
3303 > Elapsed time= 0.023 sec
3304 > Cpu = 0.010 sec
3305   Buffers = 2048
3306   Reads = 2
3307   Writes = 0
# Line 4005 | Line 4005 | CREATE TABLE JOB
4005   PRIMARY KEY (JOB_CODE, JOB_GRADE, JOB_COUNTRY)
4006   );
4007  
4008 + /* Table: LOTSOFDATA, Owner: SYSDBA */
4009 +
4010 + CREATE TABLE LOTSOFDATA
4011 + (
4012 +        ROWID   INTEGER NOT NULL,
4013 +        THEDATE TIMESTAMP,
4014 +        MYTEXT  VARCHAR(1024),
4015 + PRIMARY KEY (ROWID)
4016 + );
4017 +
4018   /* Table: PROJECT, Owner: SYSDBA */
4019  
4020   CREATE TABLE PROJECT
# Line 11764 | Line 11774 | Event Handled: EVENT2, Count = 0
11774  
11775   ------------------------------------------------------
11776   Running Test 12: Test use of Services Connection
11777 < Firebird Library PathName = /opt/firebird4rc1/lib/libfbclient.so
11777 > Firebird Library PathName = /opt/firebird4.0.0/lib/libfbclient.so
11778   Connect String = localhost:service_mgr
11779 < Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1
11779 > Server Version = LI-V4.0.0.2496 Firebird 4.0
11780   Server Implementation = Firebird/Linux/AMD/Intel/x64
11781   Service Version = 2
11782 < Firebird Release = 4.0.0 (Build no. 2353)
11782 > Firebird Release = 4.0.0 (Build no. 2496)
11783   No. of attachments = 0
11784   No. of databases = 0
11785 < Base Location = /opt/firebird4rc1/
11785 > Base Location = /opt/firebird4.0.0/
11786   Lock File Location = /tmp/firebird/
11787 < Security Database Location = /opt/firebird4rc1/security4.fdb
11788 < Message File Location = /opt/firebird4rc1/
11787 > Security Database Location = /opt/firebird4.0.0/security4.fdb
11788 > Message File Location = /opt/firebird4.0.0/
11789   Database Statistics for employee
11790  
11791 < Database "/opt/firebird4rc1/examples/empbuild/employee.fdb"
11792 < Gstat execution time Thu Feb 18 17:07:27 2021
11791 > Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb"
11792 > Gstat execution time Mon Aug 23 11:37:16 2021
11793  
11794   Database header page information:
11795   Flags                   0
11796 < Generation              1016
11796 > Generation              1124
11797   System Change Number    0
11798   Page size               8192
11799   ODS version             13.0
11800 < Oldest transaction      1192
11801 < Oldest active           1193
11802 < Oldest snapshot         1193
11803 < Next transaction        1193
11800 > Oldest transaction      1185
11801 > Oldest active           1186
11802 > Oldest snapshot         1186
11803 > Next transaction        1186
11804   Sequence number         0
11805 < Next attachment ID      899
11805 > Next attachment ID      832
11806   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
11807   Shadow count            0
11808   Page buffers            0
11809   Next header page        0
11810   Database dialect        3
11811 < Creation date           Feb 1, 2021 14:57:08
11811 > Creation date           May 29, 2021 15:47:30
11812   Attributes              force write
11813  
11814   Variable header data:
11815 < Database GUID:  {22038096-B66F-4FBA-B3DF-A02ECCE5380E}
11815 > Database GUID:  {7D20C88E-C496-4598-99F9-E33293AFA7E3}
11816   *END*
11817  
11818  
11819   Database file sequence:
11820 < File /opt/firebird4rc1/examples/empbuild/employee.fdb is the only file
11820 > File /opt/firebird4.0.0/examples/empbuild/employee.fdb is the only file
11821  
11822   Analyzing database pages ...
11823   COUNTRY (128)
# Line 11866 | Line 11876 | EMPLOYEE_PROJECT (134)
11876   Primary pointer page: 258, Index root page: 259
11877   Pointer pages: 1, data page slots: 1
11878   Data pages: 1, average fill: 10%
11879 < Primary pages: 1, secondary pages: 0, swept pages: 1
11879 > Primary pages: 1, secondary pages: 0, swept pages: 0
11880   Empty pages: 0, full pages: 0
11881   Fill distribution:
11882   0 - 19% = 1
# Line 11879 | Line 11889 | JOB (129)
11889   Primary pointer page: 229, Index root page: 230
11890   Pointer pages: 1, data page slots: 2
11891   Data pages: 2, average fill: 54%
11892 < Primary pages: 1, secondary pages: 1, swept pages: 1
11892 > Primary pages: 1, secondary pages: 1, swept pages: 0
11893   Empty pages: 0, full pages: 0
11894   Fill distribution:
11895   0 - 19% = 0
# Line 11888 | Line 11898 | Fill distribution:
11898   60 - 79% = 1
11899   80 - 99% = 0
11900  
11901 + LOTSOFDATA (140)
11902 + Primary pointer page: 285, Index root page: 311
11903 + Pointer pages: 1, data page slots: 0
11904 + Data pages: 0, average fill: 0%
11905 + Primary pages: 0, secondary pages: 0, swept pages: 0
11906 + Empty pages: 0, full pages: 0
11907 + Fill distribution:
11908 + 0 - 19% = 0
11909 + 20 - 39% = 0
11910 + 40 - 59% = 0
11911 + 60 - 79% = 0
11912 + 80 - 99% = 0
11913 +
11914   PROJECT (133)
11915   Primary pointer page: 251, Index root page: 252
11916   Pointer pages: 1, data page slots: 2
# Line 11918 | Line 11941 | SALARY_HISTORY (136)
11941   Primary pointer page: 270, Index root page: 271
11942   Pointer pages: 1, data page slots: 1
11943   Data pages: 1, average fill: 30%
11944 < Primary pages: 1, secondary pages: 0, swept pages: 1
11944 > Primary pages: 1, secondary pages: 0, swept pages: 0
11945   Empty pages: 0, full pages: 0
11946   Fill distribution:
11947   0 - 19% = 0
# Line 11940 | Line 11963 | Fill distribution:
11963   60 - 79% = 0
11964   80 - 99% = 0
11965  
11966 < Gstat completion time Thu Feb 18 17:07:28 2021
11966 > Gstat completion time Mon Aug 23 11:37:16 2021
11967  
11968  
11969  
11970   Server Log
11971  
11972 < zeus    Thu Feb 11 14:23:45 2021
11973 < firebird4rc1/bin/fbguard: guardian starting /opt/firebird4rc1/bin/firebird
11972 > zeus    Wed Jun  9 10:07:18 2021
11973 > firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird
11974  
11975   Online Validation
11976 < 17:07:32.35 Validation started
11976 > 11:37:16.89 Validation started
11977  
11978 < 17:07:32.35 Relation 128 (COUNTRY)
11979 < 17:07:32.35   process pointer page    0 of    1
11980 < 17:07:32.35 Index 1 (RDB$PRIMARY1)
11981 < 17:07:32.35 Relation 128 (COUNTRY) is ok
11982 <
11983 < 17:07:32.35 Relation 129 (JOB)
11984 < 17:07:32.35   process pointer page    0 of    1
11985 < 17:07:32.35 Index 1 (RDB$PRIMARY2)
11986 < 17:07:32.35 Index 2 (RDB$FOREIGN3)
11987 < 17:07:32.35 Index 3 (MAXSALX)
11988 < 17:07:32.35 Index 4 (MINSALX)
11989 < 17:07:32.35 Relation 129 (JOB) is ok
11990 <
11991 < 17:07:32.35 Relation 130 (DEPARTMENT)
11992 < 17:07:32.35   process pointer page    0 of    1
11993 < 17:07:32.35 Index 1 (RDB$4)
11994 < 17:07:32.35 Index 2 (RDB$PRIMARY5)
11995 < 17:07:32.35 Index 3 (RDB$FOREIGN6)
11996 < 17:07:32.35 Index 4 (BUDGETX)
11997 < 17:07:32.35 Index 5 (RDB$FOREIGN10)
11998 < 17:07:32.35 Relation 130 (DEPARTMENT) is ok
11999 <
12000 < 17:07:32.35 Relation 131 (EMPLOYEE)
12001 < 17:07:32.35   process pointer page    0 of    1
12002 < 17:07:32.35 Index 1 (RDB$PRIMARY7)
12003 < 17:07:32.35 Index 2 (RDB$FOREIGN8)
12004 < 17:07:32.35 Index 3 (RDB$FOREIGN9)
12005 < 17:07:32.35 Index 4 (NAMEX)
12006 < 17:07:32.35 Relation 131 (EMPLOYEE) is ok
12007 <
12008 < 17:07:32.35 Relation 133 (PROJECT)
12009 < 17:07:32.35   process pointer page    0 of    1
12010 < 17:07:32.35 Index 1 (RDB$11)
12011 < 17:07:32.35 Index 2 (RDB$PRIMARY12)
12012 < 17:07:32.35 Index 3 (RDB$FOREIGN13)
12013 < 17:07:32.35 Index 4 (PRODTYPEX)
12014 < 17:07:32.35 Relation 133 (PROJECT) is ok
12015 <
12016 < 17:07:32.35 Relation 134 (EMPLOYEE_PROJECT)
12017 < 17:07:32.35   process pointer page    0 of    1
12018 < 17:07:32.35 Index 1 (RDB$PRIMARY14)
12019 < 17:07:32.35 Index 2 (RDB$FOREIGN15)
12020 < 17:07:32.35 Index 3 (RDB$FOREIGN16)
12021 < 17:07:32.35 Relation 134 (EMPLOYEE_PROJECT) is ok
12022 <
12023 < 17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET)
12024 < 17:07:32.35   process pointer page    0 of    1
12025 < 17:07:32.35 Index 1 (RDB$PRIMARY17)
12026 < 17:07:32.35 Index 2 (RDB$FOREIGN18)
12027 < 17:07:32.35 Index 3 (RDB$FOREIGN19)
12028 < 17:07:32.35 Relation 135 (PROJ_DEPT_BUDGET) is ok
12029 <
12030 < 17:07:32.35 Relation 136 (SALARY_HISTORY)
12031 < 17:07:32.35   process pointer page    0 of    1
12032 < 17:07:32.35 Index 1 (RDB$PRIMARY20)
12033 < 17:07:32.36 Index 2 (RDB$FOREIGN21)
12034 < 17:07:32.36 Index 3 (CHANGEX)
12035 < 17:07:32.36 Index 4 (UPDATERX)
12036 < 17:07:32.36 Relation 136 (SALARY_HISTORY) is ok
12037 <
12038 < 17:07:32.36 Relation 137 (CUSTOMER)
12039 < 17:07:32.36   process pointer page    0 of    1
12040 < 17:07:32.36 Index 1 (RDB$PRIMARY22)
12041 < 17:07:32.36 Index 2 (RDB$FOREIGN23)
12042 < 17:07:32.36 Index 3 (CUSTNAMEX)
12043 < 17:07:32.36 Index 4 (CUSTREGION)
12044 < 17:07:32.36 Relation 137 (CUSTOMER) is ok
12045 <
12046 < 17:07:32.36 Relation 138 (SALES)
12047 < 17:07:32.36   process pointer page    0 of    1
12048 < 17:07:32.36 Index 1 (RDB$PRIMARY24)
12049 < 17:07:32.36 Index 2 (RDB$FOREIGN25)
12050 < 17:07:32.36 Index 3 (RDB$FOREIGN26)
12051 < 17:07:32.36 Index 4 (NEEDX)
12052 < 17:07:32.36 Index 5 (QTYX)
12053 < 17:07:32.36 Index 6 (SALESTATX)
12054 < 17:07:32.36 Relation 138 (SALES) is ok
11978 > 11:37:16.89 Relation 128 (COUNTRY)
11979 > 11:37:16.89   process pointer page    0 of    1
11980 > 11:37:16.89 Index 1 (RDB$PRIMARY1)
11981 > 11:37:16.89 Relation 128 (COUNTRY) is ok
11982 >
11983 > 11:37:16.89 Relation 129 (JOB)
11984 > 11:37:16.89   process pointer page    0 of    1
11985 > 11:37:16.89 Index 1 (RDB$PRIMARY2)
11986 > 11:37:16.89 Index 2 (RDB$FOREIGN3)
11987 > 11:37:16.89 Index 3 (MAXSALX)
11988 > 11:37:16.89 Index 4 (MINSALX)
11989 > 11:37:16.89 Relation 129 (JOB) is ok
11990 >
11991 > 11:37:16.89 Relation 130 (DEPARTMENT)
11992 > 11:37:16.89   process pointer page    0 of    1
11993 > 11:37:16.89 Index 1 (RDB$4)
11994 > 11:37:16.89 Index 2 (RDB$PRIMARY5)
11995 > 11:37:16.89 Index 3 (RDB$FOREIGN6)
11996 > 11:37:16.89 Index 4 (BUDGETX)
11997 > 11:37:16.89 Index 5 (RDB$FOREIGN10)
11998 > 11:37:16.89 Relation 130 (DEPARTMENT) is ok
11999 >
12000 > 11:37:16.89 Relation 131 (EMPLOYEE)
12001 > 11:37:16.89   process pointer page    0 of    1
12002 > 11:37:16.89 Index 1 (RDB$PRIMARY7)
12003 > 11:37:16.89 Index 2 (RDB$FOREIGN8)
12004 > 11:37:16.89 Index 3 (RDB$FOREIGN9)
12005 > 11:37:16.89 Index 4 (NAMEX)
12006 > 11:37:16.89 Relation 131 (EMPLOYEE) is ok
12007 >
12008 > 11:37:16.89 Relation 133 (PROJECT)
12009 > 11:37:16.89   process pointer page    0 of    1
12010 > 11:37:16.89 Index 1 (RDB$11)
12011 > 11:37:16.89 Index 2 (RDB$PRIMARY12)
12012 > 11:37:16.90 Index 3 (RDB$FOREIGN13)
12013 > 11:37:16.90 Index 4 (PRODTYPEX)
12014 > 11:37:16.90 Relation 133 (PROJECT) is ok
12015 >
12016 > 11:37:16.90 Relation 134 (EMPLOYEE_PROJECT)
12017 > 11:37:16.90   process pointer page    0 of    1
12018 > 11:37:16.90 Index 1 (RDB$PRIMARY14)
12019 > 11:37:16.90 Index 2 (RDB$FOREIGN15)
12020 > 11:37:16.90 Index 3 (RDB$FOREIGN16)
12021 > 11:37:16.90 Relation 134 (EMPLOYEE_PROJECT) is ok
12022 >
12023 > 11:37:16.90 Relation 135 (PROJ_DEPT_BUDGET)
12024 > 11:37:16.90   process pointer page    0 of    1
12025 > 11:37:16.90 Index 1 (RDB$PRIMARY17)
12026 > 11:37:16.90 Index 2 (RDB$FOREIGN18)
12027 > 11:37:16.90 Index 3 (RDB$FOREIGN19)
12028 > 11:37:16.90 Relation 135 (PROJ_DEPT_BUDGET) is ok
12029 >
12030 > 11:37:16.90 Relation 136 (SALARY_HISTORY)
12031 > 11:37:16.90   process pointer page    0 of    1
12032 > 11:37:16.90 Index 1 (RDB$PRIMARY20)
12033 > 11:37:16.91 Index 2 (RDB$FOREIGN21)
12034 > 11:37:16.91 Index 3 (CHANGEX)
12035 > 11:37:16.92 Index 4 (UPDATERX)
12036 > 11:37:16.92 Relation 136 (SALARY_HISTORY) is ok
12037 >
12038 > 11:37:16.92 Relation 137 (CUSTOMER)
12039 > 11:37:16.92   process pointer page    0 of    1
12040 > 11:37:16.92 Index 1 (RDB$PRIMARY22)
12041 > 11:37:16.92 Index 2 (RDB$FOREIGN23)
12042 > 11:37:16.92 Index 3 (CUSTNAMEX)
12043 > 11:37:16.92 Index 4 (CUSTREGION)
12044 > 11:37:16.92 Relation 137 (CUSTOMER) is ok
12045 >
12046 > 11:37:16.92 Relation 138 (SALES)
12047 > 11:37:16.92   process pointer page    0 of    1
12048 > 11:37:16.92 Index 1 (RDB$PRIMARY24)
12049 > 11:37:16.92 Index 2 (RDB$FOREIGN25)
12050 > 11:37:16.92 Index 3 (RDB$FOREIGN26)
12051 > 11:37:16.92 Index 4 (NEEDX)
12052 > 11:37:16.92 Index 5 (QTYX)
12053 > 11:37:16.92 Index 6 (SALESTATX)
12054 > 11:37:16.92 Relation 138 (SALES) is ok
12055 >
12056 > 11:37:16.92 Relation 140 (LOTSOFDATA)
12057 > 11:37:16.92   process pointer page    0 of    1
12058 > 11:37:16.93 Index 1 (RDB$PRIMARY28)
12059 > 11:37:16.93 Relation 140 (LOTSOFDATA) is ok
12060  
12061 < 17:07:32.36 Validation finished
12061 > 11:37:16.93 Validation finished
12062  
12063  
12064   Normal Validation
# Line 12166 | Line 12194 | Employee Database is Online = FALSE
12194   Employee Database is Online = TRUE
12195  
12196   Starting Backup
12197 < Backup Completed - File Size = 80384 bytes
12197 > Backup Completed - File Size = 81408 bytes
12198   Restore Started
12199  
12200   Restore Completed
# Line 13315 | Line 13343 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13343  
13344   Rows printed = 2
13345  
13346 < Current memory = 19,649,408
13346 > Current memory = 19,667,296
13347   Delta memory = 16,032
13348 < Max memory = 19,744,992
13349 < Elapsed time= 0.001 sec
13348 > Max memory = 19,762,880
13349 > Elapsed time= 0.002 sec
13350   Cpu = 0.000 sec
13351   Buffers = 2048
13352   Reads = 2
# Line 13542 | Line 13570 | Test_Transaction_13: [Commit (Hard commi
13570   *Monitor*  
13571   [Application: IBX Test Suite]
13572   Test_Database_13: [Disconnect]
13573 + *Monitor*  
13574 + [Application: IBX Test Suite]
13575 + Monitoring Disabled
13576   33 ISQL Monitor Messages Received
13577  
13578  
# Line 13580 | Line 13611 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13611  
13612   Rows printed = 2
13613  
13614 < Current memory = 19,649,408
13614 > Current memory = 19,667,296
13615   Delta memory = 16,032
13616 < Max memory = 19,744,992
13616 > Max memory = 19,762,880
13617   Elapsed time= 0.102 sec
13618   Cpu = 0.000 sec
13619   Buffers = 2048
# Line 13806 | Line 13837 | Test_Transaction_14: [Commit (Hard commi
13837   *Monitor*  
13838   [Application: IBX Test Suite]
13839   Test_Database_14: [Disconnect]
13840 + *Monitor*  
13841 + [Application: IBX Test Suite]
13842 + Monitoring Disabled
13843   33 ISQL Monitor Messages Received
13844  
13845  
# Line 15198 | Line 15232 | Create Table LotsOfData (
15232      MyText VarChar(1024),
15233      Primary Key (RowID)
15234    );                
15235 < Loading data into database table. Started at 18/2/2021 17:08:20.034
15236 < Data load completed at 18/2/2021 17:09:56.119 Elapsed Time = 96085 ms, 100000 records loaded
15237 < MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024
15238 < Database Read started at 18/2/2021 17:09:56.141
15239 < Read Dataset completed at 18/2/2021 17:10:29.759 Elapsed Time = 33618 ms, 100000 records read
15240 < MD5 checksum = 78516f380a41fc5a972b7c9b5ac14024
15235 > Loading data into database table. Started at 23/8/2021 11:38:02.975
15236 > Data load completed at 23/8/2021 11:39:43.211 Elapsed Time = 100236 ms, 100000 records loaded
15237 > Message Hash = c7644e3f9525eb5f8fc59089aecb88ec
15238 > Database Read started at 23/8/2021 11:39:43.222
15239 > Read Dataset completed at 23/8/2021 11:40:13.683 Elapsed Time = 30461 ms, 100000 records read
15240 > Message Hash = c7644e3f9525eb5f8fc59089aecb88ec
15241   Test Completed successfully
15242 + 23/8/2021 11:40:13.683 Test 21 passes as long as the checksums are identical
15243  
15244  
15245   ------------------------------------------------------

Diff Legend

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