Hi,
I have an application running on a Windows Mobile 6 PDA with SQLite
database.
In a synchronization process I got the following logs from my application:
SQL: Insert Or Replace Into MSCLI
(CLICOD,CLINOM,CLIMOR,CLILOC,CLICPT,CLINCT,CLITPC,CLIPLA,CLIRES,CLIPRC,CLITEL,CLITLM,CLIFAX,CLIZON,CLICVD,CLIEML,CLIOBS,CLITDC,CLIDPP,CLINM2,CLIMO2,CLICT1,CLINIB,CLIREQ,CLIDTV,CLIDDV,CLILCE,CLIGP1,CLIGP2,CLIGP3,CLISU1,CLISU2,CLISU3,CLIIDA,CLIOBD,CLISU4,CLISU5,CLISU6,CLISU7,CLISU8,CLISU9,CLIPCA,CLIPCF,CLIPCC,CLIPBN,CLIUNA,CLITIP,CLICLA,CLICT2,CLICT3,CLICT4,CLICT5,CLICT6,CLICT7,CLICT8,CLICT9,CLIIVA,CLIST1,CLIST3)
Values('211010392','BARCAROLA(ARRABIDA SHOPPING)','CAFE SNACK
BAR,LDA.','ARRABIDA SHOPPING,LJ.218','4400 VILA NOVA DE
GAIA','123456','',0,0,1,'4354543','354543','','','','','',0,0,'','','','
. . .
','','',0,'','','','','?','GERAL','','','','','','','','','',0,0,0,0,0,'','','','','','','','','','','','N','S')
ERROR: database or disk is full
SQL: Insert Or Replace Into MSCLI
(CLICOD,CLINOM,CLIMOR,CLILOC,CLICPT,CLINCT,CLITPC,CLIPLA,CLIRES,CLIPRC,CLITEL,CLITLM,CLIFAX,CLIZON,CLICVD,CLIEML,CLIOBS,CLITDC,CLIDPP,CLINM2,CLIMO2,CLICT1,CLINIB,CLIREQ,CLIDTV,CLIDDV,CLILCE,CLIGP1,CLIGP2,CLIGP3,CLISU1,CLISU2,CLISU3,CLIIDA,CLIOBD,CLISU4,CLISU5,CLISU6,CLISU7,CLISU8,CLISU9,CLIPCA,CLIPCF,CLIPCC,CLIPBN,CLIUNA,CLITIP,CLICLA,CLICT2,CLICT3,CLICT4,CLICT5,CLICT6,CLICT7,CLICT8,CLICT9,CLIIVA,CLIST1,CLIST3)
Values('211010457','BARCAROLA(DOLCE VITA)','CUNHADOS & MANOS,
LDA','C.C.DOLCE VITA,LOJA 312 RUA CAMPEOES','EUROPEUS 4000
PORTO','234567','',0,0,1,'345435435','3454355445','','','','','',0,0,'','','','
. . .
','','',0,'','','','','D.RAQUEL','GERAL','','','','','','','','','',0,0,0,0,0,'','','','','','','','','','','','N','S')
ERROR: unable to open database file
SQL: Insert Or Replace Into MSCLI
(CLICOD,CLINOM,CLIMOR,CLILOC,CLICPT,CLINCT,CLITPC,CLIPLA,CLIRES,CLIPRC,CLITEL,CLITLM,CLIFAX,CLIZON,CLICVD,CLIEML,CLIOBS,CLITDC,CLIDPP,CLINM2,CLIMO2,CLICT1,CLINIB,CLIREQ,CLIDTV,CLIDDV,CLILCE,CLIGP1,CLIGP2,CLIGP3,CLISU1,CLISU2,CLISU3,CLIIDA,CLIOBD,CLISU4,CLISU5,CLISU6,CLISU7,CLISU8,CLISU9,CLIPCA,CLIPCF,CLIPCC,CLIPBN,CLIUNA,CLITIP,CLICLA,CLICT2,CLICT3,CLICT4,CLICT5,CLICT6,CLICT7,CLICT8,CLICT9,CLIIVA,CLIST1,CLIST3)
Values('211010406','ROCA DOCE CONFEITARIA+++++++++++++++++++','ROCA DOCE
CONFEITARIA, LDA++++++++++++++','RUA EMIDIO PINTO, 19 -
STA.MARINHA++++++','4400-670
V.N.GAIA+++++++++++++++++++++++','345678+++++++++++','',0,0,1,'2542345345','3454354343','','','','','',0,0,'+++++++++++CHEQUE
DEVOLVIDO+++++++++++++','','',' . . .
','','',0,'','','','','SR.MANUEL
VIEIRA','SUL4F','','','','','','','','','',0,0,0,0,0,'','','','','','','','','','','','N','S')
ERROR: unable to open database file
etc, etc, etc,
Then after the application restarted I got the same errors:
SQL: Insert Or Replace Into MSCLI
(CLICOD,CLINOM,CLIMOR,CLILOC,CLICPT,CLINCT,CLITPC,CLIPLA,CLIRES,CLIPRC,CLITEL,CLITLM,CLIFAX,CLIZON,CLICVD,CLIEML,CLIOBS,CLITDC,CLIDPP,CLINM2,CLIMO2,CLICT1,CLINIB,CLIREQ,CLIDTV,CLIDDV,CLILCE,CLIGP1,CLIGP2,CLIGP3,CLISU1,CLISU2,CLISU3,CLIIDA,CLIOBD,CLISU4,CLISU5,CLISU6,CLISU7,CLISU8,CLISU9,CLIPCA,CLIPCF,CLIPCC,CLIPBN,CLIUNA,CLITIP,CLICLA,CLICT2,CLICT3,CLICT4,CLICT5,CLICT6,CLICT7,CLICT8,CLICT9,CLIIVA,CLIST1,CLIST3)
Values('211015498','REST.DORNA
VELHA++++++++++++++++++++++++','REST.DORNA VELHA,
LDA+++++++++++++++++++','RUA DAS OLIVEIRAS,
Nº340++++++++++++++++','4405-889
V.N.GAIA+++++++++++++++++++++++','55443323222+++++++++++','',0,0,1,'5435354534','234543534','','','','','',0,0,'++++++++++++++++++++++++++++++++++++++++','','','
. . .
','','',0,'','','','','SR.VIEIRA','SUL5F','','','','','','','','','',0,0,0,0,0,'','','','','','','','','','','','N','S')
ERROR: database or disk is full
etc, etc, etc,
After another application restart I lost the database. The database file
got with 0 Bytes and no Journal file.
SQLite version is 3.6.4 and I am running things inside a transaction.
Anyone has any idea how can this happen that we loose the entire Data
Base. Or how can I prevent something like this from happening?
Is it to be expected that on a Disk Full situation we can loose
everything? Maybe on the rollback?
--
Cumprimentos / Best Regards
Filipe Madureira
-----------------------------------------------------------------------------
SYSDEV, LDA - Mobile Solutions
(www.sysdevsolutions.com)
Tel: +351 234188027
Fax: +351 234188400
-----------------------------------------------------------------------------
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
