Mysql Query BUG

pkg/tsdb/mysql/mysql.go:251

return fmt.Errorf(“Invalid type for column time, must be of type timestamp or unix timestamp, got: %T %v”, columnValue, columnValue)
#####################################
when i upgraded v5.1.0-pre1 from v5.0.0-pre1,
the Graph column named time or time_sec got type error – *int32,
which was nothing wrong in the old version with the same datas.

could you pls help me to solve this problem , thx a lot!

Hi,

Could you please include your query and table schema? Are you using time series or table format of your query?

Thanks

Marcus

Thanks for your attention,

the Query like this :
SELECT ltime as time_sec,

and the Type of “ltime” is int:
±------±---------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±------±---------±-----±----±--------±------+
| ltime | int(11) | NO | PRI | 0 | |

Graph:
Format as “Time series”

Best Wishes
V

Thanks will investigate. Just to.make sure you’re selecting more columns than time when you get this error?

Marcus

Sure,
Just like this and nothing special:

SELECT
time_column as time_sec,
value_column as value,
series_name_column as metric

KeyPoint:
there is nothing wrong in the old version(v5.0.0-pre1) with the same datas.

Hi,

Confirmed this as bug. I’ve created an issue. Hopefully resolved soon in nightly builds and in v5.1 stable release later on.

Marcus