Re: [Bacula-users] Failed on backup volume 2 suddenly

2014-11-24 Thread Cejka Rudolf
Keith T wrote (2014/11/21): > BTW, any advise/references of tuning "DB dir inserting" faster? Thanks > in advance! MySQL: MyISAM & delay_key_write = ALL and either do not do unexpected power offs (not so hard today), or when the disaster happens, run "repair table ..." for all tables in bacula da

Re: [Bacula-users] Failed on backup volume 2 suddenly

2014-11-21 Thread Keith T
Hi Heitor, Many thanks! But tried to recreate a new database and catalog since I stuck there for some times. Now, the backup job was running and doing volume 3 data backup. Hope it will be accomplished in this weekend. BTW, any advise/references of tuning "DB dir inserting" faster? Thanks in a

Re: [Bacula-users] Failed on backup volume 2 suddenly

2014-11-12 Thread heitor
Keith, Did you check this? It's for MySQL, but for PgSQL I think would be the same logic. Fixing table 'bacula.batch' doesn't exist Newer versions of Bacula create a temporary working table in order to do batch inserts, which can greatly speed up inserting attributes into the catalog. Unfo

Re: [Bacula-users] Failed on backup volume 2 suddenly

2014-11-12 Thread heitor
Keith, Did you check this? It's for MySQL, but for PgSQL I think would be the same logic. Fixing table 'bacula.batch' doesn't exist Newer versions of Bacula create a temporary working table in order to do batch inserts, which can greatly speed up inserting attributes into the catalog. Unfo

Re: [Bacula-users] Failed on backup volume 2 suddenly

2014-11-10 Thread Keith T
Hi Heitor, Thanks for your kind reply!  No upgrade had done in those few months for Bacula. If DB got error, just query why volume 1 has no problem but always stuck at volume 2? Is it able to check/repair the DB comes with bacula? Or shall I check postgresql manual? I ran the job again after rep

Re: [Bacula-users] Failed on backup volume 2 suddenly

2014-11-10 Thread heitor
10-Nov 01:12 bacula-fd JobId 1105: Error: bsock.c:429 Write error sending 29424 bytes to Storage daemon:localhost:910 3: ERR=Connection reset by peer 10-Nov 01:12 bacula-fd JobId 1105: Fatal error: backup.c:1200 Network send error to SD. ERR=Connection reset by peer 10-Nov 01:45 bacula-dir Jo

[Bacula-users] Failed on backup volume 2 suddenly

2014-11-09 Thread Keith T
Hi there, Since last two month the monthly job always failed when backup data to volume 2 (around 73%) with below error message. I should not do any change of bacula configuration in this period. Any idea? Thanks in advance! Connecting to Director baculab:9101 1000 OK: bacula-dir Version: 5.2.13