search

servalproject / serval-dna

The Serval Project's core daemon that implements Distributed Numbering Architecture (DNA), MDP, VoMP, Rhizome, MeshMS, etc.
http://servalproject.org
Other
170 stars 81 forks source link

MeshMS update fileblob unique constrained failed. #109

Open adur1990 opened 8 years ago

adur1990 commented 8 years ago 
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