Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ISQL's "show database" command works wrong with 64-bit numbers [CORE5870] #6129

Closed
firebird-issue-importer opened this issue Jul 10, 2018 · 5 comments

Comments

@firebird-issue-importer

Submitted by: @hvlad

\firebird>gstat -h s:\temp\tx.30.fdb

Database "S:\TEMP\TX.30.FDB"
Gstat execution time Tue Jul 10 18:32:41 2018

Database header page information:
Flags 0
Generation 1977120
System Change Number 0
Page size 16384
ODS version 12.0
Oldest transaction 4294965022
Oldest active 4294985534
Oldest snapshot 4294985534
Next transaction 4294985534
...

while isql show zero's:

\firebird>isql s:\temp\tx.30.fdb
Database: s:\temp\tx.30.fdb, User: SYSDBA
SQL> show database;
Database: s:\temp\tx.30.fdb
Owner: SYSDBA
PAGE_SIZE 16384
Number of DB pages allocated = 68818
Number of DB pages used = 66037
Number of DB pages free = 2781
Sweep interval = 0
Forced Writes are OFF
Transaction - oldest = 0
Transaction - oldest active = 0
Transaction - oldest snapshot = 0
Transaction - Next = 0
ODS = 12.0
Database not encrypted
Default Character set: NONE

Commits: ea010ed b248e09

====== Test Details ======

It is not big problem to open fdb file and write into its header needed big values for Tx counters.
The real difficulty is to create multiple pages with type = TIP, with filling them and also to add references to them in RDB$PAGES (one *need* to create such pages otherwise bugcheck "cannot find tip page (165)" will raise).
This task looks impracticable, at least for nowadays.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2018

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2018

Modified by: @hvlad

summary: ISQL's show_database command works wrong with big numbers => ISQL's "show database" command works wrong with 64-bit numbers

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2018

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 8, 2019

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Cannot be tested

Test Details: It is not big problem to open fdb file and write into its header needed big values for Tx counters.
The real difficulty is to create multiple pages with type = TIP, with filling them and also to add references to them in RDB$PAGES (one *need* to create such pages otherwise bugcheck "cannot find tip page (165)" will raise).
This task looks impracticable, at least for nowadays.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 8, 2019

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment