mahara-contributors team mailing list archive

[Aaron Wells <1513851@xxxxxxxxxxxxxxxxxx>]

As with https://bugs.launchpad.net/mahara/+bug/1474659, because this is
a database change and it's not "high" priority, we won't backport the
fix into the stable branches.

For existing Mahara sites (15.10 and earlier) that are affected by this
problem, probably the easiest thing to do is to manually change the
column using a MySQL "ALTER TABLE" query:

 ALTER TABLE activity_queue MODIFY COLUMN data LONGTEXT NOT NULL;

-- 
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/1513851

Title:
  Activity queue: unserialize(): Error at offset 65535 of 65535 bytes

Status in Mahara:
  Fix Committed

Bug description:
  We frequently have this error coming from the cron :
  -----------------------------------------------------------------------------------------------------------
  [INF] 78 (lib/cron.php:30) ---------- cron running Thu, 10 Sep 2015 17:50:01 -0400 ----------
  [INF] 78 (lib/cron.php:75) Running PluginSearchElasticsearch::cron
  [INF] 78 (lib/cron.php:137) Running core cron activity_process_queue
  [DBG] 78 (lib/activity.php:209) Page avec l'identifiant 18121 introuvable
  [WAR] 78 (lib/activity.php:195) unserialize(): Error at offset 65535 of 65535 bytes
  Call stack (most recent first):
    * log_message("unserialize(): Error at offset 65535 of 65535 byte...", 8, true, true, "/app/apache2/htdocs/mahara/lib/activity.php", 195) a
  t /app/apache2/htdocs/mahara/lib/errors.php:439
    * error(8, "unserialize(): Error at offset 65535 of 65535 byte...", "/app/apache2/htdocs/mahara/lib/activity.php", 195, array(size 7)) at U
  nknown:0
    * unserialize("O:8:"stdClass":3:{s:4:"view";s:4:"8011";s:8:"oldus...") at /app/apache2/htdocs/mahara/lib/activity.php:195
    * activity_process_queue() at /app/apache2/htdocs/mahara/lib/cron.php:142

  [DBG] 78 (lib/activity.php:209) Le paramètre requis view n'a pas été renseigné pour le type d'activité viewaccess
  [INF] 78 (lib/cron.php:137) Running core cron import_process_queue
  [INF] 78 (lib/cron.php:137) Running core cron user_login_tries_to_zero
  [INF] 78 (lib/cron.php:137) Running core cron check_imap_for_bounces
  [INF] 78 (lib/cron.php:137) Running core cron watchlist_process_notifications
  [INF] 78 (lib/cron.php:137) Running core cron export_process_queue
  [INF] 78 (lib/cron.php:168) ---------- cron finished Thu, 10 Sep 2015 17:50:01 -0400 ----------
  -----------------------------------------------------------------------------------------------------------

  It's the same problem/resolution as in this task :
  https://bugs.launchpad.net/mahara/+bug/1474659

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1513851/+subscriptions