Skip to content

MeshMS update fileblob unique constrained failed. #109

@adur1990

Description

@adur1990
DEBUG:[ 6078] 11:19:20.157 rhizome_store.c:42:rhizome_exists()  rowcount=1 changes=1 result=1
DEBUG:[ 6072] 11:19:20.157 rhizome_store.c:797:rhizome_finish_write()  INSERT OR REPLACE INTO FILES(id,length,datavalid,inserttime,last_verified) VALUES('95285D1A25D12E62384FAECA7D7B21655F5F8C88E9E43061798C8E4F610149E64EB7A2901069E63D5B040A7C9E8116735B23EECAD68CED9707B563235264124B',21,1,1463656760054,1463656760054);
INFO: [ 6072] 11:19:20.157 rhizome_store.c:797:rhizome_finish_write()  succeeded on try 2 after 0.101 seconds (limit 5.000): INSERT OR REPLACE INTO FILES(id,length,datavalid,inserttime,last_verified) VALUES(?,?,1,?,?);
DEBUG:[ 6072] 11:19:20.157 rhizome_store.c:797:rhizome_finish_write()  rowcount=0 changes=1
DEBUG:[ 6072] 11:19:20.157 rhizome_store.c:817:rhizome_finish_write()  UPDATE FILEBLOBS SET id = '95285D1A25D12E62384FAECA7D7B21655F5F8C88E9E43061798C8E4F610149E64EB7A2901069E63D5B040A7C9E8116735B23EECAD68CED9707B563235264124B' WHERE rowid = 103
ERROR:[ 6072] 11:19:20.157 rhizome_store.c:817:rhizome_finish_write()  query failed (19), UNIQUE constraint failed: FILEBLOBS.id: UPDATE FILEBLOBS SET id = ? WHERE rowid = ?
DEBUG:[ 6072] 11:19:20.157 rhizome_store.c:817:rhizome_finish_write()  rowcount=0 changes=0
DEBUG:[ 6072] 11:19:20.157 rhizome_store.c:830:rhizome_finish_write()  ROLLBACK;
DEBUG:[ 6072] 11:19:20.158 rhizome_store.c:830:rhizome_finish_write()  rowcount=0 changes=0
DEBUG:[ 6072] 11:19:20.158 rhizome_store.c:667:rhizome_fail_write()  DELETE FROM FILEBLOBS WHERE rowid = 103;

node23.log.zip

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions