Error query: Mysqli statement execute error : Out of range value for column 'time_transfer' at row 1

Support & Bugs
1

I didn’t realize this was occurring until I started to get an error on the Visits Log (which I think is unrelated) but in my error log I keep seeing the above message with large values for time_transfer.
ie.

Error in Matomo (tracker): Error query: Mysqli statement execute error : Out of range value for column ‘time_transfer’ at row 1 In query: INSERT INTO log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, pageview_position, time_spent_ref_action, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => 45567, 1 =?$%’, 3 => 131240, 4 => 47630, 5 => 47629, 6 => ‘2021-01-24 18:56:18’, 7 => ‘lfC3a1’, 8 => 5, 9 => 913, 10 => 1214, 11 => 32, 12 => 1611073871470, 13 => 47629, )

I recently upgraded to 4.1.0 and was looking at doing the point release upgrade, but am now concerned I have something wrong in the database.

Is there a schema available I could check to verify my tables were upgraded correctly at the last update?

2

Hi,

This sounds a lot like
https://github.com/matomo-org/matomo/issues/17035

It seems like one tracking request had one of the performance metrics set to 1611073871470 ms (=18K Years) which is too large to store in this column.

3

Ok, following the chain of that post I ended up opening an issue with the log tracker.

Except I’m not importing any logs. So maybe that was a mistake?