LOAD DATA LOCAL INFILE - Cannot execute queries while other unbuffered queries are active

Hi,

I am having trouble running the following prepared statement in Laravel:

$pdo = DB::connection()->getPdo(); $ps_TempTable_PushCsv = $pdo->prepare( "LOAD DATA LOCAL INFILE '123' INTO TABLE123CHARACTER SET utf8mb4 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\n'" ); $ps_TempTable_PushCsv->execute(); $ps_TempTable_PushCsv->closeCursor(); $rowCount = $ps_TempTable_PushCsv->rowCount();

I get the following error:

[2017-06-08 03:41:35] local.ERROR: PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.

This is the entry-point of my controller, so there are definitely no prior queries running.

What do?

Thanks

mils

8 years ago

Level 1

The only way I could get it working was to replace the prepared statement with an 'exec' call:

$rowCount = DB::connection()->getpdo()->exec( "LOAD DATA LOCAL INFILE '$fileName' INTO TABLE $tableName CHARACTER SET utf8mb4 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'" );

I have no idea why it wouldn't work using a prepared statement in Laravel - it definitely does work with a pure PDO prepared statement.

Please or to participate in this conversation.