Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

14 UNAVAILABLE: Request 'AppendRows' from role 'cloud-dataengine-globalrouting' throttled: Task is overloaded (memory-protection) go/tr-t #442

Closed
brantian opened this issue Apr 15, 2024 · 1 comment
Assignees
Labels
api: bigquerystorage Issues related to the googleapis/nodejs-bigquery-storage API. priority: p2 Moderately-important priority. Fix may not be included in next release. type: question Request for information or clarification. Not an issue.

Comments

@brantian
Copy link

Hello!

I've been using the Storage Write pending stream to write that successfully, but recently I started getting this error from time to time:

14 UNAVAILABLE: Request 'AppendRows' from role 'cloud-dataengine-globalrouting' throttled: Task is overloaded (memory-protection) go/tr-t

The error is emitted by the connection created by writeClient.createStreamConnection. This is what I'm doing

  const streamId = await writeClient.createWriteStream({ 
      streamType : managedwriter.PendingStream,
      destinationTable : parent
    });

  const connection = await writeClient.createStreamConnection({
        streamId,
      });

  const  writer = new managedwriter.Writer({
      connection,
      protoDescriptor : this.protoDescriptor
    });
  
  writer.appendRows({serializedRows}, offsetValue);

  await writeClient.batchCommitWriteStream({ parent : parent, writeStreams: [writeStreamId!] })

I didn't find much documentation about this specific issue. Can anyone provide guidance on what may be happening or direct me to the corresponding documentation so I can debug it?

What is puzzling me is that this error only happens intermittently. I haven't been able to reproduce it locally, but I see it happening from time to time in my application logs.

Thanks!

@brantian brantian added priority: p3 Desirable enhancement or fix. May not be included in next release. type: question Request for information or clarification. Not an issue. labels Apr 15, 2024
@product-auto-label product-auto-label bot added the api: bigquerystorage Issues related to the googleapis/nodejs-bigquery-storage API. label Apr 15, 2024
@alvarowolfx alvarowolfx self-assigned this Apr 15, 2024
@alvarowolfx alvarowolfx added priority: p2 Moderately-important priority. Fix may not be included in next release. and removed priority: p3 Desirable enhancement or fix. May not be included in next release. labels Apr 15, 2024
@alvarowolfx
Copy link
Contributor

PR #443 will address this kind of error and will either thrown an error on the PendingWrites happening and you can retry them or you can enableWriteRetries and the library will reconnect and try to send the requests again.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
api: bigquerystorage Issues related to the googleapis/nodejs-bigquery-storage API. priority: p2 Moderately-important priority. Fix may not be included in next release. type: question Request for information or clarification. Not an issue.
Projects
None yet
Development

No branches or pull requests

2 participants