Author Topic: Fatal Error: Allowed memory size (Read 1794 times)

Heiru · « **on:** October 21, 2009, 04:43:35 am »

Hello everyone! You guys have always been a great help and quick too! I was running bebot 0.6.2 and was receiving this error when it would start up and authenticate...

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 113 bytes) in C:\BeBot\Sources\MySQL.php on line 193

I upgraded to 0.6.5 which is the latest bebot version just in case I was hoping that fixed it, but it didn't. I tried editing the php.ini file and made the number something crazy like 999M in the Memory Limit spot. I made sure to restart the machine as well after making the change and still no luck. Anyone have any advice on where to look or try?

Thanks a ton!!

clashbot · « **Reply #1 on:** October 21, 2009, 12:00:34 pm »

don't set it to a very high number as this will cause other problems. if you were just over the memory limit at the 128M, then I would say bump it to 256M.

The other option, is to set a memory ceiling in the individual file that is causing the issue.

You can do this by changing the top line in the module from :

Code: [Select]

<?phpto

Code: [Select]

<?php
ini_set('memory_limit','256M');

This may solve your problem, but I would check to see what modules might be overloading your memory requirements. I am running 11 bots on the default 128M. So sounds like either you have mysql db's running outside the bot, or you have a memory hog module that needs to be optimized.

Khalem · « **Reply #2 on:** October 21, 2009, 09:13:47 pm »

Something is definately very wrong.

BeBot should not be using anywhere near that amount of memory. With a stock BeBot you should be using around 10-20Mb.

I would start by turning on all error logging in php and checking for anything obvious.

Second it would seem that your issues could be related to the MySQL connections, so depending on what you find out from error logs that would be a second item to investigate.

Could be interesting to know what version of PHP and MySQL you are running.

Heiru · « **Reply #3 on:** October 22, 2009, 12:36:19 am »

I am running MySQL version 5.0.4 and PHP 5.2.9.9

This error just started coming up yesterday. I have been running the bot for well over 6 months with no problems. I don't have any custom addon's installed, I only have running whatever comes by default with Bebot.

I will try and turn on some php logs, I am definately a novice when it comes to this stuff. The error always comes up when it is trying to update the roster. It could be a MySQL error, but not sure what I would do to fix that.

We really only use the !quotes database alot so that is the only thing that I could think of that would cause memory or size issue's. We do have alot of members as well around 60ish and probably 100ish that are in the roster that aren't always active. Those are really the only two things that I could think of that would be taking up space or memory.

Heiru · « **Reply #4 on:** October 26, 2009, 05:02:24 am »

Good news. THe advice of hard coding my quotes and roster php pages to 256M fixed the error I was getting. It seems my roster database itself is a bit messed up at the moment because it shows alot of people as -1 when they log in including myself as the admin which means I cannot admin the bot from within the game. Is there a repair database function or something I can run to repair the roster database?