[Bacula-users] cannot find stopmysql script on debian squeeze
or can i use the debian /etc/init.d/mysql restart command? +-- |This was sent by fors...@sf.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] cannot find stopmysql script on debian squeeze
hi, i cannot find the stopmysql and startmysql scripts on debian squeeze bacula, everything ist working fine with a 16 slot library, but i just cannot find these scripts and don´t want to reboot the server to restart mysql. i searched in all locations i read about on the net, /etc/bacula/scripts does not contain them, /usr/libinclude does not exist, /usr/lib64/bacula does not exist... how can i find them? i need to urgently restore a VM, but since today when i choose a restore and choose option 5, after that the bconsole just hangs. +-- |This was sent by fors...@sf.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] cannot find stopmysql script on debian squeeze
On Tue, 22 Jan 2013 02:53:27 -0800 goorooj bacula-fo...@backupcentral.com wrote: or can i use the debian /etc/init.d/mysql restart command? Precisely. Or, rather, use stop and start targets of the /etc/init.d/mysql control script. -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] cannot find stopmysql script on debian squeeze
On 2013-01-22 05:53, goorooj wrote: or can i use the debian /etc/init.d/mysql restart command? You can, and you should. When you can, use your system provided tools. -- Dan Langille - http://langille.org/ -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Is my tape jukebox borked?
Hi folks, I started out with bacula 3 or 4 months ago but as it turned out the card I was using did not properly recognize the tape changer. The whole thing got sidetracked for a while but now I'm back with a new card which seems to see everything fine. It is a Sun SL24 jukebox. I'm running Ubuntu 12.10 with bacula out of the apt-get packages. I stopped using the jukebox a few months ago with the software Sun had sold us for it, because I suspected some issues with either the software or the hardware. Now I fear it is hardware. Was trying some basic mtx-changer tests and btape and getting some results that looked odd, so I looked into the mtx-changer script and found this command - with results as shown : root@nashead01:/etc/bacula# mtx -f /dev/sg0 status mtx: Request Sense: Long Report=yes mtx: Request Sense: Valid Residual=no mtx: Request Sense: Error Code=70 (Current) mtx: Request Sense: Sense Key=Illegal Request mtx: Request Sense: FileMark=no mtx: Request Sense: EOM=no mtx: Request Sense: ILI=no mtx: Request Sense: Additional Sense Code = 24 mtx: Request Sense: Additional Sense Qualifier = 00 mtx: Request Sense: BPV=no mtx: Request Sense: Error in CDB=no mtx: Request Sense: SKSV=no Mode sense (0x1A) for Page 0x1D failed mtx: Request Sense: Long Report=yes mtx: Request Sense: Valid Residual=no mtx: Request Sense: Error Code=70 (Current) mtx: Request Sense: Sense Key=Illegal Request mtx: Request Sense: FileMark=no mtx: Request Sense: EOM=no mtx: Request Sense: ILI=no mtx: Request Sense: Additional Sense Code = 20 mtx: Request Sense: Additional Sense Qualifier = 00 mtx: Request Sense: BPV=no mtx: Request Sense: Error in CDB=no mtx: Request Sense: SKSV=no READ ELEMENT STATUS Command Failed I have a feeling there is tape jammed in there somewhere but am not sure. What's my next step to debug this? thanks, -Alan -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How to troubleshoot a slow client, when there is no obvious answer
If you have checked disk I/O, CPU, memory, network, on both the client and the server, all seem great, both from a statistics look, showing all running normally, with low use. Verified with read/write test on local disks, remote through he network, using regular file copies (via SMB) and iperf on both client and server. However my backups which ran last weeks full backup in 3.5hrs at 26mbps, are now running at under 4mbps for this week. I have stopped and restarted things, no change. Every test I can think of shows everything is running great, but the backups are going to take more than a day at this rate. This isn't a new setup, I have been doing this for some time, using the same server / client combination. The only other client on the server ran normally, but it uses gzip (the one running slow doesn't) and never ran faster than about 6mbps, with between 55-65% compression. The local catalog backup ran at 60mpbs, which is almost as fast as dd if=/dev/zero runs against the drive I write my backup volumes to, as the dir and sd are on the same machine. Could I possibly be having a Database issue, I am using PostgreSQL, that could cause this, possibly waiting on records to be written to the catalog? If so how could I find out? Anything else anyone can think of to check? -- Thanks, Dean E. Weimer http://www.dweimer.net/ -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Is my tape jukebox borked?
On 2013-01-22 14:30, Alan McKay wrote: Hi folks, I started out with bacula 3 or 4 months ago but as it turned out the card I was using did not properly recognize the tape changer. The whole thing got sidetracked for a while but now I'm back with a new card which seems to see everything fine. It is a Sun SL24 jukebox. I'm running Ubuntu 12.10 with bacula out of the apt-get packages. I stopped using the jukebox a few months ago with the software Sun had sold us for it, because I suspected some issues with either the software or the hardware. Now I fear it is hardware. Was trying some basic mtx-changer tests and btape and getting some results that looked odd, so I looked into the mtx-changer script and found this command - with results as shown : root@nashead01:/etc/bacula# mtx -f /dev/sg0 status mtx: Request Sense: Long Report=yes mtx: Request Sense: Valid Residual=no mtx: Request Sense: Error Code=70 (Current) mtx: Request Sense: Sense Key=Illegal Request mtx: Request Sense: FileMark=no mtx: Request Sense: EOM=no mtx: Request Sense: ILI=no mtx: Request Sense: Additional Sense Code = 24 mtx: Request Sense: Additional Sense Qualifier = 00 mtx: Request Sense: BPV=no mtx: Request Sense: Error in CDB=no mtx: Request Sense: SKSV=no Mode sense (0x1A) for Page 0x1D failed mtx: Request Sense: Long Report=yes mtx: Request Sense: Valid Residual=no mtx: Request Sense: Error Code=70 (Current) mtx: Request Sense: Sense Key=Illegal Request mtx: Request Sense: FileMark=no mtx: Request Sense: EOM=no mtx: Request Sense: ILI=no mtx: Request Sense: Additional Sense Code = 20 mtx: Request Sense: Additional Sense Qualifier = 00 mtx: Request Sense: BPV=no mtx: Request Sense: Error in CDB=no mtx: Request Sense: SKSV=no READ ELEMENT STATUS Command Failed I have a feeling there is tape jammed in there somewhere but am not sure. What's my next step to debug this? I don't know what those messages mean, but anything anyone has a SCSI problem I ask: Is this a SCSI device? Is the SCSI chain properly terminated? Have you tried another SCSI cable? -- Dan Langille - http://langille.org/ -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Is my tape jukebox borked?
On Tue, Jan 22, 2013 at 2:30 PM, Alan McKay alan.mckay+bac...@gmail.com wrote: Hi folks, I started out with bacula 3 or 4 months ago but as it turned out the card I was using did not properly recognize the tape changer. The whole thing got sidetracked for a while but now I'm back with a new card which seems to see everything fine. It is a Sun SL24 jukebox. I'm running Ubuntu 12.10 with bacula out of the apt-get packages. I stopped using the jukebox a few months ago with the software Sun had sold us for it, because I suspected some issues with either the software or the hardware. Now I fear it is hardware. Was trying some basic mtx-changer tests and btape and getting some results that looked odd, so I looked into the mtx-changer script and found this command - with results as shown : root@nashead01:/etc/bacula# mtx -f /dev/sg0 status Are you sure /dev/sg0 is the changer? Use tapeinfo to tell you. For me its now /dev/sg5 but that will change when drives are added or removed from the system. dev6 ~ # tapeinfo -f /dev/sg5 Product Type: Medium Changer Vendor ID: 'EXABYTE ' Product ID: 'MAGNUM 224 ' Revision: 'C112' Attached Changer API: No SerialNumber: '89000435' SCSI ID: 3 SCSI LUN: 1 Ready: yes I use a udev rule to create a /dev/autochanger1 device that will always point at the right device then use /dev/autochanger1 in bacula. John -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fwd: Is my tape jukebox borked?
-- Forwarded message -- From: Alan McKay alan.mckay+bac...@gmail.com Date: Tue, Jan 22, 2013 at 2:51 PM Subject: Re: [Bacula-users] Is my tape jukebox borked? To: John Drescher dresche...@gmail.com On Tue, Jan 22, 2013 at 2:44 PM, John Drescher dresche...@gmail.com wrote: Are you sure /dev/sg0 is the changer? Evidently not! OK, this gets me one step closer. Honestly I have not found a good simple here is where you start when you know nothing tutorial on bacula. The online docs don't seem to have it. Thanks ! We'll see where I get now. At least btape now seems to start without barfing so now I will go follow that btape example. -- John M. Drescher -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Fwd: Is my tape jukebox borked?
Zitat von John Drescher dresche...@gmail.com: -- Forwarded message -- From: Alan McKay alan.mckay+bac...@gmail.com Date: Tue, Jan 22, 2013 at 2:51 PM Subject: Re: [Bacula-users] Is my tape jukebox borked? To: John Drescher dresche...@gmail.com On Tue, Jan 22, 2013 at 2:44 PM, John Drescher dresche...@gmail.com wrote: Are you sure /dev/sg0 is the changer? Evidently not! OK, this gets me one step closer. Honestly I have not found a good simple here is where you start when you know nothing tutorial on bacula. The online docs don't seem to have it. Thanks ! We'll see where I get now. At least btape now seems to start without barfing so now I will go follow that btape example. At least on Linux you could use lsscsi -g to find the devices. The medimux is the changer. Next is to use /dev/tape/by-id/ instead /dev/sgX in the Bacula config with the matching device ID, so no trouble with udev. Regards Andreas -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How to troubleshoot a slow client, when there is no obvious answer
On Tue, Jan 22, 2013 at 01:37:43PM -0600, dweimer wrote: If you have checked disk I/O, CPU, memory, network, on both the client and the server, all seem great, both from a statistics look, showing all What about many small files, possibly very many in single directories? I have seen these with huge impact on backup performance, especially on busy directories. Regards, Adrian -- LiHAS - Adrian Reyer - Hessenwiesenstraße 10 - D-70565 Stuttgart Fon: +49 (7 11) 78 28 50 90 - Fax: +49 (7 11) 78 28 50 91 Mail: li...@lihas.de - Web: http://lihas.de Linux, Netzwerke, Consulting Support - USt-ID: DE 227 816 626 Stuttgart -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] How to troubleshoot a slow client, when there is no obvious answer
On 2013-01-22 15:34, Adrian Reyer wrote: On Tue, Jan 22, 2013 at 01:37:43PM -0600, dweimer wrote: If you have checked disk I/O, CPU, memory, network, on both the client and the server, all seem great, both from a statistics look, showing all What about many small files, possibly very many in single directories? I have seen these with huge impact on backup performance, especially on busy directories. Regards, Adrian There really hasn't been a huge change in the data, below are from the client status, the full I canceled this morning has the majority of files done, but not the bulk of the data. The biggest chuck of which is the around 30 iTunes movie files, which is where I should see the best performance in the backup, at the point I canceled this it was in the process of processing one of those 4+G movie files. Full 67,353284.8 G OK 15-Jan-13 03:30 Incr 0 0 OK 16-Jan-13 00:05 Incr 185.145 M OK 17-Jan-13 00:05 Incr 239.016 M OK 18-Jan-13 00:05 Incr 811.50 M OK 19-Jan-13 00:05 Incr 3116.09 M OK 21-Jan-13 00:08 Incr 3116.09 M OK 21-Jan-13 00:08 Full 53,174125.0 G Cancel 22-Jan-13 08:46 However you see there are multiple incremental backups ran on the 21st. I did have some failures Monday morning, I had rebooted the server on Sunday and forgot to remount my backup volume. It was in the server during reboot, but is encrypted so it doesn't mount automatically. Those jobs had marked all of my disk volumes with an error state, I hadn't noticed, so when I remounted the volume for its Monday backups most jobs failed, due to lack of usable online volumes but a couple completed, and got kicked off a second time after I marked the volumes back online. Its possible all of this had been caused by snapshots that had been stuck around since the failure of the backup job on the bacula-dir and bacula-sd server, the database volume was included in this, that few day old snap shot may have been slowing down writes to the database. I have cleared that and its running a dbcheck on the database now, I will kick off new backups when that finishes and see how things go. Hopefully this was the cause, however I may have to do some more performance searching because the snapshot shouldn't have caused the performance to degrade that much. -- Thanks, Dean E. Weimer http://www.dweimer.net/ -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Increme job_backup.2013 has a fatal error
Hello, Overnight we have noticed that bacula requested a new tape which was not loaded into auto changer. This morning when we loaded it we noticed that some jobs (belonging in the same pool but also in the queued pool) all had fatal error in the status dir. I think sd crashed. Canceling the job will mean starting over. Can you advise if there is any way we can resume without canceling. How to restart sd and continue incremental backup process. Matter is urgent, please advise asap. Thanks +-- |This was sent by goran@momento.com.au via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Increme job_backup.2013 has a fatal error
On Tue, Jan 22, 2013 at 6:11 PM, UserMOP bacula-fo...@backupcentral.com wrote: Hello, Overnight we have noticed that bacula requested a new tape which was not loaded into auto changer. This morning when we loaded it we noticed that some jobs (belonging in the same pool but also in the queued pool) all had fatal error in the status dir. I think sd crashed. Canceling the job will mean starting over. Can you advise if there is any way we can resume without canceling. How to restart sd and continue incremental backup process. I do not think this is possible with the community edition. John -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Increme job_backup.2013 has a fatal error
The good news is bacula-sd is running. Not stopped. However looking at the logs it is clear that sd crashed. Not sure if that helps you? +-- |This was sent by goran@momento.com.au via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Increme job_backup.2013 has a fatal error
The good news is bacula-sd is running. Not stopped. However looking at the logs it is clear that sd crashed. Not sure if that helps you? Do you have an os mechanism in place to restart crashed daemons? John -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Increme job_backup.2013 has a fatal error
Thanks for your quick responses and suggestions. Not that I know off. Quickly checked our script folders and start up folders, nothing points to bacula. I have cancelled all the pending and queued up jobs other than the one needed to complete, in hope sd would pick it up (where it left off) but do not think I have a choice but to cancel and re start. :( +-- |This was sent by goran@momento.com.au via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Increme job_backup.2013 has a fatal error
On Tue, Jan 22, 2013 at 7:01 PM, UserMOP bacula-fo...@backupcentral.com wrote: Thanks for your quick responses and suggestions. Not that I know off. Quickly checked our script folders and start up folders, nothing points to bacula. I have cancelled all the pending and queued up jobs other than the one needed to complete, in hope sd would pick it up (where it left off) but do not think I have a choice but to cancel and re start. :( I am a little confused on what is going on. What does the stat dir report? Are jobs waiting for storage? Then what does stat stor report? John -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Increme job_backup.2013 has a fatal error
Status dir: JobId Level Name Status == 10079 Increme job_backup.2013-01-22_14.46.39_03 has a fatal error 10087 Fulljob2_backup.2013-01-23_01.00.01_11 has been canceled Canceled job has been marked canceled but have not yet dropped off the status dir list. No jobs waiting for storage. they are all marked canceled other than the one I am trying to run (continue) which is marked has a fatal error. When typing status sto at the Used Volume status: it freezes. does not go any further. Jobs waiting to reserve a drive: looking for the queued up jobIDs (all the ones I have canceled - which belong to another pool) There are six jobID's in the Jobs waiting table. Hope this helps. Thanks +-- |This was sent by goran@momento.com.au via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Increme job_backup.2013 has a fatal error
On Tue, Jan 22, 2013 at 7:29 PM, UserMOP bacula-fo...@backupcentral.com wrote: Status dir: JobId Level Name Status == 10079 Increme job_backup.2013-01-22_14.46.39_03 has a fatal error 10087 Fulljob2_backup.2013-01-23_01.00.01_11 has been canceled Canceled job has been marked canceled but have not yet dropped off the status dir list. No jobs waiting for storage. they are all marked canceled other than the one I am trying to run (continue) which is marked has a fatal error. When typing status sto at the Used Volume status: it freezes. does not go any further. I would restart the SD even though that should will cancel the job with the fatal error. John -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Increme job_backup.2013 has a fatal error
Thanks John. +-- |This was sent by goran@momento.com.au via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Catalog recycling
Hello, I have noticed that as not recycle my catalog but the volumes, after a period, the catalog looking for a content that is no longer in the system as the message For one or more of the JobIds selected, the files were found , so file selection is not possible. , so how can I keep only the catalog data in use? Note: If the differential recycle every 15 days and incremental every 7 days, as would the retention time of the catalog? Thank you. I await help! -- Cleuson de Oliveira Alves Rio de Janeiro - RJ -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Catalog recycling
On Tue, Jan 22, 2013 at 8:31 PM, Cleuson Alves cleuso...@gmail.com wrote: Hello, I have noticed that as not recycle my catalog but the volumes, after a period, the catalog looking for a content that is no longer in the system as the message For one or more of the JobIds selected, the files were found , so file selection is not possible. , so how can I keep only the catalog data in use? Note: If the differential recycle every 15 days and incremental every 7 days, as would the retention time of the catalog? Thank you. I await help! Did you set file or job retention periods? These control what is kept in the catalog. John -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore performance
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I added the indices back and performance dramatically increased. I assume my tables needed a repair and that that was the initial problem (maybe caused by the upgrade I had recently done from 2.2.8 to 5.0.3). While restores essentially hung before I dropped the indices and dropped to maybe 30 seconds to build a ~15GB directory tree, after adding them back, it's now nearly instantaneous. On 01/15/2013 11:03 AM, Novosielski, Ryan wrote: I would say it depends on your read of that article and either way whether or not you believe it. I'm not quite sure what to think. I believe I will re-add the indices I dropped and see what happens. - Original Message - From: Uwe Schuerkamp [mailto:uwe.schuerk...@nionex.net] Sent: Tuesday, January 15, 2013 10:32 AM To: Novosielski, Ryan Cc: John Drescher dresche...@gmail.com; bacula-users Bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] restore performance On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote: http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog Actually, after re-reading that, I'm a little confused. I don't know whether it says to drop all indexes except for primary and then drop the listed indices or drop everything except for primary and except for the listed indices. In any case, this solved the problem for me. I wonder if a repair would have also and maybe that's why? I have the following indexes defined on the File table: MariaDB [bacula] show indexes in File ; +---++--+--+-+---+-+--++--++-+---+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---++--+--+-+---+-+--++--++-+---+ | File | 0 | PRIMARY |1 | FileId | A | 947714927 | NULL | NULL | | BTREE | | | | File | 1 | JobId|1 | JobId | A |2513 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |1 | JobId | A |2513 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |2 | PathId | A |30571449 | NULL | NULL | | BTREE | | | | File | 1 | JobId_2 |3 | FilenameId | A | 947714927 | NULL | NULL | | BTREE | | | +---++--+--+-+---+-+--++--++-+---+ 5 rows in set (0.00 sec) MariaDB [bacula] select count(*) from File ; +---+ | count(*) | +---+ | 947749966 | +---+ 1 row in set (0.00 sec) So it seems I'm more or less in the clear regarding our index setup, or am I missing something? Cheers thanks in advance, Uwe -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skills now (including 2012) with LearnDevNow - 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only - learn more at: http://p.sf.net/sfu/learnmore_122512 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - -- - _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Sr. Systems Programmer |$| |__| | | |__/ | \| _| |novos...@umdnj.edu - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/EI-Academic Svcs. - ADMC 450, Newark -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/ iEYEARECAAYFAlD/ZFUACgkQmb+gadEcsb7QjACgh2I9brotUCzV17wIqaUfEaX7 4D8AoNNw+SvElefUPWV1t175yl7RTPDt =RwzM -END PGP SIGNATURE- -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
