1

Issue Summary

Hello, I am trying to use redash to visualize data in my VictoriaMetrics DB.
VictoriaMetrics provides Prometheus API that I use.

curl example :

curl -fs --data-urlencode 'query=hw_stat_cpu{machine_name="x8664server"}[30s]' http://192.168.1.10:8428/api/v1/query
{"status":"success","data":{"resultType":"matrix","result":[{"metric":{"__name__":"hw_stat_cpu","domain":"hw_stat","machine_ip":"192.168.1.10","machine_name":"x8664server"},"values":[[1665340803.608,"20.4"],[1665340808.53,"26"],[1665340813.514,"19.1"],[1665340818.608,"23.7"],[1665340823.618,"19.7"],[1665340828.509,"23.6"]]}]}}

But when I add hw_stat_cpu{machine_name="x8664server"}[30s] it does not show anything.

In redash logs I can see InvalidToken exception, but I am not sure that it is related to my query

worker_1    | [2022-10-09 18:44:56,083][PID:34][ERROR][ForkPoolWorker-8] Task redash.tasks.execute_query[ee0b469c-985e-457f-bde9-7fc3cac358a0] raised unexpected: InvalidToken()
worker_1    | Traceback (most recent call last):
worker_1    |   File "/usr/local/lib/python2.7/site-packages/celery/app/trace.py", line 385, in trace_task
worker_1    |     R = retval = fun(*args, **kwargs)
worker_1    |   File "/app/redash/worker.py", line 84, in __call__
worker_1    |     return TaskBase.__call__(self, *args, **kwargs)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/celery/app/trace.py", line 648, in __protected_call__
worker_1    |     return self.run(*args, **kwargs)
worker_1    |   File "/app/redash/tasks/queries.py", line 436, in execute_query
worker_1    |     scheduled_query).run()
worker_1    |   File "/app/redash/tasks/queries.py", line 339, in __init__
worker_1    |     self.data_source = self._load_data_source()
worker_1    |   File "/app/redash/tasks/queries.py", line 422, in _load_data_source
worker_1    |     return models.DataSource.query.get(self.data_source_id)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 924, in get
worker_1    |     ident, loading.load_on_pk_identity)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 1007, in _get_impl
worker_1    |     return db_load_fn(self, primary_key_identity)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 250, in load_on_pk_identity
worker_1    |     return q.one()
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2954, in one
worker_1    |     ret = self.one_or_none()
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2924, in one_or_none
worker_1    |     ret = list(self)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 98, in instances
worker_1    |     util.raise_from_cause(err)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
worker_1    |     reraise(type(exception), exception, tb=exc_tb, cause=cause)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 79, in instances
worker_1    |     rows = [proc(row) for row in fetch]
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 511, in _instance
worker_1    |     loaded_instance, populate_existing, populators)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 611, in _populate_full
worker_1    |     dict_[key] = getter(row)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py", line 1226, in process
worker_1    |     return process_value(impl_processor(value), dialect)
worker_1    |   File "/app/redash/models/types.py", line 28, in process_result_value
worker_1    |     return ConfigurationContainer.from_json(super(EncryptedConfiguration, self).process_result_value(value, dialect))
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 409, in process_result_value
worker_1    |     decrypted_value = self.engine.decrypt(value)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/types/encrypted/encrypted_type.py", line 216, in decrypt
worker_1    |     decrypted = self.fernet.decrypt(value)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/cryptography/fernet.py", line 75, in decrypt
worker_1    |     return self._decrypt_data(data, timestamp, ttl)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/cryptography/fernet.py", line 119, in _decrypt_data
worker_1    |     self._verify_signature(data)
worker_1    |   File "/usr/local/lib/python2.7/site-packages/cryptography/fernet.py", line 108, in _verify_signature
worker_1    |     raise InvalidToken
worker_1    | InvalidToken

Technical details:

2

Well, look like docker-compose repo that was used is completely outdated.
I have tried with setup/docker-compose.yml at master · getredash/setup · GitHub
ANd Prometheus requests are executed,

But now i have another error :
My request hw_stat_cpu{machine_name="x8664server"} works well, but I would like to have not a number but a graph - a history of values. when I setup request as hw_stat_cpu{machine_name="x8664server"}[6h] I have an error :

adhoc_worker_1      | [2022-10-09 19:18:04,849][PID:29][WARNING][ForkPoolWorker-3] Unexpected error while running query:
adhoc_worker_1      | Traceback (most recent call last):
adhoc_worker_1      |   File "/app/redash/tasks/queries.py", line 361, in run
adhoc_worker_1      |     data, error = query_runner.run_query(annotated_query, self.user)
adhoc_worker_1      |   File "/app/redash/query_runner/prometheus.py", line 168, in run_query
adhoc_worker_1      |     rows = get_instant_rows(metrics)
adhoc_worker_1      |   File "/app/redash/query_runner/prometheus.py", line 16, in get_instant_rows
adhoc_worker_1      |     timestamp, value = metric['value']
adhoc_worker_1      | KeyError: 'value'
adhoc_worker_1      | [2022-10-09 19:18:04,850][PID:29][INFO][ForkPoolWorker-3] task_name=redash.tasks.execute_query task_id=6c567fca-30fe-4e96-99fc-850342cd135d task=execute_query query_hash=bcee8e5e08439a970bc4d6e5effabc0a data_length=None error=['value']
adhoc_worker_1      | [2022-10-09 19:18:04,851][PID:29][ERROR][ForkPoolWorker-3] Task redash.tasks.execute_query[6c567fca-30fe-4e96-99fc-850342cd135d] raised unexpected: QueryExecutionError(u"'value'",)
adhoc_worker_1      | Traceback (most recent call last):
adhoc_worker_1      |   File "/usr/local/lib/python2.7/site-packages/celery/app/trace.py", line 385, in trace_task
adhoc_worker_1      |     R = retval = fun(*args, **kwargs)
adhoc_worker_1      |   File "/app/redash/worker.py", line 84, in __call__
adhoc_worker_1      |     return TaskBase.__call__(self, *args, **kwargs)
adhoc_worker_1      |   File "/usr/local/lib/python2.7/site-packages/celery/app/trace.py", line 648, in __protected_call__
adhoc_worker_1      |     return self.run(*args, **kwargs)
adhoc_worker_1      |   File "/app/redash/tasks/queries.py", line 436, in execute_query
adhoc_worker_1      |     scheduled_query).run()
adhoc_worker_1      |   File "/app/redash/tasks/queries.py", line 382, in run
adhoc_worker_1      |     raise result
adhoc_worker_1      | QueryExecutionError: 'value'
3

This is similar problem I faced and was hoping there is answer, prometheus range filter does not work (query{}[5m]), but using http range query works.


( node_namespace_pod_container:container_cpu_usage_seconds_total:sum_irate
{   namespace =~"(monitoring)",
    pod =~"|(.*nvidia.*)",
    container=~"(.*exporter.*)"
}
)&start=2021-12-14T00:00:00.000Z&end=2022-12-14T23:59:59.000Z&step=3600s