mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1883478@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1877906 ***
    https://bugs.launchpad.net/bugs/1877906

** This bug has been marked a duplicate of bug 1877906
   MariaDB error when creating secret URL

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