new blog entry fails

Bug #1813405 reported by Thorsten Rochelmeyer on 2019-01-26

This bug report will be marked for expiration in 39 days if no further activity occurs. (find out why)

6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Undecided
Unassigned

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.

Robert Lyon (robertl-9) wrote :

Hi Thorsten,

Are you able to show a bit more of the error log to help diagnose this problem?

Normally before the output of the SQL that caused the error will be a line like

 postgres8 error:

or

 mysql5 error:

and that line usually gives a better idea as to why the sql query failed

Cheers

Robert

Changed in mahara:
status: New → Incomplete

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers