Hi Robert, after querying Stackoverflow, i found the root cause of that problem. The sort_buffer_size was too low and increasing it from 1MB to 8MB fixed the problem.
I guess this is related to the fact that our mahara is hosted on a V-Server which requires larger sort buffer sizes. I am not sure how much sense it makes to dig deeper into this issue. Thanks Thorsten -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1813405 Title: new blog entry fails Status in Mahara: Incomplete Bug description: mahara 18.10 ubuntu Server 16.04 MySQL Firefox Quantum 64.0 / Linux Trying to make a new blog entry fails with the following information: Mahara: Site unavailable A nonrecoverable error occurred. This probably means you have encountered a bug in the system From the nginx-Error-Log: 2019/01/26 16:23:52 [error] 25515#25515: *325212 FastCGI sent in stderr: "dio') PHP message: [WAR] ff (lib/dml.php:517) AND a.institution IS NULL AND a.owner = '2' PHP message: [WAR] ff (lib/dml.php:517) AND a.parent IS NULL PHP message: [WAR] ff (lib/dml.php:517) GROUP BY PHP message: [WAR] ff (lib/dml.php:517) a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, PHP message: [WAR] ff (lib/dml.php:517) u.profileicon, fi.orientation")Command was: PHP message: [WAR] ff (lib/dml.php:517) SELECT PHP message: [WAR] ff (lib/dml.php:517) a.id, a.artefacttype, a.mtime, f.size, fi.orientation, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon, PHP message: [WAR] ff (lib/dml.php:517) COUNT(DISTINCT c.id) AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount, PHP message: [WAR] ff (lib/dml.php:517) COUNT(DISTINCT api.id) AS profileiconcount PHP message: [WAR] ff (lib/dml.php:517) FROM "artefact" a PHP message: [WAR] ff (lib/dml.php:517) LEFT OUTER JOIN "artefact_file_files" f ON f.artefact = a.id PHP message: [WAR] ff (lib/dml.php:517) LEFT OUTER JOIN "artefact_file_image" fi ON fi.artefact = a.id PHP message: [WAR] ff (lib/dml.php:517) LEFT OUTER JOIN "artefact" c ON c.parent = a.id PHP message: [WAR] ff (lib/dml.php:517) LEFT OUTER JOIN "artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon' PHP message: [WAR] ff (lib/dml.php:517) LEFT OUTER JOIN "view_artefact" va ON va.artefact = a.id PHP message: [WAR] ff (lib/dml.php:517) LEFT OUTER JOIN "artefact_attachment" aa ON aa.attachment = a.id PHP message: [WAR] ff (lib/dml.php:517) LE This only happens when trying to add a new blog post. All other artefacts are not affected, as far as i can say. I tried with two different user accounts and can reproduce this with both of them. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1813405/+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
