- struct s_oldest_ctx oldest;
- POOLMEM *query = get_pool_memory(PM_EMSG);
- char *select =
- "SELECT MediaId, LastWritten FROM Media "
- "WHERE PoolId=%u AND Recycle=1 AND VolStatus=\"Purged\" "
- "AND MediaType=\"%s\"";
-
- Dmsg0(100, "Enter recycle_oldest_purged_volume\n");
- oldest.MediaId = 0;
- bstrncpy(oldest.LastWritten, "9999-99-99 99:99:99", sizeof(oldest.LastWritten));
- Mmsg(&query, select, mr->PoolId, mr->MediaType);
- if (!db_sql_query(jcr->db, query, oldest_handler, (void *)&oldest)) {
- Jmsg(jcr, M_ERROR, 0, "%s", db_strerror(jcr->db));
- Dmsg0(100, "Exit 0 recycle_oldest_purged_volume query\n");
- free_pool_memory(query);
- return 0;
- }
- free_pool_memory(query);
- Dmsg1(100, "Oldest mediaid=%d\n", oldest.MediaId);
- if (oldest.MediaId != 0) {
- mr->MediaId = oldest.MediaId;
- if (db_get_media_record(jcr, jcr->db, mr)) {
- strcpy(mr->VolStatus, "Recycle");
- mr->VolJobs = mr->VolFiles = mr->VolBlocks = mr->VolErrors = 0;
- mr->VolBytes = 0;
- mr->FirstWritten = mr->LastWritten = 0;
- if (db_update_media_record(jcr, jcr->db, mr)) {
- Jmsg(jcr, M_INFO, 0, "Recycled volume \"%s\"\n", mr->VolumeName);
- Dmsg1(100, "Exit 1 recycle_oldest_purged_volume Vol=%s\n", mr->VolumeName);
- return 1;
- }
+ bstrncpy(mr->VolStatus, "Purged", sizeof(mr->VolStatus));
+ if (db_find_next_volume(jcr, jcr->db, 1, InChanger, mr)) {
+ if (recycle_volume(jcr, mr)) {
+ Jmsg(jcr, M_INFO, 0, _("Recycled volume \"%s\"\n"), mr->VolumeName);
+ Dmsg1(100, "return 1 recycle_oldest_purged_volume Vol=%s\n", mr->VolumeName);
+ return true;