You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2021/07/09 00:30:00 UTC

[jira] [Work logged] (BEAM-12504) SpannerIO Read SessionNotFoundException for long-running pipline

     [ https://issues.apache.org/jira/browse/BEAM-12504?focusedWorklogId=620807&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-620807 ]

ASF GitHub Bot logged work on BEAM-12504:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 09/Jul/21 00:29
            Start Date: 09/Jul/21 00:29
    Worklog Time Spent: 10m 
      Work Description: aaltay commented on pull request #15048:
URL: https://github.com/apache/beam/pull/15048#issuecomment-876827158


   @baeminbo - Pablo will be out of office until August. I do not know the level of urgency on this PR. If it can wait, that is fine. Otherwise, do you who else might review this?
   
   /cc @chamikaramj 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

    Worklog Id:     (was: 620807)
    Time Spent: 1h  (was: 50m)

> SpannerIO Read SessionNotFoundException for long-running pipline
> ----------------------------------------------------------------
>
>                 Key: BEAM-12504
>                 URL: https://issues.apache.org/jira/browse/BEAM-12504
>             Project: Beam
>          Issue Type: Bug
>          Components: io-java-gcp
>            Reporter: Minbo Bae
>            Priority: P2
>         Attachments: spanner_error.png, spanner_graph.png
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> [SpannderIO|https://github.com/apache/beam/blob/v2.30.0/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/spanner/SpannerIO.java#L328]  creates a transaction session with [CreateTransaction|https://github.com/apache/beam/blob/v2.30.0/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/spanner/SpannerIO.java#L747] at the beginning of pipeline run. If the pipeline takes a long time to run SpannerIO.ReadAll like the following, the session can be [cleaned up|https://cloud.google.com/spanner/docs/sessions#keep_an_idle_session_alive] by Spanner service. The Spanner read step fails with  error {{com.google.cloud.spanner.SessionNotFoundException: NOT_FOUND: com.google.api.gax.rpc.NotFoundException: io.grpc.StatusRuntimeException: NOT_FOUND: Session not found: projects/<PROJECT>/instances/<INSTANCE>/databases/<DATABASE>/sessions/<SESSION_ID>}}
> {code:java}
>  PCollection<ReadOperation> queries = pipeline
>   .apply(Create.of((Void)null))
>  .apply(ParDo.of( ... )); // long running. for example more than 2 hours
> queries
>  .apply(SpanerIO.readAll().withSpannerConfig(...))
>   .apply(ParDo.of( ... ));
> {code}
> See the attached files for my job graph and errors in Dataflow.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)