mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1883478@xxxxxxxxxxxxxxxxxx>]

Hi Hermann,

This issue looks similar to the one reported here
https://bugs.launchpad.net/mahara/+bug/1877906

Since you are using Mahara 20.04.0, and this fix was released on
20.04.1, you could try upgrading to that new minor point or applying the
patch for that specific issue and let us know if that solves the
problem.

For 20.04 you can find the code here
https://reviews.mahara.org/#/c/10969/

Cheers,
Cecilia

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

Title:
  MariaDB 10.2 error with Elasticsearch 6.8/SSO from Moodle not working

Status in Mahara:
  Triaged

Bug description:
  After upgrading to MariaDB 10.2 (mandatory for Moodle 3.9) Mahoodle integration fails. Logging into Mahara throws a couple of errors and does not work anymore.
  Disabling Elasticsearch solves the problem :-( -- everything working again. Elasticsearch/SSO from Moodle 3.8.x was working perfectly before the upgrade to MariaDB 10.2 (from 10.1).
  Versions: 
  Elasticsearch:
   "version" : {
      "number" : "6.8.10",
      "build_flavor" : "default",
      "build_type" : "deb",
      "build_hash" : "537cb22",
      "build_date" : "2020-05-28T14:47:19.882936Z",
      "build_snapshot" : false,
      "lucene_version" : "7.7.3",
      "minimum_wire_compatibility_version" : "5.6.0",
      "minimum_index_compatibility_version" : "5.0.0"
  Moodle: 
  Version: 3.9 (2020061500)
  Release: 06.15.2020
  PHP: 7.3.19-1+ubuntu16.04.1+deb.sury.org+1
  MySQL: 10.2.32-MariaDB-10.2.32+maria~xenial-log
  Mahara: 20.04.0

  
  [DBG] 64 (lib/dml.php:180) mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE NOT EXISTS (
                      SELECT 1 FROM "search_elasticsearch_qu...' at line 2] in EXECUTE("INSERT INTO "search_elasticsearch_queue" (itemid, type)
                  SELECT '3', 'usr' WHERE NOT EXISTS (
                      SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = '3' AND type = 'usr'
                  )")Command was: INSERT INTO "search_elasticsearch_queue" (itemid, type)
                  SELECT ?, ? WHERE NOT EXISTS (
                      SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = ? AND type = ?
                  )
  [WAR] 64 (lib/errors.php:859) Could not execute command: INSERT INTO "search_elasticsearch_queue" (itemid, type)
                  SELECT ?, ? WHERE NOT EXISTS (
                      SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = ? AND type = ?
                  )
  Call stack (most recent first):
  log_message(string(size 240), integer, true, true) at /var/www/mahara-20.04.0/htdocs/lib/errors.php:95
  log_warn(string(size 240)) at /var/www/mahara-20.04.0/htdocs/lib/errors.php:859
  SQLException->__construct(string(size 240)) at /var/www/mahara-20.04.0/htdocs/lib/dml.php:181
  execute_sql(string(size 213), array(size 4)) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2300
  ElasticsearchIndexing::add_to_queue(string(size 1), string(size 3), null) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2268
  ElasticsearchIndexing::bulk_add_to_queue(array(size 1)) at /var/www/mahara-20.04.0/htdocs/lib/dml.php:1507
  update_record(string(size 3), object(stdClass), array(size 1)) at /var/www/mahara-20.04.0/htdocs/auth/user.php:417
  User->commit() at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/lib.php:249
  AuthXmlrpc->request_user_authorise(string(size 40), string(size 30)) at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/land.php:78
  [WAR] 64 (lib/dml.php:181) Could not execute command: INSERT INTO "search_elasticsearch_queue" (itemid, type)
                  SELECT ?, ? WHERE NOT EXISTS (
                      SELECT 1 FROM "search_elasticsearch_queue" WHERE itemid = ? AND type = ?
                  )
  Call stack (most recent first):
  execute_sql(string(size 213), array(size 4)) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2300
  ElasticsearchIndexing::add_to_queue(string(size 1), string(size 3), null) at /var/www/mahara-20.04.0/htdocs/search/elasticsearch/lib.php:2268
  ElasticsearchIndexing::bulk_add_to_queue(array(size 1)) at /var/www/mahara-20.04.0/htdocs/lib/dml.php:1507
  update_record(string(size 3), object(stdClass), array(size 1)) at /var/www/mahara-20.04.0/htdocs/auth/user.php:417
  User->commit() at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/lib.php:249
  AuthXmlrpc->request_user_authorise(string(size 40), string(size 30)) at /var/www/mahara-20.04.0/htdocs/auth/xmlrpc/land.php:78

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