NanoGong plugin error

NanoGong plugin error

by Dave Perry -
Number of replies: 8

I have been getting the following error e-mailed to me by Apache when I come to view (as a teacher) a students nanogong submissions (our test v2.2.3 server is setup to email error messages out the box):

Insert into log table failed at Tuesday 26th of June 2012 11:14:45 AM.
 It is possible that your disk is full.

The failed query parameters are:

array (
  'time' => 1340705685,
  'userid' => '4',
  'course' => NULL,
  'ip' => '83.100.199.178',
  'module' => 'nanogong',
  'cmid' => '18',
  'action' => 'update',
  'url' => 'view.php?n=2',
  'info' => '2',
)

This is the second time i've seen this error email, the first time was when I was demonstrating the plugin and process to a teacher a few weeks ago.

I have verified the disk is nowhere near full. Ideas?

Average of ratings: -
In reply to Dave Perry

Re: NanoGong plugin error

by Ken Task -
Picture of Particularly helpful Moodlers

Are the MySQL database files on a partition such as /var?  DB files would then be in /var/lib/mysql/ on a Linux CentOS server (standalone).  Could be the partition has no more space.

If Linux based and you have access to the command line as root user:

df [ENTER]

'spirit of sharing', Ken

Average of ratings: -
In reply to Ken Task

Re: NanoGong plugin error

by Dave Perry -

Ken, df was the command I used originally so thanks confirming I was looking at the right thing when checking disk space originally. Here is its output:

Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/vg_kaltura-lv_root
                     944714148 250404320 646321092  28% /
tmpfs                  4023512         0   4023512   0% /dev/shm
/dev/sda1               495844     58817    411427  13% /boot
/dev/mapper/vg_kaltura-lv_home
                       5039616    141096   4642520   3% /home

Pretty much everything goes on / partition (I let CentOS installer decide how best to divvy up the disk, hence the volume groups which I don't really understand).

Average of ratings: -
In reply to Dave Perry

Re: NanoGong plugin error

by Ken Task -
Picture of Particularly helpful Moodlers

Should confess, don't run NanoGong, so no real first hand experience.

Then it's a 'false suggestion' as to problem.

See something strange if attempting to view a student submission ... the reference to Course = NULL.  Has the student reported any issue in using?  Wonder what the log looks like for other student submissions?  Only way to do that would be mysql queries, would think.

Suggest turning on Debugging to see if there is some other information that provides a clue.

'spirit of sharing', Ken

Average of ratings: -
In reply to Ken Task

Re: NanoGong plugin error

by Mike Wilson -

We're getting the same Nanogong error.

I did a bit of digging and noticed the order of the fields in the insert array from the email alert is in slightly the wrong order in comparison to the mdl_log table. The course and ip fields are the wrong way round. 

From error message:

array (
  'time' => 1342003821,
  'userid' => '1234',
  'course' => NULL,
  'ip' => '123.123.12.12',
  'module' => 'nanogong',
  'cmid' => '14791',
  'action' => 'update',
  'url' => 'view.php?n=4',
  'info' => '4',
)

mdl_log field order:

time
userid
ip
course
module
cmid
action
info
url

It's a pretty small error but would explain why the line can't be entered into the log. Unfortunately I couldn't find the line in the Nanogong code.

I'm sure it's not a disk space problem (atleast for us) as we have quite a generous amount of space on our database server.

Hopefully some-one from Nanogong can fix this. It's a great module.

Mike

Average of ratings: -
In reply to Dave Perry

Re: NanoGong plugin error

by Gibson Lam -

Hi,

We have seen this reported a few times by different people. However, we have not been able to reproduce that in our own servers.

Looking at the error, the NanoGong module is trying to insert a log using a 'NULL' course. This will certainly cause some problems since the database doesn't allow a course to have 'NULL' value.

We have been preparing a new version of the NanoGong activity module (to be released) and we have changed the code so that it makes sure of the existance of the course before doing anything. Hopefully this change can stop the problem.

Regards,
Gibson

Average of ratings: -
In reply to Gibson Lam

Re: NanoGong plugin error

by Dave Perry -

I should point out one of the times I got this error was when submitting a response to a nanogong activity instance on a course page. So perhaps it was losing the course ID in the submit request to the array that runs the log table insert?

EDIT - this error occurs EVERY time you try submitting a response to a nanogong activty on a course page, so not just a one-time glitch of losing the course ID.

Average of ratings: -
In reply to Gibson Lam

Re: NanoGong plugin error

by Ozan Varli -

We're also getting the same error although everything is fine with our database, but it's great to hear that you're already working on it. NanoGong is definitely one of our favorite modules, and we want to keep it longer Yes

Insert into log table failed at Wednesday 18th of July 2012 05:11:11 PM.

 It is possible that your disk is full.

 The failed query parameters are:

 array (

  'time' => 1342631471,

  'userid' => '90',

  'course' => NULL,

  'ip' => '88.235.3.39',

  'module' => 'nanogong',

  'cmid' => '2368',

  'action' => 'update',

  'url' => 'view.php?n=1',

  'info' => '1',

)

Average of ratings: -