<div dir="ltr"><div><div><div>Hi Zack,<br><br>The output is empty:<br><br>$ sudo -u mypostgresuser psql cdash mypostgresuser<br>cdash=# \conninfo<br>You are connected to database "cdash" as user "mypostgresuser" via socket in "/var/run/postgresql" at port "5432".<br>cdash=# SELECT buildin FROM buildupdate<br><br></div><div>I also tried build2update instead buildupdate (is it a typo?) but this gives the same empty line.<br></div><div><br></div>Note that the section in github that you are pointing at is the master branch. I compared it with the Release-2-2-2 tag: I don't see much difference besides styling/formatting with some extra whitespaces added to master, notably at the pdo_query() line.<br><br></div>master:<br><span class="gmail-pl-s1"><span class="gmail-pl-s"><span class="gmail-pl-pds"></span><span class="gmail-pl-s1"><span class="gmail-pl-k"></span><span class="gmail-pl-k"></span><span class="gmail-pl-s"></span></span><span class="gmail-pl-pds"></span></span><span class="gmail-pl-k"></span><span class="gmail-pl-smi"></span><span class="gmail-pl-s"><span class="gmail-pl-pds"></span><span class="gmail-pl-pds"></span></span><span class="gmail-pl-k"></span><span class="gmail-pl-s"><span class="gmail-pl-pds"></span><span class="gmail-pl-pds"></span></span><span class="gmail-pl-k"></span><span class="gmail-pl-smi"></span><span class="gmail-pl-s"><span class="gmail-pl-pds"></span><span class="gmail-pl-pds"></span></span><span class="gmail-pl-k"></span><span class="gmail-pl-s"><span class="gmail-pl-pds"></span></span></span></div><span class="gmail-pl-s1">pdo_query(<span class="gmail-pl-s"><span class="gmail-pl-pds">"</span><span class="gmail-pl-s1"><span class="gmail-pl-k">INSERT INTO</span> build2update (buildid,updateid) <span class="gmail-pl-k">VALUES</span> (<span class="gmail-pl-s">'</span></span><span class="gmail-pl-pds">"</span></span> <span class="gmail-pl-k">.</span> <span class="gmail-pl-smi">$query_array</span>[<span class="gmail-pl-s"><span class="gmail-pl-pds">'</span>buildid<span class="gmail-pl-pds">'</span></span>] <span class="gmail-pl-k">.</span> <span class="gmail-pl-s"><span class="gmail-pl-pds">"</span>','<span class="gmail-pl-pds">"</span></span> <span class="gmail-pl-k">.</span> <span class="gmail-pl-smi">$query_array</span>[<span class="gmail-pl-s"><span class="gmail-pl-pds">'</span>buildid<span class="gmail-pl-pds">'</span></span>] <span class="gmail-pl-k">.</span> <span class="gmail-pl-s"><span class="gmail-pl-pds">"</span>')<span class="gmail-pl-pds">"</span></span>);</span><br>Release-2-2-2:<br><div><div><div>pdo_query("INSERT INTO build2update (buildid,updateid) VALUES ('".$query_array['buildid']."','".$query_array['buildid']."')");<br><br></div><div><br></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jul 26, 2017 at 9:30 AM, Zack Galbreath <span dir="ltr"><<a href="mailto:zack.galbreath@kitware.com" target="_blank">zack.galbreath@kitware.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><span class="">On Tue, Jul 25, 2017 at 8:45 PM, François Bertel <span dir="ltr"><<a href="mailto:fbopensource@gmail.com" target="_blank">fbopensource@gmail.com</a>></span> wrote:<br></span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><span class=""><div><div><div><div>I have a new error when I click on the "Upgrade Cdash" button: I can see "Upgrading tables:" with the green check icon and the line below with<br></div>the spinning wheel icon and "Applying 2.2 patches..." but a modal dialog with the following message pops up:<br>"error Internal Server Error<br></div>                             [OK]"<br><br></div>When I close it, I still see the spinning wheel and it gets stuck there.<br><br></div>I have the following error message in /var/log/apache2/error.log:<br><br></span>Call to a member function fetch() on boolean in pdocore.php</div></div></div></blockquote><div><br></div><div>This error typically means you don't have a database connection.  Instead of trying to fetch results from an active DB connection, it's trying to fetch them from FALSE (the error return value).  Since you got this far, I assume that CDash can normally connect to the database, and somehow the connection slipped during the upgrade process.</div><div><br></div><div><a href="https://github.com/Kitware/CDash/blob/master/public/upgrade.php#L613" target="_blank">Looking at the v2.2 upgrade path</a>, it doesn't seem like it's doing anything that should strain your database too hard.  The only thing that isn't completely routine is the while() loop over buildupdate::buildid.  This is just a guess, but you could try running this query manually:</div><div><br></div><div><font face="monospace, monospace">SELECT buildid FROM buildupdate</font><br></div><div><br></div><div>If this returns something crazy like millions of rows, then perhaps that's the problem here.</div></div></div></div>
</blockquote></div><br></div>