(public).sospep.events ~ view task ~ FIX-PRB-3299

<h1 style="text-align: center;">FIX PROBLEM - 3299</h1>
<h2>[previously]</h2>
<ol>
<li>x] # PRB new 12-15 - hangs, ERROR TIMEOUT - sql connection IN CS file Book</li>
<li>*] ERROR = error connecting: Timeout expired. &nbsp;The timeout period elapsed prior to obtaining a connection from the pool. &nbsp;This may have occurred because all pooled connections were in use and max pool size was reached.</li>
<li>*] records = 2094-2108&nbsp;</li>
<li>x] TEST 'view' each article ind and they all work fine</li>
<li>x] TEST each parent_id record and they all work fine</li>
<li>X] MOVED each record to 12-14 (only had 1 rec 2093) &nbsp;</li>
<li>*] PRB = RECORD# 2107, DONT SEE ANY PRB with record, maybe longer title, 2nd last of 14 records,&nbsp;</li>
<li>x] copied CONTENT(manually) to new record 2207(co-inkydink)</li>
<li>x] TEST 12-15 =PASS,&nbsp;</li>
<li>x] TEST = today(01-10 ... 11-13) PASS</li>
</ol>
<div><hr /></div>
<ol>
<li>x] PRB FIX new 11-12&nbsp;</li>
<li>*] records = &nbsp;1931-1945 (15)</li>
<li>x] MOVED each record to 11-13, 1 at a time, tested view,</li>
<li>X] PRB = RECORD# 1945 (the last record in the set)</li>
<li>i] REVIEW REC 1945 - dont see anything obvious</li>
<li>] ? = is it the qty of records, 14/15 - have a record in OCT that has 15 records opening</li>
<li>x] copied CONTENT(with app) to new record 2210, (comes up OK on today)</li>
<li>x] backdateD record to 2013-11-12, TEST=PASS</li>
<li>&gt;] EDIT task 3299 IN FIX-PRB<ol>
<li>] # 3299 FIX-PRB-3299 - ERROR timeout ON PG view/new/{date} UPDATE with new</li>
<li>] multiple REPORTS, 1&nbsp;for each date , ] 3626, ] 3756 ] 3764 ] 3765</li>
</ol></li>
</ol>
<h2>[currently]</h2>
<ol>
<li>]</li>
<li>] ERROR timeout - new articles - ] &gt;14 records, ] unique time values, ] prioity value ( 0 or -5), ] string photo NULL</li>
<li>-- 14 OK, 15 problem</li>
</ol>
<h2>[next]</h2>
<ol>
<li>]&nbsp;-- SELECT * FROM articles WHERE created &gt; '2014-04-29%'</li>
</ol>
&nbsp;
&nbsp;
<hr />
[ERROR full description] -- error connecting: Timeout expired.&nbsp; The timeout period elapsed prior to obtaining a connection from the pool.&nbsp; This may have occurred because all pooled connections
were in use and max pool size was reached. &nbsp; 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.
&nbsp;Exception Details: MySql.Data.MySqlClient.MySqlException: error connecting: Timeout expired.&nbsp; The timeout period elapsed prior to obtaining a connection from the
pool.&nbsp; This may have occurred because all pooled connections were in use and max pool size was reached.
Source Error:
&nbsp;
Line 59:&nbsp;&nbsp;&nbsp;&nbsp; public Book(int id){ Line 60:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //var qry01x="SELECT * from books WHERE <a href="mailto:id_book=@0">id_book=@0</a>"; Line 61:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var book&nbsp; = sospep.QuerySingle(qryGetBook,id); Line 62:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (book !=null) Line 63:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;
&nbsp;Source File:&nbsp;
Stack Trace:
[MySqlException (0x80004005): error connecting: Timeout expired.&nbsp; The timeout period elapsed prior to obtaining a connection from the pool.&nbsp; This may have occurred because all pooled connections were in use and max pool size was reached.]
 &nbsp;&nbsp; MySql.Data.MySqlClient.MySqlPool.GetConnection() +208 &nbsp;&nbsp; MySql.Data.MySqlClient.MySqlConnection.Open() +323 &nbsp;&nbsp; WebMatrix.Data.Database.EnsureConnectionOpen() +44 &nbsp;&nbsp; WebMatrix.Data.&lt;QueryInternal&gt;d__0.MoveNext() +66 &nbsp;&nbsp; System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source) +164 &nbsp;&nbsp; WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args) +103 &nbsp;&nbsp; Book..ctor(Int32 id) in e:\HostingSpaces\dons\sospep.com\wwwroot\App_Code\Book.cs:61 &nbsp;&nbsp; Chapter..ctor(Int32 id) in e:\HostingSpaces\dons\sospep.com\wwwroot\App_Code\Chapter.cs:66 &nbsp;&nbsp; Article.getPath() in e:\HostingSpaces\dons\sospep.com\wwwroot\App_Code\Article.cs:543 &nbsp;&nbsp; ASP._Page_view_new_cshtml.Execute() in e:\HostingSpaces\dons\sospep.com\wwwroot\view\new.cshtml:145 &nbsp;&nbsp; System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197 &nbsp;&nbsp; System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +69 &nbsp;&nbsp; System.Web.WebPages.WebPage.ExecutePageHierarchy() +151 &nbsp;&nbsp; System.Web.WebPages.StartPage.RunPage() +17 &nbsp;&nbsp; System.Web.WebPages.StartPage.ExecutePageHierarchy() +62 &nbsp;&nbsp; System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +76 &nbsp;&nbsp; System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +249 &nbsp;

~ view task ~ TaskGroup] PROBLEMS-Solutions FROM [ Plan] plan-projects IN [ calendars] prj-022-sospep