search

basicrum / dashboard

0 stars 0 forks source link

Few panels get an error in the CWW dashboard #18

Open ceckoslab opened 9 months ago

ceckoslab commented 9 months ago

This issue happens when we get a very specific data in the CH database.

The error is: "TypeError: Cannot read properties of undefined (reading 'map') "

Core-Web-Vitals-Custom-Dashboards-Grafana

This is the data

RUM events:

"event_date","hostname","created_at","event_type","browser_name","browser_version","ua_vnd","ua_plt","device_type","device_manufacturer","operating_system","operating_system_version","user_agent","next_hop_protocol","visibility_state","session_id","session_length","url","connect_duration","dns_duration","first_byte_duration","redirect_duration","redirects_count","first_contentful_paint","first_paint","cumulative_layout_shift","first_input_delay","largest_contentful_paint","geo_country_code","geo_city_name","page_id","data_saver_on","boomerang_version","screen_width","screen_height","dom_res","dom_doms","mem_total","mem_limit","mem_used","mem_lsln","mem_ssln","mem_lssz","scr_bpp","scr_orn","cpu_cnc","dom_ln","dom_sz","dom_ck","dom_img","dom_img_uniq","dom_script","dom_iframe","dom_link","dom_link_css","mob_dl","mob_rtt","mob_etype"
"2024-01-24","www.example.com","2024-01-24 22:28:32","visit_page","Chrome","120.0.0","Google%20Inc.","Linux%20x86_64","desktop",\N,"Linux",\N,"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36","h2","visible","8f761221-e36e-4a8b-91d0-bbd9cd6a4bbd-s4fxuj",1,"https://www.example.com/",0,0,2280,0,0,2730,2730,\N,\N,2730,"","","q7ompqto",\N,"1.737.60",1920,1080,37,1,11471320,4294705152,9987268,1,0,548,"24%2F24","0%2Flandscape-primary",8,503,44904,163,34,30,7,0,9,2,\N,100,"4g"
"2024-01-24","www.example.com","2024-01-24 22:28:32","visit_page","Chrome","120.0.0","Google%20Inc.","Linux%20x86_64","desktop",\N,"Linux",\N,"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36","h2","visible","8f761221-e36e-4a8b-91d0-bbd9cd6a4bbd-s4fxuj",1,"https://www.example.com/",0,0,2280,0,0,2730,2730,\N,\N,2730,"","","q7ompqto",\N,"1.737.60",1920,1080,37,1,11471320,4294705152,9987268,1,0,548,"24%2F24","0%2Flandscape-primary",8,503,44904,163,34,30,7,0,9,2,72,100,"4g"

Hostnames:

"hostname","updated_at"
"www.example.com","2024-01-24 22:28:32.000"
"calendar.perfplanet.com","2024-01-24 22:13:55.000"
ceckoslab commented 9 months ago

These queries were very helpful to get the data out from ClickHouse:

select * from webperf_rum_hostnames FORMAT CSVWithNames
select * from webperf_rum_events FORMAT CSVWithNames