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

query failed: [1264] Out of range value for column 'value' at row

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.4.2, 3.4.3
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      - Ubuntu Server 16.04 LTS 64bit
      - Percona Mysql 5.7
      - Currently Zabbix Server 3.4.1 but I have also tried 3.4.2 and 3.4.3

      Description

      I am seeing a lot of the following type of messages in my zabbix server logs...

       23108:20171023:103039.244 [Z3005] query failed: [1264] Out of range value for column 'value' at row 64 [insert into history (itemid,clock,ns,value) values (68774,1508772634,730504402,0.500000),(104200,1508772634,730504402,0.000000),(77581,1508772634,730504402,0.210000),(76106,1508772634,730504402,0.270000),(70767,1508772634,730504402,0.000000),(70079,1508772634,730504402,0.130000),(26266,1508772637,247190671,0.240000),(28477,1508772637,515073470,0.000000),(35017,1508772637,515719559,70.683144),(35257,1508772637,516220749,0.000000),(30217,1508772637,516763506,0.000000),(132577,1508772637,517598144,42580570112.000000),(132457,1508772637,517832346,126553.736845),(28957,1508772637,518020672,97.876758),(35197,1508772637,519737724,2.324635),(33217,1508772637,525144835,0.000000),(70947,1508772637,839158171,0.540000),(76251,1508772637,839158171,0.500000),(77961,1508772637,839158171,0.400000),(68909,1508772637,839158171,0.500000),(77716,1508772637,839158171,0.200000),(68737,1508772638,131683938,0.000000),(130957,1508772638,131836402,99.986408),(75637,1508772638,131951001,91.493604),(86437,1508772638,132511773,0.000000),(69997,1508772638,133204174,0.001206),(69457,1508772638,134755691,0.000000),(78937,1508772638,136471530,5.390756),(71977,1508772638,136529028,53509885952.000000),(70417,1508772638,136680778,65.313304),(71197,1508772638,136847630,0.000000),(69277,1508772638,137135005,0.000689),(71917,1508772638,137551666,35369025536.000000),(131377,1508772638,138177258,99.845222),(69097,1508772638,138495954,0.000000),(72037,1508772638,138657188,56599556096.000000),(86497,1508772638,138886697,0.000000),(76177,1508772638,139311170,0.000000),(68557,1508772638,139372215,0.000000),(73597,1508772638,139964139,0.000000),(68917,1508772638,140426971,0.000000),(75697,1508772638,140492949,416169984.000000),(68377,1508772638,140867396,0.000000),(77737,1508772638,140954236,0.000000),(68197,1508772638,141465917,0.000000),(86377,1508772638,142186981,0.200000),(70297,1508772638,142760682,0.000000),(86557,1508772638,143029993,0.000000),(34704,1508772638,251066030,0.140000),(29983,1508772638,251066030,0.160000),(35018,1508772638,523180503,36.171736),(86318,1508772638,525870852,19.638000),(28958,1508772638,526136561,26.878761),(35198,1508772638,526693908,1.707499),(30218,1508772638,526948302,82.708935),(28658,1508772638,527368480,40.246177),(34958,1508772638,528152777,49197838336.000000),(132578,1508772638,531286522,22265647104.000000),(84939,1508772639,130943106,34.992028),(84999,1508772639,131000108,1.739123),(23259,1508772639,131085193,0.016943),(84039,1508772639,131130203,85.025221),(84339,1508772639,131175153,69.812952),(123938,1508772639,131329487,-1009561000000.000000);
      ]
       23104:20171023:103040.245 [Z3005] query failed: [1264] Out of range value for column 'value' at row 39 [insert into history (itemid,clock,ns,value) values (77498,1508772639,143266085,0.000000),(77378,1508772639,143725916,0.000000),(78638,1508772639,143778036,0.000000),(68378,1508772639,144722147,0.000000),(86378,1508772639,144987796,0.000000),(69098,1508772639,145242990,0.000000),(71198,1508772639,145322435,0.000000),(68918,1508772639,145738160,0.000000),(75698,1508772639,146080486,32673271808.000000),(68558,1508772639,146483931,0.000000),(68738,1508772639,146603429,12588.870313),(86558,1508772639,146858933,0.000000),(76238,1508772639,147413861,38870085632.000000),(130958,1508772639,147639386,0.000000),(69458,1508772639,148373573,31828.132207),(70418,1508772639,148647903,107005079552.000000),(68198,1508772639,149816943,0.000000),(86498,1508772639,149819756,0.000000),(77678,1508772639,150821423,0.000000),(76178,1508772639,151348624,0.000000),(86438,1508772639,151407892,0.000000),(69278,1508772639,151640945,549.437433),(70298,1508772639,152872328,0.000000),(69998,1508772639,153550834,212775.469910),(34706,1508772639,280024474,153.110000),(32745,1508772639,280024474,2.940000),(26338,1508772639,280024474,0.420000),(35019,1508772639,536604918,34.054526),(35199,1508772639,541899030,1.707499),(28419,1508772639,542286904,33.937687),(30219,1508772639,542582589,159.501227),(34959,1508772639,543079685,46755196928.000000),(28959,1508772639,543941485,18.313467),(132459,1508772639,544893590,1.700661),(33219,1508772639,546484513,0.000000),(33313,1508772639,798894001,54.900000),(23620,1508772640,131557302,99.513036),(23260,1508772640,131631856,4.003152),(123939,1508772640,131724102,-1354652000000.000000),(84340,1508772640,131755446,66.528529),(84040,1508772640,131891322,74.745767);
      ]
       23106:20171023:103041.250 [Z3005] query failed: [1264] Out of range value for column 'value' at row 62 [insert into history (itemid,clock,ns,value) values (70126,1508772639,856530866,0.540000),(71067,1508772639,856530866,0.460000),(78547,1508772639,856530866,0.660000),(126071,1508772639,856530866,0.180000),(76962,1508772639,856530866,0.120000),(68999,1508772639,856530866,0.500000),(77766,1508772639,856530866,0.280000),(70128,1508772640,11218440,0.500000),(71127,1508772640,11218440,0.480000),(76964,1508772640,11218440,0.130000),(77768,1508772640,11218440,0.300000),(78549,1508772640,11218440,0.680000),(120289,1508772640,11218440,0.780000),(69044,1508772640,11218440,0.490000),(69999,1508772640,154644593,42134.298570),(77679,1508772640,155202673,0.000299),(76239,1508772640,155375223,60.681975),(86439,1508772640,155392704,0.000000),(68379,1508772640,155769754,0.000000),(77379,1508772640,156006316,0.000000),(69099,1508772640,156339733,65057.248972),(78819,1508772640,156458690,0.012796),(70419,1508772640,156598856,37116526592.000000),(68559,1508772640,156732134,0.000000),(75699,1508772640,157620308,0.000000),(76659,1508772640,158581325,38.477064),(70299,1508772640,158907139,0.000000),(73599,1508772640,159714537,0.385385),(69459,1508772640,159764406,27757.251388),(68199,1508772640,160009697,0.000000),(86559,1508772640,160128924,0.000000),(75579,1508772640,161396124,96732946432.000000),(71199,1508772640,163397540,0.000000),(68739,1508772640,164264992,25035.427644),(69279,1508772640,165852993,1402.236626),(68919,1508772640,166235369,0.000000),(77739,1508772640,166678604,0.001457),(71259,1508772640,167243754,86729551872.000000),(86499,1508772640,167605269,0.000000),(86379,1508772640,167737194,0.498000),(78639,1508772640,167767013,0.000873),(77499,1508772640,168365342,0.001378),(130959,1508772640,168469987,0.000000),(34708,1508772640,463020585,0.490000),(34805,1508772640,463020585,0.200000),(132401,1508772640,463020585,0.420000),(34769,1508772640,463020585,0.250000),(34960,1508772640,546586038,22084284416.000000),(86320,1508772640,547587935,0.000000),(33220,1508772640,549813672,0.000000),(132460,1508772640,550405558,332251136.000000),(35200,1508772640,550673883,0.000000),(28960,1508772640,552211369,10.402923),(35320,1508772640,560275702,0.000000),(33221,1508772641,5284650,0.000000),(26681,1508772641,19274124,0.181857),(30221,1508772641,36938545,148189184.000000),(132461,1508772641,48573156,2065346560.000000),(35201,1508772641,48971276,0.304376),(28121,1508772641,50981063,63.053257),(84041,1508772641,131974927,79.724447),(123940,1508772641,132048570,-1141637000000.000000),(84341,1508772641,132360484,85.025221);
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              elvar Elvar
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: