On Wed, Jan 25, 2012 at 10:32 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 25 Jan 2012, at 3:18pm, John Elrick wrote: > > > So, it appears that something is making SQLite think the schema has > changed. > > Can you read the following: > > <http://www.sqlite.org/pragma.html#pragma_schema_version> > > If you think this corresponds to what you are seeing in the source code, > can you log the value returned by > > PRAGMA schema_version > > at various points ? Does the value returned by the PRAGMA agree with what > you see in > > db->flags&SQLITE_InternChanges > > ? Perhaps you can find that the PRAGMA value is changing when you see no > reason for it changing. > > The pragma becomes 63 at the very start of the tracked run and never changes. However, vdbeHalt continually reports that the schema has altered. schema from 56 to 57 changed on = 'create table preferences ( machine_user varchar(80), section text, value text, primary key(machine_user, section))' schema from 61 to 62 changed on = 'create table if not exists passthrough_attributes (Passthrough_attribute_oid integer, manifest_identifier varchar, element_name varchar, attribute_name varchar, value varchar)' schema from 62 to 63 changed on = 'create trigger if not exists manifest_ad2 after delete on manifests begin delete from passthrough_attributes where manifest_identifier = old.manifest_oid; end;' Schema has changed current state = 'db=03FB1188, db->aDb[pOp->p1].pSchema=02110B18, db->aDb[pOp->p1].pSchema->schema_cookie=63, db->aDb[pOp->p1].pSchema->iGeneration=0, u.av.iMeta=63, u.av.iGen=0, pOp->p1=0, pOp->p2=61, pOp->p3=0' Schema has changed sql = 'INSERT INTO TABSHEETS VALUES (null, :workbookType, :manifestOid, :surveyOid, :formDefinitionId, :prefKey, :name, :originalName, :sequence, :columnList)' vdbeHalt rollback or commit schema changes = 'p->rc=17, db->flags=48100a00, db->flags&SQLITE_InternChanges=200' Schema has changed current state = 'db=03FB1188, db->aDb[pOp->p1].pSchema=02110B18, db->aDb[pOp->p1].pSchema->schema_cookie=63, db->aDb[pOp->p1].pSchema->iGeneration=1, u.av.iMeta=63, u.av.iGen=1, pOp->p1=0, pOp->p2=61, pOp->p3=0' Schema has changed sql = 'select distinct FORM_DEFINITIONS.FORM_DEFINITION_OID from FORM_DEFINITIONS where FORM_DEFINITIONS.guid=:FORM_DEFINITIONS_guid order by FORM_DEFINITIONS.rowid ' vdbeHalt rollback or commit schema changes = 'p->rc=17, db->flags=48100a00, db->flags&SQLITE_InternChanges=200' Schema has changed current state = 'db=03FB1188, db->aDb[pOp->p1].pSchema=02110B18, db->aDb[pOp->p1].pSchema->schema_cookie=63, db->aDb[pOp->p1].pSchema->iGeneration=2, u.av.iMeta=63, u.av.iGen=2, pOp->p1=0, pOp->p2=63, pOp->p3=0' Schema has changed sql = 'select distinct FORM_DEFINITIONS.FORM_DEFINITION_OID from FORM_DEFINITIONS, SURVEYS where SURVEYS.SURVEY_OID=:SURVEYS_SURVEY_OID and FORM_DEFINITIONS.FORM_DEFINITION_OID=:FORM_DEFINITIONS_FORM_DEFINITION_OID and FORM_DEFINITIONS.definition_parent=SURVEYS.SURVEY_OID order by FORM_DEFINITIONS.rowid ' vdbeHalt rollback or commit schema changes = 'p->rc=17, db->flags=48100a00, db->flags&SQLITE_InternChanges=200' Schema has changed current state = 'db=03FB1188, db->aDb[pOp->p1].pSchema=02110B18, db->aDb[pOp->p1].pSchema->schema_cookie=63, db->aDb[pOp->p1].pSchema->iGeneration=3, u.av.iMeta=63, u.av.iGen=3, pOp->p1=0, pOp->p2=61, pOp->p3=0' Schema has changed sql = 'insert into background_constraints values ( :sequence_instance_oid , :sequence_definition_oid ) ' vdbeHalt rollback or commit schema changes = 'p->rc=17, db->flags=48100a00, db->flags&SQLITE_InternChanges=200' Schema has changed current state = 'db=03FB1188, db->aDb[pOp->p1].pSchema=02110B18, db->aDb[pOp->p1].pSchema->schema_cookie=63, db->aDb[pOp->p1].pSchema->iGeneration=4, u.av.iMeta=63, u.av.iGen=4, pOp->p1=0, pOp->p2=63, pOp->p3=2' Schema has changed sql = 'select distinct FORM_DEFINITIONS.FORM_DEFINITION_OID from FORM_DEFINITIONS where FORM_DEFINITIONS.guid=:FORM_DEFINITIONS_guid order by FORM_DEFINITIONS.rowid ' vdbeHalt rollback or commit schema changes = 'p->rc=17, db->flags=48100a00, db->flags&SQLITE_InternChanges=200' ... There are 9,775 more messages like these in the queue. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users