MYSQL Connector/Python Fails on LOAD DATA INFILE commands. (Doc ID 1588043.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Connectors - Version 5.2 and later
Information in this document applies to any platform.
Connector versions that are distributed as part of the Linux distribution are not reliable always up to date as the current version from the official MySQL site.

Symptoms

On : 5.2 version, Connector/Python

When attempting to do a LOAD DATA INFILE command,
the following error occurs.

ERROR
-----------------------
(The exception is trapped and called 'e' here)

e
InterfaceError()

e.args
()

e.errno
-1

e.message
''

e.msg
'Failed executing the operation; an integer is required'

e.sqlstate
-1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect to MySQL Server using pre-1.0 version of Connector/Python.
2. Attempt a LOAD DATA INFILE command on the server.
3. Catch the exception.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the standard range of commands offered by MySQL Server.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms