Unsolved
This post is more than 5 years old
1 Message
0
2806
February 11th, 2011 10:00
Query Returns No Results When Clips Exist
What could cause a Query to return no results when there are clearly clips in its query range? As I understand it, if you have Query Capabilities on the Pool with the Clip(s) in question, then performing a Query operation across a containing date range should always return the ClipID(s). But I've got Clips that are clearly still existing yet which don't return as results from a Query. The really strange thing is that I know Query has worked in the past, since that's how I got this list of ClipIDs in the first place.
Here's an example, straight from JCASScript:
CASScript>capabilities
CASPool Capabilities:
Supports Read Operations: True
Read Pools: default,84ba3j94-2ln1-94p2-f8ca-decns48b78z6-5
Supports Write Operations: True
Write Pools: default,84ba3j94-2ln1-94p2-f8ca-decns48b78z6-5
Supports Purge Operations: False
Purge Pools:
Supports Delete Operations: True
Delete Pools: default,84ba3j94-2ln1-94p2-f8ca-decns48b78z6-5
Supports Exist Operations: True
Exist Pools: default,84ba3j94-2ln1-94p2-f8ca-decns48b78z6-5
Supports Query Operations: True
Query Pools: default,84ba3j94-2ln1-94p2-f8ca-decns48b78z6-5
Supports PrivilegedDelete : False
PrivilegedDelete Pools:
Supports Monitor Operations: False
PoolMappings Pools:
PoolMappings Profiles:
Supports DeletionLogging : True
Default Retention Period: -1
Blob Naming Scheme: MD5,MG
Cluster Mode: CE+
EventBased Retention: Not Supported
Retention min-max: Not Supported
Retention Hold: Not Supported
Retention Hold allowed: False
Minimum Fixed Retention: 0
Maximum Fixed Retention: -1
Minimum Variable Retention: 0
Maximum Variable Retention: -1
CASScript>query
Performing clip query
Query Expression Properties:
Start Time: 2003.12.01 00:00:00 GMT
End Time : 2004.01.01 00:00:00 GMT
Type : EXISTING & DELETED
Number of clips returned: 0
All results returned: True
CASScript>clipOpen 7OXERNA2P3EM9eQ7LNA2LWENPEN
Clip Properties:
Name: example_clip
Creation Date: 2003.12.09 12:40:43 GMT
Size: 2055
Number of Tags: 1
Number of Blobs: 1
Retention Class:
Retention Seconds: 94608000
Modified: False
EBR Enabled : False
If anyone knows what could be causing this, I'd really appreciate some input. I am completely baffled at this point. Thanks!
gstuartemc
2 Intern
•
417 Posts
0
February 11th, 2011 11:00
Is there a replica? Depending on how you have things set up, your query may be only on the local cluster where the clip has been deleted but the clip open is failing over to a replica where it still exists.
Graham L. Stuart
Principal Software Engineer
jjdemski
5 Posts
0
February 14th, 2011 09:00
Could it be something along the lines of the query returning results for the application's virtual pool, but the clip that was opened exists in the default pool?