What is the full SQLite version you are using? You may be on an old broken
version.
On Thursday 05 May 2005 19:28, mollo wrote:
> Hi!
>
> After upgrading my director to 1.36.2 (some weeks ago) I see errors like :
>
> (sorry for formatting)
> 05-May 19:06 fw-dir: RestoreFiles.2005-05-05_19.06.17 Error:
> sql_update.c:111 sql_update.c:111 update UPDATE Job SET
> JobStatus='R',Level='F',StartTime='2005-05-05
> 19:06:20',ClientId=0,JobTDate=1115312780 WHERE JobId=2125 failed: database
> is locked
>
> 05-May 19:06 fw-dir: sql_update.c:111 UPDATE Job SET
> JobStatus='R',Level='F',StartTime='2005-05-05
> 19:06:20',ClientId=0,JobTDate=1115312780 WHERE JobId=2125
>
> 05-May 19:06 fw-dir: RestoreFiles.2005-05-05_19.06.17 Fatal error:
> sql_update.c:111 update UPDATE Job SET
> JobStatus='R',Level='F',StartTime='2005-05-05
> 19:06:20',ClientId=0,JobTDate=1115312780 WHERE JobId=2125 failed: database
> is locked
>
> 05-May 19:06 fw-dir: RestoreFiles.2005-05-05_19.06.17 Error:
> sql_update.c:166 sql_update.c:166 update UPDATE Job SET JobStatus='f',
> EndTime='2005-05-05 19:06:20', ClientId=NULL, JobBytes=0, JobFiles=0,
> JobErrors=0, VolSessionId=0, VolSessionTime=0, PoolId=NULL,
> FileSetId=NULL, JobTDate=1115312780 WHERE JobId=2125 failed: database is
> locked
>
> Such errors are given :
>
> -at end of Full Backup for some clients/jobs
> -during status of theses clients when performing full backup
> -when restoring such errors backup
>
> Strangely, other jobs and clients, even in full level are not erronous.
>
> My sqlite Database (ver. 2.8.14, is not big, about 260Kb)
>
> List jobs gave :
> | 2124 | Backup | 2005-05-05 09:21:54 | B | F | 0 |0 | R |
>
> and last Director status give :
>
> Terminated Jobs
>
> 2124 Full 96,241 2,870,325,676 OK 05-May-05 18:25 Backup
>
>
> As nasty effect, any restore is possible, failing with that msg " database
> is locked"
>
> Incremental jobs are running fine.
>
> Tried to restart all my Bacula services, check lsof with bacula.db. same
> shine.
>
> I'm not sure migrating to Mysql is about to solve that, since I'm thinking
> about a Bacula issue.
>
> Thanks for any information,
> Mathieu
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
