[ 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


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)

Reply via email to