See <https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/148/display/redirect?page=changes>
Changes: [piotr.szuberski] [BEAM-11058] Enable HadoopFormatIOElasticIT on Java PostCommit [noreply] Update beam-2.24.0.md [zyichi] [BEAM-11113] Switch default pickler compressor back to zlib for Coders [noreply] Fix URL to BEAM-9615 (#13190) [tysonjh] [BEAM-11130] Exclude OrderedListState VR tests. [Kenneth Knowles] Enable JSON_EXTRACT and TO_JSON_STRING in ZetaSQL [Robin Qiu] Move Beam 2.25.0 release blog to the correct directory ------------------------------------------ [...truncated 35.48 KB...] Collecting oauthlib>=3.0.0 Using cached oauthlib-3.1.0-py2.py3-none-any.whl (147 kB) Collecting mypy-extensions>=0.3.0 Using cached mypy_extensions-0.4.3-py2.py3-none-any.whl (4.5 kB) Building wheels for collected packages: apache-beam Building wheel for apache-beam (setup.py): started Building wheel for apache-beam (setup.py): finished with status 'done' Created wheel for apache-beam: filename=apache_beam-2.26.0.dev0-py3-none-any.whl size=2310655 sha256=726e7b610d6b1b8eb2fc3cb484ae42c20dcd23cf1589737dc08e8a47078967ae Stored in directory: /home/jenkins/.cache/pip/wheels/d1/c9/65/2dcfb578dbb9566e63f5563e55b8c503d2d116c400c6121d1c Successfully built apache-beam Installing collected packages: avro-python3, crcmod, dill, fastavro, docopt, certifi, chardet, idna, urllib3, requests, hdfs, httplib2, pbr, mock, numpy, pymongo, pyasn1, pyasn1-modules, rsa, oauth2client, pyarrow, pyparsing, pydot, python-dateutil, pytz, typing-extensions, jmespath, botocore, s3transfer, boto3, azure-core, pycparser, cffi, cryptography, oauthlib, requests-oauthlib, isodate, msrest, azure-storage-blob, cachetools, monotonic, fasteners, google-apitools, google-auth, googleapis-common-protos, google-api-core, google-cloud-core, google-cloud-datastore, grpc-google-iam-v1, google-cloud-pubsub, google-crc32c, google-resumable-media, google-cloud-bigquery, google-cloud-bigtable, google-cloud-spanner, grpcio-gcp, google-cloud-dlp, google-cloud-language, google-cloud-videointelligence, google-cloud-vision, mypy-extensions, typing-inspect, pyyaml, libcst, proto-plus, google-cloud-build, freezegun, nose, nose-xunitmp, pandas, parameterized, pyhamcrest, requests-mock, tenacity, packaging, more-itertools, atomicwrites, wcwidth, attrs, pytest, pytest-forked, apipkg, execnet, pytest-xdist, pytest-timeout, sqlalchemy, psycopg2-binary, colorama, crayons, blindspin, websocket-client, docker, deprecation, wrapt, testcontainers, apache-beam Successfully installed apache-beam-2.26.0.dev0 apipkg-1.5 atomicwrites-1.4.0 attrs-20.2.0 avro-python3-1.9.2.1 azure-core-1.8.2 azure-storage-blob-12.5.0 blindspin-2.0.1 boto3-1.16.5 botocore-1.19.5 cachetools-4.1.1 certifi-2020.6.20 cffi-1.14.3 chardet-3.0.4 colorama-0.4.4 crayons-0.4.0 crcmod-1.7 cryptography-3.2 deprecation-2.1.0 dill-0.3.1.1 docker-4.3.1 docopt-0.6.2 execnet-1.7.1 fastavro-1.0.0.post1 fasteners-0.15 freezegun-1.0.0 google-api-core-1.23.0 google-apitools-0.5.31 google-auth-1.22.1 google-cloud-bigquery-1.28.0 google-cloud-bigtable-1.5.1 google-cloud-build-2.0.0 google-cloud-core-1.4.3 google-cloud-datastore-1.15.3 google-cloud-dlp-1.0.0 google-cloud-language-1.3.0 google-cloud-pubsub-1.7.0 google-cloud-spanner-1.19.1 google-cloud-videointelligence-1.16.0 google-cloud-vision-1.0.0 google-crc32c-1.0.0 google-resumable-media-1.1.0 googleapis-common-protos-1.52.0 grpc-google-iam-v1-0.12.3 grpcio-gcp-0.2.2 hdfs-2.5.8 httplib2-0.17.4 idna-2.10 isodate-0.6.0 jmespath-0.10.0 libcst-0.3.13 mock-2.0.0 monotonic-1.5 more-itertools-8.5.0 msrest-0.6.19 mypy-extensions-0.4.3 nose-1.3.7 nose-xunitmp-0.4.1 numpy-1.19.2 oauth2client-4.1.3 oauthlib-3.1.0 packaging-20.4 pandas-1.1.3 parameterized-0.7.4 pbr-5.5.1 proto-plus-1.11.0 psycopg2-binary-2.8.6 pyarrow-0.17.1 pyasn1-0.4.8 pyasn1-modules-0.2.8 pycparser-2.20 pydot-1.4.1 pyhamcrest-1.10.1 pymongo-3.11.0 pyparsing-2.4.7 pytest-4.6.11 pytest-forked-1.3.0 pytest-timeout-1.4.2 pytest-xdist-1.34.0 python-dateutil-2.8.1 pytz-2020.1 pyyaml-5.3.1 requests-2.24.0 requests-mock-1.8.0 requests-oauthlib-1.3.0 rsa-4.6 s3transfer-0.3.3 sqlalchemy-1.3.20 tenacity-5.1.5 testcontainers-3.1.0 typing-extensions-3.7.4.3 typing-inspect-0.6.0 urllib3-1.25.11 wcwidth-0.2.5 websocket-client-0.57.0 wrapt-1.12.1 > Task :sdks:python:apache_beam:testing:load_tests:run <https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/io/gcp/bigquery.py>:1659: BeamDeprecationWarning: options is deprecated since First stable release. References to <pipeline>.options will not be supported self.table_reference.projectId = pcoll.pipeline.options.view_as( <https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/io/gcp/bigquery_file_loads.py>:900: BeamDeprecationWarning: options is deprecated since First stable release. References to <pipeline>.options will not be supported temp_location = p.options.view_as(GoogleCloudOptions).temp_location INFO:apache_beam.runners.portability.stager:Copying Beam SDK "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/build/apache-beam.tar.gz";> to staging location. WARNING:root:Make sure that locally built Python SDK docker image has Python 3.7 interpreter. INFO:root:Using Python SDK docker image: apache/beam_python3.7_sdk:2.26.0.dev. If the image is not available at local, we will try to pull from hub.docker.com INFO:apache_beam.runners.dataflow.internal.apiclient:Defaulting to the temp_location as staging_location: gs://temp-storage-for-perf-tests/loadtests INFO:apache_beam.internal.gcp.auth:Setting socket default timeout to 60 seconds. INFO:apache_beam.internal.gcp.auth:socket default timeout is 60.0 seconds. INFO:apache_beam.runners.dataflow.internal.apiclient:Starting GCS upload to gs://temp-storage-for-perf-tests/loadtests/performance-tests-bqio-write-python-batch-10gb1027150259.1603813484.090472/pipeline.pb... INFO:oauth2client.transport:Attempting refresh to obtain initial access_token INFO:oauth2client.transport:Attempting refresh to obtain initial access_token INFO:apache_beam.runners.dataflow.internal.apiclient:Completed GCS upload to gs://temp-storage-for-perf-tests/loadtests/performance-tests-bqio-write-python-batch-10gb1027150259.1603813484.090472/pipeline.pb in 0 seconds. INFO:apache_beam.runners.dataflow.internal.apiclient:Starting GCS upload to gs://temp-storage-for-perf-tests/loadtests/performance-tests-bqio-write-python-batch-10gb1027150259.1603813484.090472/dataflow_python_sdk.tar... INFO:apache_beam.runners.dataflow.internal.apiclient:Completed GCS upload to gs://temp-storage-for-perf-tests/loadtests/performance-tests-bqio-write-python-batch-10gb1027150259.1603813484.090472/dataflow_python_sdk.tar in 0 seconds. WARNING:apache_beam.options.pipeline_options:Discarding unparseable args: ['--output_dataset=beam_performance', '--output_table=bqio_write_10GB'] WARNING:apache_beam.options.pipeline_options:Discarding unparseable args: ['--output_dataset=beam_performance', '--output_table=bqio_write_10GB'] INFO:apache_beam.runners.dataflow.internal.apiclient:Create job: <Job createTime: '2020-10-27T15:44:46.226802Z' currentStateTime: '1970-01-01T00:00:00Z' id: '2020-10-27_08_44_44-2143763615516952977' location: 'us-central1' name: 'performance-tests-bqio-write-python-batch-10gb1027150259' projectId: 'apache-beam-testing' stageStates: [] startTime: '2020-10-27T15:44:46.226802Z' steps: [] tempFiles: [] type: TypeValueValuesEnum(JOB_TYPE_BATCH, 1)> INFO:apache_beam.runners.dataflow.internal.apiclient:Created job with id: [2020-10-27_08_44_44-2143763615516952977] INFO:apache_beam.runners.dataflow.internal.apiclient:Submitted job: 2020-10-27_08_44_44-2143763615516952977 INFO:apache_beam.runners.dataflow.internal.apiclient:To access the Dataflow monitoring console, please navigate to https://console.cloud.google.com/dataflow/jobs/us-central1/2020-10-27_08_44_44-2143763615516952977?project=apache-beam-testing INFO:apache_beam.runners.dataflow.dataflow_runner:Job 2020-10-27_08_44_44-2143763615516952977 is in state JOB_STATE_PENDING INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:49.111Z: JOB_MESSAGE_BASIC: Worker configuration: n1-standard-1 in us-central1-b. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:49.924Z: JOB_MESSAGE_DETAILED: Expanding CoGroupByKey operations into optimizable parts. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:49.963Z: JOB_MESSAGE_DEBUG: Combiner lifting skipped for step Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables: GroupByKey not followed by a combiner. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:49.998Z: JOB_MESSAGE_DEBUG: Combiner lifting skipped for step Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations: GroupByKey not followed by a combiner. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.035Z: JOB_MESSAGE_DEBUG: Combiner lifting skipped for step Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows: GroupByKey not followed by a combiner. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.072Z: JOB_MESSAGE_DETAILED: Expanding GroupByKey operations into optimizable parts. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.102Z: JOB_MESSAGE_DETAILED: Lifting ValueCombiningMappingFns into MergeBucketsMappingFns INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.237Z: JOB_MESSAGE_DEBUG: Annotating graph with Autotuner information. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.285Z: JOB_MESSAGE_DETAILED: Fusing adjacent ParDo, Read, Write, and Flatten operations INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.321Z: JOB_MESSAGE_DETAILED: Unzipping flatten s19 for input s13.WrittenFiles INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.345Z: JOB_MESSAGE_DETAILED: Fusing unzipped copy of Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround, through flatten Write to BigQuery/BigQueryBatchFileLoads/DestinationFilesUnion, into producer Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.368Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Write into Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.395Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/GroupByWindow into Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.429Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/ParDo(PartitionFiles)/ParDo(PartitionFiles) into Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/GroupByWindow INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.463Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs)/ParDo(TriggerLoadJobs) into Write to BigQuery/BigQueryBatchFileLoads/ParDo(PartitionFiles)/ParDo(PartitionFiles) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.499Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables/TriggerLoadJobsWithoutTempTables into Write to BigQuery/BigQueryBatchFileLoads/ParDo(PartitionFiles)/ParDo(PartitionFiles) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.613Z: JOB_MESSAGE_DETAILED: Unzipping flatten s19-u32 for input s20.None-c30 INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.640Z: JOB_MESSAGE_DETAILED: Fusing unzipped copy of Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify, through flatten Write to BigQuery/BigQueryBatchFileLoads/DestinationFilesUnion/Unzipped-1, into producer Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.673Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround into Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/WriteGroupedRecordsToFile INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.707Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify into Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.740Z: JOB_MESSAGE_DETAILED: Fusing consumer Count messages into Produce rows INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.779Z: JOB_MESSAGE_DETAILED: Fusing consumer Format into Count messages INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.812Z: JOB_MESSAGE_DETAILED: Fusing consumer Measure time into Format INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.838Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RewindowIntoGlobal into Measure time INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.874Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/AppendDestination into Write to BigQuery/BigQueryBatchFileLoads/RewindowIntoGlobal INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.901Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile) into Write to BigQuery/BigQueryBatchFileLoads/AppendDestination INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.949Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/ParDo(_ShardDestinations) into Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:50.977Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Reify into Write to BigQuery/BigQueryBatchFileLoads/ParDo(_ShardDestinations) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.004Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Write into Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Reify INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.034Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/GroupByWindow into Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.067Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/DropShardNumber into Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/GroupByWindow INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.097Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/WriteGroupedRecordsToFile into Write to BigQuery/BigQueryBatchFileLoads/DropShardNumber INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.135Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/LoadJobNamePrefix into Write to BigQuery/BigQueryBatchFileLoads/ImpulseSingleElementPC/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.168Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/CopyJobNamePrefix into Write to BigQuery/BigQueryBatchFileLoads/ImpulseSingleElementPC/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.190Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/GenerateFilePrefix into Write to BigQuery/BigQueryBatchFileLoads/ImpulseSingleElementPC/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.216Z: JOB_MESSAGE_DETAILED: Fusing siblings Write to BigQuery/BigQueryBatchFileLoads/WaitForDestinationLoadJobs/WaitForDestinationLoadJobs and Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/WaitForTempTableLoadJobs INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.258Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs)/ParDo(TriggerCopyJobs) into Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/WaitForTempTableLoadJobs INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.293Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/PassTables into Write to BigQuery/BigQueryBatchFileLoads/WaitForCopyJobs/WaitForCopyJobs INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.326Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/AddUselessValue into Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/PassTables INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.360Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Reify into Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/AddUselessValue INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.385Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Write into Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Reify INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.408Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/GroupByWindow into Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.441Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/GetTableNames into Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/GroupByWindow INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.478Z: JOB_MESSAGE_DETAILED: Fusing consumer Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/Delete into Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/GetTableNames INFO:apache_beam.runners.dataflow.dataflow_runner:Job 2020-10-27_08_44_44-2143763615516952977 is in state JOB_STATE_RUNNING INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.518Z: JOB_MESSAGE_DEBUG: Workflow config is missing a default resource spec. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.561Z: JOB_MESSAGE_DEBUG: Adding StepResource setup and teardown to workflow graph. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.596Z: JOB_MESSAGE_DEBUG: Adding workflow start and stop steps. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.631Z: JOB_MESSAGE_DEBUG: Assigning stage ids. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.805Z: JOB_MESSAGE_DEBUG: Executing wait step start46 INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.870Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/ImpulseSingleElementPC/Read+Write to BigQuery/BigQueryBatchFileLoads/LoadJobNamePrefix+Write to BigQuery/BigQueryBatchFileLoads/CopyJobNamePrefix+Write to BigQuery/BigQueryBatchFileLoads/GenerateFilePrefix INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.917Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Create INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.918Z: JOB_MESSAGE_DEBUG: Starting **** pool setup. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.949Z: JOB_MESSAGE_BASIC: Starting 5 ****s in us-central1-b... INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.962Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Create INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:51.995Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Create INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.010Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Create INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.011Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Create INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.031Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/ImpulseEmptyPC/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.055Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Create INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.061Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/ImpulseEmptyPC/Read INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.087Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Session" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.127Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Session" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.161Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Session" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:44:52.197Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/ImpulseEmptyPC/Read.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:45:00.017Z: JOB_MESSAGE_BASIC: 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 INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:45:16.705Z: JOB_MESSAGE_DETAILED: Autoscaling: Raised the number of ****s to 5 based on the rate of progress in the currently running stage(s). INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:46:47.412Z: JOB_MESSAGE_DETAILED: Workers have started successfully. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:46:47.442Z: JOB_MESSAGE_DETAILED: Workers have started successfully. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.598Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/ImpulseSingleElementPC/Read+Write to BigQuery/BigQueryBatchFileLoads/LoadJobNamePrefix+Write to BigQuery/BigQueryBatchFileLoads/CopyJobNamePrefix+Write to BigQuery/BigQueryBatchFileLoads/GenerateFilePrefix INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.675Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/ImpulseSingleElementPC/Read.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.701Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/LoadJobNamePrefix.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.732Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/CopyJobNamePrefix.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.753Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/GenerateFilePrefix.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.774Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs)/_UnpickledSideInput(LoadJobNamePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.809Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables/_UnpickledSideInput(LoadJobNamePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.842Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/_UnpickledSideInput(GenerateFilePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.879Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs)/_UnpickledSideInput(LoadJobNamePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.880Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/_UnpickledSideInput(GenerateFilePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.899Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables/_UnpickledSideInput(LoadJobNamePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.901Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/_UnpickledSideInput(GenerateFilePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.913Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs)/_UnpickledSideInput(CopyJobNamePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.932Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/_UnpickledSideInput(GenerateFilePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.947Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs)/_UnpickledSideInput(LoadJobNamePrefix.out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.971Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables/_UnpickledSideInput(LoadJobNamePrefix.out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:30.972Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs)/_UnpickledSideInput(CopyJobNamePrefix.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:31.011Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/_UnpickledSideInput(GenerateFilePrefix.out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:31.036Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/_UnpickledSideInput(GenerateFilePrefix.out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:31.070Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs)/_UnpickledSideInput(CopyJobNamePrefix.out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:50:31.105Z: JOB_MESSAGE_BASIC: Executing operation Produce rows+Count messages+Format+Measure time+Write to BigQuery/BigQueryBatchFileLoads/RewindowIntoGlobal+Write to BigQuery/BigQueryBatchFileLoads/AppendDestination+Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)+Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Write+Write to BigQuery/BigQueryBatchFileLoads/ParDo(_ShardDestinations)+Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Reify+Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Write INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:12.812Z: JOB_MESSAGE_BASIC: Finished operation Produce rows+Count messages+Format+Measure time+Write to BigQuery/BigQueryBatchFileLoads/RewindowIntoGlobal+Write to BigQuery/BigQueryBatchFileLoads/AppendDestination+Write to BigQuery/BigQueryBatchFileLoads/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)/ParDo(WriteRecordsToFile)+Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Write+Write to BigQuery/BigQueryBatchFileLoads/ParDo(_ShardDestinations)+Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Reify+Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Write INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:12.893Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Close INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:12.969Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Close INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:13.029Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Read+Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/GroupByWindow+Write to BigQuery/BigQueryBatchFileLoads/DropShardNumber+Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/WriteGroupedRecordsToFile+Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Write INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:13.573Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/Read+Write to BigQuery/BigQueryBatchFileLoads/GroupShardedRows/GroupByWindow+Write to BigQuery/BigQueryBatchFileLoads/DropShardNumber+Write to BigQuery/BigQueryBatchFileLoads/WriteGroupedRecordsToFile/WriteGroupedRecordsToFile+Write to BigQuery/BigQueryBatchFileLoads/IdentityWorkaround+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Reify+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Write INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:13.735Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Close INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:13.800Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Close INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:13.868Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Read+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/GroupByWindow+Write to BigQuery/BigQueryBatchFileLoads/ParDo(PartitionFiles)/ParDo(PartitionFiles)+Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs)/ParDo(TriggerLoadJobs)+Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables/TriggerLoadJobsWithoutTempTables INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.452Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/Read+Write to BigQuery/BigQueryBatchFileLoads/GroupFilesByTableDestinations/GroupByWindow+Write to BigQuery/BigQueryBatchFileLoads/ParDo(PartitionFiles)/ParDo(PartitionFiles)+Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs)/ParDo(TriggerLoadJobs)+Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables/TriggerLoadJobsWithoutTempTables INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.526Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs).out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.564Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithTempTables/ParDo(TriggerLoadJobs).TemporaryTables" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.598Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/TriggerLoadJobsWithoutTempTables.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.628Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/_UnpickledSideInput(ParDo(TriggerLoadJobs).out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.660Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/_UnpickledSideInput(ParDo(TriggerLoadJobs).TemporaryTables.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.690Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/_UnpickledSideInput(ParDo(TriggerLoadJobs).out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.704Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/_UnpickledSideInput(ParDo(TriggerLoadJobs).TemporaryTables.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.770Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/WaitForDestinationLoadJobs/_UnpickledSideInput(TriggerLoadJobsWithoutTempTables.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.809Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/Flatten INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.836Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/WaitForDestinationLoadJobs/_UnpickledSideInput(TriggerLoadJobsWithoutTempTables.out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.844Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/_UnpickledSideInput(ParDo(TriggerLoadJobs).out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.876Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/_UnpickledSideInput(ParDo(TriggerLoadJobs).TemporaryTables.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.887Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/Flatten INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.921Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/WaitForDestinationLoadJobs/_UnpickledSideInput(TriggerLoadJobsWithoutTempTables.out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.958Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/Flatten.out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:18.992Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/WaitForDestinationLoadJobs/WaitForDestinationLoadJobs+Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/WaitForTempTableLoadJobs+Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs)/ParDo(TriggerCopyJobs) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:52.196Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/WaitForDestinationLoadJobs/WaitForDestinationLoadJobs+Write to BigQuery/BigQueryBatchFileLoads/WaitForTempTableLoadJobs/WaitForTempTableLoadJobs+Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs)/ParDo(TriggerCopyJobs) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:52.273Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/ParDo(TriggerCopyJobs).out" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:52.341Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/WaitForCopyJobs/_UnpickledSideInput(ParDo(TriggerCopyJobs).out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:52.404Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/WaitForCopyJobs/_UnpickledSideInput(ParDo(TriggerCopyJobs).out.0) INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:52.508Z: JOB_MESSAGE_DEBUG: Value "Write to BigQuery/BigQueryBatchFileLoads/WaitForCopyJobs/_UnpickledSideInput(ParDo(TriggerCopyJobs).out.0).output" materialized. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:52.590Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/WaitForCopyJobs/WaitForCopyJobs+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/PassTables+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/AddUselessValue+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Reify+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Write INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:53.493Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/WaitForCopyJobs/WaitForCopyJobs+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/PassTables/PassTables+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/AddUselessValue+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Reify+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Write INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:53.591Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Close INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:53.638Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Close INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:53.729Z: JOB_MESSAGE_BASIC: Executing operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Read+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/GroupByWindow+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/GetTableNames+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/Delete INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:53.920Z: JOB_MESSAGE_BASIC: Finished operation Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/Read+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/DeduplicateTables/GroupByWindow+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/GetTableNames+Write to BigQuery/BigQueryBatchFileLoads/RemoveTempTables/Delete INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:54.036Z: JOB_MESSAGE_DEBUG: Executing success step success44 INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:54.099Z: JOB_MESSAGE_DETAILED: Cleaning up. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:54.154Z: JOB_MESSAGE_DEBUG: Starting **** pool teardown. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:55:54.181Z: JOB_MESSAGE_BASIC: Stopping **** pool... INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:56:44.357Z: JOB_MESSAGE_DETAILED: Autoscaling: Resized **** pool from 5 to 0. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:56:44.418Z: JOB_MESSAGE_BASIC: Worker pool stopped. INFO:apache_beam.runners.dataflow.dataflow_runner:2020-10-27T15:56:44.484Z: JOB_MESSAGE_DEBUG: Tearing down pending resources... INFO:apache_beam.runners.dataflow.dataflow_runner:Job 2020-10-27_08_44_44-2143763615516952977 is in state JOB_STATE_DONE INFO:apache_beam.testing.load_tests.load_test_metrics_utils:Load test results for test: 338a979742c3413aa7d4652cbc503371 and timestamp: 1603814212.294295: INFO:apache_beam.testing.load_tests.load_test_metrics_utils:Metric: bqio_write_10GB_results_count_messag_total_messages Value: 10485760 INFO:apache_beam.testing.load_tests.load_test_metrics_utils:Metric: bqio_write_10GB_results_runtime Value: 275 INFO:apache_beam.io.gcp.tests.utils:Clean up a BigQuery table with project: apache-beam-testing, dataset: beam_performance, table: bqio_write_10GB. Traceback (most recent call last): File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/io/gcp/tests/utils.py";,> line 104, in delete_bq_table client.delete_table(table_ref) File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/build/gradleenv/1329484227/lib/python3.7/site-packages/google/cloud/bigquery/client.py";,> line 1512, in delete_table timeout=timeout, File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/build/gradleenv/1329484227/lib/python3.7/site-packages/google/cloud/bigquery/client.py";,> line 641, in _call_api return call() File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/build/gradleenv/1329484227/lib/python3.7/site-packages/google/api_core/retry.py";,> line 286, in retry_wrapped_func on_error=on_error, File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/build/gradleenv/1329484227/lib/python3.7/site-packages/google/api_core/retry.py";,> line 184, in retry_target return target() File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/build/gradleenv/1329484227/lib/python3.7/site-packages/google/cloud/_http.py";,> line 435, in api_request raise exceptions.from_http_response(response) google.api_core.exceptions.NotFound: 404 DELETE https://bigquery.googleapis.com/bigquery/v2/projects/apache-beam-testing/datasets/beam_performance/tables/bqio_write_10GB?prettyPrint=false: Not found: Table apache-beam-testing:beam_performance.bqio_write_10GB During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3.7/runpy.py", line 193, in _run_module_as_main "__main__", mod_spec) File "/usr/lib/python3.7/runpy.py", line 85, in _run_code exec(code, run_globals) File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/io/gcp/bigquery_write_perf_test.py";,> line 109, in <module> BigQueryWritePerfTest().run() File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/testing/load_tests/load_test.py";,> line 155, in run self.cleanup() File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/io/gcp/bigquery_write_perf_test.py";,> line 104, in cleanup self.project_id, self.output_dataset, self.output_table) File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/utils/retry.py";,> line 260, in wrapper return fun(*args, **kwargs) File "<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/io/gcp/tests/utils.py";,> line 106, in delete_bq_table raise GcpTestIOError('BigQuery table does not exist: %s' % table_ref) apache_beam.io.gcp.tests.utils.GcpTestIOError: BigQuery table does not exist: TableReference(DatasetReference('apache-beam-testing', 'beam_performance'), 'bqio_write_10GB') > Task :sdks:python:apache_beam:testing:load_tests:run FAILED FAILURE: Build failed with an exception. * Where: Build file '<https://ci-beam.apache.org/job/beam_PerformanceTests_BiqQueryIO_Write_Python_Batch/ws/src/sdks/python/apache_beam/testing/load_tests/build.gradle'> line: 58 * What went wrong: Execution failed for task ':sdks:python:apache_beam:testing:load_tests:run'. > error occurred * Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights. * Get more help at https://help.gradle.org Deprecated Gradle features were used in this build, making it incompatible with Gradle 7.0. Use '--warning-mode all' to show the individual deprecation warnings. See https://docs.gradle.org/6.6.1/userguide/command_line_interface.html#sec:command_line_warnings BUILD FAILED in 13m 32s 5 actionable tasks: 5 executed Publishing build scan... https://gradle.com/s/ta4rqehgr6ffg Build step 'Invoke Gradle script' changed build result to FAILURE Build step 'Invoke Gradle script' marked build as failure No JDK named ‘JDK 1.8 (latest)’ found --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
