This issue seems to become more and more problematic over time.
Opensearch query : https://opensearch.logs.openstack.org/_dashboards/app/discover?security_tenant=global#/?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-7d,to:now))&_a=(columns:!(_source),filters:!(('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'94869730-aea8-11ec-9e6a-83741af3fdcd',key:project,negate:!f,params:(query:openstack%2Fnova),type:phrase),query:(match_phrase:(project:openstack%2Fnova)))),index:'94869730-aea8-11ec-9e6a-83741af3fdcd',interval:auto,query:(language:kuery,query:'%22sqlite3.OperationalError:%20no%20such%20table:%20instance_faults%22'),sort:!())
I can read 1525 hits on the last 7 days (if my query is correct and doesn't include false positives)
This issue seems to become more and more problematic over time.
Opensearch query : /opensearch. logs.openstack. org/_dashboards /app/discover? security_ tenant= global# /?_g=(filters: !(),refreshInte rval:(pause: !t,value: 0),time: (from:now- 7d,to:now) )&_a=(columns: !(_source) ,filters: !(('$state' :(store: appState) ,meta:( alias:! n,disabled: !f,index: '94869730- aea8-11ec- 9e6a-83741af3fd cd',key: project, negate: !f,params: (query: openstack% 2Fnova) ,type:phrase) ,query: (match_ phrase: (project: openstack% 2Fnova) ))),index: '94869730- aea8-11ec- 9e6a-83741af3fd cd',interval: auto,query: (language: kuery,query: '%22sqlite3. OperationalErro r:%20no% 20such% 20table: %20instance_ faults% 22'),sort: !())
https:/
I can read 1525 hits on the last 7 days (if my query is correct and doesn't include false positives)