mahara-contributors team mailing list archive

[Thorsten Rochelmeyer <thorsten@xxxxxxxxxxxxxxx>]

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