# Google-cloud-bigquery crash

**URL:** <https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604>\
**Category:** General\
**Created:** [16 January 2024 12:51 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604 "2024-01-16T12:51:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jen](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@Jen](https://discourse.nodered.org/u/Jen)\
**Post date:** [16 January 2024 12:51 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604/1 "2024-01-16T12:51:33Z")

</div>

I am trying to use _google-cloud-bigquery_ from _node-red-contrib-google-cloud_  
But when performing "select", nod red crashes and does not produce a result. what could be the problem?  
[inject]—-[google-cloud-bigquery]—-[debug]

---

<div class="post-metadata">

**Author:** ![GogoVega](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/gogovega/32/71313_2.png) [@GogoVega](https://discourse.nodered.org/u/GogoVega)\
**Post date:** [16 January 2024 12:55 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604/2 "2024-01-16T12:55:35Z")

</div>

Maybe related to this:

> <https://github.com/GoogleCloudPlatform/node-red-contrib-google-cloud/issues/129>
>
> Hello everyone, 
> I hope my question is placed well:
> 
> I struggle trying to use… \_google-cloud-bigquery\_ from \_node-red-contrib-google-cloud\_.
> After setting up the Bigquery node I get the following error message: 
> \`" TypeError: BigQuery is not a constructor"\`
> 
> Nodered is running on a Raspberry PI, started by systemctl daemon. I have added \`Environment="GOOGLE\_CLOUD\_PROJECT=supxxx-cubxxx-000000"\` to \`/lib/systemd/system/nodered.service\`.
> 
> Can you point me in the right direction, what might be the issue here?
> 
> Thank you so much, you contribution is highly appreciated!
> 
> \<img width="833" alt="TypeError" src="https://github.com/GoogleCloudPlatform/node-red-contrib-google-cloud/assets/95969199/452acb41-ff3a-489a-af5d-f849110a89ff"\>

---

<div class="post-metadata">

**Author:** ![Jen](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@Jen](https://discourse.nodered.org/u/Jen)\
**Post date:** [16 January 2024 12:58 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604/3 "2024-01-16T12:58:39Z")

</div>

I don't get this error message "TypeError: BigQuery is not a constructor"  
I hope this is another type of error that can be fixed

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [16 January 2024 13:17 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604/4 "2024-01-16T13:17:32Z")

</div>

> [@Jen](#):
>
> I hope this is another type of error that can be fixed

Well unless you tell us the details of what happens it is impossible to help.  
Stop node-red and then start it again in a command window and make node-red crash, then post the command window output that you see. Copy/paste please, not screenshot.  
Also tell us what hardware/OS you are running on.

---

<div class="post-metadata">

**Author:** ![Jen](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@Jen](https://discourse.nodered.org/u/Jen)\
**Post date:** [16 January 2024 13:45 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604/5 "2024-01-16T13:45:46Z")

</div>

in a logs I see: 2024-01-16 15:33:34 [error] - Error: request to [https://www.googleapis.com/oauth2/v4/token](https://www.googleapis.com/oauth2/v4/token) failed, reason: connect ETIMEDOUT 172..... etc  
I running at Doker  
all I need is to select the table and get data from it in node red  
 ![632_341_1.25](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/f/0fb2693cf232152aef9b4a2f2828cd7e90edc687.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [16 March 2024 13:45 UTC](https://discourse.nodered.org/t/google-cloud-bigquery-crash/84604/6 "2024-03-16T13:45:47Z")

</div>

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