Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#2969 (oK 3.2.6)import timeout when table already created

3.2.5
fixed
Marc Delisle
1
2013-06-11
2010-01-27
No

When I import a sql file comporting a CREATE TABLE statement without DROP one and lot of data for this table, phpmyadmin timeout rendering a blank page or not able to allocate memory.

exemples:
- create a table with sql file BDD_struct1.sql
- try to import again the same file
Result: phpMyAdmin report an error that the table is already created

- create a table with sql file BDD_struct1.sql
- try to import a file that create same table and insert 3 lines (BDD_struct-data1-3data.sql)
Result: phpMyAdmin report an error that the table is already created

- create a table with sql file BDD_struct1.sql
- try to import a file that create same table and insert 687 lines (BDD_struct-data1-687data.sql)
Result: blank page or memory allocation error after several minutes

- create a table with sql file BDD_struct1.sql
- try to import a file that only insert 687 lines (BDD_data1-687.sql)
Result: 687 line inserted correctly

tested with two config:
- phpmyadmin Version: 3.1.3.2
- Apache/2.2.11
- MySQL: 5.1.34
and
- phpMyAdmin Version: 3.2.4
- Apache/2.2.3
- Version du client MySQL: 5.0.32

Discussion

  • create only table

     
    Attachments
  • create table and insert 3 lines

     
  • create table and insert 687 lines

     
  • only insert 687 lines

     
    Attachments
  • Marc Delisle
    Marc Delisle
    2010-01-27

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2010-01-27

    About your two first tests, this is expected behavior. If you want to avoid the error, just use CREATE TABLE IF NOT EXISTS `phpbb_acl_groups`.

    About your test #3, I can reproduce your problem under phpMyAdmin 3.2.5.

     
  • yes, sorry, I forgot to say that the test 1,2 and 4 were running as expected only the third one is wrong.
    I was putting them to test that it was not a probleme with sql schema or data I wanted to import

     
  • Marc Delisle
    Marc Delisle
    2010-01-28

    Started to test this. If I add "IF NOT EXISTS" clause to the CREATE TABLE statement of test 3, it works.

     
  • Marc Delisle
    Marc Delisle
    2010-01-31

    • milestone: 1000680 --> 3.2.5
    • priority: 5 --> 1
    • summary: import timeout when table already created and several data --> (oK 3.2.6)import timeout when table already created
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2010-01-31

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle
    Marc Delisle
    2010-03-08

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

    • Status: closed-fixed --> fixed