Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-12731

Out of range value for column 'value'

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • None
    • 3.4.1
    • Server (S)
    • None

      Since the upgrade to version 3.4.1 the logging often has a warning:

      11755:20170915:112040.708 [Z3005] query failed: [1264] Out of range value for column 'value' at row 43 [insert into history (itemid,clock,ns,value) values (191891,1505467237,705248587,0.002597),(191784,1505467237,705248587,0.000283),(191890,1505467237,705248587,0.000000),(191783,1505467237,705248587,0.000000),(103607,1505467238,35839641,0.000000),(103608,1505467238,35839641,0.002537),(117519,1505467239,179198598,0.000000),(117219,1505467239,181654381,1.598788),(93902,1505467240,29972589,0.000000),(192309,1505467240,37890940,245956586183.445190),(130660,1505467240,53438030,0.000000),(254035,1505467240,86149425,0.000000),(145120,1505467240,101709262,31.798956),(192563,1505467240,118452261,1.410000),(192618,1505467240,120435189,1.200000),(192591,1505467240,123530735,0.740000),(248440,1505467240,168319493,66.352028),(192249,1505467240,168417920,409927643639.075317),(144520,1505467240,172215537,9.641451),(41680,1505467240,184615785,1.875000),(325900,1505467240,196002001,0.000000),(263980,1505467240,196636320,99.995737),(112120,1505467240,196743996,0.181852),(247780,1505467240,197771877,99.724579),(247600,1505467240,207084540,99.769084),(267280,1505467240,207728182,0.720165),(248620,1505467240,208076847,87.140444),(126460,1505467240,208663575,0.000000),(107140,1505467240,211113012,40.053693),(236020,1505467240,211852269,35.408080),(222040,1505467240,215212337,0.451111),(240820,1505467240,216689295,3259392.000000),(132640,1505467240,217526235,0.000000),(114220,1505467240,217719748,0.350000),(236440,1505467240,220524261,0.012726),(239020,1505467240,221308481,72.138356),(153580,1505467240,222715671,0.000000),(241240,1505467240,225195632,99.746990),(234520,1505467240,226013773,0.000000),(246340,1505467240,231625903,99.994404),(175960,1505467240,237324810,0.404790),(164620,1505467240,238204457,3.745051),(253930,1505467240,238399062,1434746741741.647461),(263740,1505467240,239165448,0.005938),(118570,1505467240,243573152,1.720507),(133690,1505467240,244535984,14.524353),(192219,1505467240,246052865,57.896383),(154780,1505467240,246153952,0.078333),(192369,1505467240,246266640,174291821261.842560),(251080,1505467240,248911014,-0.000000),(251260,1505467240,249334511,0.000000),(251110,1505467240,251436577,0.000000),(251230,1505467240,251800637,346195797.332992),(324940,1505467240,254053906,0.000000),(251200,1505467240,254959838,34406400.000000),(251290,1505467240,255096123,12.000000),(253900,1505467240,255186018,1147797393393.318115),(106780,1505467240,259026667,0.001667),(144640,1505467240,261113137,99.987030),(144760,1505467240,262949065,56.327248),(192159,1505467240,263120114,63.984744),(112180,1505467240,323244032,17122.810126),(243820,1505467240,356741603,222.869376),(232210,1505467240,357716859,2.014005),(43180,1505467240,359705423,7.352962),(126280,1505467240,363873526,0.000000),(116757,1505467240,380504682,0.000000),(219939,1505467240,385289186,0.000000),(142840,1505467240,402509426,0.000000),(43540,1505467240,408480655,77.312277),(256960,1505467240,409521642,58.782065),(113020,1505467240,411918226,70.502173),(176080,1505467240,421681957,0.000000),(237640,1505467240,423682836,0.000000),(246400,1505467240,425646537,96.562395),(239320,1505467240,427627678,99.975976),(238780,1505467240,428511802,13.070345),(248140,1505467240,428986764,0.000000),(267460,1505467240,430719709,99.975976),(239560,1505467240,437640630,42.421448),(106840,1505467240,438558653,257.749313),(222580,1505467240,438655223,44.987912),(164440,1505467240,442815375,12.130618),(265840,1505467240,449080201,0.000000),(238960,1505467240,450655004,37.653694),(264760,1505467240,451398252,99.137115),(145000,1505467240,453257344,99.999835),(322840,1505467240,454382689,0.000000),(258040,1505467240,459569396,99.010468),(265660,1505467240,464153658,97.481689),(247840,1505467240,465293754,99.964736),(265600,1505467240,465506985,99.791378),(235480,1505467240,469421532,0.007288),(236620,1505467240,486374159,99.995707),(238480,1505467240,487324597,99.981265),(165580,1505467240,488455854,0.000000),(144430,1505467240,499503134,2.830000),(237760,1505467240,506787635,81.108093),(232900,1505467240,522845223,0.003123),(144580,1505467240,527034610,107933.000000),(218739,1505467240,527841366,0.000000),(251380,1505467240,528369661,0.000000),(238720,1505467240,529125976,99.975976),(239800,1505467240,529615147,95.789991),(114580,1505467240,535047776,0.053889),(139240,1505467240,535082190,0.135556),(192339,1505467240,535275747,100553148711.835800),(233140,1505467240,538980812,0.030625),(236500,1505467240,539062692,98.879356),(238840,1505467240,539792068,99.975976),(179620,1505467240,540520465,0.000000),(241360,1505467240,541094513,99.847412),(263620,1505467240,544523031,0.004164),(122020,1505467240,547028460,0.119658),(263380,1505467240,547743122,0.010413),(236080,1505467240,548546554,460.000000),(241120,1505467240,555757884,99.808864),(247480,1505467240,560981162,0.000000),(231940,1505467240,561684114,63.442833),(238660,1505467240,562668554,31.989765),(192279,1505467240,564887447,245956586183.445190),(251140,1505467240,567517777,0.000000),(251320,1505467240,568132425,-0.000000),(264100,1505467240,568289226,99.891114),(251170,1505467240,572303073,88603.800000),(248080,1505467240,572785436,809.000000),(251350,1505467240,573289755,-0.000000),(46660,1505467240,573406672,0.000000),(119890,1505467240,579113551,6.840323),(198280,1505467240,583485383,22.959481),(43300,1505467240,588136627,0.000000),(178480,1505467240,589756100,99.741451),(247660,1505467240,590617494,37.000000),(225880,1505467240,592389550,1.777242),(234460,1505467240,607828200,0.000000),(243940,1505467240,611694071,0.000000),(233440,1505467240,611779445,0.016675),(135400,1505467240,612189056,0.000000),(249100,1505467240,612785917,99.918079),(231640,1505467240,620698516,0.019419),(178960,1505467240,622054564,9.961581),(263320,1505467240,622812501,1.398521),(239260,1505467240,623672327,48.158264),(192189,1505467240,624477697,36.847791),(239440,1505467240,628369320,99.000931),(234040,1505467240,628716487,0.717082);

      Dit we do something ?

            Unassigned Unassigned
            hansvos Hans Vos
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: