mahara-contributors team mailing list archive

Thread
Date
[Bug 615625] Re: Cron job stopped working

To: mahara-contributors@xxxxxxxxxxxxxxxxxxx
From: Shen <shzhang@xxxxxxxxx>
Date: Tue, 10 Aug 2010 00:00:14 -0000
Reply-to: Bug 615625 <615625@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
The name of the cron job is begin_autimport, which was developed for
grouping purposes

-- 
Cron job stopped working
https://bugs.launchpad.net/bugs/615625
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: Invalid

Bug description:
The cron job has been running properly. But all of the sudden it stopped working. The related message in the error_log under logs of the Apache server is as follows:

--------------------------------------------------------
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [DBG] da (lib/cron.php:70) ---------- cron running Tue, 10 Aug 2010 08:10:01 +1200 ----------
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [DBG] da (lib/cron.php:149) Running core cron begin_autimport
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [INF] da (local/lib.php:194) Line 1 of the file specifies the e-mail address "anne.grey@xxxxxxxxx" that is already taken by another user
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [INF] da (local/lib.php:194) Line 7 of the file specifies the e-mail address "andrew.withell@xxxxxxxxx" that is already taken by another user
[Tue Aug 10 08:10:02 2010] [error] [client 156.62.52.126] [INF] da (local/lib.php:194) Line 27 of the file specifies the e-mail address "peter.maclaren@xxxxxxxxx" that is already taken by another user
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da (lib/errors.php:738) Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da (lib/errors.php:738) Command was: SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] Call stack (most recent first):
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /usr/local/apache22/htdocs/mahara/lib/errors.php:111
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /usr/local/apache22/htdocs/mahara/lib/errors.php:738
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /usr/local/apache22/htdocs/mahara/lib/dml.php:467
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * record_exists_select("usr_institution", "usr = ? AND LOWER(institution) = ?", array(size 2)) at /usr/local/apache22/htdocs/mahara/local/lib.php:180
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * import_users(array(size 11), object(CsvFile), "aut", "3", "aut2009") at /usr/local/apache22/htdocs/mahara/local/lib.php:98
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * begin_autimport() at /usr/local/apache22/htdocs/mahara/lib/cron.php:152
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da (lib/dml.php:467) Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da (lib/dml.php:467) Command was: SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] Call stack (most recent first):
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * record_exists_select("usr_institution", "usr = ? AND LOWER(institution) = ?", array(size 2)) at /usr/local/apache22/htdocs/mahara/local/lib.php:180
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * import_users(array(size 11), object(CsvFile), "aut", "3", "aut2009") at /usr/local/apache22/htdocs/mahara/local/lib.php:98
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]   * begin_autimport() at /usr/local/apache22/htdocs/mahara/lib/cron.php:152
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [DBG] 4a (lib/cron.php:70) ---------- cron running Tue, 10 Aug 2010 08:11:01 +1200 ----------
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [DBG] 4a (lib/cron.php:149) Running core cron begin_autimport
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [INF] 4a (local/lib.php:194) Line 1 of the file specifies the e-mail address "anne.grey@xxxxxxxxx" that is already taken by another user
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [INF] 4a (local/lib.php:194) Line 7 of the file specifies the e-mail address "andrew.withell@xxxxxxxxx" that is already taken by another user
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [INF] 4a (local/lib.php:194) Line 27 of the file specifies the e-mail address "peter.maclaren@xxxxxxxxx" that is already taken by another user
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a (lib/errors.php:738) Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a (lib/errors.php:738) Command was: SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] Call stack (most recent first):
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /usr/local/apache22/htdocs/mahara/lib/errors.php:111
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /usr/local/apache22/htdocs/mahara/lib/errors.php:738
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /usr/local/apache22/htdocs/mahara/lib/dml.php:467
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * record_exists_select("usr_institution", "usr = ? AND LOWER(institution) = ?", array(size 2)) at /usr/local/apache22/htdocs/mahara/local/lib.php:180
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * import_users(array(size 11), object(CsvFile), "aut", "3", "aut2009") at /usr/local/apache22/htdocs/mahara/local/lib.php:98
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * begin_autimport() at /usr/local/apache22/htdocs/mahara/lib/cron.php:152
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a (lib/dml.php:467) Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a (lib/dml.php:467) Command was: SELECT * FROM "usr_institution" WHERE usr = ? AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] Call stack (most recent first):
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]   * record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...", array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
--------------------------------------------------------

The server settings are as follows:

OS: Red Hat Linux Server 5          32bit OS
PostgresPlus 8.4.1-2
Apache 2.2.14 
PHP 5.2.9 
Mahara 1.2.4

Any idea what is happening?
References

[Bug 615625] [NEW] Cron job stopped working
From: Shen, 2010-08-10