Hi Aaron and the Mahara Community, First of all thanks for fixing the following bug: https://bugs.launchpad.net/mahara/+bug/1039865.
As Donna indicates we were able to successfully upgrade to 1.5 but it is not usable. It seems there is quite a culture of ridicule surrounding MySQL among Mahara developers (referring to: https://mahara.org/interaction/forum/topic.php?id=302) even though MySQL is listed as being officially supported (https://wiki.mahara.org/index.php/System_Administrator's_Guide/Requirements). We first implemented Mahara a long long time ago (we pre-date the 1.0 release), at the time I do not believe that Postgres was listed as the "recommended" option. In the event that the CAST function will continue to cause problems with our Mahara installation (I realize this is a MySQL performance issue and Mahara is simply working around the performance issue -- again thank you). Do you know of any large installations that have migrated from MySQL to Postgres, we are stuck on 1.4 for now as it seems it is the last version that functioned properly with MySQL out of the box, we are mindful of the strong recommendation to move off of 1.4. Is there a data migration script to move from MySQL to Postgres? How would you recommend approach a migration? I have pasted recent site statistics for your reference, any helpful guidance would be appreciated, personally we not committed to either DBMS (we do have more experience with MySQL) but if we need to move to Postgres under the communities recommendation then we will have no choice, I just cant see an easy migration path. Site installed: 29 August 2008 Users: 1046 Active users: 2 today, 147 since 02 August, 926 all time Groups: 381 On average, each user is in 2.1 groups Pages: 28680 Users who make pages have about 25.3 pages each Database size: 1GB Disk usage: 19.3GB Mahara version: 1.5.11 (latest version is 1.7.2) Thanks again for everyone's attention to these issues. -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contrib members https://bugs.launchpad.net/bugs/1081947 Title: Adding Journal or Text box to a page takes approx 2 minutes to load Status in Mahara ePortfolio: Confirmed Bug description: Mahara version 1.5.2 Linux CentOS release 5.8 PHP Version 5.3.15 MySQL 5.0.77 When editing a page and trying to add a normal text box by dragging it into the page, this loads for approx 2 minutes or more and then eventually appears. It happens with a journal too but all others are fine and are instant as they should be. I'm not getting any apache log errors for this nor general server errors. The only thing I am able to see is the query that it hangs on for this length of time.... it is the below... I hope someone can help as obviously this is causing quite a lot of issues for the users!! Anyone able to diagnose what is the issue here? The thing is, there is another exact version of the Mahara site alongside this one but just a blank version which runs perfectly fine so this must be an issue within the database somewhere or the maharadata. Query below: this hangs for about 1 minute 45.. SELECT a.*, CAST(a.owner IS NOT NULL AND a.owner = '1739' AS UNSIGNED) AS editable FROM "artefact" a LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 371) WHERE ( a.owner = '1739' OR a.id IN ( SELECT aar.artefact FROM "group_member" m JOIN "artefact" aa ON m.group = aa.group JOIN "artefact_access_role" aar ON aar.role = m.role AND aar.artefact = aa.id WHERE m.member = '1739' AND aar.can_republish = 1 ) OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1739' AND can_republish = 1) OR a.institution IN ('test','mahara') ) AND artefacttype IN('blog')ORDER BY title ASC LIMIT 10 | Then this one for the rest of the time until eventually the text box or journal appears on the page: SELECT COUNT(*) FROM "artefact" a LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 371) WHERE ( a.owner = '1739' OR a.id IN ( SELECT aar.artefact FROM "group_member" m JOIN "artefact" aa ON m.group = aa.group JOIN "artefact_access_role" aar ON aar.role = m.role AND aar.artefact = aa.id WHERE m.member = '1739' AND aar.can_republish = 1 ) OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1739' AND can_republish = 1) OR a.institution IN ('test','mahara') ) AND artefacttype IN('blogpost') | Thank you for your help To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1081947/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
