[Mono-bugs] [Bug 370514] New: Lots of Npgsql random errors

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Thu Mar 13 13:24:34 EDT 2008 

https://bugzilla.novell.com/show_bug.cgi?id=370514


           Summary: Lots of Npgsql random errors
           Product: Mono: Class Libraries
           Version: 1.9.0
          Platform: i686
        OS/Version: RHEL 5
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Web
        AssignedTo: mhabersack at novell.com
        ReportedBy: nicolas.cornu at cyber-developpement.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---


Description of Problem:

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 errors are randoms.

On Windows XP/IIS I never get any errors.

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

Steps to reproduce the problem:
1. Visit
http://www.syndica.fr/article.aspx?articleid=2e13f6dd02fc4ca0e0b3167183429161
2. Refresh the page to get an error.


Actual Results:

Exceptions of different type.

Expected Results:

Result of the query

How often does this happen? 

Often (1/3)

Additional Information:

----------------------------------------------------------------------------------------------------------------------

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]


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

More information about the mono-bugs mailing list