I am using the latest stable version of Grafana with MySQL as a data source. I have a Table panel on my dashboard that is supposed to be filled by a very simple query:
SELECT url AS metric, COUNT(*) AS value FROM downloads WHERE $__timeFilter(timestamp) GROUP BY metric ORDER BY value DESC LIMIT 10
It works just fine from the MySQL console (if I expand the
$__timeFilter macro, of course). However, Grafana reports a “Database type BLOB not supported” error. What is this supposed to mean and how to fix it? It can’t be anything wrong with the database, since other, much more complex queries (querying from other tables in the same database, though) work just fine.
If it’s of any help, the structure of the table
downloads is like this:
CREATE TABLE IF NOT EXISTS `downloads` ( `id` int(11) NOT NULL auto_increment, `session` CHAR(32) NOT NULL, `timestamp` datetime NOT NULL, `url` text NOT NULL, `outfile` text NOT NULL, `shasum` varchar(64) default NULL, PRIMARY KEY (`id`), KEY `session` (`session`,`timestamp`) );