See <https://builds.apache.org/job/beam_PerformanceTests_Spark/1469/display/redirect?page=changes>
Changes: [XuMingmin] [BEAM-2281][Sql] Use SqlFunctions.toBigDecimal not toString (#4865) ------------------------------------------ [...truncated 93.38 KB...] 'apache-beam-testing:bqjob_r532439a040871b99_000001622999d3d0_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:19:31,761 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:19:53,440 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:19:55,743 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r6f413b4fdaff9b59_00000162299a30d5_1 ... (0s) Current status: RUNNING Waiting on bqjob_r6f413b4fdaff9b59_00000162299a30d5_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r6f413b4fdaff9b59_00000162299a30d5_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:19:55,744 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:20:24,292 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:20:26,278 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r504d62182820682d_00000162299aa95e_1 ... (0s) Current status: RUNNING Waiting on bqjob_r504d62182820682d_00000162299aa95e_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r504d62182820682d_00000162299aa95e_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:20:26,278 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:20:47,768 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:20:50,019 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r274b041bb0ecbbd9_00000162299b0513_1 ... (0s) Current status: RUNNING Waiting on bqjob_r274b041bb0ecbbd9_00000162299b0513_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r274b041bb0ecbbd9_00000162299b0513_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:20:50,020 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:21:12,036 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:21:14,143 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r5e85005a3cb17ef3_00000162299b63eb_1 ... (0s) Current status: RUNNING Waiting on bqjob_r5e85005a3cb17ef3_00000162299b63eb_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r5e85005a3cb17ef3_00000162299b63eb_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:21:14,144 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:21:35,195 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:21:37,675 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r5aac288c5b1ad045_00000162299bbe55_1 ... (0s) Current status: RUNNING Waiting on bqjob_r5aac288c5b1ad045_00000162299bbe55_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r5aac288c5b1ad045_00000162299bbe55_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:21:37,675 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:22:06,971 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:22:09,155 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r7dab9bfc71f87848_00000162299c3a7c_1 ... (0s) Current status: RUNNING Waiting on bqjob_r7dab9bfc71f87848_00000162299c3a7c_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r7dab9bfc71f87848_00000162299c3a7c_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:22:09,156 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:22:30,173 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:22:32,416 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r37571229f9d2c257_00000162299c9515_1 ... (0s) Current status: RUNNING Waiting on bqjob_r37571229f9d2c257_00000162299c9515_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r37571229f9d2c257_00000162299c9515_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:22:32,417 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:22:59,956 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:23:02,080 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r58c735661b1c0434_00000162299d0972_1 ... (0s) Current status: RUNNING Waiting on bqjob_r58c735661b1c0434_00000162299d0972_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r58c735661b1c0434_00000162299d0972_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:23:02,081 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:23:23,338 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:23:25,816 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r1a25ac9e5675b93_00000162299d655c_1 ... (0s) Current status: RUNNING Waiting on bqjob_r1a25ac9e5675b93_00000162299d655c_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r1a25ac9e5675b93_00000162299d655c_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:23:25,816 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:23:46,612 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:23:48,788 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r2f8f07646c57c8fa_00000162299dbfb2_1 ... (0s) Current status: RUNNING Waiting on bqjob_r2f8f07646c57c8fa_00000162299dbfb2_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r2f8f07646c57c8fa_00000162299dbfb2_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:23:48,789 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:24:12,399 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:24:14,530 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r314959e2ed3e0509_00000162299e246a_1 ... (0s) Current status: RUNNING Waiting on bqjob_r314959e2ed3e0509_00000162299e246a_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r314959e2ed3e0509_00000162299e246a_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:24:14,530 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:24:32,044 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:24:34,067 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r66b787c91e312171_00000162299e7124_1 ... (0s) Current status: RUNNING Waiting on bqjob_r66b787c91e312171_00000162299e7124_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r66b787c91e312171_00000162299e7124_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) 2018-03-15 12:24:34,067 63571dd6 MainThread INFO Retrying exception running IssueRetryableCommand: Command returned a non-zero exit code. 2018-03-15 12:24:52,021 63571dd6 MainThread INFO Running: bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json> 2018-03-15 12:24:54,230 63571dd6 MainThread INFO Ran: {bq load --autodetect --source_format=NEWLINE_DELIMITED_JSON beam_performance.pkb_results <https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/runs/63571dd6/perfkit-bq-publOAlM4.json}> ReturnCode:1 STDOUT: Upload complete. Waiting on bqjob_r5cc62ab33208d137_00000162299ebf2f_1 ... (0s) Current status: RUNNING Waiting on bqjob_r5cc62ab33208d137_00000162299ebf2f_1 ... (0s) Current status: DONE BigQuery error in load operation: Error processing job 'apache-beam-testing:bqjob_r5cc62ab33208d137_00000162299ebf2f_1': Invalid schema update. Field timestamp has changed type from TIMESTAMP to FLOAT STDERR: /usr/lib/google-cloud-sdk/platform/bq/third_party/oauth2client/contrib/gce.py:73: UserWarning: You have requested explicit scopes to be used with a GCE service account. Using this argument will have no effect on the actual scopes for tokens requested. These scopes are set at VM instance creation time and can't be overridden in the request. warnings.warn(_SCOPES_WARNING) Traceback (most recent call last): File "PerfKitBenchmarker/pkb.py", line 21, in <module> sys.exit(Main()) File "<https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/PerfKitBenchmarker/perfkitbenchmarker/pkb.py";,> line 927, in Main return RunBenchmarks() File "<https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/PerfKitBenchmarker/perfkitbenchmarker/pkb.py";,> line 854, in RunBenchmarks collector.PublishSamples() File "<https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/PerfKitBenchmarker/perfkitbenchmarker/publisher.py";,> line 886, in PublishSamples publisher.PublishSamples(self.samples) File "<https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/PerfKitBenchmarker/perfkitbenchmarker/publisher.py";,> line 538, in PublishSamples vm_util.IssueRetryableCommand(load_cmd) File "<https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/PerfKitBenchmarker/perfkitbenchmarker/vm_util.py";,> line 249, in WrappedFunction return f(*args, **kwargs) File "<https://builds.apache.org/job/beam_PerformanceTests_Spark/ws/PerfKitBenchmarker/perfkitbenchmarker/vm_util.py";,> line 387, in IssueRetryableCommand 'Command returned a non-zero exit code.\n') perfkitbenchmarker.errors.CalledProcessException: Command returned a non-zero exit code. Build step 'Execute shell' marked build as failure
