- struct s_oldest_ctx oldest;
- char ed1[50];
- POOLMEM *query = get_pool_memory(PM_EMSG);
- const char *select =
- "SELECT MediaId,LastWritten FROM Media "
- "WHERE PoolId=%s AND Recycle=1 AND VolStatus='Purged' "
- "AND MediaType='%s' %s"
- "ORDER BY LastWritten ASC,MediaId LIMIT 1";
-
- Dmsg0(100, "Enter recycle_oldest_purged_volume\n");
- oldest.MediaId = 0;
- if (InChanger) {
- char changer[100];
- bsnprintf(changer, sizeof(changer), "AND InChanger=1 AND StorageId=%s",
- edit_uint64(mr->StorageId, ed1));
- Mmsg(query, select, edit_int64(mr->PoolId, ed1), mr->MediaType, changer);
- } else {
- Mmsg(query, select, edit_int64(mr->PoolId, ed1), 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, "return 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)) {
- 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 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;