NHibernate.Exceptions.GenericADOException: could not execute query
Hi everyone,
I have set up Courier on a new project. I have two custom data resolvers. When I am trying to send my data, I am getting an NHibernate timeout:
When I run the query manually it completes in about a second.
Here is the error / crash in my log.
2017-09-06 13:47:29,407 [41] ERROR Umbraco.Courier.Core.Extraction.RevisionExtraction - [Thread 41] There was a problem with extracting database information for the item: CurrentItem is null
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT cmsPropertyData.dataNvarchar, cmsPropertyData.dataNtext, umbracoNode.id, umbracoNode.uniqueID
FROM cmsPropertyData
INNER JOIN cmsPropertyType ON cmsPropertyType.id = cmsPropertyData.propertytypeid
INNER JOIN umbracoNode ON umbracoNode.id = cmsPropertyData.contentNodeId
WHERE cmsPropertyType.Alias = (@p0) AND umbracoNode.nodeObjectType = (@p1)
AND (cmsPropertyData.dataNvarchar IS NOT NULL OR cmsPropertyData.dataNtext IS NOT NULL) ]
Name:alias - Value:umbracoFile Name:nodeObjectType - Value:b796f64c-1f99-4ffb-b886-4bf4bc011a9c
[SQL: SELECT cmsPropertyData.dataNvarchar, cmsPropertyData.dataNtext, umbracoNode.id, umbracoNode.uniqueID
FROM cmsPropertyData
INNER JOIN cmsPropertyType ON cmsPropertyType.id = cmsPropertyData.propertytypeid
INNER JOIN umbracoNode ON umbracoNode.id = cmsPropertyData.contentNodeId
WHERE cmsPropertyType.Alias = (@p0) AND umbracoNode.nodeObjectType = (@p1)
AND (cmsPropertyData.dataNvarchar IS NOT NULL OR cmsPropertyData.dataNtext IS NOT NULL)] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject 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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
--- End of inner exception stack trace ---
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
at NHibernate.Impl.StatelessSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
at NHibernate.Impl.SqlQueryImpl.List(IList results)
at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.MediaHelper.<>c__DisplayClass2.<GetOrCreateMediaPathCache>b__0(Object x)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.MediaHelper.GetOrCreateMediaPathCache(Func`2 sqlQueryFactory)
at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.MediaHelper.GetMediaGuidByPath(String mediaPath)
at Umbraco.Courier.Persistence.V6.NHibernate.NHibernateProvider.GetUniqueIdFromMediaFile(String filePath)
at Umbraco.Courier.DataResolvers.Helpers.ImagesResolver.AddImageDependenciesForValue(String value, Item item)
at Umbraco.Courier.DataResolvers.GridCellDataResolvers.CoreCellEditorResolver.HandleRte(Item item, ContentProperty propertyData, GridValueControlModel cell, Boolean packing)
at Umbraco.Courier.DataResolvers.GridCellDataResolvers.CoreCellEditorResolver.HandleCoreCellEditors(Item item, ContentProperty propertyData, GridValueControlModel cell, Boolean packing)
at Umbraco.Courier.DataResolvers.GridCellDataResolvers.CoreCellEditorResolver.ExtractingCell(Item item, ContentProperty propertyData, GridValueControlModel cell)
at Umbraco.Courier.DataResolvers.PropertyDataResolvers.GridCellResolverProvider.ExtractingProperty(Item item, ContentProperty propertyData)
at Umbraco.Courier.DataResolvers.PropertyDataResolverProvider.Extracting(Item item)
at Umbraco.Courier.Core.ResolutionManager.ExecuteResolver(Item item, ItemEvent e, ItemProvider provider)
at Umbraco.Courier.Core.ItemProvider.Extract(Item item)
at Umbraco.Courier.RepositoryProviders.Local.ExtractItem(Item item, Boolean overwrite)
at Umbraco.Courier.RepositoryProviders.Webservices.Repository.ExtractItems(String sessionKey, SerializedItemWrapper[] items, Boolean overWrite)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.EndInvoke(IAsyncResult asyncResult)
at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.EndExtractItems(IAsyncResult asyncResult)
at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.ExtractItems(Item[] items, Boolean overWrite)
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractItems(List`1 nodes)
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()
2017-09-06 13:47:29,412 [41] DEBUG Umbraco.Courier.Persistence.V6.NHibernate.NHibernateProvider - [Thread 41] Closing session, UseGlobalSession: False, key: 5460a37d-3c6d-4134-a389-279ec55299d6
Had a similar issue today with "There was a problem with extracting database information for the item: CurrentItem is null". In our case we were trying to move PDF files from staging to production and the server was erroring with 500 codes and stack traces.
The situation was resolved by using Courier to sync the File media type, even though there was no visible difference between the definitions on stage and prod.
NHibernate.Exceptions.GenericADOException: could not execute query
Hi everyone,
I have set up Courier on a new project. I have two custom data resolvers. When I am trying to send my data, I am getting an NHibernate timeout:
When I run the query manually it completes in about a second.
Here is the error / crash in my log.
What are my next steps?
Hi Sam
I saw the same error on Umbraco 6.2.3 installation, did you solve the issue?
Thanks,
Alex
Hi Alex.
No, we have not solved the issue.
We have an open issue against courier - http://issues.umbraco.org/issue/COU-627
No one from the Umbraco team has picked it up unfortunately.
Had a similar issue today with "There was a problem with extracting database information for the item: CurrentItem is null". In our case we were trying to move PDF files from staging to production and the server was erroring with 500 codes and stack traces.
The situation was resolved by using Courier to sync the File media type, even though there was no visible difference between the definitions on stage and prod.
is working on a reply...