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

Incorrect size of volumes in multi volume database [CORE2532] #2942

Closed
firebird-issue-importer opened this issue Jun 28, 2009 · 6 comments
Closed

Comments

@firebird-issue-importer

Submitted by: @SENikitin

Is related to QA243

While creating multi-volume database, actual sizes of volumes are not corresponding to the number of pages set in RDB$FILES

set sql dialect 3;
create database 'c:\testmulti.fdb' user 'sysdba' password 'masterkey'
page_size 4096
length 1000
FILE 'c:\dbmv1.fd1' length 2000
FILE 'c:\dbmv1.fd2' length 3000
FILE 'c:\dbmv1.fd3' length 4000
FILE 'c:\dbmv1.fd4' length 5000;

create generator g1;
create table t1(c1 varchar(100));
insert into t1(c1) values ('test test test testtttttt test');
insert into t1 select * from t1 where gen_id(g1, 1)<1000000;
exit;

As a result, database files were created

29.06.2009 00:25 8 216 576 DBMV1.FD1 2006 pages
29.06.2009 00:25 12 357 632 DBMV1.FD2 3017 pages
29.06.2009 00:25 16 453 632 DBMV1.FD3 4017 pages
29.06.2009 00:25 38 703 104 DBMV1.FD4
29.06.2009 00:25 4 190 208 TESTMULTI.FDB -1023 pages

Commits: 9ac27ab a6345fe

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 28, 2009

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 28, 2009

Modified by: @hvlad

Version: 2.5 Beta 1 [ 10251 ]

Version: 2.5 Alpha 1 [ 10224 ]

Version: 2.1.3 [ 10302 ]

Fix Version: 2.5 RC1 [ 10300 ]

Fix Version: 2.1.4 [ 10361 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 28, 2009

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 16, 2009

Modified by: @pcisar

Link: This issue is related to QA243 [ QA243 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 21, 2010

Modified by: @dyemanov

security: Developers [ 10012 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 18, 2016

Modified by: @pavel-zotov

QA Status: No test

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