Dear experts,
I've migrate from bacula 2.03 to bacula 2.2 on FreeBSD-6.2 today.
In the same step I switch from sqlite2 to sqlite3. Here's what I've done:
- Both datases are on V10
- mv bacula.db bacula-sqlite2.db
- echo ".dump" | sqlite bacula-sqlite2.db > bacula-sqlite2.sql
- Upgrade bacula to V2.2 with sqlite3
- Recreate DB
- make_bacula_tables (uses make_sqlite3_tables !)
- sqlite3 bacula.db < bacula-sqlite2.sql
- Some warnings (sorry, miss to copy tem exactly):
JobMedia ... table has 11 colums but 12 values are commited
I looked into the table description (yes, 11 columns) but
12 are inserted (from sql export):
....
INSERT INTO JobMedia
VALUES(4196,1735,55,172358,172393,87,87,0,15499,154,0,0);
....
- Check the new database with bconsole
- list media, list jobs, etc.
seem to be o.k.
- Incremental backup of a FreeBSD client works well
- During full Backup of a FreeBSD client I've migrated
into a VMware machine I get:
....
02-Sep 15:30 bacula-sd: Sending spooled attrs to the Director. Despooling
64,329,756 bytes ...
02-Sep 16:53 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 1
02-Sep 16:53 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 2
02-Sep 16:53 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 3
02-Sep 16:53 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 442
.....
02-Sep 16:55 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 22
02-Sep 16:55 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 55
02-Sep 16:55 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 54
02-Sep 16:55 bacula-dir: FullDiffIncr-odie.2007-09-02_15.08.54 Warning:
sql_create.c:1076 More than one Filename! 2 for file: 56
02-Sep 17:01 bacula-dir: Bacula bacula-dir 2.2.0 (08Aug07): 02-Sep-2007
17:01:23
about 1090 lines. However the job completes successfully.
- Now I run dbcheck on the DB. Since it is > 800MB I expect it runns
for days.
Did I miss something, what kind of mistake did I make?
Any hints or encouraging words for me :-)
Many thanks and best regards
Lars
--
Lars Köller
EMail: [EMAIL PROTECTED] ([EMAIL PROTECTED])
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
