← Back to team overview

mahara-contributors team mailing list archive

  1. mahara-contributors team
  2. Mailing list archive
  3. Message #59119

Re: [Bug 1883478] MariaDB 10.2 error with Elasticsearch 6.8/SSO from Moodle not working

  Thread Previous • Date Previous • • Thread Next 
Hi Cecilia,

This patch is working for me! Thank you.

Hermann

> Am 20.07.2020 um 07:43 schrieb 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 subscribed to the bug
> report.
> 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

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

References

  Thread Previous • Date Previous • • Thread Next