Skip to content

Simulate DELETE in a large table with million of rows gives error 500 #18941

@liviuconcioiu

Description

@liviuconcioiu

Describe the bug

Simulate DELETE in a large table with million of rows gives error 500.

To Reproduce

Steps to reproduce the behavior:

  1. Create a large table
  2. Simulate a delete query
  3. See error

Expected behavior

No error should be given and simulate should give the row count that will be deleted.

Screenshots

1e

Server configuration

  • phpMyAdmin version: 5.2.2-dev, 6.0.0-dev

Additional context

5.2.2-dev:

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 49152 bytes) in /libraries/classes/Dbal/DbiMysqli.php on line 209

6.0.0-dev:

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 27279360 bytes) in /src/Dbal/DbiMysqli.php on line 171

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing featureaffects/5.2This issue or pull-request affects 5.2.x releases (and maybe further versions)affects/6.0This issue or pull-request affects 6.0.x releases (and maybe further versions)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions