mahara-contributors team mailing list archive

[Mahara Bot <1513851@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/5667
Committed: https://git.mahara.org/mahara/mahara/commit/fcbb3ad103a7b5268bfcd04b34ae3df7f93e4b75
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    master

commit fcbb3ad103a7b5268bfcd04b34ae3df7f93e4b75
Author: Jean-Philippe Gaudreau <jp.gaudreau@xxxxxxxxxxxx>
Date:   Fri Nov 6 10:32:28 2015 -0500

Increase the size of the activity queue data column (Bug 1513851)

In MySQL, the default "text" column size is 65kB. Because this column
can hold the serialized text from several other columns, it needs to
be larger than that. Setting it to "big" generates a "longtext", which
is 4GB.

This change has no effect in Postgres. Postgres has only one text
size (unlimited). The XMLDB generator is smart enough that it
recognizes this and doesn't run any SQL in this case.

behatnotneeded

Change-Id: I0311bf9d25dba531ced72e6f74b8d5b2d317e745

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