Error in Matomo (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 167

glatzenarsch · April 19, 2021, 2:50pm

I have this errors in my matomo-error.log and none of logs were imported this night with import log script. Thanks in advance.

Matomo version: 3.13.6
MySQL version: 10.3.27-MariaDB-0+deb10u1
PHP version: 7.3.27-1~deb10u1

Error in Matomo (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column ‘idlink_va’ at row 1 In query: INSERT INTO piwik_log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, interaction_position, time_spent_ref_action, idaction_name, custom_float) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => ‘352605084’, 1 => 20, 2 => ’ \x01\x16H\xbf\xc6\x92\xe0’, 3 => ‘138078270’, 4 => ‘136866289’, 5 => ‘1’, 6 => ‘2021-04-19 14:12:36’, 7 => ‘IKrsLo’, 8 => 3, 9 => 28, 10 => ‘9218124’, 11 => ‘529’, ),

Lukas · April 26, 2021, 12:40pm

Hi,

This issue is tracked here:

github.com/matomo-org/matomo

don't try to insert unrealistically high values for time_transfer and other performance metrics

opened 10:28AM - 31 Dec 20 UTC

closed 08:10PM - 23 Jun 21 UTC

Findus23

Bug Help wanted not-in-changelog

see https://forum.matomo.org/t/512m-of-memory-limit-is-it-too-little/40047/5 …No page takes 50 years to load, so I guess Matomo should not try to insert invalid values. > [28-Dec-2020 07:09:09 UTC] Error in Matomo (tracker): Error query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'time_transfer' at row 1 In query: INSERT INTO matomo2_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_dom_processing, time_network, time_server, time_transfer, idaction_name) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => '620729', 1 => 23, 2 => '&� ��V� ', 3 => '122626', 4 => '122626', 5 => '122625', 6 => '2020-12-28 07:09:09', 7 => 'qDEDCT', 8 => 3, 9 => 185, 10 => 874, 11 => 2180, 12 => 283, 13 => 1608938301263, 14 => '122625', ) Then again it would be interesting to know where they come from.

Matomo tracks the page load time, but for whatever weird reason, there is a low amount of users which report an absurdly long pageload time (138078270ms =38 hours in your case) which causes Matomo to throw that error.