Re: [Bacula-users] Device "FileStorage" with MediaType "File" requested by DIR not found in SD Device resources.
Martin Simmons schrieb: > The most likely reasons I can think of are > * the config file is corrupted, e.g. extra entries at the start > Ok, i think this was the problem, but i don't know how this happen, perhaps c&p or something. But now the Backup works, and also over some days. Thanks for your help. Greetings Roger Meier -- Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Device "FileStorage" with MediaType "File" requested by DIR not found in SD Device resources.
Martin Simmons schrieb:
> What does
>
> status storage=File
>
> print, in particular the "Device status" part?
>
The Device Status Part of "status storage=File" prints out the following:
Device status:
Device "File" (/data/backup) is not open.
Device "LTO-2" (/dev/nst0) is not open.
Device "LTO-3" (/dev/nst1) is not open.
>
> Maybe the SD read a different config file
I think not, because in the init.d Script i have the following:
daemon /usr/sbin/bacula-sd $2 ${SD_OPTIONS} -c /etc/bacula/bacula-sd.conf
And this config is the correct, with the snipped that i have posted.
After a reboot now all backup jobs have this error, but i don't have changed
anything at the config since some days. (Because i have Input/Output
Errors on Device LTO-3,
but this is another Error but i think problem with the Tape Drive, and i
think not Part of this Problem).
Greetings
Roger Meier
--
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Device "FileStorage" with MediaType "File" requested by DIR not found in SD Device resources.
Hi all
We have some problem with bacula. I don't know where the Problem is,
because all of our
7 hosts have the same configuration (only different include/exclude file
list and hostname)
All works fine now for some weeks, but now since 3-4 days we have the
following problem,
on some of our system (not all, some works):
14-Sep 01:05 lin-backup1-sd JobId 990: Fatal error:
Device "FileStorage" with MediaType "File" requested by DIR not found in
SD Device resources.
14-Sep 01:05 lin-backup1-dir JobId 990: Fatal error:
Storage daemon didn't accept Device "FileStorage" because:
3924 Device "FileStorage" not in SD Device resources.
14-Sep 01:05 lin-backup1-dir JobId 990: Fatal error: Max wait time exceeded.
Job canceled.
We have setup a cancel after 4 hours, but this shoul'd not happen,
because the run of the
backup is max. 1-2 hours.
We have one Backup Host with one DIR and hone SD Daemon. See config
snipped below:
bacula-dir.conf:
# Definition of file storage device
Storage {
Name = File
Address = lin-backup1.intra
SDPort = 9103
Password = "pw4backup-sd"
Device = FileStorage
Media Type = File
Maximum Concurrent Jobs = 20
}
bacula-sd.conf:
Device {
Name = FileStorage
Media Type = File
Archive Device = /data/backup
LabelMedia = yes;
Random Access = Yes;
AutomaticMount = yes;
RemovableMedia = no;
AlwaysOpen = no;
Autochanger = no
}
I don't know where the Problem is , because this config works some weeks
but now this Errors :(
Bacula Version: Version: 3.0.1 (30 April 2009) on a CentOS 5.3
Greetings
Roger Meier
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Windows 2000 Permission (or other?) Confusion
Hi, A couple of days ago I installed bacula 3.0.1 on Debian Lenny x86, and successfully ran the first local test job. Then I installed a file daemon on a Windows 2000 SP4 Server, and as soon as I try to run a backup job from that FD, I receive this: win2000srv-fd JobId 41: Fatal error: /home/kern/bacula/k/src/filed/backup.c :948 Network send error to SD. ERR=Input/output error This is with my data directory e:\Share. When I tried to use something from different locations (another directories on the same drive, or some directories from drive c:), they are sent to my Debian bacula server ok, and I could also restore them back to a restore directory on the Windows machine. Tried to make a new file within e:\Share, and it backs up ok. Tried to change all permissions in e:\Share, -- doesn't help. Tried to run setacl: SetACL.exe -on "\\win200srv\share" -ot file -actn ace -ace "n:mydomain\administrator;p:change" -ace "n:S-1-5-32-544;p:full;s:y" -actn clear -clr "dacl,sacl" -actn rstchldrn -rst "dacl,sacl" -log "c:\my documents\setacl\log.txt" It executed ok, but didn't help. Tried to copy the whole directory to c:, and the same effect. The Bacula Service is run by "LocalSystem" user, as are all other system services, and on my Win2000 machine, there is no user named "SYSTEM" to change it to. Tried to run as Administrator but that didn't help, too. Now I'm out of ideas... Has anyone suggestions? -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Delete old job files from File Storage file
I have a FileVolume that is full. How do I purge about 50% of the files in this volume? This is why I need to reduce the size of the file. The FileVolume is in a partition that is now full. - Roger Sinel www.nordickiwi.com -- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacula 2.2.8 - EPEL
Anyone know of plans to add Bacula 2.2.8 to Extra Packages for Enterprise Linux (EPEL) ? http://download.fedora.redhat.com/pub/epel/5/i386/repoview/ - Roger Sinel www.nordickiwi.com -- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ang. Re: Two Directors - using one SD and one Pool
[EMAIL PROTECTED] wrote: > I have to configure two bacula-dir machines to use the same SD and pool. > > I'm testing with a File backup pool first before changing to Tape > Autochanger. I'm having a problem that both directors are creating there > own seperate Volumes for there jobs. I want them to use the same pool, > continue writing to the same append media. > Can I add a Pool line to the Storage part of the bacula-dir.conf? [EMAIL PROTECTED] wrote: > Of interest to me: Are both Directors using the same Catalog? No, they both have there own mysql datasbases on each server. One director has been running for nearly two years. I'am adding another director which will have a Tape Autochanger attached. I'd like to keep the old directer as untouched as possible as it's all set up and on a seperate net segment, I just want to send the data to the new SD. Is this the right choice or should I just use the new Director? /Roger Sinel - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Two Directors - using one SD and one Pool
I have to configure two bacula-dir machines to use the same SD and pool. I'm testing with a File backup pool first before changing to Tape Autochanger. I'm having a problem that both directors are creating there own seperate Volumes for there jobs. I want them to use the same pool, continue writing to the same append media. Can I add a Pool line to the Storage part of the bacula-dir.conf? - Roger Sinel www.nordickiwi.com - - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ang. Re: Ang. Re: Ang. Re: Unable to find Qt4 installation needed by bat
Hello Deval, I have edited me Howto to make it more understandable Use yum to get your correct qt packages. Install qt packages with yum # yum install qt4 qt4-devel-4.x.x qwt-5.0.x qwt-devel Download bacula-*.*.*.tar.gz package from sourceforge. /Roger Sinel www.nordickiwi.com Hi roger You have mentioned to download qt4 and qt4-devel library from sourceforge and install on bacula server, in order to compile and build bat. I am not been able to locate qt4 and qt4-devel on sourceforge, please help me to locate QT4 on Sourceforge. Thanking you. DEVAL KULSHRESTHA - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Dan Langille <[EMAIL PROTECTED]> Cc: bacula-users@lists.sourceforge.net Sent: Tuesday, 5 February, 2008 6:21:24 PM Subject: [Bacula-users] Ang. Re: Ang. Re: Unable to find Qt4 installation needed by bat Done - http://wiki.bacula.org/doku.php?id=howto_compile_and_install_bacula_with_bat_on_fedora_7_or_centos_5 - Roger Sinel - Dan Langille <[EMAIL PROTECTED]> 02/05/2008 12:28 PM Till [EMAIL PROTECTED] Kopia [EMAIL PROTECTED], bacula-users@lists.sourceforge.net Ärende Re: [Bacula-users] Ang. Re: Unable to find Qt4 installation needed by bat [EMAIL PROTECTED] wrote: > > Hello Deval, > I went through the same process with trying to get BAT to work with > Fedora7 and CentOS 5. Here is my own Howto after many hours of trial and > error. I hope it helps. > > http://nordickiwi.no-ip.com/mediawiki/index.php/Install_notes_-_from_source This seems worthy of addition to the Bacula wiki: http://wiki.bacula.org/doku.php -- Dan Langille - http://www.langille.org/ BSDCan - The Technical BSD Conference: http://www.bsdcan.org/ PGCon - The PostgreSQL Conference:http://www.pgcon.org/ -Inline Attachment Follows- - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ -Inline Attachment Follows- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Get the freedom to save as many mails as you wish. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ang. Re: Ang. Re: Unable to find Qt4 installation needed by bat
Done - http://wiki.bacula.org/doku.php?id=howto_compile_and_install_bacula_with_bat_on_fedora_7_or_centos_5 - Roger Sinel - Dan Langille <[EMAIL PROTECTED]> 02/05/2008 12:28 PM Till [EMAIL PROTECTED] Kopia [EMAIL PROTECTED], bacula-users@lists.sourceforge.net Ärende Re: [Bacula-users] Ang. Re: Unable to find Qt4 installation needed by bat [EMAIL PROTECTED] wrote: > > Hello Deval, > I went through the same process with trying to get BAT to work with > Fedora7 and CentOS 5. Here is my own Howto after many hours of trial and > error. I hope it helps. > > http://nordickiwi.no-ip.com/mediawiki/index.php/Install_notes_-_from_source This seems worthy of addition to the Bacula wiki: http://wiki.bacula.org/doku.php -- Dan Langille - http://www.langille.org/ BSDCan - The Technical BSD Conference: http://www.bsdcan.org/ PGCon - The PostgreSQL Conference:http://www.pgcon.org/ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ang. Re: Unable to find Qt4 installation needed by bat
Hello Deval, I went through the same process with trying to get BAT to work with Fedora7 and CentOS 5. Here is my own Howto after many hours of trial and error. I hope it helps. http://nordickiwi.no-ip.com/mediawiki/index.php/Install_notes_-_from_source - Roger Sinel - <[EMAIL PROTECTED]> Sänt av: [EMAIL PROTECTED] 02/05/2008 11:53 AM Till Ryan Novosielski <[EMAIL PROTECTED]> Kopia bacula-users@lists.sourceforge.net Ärende Re: [Bacula-users] Unable to find Qt4 installation needed by bat Dear sir Pls find attached my config.log file. I have tried to read through this file but didn't get any useful info. DEVAL KULSHRESTHA - Original Message From: Ryan Novosielski <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Monday, 4 February, 2008 8:14:50 PM Subject: Re: [Bacula-users] Unable to find Qt4 installation needed by bat .. Original Message ... On Mon, 04 Feb 2008 18:43:38 +0530 (IST) <[EMAIL PROTECTED]> wrote: >Hi >I am a new user of Bacula. Trying to set it up and evaluate all the features. My initial setup is working fine with Linux(RHEL) based servers and Windows servers. I wanted to enable bat(Bacula admin tool). I have prepared a new setup and completed all pre-requisite for Bacula and bat.(Mysql Database, Qt4 , qwt) and than trying to run CFLAGS ./configure.. with specifying all the right location of qwt. but configure's initial check always get stopped at "error:Unable to find Qt4 installation needed by bat". Tried variation of installation and even someone suggested *.pc file copy from /usr/local to /usr/lib/pkgconfig. but still its not working. >I need some clue and help from Bacula experts. how can i take it forward? Please comment. > > >DEVAL KULSHRESTHA You'll want to show the relevant portions of config.log, which will tell you how it arrived at that conclusion (generally which file it wanted that it could not find). 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users config.log Description: Binary data - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] make fails on qt-console
Fedora Core 6 Vanilla-kernel 2.6.18.2 bacula-2.2.5 rpm -qa qt4* qt4-4.3.2-1.fc6 qt4-devel-4.3.2-1.fc6 qt4-x11-4.3.2-1.fc6 CFLAGS="-g -O2" ./configure --sbindir=/usr/local/bacula/bin --sysconfdir=/usr/local/bacula/bin --with-pid-dir=/usr/local/bacula/bin/working --with-subsys-dir=/usr/local/bacula/bin/working --enable-smartalloc --with-mysql --with-working-dir=/usr/local/bacula/bin/working --with-qwt=/usr/local/qwt-5.0.2 --enable-bat make output ==>Entering directory /tmp/bacula-2.2.5/src/qt-console make[1]: Entering directory `/tmp/bacula-2.2.5/src/qt-console' /usr/lib/qt4/bin/uic main.ui -o ui/ui_main.h /usr/lib/qt4/bin/uic prefs.ui -o ui/ui_prefs.h /usr/lib/qt4/bin/uic label/label.ui -o ui/ui_label.h /usr/lib/qt4/bin/uic relabel/relabel.ui -o ui/ui_relabel.h /usr/lib/qt4/bin/uic mount/mount.ui -o ui/ui_mount.h /usr/lib/qt4/bin/uic console/console.ui -o ui/ui_console.h /usr/lib/qt4/bin/uic restore/restore.ui -o ui/ui_restore.h /usr/lib/qt4/bin/uic restore/prerestore.ui -o ui/ui_prerestore.h /usr/lib/qt4/bin/uic restore/brestore.ui -o ui/ui_brestore.h /usr/lib/qt4/bin/uic restore/restoretree.ui -o ui/ui_restoretree.h /usr/lib/qt4/bin/uic run/run.ui -o ui/ui_run.h /usr/lib/qt4/bin/uic run/runcmd.ui -o ui/ui_runcmd.h /usr/lib/qt4/bin/uic run/estimate.ui -o ui/ui_estimate.h /usr/lib/qt4/bin/uic run/prune.ui -o ui/ui_prune.h /usr/lib/qt4/bin/uic select/select.ui -o ui/ui_select.h /usr/lib/qt4/bin/uic medialist/medialist.ui -o ui/ui_medialist.h /usr/lib/qt4/bin/uic mediaedit/mediaedit.ui -o ui/ui_mediaedit.h /usr/lib/qt4/bin/uic joblist/joblist.ui -o ui/ui_joblist.h /usr/lib/qt4/bin/uic clients/clients.ui -o ui/ui_clients.h /usr/lib/qt4/bin/uic storage/storage.ui -o ui/ui_storage.h /usr/lib/qt4/bin/uic fileset/fileset.ui -o ui/ui_fileset.h /usr/lib/qt4/bin/uic joblog/joblog.ui -o ui/ui_joblog.h /usr/lib/qt4/bin/uic jobs/jobs.ui -o ui/ui_jobs.h /usr/lib/qt4/bin/uic help/help.ui -o ui/ui_help.h /usr/lib/qt4/bin/uic jobgraphs/jobplotcontrols.ui -o ui/ui_jobplotcontrols.h g++ -c -pipe -g -D_REENTRANT -Wall -W -DQT_GUI_LIB -DQT_CORE_LIB -I/usr/lib/qt4/mkspecs/linux-g++ -I. -I/usr/include/QtCore -I/usr/include/QtCore -I/usr/include/QtGui -I/usr/include/QtGui -I/usr/include -I.. -I. -Iconsole -Irestore -Iselect -I/usr/local/qwt-5.0.2/include -Imoc -Iui -o obj/main.o main.cpp g++ -o bat obj/main.o obj/bat_conf.o obj/mainwin.o obj/qstd.o obj/pages.o obj/dircomm.o obj/dircomm_auth.o obj/authenticate.o obj/console.o obj/prerestore.o obj/restore.o obj/brestore.o obj/label.o obj/relabel.o obj/mount.o obj/run.o obj/runcmd.o obj/estimate.o obj/prune.o obj/select.o obj/medialist.o obj/mediaedit.o obj/joblist.o obj/clients.o obj/storage.o obj/fileset.o obj/joblog.o obj/jobs.o obj/restoretree.o obj/jobplot.o obj/help.o obj/moc_mainwin.o obj/moc_dircomm.o obj/moc_console.o obj/moc_restore.o obj/moc_label.o obj/moc_relabel.o obj/moc_mount.o obj/moc_run.o obj/moc_select.o obj/moc_medialist.o obj/moc_mediaedit.o obj/moc_joblist.o obj/moc_clients.o obj/moc_storage.o obj/moc_fileset.o obj/moc_joblog.o obj/moc_jobs.o obj/moc_restoretree.o obj/moc_jobplot.o obj/moc_help.o obj/qrc_main.o -L../lib -lbac -L/usr/local/qwt-5.0.2/lib -lqwt -lQtGui -lQtCore -lpthread obj/jobplot.o: In function `JobPlot::addCurve()': jobgraphs/jobplot.cpp:416: undefined reference to `QwtPlotMarker::setLabelAlignment(QFlags)' obj/jobplot.o:(.rodata._ZTV17DateTimeScaleDraw[vtable for DateTimeScaleDraw]+0x10): undefined reference to `QwtAbstractScaleDraw::draw(QPainter*, QPalette const&) const' collect2: ld returned 1 exit status make[1]: *** [bat] Error 1 make[1]: Leaving directory `/tmp/bacula-2.2.5/src/qt-console' == Error in /tmp/bacula-2.2.5/src/qt-console == -- Mvh Roger Sinel [EMAIL PROTECTED] www.nordickiwi.com + gpg key -- http://www.nordickiwi.com/rsinel.asc + fingerprint -- F0EF 2C17 99CA DC06 132A 967F B642 D0BA 6503 87C7 signature.asc Description: This is a digitally signed message part - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Using Bacula-BAT GUI
Hi, After finally installing bacula-2.2.5 on Fedora Core 6 with BAT enabled and QT4 and QWT, how do I actually use BAT? Where is the binary to start that great GUI I've seen screenshots of? -- Mvh Roger Sinel www.nordickiwi.com + gpg key -- http://www.nordickiwi.com/rsinel.asc + fingerprint -- F0EF 2C17 99CA DC06 132A 967F B642 D0BA 6503 87C7 signature.asc Description: This is a digitally signed message part - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] "Fatal error:..is busy writing on .."
I'm backing up 20 machines over the internet using file storage with "Maximum Volume Jobs = 1" and have a recurring problem. Whenever a job fails due to a "network error", the next job finishes without any problem, but all following jobs (within a hour or so) fails with 'Fatal error:..is busy writing on "XXX"' where XXX is the volume name which the finished job was writing on. So the sequence of events is: - At 22:00 each night jobs to start backing up all machines starts - Job 1-(N-1) finishes without any problem - Job N on client A starts and recycles volume X and starts backing up, but fails with "Fatal error: backup.c:498 Network send error to SD. ERR=Broken pipe" and "SD Bytes Written" is 0. - Job N+1 on client B starts writing on volume X and ends without any problems - Job N+2 on client C starts and recycles volume Z but fails to mount it with error 'Fatal error: acquire.c:263 Wanted Volume "Z", but device "File-1" (/var/bacula/backups/1) is busy writing on "X" .' - All subsequent jobs fail with same error as N+2 - Next evening all scheduled jobs (or even a few hours running a manual job) manages to mount requested volume without any problem I've seen this problem with all 1.38.x relases and I'm currently running 1.38.11 smime.p7s Description: S/MIME Cryptographic Signature - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Rocket science: was Re: Bacula version 1.38.10 released
> > Are you able to do a Bacula tree restore with 6 million files? > I needed to split my backups into several jobs, because the bacula-dir consumed more than 2 gig of RAM, my largest backup now, is 4,487,947 files, and bacula-dir consumes 1156M of RAM alone, and you need some RAM for backula-sd, mysql and OS as well. ( I now have 24 jobs, several almost as large as the biggest) -- Roger Kvam System administrator ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: bacula restores
I had the exact same problem, running out of free memory while having 2GB installed, I had to split the backups into 10 separate jobs, where the biggest consist of 3,8M files and 250GB data, and even this takes a lot of time on my dual xenon system with fibre channels and scsi disks, while building the directory tree. (and please notice the problem I posted earlier to day, where File tables was full) Roger Kvam Ryan Sizemore wrote: All, We have run our first full backup of our data server, and we are in the process of restoring the entire system to a temporary drive. Everything is going great, although when bconsole goes to grab all of the files (before we are able to mark the ones that we want), it take 10-15 minutes before we can mark any files. A full backup consists of 803.4 GB and about 10 million file. mysql> select count(*) from File; +--+ | count(*) | +--+ | 9978625 | +--+ 1 row in set (0.00 sec) Currently, with just this full backup (no incrementals yet), the size of the database is 1.7 GB. While the query is executing, bacula-dir consumes over 2GB of memory, then the building of the file tree takes another 600MB. We are planning to keep a record of full backups for a year, and with the current growth rate of the database, it will likely get quite large indeed. The foreseen problem here is that as the size of our full backups grow, so will the amount of memory that the queries need to run. This will pose the biggest problem for situations where a use wants to restore just a few files. Also, the current query takes up almost all of the 1 GB of memory plus 2 GB of swap. The system is a dual PIII-800 with 1G of RAM. Are there people out there restoring a similar size/number of files? If so, I would like to hear what hardware you are running. On the other hand, once the file tree is built, marking files is relatively quick. The restore begins almost as soon as the job is started, whereas our current backup manager (Networker) takes over 12 hours to select all of the files it is going to need, then dies because it has lost its connection to the client. So my question to the community is: Is there any way to speed up the building of the initial file tree? Or is there way of limiting the query size? Best Regards, Ryan Sizemore --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: The table 'File' is full
What will happend to the MyISAM file, will it be converted, or just left behind an I need to start my backups from scratch? Roger Kvam Daniel Holtkamp wrote: Hi ! Roger Kvam wrote: My MySQL database is 6.8G, while the File.MYD is 4.0G You ran into a mysql-limit there. The File Table apparently uses MyISAM as storage engine and the max-limit there is 4 GB. Fire up mysql-administrator and change the storage engine to InnoDB then you`re fine. (On my system i changed all tables to InnoDB - just in case). Best regards, --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: The table 'File' is full
mysql> select count(*) from File; +--+ | count(*) | +--+ | 47405618 | +--+ 1 row in set (0.00 sec) Frank Sweetser wrote: On Wed, Feb 01, 2006 at 03:37:11PM +0100, Roger Kvam wrote: 27-Jan 00:45 alexandria-dir: LogicBackupAvr32.2006-01-27_00.05.10 Fatal error: sql_create.c:732 sql_create.c:732 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (55527,829,2825202,2033976,'Bc sHVV IGk B Yc Y CwOuQ WvE BAA C4 BD0Kbs BD0Kbs BD2MTW A A C','0') failed: The table 'File' is full If you start up the mysql client, what does the query select count(*) from File; return? --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] The table 'File' is full
27-Jan 00:45 alexandria-dir: LogicBackupAvr32.2006-01-27_00.05.10 Fatal error: sql_create.c:732 sql_create.c:732 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (55527,829,2825202,2033976,'Bc sHVV IGk B Yc Y CwOuQ WvE BAA C4 BD0Kbs BD0Kbs BD2MTW A A C','0') failed: The table 'File' is full I`m running bacula 1.38.2, with standard install besides som alteration in the chio.changer scripts, on a FreeBSD 6.0-RELEASE My MySQL database is 6.8G, while the File.MYD is 4.0G My backup with most files are like this: FD Files Written: 3,876,210 SD Files Written: 3,876,210 FD Bytes Written: 256,133,597,826 SD Bytes Written: 256,774,755,561 And i got ca 10 similar jobs, I have been running since 9/des-2005 How could this happend? Roger Kvam --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: Segmentation violation
Heigl Florian - Munich-MR - external wrote: Hi Roger, Do some sizing of the mysql database configuration and let it know it can't allocate more than 1GB physical memory and set maxdsiz to that. MySQL is not using the memory, it`s the bacula-dir who use all the memory. Whats was really anoying is that FreeBSD did not write anything in the logs who would point me in the right direction Florian --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: Segmentation violation
Now I`m really embarrassed, actually ,FreeBSD is protecting itself against runaway processes by allowing maximum memory size for one process to 512MB, I had to increase the maximum to 2 gig by adding kern.maxdsiz=2147483648 to /boot/loader.conf. witch is my physical amount of memory, but maxed out that to, so I had tried another job who only used 870MB RAM. Maybe there should be a warning in the documentation about this problem? I think my job would have required at least 2.3GB memory :D I will divide it now ;) But the error messages from bacula was far out :p "Query failed: SELECT MediaType >>> FROM JobMedia,Media WHERE JobMedia.JobId=2 AND >>> JobMedia.MediaId=Media.MediaId: ERR=Lost connection to MySQL server >>> during query" Roger Roger Kvam wrote: I have tried to run several restorejobs, and every job who is beneth 516 MB i memory consumption is a sucess, every job above 516 crash whith same error message. MySQL is installed same way as when running bacula 1.36. Bacula did crash earlyer when consuming more than fysical mermory, but the box was upgraded to 2GB prior to 1.36, and the versions prior to 1.36 and 1.36 worked fine. Kern Sibbald wrote: Hello, I repeat what I said the last time: this looks like a MySQL problem. Given the new information you have presented, and the fact that you are having problems when working with almost 9 million files backed up (a lot), I would suspect that the problem is with your MySQL configuration. If you used the standard MySQL installation, it is probably not configured for such large databases. See below for more ... On Monday 12 December 2005 10:52, Roger Kvam wrote: I Tried to upgrade MySQL to 5. and recomile bacula (yes I did a make distclean), but same error, have now installed MySQL 4.1.15 again, and recompiled bacula again, deleted the database and deleted the tapes so I could start fresh. When trying to restore from a large job, bacula crashes, From the message you show below, it looks to me like MySQL crashed or at least disconnected. when trying to restore from a small job everything works fine. Does bacula has shortcomings when comes to enterprise systems? Bacula is not what I would call an enterprise system, so one could say it has that kind of shortcoming. In your case, you are dealing with a quite large backup set, and it looks like you have not adapted MySQL to handle it appropriatedly. Perhaps some of the other users on the list can help you. If I am not mistaken, the Bacula document also mentions some steps you might take for large databases, but your best bet is to look at the MySQL documentation. Now I have run several backups of several servers and everything works fine, until I wanted to do a restore from the biggest job, +---+---+---+-+-+-- --+---+ | JobId | Level | JobFiles | JobBytes| StartTime | VolumeName | StartFile | +---+---+---+-+-+-- --+---+ | 2 | F | 8,759,302 | 821,505,476,167 | 2005-12-09 16:27:02 | 09L2 | 0 | +---+---+---+-+-+-- --+---+ You have selected the following JobId: 2 Building directory tree for JobId 2 ... Query failed: SELECT MediaType FROM JobMedia,Media WHERE JobMedia.JobId=2 AND JobMedia.MediaId=Media.MediaId: ERR=Lost connection to MySQL server during query There were no files inserted into the tree, so file selection is not possible.Most likely your retention policy pruned the files Do you want to restore all the files? (yes|no): ¤¤ When trying to restore from a smaller job, everything works fine: +---+---+--++-+ +---+ | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName | StartFile | +---+---+--++-+ +---+ | 3 | F | 833,832 | 52,358,007,603 | 2005-12-09 16:29:06 | 09L2 |29 | | 4 | I |1,434 |322,179,540 | 2005-12-10 00:05:01 | 01L2 | 0 | +---+---+--++-+ +---+ You have selected the following JobIds: 3,4 Building directory tree for JobId 3 ... + Building directory tree for JobId 4 ... 2 Jobs, 828,824 files inserted into the tree. Have I met any limitations in bacula? The system status was like this the moment before the crash: last pid: 34607; load averages: 1.24, 0.58, 0.25 up 3+19:19:56 08:57:34 59 processes: 6 running, 53 sleeping Mem: 572M Active, 1156M Inact, 212M Wired, 64M Cache, 112M Buf, 3008K Free Swap: 4096M Total, 500K Used, 4
[Bacula-users] Re: Segmentation violation
I have tried to run several restorejobs, and every job who is beneth 516 MB i memory consumption is a sucess, every job above 516 crash whith same error message. MySQL is installed same way as when running bacula 1.36. Bacula did crash earlyer when consuming more than fysical mermory, but the box was upgraded to 2GB prior to 1.36, and the versions prior to 1.36 and 1.36 worked fine. Kern Sibbald wrote: Hello, I repeat what I said the last time: this looks like a MySQL problem. Given the new information you have presented, and the fact that you are having problems when working with almost 9 million files backed up (a lot), I would suspect that the problem is with your MySQL configuration. If you used the standard MySQL installation, it is probably not configured for such large databases. See below for more ... On Monday 12 December 2005 10:52, Roger Kvam wrote: I Tried to upgrade MySQL to 5. and recomile bacula (yes I did a make distclean), but same error, have now installed MySQL 4.1.15 again, and recompiled bacula again, deleted the database and deleted the tapes so I could start fresh. When trying to restore from a large job, bacula crashes, From the message you show below, it looks to me like MySQL crashed or at least disconnected. when trying to restore from a small job everything works fine. Does bacula has shortcomings when comes to enterprise systems? Bacula is not what I would call an enterprise system, so one could say it has that kind of shortcoming. In your case, you are dealing with a quite large backup set, and it looks like you have not adapted MySQL to handle it appropriatedly. Perhaps some of the other users on the list can help you. If I am not mistaken, the Bacula document also mentions some steps you might take for large databases, but your best bet is to look at the MySQL documentation. Now I have run several backups of several servers and everything works fine, until I wanted to do a restore from the biggest job, +---+---+---+-+-+-- --+---+ | JobId | Level | JobFiles | JobBytes| StartTime | VolumeName | StartFile | +---+---+---+-+-+-- --+---+ | 2 | F | 8,759,302 | 821,505,476,167 | 2005-12-09 16:27:02 | 09L2 | 0 | +---+---+---+-+-+-- --+---+ You have selected the following JobId: 2 Building directory tree for JobId 2 ... Query failed: SELECT MediaType FROM JobMedia,Media WHERE JobMedia.JobId=2 AND JobMedia.MediaId=Media.MediaId: ERR=Lost connection to MySQL server during query There were no files inserted into the tree, so file selection is not possible.Most likely your retention policy pruned the files Do you want to restore all the files? (yes|no): ¤¤ When trying to restore from a smaller job, everything works fine: +---+---+--++-+ +---+ | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName | StartFile | +---+---+--++-+ +---+ | 3 | F | 833,832 | 52,358,007,603 | 2005-12-09 16:29:06 | 09L2 |29 | | 4 | I |1,434 |322,179,540 | 2005-12-10 00:05:01 | 01L2 | 0 | +---+---+--++-+ +---+ You have selected the following JobIds: 3,4 Building directory tree for JobId 3 ... + Building directory tree for JobId 4 ... 2 Jobs, 828,824 files inserted into the tree. Have I met any limitations in bacula? The system status was like this the moment before the crash: last pid: 34607; load averages: 1.24, 0.58, 0.25 up 3+19:19:56 08:57:34 59 processes: 6 running, 53 sleeping Mem: 572M Active, 1156M Inact, 212M Wired, 64M Cache, 112M Buf, 3008K Free Swap: 4096M Total, 500K Used, 4095M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 20584 mysql 9 200 57640K 33344K kserel 0 256:57 86.77% mysqld 31511 root 6 200 5608K 2304K kserel 0 144:10 0.00% bacula-sd 31532 root 6 200 518M 513M RUN0 53:32 0.00% bacula-dir Kern Sibbald wrote: This looks to me like a problem with MySQL. Did you by any chance load pre-built binaries rather than build on your system. My best guess at the moment is that Bacula is built with version X of MySQL and you are running with version Y on your machine. That means that some of the packet fields have moved or are aligned differently. Rebuiding Bacula from source directly on your machine should resolve this, if I am right ... To answer your question. Yes, of course, you can do as many backup
[Bacula-users] Re: Segmentation violation
Well, the strange ting is that the crash happens every time bacula-dir reach 516MB memory usage, and mysql i steady on same consumption as when started. And we have used bacula before (1.6) without these problems. Anyone else tried bacula on these amount of files? Kern Sibbald wrote: Hello, I repeat what I said the last time: this looks like a MySQL problem. Given the new information you have presented, and the fact that you are having problems when working with almost 9 million files backed up (a lot), I would suspect that the problem is with your MySQL configuration. If you used the standard MySQL installation, it is probably not configured for such large databases. See below for more ... On Monday 12 December 2005 10:52, Roger Kvam wrote: I Tried to upgrade MySQL to 5. and recomile bacula (yes I did a make distclean), but same error, have now installed MySQL 4.1.15 again, and recompiled bacula again, deleted the database and deleted the tapes so I could start fresh. When trying to restore from a large job, bacula crashes, From the message you show below, it looks to me like MySQL crashed or at least disconnected. when trying to restore from a small job everything works fine. Does bacula has shortcomings when comes to enterprise systems? Bacula is not what I would call an enterprise system, so one could say it has that kind of shortcoming. In your case, you are dealing with a quite large backup set, and it looks like you have not adapted MySQL to handle it appropriatedly. Perhaps some of the other users on the list can help you. If I am not mistaken, the Bacula document also mentions some steps you might take for large databases, but your best bet is to look at the MySQL documentation. Now I have run several backups of several servers and everything works fine, until I wanted to do a restore from the biggest job, +---+---+---+-+-+-- --+---+ | JobId | Level | JobFiles | JobBytes| StartTime | VolumeName | StartFile | +---+---+---+-+-+-- --+---+ | 2 | F | 8,759,302 | 821,505,476,167 | 2005-12-09 16:27:02 | 09L2 | 0 | +---+---+---+-+-+-- --+---+ You have selected the following JobId: 2 Building directory tree for JobId 2 ... Query failed: SELECT MediaType FROM JobMedia,Media WHERE JobMedia.JobId=2 AND JobMedia.MediaId=Media.MediaId: ERR=Lost connection to MySQL server during query There were no files inserted into the tree, so file selection is not possible.Most likely your retention policy pruned the files Do you want to restore all the files? (yes|no): ¤¤ When trying to restore from a smaller job, everything works fine: +---+---+--++-+ +---+ | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName | StartFile | +---+---+--++-+ +---+ | 3 | F | 833,832 | 52,358,007,603 | 2005-12-09 16:29:06 | 09L2 |29 | | 4 | I |1,434 |322,179,540 | 2005-12-10 00:05:01 | 01L2 | 0 | +---+---+--++-+ +---+ You have selected the following JobIds: 3,4 Building directory tree for JobId 3 ... + Building directory tree for JobId 4 ... 2 Jobs, 828,824 files inserted into the tree. Have I met any limitations in bacula? The system status was like this the moment before the crash: last pid: 34607; load averages: 1.24, 0.58, 0.25 up 3+19:19:56 08:57:34 59 processes: 6 running, 53 sleeping Mem: 572M Active, 1156M Inact, 212M Wired, 64M Cache, 112M Buf, 3008K Free Swap: 4096M Total, 500K Used, 4095M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 20584 mysql 9 200 57640K 33344K kserel 0 256:57 86.77% mysqld 31511 root 6 200 5608K 2304K kserel 0 144:10 0.00% bacula-sd 31532 root 6 200 518M 513M RUN0 53:32 0.00% bacula-dir Kern Sibbald wrote: This looks to me like a problem with MySQL. Did you by any chance load pre-built binaries rather than build on your system. My best guess at the moment is that Bacula is built with version X of MySQL and you are running with version Y on your machine. That means that some of the packet fields have moved or are aligned differently. Rebuiding Bacula from source directly on your machine should resolve this, if I am right ... To answer your question. Yes, of course, you can do as many backup and restores at the same time as you want without Bacula crashing (providing it is working properly). On Wednesday 07 December
[Bacula-users] Re: Segmentation violation
I Tried to upgrade MySQL to 5. and recomile bacula (yes I did a make distclean), but same error, have now installed MySQL 4.1.15 again, and recompiled bacula again, deleted the database and deleted the tapes so I could start fresh. When trying to restore from a large job, bacula crashes, when trying to restore from a small job everything works fine. Does bacula has shortcomings when comes to enterprise systems? Now I have run several backups of several servers and everything works fine, until I wanted to do a restore from the biggest job, +---+---+---+-+-++---+ | JobId | Level | JobFiles | JobBytes| StartTime | VolumeName | StartFile | +---+---+---+-+-++---+ | 2 | F | 8,759,302 | 821,505,476,167 | 2005-12-09 16:27:02 | 09L2 | 0 | +---+---+---+-+-++---+ You have selected the following JobId: 2 Building directory tree for JobId 2 ... Query failed: SELECT MediaType FROM JobMedia,Media WHERE JobMedia.JobId=2 AND JobMedia.MediaId=Media.MediaId: ERR=Lost connection to MySQL server during query There were no files inserted into the tree, so file selection is not possible.Most likely your retention policy pruned the files Do you want to restore all the files? (yes|no): ¤¤ When trying to restore from a smaller job, everything works fine: +---+---+--++-++---+ | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName | StartFile | +---+---+--++-++---+ | 3 | F | 833,832 | 52,358,007,603 | 2005-12-09 16:29:06 | 09L2 |29 | | 4 | I |1,434 |322,179,540 | 2005-12-10 00:05:01 | 01L2 | 0 | +---+---+--++-++---+ You have selected the following JobIds: 3,4 Building directory tree for JobId 3 ... + Building directory tree for JobId 4 ... 2 Jobs, 828,824 files inserted into the tree. Have I met any limitations in bacula? The system status was like this the moment before the crash: last pid: 34607; load averages: 1.24, 0.58, 0.25 up 3+19:19:56 08:57:34 59 processes: 6 running, 53 sleeping Mem: 572M Active, 1156M Inact, 212M Wired, 64M Cache, 112M Buf, 3008K Free Swap: 4096M Total, 500K Used, 4095M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 20584 mysql 9 200 57640K 33344K kserel 0 256:57 86.77% mysqld 31511 root 6 200 5608K 2304K kserel 0 144:10 0.00% bacula-sd 31532 root 6 200 518M 513M RUN0 53:32 0.00% bacula-dir Kern Sibbald wrote: This looks to me like a problem with MySQL. Did you by any chance load pre-built binaries rather than build on your system. My best guess at the moment is that Bacula is built with version X of MySQL and you are running with version Y on your machine. That means that some of the packet fields have moved or are aligned differently. Rebuiding Bacula from source directly on your machine should resolve this, if I am right ... To answer your question. Yes, of course, you can do as many backup and restores at the same time as you want without Bacula crashing (providing it is working properly). On Wednesday 07 December 2005 22:57, rkvam wrote: Actually, even when there is no backup running, the restore job fails, anyone have a clue? Did I fuck up the database while trying to restore while backuping? Same crash everytime I try to restore the same job as I tried to run while segfault. Automatically selected FileSet: Store +---+---+---+-+-+-- --+---+ | JobId | Level | JobFiles | JobBytes| StartTime | VolumeName | StartFile | +---+---+---+-+-+-- --+---+ |13 | F | 8,743,518 | 819,499,095,510 | 2005-12-05 21:30:55 | 10L2 | 117 | |18 | I | 143,886 | 27,865,423,512 | 2005-12-07 00:15:07 | 01L2 | 9 | |30 | I |36,820 | 21,111,393,490 | 2005-12-07 16:24:15 | 01L2 |42 | +---+---+---+-+-+-- --+---+ You have selected the following JobIds: 13,18,30 Building directory tree for JobId 13 ... Query failed: SELECT MediaType FROM JobMedia,Media WHERE JobMedia.JobId=13 AND JobMedia.MediaId=Media.MediaId: ERR=Lost connection to MySQL server during query Building directory tree for JobId 18 ... Building directory tree for JobId 30 ... 3 J
[Bacula-users] Comm error with SD
usr/local/sbin/chio-changer %c %o %S %a" Changer Command = "/usr/local/sbin/chio-changer %o %S %a" Autochanger = yes LabelMedia = no AutomaticMount = yes AlwaysOpen = yes ### for testing ## Backward Space Record = no Backward Space File = no # Hardware End of Medium = no Fast Forward Space File = yes BSF at EOM = yes Drive Index = 0 TWO EOF = yes } TapeLib0-Drive1 is identical to TapeLib0-Drive0, but has never been used. Everyting compiled from source on FreeBSD 6.0 Release I386 Bacula source: 1.38 ./configure \ --sbindir=/usr/local/bin \ --sysconfdir=/usr/local/etc/bacula \ --with-pid-dir=/var/run/bacula \ --with-subsys-dir=/usr/local/bacula/bin \ --with-mysql=yes \ --with-working-dir=/usr/local/bacula/bin/working \ [EMAIL PROTECTED] \ --with-smtp-host=smtp...xxx \ --with-dir_user=bacula \ --with-fd_user=bacula \ --with-sd_user=bacula \ --enable-readline Hardware: alexandria# camcontrol devlist at scbus0 target 0 lun 0 (da0,pass0) at scbus2 target 129 lun 0 (pass1) at scbus2 target 129 lun 1 (pass2,ch0) at scbus2 target 129 lun 2 (pass3,sa0) at scbus2 target 129 lun 3 (pass4,sa1) at scbus2 target 130 lun 0 (pass5,da1) alexandria# begin:vcard fn:Roger Kvam n:Kvam;Roger org:Atmel Norway;IT Operations adr:;;Vestre Rosten 79;Trondheim;Tiller;7075;Norway email;internet:[EMAIL PROTECTED] title:System Engineer IT tel;work:+47 72897561 tel;fax:+47 72884399 tel;cell:+47 92295777 x-mozilla-html:FALSE url:http://www.atmel.com version:2.1 end:vcard
[Bacula-users] Warning: sql_create.c:830 More than one Filename! 2 for file:
Hi,
I started seeing these errors in Bacula-1.36.3. I upgraded to
Bacula-1.37.29 and I'm still getting these sql_create.c errors for
blank filename. These sql_create.c error messages also occurs on
another Linux client fd, but that client backup succeeded because it
did not disconnect from MySQL. What is the problem?
Also I've upgraded to MySQL-4.1.12-max from MySQL-3.23.58-fc2 at the
beginning of the week. This looks like a Bacula problem though.
Pointers? Thanks.
-Roger
# List of files to be backed up
FileSet {
Name = "Full Set"
Include {
Options {
signature = MD5
compression = GZIP6
verify = pins5
#aclsupport = yes
sparse = yes
wildfile = \.journal
wildfile = \.fsck
wildfile = \.cfs_unlink
exclude = yes
}
#
# Put your list of files here, preceded by 'File =', one per line
#or include an external list with:
#
#File =
15-Jul 01:10 cluster-dir: Cluster.2005-07-15_01.05.00 Warning:
sql_create.c:830 More
than one Filename! 2 for file:
15-Jul 01:10 cluster-dir: Cluster.2005-07-15_01.05.00 Warning:
sql_create.c:830 More
than one Filename! 2 for file:
15-Jul 01:10 cluster-dir: Cluster.2005-07-15_01.05.00 Warning:
sql_create.c:830 More
than one Filename! 2 for file:
15-Jul 01:11 cluster-dir: Cluster.2005-07-15_01.05.00 Fatal error:
sql_create.c:825
sql_create.c:825 query SELECT FilenameId FROM Filename WHERE Name='' failed:
Lost connection to MySQL server during query
15-Jul 01:11 cluster-dir: Cluster.2005-07-15_01.05.00 Warning:
sql_create.c:830 More
than one Filename! 3 for file:
15-Jul 01:11 cluster-dir: Cluster.2005-07-15_01.05.00 Warning:
sql_create.c:830 More
than one Filename! 3 for file:
15-Jul 01:11 cluster-dir: Cluster.2005-07-15_01.05.00 Error: Bacula 1.37.29
(13Jul05): 15-Jul-2005 01:11:14
JobId: 479
Job:Cluster.2005-07-15_01.05.00
Backup Level: Incremental, since=2005-07-14 01:05:02
Client: "cluster-fd" i686-pc-linux-gnu,redhat,(Tettnang)
FileSet:"Full Set" 2005-04-25 23:01:48
Pool: "Inc-Pool"
Storage:"CVIP"
Scheduled time: 15-Jul-2005 01:05:00
Start time: 15-Jul-2005 01:05:01
End time: 15-Jul-2005 01:11:14
Priority: 9
FD Files Written: 16,247
SD Files Written: 16,247
FD Bytes Written: 190,405,704
SD Bytes Written: 172,578,570
Rate: 510.5 KB/s
Software Compression: 77.4 %
Volume name(s): Cluster.2005-05-07_01.05.00-Inc
Volume Session Id: 1
Volume Session Time:1121339996
Last Volume Bytes: 306,968,538
Non-fatal FD errors:0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination:*** Backup Error ***
---
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
