It could be due to the php xdebug module.
Galou
On 20 mai, 09:14, Mohd Shakir Zakaria <mohdsha...@gmail.com> wrote:
> I keep on getting this error when running one of my scripts;
>
> PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted
> (tried to allocate 71 bytes) in ...
> lib/symfony-1.4.11/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php
> on line 246, ...
>
> The following is the stripped-down version of the script that's
> triggering the error;
>
> public function executeImportFile(sfWebRequest $request)
> {
> ini_set('memory_limit', '1024M');
> set_time_limit ( 0 );
>
> //more codes here...
>
> $files = scandir($workspace.'/'.$directory);
>
> foreach ($files as $file) {
> $path = $workspace.'/'.$directory.'/'.$file;
>
> if ($file != "." && $file != "..") {
> $this->importfile($path);
> }
> }
>
> }
>
> protected function importfile($path){
> ini_set('memory_limit', '1024M');
> set_time_limit ( 0 );
>
> $connection =
> sfContext::getInstance()->getDatabaseManager()->getDatabase('doctrine')->getDoctrineConnection();
> $connection->beginTransaction();
> try {
>
> //more codes here...
>
> while ($data = $reader->read()) //reads each line of a csv file
> {
> // send the line to another private function to be processed
> // and then write to database
> $this->writewave($data);
> }
>
> $connection->commit();
>
> } catch (Exception $e) {
> $connection->rollback();
> }
>
> }
>
> What the script does is basically to read all the csv files in a
> folder (which contains tens of thousands of lines each), process it,
> and the write it to the database using Doctrine's transaction.
>
> While I don't think I need to set the memory limit and the time limit
> in both functions, the script quits as Doctrine uses up all the the
> allocated 1GB of memory.
>
> It will normally stop after processing 10 files, and allocating more
> memory will allow it to process a bit more files, and will still
> crash.
>
> Is there anything that I'm missing here that's causing the memory not
> to free up after processing each files?
>
> Mohd Shakir Zakariahttp://www.mohdshakir.net
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
