19 April 2013, 12:25

• upgrading from v1.4.0 to v1.6.4, downloaded from mahara.org
• Linux RedHat, Apache, mySQL, PHP v5.3.3

Background: First tried upgrade from v1.4.0 to v1.6.2 back in December on our test instance. Upgrade was put on hold; am now returning to the job.

Experienced this bug in December https://bugs.launchpad.net/mahara/+bug/1039865 and applied the fix/work-around as described in this forum thread https://mahara.org/interaction/forum/topic.php?id=5143#post22232

Alas, my reported success in the last posting was not entirely true. While the upgrade process appeared to complete successfully, during testing we discovered a problem with adding text boxes -- the page hangs ("Connecting..."), the box is never added, and I have to restart httpd to get the session to respond again.

I am able to add an image just fine.

As the above-mentioned bug directly affects blocks, indeed the sample sql query I posted in the the thread was "... AND "block_instance".blocktype = 'textbox'...", I'm wondering if the bug fix/workaround isn't the root of my problems.

I'm at the end of a challenging work day. My plans for tomorrow are to test adding some of the other resource blocks to try and determing if text boxes are the only problem. And examine the logs for any obvious error messages. And possibly try some variations of the work-around.

But I'm hoping someone with more database experience might be able to shed a little further light on my problem.

Hrynkiw

Kwantlen Polytechnic University

23 April 2013, 12:22

We had the same issue after upgrade. We created an index artefact_access_role, create index arteaccerole_roleart_ix on artefact_access_role (role,artefact);

Even after the above index it is slow but better than before as now it takes few seconds 20-30.

24 April 2013, 7:09

Clarification of symptoms: A text block could be added but took 28 minutes to appear initially and never did successfully save.

We're having some success after a mysql upgrade. I'll post the details when the dust has settled. My DBAs are working on it as I type.