#30630 (MemoryError appears when using cx-Oracle 7.2 on Oracle 12c (12.1.0.2.0) with Python 3.7 (3.7.4).) – Django (original) (raw)

#30630 closed Bug (invalid)

Reported by: Owned by: nobody
Component: Database layer (models, ORM) Version: 2.2
Severity: Normal Keywords: oracle cx-oracle python-3.7
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

These are the queries being executed before the crash:

Query: ALTER SESSION SET NLS_TERRITORY = 'AMERICA' Params: [] Query: ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF' TIME_ZONE = 'UTC' Params: [] Query: SELECT 1 FROM DUAL WHERE DUMMY LIKE TRANSLATE(:arg0 USING NCHAR_CS) ESCAPE TRANSLATE('' USING NCHAR_CS) Params: {':arg0': 'X'}

This is the traceback output in the command line:

Traceback (most recent call last): File ".\manage.py", line 17, in execute_from_command_line(sys.argv) File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\core\management_init.py", line 381, in execute_from_command_line utility.execute() File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\core\management_init.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\core\management\base.py", line 323, in run_from_argv self.execute(*args, **cmd_options) File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\core\management\base.py", line 364, in execute output = self.handle(*args, **options) File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\core\management\commands\inspectdb.py", line 34, in handle for line in self.handle_inspection(options): File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\core\management\commands\inspectdb.py", line 47, in handle_inspection with connection.cursor() as cursor: File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\db\backends\base\base.py", line 256, in cursor return self._cursor() File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\db\backends\base\base.py", line 233, in _cursor self.ensure_connection() File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\db\backends\base\base.py", line 217, in ensure_connection self.connect() File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect self.init_connection_state() File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\db\backends\oracle\base.py", line 259, in init_connection_state ['X']) File "D:\Rudi\Workspace\Visual Studio\PTT Lite\env\lib\site-packages\django\db\backends\oracle\base.py", line 510, in execute return self.cursor.execute(query, self._param_generator(params)) MemoryError

The SELECT query returns 1 as a result if executed in Oracle SQL Developer so I assume the error is not in the execution of that command.
I don't know if it's a bug in Django, cx-Oracle or at some other level or if it's a configuration issue and have no clue how to proceed.

Database information:

Environment:

Change History(11)

comment:1 by Mariusz Felisiak, 6 years ago

Resolution: → invalid
Status: new → closed
Summary: MemoryError raised by inspectdb executed on Oracle 12c database → MemoryError raised by inspectdb executed on Oracle 12c.

comment:5 by Alexandru Rudi, 6 years ago

Tried using the same version of instant client as the database version (12.1.0.2.0). Error still appears.

comment:7 by Alexandru Rudi, 6 years ago

Keywords: cx-oracle python-3.7 added
Resolution: invalid
Status: closed → new
Summary: MemoryError raised by inspectdb executed on Oracle 12c. → MemoryError appears when using cx-Oracle 7.2 on Oracle 12c (12.1.0.2.0) with Python 3.7 (3.7.4).

comment:9 by Mariusz Felisiak, 6 years ago

Thanks for investigation, but I still don't believe that it is an issue in Django, it's probably some cx_Oracle issue with outputtypehandler related with a specific database, environment, OS, etc. configuration. I agree with Jani you could try to check with previous versions of cx_Oracle i.e. 7.1, 7.0, 6.X. If it works with other versions of cx_Oracle then you should report this issue in ​https://github.com/oracle/python-cx_Oracle/issues.

in reply to: 8 comment:10 by Alexandru Rudi, 6 years ago

Resolution: → invalid
Status: new → closed

Note: See TracTickets for help on using tickets.