25 March 2016, 0:08

I am using mahara 15.1 new installation,

when I click

1)  contnet > file

2) content >journal >new entry

the following error occurs

A nonrecoverable error occurred. This probably means you have encountered a bug in the system

when I enable errors , I got so many errors but I don't understand it

 

WAR] 30 (lib\errors.php:747) Failed to get a recordset: mysqli error: [1038: Out of sort memory, consider increasing server sort buffer size] in EXECUTE("
            SELECT
                a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
                COUNT(DISTINCT c.id) AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
                COUNT(DISTINCT api.id) AS profileiconcount
            FROM "artefact" a
                LEFT OUTER JOIN "artefact_file_files" f ON f.artefact = a.id
                LEFT OUTER JOIN "artefact" c ON c.parent = a.id
                LEFT OUTER JOIN "artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
                LEFT OUTER JOIN "view_artefact" va ON va.artefact = a.id
                LEFT OUTER JOIN "artefact_attachment" aa ON aa.attachment = a.id
                LEFT OUTER JOIN "skin" s ON (s.bodybgimg = a.id OR s.viewbgimg = a.id)
                LEFT OUTER JOIN "usr" u ON a.id = u.profileicon AND a.owner = u.id
            WHERE a.artefacttype IN ('file','folder','image','profileicon','archive','video','audio')
            AND a.institution IS NULL AND a.owner = '3'
            AND a.parent IS NULL
            GROUP BY
                a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments,
                u.profileicon")
Command was:
            SELECT
                a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
                COUNT(DISTINCT c.id) AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
                COUNT(DISTINCT api.id) AS profileiconcount
            FROM "artefact" a
                LEFT OUTER JOIN "artefact_file_files" f ON f.artefact = a.id
                LEFT OUTER JOIN "artefact" c ON c.parent = a.id
                LEFT OUTER JOIN "artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
                LEFT OUTER JOIN "view_artefact" va ON va.artefact = a.id
                LEFT OUTER JOIN "artefact_attachment" aa ON aa.attachment = a.id
                LEFT OUTER JOIN "skin" s ON (s.bodybgimg = a.id OR s.viewbgimg = a.id)
                LEFT OUTER JOIN "usr" u ON a.id = u.profileicon AND a.owner = u.id
            WHERE a.artefacttype IN ('file','folder','image','profileicon','archive','video','audio')
            AND a.institution IS NULL AND a.owner = ?
            AND a.parent IS NULL
            GROUP BY
                a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments,
                u.profileicon and values was (3)

==============

 

 

thanks in advance for any help

31 March 2016, 13:54

Hi,

You need to increase the sort memory size for mysql.

Please refer to this link:

http://stackoverflow.com/questions/29575835/error-1038-out-of-sort-memory-consider-increasing-sort-buffer-size

 

On a Linux system, the mysql conf file is usually located at  /etc/mysql/my.cnf

In my conf file, that variable doesn't exist so it's set to the default - and I don't get your error.

If it does exist in your conf file, try to first comment it out and see if that works.

If it doesn't work, uncomment it and set it to a larger size.

#sort_buffer_size=256K

Please let me know if that works for you.

Cheers,

Ghada

 

 

06 April 2016, 19:55

thank you so much for helping

I am using WAMP and I could not fine the file

I found my.ini in D:\wamp\bin\mysql\mysql5.6.17

and in it

sort_buffer_size = 20M

so I didn't change it. I also find this artical where he advice not to change it

I hope any one could help me in this

 

06 April 2016, 23:46

Yes, I understand. Is this a production site?

When the error happens, are you trying to upload a file to the journal entry?

Thanks,
Ghada

07 April 2016, 18:58

it's test site.

the error occurs when I click new entery content >journals

in administration I got this errors(warnings)

 

 

 

thank you, I appreciate your help

07 April 2016, 20:11

Hi,

 

You will need to address some of the warnings you're getting in the admin screen.

1. timezones - you may need to add timezones to your mysql database.

Please refer to this post:
http://stackoverflow.com/questions/5510052/changing-the-connection-timezone-in-mysql/16946123#16946123

Also, this post may help you:

https://mahara.org/interaction/forum/topic.php?id=7529

 

2. session.entroy - update this setting in your php.ini file.

 

3. post_max_size - update your php.ini file and set this the same as your upload_max_filesize.

 

You can ignore the site wide salt and noreply address for now - but you should fix those up later.

 

As for the 'new entry' error:

Unfortunately, I can't replicate this error in a vanilla Mahara 15.10 with mysql.

4. Are you getting any errors in your apache log? Please post them here.

 

Thanks,

Ghada

 

 

 

07 April 2016, 20:42

thanks, I updated session.entroy, and post_max_size in php.ini

here is apatche log

====================================

[Thu Apr 07 09:55:58.564890 2016] [core:warn] [pid 4456:tid 268] AH00098: pid file D:/wamp/bin/apache/apache2.4.9/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Thu Apr 07 09:55:59.946890 2016] [mpm_winnt:notice] [pid 4456:tid 268] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 09:55:59.946890 2016] [mpm_winnt:notice] [pid 4456:tid 268] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 09:55:59.946890 2016] [core:notice] [pid 4456:tid 268] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 09:56:00.013890 2016] [mpm_winnt:notice] [pid 4456:tid 268] AH00418: Parent: Created child process 3752
[Thu Apr 07 09:56:01.664890 2016] [mpm_winnt:notice] [pid 3752:tid 308] AH00354: Child: Starting 64 worker threads.
[Thu Apr 07 10:05:26.121890 2016] [mpm_winnt:notice] [pid 4456:tid 268] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 07 10:05:28.122890 2016] [mpm_winnt:notice] [pid 3752:tid 308] AH00364: Child: All worker threads have exited.
[Thu Apr 07 10:05:28.197890 2016] [mpm_winnt:notice] [pid 4456:tid 268] AH00430: Parent: Child process 3752 exited successfully.
[Thu Apr 07 10:05:30.381890 2016] [mpm_winnt:notice] [pid 5508:tid 392] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 10:05:30.381890 2016] [mpm_winnt:notice] [pid 5508:tid 392] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 10:05:30.381890 2016] [core:notice] [pid 5508:tid 392] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 10:05:30.383890 2016] [mpm_winnt:notice] [pid 5508:tid 392] AH00418: Parent: Created child process 2132
[Thu Apr 07 10:05:30.786890 2016] [mpm_winnt:notice] [pid 2132:tid 308] AH00354: Child: Starting 64 worker threads.
[Thu Apr 07 10:07:30.148890 2016] [mpm_winnt:notice] [pid 5508:tid 392] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 07 10:07:32.172890 2016] [mpm_winnt:notice] [pid 2132:tid 308] AH00364: Child: All worker threads have exited.
[Thu Apr 07 10:07:32.206890 2016] [mpm_winnt:notice] [pid 5508:tid 392] AH00430: Parent: Child process 2132 exited successfully.
[Thu Apr 07 10:07:34.033890 2016] [mpm_winnt:notice] [pid 4128:tid 392] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 10:07:34.033890 2016] [mpm_winnt:notice] [pid 4128:tid 392] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 10:07:34.033890 2016] [core:notice] [pid 4128:tid 392] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 10:07:34.035890 2016] [mpm_winnt:notice] [pid 4128:tid 392] AH00418: Parent: Created child process 2184
[Thu Apr 07 10:07:34.528890 2016] [mpm_winnt:notice] [pid 2184:tid 308] AH00354: Child: Starting 64 worker threads.
[Thu Apr 07 10:23:38.117890 2016] [mpm_winnt:notice] [pid 4128:tid 392] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 07 10:23:40.118890 2016] [mpm_winnt:notice] [pid 2184:tid 308] AH00364: Child: All worker threads have exited.
[Thu Apr 07 10:23:40.150890 2016] [mpm_winnt:notice] [pid 4128:tid 392] AH00430: Parent: Child process 2184 exited successfully.
[Thu Apr 07 10:23:42.050890 2016] [mpm_winnt:notice] [pid 4820:tid 392] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 10:23:42.050890 2016] [mpm_winnt:notice] [pid 4820:tid 392] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 10:23:42.050890 2016] [core:notice] [pid 4820:tid 392] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 10:23:42.052890 2016] [mpm_winnt:notice] [pid 4820:tid 392] AH00418: Parent: Created child process 4868
[Thu Apr 07 10:23:42.446890 2016] [mpm_winnt:notice] [pid 4868:tid 308] AH00354: Child: Starting 64 worker threads.
[Thu Apr 07 10:25:06.023890 2016] [mpm_winnt:notice] [pid 4820:tid 392] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 07 10:25:08.023890 2016] [mpm_winnt:notice] [pid 4868:tid 308] AH00364: Child: All worker threads have exited.
[Thu Apr 07 10:25:08.051890 2016] [mpm_winnt:notice] [pid 4820:tid 392] AH00430: Parent: Child process 4868 exited successfully.
[Thu Apr 07 10:25:09.437890 2016] [mpm_winnt:notice] [pid 6912:tid 392] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 10:25:09.438890 2016] [mpm_winnt:notice] [pid 6912:tid 392] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 10:25:09.438890 2016] [core:notice] [pid 6912:tid 392] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 10:25:09.440890 2016] [mpm_winnt:notice] [pid 6912:tid 392] AH00418: Parent: Created child process 6932
[Thu Apr 07 10:25:09.868890 2016] [mpm_winnt:notice] [pid 6932:tid 308] AH00354: Child: Starting 64 worker threads.
[Thu Apr 07 10:25:55.787890 2016] [mpm_winnt:notice] [pid 6912:tid 392] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 07 10:25:57.787890 2016] [mpm_winnt:notice] [pid 6932:tid 308] AH00364: Child: All worker threads have exited.
[Thu Apr 07 10:25:57.816890 2016] [mpm_winnt:notice] [pid 6912:tid 392] AH00430: Parent: Child process 6932 exited successfully.
[Thu Apr 07 10:25:59.061890 2016] [mpm_winnt:notice] [pid 3616:tid 392] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 10:25:59.061890 2016] [mpm_winnt:notice] [pid 3616:tid 392] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 10:25:59.061890 2016] [core:notice] [pid 3616:tid 392] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 10:25:59.063890 2016] [mpm_winnt:notice] [pid 3616:tid 392] AH00418: Parent: Created child process 6036
[Thu Apr 07 10:25:59.523890 2016] [mpm_winnt:notice] [pid 6036:tid 308] AH00354: Child: Starting 64 worker threads.
[Thu Apr 07 10:26:36.113890 2016] [mpm_winnt:notice] [pid 3616:tid 392] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Apr 07 10:26:38.120890 2016] [mpm_winnt:notice] [pid 6036:tid 308] AH00364: Child: All worker threads have exited.
[Thu Apr 07 10:26:38.152890 2016] [mpm_winnt:notice] [pid 3616:tid 392] AH00430: Parent: Child process 6036 exited successfully.
[Thu Apr 07 10:26:39.569890 2016] [mpm_winnt:notice] [pid 4712:tid 392] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Thu Apr 07 10:26:39.569890 2016] [mpm_winnt:notice] [pid 4712:tid 392] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Thu Apr 07 10:26:39.569890 2016] [core:notice] [pid 4712:tid 392] AH00094: Command line: 'D:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d D:/wamp/bin/apache/apache2.4.9'
[Thu Apr 07 10:26:39.570890 2016] [mpm_winnt:notice] [pid 4712:tid 392] AH00418: Parent: Created child process 5784
[Thu Apr 07 10:26:39.957890 2016] [mpm_winnt:notice] [pid 5784:tid 308] AH00354: Child: Starting 64 worker threads.

=====================================

07 April 2016, 22:10

when I open phpmyadmin to view the relation ,

I got the following

The column name 'group' is a MySQL reserved keyword.

 

07 April 2016, 22:38

Hi,

Yes. Group is a reserved word but is a column in the table.  When Mahara queries the table, it wraps it in quotes. So, that's not an issue.

Cheers,
Ghada

07 April 2016, 22:35

Hi,

Thanks for the log. But, I don't think your Mahara is outputting it's errors to this file.

Can you make sure php logging is enabled in php.ini?

Also, please check if your apache vhost is writing errors to another log file.

Sorry about this.

Thanks,
Ghada