node-red-mysql caused node-red to fail to start

[ca-anderson]

Which node are you reporting an issue on?

node-red-mysql

What are the steps to reproduce?

install latest version (1.0) and run node-red-start.

What happens?

Get below output and node-red restarts

Welcome to Node-RED
===================
16 Jan 17:26:28 - [info] Node-RED version: v2.1.4
16 Jan 17:26:29 - [info] Node.js  version: v16.13.0
16 Jan 17:26:29 - [info] Linux 5.10.63+ arm LE
16 Jan 17:26:40 - [info] Loading palette nodes
#
# Fatal error in , line 0
# Fatal error in , line 0
# Liftoff bailout should not happen. Cause: Armv6 not supported
#FailureMessage Object: 0xb59fcf50

What do you expect to happen?

Node-red should stay running. mysql v0.3.0 installs and runs ok.

Please tell us about your environment:

• [v2.1.4 ] Node-RED version:
• [v16.13.0 ] node.js version:
• [8.1.0 ] npm version:
• [ Pi 3 bullseye] Platform/OS:
• [ NA] Browser:

[hardillb]

• How did you install the node-red-node-mysql?
• How did you install Node-RED?
• Exactly what hardware are you running on? A Pi 3 should not be ARMv6
• Does Node-RED start if you remove the MySQL node? (You can run npm remove node-red-node-mysql in the ~/.node-red directory assuming the answer to the first question is via the palette manager)

Can you create a fresh directory (not in the ~/.node-red) directory and run npm install node-red-node-mysql and add the whole output to the issue.

Also the node-red-node-mysql node now uses the mysql2 not mysql from the v1.0.0 release

[ca-anderson]

Hi In answer to your questions. I installed from the command line when in directory .node-red. I installed using the script ./update-nodejs-and-nodered --node16 Sorry the board I am using is in fact a Pi B+ V1.2 I have removed mysql and node-red starts ok. Reinstalled failure returns. Installing version 0.3 does work but will not select more that one column from a table, though * (select all) works. What is the most recent version of mysql that works with the ARM6 processor?

Colin

Colin A Anderson Electronics + IT Workshop Room H064 Life & Health Sciences University of Ulster Coleraine BT52 1SA Tel (44)2870 124528 e-mail @.@.>

From: Ben Hardill @.> Sent: 16 January 2022 19:05 To: node-red/node-red-nodes @.> Cc: Anderson, Colin @.>; Author @.> Subject: Re: [node-red/node-red-nodes] node-red-mysql caused node-red to fail to start (Issue #878)

You don't often get email from @.*** Learn why this is importanthttp://aka.ms/LearnAboutSenderIdentification [EXTERNAL EMAIL]

• How did you install the node-red-node-mysql?
• How did you install Node-RED
• Exactly what hardware are you running on? A Pi 3 should not be ARMv6
• Does Node-RED start if you remove the MySQL node? (You can run npm remove node-red-node-mysql in the ~/.node-red directory assuming the answer to the first question is via the palette manager)

Can you create a fresh directory (not in the ~/.node-red) directory and run npm install node-red-node-mysql and add the whole output to the issue.

Reply to this email directly, view it on GitHubhttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnode-red%2Fnode-red-nodes%2Fissues%2F878%23issuecomment-1013933360&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ujMrbOg5KrbSq5kskKNK7jcRdppXyOvuJYw%2FbVaQ194%3D&reserved=0, or unsubscribehttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAGVI5BNIJZPAQD3TYYXT2ZLUWMJF7ANCNFSM5MDCJQCA&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=CaQJcZxW4DGQ7is9pINieI2CK%2F74xTwugjW5miW49gg%3D&reserved=0. Triage notifications on the go with GitHub Mobile for iOShttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.apple.com%2Fapp%2Fapple-store%2Fid1477376905%3Fct%3Dnotification-email%26mt%3D8%26pt%3D524675&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=vy0e5ZK2Jgrf4ppoF9yMtGFsHNq92SksneQeDg0zHPk%3D&reserved=0 or Androidhttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.github.android%26referrer%3Dutm_campaign%253Dnotification-email%2526utm_medium%253Demail%2526utm_source%253Dgithub&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=%2BavwUAZGb45pceRbBqNDPAUoKBcmtLF5rYQYfm7XUWo%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***>

This email and any attachments are confidential and intended solely for the use of the addressee and may contain information which is covered by legal, professional or other privilege. If you have received this email in error please notify the system manager at @.*** and delete this email immediately. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Ulster University. The University's computer systems may be monitored and communications carried out on them may be recorded to secure the effective operation of the system and for other lawful purposes. Ulster University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of a separate attachment, the text of email is not intended to form a binding contract. Correspondence to and from the University may be subject to requests for disclosure by 3rd parties under relevant legislation. The Ulster University was founded by Royal Charter in 1984 and is registered with company number RC000726 and VAT registered number GB672390524.The primary contact address for Ulster University in Northern Ireland is Cromore Road, Coleraine, Co. Londonderry BT52 1SA

[ca-anderson]

Sorry forgot to add sperate install files.

Colin

Colin A Anderson Electronics + IT Workshop Room H064 Life & Health Sciences University of Ulster Coleraine BT52 1SA Tel (44)2870 124528 e-mail @.@.>

From: Ben Hardill @.> Sent: 16 January 2022 19:05 To: node-red/node-red-nodes @.> Cc: Anderson, Colin @.>; Author @.> Subject: Re: [node-red/node-red-nodes] node-red-mysql caused node-red to fail to start (Issue #878)

You don't often get email from @.*** Learn why this is importanthttp://aka.ms/LearnAboutSenderIdentification [EXTERNAL EMAIL]

• How did you install the node-red-node-mysql?
• How did you install Node-RED
• Exactly what hardware are you running on? A Pi 3 should not be ARMv6
• Does Node-RED start if you remove the MySQL node? (You can run npm remove node-red-node-mysql in the ~/.node-red directory assuming the answer to the first question is via the palette manager)

Can you create a fresh directory (not in the ~/.node-red) directory and run npm install node-red-node-mysql and add the whole output to the issue.

Reply to this email directly, view it on GitHubhttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnode-red%2Fnode-red-nodes%2Fissues%2F878%23issuecomment-1013933360&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ujMrbOg5KrbSq5kskKNK7jcRdppXyOvuJYw%2FbVaQ194%3D&reserved=0, or unsubscribehttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAGVI5BNIJZPAQD3TYYXT2ZLUWMJF7ANCNFSM5MDCJQCA&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=CaQJcZxW4DGQ7is9pINieI2CK%2F74xTwugjW5miW49gg%3D&reserved=0. Triage notifications on the go with GitHub Mobile for iOShttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.apple.com%2Fapp%2Fapple-store%2Fid1477376905%3Fct%3Dnotification-email%26mt%3D8%26pt%3D524675&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=vy0e5ZK2Jgrf4ppoF9yMtGFsHNq92SksneQeDg0zHPk%3D&reserved=0 or Androidhttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.github.android%26referrer%3Dutm_campaign%253Dnotification-email%2526utm_medium%253Demail%2526utm_source%253Dgithub&data=04%7C01%7Cca.anderson%40ulster.ac.uk%7C998de85a3acb4ec58dff08d9d9231aa2%7C6f0b94874fa842a8aeb4bf2e2c22d4e8%7C0%7C0%7C637779567054578060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=%2BavwUAZGb45pceRbBqNDPAUoKBcmtLF5rYQYfm7XUWo%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***>

This email and any attachments are confidential and intended solely for the use of the addressee and may contain information which is covered by legal, professional or other privilege. If you have received this email in error please notify the system manager at @.*** and delete this email immediately. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Ulster University. The University's computer systems may be monitored and communications carried out on them may be recorded to secure the effective operation of the system and for other lawful purposes. Ulster University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of a separate attachment, the text of email is not intended to form a binding contract. Correspondence to and from the University may be subject to requests for disclosure by 3rd parties under relevant legislation. The Ulster University was founded by Royal Charter in 1984 and is registered with company number RC000726 and VAT registered number GB672390524.The primary contact address for Ulster University in Northern Ireland is Cromore Road, Coleraine, Co. Londonderry BT52 1SA

[hardillb]

Attachments are stripped when replying to issues comments by email, you need to either include the text inline in the email or add it via the web interface

[ca-anderson]

This is the installed node-re-node-mysql into another directory mysql.zip

[hardillb]

Sorry, I wasn't clear, I wanted the output of the npm command to the terminal, not the installed files.

But having been through the node_modules dir there doesn't appear to be any native components in any of the dependent modules so it's not the cause.

A google for the error implies that there may be some changes in the NodeJS 16 builds recently that won't work on ARMv6 using WebAssembly

NodeJS don't formally support the NodeJS ARMv6 builds any more (but the do still build them, hence how the script manages to install them on Pi Zero and the old original Pi B)

• Try starting Node-RED with the --no-expose-wasm passed to the NodeJS runtime. I think you should be able to just add this to the node-red command line
• Try with NodeJS 14 rather than 16
• Use a newer Pi with at least an ARMv7 core (anything newer than what you have and not a Pi Zero or Pi Zero W [The new Pi Zero 2 W is based on a Pi 3 core])

[hardillb]

re - https://github.com/nodejs/node/issues/41402 and long is a dependency of mysql2

[hardillb]

The linked issue implies that a newer build of NodeJS v16 might contain a fix for this.

[ca-anderson]

Below is what is printed when installed to new directory

added 16 packages, and audited 17 packages in 24s

found 0 vulnerabilities