Hi Johan, Is this problem happening all the time or is it randomly coming in? It does look like a SQL problem but if it happens after a long period of inactivity on the Manager then it might be caused by a cached connection that timed out. Please let me know if you have a way to reproduce this.
Thanks, Tibor > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:alchemi-users- > [EMAIL PROTECTED] On Behalf Of Ansink, Johan > Sent: Friday, August 04, 2006 2:29 AM > To: [email protected] > Subject: [Alchemi-users] Error > > Hello Tibor et al, > > My Grid application generates the following errors and I don't know what > to do about it. Is it a network problem or so ?? > > Thanks in advance > Johan Ansink > > > 2006-08-02 18:02:05,518 [980] DEBUG - > GenericManagerDatabaseStorage:RunSql():0 - Exception RunSql:update > executor set host='Styx', port=9001 where executor_id='6927c688-d7f4-4348- > a6b9-e33a740c3ce1' > > System.InvalidOperationException: Timeout expired. The timeout period > elapsed prior to obtaining a connection from the pool. This may have > occurred because all pooled connections were in use and max pool size was > reached. > at > System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn > ectionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > at Alchemi.Manager.Storage.GenericManagerDatabaseStorage.RunSql(String > sqlQuery, IDataParameter[] parameters) > 2006-08-02 18:02:07,768 [968] DEBUG - > GenericManagerDatabaseStorage:RunSql():0 - Exception RunSql:update > executor set is_dedicated=1, is_connected=1, usr_name='executor' where > executor_id='934204b9-528e-4052-be04-e514582704a4' > > System.InvalidOperationException: Timeout expired. The timeout period > elapsed prior to obtaining a connection from the pool. This may have > occurred because all pooled connections were in use and max pool size was > reached. > at > System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn > ectionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > at Alchemi.Manager.Storage.GenericManagerDatabaseStorage.RunSql(String > sqlQuery, IDataParameter[] parameters) > 2006-08-02 18:02:09,674 [596] DEBUG - ManagerContainer:Watchdog():0 - > Error in WatchDog thread. Continuing after error... > > System.InvalidOperationException: Timeout expired. The timeout period > elapsed prior to obtaining a connection from the pool. This may have > occurred because all pooled connections were in use and max pool size was > reached. > at > System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn > ectionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > at > Alchemi.Manager.Storage.GenericManagerDatabaseStorage.RunSqlReturnDataRead > er(String sqlQuery) > at > Alchemi.Manager.Storage.GenericManagerDatabaseStorage.GetExecutors(TriStat > eBoolean dedicated, TriStateBoolean connected) > at > Alchemi.Manager.ManagerContainer.DisconnectTimedOutExecutors(TimeSpan > time) > at Alchemi.Manager.ManagerContainer.Watchdog() > 2006-08-02 18:02:13,721 [2140] DEBUG - > GenericManagerDatabaseStorage:RunSql():0 - Exception RunSql:update > executor set cpu_max=2992, cpu_usage=0, cpu_avail=44, > [EMAIL PROTECTED] where executor_id='35d47250-d1e4-43c0-b45b- > 39b591ffc495' > > System.InvalidOperationException: Timeout expired. The timeout period > elapsed prior to obtaining a connection from the pool. This may have > occurred because all pooled connections were in use and max pool size was > reached. > at > System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn > ectionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > at Alchemi.Manager.Storage.GenericManagerDatabaseStorage.RunSql(String > sqlQuery, IDataParameter[] parameters) > 2006-08-02 18:02:13,799 [1972] ERROR - ScheduleDedicated thread error. > Continuing... > > System.InvalidOperationException: Timeout expired. The timeout period > elapsed prior to obtaining a connection from the pool. This may have > occurred because all pooled connections were in use and max pool size was > reached. > at > System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn > ectionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > at > Alchemi.Manager.Storage.GenericManagerDatabaseStorage.RunSqlReturnDataRead > er(String sqlQuery) > at > Alchemi.Manager.Storage.GenericManagerDatabaseStorage.GetExecutors(TriStat > eBoolean dedicated, TriStateBoolean connected) > at Alchemi.Manager.DefaultScheduler.GetNextAvailableExecutor() > at Alchemi.Manager.DefaultScheduler.ScheduleDedicated() > at Alchemi.Manager.ManagerContainer.ScheduleDedicated() > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > alchemi-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/alchemi-users ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ alchemi-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/alchemi-users
