.net - Timeout expired during select request using NHibernate -


i use nhibernate in project. diferent request different table fail genericadoexception wraps inside sqlexception: timeout expired.

example (there index on objectid)

nhibernate.exceptions.genericadoexception: not execute query [ select user_15f5e0_.id col_0_0_, user_15f5e0_.objectid col_1_0_, user_15f5e0_.typename col_2_0_, user_15f5e0_.vulnerabilitylevel col_3_0_, user_15f5e0_.displayname col_4_0_, user_15f5e0_.username col_5_0_ [user] user_15f5e0_ user_15f5e0_.objectid in (@p0 , @p1 , @p2 , @p3 , @p4 , @p5 ) ]

--> system.data.sqlclient.sqlexception: timeout expired. timeout period elapsed prior completion of operation or server not responding.

---> system.componentmodel.win32exception: wait operation timed out

it's 1 request via webapi, without different activitis in other threads. according logs there no opend transactions. thought main reason not commited transaction, these exceptions occure undeterminated whithout "write" activity.

can explain can main reason of errors?

in case helps:

to me turned out issue related not closing transactions (not calling dispose, nor eclosed "using" block).


Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -