Hi, Excellent! The sqlquery command followed by the PRAGMA "query" did the trick. I was now able to create full backups of my systems again.
Martin en Arno thank you both very much for you help! Regards, J. Arno Lehmann writes: > Hello, > > 02.06.2009 07:59, Johan van Vliet wrote: >> Hi all, >> >> With help from this list I discovered that a temporary SQLite3 file is >> filling up my root file system. For incrementals and differentials this is >> not a problem. Full backups, however, fail because the / (root) fills to >> 100%. >> >> I've created the largest possible root for my setup (= flashboot/ramdrive) >> >> I discovered that Sqlite3 supports a statement that will allow you to direct >> the temp file to an other directory (where I have plenty of space) using the >> statement: >> >> PRAGMA temp_store_directory = 'directory-name'; >> >> Is there anyway I can configure this from bacula or do I need to manually >> patch the director and recompile? And If I need to patch is myself is it >> sufficient to patch only "sql_create.c"? > > Try the following: > Use bconsole to execute an SQL query and issue the command you need: > sqlquery > PRAGMA temp_store_directory = 'directory-name'; > > ^^ > This is a blank line to leave SQL query mode > > Run a full job, or check somehow if the command was successfull. > > If that works, I'd simply modify my start scripts to execute something > like > echo 'sqlquery > PRAGMA temp_store_directory = 'directory-name'; > > ' | bconsole -c ... > a few seconds after the DIR starts up. > > Alternatively, you could set up an admin job to set this, scheduled to > run every hour or so - I assume setting this more often than strictly > necessary won't hurt. > > Arno > >> Best regards, >> J. >> >> >> >> >>> 15007 bacula-dir GIO fd 15 wrote 1024 bytes >>> "SQLite format 3 >>> ........................................................................... >>> ...........CREATE TABLE batch (FileIndex integer,J\ >>> obId integer,Path blob,Name blob,LStat tinyblob,MD5 tinyblob)" >>> >> ... >>> Based on the file "cats/sql_create.c" (my_batch_start) in the bacula source >>> I would guess it is a "temporary database". >> >> >> >> ----------------------------------------------------------------------------- >> OpenSolaris 2009.06 is a cutting edge operating system for enterprises >> looking to deploy the next generation of Solaris that includes the latest >> innovations from Sun and the OpenSource community. Download a copy and >> enjoy capabilities such as Networking, Storage and Virtualization. >> Go to: http://p.sf.net/sfu/opensolaris-get >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users >> > > -- > Arno Lehmann > IT-Service Lehmann > Sandstr. 6, 49080 Osnabrück > www.its-lehmann.de > > ------------------------------------------------------------------------------ > OpenSolaris 2009.06 is a cutting edge operating system for enterprises > looking to deploy the next generation of Solaris that includes the latest > innovations from Sun and the OpenSource community. Download a copy and > enjoy capabilities such as Networking, Storage and Virtualization. > Go to: http://p.sf.net/sfu/opensolaris-get > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
