"Connection lost" on a specific dashboard tab

Dashboard
1

I currently have three dashboard tabs.
One of them draws a chart with 4 lines using data from MySQL.
When I switch to this tab using the dashboard hamburger menu:

  • A mesage pops up "Connection lost" for a second.
  • Same message once more.
  • ~ 5sec delay.
  • The graph is displayed.

I'm struggling to identify the cause.

It seems not to be a problem in the SQL query or drawing the graph. If I add a button to repeat the query it redraws the graph instantly.

The graph has 4 lins, each with about 40 points.

Every time I deploy this flow the Mysql node status is "not yet connected" & I get this error on the node-red-dashboard node (ui_base)

Untitled 1
Untitled 11200×132 16.2 KB

A snippet of the Node-red log:

6 Dec 17:26:40 - [info] Starting flows
6 Dec 17:26:40 - [error] [ui_base:70ea48b6c7ce5aec] TypeError: Cannot read properties of undefined (reading 'replace')
6 Dec 17:26:40 - [info] [cronplus:8ee84f7bf63b1027] createTask - [truncated irrelevant]
6 Dec 17:26:40 - [info] Started flows
6 Dec 17:26:40 - [error] [mysql:b558a28a8cbd9b7e] Database not connected
6 Dec 17:26:40 - [info] [mqtt-broker:754230cc.99c44] Connected to broker: mqtt://localhost:1883

Can anyone suggest where to look for the cause?

2

Every time I deploy this flow the Mysql node status is "not yet connected"

Because your inject node will inject immediately after deploy before the mysql node is actually connected ?

3

Yes, that probably explains that, so it's not a symptom of the actual problem.

4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.