Bug #40017
closed
Allowed memory size exhausted with "cli_dispatch.phpsh lowlevel_refindex -e"
0%
Description
Hi,
I've updated TYPO3 from 4.4.15 to 4.5.19 and now I'm getting a fatal error in PHP when I run ...
./cli_dispatch.phpsh lowlevel_refindex -e
... I get this output:
******************************************* Reference Index being Updated ******************************************* PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /opt/support/shelpzag/typo3_src-4.5.17/t3lib/class.t3lib_db.php on line 347
This didn't happen before.
Best regards,
Amar
Updated by Soren Malling over 12 years ago
Hi Amar,
Please debug your own setup (adjusting memory_limit, clear cache tables etc.) before posting a issue.
This seems like a issue that should go to the mailing list instead, http://lists.typo3.org
Cheers
Updated by Michael Stucki over 12 years ago
- Status changed from New to Needs Feedback
Before trying too much, I suggest to raise the memory limit (double it) and see if it helps. I can only say that personally, I use 128M as the default memory limit for most sites. So it is very likely that 64M is not enough...
Updated by Amar Bouchibane over 12 years ago
Thank you, Michael, for your suggestion!
The value for "memory_limit" was in normal and CLI mode 128M.
I changed the value to 256M, restarted Apache, but the error remains:
/home/uttguidebase/www/htdocs/ttguidebase/typo3/cli_dispatch.phpsh lowlevel_refindex -e ******************************************* Reference Index being Updated ******************************************* Record tx_helpzag_main:2741 had 1 added indexes and 0 deleted indexes Record tx_helpzag_main:2742 had 1 added indexes and 0 deleted indexes PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /opt/support/shelpzag/typo3_src-4.5.17/t3lib/class.t3lib_db.php on line 347
I have to correct my description: I have updated TYPO3 to 4.5.17 (not to 4.5.19).
My TYPO3 database consists of 76 tables with 447207 rows and a total size of 112 MiB.
This error didn't occur with the previous version of TYPO3 4.4.15 that I used.
I have a cronjob that updates the reference index every day at 2:00am. And with the same amount of data this didn't happen with TYPO3 4.4.
Any further suggestions?
Updated by Amar Bouchibane over 12 years ago
Sorry, but setting the "memory_limit" in php.ini wasn't correct.
In localconf.php the value for 'setMemoryLimit' was "64".
I've changed it to "128", but the error remained.
But with "256" ...
$TYPO3_CONF_VARS['SYS']['setMemoryLimit'] = '256';
... the "lowlevel_refindex" CLI script works!
/home/uttguidebase/www/htdocs/ttguidebase/typo3/cli_dispatch.phpsh lowlevel_refindex -e ******************************************* Reference Index being Updated ******************************************* 277220 records from 31 tables were checked/updated. Index Integrity was perfect!
Updated by Michael Stucki over 12 years ago
- Status changed from Needs Feedback to Resolved
Good to hear that this helped! Of course the localconf.php setting takes precedence, but it is not a default setting, therefore you should know about it.
As this is not a bug but a configuration issue, I will close the issue.
Updated by