Lock request time out period exceeded

9 posts, 0 answers
  1. FISCAL
    FISCAL avatar
    91 posts
    Member since:
    May 2010

    Posted 29 Oct 2010 Link to this post

    Hi,

    Processing & dumping 200k size csv file into one of the SQL table and at the same time if some other user tries to access the same table where still it is dumping records, I get the following error- 

    [This is a ASP.NET driven application with the use of Telerik ORM version 2010.2.714.1]

    Message: Telerik.OpenAccess.RT.sql.SQLException: Lock request time out period exceeded. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.next() at OpenAccessRuntime.Relational.fetch.FetchResultImp.rsNext() at OpenAccessRuntime.Relational.fetch.FetchResultImp.hasNext()

    Source: Telerik.OpenAccess.Runtime

    StackTrace: System.Exception Throw()

    Full Error Log:
     Telerik.OpenAccess.Exceptions.LockNotGrantedException: Telerik.OpenAccess.RT.sql.SQLException: Lock request time out period exceeded. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.next() at OpenAccessRuntime.Relational.fetch.FetchResultImp.rsNext() at OpenAccessRuntime.Relational.fetch.FetchResultImp.hasNext() at Telerik.OpenAccess.RT.ExceptionWrapper.Throw() at OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.executeQueryAll(ApplicationContext context, ImmutableQueryDetails query, CompiledQuery compiledQuery, Object[] para, Int32 skip, Int32 take) at OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getAllQueryResults(CompiledQuery cq, Object[] para, Int32 skip, Int32 take) at OpenAccessRuntime.DataObjects.OpenAccessQueryImp.executeWithArrayImp(Object[] parameters) at Telerik.OpenAccess.RT.QueryResultImpl.check() at Telerik.OpenAccess.RT.ListEnumerator.get_Count() at Telerik.OpenAccess.Query.ExpressionExecution.PerformDatabaseQuerySingle[TResult,T](Piece`1 piece, Int32& found, Int32 elemAt) at Telerik.OpenAccess.Query.ExpressionExecution.PerformQuerySingle[T,TResult](Piece`1 piece, Expression expression) at Telerik.OpenAccess.Query.Piece`1.System.Linq.IQueryProvider.Execute[TResult](Expression expr) at System.Linq.Queryable.Sum(IQueryable`1 source) at APForensicsDataRepository.InvoiceAnalysis.DetectionRepository.GetTotalnvoiceValues(Int32 processID) in D:\APForensics\branches\InvoiceAnalysisModule\APForensicsDataRepository\InvoiceAnalysis\DetectionRepository.cs:line 81 at APForensicsDataRepository.InvoiceAnalysis.DetectionRepository.ListAllDPFProcess() in D:\APForensics\branches\InvoiceAnalysisModule\APForensicsDataRepository\InvoiceAnalysis\DetectionRepository.cs:line 69 at IsisWebApp.WebUI.InvoiceAnalysis.Detection.frmInvoiceDatasetListing.PopulateGrid() in D:\APForensics\branches\InvoiceAnalysisModule\APForensicsWebApp\WebUI\InvoiceAnalysis\Detection\frmViewDataList.aspx.cs:line 128 


    Any idea?

    Many thanks.

    M G

  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 29 Oct 2010 Link to this post

    Hello M G,
    Our connection pool has a timeout where we close connecrtions that are busy for a certain time, default is 2 minutes. This should show you where you have too long running operations.

    You can set this timeout to 0 which means we do not care or just increase the number of seconds. The timeout can be set in the DSL via the Model Settings Dialog or with the old wizard via Telerik->OpenAccess->Configuration->BackendConfigurations

    All the best,
    Jan Blessenohl
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
  4. FISCAL
    FISCAL avatar
    91 posts
    Member since:
    May 2010

    Posted 29 Oct 2010 Link to this post

    Many thanks Jan.

    I will try to reset to 0.

    Cheers,
    MG
  5. Ingo Oltmann
    Ingo Oltmann avatar
    44 posts
    Member since:
    Nov 2005

    Posted 02 Nov 2010 Link to this post

    Hello Jan,

    what exactly is the name of the property you are talking about?

    Regards,
    Ingo
  6. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 04 Nov 2010 Link to this post

    Hello Ingo Oltmann,
    I am talking about this:
    http://www.telerik.com/help/openaccess-orm/active-connection-timeout.html

    Or if you use the new context you have to modify the backendconfiguration before you call the context ctor with:

    backendConfig.ConnectionPool.ActiveConnectionTimeout = 1200;

    Regards,
    Jan Blessenohl
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  7. Patrice Boissonneault
    Patrice Boissonneault avatar
    18 posts
    Member since:
    Mar 2010

    Posted 07 Apr 2011 Link to this post

    What is the unit of the

    ActiveConnectionTimeout

    property?

    1200 seems like an odd number for 2 minutes?

    Thanks.
  8. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 07 Apr 2011 Link to this post

    Hello Patrice Boissonneault,
    Please have a look here.

    All the best,
    Jan Blessenohl
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  9. Patrice Boissonneault
    Patrice Boissonneault avatar
    28 posts
    Member since:
    Nov 2009

    Posted 26 Mar 2012 Link to this post

    The article you refer to is talking about seconds where are in your example, you are specifying 1200.  Does that mean 1200 seconds or are those milliseconds (in which case this would only be 1.2 second...).  I'm confused.  Can you please precise the unit of this property.
    Thanks.
  10. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 27 Mar 2012 Link to this post

    Hi Patrice,
    The documentation is right, it is in seconds. 2 minutes --> 120 seconds.

    Regards,
    Jan Blessenohl
    the Telerik team
    Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>
Back to Top
DevCraft banner