t;> I think the Wiki has a list that is a bit more up to date:
>>
>> http://wiki.bacula.org/doku.php?id=faq#what_do_all_those_job_status_codes_mean
>
> I'm glad all the work is being recorded on the wiki. When I get my
> documentation hat on, the docs will be updated.
In a
this is
an email forum, and as such ought to be conducted in plain text, not
half-html. Dan isn't complaining that we won't read config files, or
that you shouldn't post them, but rather, the file that was posted
was difficult/impossible to read. If you want help, ask for it in a
e, which is
omitted in the second version? With my experience of Oracle, that
looks like an "execution hint", in other words a directive to help
the database choose the most efficient way of retrieveing the data.
It's a specially formed comment, hence the /* ... */, so you ei
an Oracle
expert, as that is what I get paid for in my day job :-)
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
--
This
Mike Holden wrote:
> If I can find how to register as a wiki contributor, I'll update the
> page, otherwise somebody else may wish to take on these minor
> modifications?
I've registered and updated the wiki page at
http://wiki.bacula.org/doku.php?id=application_specific_backup
0)) is not big enough. I would
suggest increasing this value to 2 million, which is the maximum
value allowed. I've also go no idea why this is run as a separate
exec call at the top, rather than as the first line of the pl/sql
script!
If I can find how to regist
scripts we
may be able to spot what is wrong!
Can you run the hotbackup script directly in sqlplus using "@
runhotbackup.sql" from within sqlplus? If so, then the problem is
elsewhere, if not then error message sill
n of the appropriate sh or bash or ksh
executable file in this case.
5. sudo or some other security mechanism (SELinux etc) is blocking
execution. You may be able to check the logs for these applications
to see if this is the case.
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner
; necessary.
Have you downloaded and installed the various scripts mentioned on
that wiki (namely runbeforebackup.sh, runafterbackup.sh etc - there
are 5 named)?
If so, what path have you saved them at, and have you made the *.sh
scripts executable after downloading them (using the chmod command)
wer priority, so that it runs immediately after the first one
completes.
Not sure if concurrency could be an issue here? You may need to
ensure only 1 job runs at a time.
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted it
r: sqlite.c:178 Database
> /var/lib/bacula/bacula.db does not exist, please create it.
The sqlite.c error in the log would suggest that maybe it is trying
to use sqlite rather than mysql?
--
Mike Holden
http://www.by-
e instances of the same extension in
different cases by using UPPER() like this:
OR UPPER((Filename.Name LIKE "%MPG"))
--
Mike Holden
http://www.by-ang.com - th
mario parreño wrote:
> Check file /var/run/bacula-dir.9101.pid
Did you do this part?
If this file exists, and the director is not running, then the
startup script thinks that it _is_ running.
If the director is _not_ running, you can safely remove that file
and try again.
--
Mike Holden
h
ume Jobs = 1?
I appreciate that this is something of a corner case!
I also appreciate, before someone else point it out, that using
labels with dates in them etc is not a good idea due to recycling
files, but these files are not recycled, and only used once each, so
there is no future confu
ytes=0
> MigTime=0 secs MigHiBytes=0 MigLoBytes=0
>
> Thanks.
If I read that right, you have retention set to 1 month as well, so
it will recycle after one month! Recycling happens at the first
limit reached, so 1 month happens before 45 volumes.
--
Mike Holden
http://w
- should backups be pruned, purged and truncated
automatically if
the backup fails?
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
Martin Simmons wrote:
>>>>>> On Wed, 24 Feb 2010 20:45:01 -, Mike Holden said:
>>
>> bextract: record.c:465-0 Block=219743 Ver=2 size=64512
>> bextract: record.c:473-0 Enter read_record_block: remlen=56750 data_len=222
>> rem=0
>> blkver=2
Nobody got any clues at all? (Sorry for top-post, seemed more appropriate this
time!!!)
--
Mike Holden wrote:
> Been struggling with a difficult restore for a few days now, and need some
> help
> please.
>
> The short story is that I am trying to recover files from a disk archi
n recover
more
than I am currently getting. Of course, Sod's Law dictates that the files I am
most
interested in are closer to the end of the volume than the beginning!
I should also mention that I am using bacula version 3.0.3 on fedora 12,
although
the backup was originally created under ba
e entire array. Keep them separate and you only lose the disk that failed
and
the other 11 continue to work fine.
One "bug" partition could well be an aposite typo :-)
--
Mike Holden
http://www.by-ang.com - the place
y
> problem :) It looks like it's working first time after two months of trying
> to make it
> work.
store0001 -> store0010 should be files, not directories. That is your problem!
You are
now using a different destination creating files called "backup", so th
ly not adequate, since
you need
execute permission as well. 666 gives rw-, while you need rwx to allow the
bacula server
to descend into the directories.
Assuming you are running bacula as root, and root owns both /mnt and /mnt/mnt1,
then
/mnt and /mnt/mnt1 should have 755 permissions, or even
"idiot limit" to stop people running huge queries that will cripple
the
database performance - I'm not suggesting you are an idiot, just that the
database maybe
thinks bacula is an idiot ;-)
Either this is due to a bug in bacula, or you are hitting some limit in your
database
configurati
complicated but more accurate as you are
> letting bacula decide what gets removed instead of externally forcing
> the issue.
>
> John
I posted a script recently on another thread which takes care of purging,
deleting
volumes and deleting the files based on individual retention periods
t!!!
Automated removal as detailed by Marek above is difficult to implement simply,
because
you will probably have multiple retention periods on your files, and you need
to take
this into account in your deletion. Plus, deleting the files while they are
still listed
in the bacula database is possib
list but not in the GROUP BY
clause. I
would suggest (to give standard SQL code), that you change the "GROUP BY clause
to
"GROUP BY Client.Name, Pool.Name". You might want to update the ORDER BY in the
same
way.
--
Mike Holden
http://www.by-ang.com -
l
the other output columns in the query would need to be listed in the GROUP BY
clause.
If you want size by client, then you don't need to be listing any columns other
than
Client.Name and sum(JobBytes) in the SELECT clause.
--
Mike Holden
http://www.by-ang.co
stuff like that!
Be wary of using fancy labels that include the date etc when the volume can be
re-used
at a later date, because the violume name will then be very misleading. It's
only really
useful for volumes that will only be written once.
--
Mike Holden
http://www.by-ang.com - the pla
ing a
Flash Recovery Area (FRA) for Oracle backups, rather than using an external
tool,
however good Bacula may be at simple file backups!
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted items,
including Jewellery, Greet
loop goes round
several million times, the cumulative time becomes significant.
One general rule of thumb of SQL execution is that bulk processing is
almost always faster than processing records individually in a loop.
--
Mike Holden
--
(my day job) that this can often
produce far more efficient results.
Of course, all options need testing for both speed of execution and
resource usage, bearing in mind that data varies from one installation to
another, and one size may not fit all!
--
M
lieve I have anything further to add on the subject, and I respectfully
suggest we all get back to discussing bacula :-)
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Gree
and sends a mail they want to see
a reply to, then it's up to them to ensure that they have a setup that
allows them to see those replies, surely. It's not MY responsibility you
ensure that YOU receive my email, it's yours.
--
Mike Holden
t need anyone to send me a personal
copy of an email they are sending to the list, because I just end up with
2 copies of it.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items,
till get
any bounces back anyway if the victim email addresses fail (unknown email
address, quota exceeded etc). A fair percentage of the spam I receive is
bounce messages from spam sent "on my behalf" (i.e. spoofed From address)
to invalid email addresses.
Not a lot I can do about it, unfortun
Ulrich Leodolter wrote:
> On Wed, 2009-03-18 at 17:49 +0000, Mike Holden wrote:
>> Ulrich Leodolter wrote:
>> > PS: RTFM might help too
>>
>> That sounds interesting. Where can I download that from?
>>
>
> http://mysqltuner.pl
>
>
> Isn't it
Ulrich Leodolter wrote:
> PS: RTFM might help too
That sounds interesting. Where can I download that from?
:-)
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gi
4 - Configure Oracle DB in backup mode off.
> 5 - Destroy the Snapshot
You need to swap items 3 and 4 if you use a snapshot. You need to aim to
keep the database in backup mode for as short a time as possible, as
performance is impacted during that time.
--
Mike Holden
http://www.by-ang.c
o status=1.
>> ERR=Child exited with code 1
>
> (Client)RunBefore/AfterJob:
> sticking commands one after another on one line separated by semicolon
> seems not to work propperly.
Probably better therefore to write your own shell script to do everything
you want, save it somewher
ve with a piece of software more complex than a simple
text editor?
Feel free to throw good money down the drain on an expensive backup
program that will be less feature rich and more buggy, and with a company
less responsive to bug reports than bacula if you like, but everyone else
here knows yo
You could also look at using iotop and iftop to check disk and network
throughtput at the problem times to see what is going on.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
on was finalised, and this forced
them to change their coding practices to cope with their final choice of
product. Barmy!
I used CVS for my own stuff at work (as a DBA/Unix guy I was outside the
main development loop so wasn't tied in with what they were using), and
was very happy with it.
mail address to an admin email address for the group.
That said though, Yahoo groups is a bit pants really, and I wouldn't have
subscribed at all if there was any other way!
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including J
aw was http://ubuntuforums.org/showthread.php?t=398332 which heads
towards xfs/jfs for your arena.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Card
or
smaller, just because of recovery times when only a single file needs to
be recovered.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
--
I know but this varies
significantly from one database to another), then look into setting up a
FLASH RECOVERY AREA and use that as a staging area for your backups.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Car
ng them, I got no error from "estimate" command.
That first one is the suspect. The "find" command expects the first
parameter to be a directory. In that case, it is a filename.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand cra
and check the r and x permissions allow the
appropriate user to browse into them.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
Charlie Reddington wrote:
> Okay, that makes sense. So if
48 matches
Mail list logo
