. bq . Hi Chris, thanks for the report. Could you verify how many SQL statements are actually executed? I am wondering if there are additional loading events being triggered after the first select to satisfy mandatory or eager relations
There is only the one SQL statement to satisfy the 250 row requirement. I updated our SQL Server JDBC driver to the latest provided by Microsoft to see whether it might be something related to the JDBC driver that could have been addressed and we still experience the same issue but instead of it blocking between 119 and 120, it blocks between 121 and 122 rows. I'm not sure if there is some setting on the JDBC driver that needs to be adjusted or not.
I also checked whether the GC could be running when it hits these blocking points but verbose GC logging doesn't indicate that the GC is invoked when the Loader stalls.
|
