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 Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users