Process exit with code 9

[ioalloc]

I use cx_oracle to fetch a large amount data to csv file, but the process has crashed occasionally, the process exit code is 9.

It's seems only happened on frozen app for now.

I use cx_freeze build a frozen app in this environment:

python version & platform:

Python 2.6.6 (r266:84292, Jul 23 2015, 15:22:56)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-11)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import platform
>>> platform.platform()
'Linux-2.6.32-504.el6.x86_64-x86_64-with-centos-6.6-Final'

python package:

cx_freeze==4.3.4
cx_Oracle==5.2.1

oracle instant client:

instantclient_11_2

the app running on:

platform:

Linux-2.6.32-573.12.1.el6.x86_64-x86_64-with-centos-6.7-Final

oracle instant:

instantclient_11_2

oracle server:

10.2.0.5

[anthony-tuininga]

Exit code 9 can be due to the OS killing your process due to being out of memory. Check your system logs to see if that is the case. How are you processing the large amount of data? Can you share your code?

[ioalloc]

It is likely that out of memory.

• I fetch 10000 rows from database as a data package, and packages stored in a Queue(10).
• Another thread read from the queue and processing with a custom json.Encoder to dumps as a string
• Use http(requests) post to another server

It seems solved after I adjust package's length to 2000 rows.
But I still want to know it there any document explain the exit code 9?

[anthony-tuininga]

This Stack Overflow question discusses the matter. Maybe it will answer your questions?

http://stackoverflow.com/questions/40888164/c-program-crashes-with-exit-code-9-sigkill

[ioalloc]

Thank you every much.

[ioalloc]

Finally, I got the std.err output after process crashed, the error was:

ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=128] [si_int=0] [si_ptr=(nil)] [si_addr=(nil)]
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=128] [si_int=1006559164] [si_ptr=0x7fd53bfedfbc] [si_addr=(nil)]
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=128] [si_int=25] [si_ptr=0x19] [si_addr=(nil)]

I search on google (see: stackoverflow), found it's due to Invalid memory reference, Is this error cause the crash?

[jmcp]

Can you provide the stack trace(s) from each of those threads? si_signo=11 means that the process had a segmentation violation, which is sometimes referred to as "smashing the stack". Without code (and thread stacks) there's not much more that we can advise you of.

[anthony-tuininga]

Closing due to lack of feedback.