Details
Description
Automated and Manual runs = both can easily run into this issue
Automated test to repro:
./testrunner -i fournode_windows_2012_r2.ini -t tuqquery.tuq_dml.DMLQueryTests.test_update_where,force_clean=True,reload_data=False,nodes_init=1,skip_load=True
What the test does
- Create a bucket
- create primary view index on the bucket
- Issue INSERTs ( ~ 20) on the bucket
- Check system:indexes to see if the indexes are online - Error:
System database error: Failed to load indexes for keyspace default
Successive attempts to read this as unsuccessful, after the index is completely online only - Can I get any results from system:indexes.
Strange observations:
- Indexing primary view index on a nearly empty bucket ( doc contains fewer than 2 records) taking more than a couple of minutes
- While the index is being built , system catalog tables should display "pending" state, not sure why it throws up a System database error.
- This impacts most of our tests, where we check if an index is online or not, and this above failure causes intermittent expectations on the test.
Logs https://s3.amazonaws.com/cb-customers/a/1/collectinfo-2015-05-01T182445-ns_1%40172.23.107.90.zip