So the "used bytes" are the same, but the "unused bytes" are not. That would seem to indicate the possibility that the "empty page" initialization is the difference. Some OSes will return zero'd out "new" sectors while some are perfectly happy to return whatever data happened to reside in the sector prior to it being allocated. If this is the case the "used contents" will be the same but the "unused bytes" will be different.
Is this what you are seeing? --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Karl Forner >Sent: Tuesday, 19 December, 2017 06:30 >To: SQLite mailing list >Subject: Re: [sqlite] same code produces a different database file on >different computers > >and the dumps usign the .dump sqlite3.exe command are also identical. > >On Tue, Dec 19, 2017 at 2:19 PM, Karl Forner <karl.for...@gmail.com> >wrote: > >> > Using the sqlite3 shell tool please give the command >> > SELECT * FROM sqlite_master; >> >> the results are identical >> >> table|_meta|_meta|2|CREATE TABLE "_meta"( "TABLENAME" TEXT NOT >NULL , >> "COLNAME" TEXT NOT NULL , "VARNAMES" TEXT , "LABELS" TEXT , >"PREFS" >> TEXT , PRIMARY KEY(TABLENAME,COLNAME)) >> index|sqlite_autoindex__meta_1|_meta|3| >> table|pk_model|pk_model|39020|CREATE TABLE "pk_model"( "MODEL" >TEXT >> , PRIMARY KEY(MODEL)) >> index|sqlite_autoindex_pk_model_1|pk_model|39021| >> table|tumor_data|tumor_data|39027|CREATE TABLE "tumor_data"( >"CRO" >> TEXT , "MODEL" TEXT , "SUBTYPE" TEXT , "QB_SUBTYPE" TEXT , >> "SUBTYPE_DEFINED_FOR_QUARTZBIO_INTERNAL_HISTO_SUBTYPING_CRO_ >> SUBTYPING_CONSIDERED_IN_CASE_IT_IS_MORE_SUBTYPE_SPECIFIC" TEXT , >> "TREATMENT_ARM_NO" INTEGER , "TREATMENT" TEXT , "DAY" TEXT , >"MEASURE" >> TEXT , "LBSTRESC" TEXT , FOREIGN KEY(MODEL) REFERENCES >pk_model(MODEL) ON >> UPDATE NO ACTION ON DELETE NO ACTION) >> table|sequencing_metadata|sequencing_metadata|7|CREATE TABLE >> "sequencing_metadata"( "ANALYSIS_ANALYSIS_NAME" TEXT , >> "ANALYSIS_DATASET_NAME" TEXT , "ANALYSIS_PROJECT_NAME" TEXT , >> "METADATA_NAME" TEXT , "METADATA_NUM" TEXT , "METADATA_STR" TEXT >, >> "SAMPLE_BATCH" TEXT , "SAMPLE_NAME" TEXT , "MODEL" TEXT , FOREIGN >> KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE >NO >> ACTION) >> table|excluded_mice|excluded_mice|1319|CREATE TABLE >"excluded_mice"( >> "MODEL" TEXT , "TREATMENT" TEXT , "COMMENT" TEXT , "X" TEXT , >FOREIGN >> KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE >NO >> ACTION) >> table|excluded_visits|excluded_visits|1320|CREATE TABLE >> "excluded_visits"( "MODEL" TEXT , "TREATMENT" TEXT , "VISIT" >TEXT , >> "COMMENT" TEXT , FOREIGN KEY(MODEL) REFERENCES pk_model(MODEL) ON >UPDATE NO >> ACTION ON DELETE NO ACTION) >> table|tumor_lungsubtypes|tumor_lungsubtypes|1321|CREATE TABLE >> "tumor_lungsubtypes"( "MODEL" TEXT , "SUBTYPE_COMBINED" TEXT , >FOREIGN >> KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE >NO >> ACTION) >> >> >> >> Here's a screenshot of some of the diffs using vbindiff >> >> https://ibb.co/kNm0X6 >> >> On Tue, Dec 19, 2017 at 1:48 PM, Simon Slavin ><slav...@bigfraud.org> >> wrote: >> >>> >>> >>> On 19 Dec 2017, at 12:43pm, Karl Forner <karl.for...@gmail.com> >wrote: >>> >>> > All the software in the docker container. so it is exactly the >same >>> version >>> > of all software and libraries, except the linux kernel. Moreover >the >>> > differences are not in the header, rather interspersed with what >looks >>> like >>> > CREATE statements. >>> >>> Using the sqlite3 shell tool please give the command >>> >>> SELECT * FROM sqlite_master; >>> >>> on one copy of the database. Are the CREATE commands in the >result the >>> same as the CREATE command you just told us about ? >>> >>> Issue the same SELECT command for the other copy of the database. >Do you >>> get identical output, in the same order, as you got from the first >copy of >>> the database ? >>> >>> Simon. >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@mailinglists.sqlite.org >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users >>> >> >> >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
