task

FIX PROBLEM - 3299

[previously]

1. x] # PRB new 12-15 - hangs, ERROR TIMEOUT - sql connection IN CS file Book
2. *] ERROR = error connecting: 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.
3. *] records = 2094-2108 
4. x] TEST 'view' each article ind and they all work fine
5. x] TEST each parent_id record and they all work fine
6. X] MOVED each record to 12-14 (only had 1 rec 2093)  
7. *] PRB = RECORD# 2107, DONT SEE ANY PRB with record, maybe longer title, 2nd last of 14 records, 
8. x] copied CONTENT(manually) to new record 2207(co-inkydink)
9. x] TEST 12-15 =PASS, 
10. x] TEST = today(01-10 ... 11-13) PASS

1. x] PRB FIX new 11-12 
2. *] records =  1931-1945 (15)
3. x] MOVED each record to 11-13, 1 at a time, tested view,
4. X] PRB = RECORD# 1945 (the last record in the set)
5. i] REVIEW REC 1945 - dont see anything obvious
6. ] ? = is it the qty of records, 14/15 - have a record in OCT that has 15 records opening
7. x] copied CONTENT(with app) to new record 2210, (comes up OK on today)
8. x] backdateD record to 2013-11-12, TEST=PASS
9. >] EDIT task 3299 IN FIX-PRB
   1. ] # 3299 FIX-PRB-3299 - ERROR timeout ON PG view/new/{date} UPDATE with new
   2. ] multiple REPORTS, 1 for each date , ] 3626, ] 3756 ] 3764 ] 3765

[currently]

1. ]
2. ] ERROR timeout - new articles - ] >14 records, ] unique time values, ] prioity value ( 0 or -5), ] string photo NULL
3. -- 14 OK, 15 problem

[next]

1. ] -- SELECT * FROM articles WHERE created > '2014-04-29%'

 

 

---

[ERROR full description]

-- error connecting: 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.
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and

where it originated in the code.

 Exception Details: MySql.Data.MySqlClient.MySqlException: error connecting: 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.

Source Error:

 

Line 59:     public Book(int id){
Line 60:         //var qry01x="SELECT * from books WHERE id_book=@0";
Line 61:         var book  = sospep.QuerySingle(qryGetBook,id);
Line 62:         if (book !=null)
Line 63:         {
 

 Source File: 

Stack Trace:

[MySqlException (0x80004005): error connecting: 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.]

   MySql.Data.MySqlClient.MySqlPool.GetConnection() +208
   MySql.Data.MySqlClient.MySqlConnection.Open() +323
   WebMatrix.Data.Database.EnsureConnectionOpen() +44
   WebMatrix.Data.<QueryInternal>d__0.MoveNext() +66
   System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source) +164
   WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args) +103
   Book..ctor(Int32 id) in e:\HostingSpaces\dons\sospep.com\wwwroot\App_Code\Book.cs:61
   Chapter..ctor(Int32 id) in e:\HostingSpaces\dons\sospep.com\wwwroot\App_Code\Chapter.cs:66
   Article.getPath() in e:\HostingSpaces\dons\sospep.com\wwwroot\App_Code\Article.cs:543
   ASP._Page_view_new_cshtml.Execute() in e:\HostingSpaces\dons\sospep.com\wwwroot\view\new.cshtml:145
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +69
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +151
   System.Web.WebPages.StartPage.RunPage() +17
   System.Web.WebPages.StartPage.ExecutePageHierarchy() +62
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +76
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +249
 

Details

ID: 3299

NAME: FIX-PRB-3299

DESCRIPTION: {"PRB:":"ERROR -timeout MSG RESOLVED: # 2107 ON PG view/new/2013-12-15 "}

START DATE TIME: 2014-01-10 13:00:00

EST DURATION: 04:00:00

END DATE TIME: 2014-01-10 17:00:00

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

photos

actions

Agenda Email task SMS task Priorities