Hello, I have a website made with ASP.NET that run with Mono on CentOS. I switched from mysql to postgre because I was getting lot of bugs with mysql drivers. I get lot of bugs with Npgsql 1.0.0 driver or Npgsql 2.0 beta3 driver with mono 1.2.6 or mono 1.9 beta3. This error are partially reproductible. If i hit refresh on the navigator the page is sometimes displayed succesfully, sometimes I get the same error or another error.
When I develop the website on Windows XP / IIS I never get any errors. I would like to know if someone experience problems with Npgsql driver 1.0.0 or 2.0 beta3(I don't use 1.0.1) ? I asked for help on Npgsql forums, here is the link to the discussion http://pgfoundry.org/forum/forum.php?thread_id=1629&forum_id=519 In advance thanks, Cornu Nicolas ---------------------------------------------------------------------------------------------------------------------- Offending URL: http://www.syndica.fr/article.aspx?articleid=1ae22922ac225be4942fa39e249ab90c Source: System.Web Message: Exception has been thrown by the target of an invocation. Stack trace: at System.Web.UI.Page.ProcessException (System.Exception e) [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] at System.Web.HttpApplication+<>c__CompilerGenerated2.MoveNext () [0x00000] at System.Web.HttpApplication.Tick () [0x00000] Complete stack trace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.ADOException: could not execute query [ select feeditem0_.hash as hash4_, feeditem0_.feed_link as feed2_4_, feeditem0_.link as link4_, feeditem0_.parent_feed_hash as parent4_4_, feeditem0_.date as date4_, feeditem0_.title as title4_, feeditem0_.content as content4_, feeditem0_.author as author4_, feeditem0_.category as category4_ from feeds_items feeditem0_ where (feeditem0_.parent_feed_hash IN(select feed1_.hash from feeds feed1_ where (feed1_.suggested_category_id='6c9e3180bd4a41c08db94500ac397dad' ))) order by feeditem0_.date DESC LIMIT 14 OFFSET 1 ] [SQL: select feeditem0_.hash as hash4_, feeditem0_.feed_link as feed2_4_, feeditem0_.link as link4_, feeditem0_.parent_feed_hash as parent4_4_, feeditem0_.date as date4_, feeditem0_.title as title4_, feeditem0_.content as content4_, feeditem0_.author as author4_, feeditem0_.category as category4_ from feeds_items feeditem0_ where (feeditem0_.parent_feed_hash IN(select feed1_.hash from feeds feed1_ where (feed1_.suggested_category_id='6c9e3180bd4a41c08db94500ac397dad' ))) order by feeditem0_.date DESC LIMIT 14 OFFSET 1] ---> System.NullReferenceException: Object reference not set to an instance of an object at Npgsql.NpgsqlState.ProcessBackendResponses_Ver_3 (Npgsql.NpgsqlConnector context) [0x00000] at Npgsql.NpgsqlState.ProcessBackendResponses (Npgsql.NpgsqlConnector context) [0x00000] at Npgsql.NpgsqlReadyState.Query (Npgsql.NpgsqlConnector context, Npgsql.NpgsqlCommand command) [0x00000] at Npgsql.NpgsqlConnector.Query (Npgsql.NpgsqlCommand queryCommand) [0x00000] at Npgsql.NpgsqlCommand.ExecuteCommand () [0x00000] at Npgsql.NpgsqlCommand.ExecuteReader (CommandBehavior cb) [0x00000] at Npgsql.NpgsqlCommand.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] at System.Data.Common.DbCommand.ExecuteReader () [0x00000] at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] at NHibernate.Impl.BatcherImpl.ExecuteReader (IDbCommand cmd) [0x00000] at NHibernate.Loader.Loader.GetResultSet (IDbCommand st, NHibernate.Engine.RowSelection selection, ISessionImplementor session) [0x00000] --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Loader.Loader.ListIgnoreQueryCache (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Loader.Loader.List (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, ISet querySpaces, NHibernate.Type.IType[] resultTypes) [0x00000] at NHibernate.Hql.Classic.QueryTranslator.List (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Impl.SessionImpl.Find (System.String query, NHibernate.Engine.QueryParameters parameters, IList results) [0x00000] --- End of inner exception stack trace --- at System.Web.UI.Page.ProcessException (System.Exception e) [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] at System.Web.HttpApplication+<>c__CompilerGenerated2.MoveNext () [0x00000] at System.Web.HttpApplication.Tick () [0x00000] -------------------------------------------------------------------------------------------------------------------------------- Offending URL: http://www.syndica.fr/article.aspx?articleid=0f7795d47727c134dead6a2596579274 Source: System.Web Message: Exception has been thrown by the target of an invocation. Stack trace: at System.Web.UI.Page.ProcessException (System.Exception e) [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] at System.Web.HttpApplication+<>c__CompilerGenerated2.MoveNext () [0x00000] at System.Web.HttpApplication.Tick () [0x00000] Complete stack trace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.ADOException: could not execute query [ SELECT count(*) as c FROM feeds_items fi, feeds f WHERE fi.parent_feed_hash = f.hash AND f.suggested_category_id = '6fbdcdb861f44f109d8a3f993d06c659' ] [SQL: SELECT count(*) as c FROM feeds_items fi, feeds f WHERE fi.parent_feed_hash = f.hash AND f.suggested_category_id = '6fbdcdb861f44f109d8a3f993d06c659'] ---> System.NullReferenceException: Object reference not set to an instance of an object at Npgsql.NpgsqlState.ProcessBackendResponses_Ver_3 (Npgsql.NpgsqlConnector context) [0x00000] at Npgsql.NpgsqlState.ProcessBackendResponses (Npgsql.NpgsqlConnector context) [0x00000] at Npgsql.NpgsqlReadyState.Query (Npgsql.NpgsqlConnector context, Npgsql.NpgsqlCommand command) [0x00000] at Npgsql.NpgsqlConnector.Query (Npgsql.NpgsqlCommand queryCommand) [0x00000] at Npgsql.NpgsqlCommand.ExecuteCommand () [0x00000] at Npgsql.NpgsqlCommand.ExecuteReader (CommandBehavior cb) [0x00000] at Npgsql.NpgsqlCommand.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] at System.Data.Common.DbCommand.ExecuteReader () [0x00000] at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] at NHibernate.Impl.BatcherImpl.ExecuteReader (IDbCommand cmd) [0x00000] at NHibernate.Loader.Loader.GetResultSet (IDbCommand st, NHibernate.Engine.RowSelection selection, ISessionImplementor session) [0x00000] --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Loader.Loader.ListIgnoreQueryCache (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Loader.Loader.List (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, ISet querySpaces, NHibernate.Type.IType[] resultTypes) [0x00000] at NHibernate.Loader.Custom.CustomLoader.List (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Impl.SessionImpl.ListCustomQuery (ICustomQuery customQuery, NHibernate.Engine.QueryParameters queryParameters, IList results) [0x00000] at NHibernate.Impl.SessionImpl.List (NHibernate.Engine.Query.NativeSQLQuerySpecification spec, NHibernate.Engine.QueryParameters queryParameters, IList results) [0x00000] at NHibernate.Impl.SessionImpl.List (NHibernate.Engine.Query.NativeSQLQuerySpecification spec, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Impl.SqlQueryImpl.List () [0x00000] at NHibernate.Impl.AbstractQueryImpl.UniqueResult () [0x00000] at NHibernate.Impl.AbstractQueryImpl.UniqueResult[Int32] () [0x00000] at syndica.Library.DataLayer.FeedItemsManager.GetFeedsItems (ISession Session, System.String CategoryHash, Int32 MinResult, Int32 MaxResult) [0x00000] at article.Page_Load (System.Object sender, System.EventArgs e) [0x00000] at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] at System.Web.UI.Control.LoadRecursive () [0x00000] at System.Web.UI.Page.ProcessLoad () [0x00000] at System.Web.UI.Page.ProcessPostData () [0x00000] at System.Web.UI.Page.InternalProcessRequest () [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] --- End of inner exception stack trace --- at System.Web.UI.Page.ProcessException (System.Exception e) [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] at System.Web.HttpApplication+<>c__CompilerGenerated2.MoveNext () [0x00000] at System.Web.HttpApplication.Tick () [0x00000] ------------------------------------------------------------------------------------------------------- Offending URL: http://www.syndica.fr/article.aspx?articleid=1c315ffc41801a9983eae7a54b50904e Source: System.Web Message: Exception has been thrown by the target of an invocation. Stack trace: at System.Web.UI.Page.ProcessException (System.Exception e) [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] at System.Web.HttpApplication+<>c__CompilerGenerated2.MoveNext () [0x00000] at System.Web.HttpApplication.Tick () [0x00000] Complete stack trace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.ADOException: could not execute query [ SELECT count(*) as c FROM feeds_items fi, feeds f WHERE fi.parent_feed_hash = f.hash AND f.suggested_category_id = 'd4209925822e4b2fbf064ffe7c7e44c4' ] [SQL: SELECT count(*) as c FROM feeds_items fi, feeds f WHERE fi.parent_feed_hash = f.hash AND f.suggested_category_id = 'd4209925822e4b2fbf064ffe7c7e44c4'] ---> System.ObjectDisposedException: The object was used after being disposed. at System.Net.Sockets.NetworkStream.CheckDisposed () [0x00000] at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, Int32 offset, Int32 size) [0x00000] at System.IO.BufferedStream.Read (System.Byte[] array, Int32 offset, Int32 count) [0x00000] at System.IO.BufferedStream.ReadByte () [0x00000] at Npgsql.NpgsqlState.ProcessBackendResponses_Ver_3 (Npgsql.NpgsqlConnector context) [0x00000] at Npgsql.NpgsqlState.ProcessBackendResponses (Npgsql.NpgsqlConnector context) [0x00000] at Npgsql.NpgsqlReadyState.Query (Npgsql.NpgsqlConnector context, Npgsql.NpgsqlCommand command) [0x00000] at Npgsql.NpgsqlConnector.Query (Npgsql.NpgsqlCommand queryCommand) [0x00000] at Npgsql.NpgsqlCommand.ExecuteCommand () [0x00000] at Npgsql.NpgsqlCommand.ExecuteReader (CommandBehavior cb) [0x00000] at Npgsql.NpgsqlCommand.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] at System.Data.Common.DbCommand.ExecuteReader () [0x00000] at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] at NHibernate.Impl.BatcherImpl.ExecuteReader (IDbCommand cmd) [0x00000] at NHibernate.Loader.Loader.GetResultSet (IDbCommand st, NHibernate.Engine.RowSelection selection, ISessionImplementor session) [0x00000] --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Loader.Loader.ListIgnoreQueryCache (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Loader.Loader.List (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, ISet querySpaces, NHibernate.Type.IType[] resultTypes) [0x00000] at NHibernate.Loader.Custom.CustomLoader.List (ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Impl.SessionImpl.ListCustomQuery (ICustomQuery customQuery, NHibernate.Engine.QueryParameters queryParameters, IList results) [0x00000] at NHibernate.Impl.SessionImpl.List (NHibernate.Engine.Query.NativeSQLQuerySpecification spec, NHibernate.Engine.QueryParameters queryParameters, IList results) [0x00000] at NHibernate.Impl.SessionImpl.List (NHibernate.Engine.Query.NativeSQLQuerySpecification spec, NHibernate.Engine.QueryParameters queryParameters) [0x00000] at NHibernate.Impl.SqlQueryImpl.List () [0x00000] at NHibernate.Impl.AbstractQueryImpl.UniqueResult () [0x00000] at NHibernate.Impl.AbstractQueryImpl.UniqueResult[Int32] () [0x00000] at syndica.Library.DataLayer.FeedItemsManager.GetFeedsItems (ISession Session, System.String CategoryHash, Int32 MinResult, Int32 MaxResult) [0x00000] at article.Page_Load (System.Object sender, System.EventArgs e) [0x00000] at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] at System.Web.UI.Control.LoadRecursive () [0x00000] at System.Web.UI.Page.ProcessLoad () [0x00000] at System.Web.UI.Page.ProcessPostData () [0x00000] at System.Web.UI.Page.InternalProcessRequest () [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] --- End of inner exception stack trace --- at System.Web.UI.Page.ProcessException (System.Exception e) [0x00000] at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] at System.Web.HttpApplication+<>c__CompilerGenerated2.MoveNext () [0x00000] at System.Web.HttpApplication.Tick () [0x00000] ------------------------------------------------------------------------------------------------------------------------------ In advance Thanks, Cornu Nicolas _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
