.Net 2.0 error reporting

Discussions about using SIP Sorcery on your own computer/server
Aaron
Site Admin
Posts: 4652
Joined: Thu Jul 12, 2007 12:13 am

Post by Aaron » Sun Mar 21, 2010 12:05 am

Ok that error will affect the SSH server side of your sipsorcery instance but not any other servers, it happens sporadically on the main sipsorcery site as well nad I've got it on the issues list http://sipsorcery.codeplex.com/WorkItem ... temId=4154.

If you're not using SSH and want to stop the error just comment out or delete the sshserver node in your sipsorcery-appsvr.exe.config file.

However I believe the main issue you have is that the Registrar stops working? If so that error won't be hte cause.

Regards,

Aaron

jvwelzen
Posts: 716
Joined: Thu Sep 11, 2008 1:56 pm

Post by jvwelzen » Mon Mar 22, 2010 6:17 pm

Hi Aaron

Does the 1.2 release need .net frame network 4 or is 3.5 enough

Aaron
Site Admin
Posts: 4652
Joined: Thu Jul 12, 2007 12:13 am

Post by Aaron » Mon Mar 22, 2010 10:53 pm

It needs 3.5 service pack 1.

Regards,

Aaron

jvwelzen
Posts: 716
Joined: Thu Sep 11, 2008 1:56 pm

Re: .Net 2.0 error reporting

Post by jvwelzen » Wed Mar 24, 2010 5:54 am

Hi

Today the .net frame error 2.0 has happend again and now I found something in the error.log

It seems that It could not connect to the database

But I don't think It could be a database problem ( maybe an internet connection problem I need to ask my service provider in england)

Code: Select all

2010-03-24 02:06:22,726 [sipregistrar-expirebindings] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(b => (b.ExpiryTime < value(SIPSorcery.Servers.SIPRegistrarBindingsManager+<>c__DisplayClass2).expiryTime)).Select(asset => asset).FirstOrDefault(). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:22,736 [sipregistrar-expirebindings] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (where) (for SIPRegistrarBinding). b => (b.ExpiryTime < value(SIPSorcery.Servers.SIPRegistrarBindingsManager+<>c__DisplayClass2).expiryTime). MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at SIPSorcery.Persistence.SQLQueryProvider.Execute(Expression expression)
   at SIPSorcery.Persistence.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SIPSorcery.Persistence.SQLAssetPersistor`1.Get(Expression`1 whereClause)
2010-03-24 02:06:22,736 [sipregistrar-expirebindings] ERROR sipregistrar [(null)] - Exception ExpireBindings Delete. Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:23,367 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(d => (d.HangupAt <= Convert(DateTimeOffset.UtcNow))).Select(asset => asset).FirstOrDefault(). Fatal error encountered during command execution.
2010-03-24 02:06:25,460 [regagent-1] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(b => (b.NextRegistrationTime <= DateTimeOffset.UtcNow)).Select(asset => asset). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:25,460 [regagent-1] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (list) (for SIPProviderBinding). b => (b.NextRegistrationTime <= DateTimeOffset.UtcNow). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:25,460 [regagent-1] ERROR sipregagent [(null)] - Exception GetNextBindings (MySql.Data.MySqlClient.MySqlException). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:26,171 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (where) (for SIPDialogueAsset). d => (d.HangupAt <= Convert(DateTimeOffset.UtcNow)). MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at SIPSorcery.Persistence.SQLQueryProvider.Execute(Expression expression)
   at SIPSorcery.Persistence.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SIPSorcery.Persistence.SQLAssetPersistor`1.Get(Expression`1 whereClause)
2010-03-24 02:06:26,171 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception MonitorCalls Monitoring. Fatal error encountered during command execution.
2010-03-24 02:06:40,822 [sipregistrar-expirebindings] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(b => (b.ExpiryTime < value(SIPSorcery.Servers.SIPRegistrarBindingsManager+<>c__DisplayClass2).expiryTime)).Select(asset => asset).FirstOrDefault(). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:40,822 [sipregistrar-expirebindings] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (where) (for SIPRegistrarBinding). b => (b.ExpiryTime < value(SIPSorcery.Servers.SIPRegistrarBindingsManager+<>c__DisplayClass2).expiryTime). MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at SIPSorcery.Persistence.SQLQueryProvider.Execute(Expression expression)
   at SIPSorcery.Persistence.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SIPSorcery.Persistence.SQLAssetPersistor`1.Get(Expression`1 whereClause)
2010-03-24 02:06:40,832 [sipregistrar-expirebindings] ERROR sipregistrar [(null)] - Exception ExpireBindings Delete. Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:41,473 [regagent-1] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(b => (b.NextRegistrationTime <= DateTimeOffset.UtcNow)).Select(asset => asset). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:41,473 [regagent-1] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (list) (for SIPProviderBinding). b => (b.NextRegistrationTime <= DateTimeOffset.UtcNow). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:41,473 [regagent-1] ERROR sipregagent [(null)] - Exception GetNextBindings (MySql.Data.MySqlClient.MySqlException). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:42,184 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(d => (d.HangupAt <= Convert(DateTimeOffset.UtcNow))).Select(asset => asset).FirstOrDefault(). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:06:42,184 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (where) (for SIPDialogueAsset). d => (d.HangupAt <= Convert(DateTimeOffset.UtcNow)). MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at SIPSorcery.Persistence.SQLQueryProvider.Execute(Expression expression)
   at SIPSorcery.Persistence.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SIPSorcery.Persistence.SQLAssetPersistor`1.Get(Expression`1 whereClause)
2010-03-24 02:06:42,184 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception MonitorCalls Monitoring. Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,082 [sipregistrar-expirebindings] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(b => (b.ExpiryTime < value(SIPSorcery.Servers.SIPRegistrarBindingsManager+<>c__DisplayClass2).expiryTime)).Select(asset => asset).FirstOrDefault(). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,082 [regagent-1] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(b => (b.NextRegistrationTime <= DateTimeOffset.UtcNow)).Select(asset => asset). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,082 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception SQLQueryProvider Execute. .Where(d => (d.HangupAt <= Convert(DateTimeOffset.UtcNow))).Select(asset => asset).FirstOrDefault(). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,132 [regagent-1] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (list) (for SIPProviderBinding). b => (b.NextRegistrationTime <= DateTimeOffset.UtcNow). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,132 [regagent-1] ERROR sipregagent [(null)] - Exception GetNextBindings (MySql.Data.MySqlClient.MySqlException). Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,162 [sipregistrar-expirebindings] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (where) (for SIPRegistrarBinding). b => (b.ExpiryTime < value(SIPSorcery.Servers.SIPRegistrarBindingsManager+<>c__DisplayClass2).expiryTime). MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at SIPSorcery.Persistence.SQLQueryProvider.Execute(Expression expression)
   at SIPSorcery.Persistence.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SIPSorcery.Persistence.SQLAssetPersistor`1.Get(Expression`1 whereClause)
2010-03-24 02:08:18,162 [sipregistrar-expirebindings] ERROR sipregistrar [(null)] - Exception ExpireBindings Delete. Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:18,172 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Get (where) (for SIPDialogueAsset). d => (d.HangupAt <= Convert(DateTimeOffset.UtcNow)). MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at SIPSorcery.Persistence.SQLQueryProvider.Execute(Expression expression)
   at SIPSorcery.Persistence.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SIPSorcery.Persistence.SQLAssetPersistor`1.Get(Expression`1 whereClause)
2010-03-24 02:08:18,202 [sipcallmanager-monitorcalls] ERROR sipsorcery [(null)] - Exception MonitorCalls Monitoring. Unable to connect to any of the specified MySQL hosts.
2010-03-24 02:08:21,056 [sipchanneludp-3674] ERROR sipsorcery.sip [(null)] - Exception (System.ObjectDisposedException) SIPUDPChannel Send (sendto=>82.173.133.238:5060). Cannot access a disposed object.
Object name: 'System.Net.Sockets.UdpClient'.
2010-03-24 02:08:21,106 [sipchanneludp-3674] ERROR sipproxy [(null)] - Exception SIPProxyCore GotResponse. Cannot access a disposed object.
Object name: 'System.Net.Sockets.UdpClient'.
2010-03-24 02:08:21,296 [sipchanneludp-4371] ERROR sipsorcery.sip [(null)] - Exception (System.ObjectDisposedException) SIPUDPChannel Send (sendto=>127.0.0.1:5001). Cannot access a disposed object.
Object name: 'System.Net.Sockets.UdpClient'.
2010-03-24 02:08:21,296 [sipchanneludp-4371] ERROR sipproxy [(null)] - Exception SIPProxyCore GotRequest. Cannot access a disposed object.
Object name: 'System.Net.Sockets.UdpClient'.


Aaron
Site Admin
Posts: 4652
Joined: Thu Jul 12, 2007 12:13 am

Re: .Net 2.0 error reporting

Post by Aaron » Wed Mar 24, 2010 9:48 am

While it is always a good idea to get to the bottom of database issues the sipsorcery software will be able to handle a loss of connection and will simply keep trying until it's able to re-connect.

A bigger concern is this log message:

2010-03-24 02:08:21,056 [sipchanneludp-3674] ERROR sipsorcery.sip [(null)] - Exception (System.ObjectDisposedException) SIPUDPChannel Send (sendto=>82.173.133.238:5060). Cannot access a disposed object.
Object name: 'System.Net.Sockets.UdpClient'.

That's unusual and I suspect indicate something's happened to the network connection of stack on the host the sipsorcery software is running on. If the sipsorcery software loses its ability to use sockets then nothing will work and I don't know if it will be able to recover from that.

Regards,

Aaron

Post Reply