Fatal: Allowed memory size of 134217728 bytes exhausted

calmyabadselfdown

I have used the Premium Sync to import about 79000 companies but now if I try to view either contacts or companies I get an error:-

Fatal: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4461945 bytes) in D:\Apache2.2\htdocs\epesi\include\epesi.php on line 119

I am suppose to demo this system to my bosses on Thursday as an interim customer database and salesperson's diary system so any help with the above would be gratefully received

my php.ini in the EPESI folder is memory_limit = "128M" as is the PHP in the PHP folder

jasiek

The number of records in the database should not matter - we have installations with over 1 mln records and it works fine.
See this post: viewtopic.php?f=3&t=1616&p=5976#p5667

You can try to enable debugging to see which module generates an error: http://www.epesi.org/Troubleshooting
php error log should tell you what is causing such a high memory usage.

You can also try to increase the memory limit from 128 to 256 MB if possible.

Maybe import did not go through as expected? Can you inspect tables using tool like phpmyadmin?

calmyabadselfdown

I increased the memory limit to 256 Mb and I can now list companies but the sync tool now errors.
I want to use the sync tool to input the initial data and keep it sync'd with Customer ERP data.

it errors when I try to use get_records.php the error seems to be a memory one again.

the get_record.php returns the values fine.

I need the get_records.php to compare the data that is already in EPESI with the ERP data to decide if the data is to be updated (with record_id) or created (record_id=NEW)

calmyabadselfdown

Hello

I have now upped the memory_limit in the php.ini settings to 384Mb and the get_records.php now works

does anyone have some type of calculation or idea of what settings should be if I have 80000 companies and at least 30000 contacts with approx 200 users?

looking at task manager while the script is running shows that Mysqld.exe memory usage is 600Mb and Httpd.exe is at 300Mb

jasiek

It is difficult to say how much memory will be used even knowing the number of records in the recordset. This will depend on a number of fields per record, how many users you have connected to the database and other factors.

One thing I would like to point out that get_records.php does not limit the query - you will get all records returned and with 80000 companies this can be the problem with your memory usage. http://www.epesi.org/Premium_Sync#Retri ... le_records

calmyabadselfdown

how easy would it be to add an extra bit of logic to get_records.php that allowed an extra variable to be sent in the URL get request.

I was think something like the first letter of the account name therefore splitting the number of records (sort of into 26)

I dont know PHP (at all) but it seems that in get_records.php :-

if (isset($_REQUEST['last_sync_date'])) {
$last_sync_date = $_REQUEST['last_sync_date'];
$crits = array('>=:Edited_on'=>$_REQUEST['last_sync_date']);
} else {
$last_sync_date = false;
$crits = array(); <--- THIS BIT COULD BE USED FOR THAT PURPOSE ?

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge