phpmyadmin / phpmyadmin

A web interface for MySQL and MariaDB
https://www.phpmyadmin.net/
GNU General Public License v2.0
7.28k stars 3.42k forks source link

Importing a CSV file gives error 500 #19380

Open liviuconcioiu opened 2 weeks ago

liviuconcioiu commented 2 weeks ago

Describe the bug

memory_limit = 128M, ~5 Mb / 25,000 records CSV file gives error 500 when importing. Import is successful but it fails at creating a new session and that error message comes up. The problem is I've tried with larger tables, and import is successful too. So clearly a bug, not a memory limit hit.

To Reproduce

Steps to reproduce the behavior:

  1. Import a CSV file from Import tab
  2. See error

Expected behavior

No error should be given.

Screenshots

import_error

import_error1

Server configuration

Additional context

5.2.2-dev:

[11-Nov-2024 21:50:53 UTC] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 17004024 bytes) in Z:\nginx\html\phpMyAdmin-5.2+snapshot-all-languages\libraries\classes\Session.php on line 204

6.0.0-dev:

[11-Nov-2024 21:42:43 UTC] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8406800 bytes) in Z:\GitHub\phpmyadmin\src\Session.php on line 187

liviuconcioiu commented 2 weeks ago

Duplicate of #18455.