-
Problem report
-
Resolution: Fixed
-
Critical
-
5.0.27, 6.0.8, 6.2.2
-
AlmaLinux 8 / 6.2
RHEL 7 / LTS 5.0
-
Sprint 91 (Aug 2022), Sprint 92 (Sep 2022), Sprint 93 (Oct 2022), Sprint 94 (Nov 2022), Sprint 95 (Dec 2022), Sprint 96 (Jan 2023)
-
1
Steps to reproduce:
- use history.get during housekeeping
Housekeeper pid = 30542, blocking query pid = 50761
postgres=# SELECT pid, state, age(clock_timestamp(), query_start), usename, CHAR_LENGTH(query) AS q_len, LEFT(query, 100) AS query, wait_event FROM pg_stat_activity WHERE state NOT LIKE '%idle%' AND query NOT LIKE '%pg_stat_activity%' ORDER BY query_start desc; pid | state | age | usename | q_len | query | wait_event -------+--------+-----------------+------------+-------+------------------------------------------------------------------------------------------------------+--------------- 13254 | active | | replicator | 0 | | WalSenderMain 10238 | active | | replicator | 0 | | WalSenderMain 26591 | active | 00:00:00.001697 | zbx_srv | 201 | select ia.itemappid,ia.itemid,ia.applicationid from items_applications ia,item_discovery id1,item_di | ClientRead 59636 | active | 00:00:00.117613 | zbx_web | 1023 | SELECT t.triggerid,t.priority FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i | 47140 | active | 00:03:59.593897 | zbx_web | 1023 | SELECT h.* FROM history_uint h WHERE (h.itemid IN (2024184,2024185,2024186,2024187,2024188,2024189,2 | 57556 | active | 00:07:08.536077 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_3_4993_chunk | VacuumDelay 30542 | active | 00:09:21.233662 | zbx_srv | 67 | select drop_chunks(relation=>'history_uint',older_than=>1657564056) | transactionid 50761 | active | 00:22:29.368164 | zbx_web | 1023 | SELECT h.* FROM history_uint h WHERE (h.itemid IN (8459089,8459090,8459091,8459092,8459093,8459094,8 | 3787 | active | 01:47:16.019165 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_2_4964_chunk | VacuumDelay 8011 | active | 02:25:37.916994 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_1_4920_chunk | VacuumDelay 34891 | active | 07:57:30.776173 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_1_4911_chunk | VacuumDelay 40776 | active | 09:17:55.10078 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_2_4910_chunk | VacuumDelay 53885 | active | 09:57:07.006026 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_2_5045_chunk | VacuumDelay 14900 | active | 15:46:53.2887 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_1_4943_chunk | VacuumDelay 46554 | active | 18:34:56.87878 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_1_4955_chunk | VacuumDelay 34569 | active | 19:36:29.701993 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_2_4942_chunk | VacuumDelay 59737 | active | 20:57:48.142187 | | 68 | autovacuum: VACUUM ANALYZE _timescaledb_internal._hyper_2_4902_chunk | VacuumDelay
blocking query
postgres=# SELECT activity.pid,
activity.usename,
LEFT(activity.query,50),
blocking.pid AS blocking_id,
LEFT(blocking.query,50) AS blocking_query
FROM pg_stat_activity AS activity
JOIN pg_stat_activity AS blocking ON blocking.pid = ANY(pg_blocking_pids(activity.pid));
pid | usename | left | blocking_id | blocking_query
-------+---------+----------------------------------------------------+-------------+----------------------------------------------------
30542 | zbx_srv | select drop_chunks(relation=>'history_uint',older_ | 50761 | SELECT h.* FROM history_uint h WHERE (h.itemid IN
Small query example without ANY chunk/partition/history period pruning:
SELECT h.* FROM history_uint h WHERE (h.itemid IN (3002048,3002049,3002050,3002051,3002052,3002055,3002056,3002059,3002060,3002061,3151851,3151852,3151853,3151854,3151855,3151856,3151857,3151858,3151859,3151860,3151861,3151862,3151863,3151864,3151865,3151870,3151873,3151874,3151875,3151876,3151877,3151878,3151881,3151882,3151883,3151884,3151885,3151886,3151887,3151888,3151889,3151890,3151891,3151892,3151893,3151894,3151895,3151896,3151897,3151898,3151899,3151900,3151901,3151902,3151903,3151904,3151905,3151906,3151907,3151908,3151909,3151910,3151911,3151912,3151913,3151914,3151915,3151916,3151917,3151918,3151919,3151920,3151921,3151922,3151923,3151924,3151925,3151926,3151927,3151928,3151929,3151930,3151931,3151932,3151933,3151934,3151935,3151936,3151937,3151938,3151939,3151940,3151941,3151942,3151943,3151944,3151945,3151946,3151947,3151948,3151949,3151950,3151951,3151952,3151953,3151954,3151955,3151956,3151957,3151958,3151959,3151960,3151961,3151962,3151963,3151964,3151965,3151966,3151967,3151968,3151969,3151970,3151971,3151972,3151973,3151974,3151975,3151976,3151977,3151978,3151979,3151980,3151981,3151982,3151983,3151984,3151985,3151986,3151987,3151988,3151989,3151990,3151991,3151992,3151993,3151994,3151995,3151996,3151997,3151998,3151999,3152000,3152001,3152002,3152003,3152004,3152005,3152006,3152007,3152008,3152009,3152010,3152011,3152012,3152013,3152014,3152015,3152016,3152017,3152018,3152019,3152020,3152021,3152022,3152023,3152024,3152025,3152026,3152027,3152028,3152029,3152030,3152031,3152032,3152033,3152034,3152035,3152036,3152037,3152038,3152039,3152040,3152041,3152042,3152043,3152044,3152045,3152046,3152047,3152048,3152049,3152052,3152053,3152054,3152055,3152056,3152057,3152058,3152059,3152060,3152061,3152062,3152063,3152064,3152065,3152066,3152067,3152068,3152069,3152070,3152071,3152072,3152073,3152074,3152075,3152076,3152077,3152078,3152079,3152080,3152081,3152082,3152083,3152084,3152085,3152086,3152087,3152088,3152089,3152090,3152091,3152092,3152093,3152094,3152095,3152096,3152097,3152098,3152099,3152100,3152101,3152102,3152103,3152104,3152105,3152106,3152107,3152108,3152109,3152110,3152111,3152112,3152113,3152114,3152115,3152116,3152117,3152118,3152119,3152120,3152121,3152122,3152123,3152124,3152125,3152126,3152127,3152128,3152129,3152130,3152131,3152132,3152133,3152134,3152135,3152136,3152137,3152138,3152139,3152140,3152141,3152142,3152143,3152144,3152145,3152146,3152147,3152148,3152149,3152150,3152151,3152152,3152153,3152154,3152155,3152156,3152157,3152158,3152159,3152160,3152161,3152162,3152163,3152164,3152165,3152166,3152167,3152168,3152169,3152170,3152171,3152172,3152173,3152174,3152175,3152176,3152177,3152178,3152179,3152180,3152181,3152182,3152183,3152184,3152185,3152186,3152187,3152188,3152189,3152190,3152191,3152192,3152193,3152194,3152195,3152196,3152197,3152198,3152199,3152200,3152201,3152202,3152203,3152204,3152205,3152206,3152207,3152208,3152209,3152210,3152211,3152212,3152213,3152214,3152215,3152216,3152217,3152218,3152219,3152220,3152223,3152224,3152225,3152226,3152227,3152228,3152229,3152230,3152231,3152232,3152233,3152234,3152235,3152236,3152237,3152238,3152239,3152240,3152241,3152242,3152243,3152244,3152245,3152246,3152247,3152248,3152249,3152250,3152251,3152252,3152253,3152254,3152255,3152256,3152257,3152258,3152259,3152260,3152261,3152262,3152263,3152264,3152265,3152266,3152267,3152268,3152269,3152270,3152271,3152272,3152273,3152274,3152275,3152276,3152277,3152278,3152279,3152280,3152281,3152282,3152283,3152284,3152285,3152286,3152287,3152288,3152289,3152290,3152291,3152292,3152293,3152294,3152295,3152296,3152297,3152298,3152299,3152300,3152301,3152302,3152303,3152304,3152305,3152306,3152307,3152308,3152309,3152310,3152311,3152312,3152313,3152314,3152315,3152316,3152317,3152318,3152319,3152320,3152321,3152322,3152323,3152324,3152325,3152326,3152327,3152328,3152329,3152330,3152331,3152332,3152333,3152334,3152335,3152336,3152337,3152338,3152339,3152340,3152341,3152342,3152343,3152344,3152345,3152346,3152347,3152348,3152349,3152350,3152351,3152352,3152353,3152354,3152355,3152356,3152357,3152358,3152359,3152360,3152361,3152362,3152363,3152364,3152365,3152366,3152367,3152368,3152369,3152370,3152371,3152372,3152373,3152374,3152375,3152376,3152377,3152378,3152379,3152380,3152381,3152382,3152383,3152384,3152385,3152386,3152387,3152388,3152389,3152390,3152391,3152394,3152395,3152396,3152397,3152398,3152399,3152400,3152401,3152402,3152403,3152404,3152405,3152406,3152407,3152408,3152409,3152410,3152411,3152412,3152413,3152414,3152415,3152416,3152417,3152418,3152419,3152420,3152421,3152422,3152423,3152424,3152425,3152426,3152427,3152428,3152429,3152430,3152431,3152432,3152433,3152434,3152435,3152436,3152437,3152438,3152439,3152440,3152441,3152442,3152443,3152444,3152445,3152446,3152447,3152448,3152449,3152450,3152451,3152452,3152453,3152454,3152455,3152456,3152457,3152458,3152459,3152460,3152461,3152462,3152463,3152464,3152465,3152466,3152467,3152468,3152469,3152470,3152471,3152472,3152473,3152474,3152475,3152476,3152477,3152478,3152479,3152480,3152481,3152482,3152483,3152484,3152485,3152486,3152487,3152488,3152489,3152490,3152491,3152492,3152493,3152494,3152495,3152496,3152497,3152498,3152499,3152500,3152501,3152502,3152503,3152504,3152505,3152506,3152507,3152508,3152509,3152510,3152511,3152512,3152513,3152514,3152515,3152516,3152517,3152518,3152519,3152520,3152521,3152522,3152523,3152524,3152525,3152526,3152527,3152528,3152529,3152530,3152531,3152532,3152533,3152534,3152535,3152536,3152537,3152538,3152539,3152540,3152541,3152542,3152543,3152544,3152545,3152546,3152547,3152548,3152549,3152550,3152551,3152552,3152553,3152554,3152555,3152556,3152557,3152558,3152559,3152560,3152561,3152562,3152565,3152566,3152567,3152568,3152569,3152570,3152571,3152572,3152573,3152574,3152575,3152576,3152577,3152578,3152579,3152580,3152581,3152582,3152583,3152584,3152585,3152586,3152587,3152588,3152589,3152590,3152591,3152592,3152593,3152594,3152595,3152596,3152597,3152598,3152599,3152600,3152601,3152602,3152603,3152604,3152605,3152606,3152607,3152608,3152609,3152610,3152611,3152612,3152613,3152614,3152615,3152616,3152617,3152618,3152619,3152620,3152621,3152622,3152623,3152624,3152625,3152626,3152627,3152628,3152629,3152630,3152631,3152632,3152633,3152634,3152635,3152636,3152637,3152638,3152639,3152640,3152641,3152642,3152643,3152644,3152645,3152646,3152647,3152648,3152649,3152650,3152651,3152652,3152653,3152654,3152655,3152656,3152657,3152658,3152659,3152660,3152661,3152662,3152663,3152664,3152665,3152666,3152667,3152668,3152669,3152670,3152671,3152672,3152673,3152674,3152675,3152676,3152677,3152678,3152679,3152680,3152681,3152682,3152683,3152684,3152685,3152686,3152687,3152688,3152689,3152690,3152691,3152692,3152693,3152694,3152695,3152696,3152697,3152698,3152699,3152700,3152701,3152702,3152703,3152704,3152705,3152706,3152707,3152708,3152709,3152710,3152711,3152712,3152713,3152714,3152715,3152716,3152717,3152718,3152719,3152720,3152721,3152722,3152723,3152724,3152725,3152726,3152727,3152728,3152729,3152730,3152731,3152732,3152733,3152736,3152737,3152738,3152739,3152740,3152741,3152742,3152743,3152744,3152745,3152746,3152747,3152748,3152749,3152750,3152751,3152752,3152753,3152754,3152755,3152756,3152757,3152758,3152759,3152760,3152761,3152762,3152763,3152764,3152765,3152766,3152767,3152768,3152769,3152770,3152771,3152772,3152773,3152774,3152775,3152776,3152777,3152778,3152779,3152780,3152781,3152782,3152783,3152784,3152785,3152786,3152787,3152788,3152789,3152790,3152791,3152792,3152793,3152794,3152795,3152796,3152797,3152798,3152799,3152800,3152801,3152802,3152803,3152804,3152805,3152806,3152807,3152808) OR h.itemid IN (3152809,3152810,3152811,3152812,3152813,3152814,3152815,3152816,3152817,3152818,3152819,3152820,3152821,3152822,3152823,3152824,3152825,3152826,3152827,3152828,3152829,3152830,3152831,3152832,3152833,3152834,3152835,3152836,3152837,3152838,3152839,3152840,3152841,3152842,3152843,3152844,3152845,3152846,3152847,3152848,3152849,3152850,3152851,3152852,3152853,3152854,3152855,3152856,3152857,3152858,3152859,3152860,3152861,3152862,3152863,3152864,3152865,3152866,3152867,3152868,3152869,3152870,3152871,3152872,3152873,3152874,3152875,3152876,3152877,3152878,3152879,3152880,3152881,3152882,3152883,3152884,3152885,3152886,3152887,3152888,3152889,3152890,3152891,3152892,3152893,3152894,3152895,3152896,3152897,3152898,3152899,3152900,3152901,3152902,3152903,3152904,3152907,3152908,3152909,3152910,3152911,3152912,3152913,3152914,3152915,3152916,3152917,3152918,3152919,3152920,3152921,3152922,3152923,3152924,3152925,3152926,3152927,3152928,3152929,3152930,3152931,3152932,3152933,3152934,3152935,3152936,3152937,3152938,3152939,3152940,3152941,3152942,3152943,3152944,3152945,3152946,3152947,3152948,3152949,3152950,3152951,3152952,3152953,3152954,3152955,3152956,3152957,3152958,3152959,3152960,3152961,3152962,3152963,3152964,3152965,3152966,3152967,3152968,3152969,3152970,3152971,3152972,3152973,3152974,3152975,3152976,3152977,3152978,3152979,3152980,3152981,3152982,3152983,3152984,3152985,3152986,3152987,3152988,3152989,3152990,3152991,3152992,3152993,3152994,3152995,3152996,3152997,3152998,3152999,3153000,3153001,3153002,3153003,3153004,3153005,3153006,3153007,3153008,3153009,3153010,3153011,3153012,3153013,3153014,3153015,3153016,3153017,3153018,3153019,3153020,3153021,3153022,3153023,3153024,3153025,3153026,3153027,3153028,3153029,3153030,3153031,3153032,3153033,3153034,3153035,3153036,3153037,3153038,3153039,3153040,3153041,3153042,3153043,3153044,3153045,3153046,3153047,3153048,3153049,3153050,3153051,3153052,3153053,3153054,3153055,3153056,3153057,3153058,3153059,3153060,3153061,3153062,3153063,3153064,3153065,3153066,3153067,3153068,3153069,3153070,3153071,3153072,3153073,3153074,3153075,3153078,3153079,3153080,3153081,3153082,3153083,3153084,3153085,3153086,3153087,3153088,3153089,3153090,3153091,3153092,3153093,3153094,3153095,3153096,3153097,3153098,3153099,3153100,3153101,3153102,3153103,3153104,3153105,3153106,3153107,3153108,3153109,3153110,3153111,3153112,3153113,3153114,3153115,3153116,3153117,3153118,3153119,3153120,3153121,3153122,3153123,3153124,3153125,3153126,3153127,3153128,3153129,3153130,3153131,3153132,3153133,3153134,3153135,3153136,3153137,3153138,3153139,3153140,3153141,3153142,3153143,3153144,3153145,3153146,3153147,3153148,3153149,3153150,3153151,3153152,3153153,3153154,3153155,3153156,3153157,3153158,3153159,3153160,3153161,3153162,3153163,3153164,3153165,3153166,3153167,3153168,3153169,3153170,3153171,3153172,3153173,3153174,3153175,3153176,3153177,3153178,3153179,3153180,3153181,3153182,3153183,3153184,3153185,3153186,3153187,3153188,3153189,3153190,3153191,3153192,3153193,3153194,3153195,3153196,3153197,3153198,3153199,3153200,3153201,3153202,3153203,3153204,3153205,3153206,3153207,3153208,3153209,3153210,3153211,3153212,3153213,3153214,3153215,3153216,3153217,3153218,3153219,3153220,3153221,3153222,3153223,3153224,3153225,3153226,3153227,3153228,3153229,3153230,3153231,3153232,3153233,3153234,3153235,3153236,3153237,3153238,3153239,3153240,3153241,3153242,3153243,3153244,3153245,3153246,3153249,3153250,3153251,3153252,3153253,3153254,3153255,3153256,3153257,3153258,3153259,3153260,3153261,3153262,3153263,3153264,3153265,3153266,3153267,3153268,3153269,3153270,3153271,3153272,3153273,3153274,3153275,3153276,3153277,3153278,3153279,3153280,3153281,3153282,3153283,3153284,3153285,3153286,3153287,3153288,3153289,3153290,3153291,3153292,3153293,3153294,3153295,3153296,3153297,3153298,3153299,3153300,3153301,3153302,3153303,3153304,3153305,3153306,3153307,3153308,3153309,3153310,3153311,3153312,3153313,3153314,3153315,3153316,3153317,3153318,3153319,3153320,3153321,3153322,3153323,3153324,3153325,3153326,3153327,3153328,3153329,3153330,3153331,3153332,3153333,3153334,3153335,3153336,3153337,3153338,3153339,3153340,3153341,3153342,3153343,3153344,3153345,3153346,3153347,3153348,3153349,3153350,3153351,3153352,3153353,3153354,3153355,3153356,3153357,3153358,3153359,3153360,3153361,3153362,3153363,3153364,3153365,3153366,3153367,3153368,3153369,3153370,3153371,3153372,3153373,3153374,3153375,3153376,3153377,3153378,3153379,3153380,3153381,3153382,3153383,3153384,3153385,3153386,3153387,3153388,3153389,3153390,3153391,3153392,3153393,3153394,3153395,3153396,3153397,3153398,3153399,3153400,3153401,3153402,3153403,3153404,3153405,3153406,3153407,3153408,3153409,3153410,3153411,3153412,3153413,3153414,3153415,3153416,3153417,3153420,3153421,3153422,3153423,3153424,3153425,3153426,3153427,3153428,3153429,3153430,3153431,3153432,3153433,3153434,3153435,3153436,3153437,3153438,3153439,3153440,3153441,3153442,3153443,3153444,3153445,3153446,3153447,3153448,3153449,3153450,3153451,3153452,3153453,3153454,3153455,3153456,3153457,3153458,3153459,3153460,3153461,3153462,3153463,3153464,3153465,3153466,3153467,3153468,3153469,3153470,3153471,3153472,3153473,3153474,3153475,3153476,3153477,3153478,3153479,3153480,3153481,3153482,3153483,3153484,3153485,3153486,3153487,3153488,3153489,3153490,3153491,3153492,3153493,3153494,3153495,3153496,3153497,3153498,3153499,3153500,3153501,3153502,3153503,3153504,3153505,3153506,3153507,3153508,3153509,3153510,3153511,3153512,3153513,3153514,3153515,3153516,3153517,3153518,3153519,3153520,3153521,3153522,3153523,3153524,3153525,3153526,3153527,3153528,3153529,3153530,3153531,3153532,3153533,3153534,3153535,3153536,3153537,3153538,3153539,3153540,3153541,3153542,3153543,3153544,3153545,3153546,3153547,3153548,3153549,3153550,3153551,3153552,3153553,3153554,3153555,3153556,3153557,3153558,3153559,3153560,3153561,3153562,3153563,3153564,3153565,3153566,3153567,3153568,3153569,3153570,3153571,3153572,3153573,3153574,3153575,3153576,3153577,3153578,3153579,3153580,3153581,3153582,3153583,3153584,3153585,3153586,3153587,3153588,3153591,3153592,3153593,3153594,3153595,3153596,3153597,3153598,3153599,3153600,3153601,3153602,3153603,3153604,3153605,3153606,3153607,3153608,3153609,3153610,3153611,3153612,3153613,3153614,3153615,3153616,3153617,3153618,3153619,3153620,3153621,3153622,3153623,3153624,3153625,3153626,3153627,3153628,3153629,3153630,3153631,3153632,3153633,3153634,3153635,3153636,3153637,3153638,3153639,3153640,3153641,3153642,3153643,3153644,3153645,3153646,3153647,3153648,3153649,3153650,3153651,3153652,3153653,3153654,3153655,3153656,3153657,3153658,3153659,3153660,3153661,3153662,3153663,3153664,3153665,3153666,3153667,3153668,3153669,3153670,3153671,3153672,3153673,3153674,3153675,3153676,3153677,3153678,3153679,3153680,3153681,3153682,3153683,3153684,3153685,3153686,3153687,3153688,3153689,3153690,3153691,3153692,3153693,3153694,3153695,3153696,3153697,3153698,3153699,3153700,3153701,3153702,3153703,3153704,3153705,3153706,3153707,3153708,3153709,3153710,3153711,3153712,3153713,3153714,3153715,3153716,3153717,3153718,3153719,3153720,3153721,3153722,3153723,3153724,3153725,3153726,3153727,3153728,3153729,3153730,3153731,3153732,3153733,3153734,3153735,3153736,3153737,3153738,3153739,3153740,3153741,3153742,3153743,3153744,3153745,3153746,3153747,3153748,3153749,3153750,3153751,3153752,3153753,3154210,3154211,3154212,3154213,3154214,3154215,3154216,3154217,3154218,3154219,3154220,3154221,3154222,3154223,3154224) OR h.itemid IN (3154225,3154226,3154227,3154228,3154229,3154230,3154231,3154232,3154233,3154234,3154235,3154236,3154237,3154238,3154239,3154240,3154241,3154242,3154243,3154244,3154245,3154246,3154247,3154248,3154249,3154250,3154252,3154253,3154254,3154255,3154256,3154257,3154258,3154259,3154260,3154261,3154262,3154263,3154264,3154265,3154266,3154267,3154268,3154269,3154270,3154271,3154272,3154273,3154274,3154275,3154276,3154277,3154278,3154279,3154280,3154281,3154282,3154283,3154284,3154285,3154286,3154287,3154288,3154289,3154290,3154291,3154292,3154293,3154294,3154295,3154297,3154298,3154299,3154300,3154301,3154302,3154303,3154304,3154305,3154306,3154307,3154308,3154309,3154310,3154311,3154312,3154313,3154314,3154315,3154316,3154317,3154318,3154319,3154320,3154321,3154322,3154323,3154324,3154325,3154326,3154327,3154328,3154329,3154330,3154331,3154332,3154333,3154334,3154335,3154336,3154337,3154338,3154339,3154340,3154342,3154343,3154344,3154390,3154391,3154392,3154393,3154394,3154395,3154396,3154397,3154398,3154399,3154400,3154401,3154402,3154403,3154404,3154405,3154406,3154407,3154408,3154409,3154410,3154411,3154412,3154413,3154414,3154415,3154416,3154417,3154418,3154419,3154420,3154421,3154422,3154423,3154424,3154425,3154426,3154427,3154428,3154429,3154430,3154432,3154433,3154434,3154480,3154481,3154482,3154483,3154484,3154485,3154486,3154487,3154488,3154489,3154490,3154491,3154492,3154493,3154494,3154495,3154496,3154497,3154498,3154499,3154500,3154501,3154502,3154503,3154504,3154505,3154506,3154507,3154508,3154509,3154510,3154511,3154512,3154513,3154514,3154515,3154516,3154517,3154518,3154519,3154520,3154522,3154523,3154524,4739462,4872655,4872656,4872657,4872658,4872659,4996254,4996255,4996256,4996257,4996258,5170665,5170666,5170667,5170668,5170669,5241407,6050871,6050872,6050873,6050874,6050875,6050876,6050877,6050878,6050879,6050880,6854883,8889060,8889061,8889062,8889063,8889064,9387105,9387106,9387107,9387108,9387109,9387110,9387111,9387112,9387113,9387114,9387115,9387116,9387117,9387118,9387119,9387120,9387121,9387122,9387123,9387124,9387125,9387126,9573514,9573515,9573516,9573517,9573518,9573519,9573520,9573521,9573522,9573523,9573524,9573525,9573526,9573527,9573528,9573529,9573530,9573531,9573532,9573533,9573534,9573535,9573536,9573537,9573538,9573539,9573540,9573541,9573542,9573543,9573544,9573545,9573546,9573547,9573548,9573549,9573550,9573551,9573552,9573553,9573554,9573555,9573556,9573557,9573558,9573559,9573560,9573561,9573562,9573563,9573564,9573565,9573566,9573567,9573568,9573569,9573570,9573571,9573572,9573573,9573574,9573575,9573576,9573577,9573578,9573579,9573580,9573581,9573582,9573583,9573584,9573585,9573586,9573587,9573588,9573589,9573590,9573591,9573592,9573593,9573594,9573595,9573596,9573597,9573598,9573599,9573600,9573601,9573602,9573603,9573604,9573605,9573606,9573607,9573608,9573609,9573610,9573611,9573612,9573613,9573614,9573615,9573616,9573617,9573618,9573619,9573620,9573621,9573622,9573623,9573624,9573625,9573626,9573627,9573628,9573629,9573630,9573631,9573632,9573633,9573634,9573635,9573636,9573637,9573638,9573639,9573640,9573641,9573642,9573643,9573644,9573645,9573646,9573647,9573648,9573649,9573650,9573651,9573652,9573653,9573654,9573655,9573656,9573657,9573658,9573659,9573660,9573661,9573662,9573663,9573664,9573665,9573666,9573667,9573668,9573669,9573670,9573671,9573672,9573673,9573674,9573675,9573676,9573677,9573678,9573679,9573680,9573681,9573682,9573683,9573684))
Expected:
Do not get data for the period outside of the history or trends period, otherwise it will lock drop_chunk execution because this data will be removed and has no meaning for the export by history.get API.
