You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "chenwyi2 (via GitHub)" <gi...@apache.org> on 2023/09/25 03:50:18 UTC
[GitHub] [iceberg] chenwyi2 opened a new issue, #8635: spark read error with Failed to open file
chenwyi2 opened a new issue, #8635:
URL: https://github.com/apache/iceberg/issues/8635
### Query engine
spark
### Question
when i query table with spark with error:
Caused by: org.apache.iceberg.exceptions.RuntimeIOException: Failed to open file: qbfs://online01/warehouse/bi_warehouse_ods_ice.db/ods2_qos_allpay_7_72_724/metadata/eb017bb0-5b27-4180-8c0a-18a8e19671ee-m0.avro
at org.apache.iceberg.avro.AvroIterable.newFileReader(AvroIterable.java:102)
at org.apache.iceberg.avro.AvroIterable.getMetadata(AvroIterable.java:65)
at org.apache.iceberg.ManifestReader.readMetadata(ManifestReader.java:141)
at org.apache.iceberg.ManifestReader.readPartitionSpec(ManifestReader.java:121)
at org.apache.iceberg.ManifestReader.<init>(ManifestReader.java:114)
at org.apache.iceberg.ManifestFiles.read(ManifestFiles.java:131)
at org.apache.iceberg.ManifestFiles.readPaths(ManifestFiles.java:95)
at org.apache.iceberg.spark.actions.BaseSparkAction$ReadManifest.call(BaseSparkAction.java:174)
at org.apache.iceberg.spark.actions.BaseSparkAction$ReadManifest.call(BaseSparkAction.java:165)
at org.apache.spark.sql.Dataset.$anonfun$flatMap$2(Dataset.scala:2876)
at scala.collection.Iterator$$anon$11.nextCur(Iterator.scala:486)
at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:492)
at scala.collection.Iterator$$anon$10.hasNext(Iterator.scala:460)
at org.apache.spark.sql.catalyst.expressions.GeneratedClass$GeneratedIteratorForCodegenStage9.processNext(Unknown Source)
at org.apache.spark.sql.execution.BufferedRowIterator.hasNext(BufferedRowIterator.java:43)
at org.apache.spark.sql.execution.WholeStageCodegenExec$$anon$1.hasNext(WholeStageCodegenExec.scala:755)
at scala.collection.Iterator$$anon$10.hasNext(Iterator.scala:460)
at org.apache.spark.shuffle.writer.RssShuffleWriter.doWrite(RssShuffleWriter.java:200)
at org.apache.spark.shuffle.writer.RssShuffleWriter.write(RssShuffleWriter.java:167)
at org.apache.spark.shuffle.ShuffleWriteProcessor.write(ShuffleWriteProcessor.scala:59)
at org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:99)
at org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:52)
at org.apache.spark.scheduler.Task.run(Task.scala:131)
at org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:497)
at org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1470)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:500)
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:748)
Caused by: java.io.EOFException: Unexpected EOF with 4 bytes remaining to read
at org.apache.iceberg.shaded.org.apache.avro.file.DataFileReader.openReader(DataFileReader.java:67)
how can i recover? and why this happen?
--
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: issues-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
[GitHub] [iceberg] manuzhang commented on issue #8635: spark read error with Failed to open file
Posted by "manuzhang (via GitHub)" <gi...@apache.org>.
manuzhang commented on issue #8635:
URL: https://github.com/apache/iceberg/issues/8635#issuecomment-1736659842
You may verify whether your avro file is intact with Spark SQL
```sql
select * from avro.`qbfs://online01/warehouse/bi_warehouse_ods_ice.db/ods2_qos_allpay_7_72_724/metadata/eb017bb0-5b27-4180-8c0a-18a8e19671ee-m0.avro`
```
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
[GitHub] [iceberg] chenwyi2 commented on issue #8635: spark read error with Failed to open file
Posted by "chenwyi2 (via GitHub)" <gi...@apache.org>.
chenwyi2 commented on issue #8635:
URL: https://github.com/apache/iceberg/issues/8635#issuecomment-1736772804
thank you , i think this file is corrupted, but how can i recovery this file? because with this corrupted file, i cannot write or query.
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
[GitHub] [iceberg] MehulBatra commented on issue #8635: spark read error with Failed to open file
Posted by "MehulBatra (via GitHub)" <gi...@apache.org>.
MehulBatra commented on issue #8635:
URL: https://github.com/apache/iceberg/issues/8635#issuecomment-1741466631
and how this file got corrupted, as we also face this issue alot?
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] spark read error with Failed to open file [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #8635:
URL: https://github.com/apache/iceberg/issues/8635#issuecomment-2362461520
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org