DLT Autoloader stuck in reading Avro files from Azure blob storage

[kurokaj]

I have a DLT pipeline joining data from streaming tables to metadata of Avro files located in Azure blob storage. The avro files are loaded using autoloader. Up until 25.3. (about 20:00UTC) the pipeline worked fine, but then suddenly got stuck in initializing the avro stream. From the compute metrics its clear that the read process is stuck in some sort of loop. 

This issue is replicable also in basic notebook when running autoloader or batch loader on any number of avro files. The runs do not throw any errors, which makes the issue quite puzzling to solve. 

We have also noticed that when running autoloader/batch loader on notebook with runtime 13.3LTS, the process is successful. However if used 14.3LTS or 14.1 the process gets stuck. Any advice on the situation is appreciated. 

(SC of the frozen process.)

 

[Kaniz_Fatma]

Hi @kurokaj, 

• If the schema of the input data changes while an update is running, the update may be logged as CANC...¹. Ensure that there haven’t been any unexpected schema changes in your Avro files during the problematic period.
• Consider monitoring schema changes and handling them appropriately within your pipeline.
• Verify that your DLT pipeline components (including the autoloader) are compatible with the specific runtime versions you’re using. Check for any known issues or updates related to these versions.
• Since the pipeline isn’t throwing errors, it’s essential to gather additional diagnostic information.
• Review the compute metrics to understand where the read process is getting stuck. Look for any unusual patterns or bottlenecks.
• Consider enabling detailed logging or debugging options to capture more information during the initialization process.