See
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/14/display/redirect?page=changes>
Changes:
[noreply] Bump github.com/aws/aws-sdk-go-v2/feature/s3/manager in /sdks (#24915)
[noreply] update Beam GCP BOM (#24929)
[noreply] [#24931][Go SDK] Make element checkpoints independant (#24932)
[noreply] Update Kafka watermark based on policy when records poll empty
(#24205)
[noreply] Grafana dashboard - Github actions postcommit workflows mapping
(#24176)
[noreply] Shard Python PreCommit (#24866)
------------------------------------------
[...truncated 769.65 KB...]
INFO: 2023-01-09T22:35:19.350Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup into BeamIOSourceRel_118/Read
Input BQ Rows/PassThroughThenCleanup/Create(CleanupOperation)/Read(CreateSource)
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.454Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map
into BeamIOSourceRel_118/Read Input BQ
Rows/TriggerIdCreation/Read(CreateSource)
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.525Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.631Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.726Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Write
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.820Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Read
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.884Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:19.952Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:20.010Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:20.077Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Write
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:20.174Z: Fusing consumer BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/ParDo(IsmRecordForSingularValuePerWindow)
into BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Read
Jan 09, 2023 10:35:20 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:20.945Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/Read(BigQueryTableSource)+BeamIOSourceRel_118/Read Input BQ
Rows/PassThroughThenCleanup/ParMultiDo(Identity)+BeamIOSourceRel_118/ParDo(RowMonitor)+BeamIOSourceRel_118/Read
Input BQ
Rows/PassThroughThenCleanup/View.AsIterable/ParDo(ToIsmRecordForGlobalWindow)+BeamCalcRel_227/ParMultiDo(Calc)+ParDo(TimeMonitor)
Jan 09, 2023 10:35:22 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:21.021Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Create
Jan 09, 2023 10:35:22 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:21.096Z: Starting 5 workers in us-central1-f...
Jan 09, 2023 10:35:22 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:21.496Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Create
Jan 09, 2023 10:35:22 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:21.808Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/TriggerIdCreation/Read(CreateSource)+BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Write
Jan 09, 2023 10:35:29 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:35:27.569Z: Your project already contains 100
Dataflow-created metric descriptors, so new user metrics of the form
custom.googleapis.com/* will not be created. However, all user metrics are also
available in the metric dataflow.googleapis.com/job/user_counter. If you rely
on the custom metrics, you can delete old / unused metric descriptors. See
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.list
and
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.delete
Jan 09, 2023 10:36:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:36:03.851Z: Autoscaling: Raised the number of workers
to 5 based on the rate of progress in the currently running stage(s).
Jan 09, 2023 10:36:37 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:36:36.548Z: Workers have started successfully.
Jan 09, 2023 10:37:01 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:36:58.549Z: All workers have finished the startup
processes and began to receive work requests.
Jan 09, 2023 10:37:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:03.604Z: Finished operation BeamIOSourceRel_118/Read
Input BQ Rows/TriggerIdCreation/Read(CreateSource)+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Write
Jan 09, 2023 10:37:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:03.734Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Close
Jan 09, 2023 10:37:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:03.818Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Close
Jan 09, 2023 10:37:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:03.982Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Create
Jan 09, 2023 10:37:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:04.164Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Create
Jan 09, 2023 10:37:06 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:04.481Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Read+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Write
Jan 09, 2023 10:37:06 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:06.040Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Read+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Write
Jan 09, 2023 10:37:06 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:06.216Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Close
Jan 09, 2023 10:37:06 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:06.300Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Close
Jan 09, 2023 10:37:06 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:06.443Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Read+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/ParDo(IsmRecordForSingularValuePerWindow)
Jan 09, 2023 10:37:12 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:11.890Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Read+BeamIOSourceRel_118/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/ParDo(IsmRecordForSingularValuePerWindow)
Jan 09, 2023 10:37:14 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:12.245Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/CreateDataflowView
Jan 09, 2023 10:37:14 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:37:12.372Z: Finished operation BeamIOSourceRel_118/Read
Input BQ Rows/ViewId/Combine.GloballyAsSingletonView/CreateDataflowView
Jan 09, 2023 10:38:31 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:30.221Z: Finished operation BeamIOSourceRel_118/Read
Input BQ Rows/Read(BigQueryTableSource)+BeamIOSourceRel_118/Read Input BQ
Rows/PassThroughThenCleanup/ParMultiDo(Identity)+BeamIOSourceRel_118/ParDo(RowMonitor)+BeamIOSourceRel_118/Read
Input BQ
Rows/PassThroughThenCleanup/View.AsIterable/ParDo(ToIsmRecordForGlobalWindow)+BeamCalcRel_227/ParMultiDo(Calc)+ParDo(TimeMonitor)
Jan 09, 2023 10:38:31 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:30.493Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/PassThroughThenCleanup/View.AsIterable/CreateDataflowView
Jan 09, 2023 10:38:31 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:30.625Z: Finished operation BeamIOSourceRel_118/Read
Input BQ Rows/PassThroughThenCleanup/View.AsIterable/CreateDataflowView
Jan 09, 2023 10:38:31 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:30.960Z: Executing operation
BeamIOSourceRel_118/Read Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Read(CreateSource)+BeamIOSourceRel_118/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup
Jan 09, 2023 10:38:34 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:33.749Z: Finished operation BeamIOSourceRel_118/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Read(CreateSource)+BeamIOSourceRel_118/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup
Jan 09, 2023 10:38:34 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:34.131Z: Cleaning up.
Jan 09, 2023 10:38:36 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:38:34.269Z: Stopping worker pool...
Jan 09, 2023 10:41:27 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:41:26.091Z: Autoscaling: Resized worker pool from 5 to
0.
Jan 09, 2023 10:41:27 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:41:26.264Z: Worker pool stopped.
Jan 09, 2023 10:41:32 PM
org.apache.beam.runners.dataflow.DataflowPipelineJob logTerminalState
INFO: Job 2023-01-09_14_35_03-13883606568168914394 finished with status
DONE.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDefaultMethod STANDARD_OUT
Load test results for test (ID): e30851e9-b930-40cd-b436-bfaec4e87dd0 and
timestamp: 2023-01-09T22:41:32.293000000Z:
Metric: Value:
fields_read 3.08350476E8
read_time 61.327
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDefaultMethod STANDARD_ERROR
Jan 09, 2023 10:41:32 PM
org.apache.beam.sdk.testutils.publishing.InfluxDBPublisher publishWithCheck
WARNING: Missing setting InfluxDB database. Metrics won't be published.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_ERROR
Jan 09, 2023 10:41:32 PM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery method is set to: DIRECT_READ
Jan 09, 2023 10:41:32 PM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery writeDisposition is set to: WRITE_EMPTY
Jan 09, 2023 10:41:32 PM
org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `HACKER_NEWS`.`by` AS `author`, `HACKER_NEWS`.`type`,
`HACKER_NEWS`.`title`, `HACKER_NEWS`.`score`
FROM `beam`.`HACKER_NEWS` AS `HACKER_NEWS`
WHERE (`HACKER_NEWS`.`type` = 'story' OR `HACKER_NEWS`.`type` = 'job') AND
`HACKER_NEWS`.`score` > 2
Jan 09, 2023 10:41:32 PM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery method is set to: DIRECT_READ
Jan 09, 2023 10:41:32 PM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery writeDisposition is set to: WRITE_EMPTY
Jan 09, 2023 10:41:33 PM
org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(author=[$4], type=[$8], title=[$0], score=[$5])
LogicalFilter(condition=[AND(OR(=($8, 'story'), =($8, 'job')), >($5, 2))])
BeamIOSourceRel(table=[[beam, HACKER_NEWS]])
Jan 09, 2023 10:41:34 PM
org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamPushDownIOSourceRel(table=[[beam, HACKER_NEWS]], usedFields=[[by, type,
title, score]], BigQueryFilter=[[supported{OR(=($8, 'story'), =($8,
'job'))>($5, 2)}, unsupported{}]])
Jan 09, 2023 10:41:34 PM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable
buildIOReader
INFO: Pushing down the following filter: (type = 'story' OR type = 'job')
AND score > 2
Jan 09, 2023 10:41:34 PM org.apache.beam.runners.dataflow.DataflowRunner
validateSdkContainerImageOptions
WARNING: Prefer --sdkContainerImage over deprecated legacy option
--workerHarnessContainerImage.
Jan 09, 2023 10:41:34 PM
org.apache.beam.runners.dataflow.options.DataflowPipelineOptions$StagingLocationFactory
create
INFO: No stagingLocation provided, falling back to gcpTempLocation
Jan 09, 2023 10:41:35 PM org.apache.beam.runners.dataflow.DataflowRunner
fromOptions
INFO: PipelineOptions.filesToStage was not specified. Defaulting to files
from the classpath: will stage 399 files. Enable logging at DEBUG level to see
which files will be staged.
Jan 09, 2023 10:41:35 PM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Executing pipeline on the Dataflow Service, which will have billing
implications related to Google Compute Engine usage and other Google Cloud
Services.
Jan 09, 2023 10:41:41 PM org.apache.beam.runners.dataflow.util.PackageUtil
stageClasspathElements
INFO: Uploading 400 files from PipelineOptions.filesToStage to staging
location to prepare for execution.
Jan 09, 2023 10:41:41 PM
org.apache.beam.runners.dataflow.util.PackageUtil$PackageAttributes
forFileToStage
INFO: Staging custom dataflow-worker.jar as
beam-runners-google-cloud-dataflow-java-legacy-worker-2.45.0-SNAPSHOT-sw7I5NxGbae6Qla1KmOxciLMncGVaoFNAfP5Wr6g_WM.jar
Jan 09, 2023 10:41:42 PM org.apache.beam.runners.dataflow.util.PackageUtil
stageClasspathElements
INFO: Staging files complete: 400 files cached, 0 files newly uploaded in 0
seconds
Jan 09, 2023 10:41:42 PM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Staging portable pipeline proto to
gs://temp-storage-for-perf-tests/loadtests/staging/
Jan 09, 2023 10:41:42 PM org.apache.beam.runners.dataflow.util.PackageUtil
tryStagePackage
INFO: Uploading <155976 bytes, hash
2f6cf6acd71bd6b5bb5ed2ee7c937a848d4dd485170e142a7adb0cf0c8d07121> to
gs://temp-storage-for-perf-tests/loadtests/staging/pipeline-L2z2rNcb1rW7XtLufJN6hI1N1IUXDhQqetsM8MjQcSE.pb
Jan 09, 2023 10:41:48 PM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding BeamPushDownIOSourceRel_272/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource) as step s1
Jan 09, 2023 10:41:48 PM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding BeamPushDownIOSourceRel_272/ParDo(RowMonitor) as step s2
Jan 09, 2023 10:41:48 PM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding ParDo(TimeMonitor) as step s3
Jan 09, 2023 10:41:48 PM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Dataflow SDK version: 2.45.0-SNAPSHOT
Jan 09, 2023 10:41:49 PM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: To access the Dataflow monitoring console, please navigate to
https://console.cloud.google.com/dataflow/jobs/us-central1/2023-01-09_14_41_48-13311180379341806558?project=apache-beam-testing
Jan 09, 2023 10:41:49 PM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Submitted job: 2023-01-09_14_41_48-13311180379341806558
Jan 09, 2023 10:41:49 PM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: To cancel the job using the 'gcloud' tool, run:
> gcloud dataflow jobs --project=apache-beam-testing cancel
--region=us-central1 2023-01-09_14_41_48-13311180379341806558
Jan 09, 2023 10:41:51 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
WARNING: 2023-01-09T22:41:49.677Z: The requested max number of workers (5)
is ignored as autoscaling is explicitly disabled (autoscalingAlgorithm=NONE).
Jan 09, 2023 10:41:54 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
WARNING: 2023-01-09T22:41:52.150Z: The workflow name is not a valid Cloud
Label. Labels applied to Cloud resources (such as GCE Instances) for monitoring
will be labeled with this modified job name:
bigqueryiopushdownit0readusingdirectreadmethodpushdown-jen-frdf. For the best
monitoring experience, please name your job with a valid Cloud Label. For
details, see:
https://cloud.google.com/compute/docs/labeling-resources#restrictions
Jan 09, 2023 10:42:04 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:03.445Z: Worker configuration: e2-standard-2 in
us-central1-f.
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:04.803Z: Expanding CoGroupByKey operations into
optimizable parts.
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:04.909Z: Expanding GroupByKey operations into
optimizable parts.
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:05.010Z: Lifting ValueCombiningMappingFns into
MergeBucketsMappingFns
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:05.254Z: Fusing adjacent ParDo, Read, Write, and
Flatten operations
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:05.391Z: Fusing consumer
BeamPushDownIOSourceRel_272/ParDo(RowMonitor) into
BeamPushDownIOSourceRel_272/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:05.487Z: Fusing consumer ParDo(TimeMonitor) into
BeamPushDownIOSourceRel_272/ParDo(RowMonitor)
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:06.602Z: Executing operation
BeamPushDownIOSourceRel_272/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)+BeamPushDownIOSourceRel_272/ParDo(RowMonitor)+ParDo(TimeMonitor)
Jan 09, 2023 10:42:07 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:06.817Z: Starting 5 workers in us-central1-f...
Jan 09, 2023 10:42:22 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:42:20.120Z: Your project already contains 100
Dataflow-created metric descriptors, so new user metrics of the form
custom.googleapis.com/* will not be created. However, all user metrics are also
available in the metric dataflow.googleapis.com/job/user_counter. If you rely
on the custom metrics, you can delete old / unused metric descriptors. See
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.list
and
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.delete
Jan 09, 2023 10:45:11 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:45:10.115Z: Autoscaling: Raised the number of workers
to 4 based on the rate of progress in the currently running stage(s).
Jan 09, 2023 10:45:11 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:45:10.277Z: Autoscaling: Resized worker pool to 4,
though goal was 5. This could be a quota issue.
Jan 09, 2023 10:45:21 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:45:19.874Z: Autoscaling: Raised the number of workers
to 5 based on the rate of progress in the currently running stage(s).
Jan 09, 2023 10:45:52 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:45:51.587Z: Workers have started successfully.
Jan 09, 2023 10:46:13 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:46:13.241Z: All workers have finished the startup
processes and began to receive work requests.
Jan 09, 2023 10:46:31 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:46:31.245Z: Finished operation
BeamPushDownIOSourceRel_272/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)+BeamPushDownIOSourceRel_272/ParDo(RowMonitor)+ParDo(TimeMonitor)
Jan 09, 2023 10:46:34 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:46:31.689Z: Cleaning up.
Jan 09, 2023 10:46:34 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:46:31.950Z: Stopping worker pool...
Jan 09, 2023 10:48:52 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:48:50.610Z: Autoscaling: Resized worker pool from 5 to
0.
Jan 09, 2023 10:48:52 PM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-01-09T22:48:50.761Z: Worker pool stopped.
Jan 09, 2023 10:48:59 PM
org.apache.beam.runners.dataflow.DataflowPipelineJob logTerminalState
INFO: Job 2023-01-09_14_41_48-13311180379341806558 finished with status
DONE.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_OUT
Load test results for test (ID): b9463f78-3266-40f1-aad3-ce7bde36da1b and
timestamp: 2023-01-09T22:48:59.564000000Z:
Metric: Value:
fields_read 4375276.0
read_time 8.716
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_ERROR
Jan 09, 2023 10:48:59 PM
org.apache.beam.sdk.testutils.publishing.InfluxDBPublisher publishWithCheck
WARNING: Missing setting InfluxDB database. Metrics won't be published.
Gradle Test Executor 2 finished executing tests.
> Task :sdks:java:extensions:sql:perf-tests:integrationTest FAILED
3 tests completed, 1 failed
Finished generating test XML results (0.064 secs) into:
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/ws/src/sdks/java/extensions/sql/perf-tests/build/test-results/integrationTest>
Generating HTML test report...
Finished generating test html results (0.092 secs) into:
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/ws/src/sdks/java/extensions/sql/perf-tests/build/reports/tests/integrationTest>
:sdks:java:extensions:sql:perf-tests:integrationTest (Thread[Execution
worker,5,main]) completed. Took 1 hrs 17 mins 25.89 secs.
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task
':sdks:java:extensions:sql:perf-tests:integrationTest'.
> There were failing tests. See the report at:
> file://<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/ws/src/sdks/java/extensions/sql/perf-tests/build/reports/tests/integrationTest/index.html>
* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --debug option to get more log output.
* Get more help at https://help.gradle.org
Deprecated Gradle features were used in this build, making it incompatible with
Gradle 8.0.
You can use '--warning-mode all' to show the individual deprecation warnings
and determine if they come from your own scripts or plugins.
See
https://docs.gradle.org/7.5.1/userguide/command_line_interface.html#sec:command_line_warnings
BUILD FAILED in 1h 18m 26s
171 actionable tasks: 107 executed, 62 from cache, 2 up-to-date
Publishing build scan...
https://gradle.com/s/ogqvueuaxvs5m
Stopped 1 worker daemon(s).
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
