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

Reply via email to