Comment 2 for bug 887051

Revision history for this message
Elena Stepanova (elenst) wrote :

To reproduce the problem manually:

- Create a text file update.in with two lines in it, e.g.
saved1
saved2
- Start a server on a fresh data folder, default server settings are enough
- Execute SQL

USE test;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1
( word VARCHAR(255) PRIMARY KEY ) ENGINE=Aria;
LOAD DATA LOCAL INFILE 'update.in' INTO TABLE t1;
SET AUTOCOMMIT=0;
DELETE FROM t1;
LOAD DATA LOCAL INFILE 'update.in'
INTO TABLE t1 IGNORE 1 LINES;
COMMIT;

(make sure you have the right path to update.in)
- kill server with SIGKILL or alike
- try to start server on the same datadir again