Hello! It's me again and I still have the same problem. After getting the attached error messages I supposed a mysql problem and updated from Version 3.23 to 4.1 and I deleted the complete bacula database and set it up again. But the problem still remains.
I really need help, because the backup hangs up nearly every night. Regards, Tim On Sunday 06 March 2005 17:38, Tim Oberfoell wrote: > Hello! > > I've a little problem with the director. The director has not executed our > nightly full backup and I'm wondering why. The dir seems to run (a pid is > given) but is not reachable by the console and is not doing anything. > > After restarting the dir I've tried to start the missed jobs by myself but > the "run" coammand is not executed completetly, because the dir again is > hanging. > > Here is what I've done in the console: > ----------------------------------------------------------- > SCL01M01:/etc/bacula # bconsole > Connecting to Director SCL01M01:9101 > 1000 OK: SCL01M01-dir Version: 1.36.2 (28 February 2005) > Enter a period to cancel a command. > *run > Using default Catalog name=MyCatalog DB=bacula > A job name must be specified. > The defined Job resources are: > 1: EjectTapeAfterJob > 2: SED_SFILE-TAPE > 3: SEDSFILE-HD > 4: SCL01M01-HD > 5: SCL01V11-HD > 6: SCL01V11-TAPE > 7: SCL01M01-TAPE > 8: SCL01N01-HD > 9: SCL01N01-TAPE > 10: SCL01N02-HD > 11: SCL01N02-TAPE > 12: SCL01V02-HD > 13: SCL01V02-TAPE > 14: SRAS01-HD > 15: SRAS01-TAPE > 16: SCL01V09-HD > 17: SCL01V09-TAPE > 18: SNOTES01-HD > 19: SNOTES01-TAPE > 20: SRAS02-HD > 21: SRAS02-TAPE > 22: BASTION01-HD > 23: BASTION01-TAPE > 24: SCL01V08-HD > 25: SCL01V08-TAPE > 26: SCL01V10-HD > 27: SCL01V10-TAPE > 28: SCL01V12-HD > 29: SCL01V12-TAPE > 30: SFAX01-HD > 31: SFAX01-TAPE > 32: SCL01V03-HD > 33: SCL01V03-TAPE > 34: SCL01V05-HD > 35: SCL01V05-TAPE > 36: SCL01V13-HD > 37: SCL01V13-TAPE > 38: SCL01V14-HD > 39: SCL01V14-TAPE > 40: BackupCatalog > 41: BackupCatalog-TAPE > 42: RestoreFiles > Select Job resource (1-42): 7 > Run Backup job > JobName: SCL01M01-TAPE > FileSet: Full Set > Level: Incremental > Client: SCL01M01-fd > Storage: EZ17 > Pool: TapeDailyDiffPool > When: 2005-03-06 15:46:12 > Priority: 10 > OK to run? (yes/mod/no): m > Parameters to modify: > 1: Level > 2: Storage > 3: Job > 4: FileSet > 5: Client > 6: When > 7: Priority > 8: Pool > Select parameter to modify (1-8): 8 > The defined Pool resources are: > 1: Default > 2: DiskIncPool > 3: DiskFullPool > 4: TapeDailyDiffPool > 5: TapeWeeklyFullPool > 6: TapeMonthlyFullPool > Select Pool resource (1-6): 6 > Run Backup job > JobName: SCL01M01-TAPE > FileSet: Full Set > Level: Incremental > Client: SCL01M01-fd > Storage: EZ17 > Pool: TapeMonthlyFullPool > When: 2005-03-06 15:46:12 > Priority: 10 > OK to run? (yes/mod/no): m > Parameters to modify: > 1: Level > 2: Storage > 3: Job > 4: FileSet > 5: Client > 6: When > 7: Priority > 8: Pool > Select parameter to modify (1-8): 1 > Levels: > 1: Base > 2: Full > 3: Incremental > 4: Differential > 5: Since > Select level (1-5): 2 > Run Backup job > JobName: SCL01M01-TAPE > FileSet: Full Set > Level: Full > Client: SCL01M01-fd > Storage: EZ17 > Pool: TapeMonthlyFullPool > When: 2005-03-06 15:46:12 > Priority: 10 > OK to run? (yes/mod/no): yes > !!!!!!!!!!!!!!!!!!!!(Here it hangs, directly after pressing > enter)!!!!!!!!!!!!!!!!!!!! > ----------------------------------------------------------- > > > Here is an excerpt the output of "bacula-dir -f -c bacula-dir.conf -d1000": > ----------------------------------------------------------- > SCL01M01-dir: scan.c:138 Next arg=run > SCL01M01-dir: scan.c:167 End arg=run next= > SCL01M01-dir: scan.c:138 Next arg= > SCL01M01-dir: scan.c:167 End arg= next= > SCL01M01-dir: ua_cmds.c:150 Command: run > SCL01M01-dir: ua_cmds.c:2004 Open database > SCL01M01-dir: mysql.c:81 db_open first time > SCL01M01-dir: mem_pool.c:111 sm_get_pool_memory reuse 80cdf58 to mysql.c:97 > SCL01M01-dir: mem_pool.c:111 sm_get_pool_memory reuse 80c0fb0 to mysql.c:99 > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d5130 to mysql.c:100 > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d5260 to mysql.c:103 > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d5390 to mysql.c:104 > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d54c0 to mysql.c:105 > SCL01M01-dir: mysql.c:141 mysql_init done > SCL01M01-dir: mysql.c:161 mysql_real_connect done > SCL01M01-dir: mysql.c:163 db_user=bacula db_name=bacula db_password= > SCL01M01-dir: sql.c:55 int_handler starts with row pointing at 80db6c8 > SCL01M01-dir: sql.c:58 int_handler finds '8' > SCL01M01-dir: sql.c:64 int_handler finishes > SCL01M01-dir: ua_cmds.c:2019 DB bacula opened > SCL01M01-dir: ua_run.c:269 Done scan. > SCL01M01-dir: ua_run.c:279 Using catalog=(null) > SCL01M01-dir: ua_run.c:322 Using storage=EZ17 > SCL01M01-dir: ua_run.c:342 Using pool > SCL01M01-dir: ua_run.c:362 Using client=SCL01M01-fd > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d7d08 to jcr.c:202 > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d8090 to jcr.c:204 > SCL01M01-dir: mem_pool.c:127 sm_get_pool_memory give 80d82c0 to job.c:777 > SCL01M01-dir: ua_run.c:481 JobType=B > SCL01M01-dir: watchdog.c:286 pthread_cond_timedwait 30 > SCL01M01-dir: ua_run.c:481 JobType=B > SCL01M01-dir: ua_run.c:481 JobType=B > SCL01M01-dir: ua_run.c:851 Calling run_job job=80c2200 > SCL01M01-dir: message.c:246 Copy message resource 0x80cc080 to 0x80d8480 > SCL01M01-dir: job.c:108 Open database > SCL01M01-dir: mysql.c:74 DB REopen 1 bacula > SCL01M01-dir: job.c:121 DB opened > ----------------------------------------------------------- > > > I hope somebody is able to help me. > > Best Regards, > Tim > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users
12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Fatal error: Network error with FD during Backup: ERR=No data available 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Fatal error: No Job status returned from FD. 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Error: sql_update.c:166 sql_update.c:166 update UPDATE Job SET JobStatus='f', EndTime='2005-03-12 15:37:41', ClientId=4, JobBytes=0, JobFiles=0, JobErrors=0, VolSessionId=4, VolSessionTime=1110588271, PoolId=4, FileSetId=1, JobTDate=1110638261 WHERE JobId=140 failed: 12-Mar 15:37 SCL01M01-dir: sql_update.c:166 UPDATE Job SET JobStatus='f', EndTime='2005-03-12 15:37:41', ClientId=4, JobBytes=0, JobFiles=0, JobErrors=0, VolSessionId=4, VolSessionTime=1110588271, PoolId=4, FileSetId=1, JobTDate=1110638261 WHERE JobId=140 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Warning: Error updating job record. sql_update.c:166 update UPDATE Job SET JobStatus='f', EndTime='2005-03-12 15:37:41', ClientId=4, JobBytes=0, JobFiles=0, JobErrors=0, VolSessionId=4, VolSessionTime=1110588271, PoolId=4, FileSetId=1, JobTDate=1110638261 WHERE JobId=140 failed: 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Fatal error: sql_get.c:277 sql_get.c:277 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId FROM Job WHERE JobId=140 failed: 12-Mar 15:37 SCL01M01-dir: sql_get.c:277 SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId FROM Job WHERE JobId=140 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Warning: Error getting job record for stats: sql_get.c:277 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId FROM Job WHERE JobId=140 failed: 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Fatal error: sql_get.c:823 sql_get.c:823 query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock FROM Media WHERE VolumeName='Freitag_1' failed: 12-Mar 15:37 SCL01M01-dir: sql_get.c:823 SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock FROM Media WHERE VolumeName='Freitag_1' 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Warning: Error getting Media record for Volume "Freitag_1": ERR=Media record not found in Catalog. 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Fatal error: sql_get.c:333 sql_get.c:333 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media WHERE JobMedia.JobId=140 AND JobMedia.MediaId=Media.MediaId GROUP BY VolumeName ORDER BY 2 ASC failed: 12-Mar 15:37 SCL01M01-dir: sql_get.c:333 SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media WHERE JobMedia.JobId=140 AND JobMedia.MediaId=Media.MediaId GROUP BY VolumeName ORDER BY 2 ASC 12-Mar 15:37 SCL01M01-dir: SCL01M01-TAPE.2005-03-12_01.52.40 Error: Bacula 1.36.2 (28Feb05): 12-Mar-2005 15:37:41
