Page MenuHomePhabricator

MySQL client NullReferenceException
Closed, MigratedPublic

Description

2019-05-25 01:05:54,016 [Thread Pool Worker] ERROR Helpmebot.Background.CategoryWatcherBackgroundService [(null)] - Error encountered during catwatcher run
NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.channel_id as channel1_3_0_, this_.channel_name as channel2_3_0_, this_.channel_password as channel3_3_0_, this_.channel_enabled as channel4_3_0_, this_.autolink as autolink3_0_, this_.silence as silence3_0_, this_.hedgehog as hedgehog3_0_, this_.basewiki as basewiki3_0_ FROM channel this_ WHERE this_.channel_name = ?p0 ]
  Name:cp0 - Value:##stwalkerster
[SQL: SELECT this_.channel_id as channel1_3_0_, this_.channel_name as channel2_3_0_, this_.channel_password as channel3_3_0_, this_.channel_enabled as channel4_3_0_, this_.autolink as autolink3_0_, this_.silence as silence3_0_, this_.hedgehog as hedgehog3_0_, this_.basewiki as basewiki3_0_ FROM channel this_ WHERE this_.channel_name = ?p0] ---> System.NullReferenceException: Object reference not set to an instance of an object
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x001d5] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00251] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <8051f3898298485d9e8510b51445dcd7>:0 
  at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] in <dae9d897f85e430e83bbd1fe4277bb5b>:0 
  at NHibernate.AdoNet.AbstractBatcher.ExecuteReader (System.Data.IDbCommand cmd) [0x00065] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.GetResultSet (System.Data.IDbCommand st, System.Boolean autoDiscoverTypes, System.Boolean callable, NHibernate.Engine.RowSelection selection, NHibernate.Engine.ISessionImplementor session) [0x00086] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.DoQuery (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, System.Boolean returnProxies, NHibernate.Transform.IResultTransformer forcedResultTransformer) [0x0005d] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, System.Boolean returnProxies, NHibernate.Transform.IResultTransformer forcedResultTransformer) [0x00036] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.DoList (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, NHibernate.Transform.IResultTransformer forcedResultTransformer) [0x00020] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
   --- End of inner exception stack trace ---
  at NHibernate.Loader.Loader.DoList (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, NHibernate.Transform.IResultTransformer forcedResultTransformer) [0x00059] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.DoList (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.ListIgnoreQueryCache (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters) [0x00000] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Loader.List (NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, System.Collections.Generic.ISet`1[T] querySpaces, NHibernate.Type.IType[] resultTypes) [0x0002b] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Loader.Criteria.CriteriaLoader.List (NHibernate.Engine.ISessionImplementor session) [0x0000d] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Impl.SessionImpl.List (NHibernate.Impl.CriteriaImpl criteria, System.Collections.IList results) [0x000ba] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Impl.CriteriaImpl.List (System.Collections.IList results) [0x00006] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Impl.CriteriaImpl.List () [0x00006] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Impl.CriteriaImpl.UniqueResult () [0x00000] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at NHibernate.Impl.CriteriaImpl.UniqueResult[T] () [0x00000] in <8210282bc4024c02ab1c8fa84c45a21e>:0 
  at Helpmebot.ExtensionMethods.DatabaseExtensions.GetChannelObject (NHibernate.ISession session, System.String commandSource) [0x00016] in <ef697027244d4a8897938d053781143b>:0 
  at Helpmebot.ExtensionMethods.DatabaseExtensions.GetMediaWikiSiteObject (NHibernate.ISession session, System.String commandSource) [0x00000] in <ef697027244d4a8897938d053781143b>:0 
  at Helpmebot.Services.LinkerService.GetWikiArticleBasePath (System.String destination) [0x00000] in <ef697027244d4a8897938d053781143b>:0 
  at Helpmebot.Services.LinkerService.ConvertWikilinkToUrl (System.String destination, System.String link) [0x00061] in <ef697027244d4a8897938d053781143b>:0 
  at Helpmebot.Services.CategoryWatcherHelperService.ConstructDefaultMessage (Helpmebot.Model.WatchedCategory category, Helpmebot.Model.CategoryWatcherChannel categoryChannel, System.Collections.Generic.IReadOnlyCollection`1[T] items, System.Boolean isNew, System.Boolean describeEmptySet) [0x00050] in <ef697027244d4a8897938d053781143b>:0 
  at Helpmebot.Background.CategoryWatcherBackgroundService.TimerOnElapsed (System.Object sender, System.Timers.ElapsedEventArgs elapsedEventArgs) [0x0024f] in <ef697027244d4a8897938d053781143b>:0

Event Timeline

swalker created this task.
stwalkerster renamed this task from catwatcher null ref to MySQL client NullReferenceException.Jun 5 2019, 10:20 PM
stwalkerster moved this task from Backlog to Bugs on the Helpmebot board.
stwalkerster added a subscriber: stwalkerster.
stwalkerster claimed this task.

This issue has migrated to GitHub issues