Skip to content

Conversation

@olavloite
Copy link
Collaborator

Most transactions that exceed the mutation limit for an atomic transaction will fail with the error "The transaction contains too many mutations.". However, it is also possible that the transaction fails with the more generic error message "Transaction resource limits exceeded". This error did not trigger a retry of the statement using a PDML transaction.

Fixes #4253

Most transactions that exceed the mutation limit for an atomic transaction will
fail with the error "The transaction contains too many mutations.". However, it
is also possible that the transaction fails with the more generic error message
"Transaction resource limits exceeded". This error did not trigger a retry of the
statement using a PDML transaction.

Fixes #4253
@olavloite olavloite requested review from a team as code owners December 10, 2025 15:21
@product-auto-label product-auto-label bot added size: m Pull request size is medium. api: spanner Issues related to the googleapis/java-spanner API. labels Dec 10, 2025
@gemini-code-assist
Copy link

Summary of Changes

Hello @olavloite, I'm Gemini Code Assist1! I'm currently reviewing this pull request and will post my feedback shortly. In the meantime, here's a summary to help you and other reviewers quickly get up to speed!

This pull request addresses a critical issue where transactions failing due to a generic 'Transaction resource limits exceeded' error were not being retried using Partitioned DML (PDML). By extending the TransactionMutationLimitExceededException to recognize this broader error message, the system can now correctly identify and retry these transactions, improving the robustness of operations that might exceed resource limits.

Highlights

  • Expanded Exception Recognition: The TransactionMutationLimitExceededException now correctly identifies transactions failing with the generic 'Transaction resource limits exceeded' error message, in addition to the more specific 'The transaction contains too many mutations' error.
  • Enabled PDML Retries: This change ensures that transactions encountering the 'Transaction resource limits exceeded' error will now correctly trigger a retry using Partitioned DML (PDML), improving resilience.
  • Parameterized Tests: Existing test cases for PDML retry logic have been updated to be parameterized, allowing them to validate the behavior for both the specific mutation limit exceeded error and the newly recognized generic resource limit exceeded error.
Using Gemini Code Assist

The full guide for Gemini Code Assist can be found on our documentation page, here are some quick tips.

Invoking Gemini

You can request assistance from Gemini at any point by creating a comment using either /gemini <command> or @gemini-code-assist <command>. Below is a summary of the supported commands on the current page.

Feature Command Description
Code Review /gemini review Performs a code review for the current pull request in its current state.
Pull Request Summary /gemini summary Provides a summary of the current pull request in its current state.
Comment @gemini-code-assist Responds in comments when explicitly tagged, both in pull request comments and review comments.
Help /gemini help Displays a list of available commands.

Customization

To customize Gemini Code Assist for GitHub experience, repository maintainers can create a configuration file and/or provide a custom code review style guide (such as PEP-8 for Python) by creating and adding files to a .gemini/ folder in the base of the repository. Detailed instructions can be found here.

Limitations & Feedback

Gemini Code Assist may make mistakes. Please leave feedback on any instances where its feedback is incorrect or counter productive. You can react with 👍 and 👎 on @gemini-code-assist comments. If you're interested in giving your feedback about your experience with Gemini Code Assist for Github and other Google products, sign up here.

You can also get AI-powered code generation, chat, as well as code reviews directly in the IDE at no cost with the Gemini Code Assist IDE Extension.

Footnotes

  1. Review the Privacy Notices, Generative AI Prohibited Use Policy, Terms of Service, and learn how to configure Gemini Code Assist in GitHub here. Gemini can make mistakes, so double check it and use code with caution.

Copy link

@gemini-code-assist gemini-code-assist bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Code Review

This pull request introduces a new error message, "Transaction resource limits exceeded," to the TransactionMutationLimitExceededException class, allowing it to recognize this message in addition to the existing "The transaction contains too many mutations" message. The isTransactionMutationLimitException methods were updated to check for both error strings. Correspondingly, the RetryDmlAsPartitionedDmlMockServerTest test suite was refactored to be parameterized, enabling existing tests to run against both the original mutation limit exceeded exception and the newly recognized resource limit exceeded exception, ensuring consistent behavior for both scenarios.

@olavloite olavloite added the automerge Merge the pull request once unit tests and other checks pass. label Dec 10, 2025
@gcf-merge-on-green gcf-merge-on-green bot merged commit c735d42 into main Dec 10, 2025
40 of 42 checks passed
@gcf-merge-on-green gcf-merge-on-green bot removed the automerge Merge the pull request once unit tests and other checks pass. label Dec 10, 2025
@gcf-merge-on-green gcf-merge-on-green bot deleted the issue-4253 branch December 10, 2025 16:00
diegomarquezp pushed a commit that referenced this pull request Dec 10, 2025
Most transactions that exceed the mutation limit for an atomic transaction will fail with the error "The transaction contains too many mutations.". However, it is also possible that the transaction fails with the more generic error message "Transaction resource limits exceeded". This error did not trigger a retry of the statement using a PDML transaction.

Fixes #4253
blakeli0 pushed a commit that referenced this pull request Dec 17, 2025
* chore: add release-please config for protobuf-4.x (#4249)

* fix: Refine connecitivity metrics to capture RPCs with no response he… (#4252)

* fix: Refine connecitivity metrics to capture RPCs with no response headers

* test fix

* fix: retry as PDML dit not retry Resource limit exceeded (#4258)

Most transactions that exceed the mutation limit for an atomic transaction will fail with the error "The transaction contains too many mutations.". However, it is also possible that the transaction fails with the more generic error message "Transaction resource limits exceeded". This error did not trigger a retry of the statement using a PDML transaction.

Fixes #4253

* deps: update dependency com.google.cloud:sdk-platform-java-config to v3.54.2 (#4261)

* deps: update googleapis/sdk-platform-java action to v2.64.2 (#4262)

* feat: include RequestID in requests and errors (#4263)

- Send a RequestID to Spanner for each request
- Make sure that the attempt number of the RequestID is increased
  if the RPC is retried.
- Include the RequestID in every error that is thrown due to an error
  that is returned by Spanner.

* feat: make grpc-gcp default enabled (#4239)

This PR enables the gRPC-GCP channel pool extension by default for Cloud Spanner Java client.

**What's Changing for Customers**

**Before this change**

- gRPC-GCP extension was disabled by default
- Default number of channels: 4
- Channel pooling was handled by GAX

**After this change**

- gRPC-GCP extension is enabled by default
- Default number of channels: 8
- Channel pooling is handled by gRPC-GCP extension

**Benefits of gRPC-GCP**

- **Improved resilience:** When a network connection fails on a particular channel, operations can be automatically retried on a different gRPC channel
- **Better channel management:** gRPC-GCP provides more sophisticated channel affinity and load balancing

**How to Disable gRPC-GCP (Switch Back to GAX Channel Pool)**

If you need to disable gRPC-GCP and use the previous GAX channel pooling behavior, use the `disableGrpcGcpExtension()` method:
```
SpannerOptions options = SpannerOptions.newBuilder()
    .setProjectId("my-project")
    .disableGrpcGcpExtension()
    .build();
```

When disabled, the default number of channels reverts to 4 (the previous default).

**When You Might Want to Disable gRPC-GCP**

- **Maintaining previous behavior:** If you want to keep the exact same behavior as before this change (GAX channel pool with 4 default channels).
- **Troubleshooting**: If you experience any unexpected behavior, disabling gRPC-GCP can help isolate whether the issue is related to the channel pooling mechanism.

* chore(main): release 6.104.1-SNAPSHOT (#4248)

:robot: I have created a release *beep* *boop*
---


### Updating meta-information for bleeding-edge SNAPSHOT release.

---
This PR was generated with [Release Please](https://togithub.com/googleapis/release-please). See [documentation](https://togithub.com/googleapis/release-please#release-please).

* feat: add support of dynamic channel pooling (#4265)

* feat: add support of dynamic channel pooling

* set initial pool size to 0 make dynamic channel pool work

* chore: generate libraries at Tue Dec 16 06:00:50 UTC 2025

* bump grpc-gcp-java version

* fix test

* incorporate suggestions

* chore: generate libraries at Tue Dec 16 09:56:45 UTC 2025

* make dynamic channel pool default disabled

* add verifySameChannelId back and fix partitionDML test

* support setting GcpChannelPoolOptions directly

---------

Co-authored-by: cloud-java-bot <[email protected]>

* chore(main): release 6.105.0 (#4267)

* chore(main): release 6.105.0

* chore: generate libraries at Tue Dec 16 17:46:24 UTC 2025

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: cloud-java-bot <[email protected]>

* chore(main): release 6.105.1-SNAPSHOT (#4268)

:robot: I have created a release *beep* *boop*
---


### Updating meta-information for bleeding-edge SNAPSHOT release.

---
This PR was generated with [Release Please](https://togithub.com/googleapis/release-please). See [documentation](https://togithub.com/googleapis/release-please#release-please).

* chore: update manifest

---------

Co-authored-by: surbhigarg92 <[email protected]>
Co-authored-by: Knut Olav Løite <[email protected]>
Co-authored-by: Mend Renovate <[email protected]>
Co-authored-by: rahul2393 <[email protected]>
Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: cloud-java-bot <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

api: spanner Issues related to the googleapis/java-spanner API. size: m Pull request size is medium.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Fallback to PDML should also retry on "Transaction resource limits exceeded" errors

2 participants