Re: [Bacula-users] innodb_autoinc_lock_mode
Thank you, Phil ! I appreciate you taking the time to reply and for the information. That is good news! -craig On Fri, Oct 23, 2015 at 12:09 PM, Phil Stracchino wrote: > On 10/23/15 14:47, Craig Shiroma wrote: > > Hello, > > > > We are experiencing database performance problems with locks occurring. > > We think it is because jobs that require a huge amount of inserts is > > holding on to innodb_autoinc. We are thinking of changing the following > > to see if it helps. > > > > innodb_autoinc_lock_mode = 1 > > > > to: > > > > innodb_autoinc_lock_mode = 2 > > > > I think the change causes a problem with database replication. However, > > we currently are not doing DB replication so we don't think that will be > > a problem. Does anyone know if this change will cause other problems? > > In my professional capacity, I recommend this tuning change to all of > our customers by default. It can make a big difference. > > There is basically one caveat: If you use innodb_autoinc_lock_mode = 2 > in a replicated environment, you MUST set binlog_format to either ROW or > MIXED, because it is unsafe in STATEMENT mode. (If set to MIXED, MySQL > will know that it is an unsafe operation and automatically record it as > ROW.) Provided that is done, this is 100% safe unless you are using an > application which can insert multiple rows in a single transaction and > expects them to have strictly consecutive auto-increment IDs, but does > not actually check that they do. (In which case, the application > developer is doing it wrong.) > > > -- > Phil Stracchino > Babylon Communications > ph...@caerllewys.net > p...@co.ordinate.org > Landline: 603.293.8485 > > > -- > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacula wont backup new partition /nfs01
I just added a new disk and mounted it as /nfs01 and put 107gb of data on
it.
root@warlocke:/etc/bacula# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/root59G 17G 40G 30% /
devtmpfs428M 0 428M 0% /dev
tmpfs87M 412K 86M 1% /run
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 173M 0 173M 0% /run/shm
/dev/mmcblk0p1 56M 20M 37M 36% /boot
/dev/sda1 230G 107G 112G 49% /nfs01
/dev/sdc1 230G 25G 193G 12% /bacula/backup
I added this "File" to the dir conf as below and restarted bacula-dir run a
backup but bacula is not backing it up as /bacula/backup is still only
showing 25gb used and the backup is 40mb,
# List of files to be backed up
FileSet {
Name = "Full Set"
Include {
Options {
signature = MD5
compression = GZIP
}
#
# Put your list of files here, preceded by 'File =', one per line
#or include an external list with:
#
#File = --
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] catalogue fails after a reboot....
Hi, Not that I am aware of. I am trying to get bacula to backup a new partition so I added that, which is failing, so I may have an introduced syntax error, === #directory to give a reasonable FileSet to backup to #disk storage during initial testing. # #File = /usr/sbin File = / File = /nfs01 } # # If you backup the root directory, the following two excluded === So I added /nfs01 On 27 October 2015 at 10:21, John Drescher wrote: > > | warlocke-dir JobId 86: BeforeJob: Can't find your catalog (MyCatalog) > in > > director configuration > > I would start at this error message. Did you edit bacula_dir.conf > recently? Does it have a catalog resource named MyCatalog? > > John > -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] catalogue fails after a reboot....
> | warlocke-dir JobId 86: BeforeJob: Can't find your catalog (MyCatalog) in > director configuration I would start at this error message. Did you edit bacula_dir.conf recently? Does it have a catalog resource named MyCatalog? John -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] catalogue fails after a reboot....
Not sure what is going on here, but I took down the Pi to add a sata disk
and now the catalogue fails,
before job 80 was successful,
=
root@warlocke:/etc/bacula/scripts# bconsole
Connecting to Director localhost:9101
bconsole: bsock.c:223 Socket open error. proto=10 port=9101. ERR=Address
family not supported by protocol
1000 OK: warlocke-dir Version: 5.2.6 (21 February 2012)
Enter a period to cancel a command.
*status
Status available for:
1: Director
2: Storage
3: Client
4: All
Select daemon type for status (1-4): 1
warlocke-dir Version: 5.2.6 (21 February 2012) arm-unknown-linux-gnueabihf
debian 7.0
Daemon started 25-Oct-15 14:34. Jobs: run=8, running=0 mode=0,0
Heap: heap=393,216 smbytes=87,831 max_bytes=95,209 bufs=272 max_bufs=297
Scheduled Jobs:
Level Type Pri Scheduled Name Volume
===
IncrementalBackup10 27-Oct-15 23:05BackupLocalFiles
Local-0001
Full Backup11 27-Oct-15 23:10BackupCatalog
Local-0001
Running Jobs:
Console connected at 27-Oct-15 09:51
Console connected at 27-Oct-15 10:02
No Jobs running.
Terminated Jobs:
JobId LevelFiles Bytes Status FinishedName
77 Incr50936.62 M OK 24-Oct-15 23:06
BackupLocalFiles
78 Full 141.11 M OK 24-Oct-15 23:10 BackupCatalog
79 Diff 23,0749.560 G OK 26-Oct-15 00:15
BackupLocalFiles
80 Full 143.75 M OK 26-Oct-15 00:16 BackupCatalog
81 Incr 1,03038.23 M OK 26-Oct-15 10:31
BackupLocalFiles
82 Incr76948.88 M OK 26-Oct-15 15:09
BackupLocalFiles
83 Incr60438.04 M OK 26-Oct-15 19:41
BackupLocalFiles
84 Incr58936.35 M OK 26-Oct-15 23:06
BackupLocalFiles
85 Full 0 0 Error26-Oct-15 23:10 BackupCatalog
86 Full 0 0 Error27-Oct-15 09:51 BackupCatalog
*
after the reboot job 85 and 86 failed,
===
*list joblog jobid=86
++
|
LogText
|
++
| warlocke-dir JobId 86: shell command: run BeforeJob "/etc/bacula/scripts/
make_catalog_backup.pl MyCatalog"
|
| warlocke-dir JobId 86: BeforeJob: Can't find your catalog (MyCatalog) in
director configuration
|
| warlocke-dir JobId 86: Error: Runscript: BeforeJob returned non-zero
status=1. ERR=Child exited with code 1
|
| warlocke-dir JobId 86: Error: Bacula warlocke-dir 5.2.6 (21Feb12):
Build OS: arm-unknown-linux-gnueabihf debian 7.0
JobId: 86
Job:BackupCatalog.2015-10-27_09.51.32_14
Backup Level: Full
Client: "warlocke-fd" 5.2.6 (21Feb12)
arm-unknown-linux-gnueabihf,debian,7.0
FileSet:"Catalog" 2015-10-20 11:11:52
Pool: "File" (From Job resource)
Catalog:"MyCatalog" (From Client resource)
Storage:"File" (From Job resource)
Scheduled time: 27-Oct-2015 09:51:29
Start time: 27-Oct-2015 09:51:34
End time: 27-Oct-2015 09:51:34
Elapsed time: 0 secs
Priority: 11
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS:no
Encryption: no
Accurate: no
Volume name(s):
Volume Session Id: 0
Volume Session Time:0
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors:1
SD Errors: 0
FD termination status:
SD termination status:
Termination:*** Backup Error ***
|
++
+---+---+-+--+---+--+--+---+
| JobId | Name | StartTime | Type | Level | JobFiles |
JobBytes | JobStatus |
+---+---+-+--+---+--+--+---+
|86 | BackupCatalog | 2015-10-27 09:51:34 | B| F |0
|0 | E |
+---+---+-+--+---+--+--+---+
*quit
root@warlocke:~# cd /etc/bacula/
==
8><
# Backup the catalog database (after the nightly save)
Job {
Name = "BackupCatalog"
JobDefs = "DefaultJob"
Level = Full
FileSet="Catalog"
Schedule = "WeeklyCycleAfterBackup"
# This creates an ASCII copy of the catalog
# Arguments
