#3856 (ok 4.0.0-beta3) Runs out of memory when changing fields

Latest_Git
fixed
Marc Delisle
None
1
2013-06-11
2013-03-24
Marcus Bointon
No

I have a table with about half a million records using about 250M on disk, and this is just a small dev database - I have much bigger ones in production. If I click 'change' next to any field in this table (or others of a similar size), phpmailer crashes with an out of memory error. I've tried it with a PHP memory limit of 1Gb, but it still happens. It looks like it's trying to do something dumb like read the entire table into an array to figure out what to display for the field editor page. It works fine for smaller tables.

I attach an example screen shot.

Adminer has no problem doing the same thing.

I'm running latest from git (4.0beta2) on PHP 5.4.12 on OS X.

1 Attachments

Discussion

  • Marc Delisle
    Marc Delisle
    2013-03-24

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2013-03-24

    Hi,
    can you try the attached patch?

     
    Attachments
  • Marc Delisle
    Marc Delisle
    2013-03-25

    I applied the patch, waiting for a confirmation.

     
  • Marcus Bointon
    Marcus Bointon
    2013-03-25

    Yep, that works, Thanks.

     
  • Marc Delisle
    Marc Delisle
    2013-03-25

    • summary: Runs out of memory when changing fields --> (ok 4.0.0-beta3) Runs out of memory when changing fields
    • status: open --> open-fixed
    • priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2013-03-27

    • Status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed