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

Comparing ibx/trunk/testsuite/FB4reference.log (file contents):
Revision 344 by tony, Wed Jul 7 11:53:54 2021 UTC vs.
Revision 345 by tony, Mon Aug 23 14:22:29 2021 UTC

# Line 641 | Line 641 | DEPT_KEY_PATH = 000;900 (Charset = UTF8
641  
642   Rows printed = 42
643  
644 < Current memory = 19,686,512
644 > Current memory = 19,688,352
645   Delta memory = 16,384
646 < Max memory = 19,781,408
647 < Elapsed time= 0.015 sec
646 > Max memory = 19,783,248
647 > Elapsed time= 0.027 sec
648   Cpu = 0.010 sec
649   Buffers = 2048
650   Reads = 2
# Line 1445 | Line 1445 | DPB: Item Count = 3
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 20 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 4019 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 1491 | Line 1491 | TPB: Item Count = 3
1491    isc_tpb_read
1492  
1493   Transaction Ending
1494 < Transaction Ended after 1999 ms
1494 > Transaction Ended after 2001 ms
1495   Idle Timer Expired for Test_Transaction_02
1496   Before Disconnect
1497 < inet://localhost/employee Disconnected after 2038 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 29 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 76 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 18 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 1531 | Line 1531 | on disk structure version 13.0
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/firebird4.0.0/examples/empbuild/employee.fdb
1537   DB Site Name = zeus
# Line 1543 | Line 1543 | ODS Minor Version = 0
1543   ODS Major Version = 13
1544   Page Size = 8192
1545   Version = LI-V6.3.0.2496 Firebird 4.0
1546 < Current Memory = 19501200
1546 > Current Memory = 19503040
1547   Forced Writes Enabled
1548 < Max Memory = 19627808
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,667,232
3300 > Current memory = 19,669,072
3301   Delta memory = 16,416
3302 < Max memory = 19,762,896
3303 < Elapsed time= 0.026 sec
3304 < Cpu = 0.020 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 11779 | Line 11789 | Message File Location = /opt/firebird4.0
11789   Database Statistics for employee
11790  
11791   Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb"
11792 < Gstat execution time Wed Jul  7 11:45:32 2021
11792 > Gstat execution time Mon Aug 23 11:37:16 2021
11793  
11794   Database header page information:
11795   Flags                   0
11796 < Generation              438
11796 > Generation              1124
11797   System Change Number    0
11798   Page size               8192
11799   ODS version             13.0
11800 < Oldest transaction      456
11801 < Oldest active           457
11802 < Oldest snapshot         457
11803 < Next transaction        457
11800 > Oldest transaction      1185
11801 > Oldest active           1186
11802 > Oldest snapshot         1186
11803 > Next transaction        1186
11804   Sequence number         0
11805 < Next attachment ID      274
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
# 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 11940 | Line 11963 | Fill distribution:
11963   60 - 79% = 0
11964   80 - 99% = 0
11965  
11966 < Gstat completion time Wed Jul  7 11:45:32 2021
11966 > Gstat completion time Mon Aug 23 11:37:16 2021
11967  
11968  
11969  
# Line 11950 | Line 11973 | zeus   Wed Jun  9 10:07:18 2021
11973   firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird
11974  
11975   Online Validation
11976 < 11:45:32.71 Validation started
11976 > 11:37:16.89 Validation started
11977  
11978 < 11:45:32.71 Relation 128 (COUNTRY)
11979 < 11:45:32.71   process pointer page    0 of    1
11980 < 11:45:32.71 Index 1 (RDB$PRIMARY1)
11981 < 11:45:32.71 Relation 128 (COUNTRY) is ok
11982 <
11983 < 11:45:32.71 Relation 129 (JOB)
11984 < 11:45:32.71   process pointer page    0 of    1
11985 < 11:45:32.71 Index 1 (RDB$PRIMARY2)
11986 < 11:45:32.71 Index 2 (RDB$FOREIGN3)
11987 < 11:45:32.71 Index 3 (MAXSALX)
11988 < 11:45:32.71 Index 4 (MINSALX)
11989 < 11:45:32.71 Relation 129 (JOB) is ok
11990 <
11991 < 11:45:32.71 Relation 130 (DEPARTMENT)
11992 < 11:45:32.71   process pointer page    0 of    1
11993 < 11:45:32.71 Index 1 (RDB$4)
11994 < 11:45:32.71 Index 2 (RDB$PRIMARY5)
11995 < 11:45:32.71 Index 3 (RDB$FOREIGN6)
11996 < 11:45:32.71 Index 4 (BUDGETX)
11997 < 11:45:32.71 Index 5 (RDB$FOREIGN10)
11998 < 11:45:32.71 Relation 130 (DEPARTMENT) is ok
11999 <
12000 < 11:45:32.71 Relation 131 (EMPLOYEE)
12001 < 11:45:32.71   process pointer page    0 of    1
12002 < 11:45:32.71 Index 1 (RDB$PRIMARY7)
12003 < 11:45:32.71 Index 2 (RDB$FOREIGN8)
12004 < 11:45:32.71 Index 3 (RDB$FOREIGN9)
12005 < 11:45:32.71 Index 4 (NAMEX)
12006 < 11:45:32.71 Relation 131 (EMPLOYEE) is ok
12007 <
12008 < 11:45:32.71 Relation 133 (PROJECT)
12009 < 11:45:32.71   process pointer page    0 of    1
12010 < 11:45:32.71 Index 1 (RDB$11)
12011 < 11:45:32.71 Index 2 (RDB$PRIMARY12)
12012 < 11:45:32.71 Index 3 (RDB$FOREIGN13)
12013 < 11:45:32.71 Index 4 (PRODTYPEX)
12014 < 11:45:32.71 Relation 133 (PROJECT) is ok
12015 <
12016 < 11:45:32.72 Relation 134 (EMPLOYEE_PROJECT)
12017 < 11:45:32.72   process pointer page    0 of    1
12018 < 11:45:32.72 Index 1 (RDB$PRIMARY14)
12019 < 11:45:32.72 Index 2 (RDB$FOREIGN15)
12020 < 11:45:32.72 Index 3 (RDB$FOREIGN16)
12021 < 11:45:32.72 Relation 134 (EMPLOYEE_PROJECT) is ok
12022 <
12023 < 11:45:32.72 Relation 135 (PROJ_DEPT_BUDGET)
12024 < 11:45:32.72   process pointer page    0 of    1
12025 < 11:45:32.72 Index 1 (RDB$PRIMARY17)
12026 < 11:45:32.72 Index 2 (RDB$FOREIGN18)
12027 < 11:45:32.72 Index 3 (RDB$FOREIGN19)
12028 < 11:45:32.73 Relation 135 (PROJ_DEPT_BUDGET) is ok
12029 <
12030 < 11:45:32.73 Relation 136 (SALARY_HISTORY)
12031 < 11:45:32.73   process pointer page    0 of    1
12032 < 11:45:32.73 Index 1 (RDB$PRIMARY20)
12033 < 11:45:32.73 Index 2 (RDB$FOREIGN21)
12034 < 11:45:32.73 Index 3 (CHANGEX)
12035 < 11:45:32.73 Index 4 (UPDATERX)
12036 < 11:45:32.73 Relation 136 (SALARY_HISTORY) is ok
12037 <
12038 < 11:45:32.73 Relation 137 (CUSTOMER)
12039 < 11:45:32.73   process pointer page    0 of    1
12040 < 11:45:32.73 Index 1 (RDB$PRIMARY22)
12041 < 11:45:32.73 Index 2 (RDB$FOREIGN23)
12042 < 11:45:32.73 Index 3 (CUSTNAMEX)
12043 < 11:45:32.73 Index 4 (CUSTREGION)
12044 < 11:45:32.73 Relation 137 (CUSTOMER) is ok
12045 <
12046 < 11:45:32.73 Relation 138 (SALES)
12047 < 11:45:32.73   process pointer page    0 of    1
12048 < 11:45:32.73 Index 1 (RDB$PRIMARY24)
12049 < 11:45:32.73 Index 2 (RDB$FOREIGN25)
12050 < 11:45:32.73 Index 3 (RDB$FOREIGN26)
12051 < 11:45:32.73 Index 4 (NEEDX)
12052 < 11:45:32.73 Index 5 (QTYX)
12053 < 11:45:32.73 Index 6 (SALESTATX)
12054 < 11:45:32.73 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 < 11:45:32.73 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,665,456
13346 > Current memory = 19,667,296
13347   Delta memory = 16,032
13348 < Max memory = 19,761,040
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 13583 | Line 13611 | DEPT_KEY_PATH = 000 (Charset = UTF8 Code
13611  
13612   Rows printed = 2
13613  
13614 < Current memory = 19,665,456
13614 > Current memory = 19,667,296
13615   Delta memory = 16,032
13616 < Max memory = 19,761,040
13616 > Max memory = 19,762,880
13617   Elapsed time= 0.102 sec
13618   Cpu = 0.000 sec
13619   Buffers = 2048
# Line 15204 | Line 15232 | Create Table LotsOfData (
15232      MyText VarChar(1024),
15233      Primary Key (RowID)
15234    );                
15235 < Loading data into database table. Started at 07/7/2021 11:46:17.204
15236 < Data load completed at 07/7/2021 11:48:00.164 Elapsed Time = 102960 ms, 100000 records loaded
15237 < MD5 checksum = 1c66cd114720b84a4fa21d01f8a0ba2b
15238 < Database Read started at 07/7/2021 11:48:00.174
15239 < Read Dataset completed at 07/7/2021 11:48:38.470 Elapsed Time = 38296 ms, 100000 records read
15240 < MD5 checksum = 1c66cd114720b84a4fa21d01f8a0ba2b
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 < 07/7/2021 11:48:38.470 Test 21 passes as long as the MD5 sums are identical
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