[Mono-list] Lots of Npgsql partially reproductible errors
Nicolas Cornu
nicolas.cornu at cyber-developpement.com
Tue Mar 11 16:53:11 EDT 2008
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
More information about the Mono-list
mailing list