Project

General

Profile

« Previous | Next » 

Revision 7520

Added by ben leinfelder almost 12 years ago

select only distinct guids (synch may have failed more than once for any given guid)
https://redmine.dataone.org/issues/3539

View differences:

src/edu/ucsb/nceas/metacat/admin/upgrade/RemoveInvalidReplicas.java
112 112 
	        // find the replicas that failed to synch
113 113 
			List<String> invalidReplicas = new ArrayList<String>();
114 114 
			pstmt = sqlca.prepareStatement(
115 
					"SELECT guid " +
115 
					"SELECT distinct guid " +
116 116 
					"FROM xml_documents xml, identifier id, access_log log " +
117 117 
					"WHERE id.docid = xml.docid " +
118 118 
					"AND id.rev = xml.rev " +
......
120 120 
					"AND xml.server_location = ? " +
121 121 
					"AND log.event = ? " +
122 122 
					"UNION " +
123 
					"SELECT guid " +
123 
					"SELECT distinct guid " +
124 124 
					"FROM xml_revisions xml, identifier id, access_log log " +
125 125 
					"WHERE id.docid = xml.docid " +
126 126 
					"AND id.rev = xml.rev " +

Also available in: Unified diff