J4 on AWS Aurora: ERROR when saving article and category

[CitW]

Hi

Just installed J4.2.5. Apache 2, PHP 8.1, AWS Aurora 2.10.2 (MySQL 5.7).

The problem is when I save article or category I get:

Save failed with the following error: The 'MEMORY' feature is disabled; you need MySQL built with 'MEMORY' to have it working

The data seems to be saved in some tables as e.g. when saving article '_content' and '_assets' tables are updated but the above error is still displayed and article I try to add doesn't appear under articles.

The db users has sufficient privileges to the db so it puzzles me why I get the error.

Any help would be greatly appreciated.

[Per Yngve Berg]

Check that you have these two tables (#_finder_tokens, #_finder_tokens_aggregate). These are of type memory in my installation. The table type memory appears to be disabled in your datbase server.

[CitW]

Hi

I do have both '#_finder_tokens' and '#_finder_tokens_aggregate' tables.

When I run:

Code: Select all

select * from information_schema.engines where engine='MEMORY';

I get:

Code: Select all

ENGINE: MEMORY
SUPPORT: YES
COMMENT: Hash based, stored in memory, useful for temporary tables
TRANSACTIONS: NO
XA: NO
SAVEPOINTS: NO

So it looks like table type memory is not disabled.

Also, on the same Apache and db servers, I have latest Joomla 3 site that works without problems and Joomla 4 (upgraded from 3, close to being launched) site that also works without these errors. That's why I'm so puzzled. The only difference between J4 sites is that the one that works was upgraded from J3 and one that doesn't work was a fresh J4 install.

[Per Yngve Berg]

Articles will not show in Admin if the workflow entry is missing.

[CitW]

Articles will not show in Admin if the workflow entry is missing.

Where would I find this "workflow entry"?

[ceford]

See viewtopic.php?t=990519

A similar problem citing Google

Google Cloud does not support engine=memory which is used on two tables #__finder_tokens and #__finder_tokens_aggregate

[CitW]

A similar problem citing Google

I have read that. Like I wrote in my previous post ENGINE: MEMORY is supported by AWS Aurora. I have also another J4 site on the same servers which is working.

The only difference between J4 sites is that the one that works was upgraded from J3 and one that doesn't work was a fresh J4 install.

[ceford]

I have been looking though the code to try to understand this issue. I don't have the problem but I can trigger a stack trace that gives me a memory error totally unrelated to the problem. So I am not convinced the stated memory error is real.

I think the message you see comes from line 681 of libraries/src/MVC/Controller/FormController.php

Code: Select all

            $this->setMessage(Text::sprintf('JLIB_APPLICATION_ERROR_SAVE_FAILED', $model->getError()), 'error');

If you are game you can confirm that by adding this line before (or after):

Code: Select all

$this->setMessage('Confirm error is here!', 'error');

Then when you save an article you should see that message as well as the error message.

If the problem is there then the next task is figure out why the data is not being saved, on line 676.

[CitW]

Disabling Smart Search plugins sorts out the problem on AWS Aurora.