idies / pyJHTDB

Python wrapper for the Johns Hopkins turbulence database library
Apache License 2.0
96 stars 47 forks source link

Jupyter Python kernels dying on multiple requests to channel dataset #21

Closed petebachant closed 4 years ago

petebachant commented 6 years ago

Seems like the service should at least raise an exception instead of killing kernels. I am getting this issue with the channel flow dataset. I am requesting data at an existing point in the domain (according to the dataset info) for all times. Do these perhaps change with time? Is there a request to get a time averaged value of a given quantity at a given point in the domain?

0: SOAP 1.2 fault: SOAP-ENV:Receiver [no subcode]
"System.Web.Services.Protocols.SoapException: Server was unable to process reque
st. ---> System.Data.SqlClient.SqlException: OLE DB provider 'STREAM' for linked
 server '(null)' returned invalid data for column '[!BulkInsert].x'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand
 cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCo
pyHandler)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkC
opySimpleResultSet internalResults, String updateBulkCommandText, CancellationTo
ken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimple
ResultSet internalResults, String updateBulkCommandText, CancellationToken cts,
TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet
 internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompl
etionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(
BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSo
urce`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(Cancellat
ionToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationT
oken ctoken)
   at System.Data.SqlClient.S