3 * Bacula Director -- Automatic Recycling of Volumes
4 * Recycles Volumes that have been purged
6 * Kern Sibbald, May MMII
12 Copyright (C) 2002-2004 Kern Sibbald and John Walker
14 This program is free software; you can redistribute it and/or
15 modify it under the terms of the GNU General Public License as
16 published by the Free Software Foundation; either version 2 of
17 the License, or (at your option) any later version.
19 This program is distributed in the hope that it will be useful,
20 but WITHOUT ANY WARRANTY; without even the implied warranty of
21 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
22 General Public License for more details.
24 You should have received a copy of the GNU General Public
25 License along with this program; if not, write to the Free
26 Software Foundation, Inc., 59 Temple Place - Suite 330, Boston,
40 static int oldest_handler(void *ctx, int num_fields, char **row)
42 struct s_oldest_ctx *oldest = (struct s_oldest_ctx *)ctx;
45 oldest->MediaId = str_to_int64(row[0]);
46 bstrncpy(oldest->LastWritten, row[1]?row[1]:"", sizeof(oldest->LastWritten));
47 Dmsg1(100, "New oldest %s\n", row[1]?row[1]:"");
52 /* Forward referenced functions */
54 int find_recycled_volume(JCR *jcr, bool InChanger, MEDIA_DBR *mr)
56 bstrncpy(mr->VolStatus, "Recycle", sizeof(mr->VolStatus));
57 if (db_find_next_volume(jcr, jcr->db, 1, InChanger, mr)) {
58 jcr->MediaId = mr->MediaId;
59 Dmsg1(20, "Find_next_vol MediaId=%u\n", jcr->MediaId);
60 pm_strcpy(jcr->VolumeName, mr->VolumeName);
68 * Look for oldest Purged volume
70 int recycle_oldest_purged_volume(JCR *jcr, bool InChanger, MEDIA_DBR *mr)
72 struct s_oldest_ctx oldest;
74 POOLMEM *query = get_pool_memory(PM_EMSG);
76 "SELECT MediaId,LastWritten FROM Media "
77 "WHERE PoolId=%s AND Recycle=1 AND VolStatus='Purged' "
78 "AND MediaType='%s' %s"
79 "ORDER BY LastWritten ASC,MediaId LIMIT 1";
81 Dmsg0(100, "Enter recycle_oldest_purged_volume\n");
84 Mmsg(query, select, edit_int64(mr->PoolId, ed1), mr->MediaType,
87 Mmsg(query, select, edit_int64(mr->PoolId, ed1), mr->MediaType, "");
90 if (!db_sql_query(jcr->db, query, oldest_handler, (void *)&oldest)) {
91 Jmsg(jcr, M_ERROR, 0, "%s", db_strerror(jcr->db));
92 Dmsg0(100, "return 0 recycle_oldest_purged_volume query\n");
93 free_pool_memory(query);
96 free_pool_memory(query);
97 Dmsg1(100, "Oldest mediaid=%d\n", oldest.MediaId);
98 if (oldest.MediaId != 0) {
99 mr->MediaId = oldest.MediaId;
100 if (db_get_media_record(jcr, jcr->db, mr)) {
101 if (recycle_volume(jcr, mr)) {
102 Jmsg(jcr, M_INFO, 0, "Recycled volume \"%s\"\n", mr->VolumeName);
103 Dmsg1(100, "return 1 recycle_oldest_purged_volume Vol=%s\n", mr->VolumeName);
107 Jmsg(jcr, M_ERROR, 0, "%s", db_strerror(jcr->db));
109 Dmsg0(100, "return 0 recycle_oldest_purged_volume end\n");
114 * Recycle the specified volume
116 int recycle_volume(JCR *jcr, MEDIA_DBR *mr)
118 bstrncpy(mr->VolStatus, "Recycle", sizeof(mr->VolStatus));
119 mr->VolJobs = mr->VolFiles = mr->VolBlocks = mr->VolErrors = 0;
121 mr->FirstWritten = mr->LastWritten = 0;
122 return db_update_media_record(jcr, jcr->db, mr);