You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hudi.apache.org by "zhangzhaohuazai (via GitHub)" <gi...@apache.org> on 2023/07/21 07:28:02 UTC

[GitHub] [hudi] zhangzhaohuazai opened a new issue, #9254: [SUPPORT].exception.HoodieIOException: Could not load filesystem view storage properties from s3a://**/.hoodie/.aux/view_storage_conf.properties

zhangzhaohuazai opened a new issue, #9254:
URL: https://github.com/apache/hudi/issues/9254

   **_Tips before filing an issue_**
   
   - Have you gone through our [FAQs](https://hudi.apache.org/learn/faq/)?
   yes
   - Join the mailing list to engage in conversations and get faster support at dev-subscribe@hudi.apache.org.
   
   - If you have triaged this as a bug, then file an [issue](https://issues.apache.org/jira/projects/HUDI/issues) directly.
   
   **Describe the problem you faced**
   
   When a jar job is submitted using flink (the customized data source is written to hudi and hive, and the underlying storage is s3), the flink job is abnormal when a large amount of data is written (tens of millions of data), but normal when a small amount of data is written.
   
   **To Reproduce**
   
   Steps to reproduce the behavior:
   
   1.write flink job by java(the customized data source is written to hudi(table unpartitioned) and hive, and the underlying storage is s3),and submit to flink cluster
   2.run the job
   3.When the job run data volume is small, the job runs normally when it is less than 10 million
   4.A job exception occurs when the amount of data increases to tens of millions
   5.The hive also report errors when reading tables
   
   **Expected behavior**
   
   flink operations are always normal, even when the amount of data is large.Finally, hive query is normal.
   
   **Environment Description**
   core-site.xml:
   ![image](https://github.com/apache/hudi/assets/28680957/e8492c5e-1fdd-451d-9d1a-221aa1ace7e5)
   /hive/auxlib:
   ![image](https://github.com/apache/hudi/assets/28680957/dfabd903-2fcd-4cc5-b26a-783055b8a364)
   /hive/conf/hive-env.sh:
   ![image](https://github.com/apache/hudi/assets/28680957/3cdbb507-30a9-4686-b3b0-44dc36352c8a)
   /flink/lib:
   ![image](https://github.com/apache/hudi/assets/28680957/d392c4b1-282d-4c7f-bd42-68db86e3cb94)
   
   * Hudi version :
   0.12.1
   * Flink version :
   1.14.5
   * Hive version :
   3.1.2
   * Hadoop version :
   3.2.4
   * Storage (HDFS/S3/GCS..) :
   S3
   * Running on Docker? (yes/no) :
   no
   
   **Additional context**
   
   Add any other context about the problem here.
   
   **Stacktrace**
   **1.flink exception**
   ```org.apache.hudi.exception.HoodieIOException: Could not load filesystem view storage properties from s3a://metadatahudi/metasource_sync_hudi24/.hoodie/.aux/view_storage_conf.properties
       at org.apache.hudi.util.ViewStorageProperties.loadFromProperties(ViewStorageProperties.java:78)
       at org.apache.hudi.util.StreamerUtil.getHoodieClientConfig(StreamerUtil.java:240)
       at org.apache.hudi.util.StreamerUtil.getHoodieClientConfig(StreamerUtil.java:158)
       at org.apache.hudi.sink.partitioner.BucketAssignFunction.open(BucketAssignFunction.java:118)
       at org.apache.flink.api.common.functions.util.FunctionUtils.openFunction(FunctionUtils.java:34)
       at org.apache.flink.streaming.api.operators.AbstractUdfStreamOperator.open(AbstractUdfStreamOperator.java:100)
       at org.apache.flink.streaming.api.operators.KeyedProcessOperator.open(KeyedProcessOperator.java:55)
       at org.apache.flink.streaming.runtime.tasks.RegularOperatorChain.initializeStateAndOpenOperators(RegularOperatorChain.java:110)
       at org.apache.flink.streaming.runtime.tasks.StreamTask.restoreGates(StreamTask.java:711)
       at org.apache.flink.streaming.runtime.tasks.StreamTaskActionExecutor$1.call(StreamTaskActionExecutor.java:55)
       at org.apache.flink.streaming.runtime.tasks.StreamTask.restoreInternal(StreamTask.java:687)
       at org.apache.flink.streaming.runtime.tasks.StreamTask.restore(StreamTask.java:654)
       at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:958)
       at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:927)
       at org.apache.flink.runtime.taskmanager.Task.doRun(Task.java:766)
       at org.apache.flink.runtime.taskmanager.Task.run(Task.java:575)
       at java.lang.Thread.run(Thread.java:750)
       Suppressed: java.lang.NullPointerException
           at org.apache.hudi.sink.partitioner.BucketAssignFunction.close(BucketAssignFunction.java:240)
           at org.apache.flink.api.common.functions.util.FunctionUtils.closeFunction(FunctionUtils.java:41)
           at org.apache.flink.streaming.api.operators.AbstractUdfStreamOperator.close(AbstractUdfStreamOperator.java:114)
           at org.apache.flink.streaming.runtime.tasks.StreamOperatorWrapper.close(StreamOperatorWrapper.java:141)
           at org.apache.flink.streaming.runtime.tasks.RegularOperatorChain.closeAllOperators(RegularOperatorChain.java:127)
           at org.apache.flink.streaming.runtime.tasks.StreamTask.closeAllOperators(StreamTask.java:1035)
           at org.apache.flink.streaming.runtime.tasks.StreamTask.runAndSuppressThrowable(StreamTask.java:1021)
           at org.apache.flink.streaming.runtime.tasks.StreamTask.cleanUp(StreamTask.java:928)
           at org.apache.flink.runtime.taskmanager.Task.lambda$restoreAndInvoke$0(Task.java:940)
           at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:958)
           at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:940)
           ... 3 more
   Caused by: java.io.InterruptedIOException: getFileStatus on s3a://metadatahudi/metasource_sync_hudi24/.hoodie/.aux/view_storage_conf.properties: com.amazonaws.SdkClientException: Unable to execute HTTP request: Timeout waiting for connection from pool
       at org.apache.hadoop.fs.s3a.S3AUtils.translateInterruptedException(S3AUtils.java:352)
       at org.apache.hadoop.fs.s3a.S3AUtils.translateException(S3AUtils.java:177)
       at org.apache.hadoop.fs.s3a.S3AUtils.translateException(S3AUtils.java:151)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.s3GetFileStatus(S3AFileSystem.java:2278)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.innerGetFileStatus(S3AFileSystem.java:2226)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.getFileStatus(S3AFileSystem.java:2160)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.open(S3AFileSystem.java:727)
       at org.apache.hadoop.fs.FileSystem.open(FileSystem.java:906)
       at org.apache.hudi.util.ViewStorageProperties.loadFromProperties(ViewStorageProperties.java:73)
       ... 16 more
   Caused by: com.amazonaws.SdkClientException: Unable to execute HTTP request: Timeout waiting for connection from pool
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.handleRetryableException(AmazonHttpClient.java:1207)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1153)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.doExecute(AmazonHttpClient.java:802)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeWithTimer(AmazonHttpClient.java:770)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.execute(AmazonHttpClient.java:744)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.access$500(AmazonHttpClient.java:704)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutionBuilderImpl.execute(AmazonHttpClient.java:686)
       at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:550)
       at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:530)
       at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5259)
       at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5206)
       at com.amazonaws.services.s3.AmazonS3Client.getObjectMetadata(AmazonS3Client.java:1360)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.lambda$getObjectMetadata$4(S3AFileSystem.java:1307)
       at org.apache.hadoop.fs.s3a.Invoker.retryUntranslated(Invoker.java:322)
       at org.apache.hadoop.fs.s3a.Invoker.retryUntranslated(Invoker.java:285)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.getObjectMetadata(S3AFileSystem.java:1304)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.s3GetFileStatus(S3AFileSystem.java:2264)
       ... 21 more
   Caused by: org.apache.http.conn.ConnectionPoolTimeoutException: Timeout waiting for connection from pool
       at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.leaseConnection(PoolingHttpClientConnectionManager.java:316)
       at org.apache.http.impl.conn.PoolingHttpClientConnectionManager$1.get(PoolingHttpClientConnectionManager.java:282)
       at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at com.amazonaws.http.conn.ClientConnectionRequestFactory$Handler.invoke(ClientConnectionRequestFactory.java:70)
       at com.amazonaws.http.conn.$Proxy47.get(Unknown Source)
       at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:190)
       at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
       at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
       at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
       at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
       at com.amazonaws.http.apache.client.impl.SdkHttpClient.execute(SdkHttpClient.java:72)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeOneRequest(AmazonHttpClient.java:1331)
       at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1145)
       ... 36 more
   ```
   **2.hive query exception:**
   ``` 
   Diagnostic Messages for this Task:
   Error: java.io.IOException: org.apache.hudi.exception.HoodieException: Exception when reading log file 
   	at org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderCreationException(HiveIOExceptionHandlerChain.java:97)
   	at org.apache.hadoop.hive.io.HiveIOExceptionHandlerUtil.handleRecordReaderCreationException(HiveIOExceptionHandlerUtil.java:57)
   	at org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:420)
   	at org.apache.hadoop.mapred.MapTask$TrackedRecordReader.<init>(MapTask.java:176)
   	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:445)
   	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:350)
   	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174)
   	at java.security.AccessController.doPrivileged(Native Method)
   	at javax.security.auth.Subject.doAs(Subject.java:422)
   	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1762)
   	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168)
   Caused by: org.apache.hudi.exception.HoodieException: Exception when reading log file 
   	at org.apache.hudi.common.table.log.AbstractHoodieLogRecordReader.scanInternal(AbstractHoodieLogRecordReader.java:352)
   	at org.apache.hudi.common.table.log.AbstractHoodieLogRecordReader.scan(AbstractHoodieLogRecordReader.java:192)
   	at org.apache.hudi.common.table.log.HoodieMergedLogRecordScanner.performScan(HoodieMergedLogRecordScanner.java:110)
   	at org.apache.hudi.common.table.log.HoodieMergedLogRecordScanner.<init>(HoodieMergedLogRecordScanner.java:103)
   	at org.apache.hudi.common.table.log.HoodieMergedLogRecordScanner$Builder.build(HoodieMergedLogRecordScanner.java:324)
   	at org.apache.hudi.hadoop.realtime.RealtimeCompactedRecordReader.getMergedLogRecordScanner(RealtimeCompactedRecordReader.java:94)
   	at org.apache.hudi.hadoop.realtime.RealtimeCompactedRecordReader.<init>(RealtimeCompactedRecordReader.java:64)
   	at org.apache.hudi.hadoop.realtime.HoodieRealtimeRecordReader.constructRecordReader(HoodieRealtimeRecordReader.java:70)
   	at org.apache.hudi.hadoop.realtime.HoodieRealtimeRecordReader.<init>(HoodieRealtimeRecordReader.java:47)
   	at org.apache.hudi.hadoop.realtime.HoodieParquetRealtimeInputFormat.getRecordReader(HoodieParquetRealtimeInputFormat.java:74)
   	at org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:417)
   	... 8 more
   Caused by: org.apache.hudi.exception.HoodieIOException: unable to initialize read with log file 
   	at org.apache.hudi.common.table.log.HoodieLogFormatReader.hasNext(HoodieLogFormatReader.java:113)
   	at org.apache.hudi.common.table.log.AbstractHoodieLogRecordReader.scanInternal(AbstractHoodieLogRecordReader.java:223)
   	... 18 more
   Caused by: java.io.InterruptedIOException: getFileStatus on s3a://metadatahudi/metasource_sync_hudi24/.246f8055-041d-47c9-8b52-9dab4126b5eb_20230721021319640.log.15_1-0-1: com.amazonaws.SdkClientException: Unable to execute HTTP request: Timeout waiting for connection from pool
   	at org.apache.hadoop.fs.s3a.S3AUtils.translateInterruptedException(S3AUtils.java:352)
   	at org.apache.hadoop.fs.s3a.S3AUtils.translateException(S3AUtils.java:177)
   	at org.apache.hadoop.fs.s3a.S3AUtils.translateException(S3AUtils.java:151)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.s3GetFileStatus(S3AFileSystem.java:2278)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.innerGetFileStatus(S3AFileSystem.java:2226)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.getFileStatus(S3AFileSystem.java:2160)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.open(S3AFileSystem.java:727)
   	at org.apache.hudi.common.table.log.HoodieLogFileReader.getFSDataInputStream(HoodieLogFileReader.java:475)
   	at org.apache.hudi.common.table.log.HoodieLogFileReader.<init>(HoodieLogFileReader.java:114)
   	at org.apache.hudi.common.table.log.HoodieLogFormatReader.hasNext(HoodieLogFormatReader.java:110)
   	... 19 more
   Caused by: com.amazonaws.SdkClientException: Unable to execute HTTP request: Timeout waiting for connection from pool
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.handleRetryableException(AmazonHttpClient.java:1207)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1153)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.doExecute(AmazonHttpClient.java:802)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeWithTimer(AmazonHttpClient.java:770)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.execute(AmazonHttpClient.java:744)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.access$500(AmazonHttpClient.java:704)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutionBuilderImpl.execute(AmazonHttpClient.java:686)
   	at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:550)
   	at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:530)
   	at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5227)
   	at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:5173)
   	at com.amazonaws.services.s3.AmazonS3Client.getObjectMetadata(AmazonS3Client.java:1360)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.lambda$getObjectMetadata$4(S3AFileSystem.java:1307)
   	at org.apache.hadoop.fs.s3a.Invoker.retryUntranslated(Invoker.java:322)
   	at org.apache.hadoop.fs.s3a.Invoker.retryUntranslated(Invoker.java:285)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.getObjectMetadata(S3AFileSystem.java:1304)
   	at org.apache.hadoop.fs.s3a.S3AFileSystem.s3GetFileStatus(S3AFileSystem.java:2264)
   	... 25 more
   Caused by: com.amazonaws.thirdparty.apache.http.conn.ConnectionPoolTimeoutException: Timeout waiting for connection from pool
   	at com.amazonaws.thirdparty.apache.http.impl.conn.PoolingHttpClientConnectionManager.leaseConnection(PoolingHttpClientConnectionManager.java:316)
   	at com.amazonaws.thirdparty.apache.http.impl.conn.PoolingHttpClientConnectionManager$1.get(PoolingHttpClientConnectionManager.java:282)
   	at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at com.amazonaws.http.conn.ClientConnectionRequestFactory$Handler.invoke(ClientConnectionRequestFactory.java:70)
   	at com.amazonaws.http.conn.$Proxy23.get(Unknown Source)
   	at com.amazonaws.thirdparty.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:190)
   	at com.amazonaws.thirdparty.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
   	at com.amazonaws.thirdparty.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
   	at com.amazonaws.thirdparty.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
   	at com.amazonaws.thirdparty.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
   	at com.amazonaws.http.apache.client.impl.SdkHttpClient.execute(SdkHttpClient.java:72)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeOneRequest(AmazonHttpClient.java:1333)
   	at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1145)
   ```
   


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

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org.apache.org

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


[GitHub] [hudi] zhangzhaohuazai commented on issue #9254: [SUPPORT].exception.HoodieIOException: Could not load filesystem view storage properties from s3a://**/.hoodie/.aux/view_storage_conf.properties

Posted by "zhangzhaohuazai (via GitHub)" <gi...@apache.org>.
zhangzhaohuazai commented on issue #9254:
URL: https://github.com/apache/hudi/issues/9254#issuecomment-1645180741

   mysql flink sql to hudi hive:
   ```CREATE TABLE metasource_sync_hudi01(
   id bigint ,
   name string,
   birthday TIMESTAMP(3),
   ts TIMESTAMP(3),
   `partition` VARCHAR(20),
   _hoodie_is_deleted BOOLEAN,
   primary key(id) not enforced
   )
   with(
   'connector'='hudi'
   ,'path'= 's3a://metadatahudi/metasource_sync_hudi24/'
   ,'hadoop.fs.s3a.path.style.access' = 'true'
   ,'hoodie.datasource.write.recordkey.field'= 'id'
   ,'write.precombine.field'= 'ts'
   ,'write.tasks'= '8'
   ,'write.rate.limit'= '65000'
   ,'table.type'= 'MERGE_ON_READ'
   ,'compaction.tasks'= '4'
   ,'compaction.schedule.enabled'= 'true'
   ,'compaction.async.enabled'= 'true'
   ,'compaction.trigger.strategy'= 'num_commits'
   ,'compaction.delta_commits'= '1'
   ,'changelog.enabled'= 'true'
   ,'read.streaming.enabled'= 'true'
   ,'read.streaming.check-interval'= '3'
   ,'hive_sync.enable'= 'true'
   ,'hive_sync.mode'= 'hms'
   ,'hive_sync.metastore.uris'= 'thrift://***:9083'
   ,'hive_sync.db'= 'metadata_hudi24'
   ,'hive_sync.table'= 'metadata_hudi_24'
   ,'hive_sync.support_timestamp'= 'true'
   );```


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

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

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


[GitHub] [hudi] zhangzhaohuazai commented on issue #9254: [SUPPORT].exception.HoodieIOException: Could not load filesystem view storage properties from s3a://**/.hoodie/.aux/view_storage_conf.properties

Posted by "zhangzhaohuazai (via GitHub)" <gi...@apache.org>.
zhangzhaohuazai commented on issue #9254:
URL: https://github.com/apache/hudi/issues/9254#issuecomment-1645181663

   my flink sql to hudi:
   ```
   CREATE TABLE metasource_sync_hudi01(
   id bigint ,
   name string,
   birthday TIMESTAMP(3),
   ts TIMESTAMP(3),
   `partition` VARCHAR(20),
   _hoodie_is_deleted BOOLEAN,
   primary key(id) not enforced
   )
   with(
   'connector'='hudi'
   ,'path'= 's3a://metadatahudi/metasource_sync_hudi24/'
   ,'hadoop.fs.s3a.path.style.access' = 'true'
   ,'hoodie.datasource.write.recordkey.field'= 'id'
   ,'write.precombine.field'= 'ts'
   ,'write.tasks'= '8'
   ,'write.rate.limit'= '65000'
   ,'table.type'= 'MERGE_ON_READ'
   ,'compaction.tasks'= '4'
   ,'compaction.schedule.enabled'= 'true'
   ,'compaction.async.enabled'= 'true'
   ,'compaction.trigger.strategy'= 'num_commits'
   ,'compaction.delta_commits'= '1'
   ,'changelog.enabled'= 'true'
   ,'read.streaming.enabled'= 'true'
   ,'read.streaming.check-interval'= '3'
   ,'hive_sync.enable'= 'true'
   ,'hive_sync.mode'= 'hms'
   ,'hive_sync.metastore.uris'= 'thrift://***:9083'
   ,'hive_sync.db'= 'metadata_hudi24'
   ,'hive_sync.table'= 'metadata_hudi_24'
   ,'hive_sync.support_timestamp'= 'true'
   );
   ```


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

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

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


[GitHub] [hudi] zhangzhaohuazai commented on issue #9254: [SUPPORT].exception.HoodieIOException: Could not load filesystem view storage properties from s3a://**/.hoodie/.aux/view_storage_conf.properties

Posted by "zhangzhaohuazai (via GitHub)" <gi...@apache.org>.
zhangzhaohuazai commented on issue #9254:
URL: https://github.com/apache/hudi/issues/9254#issuecomment-1646790547

   I am now increasing the s3 time configuration of core-site.xml:
   ![image](https://github.com/apache/hudi/assets/28680957/6fe847f7-85b2-48a7-a60d-2cfdc9c626ba)
   
   but I am reporting a new error when the number of table writes is approaching 10 million:
   ```
   2023-07-23 07:23:27
   org.apache.flink.util.FlinkException: Global failure triggered by OperatorCoordinator for 'stream_write: metasource_sync_hudi01' (operator 8217d97d977888787b7cc15b629051fb).
       at org.apache.flink.runtime.operators.coordination.OperatorCoordinatorHolder$LazyInitializedCoordinatorContext.failJob(OperatorCoordinatorHolder.java:545)
       at org.apache.hudi.sink.StreamWriteOperatorCoordinator.lambda$start$0(StreamWriteOperatorCoordinator.java:187)
       at org.apache.hudi.sink.utils.NonThrownExecutor.handleException(NonThrownExecutor.java:146)
       at org.apache.hudi.sink.utils.NonThrownExecutor.lambda$wrapAction$0(NonThrownExecutor.java:133)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
       at java.lang.Thread.run(Thread.java:750)
   Caused by: org.apache.hudi.exception.HoodieException: Executor executes action [commits the instant 20230723072228761] error
       ... 6 more
   Caused by: org.apache.hudi.exception.HoodieException: Error fetching partition paths from metadata table
       at org.apache.hudi.common.fs.FSUtils.getAllPartitionPaths(FSUtils.java:318)
       at org.apache.hudi.table.action.compact.HoodieCompactor.generateCompactionPlan(HoodieCompactor.java:279)
       at org.apache.hudi.table.action.compact.ScheduleCompactionActionExecutor.scheduleCompaction(ScheduleCompactionActionExecutor.java:123)
       at org.apache.hudi.table.action.compact.ScheduleCompactionActionExecutor.execute(ScheduleCompactionActionExecutor.java:93)
       at org.apache.hudi.table.HoodieFlinkMergeOnReadTable.scheduleCompaction(HoodieFlinkMergeOnReadTable.java:112)
       at org.apache.hudi.client.BaseHoodieWriteClient.scheduleTableServiceInternal(BaseHoodieWriteClient.java:1349)
       at org.apache.hudi.client.BaseHoodieWriteClient.scheduleTableService(BaseHoodieWriteClient.java:1326)
       at org.apache.hudi.client.BaseHoodieWriteClient.scheduleCompactionAtInstant(BaseHoodieWriteClient.java:1005)
       at org.apache.hudi.client.BaseHoodieWriteClient.scheduleCompaction(BaseHoodieWriteClient.java:996)
       at org.apache.hudi.util.CompactionUtil.scheduleCompaction(CompactionUtil.java:65)
       at org.apache.hudi.sink.StreamWriteOperatorCoordinator.lambda$notifyCheckpointComplete$2(StreamWriteOperatorCoordinator.java:246)
       at org.apache.hudi.sink.utils.NonThrownExecutor.lambda$wrapAction$0(NonThrownExecutor.java:130)
       ... 3 more
   Caused by: org.apache.hudi.exception.HoodieException: Error occurs when executing flatMap
       at org.apache.hudi.common.function.FunctionWrapper.lambda$throwingFlatMapWrapper$1(FunctionWrapper.java:50)
       at java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:267)
       at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
       at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
       at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
       at java.util.stream.ReduceOps$ReduceTask.doLeaf(ReduceOps.java:747)
       at java.util.stream.ReduceOps$ReduceTask.doLeaf(ReduceOps.java:721)
       at java.util.stream.AbstractTask.compute(AbstractTask.java:316)
       at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731)
       at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
       at java.util.concurrent.ForkJoinTask.doInvoke(ForkJoinTask.java:401)
       at java.util.concurrent.ForkJoinTask.invoke(ForkJoinTask.java:734)
       at java.util.stream.ReduceOps$ReduceOp.evaluateParallel(ReduceOps.java:714)
       at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:233)
       at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
       at org.apache.hudi.client.common.HoodieFlinkEngineContext.flatMap(HoodieFlinkEngineContext.java:135)
       at org.apache.hudi.metadata.FileSystemBackedTableMetadata.getAllPartitionPaths(FileSystemBackedTableMetadata.java:86)
       at org.apache.hudi.common.fs.FSUtils.getAllPartitionPaths(FSUtils.java:316)
       ... 14 more
   Caused by: java.io.FileNotFoundException: No such file or directory: s3a://metadatahudi/metasource_sync_hudi28/e5aff3d2-d85a-4598-8581-81bf235d7be4_2-4-0_20230723065928010.parquet
       at org.apache.hadoop.fs.s3a.S3AFileSystem.s3GetFileStatus(S3AFileSystem.java:2344)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.innerGetFileStatus(S3AFileSystem.java:2226)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.getFileStatus(S3AFileSystem.java:2160)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.innerListStatus(S3AFileSystem.java:1961)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.lambda$listStatus$9(S3AFileSystem.java:1940)
       at org.apache.hadoop.fs.s3a.Invoker.once(Invoker.java:109)
       at org.apache.hadoop.fs.s3a.S3AFileSystem.listStatus(S3AFileSystem.java:1940)
       at org.apache.hudi.metadata.FileSystemBackedTableMetadata.lambda$getAllPartitionPaths$4e4c112d$1(FileSystemBackedTableMetadata.java:88)
       at org.apache.hudi.common.function.FunctionWrapper.lambda$throwingFlatMapWrapper$1(FunctionWrapper.java:48)
       ... 31 more
   
   ```
   And flink restarts after encountering this error, restarting a new round of data writing


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

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

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


[GitHub] [hudi] danny0405 commented on issue #9254: [SUPPORT].exception.HoodieIOException: Could not load filesystem view storage properties from s3a://**/.hoodie/.aux/view_storage_conf.properties

Posted by "danny0405 (via GitHub)" <gi...@apache.org>.
danny0405 commented on issue #9254:
URL: https://github.com/apache/hudi/issues/9254#issuecomment-1645219907

   It seems a regular exception when job terminates:
   
   > at java.lang.Thread.run(Thread.java:750)
       Suppressed: java.lang.NullPointerException
           at org.apache.hudi.sink.partitioner.BucketAssignFunction.close(
   
   Do you have other exceptions in your Flink job?


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

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

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


[GitHub] [hudi] danny0405 commented on issue #9254: [SUPPORT].exception.HoodieIOException: Could not load filesystem view storage properties from s3a://**/.hoodie/.aux/view_storage_conf.properties

Posted by "danny0405 (via GitHub)" <gi...@apache.org>.
danny0405 commented on issue #9254:
URL: https://github.com/apache/hudi/issues/9254#issuecomment-1647119802

   Can you try 0.12.3 instead?


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

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

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