search

WanderInCode / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

pyodbc execute dump #139

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.
import pyodbc
conn = pyodbc.connect("DRIVER={**};SERVER=**;UID=**;PWD=**;DATABASE=**")
cursor     = conn.cursor()
cursor.execute("insert into test1 values(?,?,?)", "aaaa","aaaa","ddd")  
--->with 3 column, its OK
cursor.execute("insert into test2 values(?,?,?,?)", "aaaa","aaaa","ddd","dd")
--->with 4 column, its dump

*** glibc detected *** /usr/bin/python: malloc(): memory corruption: 
0x00000000179e5f70 ***
======= Backtrace: =========
/lib64/libc.so.6[0x31d1c72fae]
/lib64/libc.so.6(__libc_malloc+0x6e)[0x31d1c74cde]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2ae6c4ad6638]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2ae6c4adee34]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2ae6c4af6b87]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2ae6c4af8971]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2ae6c4ae3181]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2ae6c4ae3f39]
/opt/vertica/lib64/libverticaodbc_unixodbc.so(SQLExecute+0xbc)[0x2ae6c4ae7a80]
/usr/lib64/libodbc.so.1(SQLExecute+0xd0)[0x31d2c15a00]
/usr/lib64/python2.4/site-packages/pyodbc.so[0x2ae6c3bcd831]
/usr/lib64/libpython2.4.so.1.0(PyEval_EvalFrame+0x49fa)[0x31e96950ba]
/usr/lib64/libpython2.4.so.1.0(PyEval_EvalCodeEx+0x925)[0x31e9695fe5]
/usr/lib64/libpython2.4.so.1.0(PyEval_EvalCode+0x32)[0x31e9696032]
/usr/lib64/libpython2.4.so.1.0[0x31e96b2729]
/usr/lib64/libpython2.4.so.1.0(PyRun_SimpleFileExFlags+0x1a8)[0x31e96b3bd8]
/usr/lib64/libpython2.4.so.1.0(Py_Main+0xa5d)[0x31e96ba00d]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x31d1c1d994]
/usr/bin/python[0x400629]
======= Memory map: ========
00400000-00401000 r-xp 00000000 08:03 7053367                            
/usr/bin/python
00600000-00601000 rw-p 00000000 08:03 7053367                            
/usr/bin/python
17947000-17abc000 rw-p 17947000 00:00 0                                  [heap]
31d1800000-31d181c000 r-xp 00000000 08:03 457883                         
/lib64/ld-2.5.so
31d1a1b000-31d1a1c000 r--p 0001b000 08:03 457883                         
/lib64/ld-2.5.so
31d1a1c000-31d1a1d000 rw-p 0001c000 08:03 457883                         
/lib64/ld-2.5.so
31d1c00000-31d1d4e000 r-xp 00000000 08:03 457887                         
/lib64/libc-2.5.so
31d1d4e000-31d1f4d000 ---p 0014e000 08:03 457887                         
/lib64/libc-2.5.so
31d1f4d000-31d1f51000 r--p 0014d000 08:03 457887                         
/lib64/libc-2.5.so
31d1f51000-31d1f52000 rw-p 00151000 08:03 457887                         
/lib64/libc-2.5.so
31d1f52000-31d1f57000 rw-p 31d1f52000 00:00 0 
31d2000000-31d2082000 r-xp 00000000 08:03 459063                         
/lib64/libm-2.5.so
31d2082000-31d2281000 ---p 00082000 08:03 459063                         
/lib64/libm-2.5.so
31d2281000-31d2282000 r--p 00081000 08:03 459063                         
/lib64/libm-2.5.so
31d2282000-31d2283000 rw-p 00082000 08:03 459063                         
/lib64/libm-2.5.so
31d2400000-31d2402000 r-xp 00000000 08:03 458113                         
/lib64/libdl-2.5.so
31d2402000-31d2602000 ---p 00002000 08:03 458113                         
/lib64/libdl-2.5.so
31d2602000-31d2603000 r--p 00002000 08:03 458113                         
/lib64/libdl-2.5.so
31d2603000-31d2604000 rw-p 00003000 08:03 458113                         
/lib64/libdl-2.5.so
31d2800000-31d2816000 r-xp 00000000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2816000-31d2a15000 ---p 00016000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2a15000-31d2a16000 r--p 00015000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2a16000-31d2a17000 rw-p 00016000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2a17000-31d2a1b000 rw-p 31d2a17000 00:00 0 
31d2c00000-31d2c5c000 r-xp 00000000 08:03 7057777                        
/usr/lib64/libodbc.so.1.0.0
31d2c5c000-31d2e5c000 ---p 0005c000 08:03 7057777                        
/usr/lib64/libodbc.so.1.0.0
31d2e5c000-31d2e64000 rw-p 0005c000 08:03 7057777                        
/usr/lib64/libodbc.so.1.0.0
31dc200000-31dc20d000 r-xp 00000000 08:03 457905                         
/lib64/libgcc_s-4.1.2-20080825.so.1
31dc20d000-31dc40d000 ---p 0000d000 08:03 457905                         
/lib64/libgcc_s-4.1.2-20080825.so.1
31dc40d000-31dc40e000 rw-p 0000d000 08:03 457905                         
/lib64/libgcc_s-4.1.2-20080825.so.1
31dfe00000-31dfe02000 r-xp 00000000 08:03 4590已放弃
[root@feixiao-linux Linux]# dos2unix insert.py
dos2unix: converting file insert.py to UNIX format ...
[root@feixiao-linux Linux]# ./insert.py
*** glibc detected *** /usr/bin/python: malloc(): memory corruption: 
0x000000000de8df70 ***
======= Backtrace: =========
/lib64/libc.so.6[0x31d1c72fae]
/lib64/libc.so.6(__libc_malloc+0x6e)[0x31d1c74cde]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2b727e4ae638]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2b727e4b6e34]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2b727e4ceb87]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2b727e4d0971]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2b727e4bb181]
/opt/vertica/lib64/libverticaodbc_unixodbc.so[0x2b727e4bbf39]
/opt/vertica/lib64/libverticaodbc_unixodbc.so(SQLExecute+0xbc)[0x2b727e4bfa80]
/usr/lib64/libodbc.so.1(SQLExecute+0xd0)[0x31d2c15a00]
/usr/lib64/python2.4/site-packages/pyodbc.so[0x2b727d5a5831]
/usr/lib64/libpython2.4.so.1.0(PyEval_EvalFrame+0x49fa)[0x31e96950ba]
/usr/lib64/libpython2.4.so.1.0(PyEval_EvalCodeEx+0x925)[0x31e9695fe5]
/usr/lib64/libpython2.4.so.1.0(PyEval_EvalCode+0x32)[0x31e9696032]
/usr/lib64/libpython2.4.so.1.0[0x31e96b2729]
/usr/lib64/libpython2.4.so.1.0(PyRun_SimpleFileExFlags+0x1a8)[0x31e96b3bd8]
/usr/lib64/libpython2.4.so.1.0(Py_Main+0xa5d)[0x31e96ba00d]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x31d1c1d994]
/usr/bin/python[0x400629]
======= Memory map: ========
00400000-00401000 r-xp 00000000 08:03 7053367                            
/usr/bin/python
00600000-00601000 rw-p 00000000 08:03 7053367                            
/usr/bin/python
0ddef000-0df64000 rw-p 0ddef000 00:00 0                                  [heap]
31d1800000-31d181c000 r-xp 00000000 08:03 457883                         
/lib64/ld-2.5.so
31d1a1b000-31d1a1c000 r--p 0001b000 08:03 457883                         
/lib64/ld-2.5.so
31d1a1c000-31d1a1d000 rw-p 0001c000 08:03 457883                         
/lib64/ld-2.5.so
31d1c00000-31d1d4e000 r-xp 00000000 08:03 457887                         
/lib64/libc-2.5.so
31d1d4e000-31d1f4d000 ---p 0014e000 08:03 457887                         
/lib64/libc-2.5.so
31d1f4d000-31d1f51000 r--p 0014d000 08:03 457887                         
/lib64/libc-2.5.so
31d1f51000-31d1f52000 rw-p 00151000 08:03 457887                         
/lib64/libc-2.5.so
31d1f52000-31d1f57000 rw-p 31d1f52000 00:00 0 
31d2000000-31d2082000 r-xp 00000000 08:03 459063                         
/lib64/libm-2.5.so
31d2082000-31d2281000 ---p 00082000 08:03 459063                         
/lib64/libm-2.5.so
31d2281000-31d2282000 r--p 00081000 08:03 459063                         
/lib64/libm-2.5.so
31d2282000-31d2283000 rw-p 00082000 08:03 459063                         
/lib64/libm-2.5.so
31d2400000-31d2402000 r-xp 00000000 08:03 458113                         
/lib64/libdl-2.5.so
31d2402000-31d2602000 ---p 00002000 08:03 458113                         
/lib64/libdl-2.5.so
31d2602000-31d2603000 r--p 00002000 08:03 458113                         
/lib64/libdl-2.5.so
31d2603000-31d2604000 rw-p 00003000 08:03 458113                         
/lib64/libdl-2.5.so
31d2800000-31d2816000 r-xp 00000000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2816000-31d2a15000 ---p 00016000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2a15000-31d2a16000 r--p 00015000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2a16000-31d2a17000 rw-p 00016000 08:03 458095                         
/lib64/libpthread-2.5.so
31d2a17000-31d2a1b000 rw-p 31d2a17000 00:00 0 
31d2c00000-31d2c5c000 r-xp 00000000 08:03 7057777                        
/usr/lib64/libodbc.so.1.0.0
31d2c5c000-31d2e5c000 ---p 0005c000 08:03 7057777                        
/usr/lib64/libodbc.so.1.0.0
31d2e5c000-31d2e64000 rw-p 0005c000 08:03 7057777                        
/usr/lib64/libodbc.so.1.0.0
31dc200000-31dc20d000 r-xp 00000000 08:03 457905                         
/lib64/libgcc_s-4.1.2-20080825.so.1
31dc20d000-31dc40d000 ---p 0000d000 08:03 457905                         
/lib64/libgcc_s-4.1.2-20080825.so.1
31dc40d000-31dc40e000 rw-p 0000d000 08:03 457905                         
/lib64/libgcc_s-4.1.2-20080825.so.1
31dfe00000-31dfe02000 r-xp 00000000 08:03 459066                         
/lib64/libutil-2.5.so
31dfe02000-31e0001000 ---p 00002000 08:03 459066                         
/lib64/libutil-2.5.so
31e0001000-31e0002000 r--p 00001000 08:03 459066                         
/lib64/libutil-2.5.so
31e0002000-31e0003000 rw-p 00002000 08:03 459066                         
/lib64/libutil-2.5.so
31e1e00000-31e1ee6000 r-xp 00000000 08:03 7053935                        
/usr/lib64/libstdc++.so.6.0.8
31e1ee6000-31e20e5000 ---p 000e6000 08:03 7053935                        
/usr/lib64/libstdc++.so.6.0.8
31e20e5000-31e20eb000 r--p 000e5000 08:03 7053935                        
/usr/lib64/libstdc++.so.6.0.8
31e20eb000-31e20ee000 rw-p 000eb000 08:03 7053935                        
/usr/lib64/libstdc++.so.6.0.8
31e20ee000-31e2100000 rw-p 31e20ee000 00:00 0 
31e9600000-31e9701000 r-xp 00000000 08:03 7062315                        
/usr/lib64/libpython2.4.so.1.0
31e9701000-31e9900000 ---p 00101000 08:03 7062315                        
/usr/lib64/libpython2.4.so.1.0
31e9900000-31e992d000 rw-p 00100000 08:03 7062315                        
/usr/lib64/libpython2.4.so.1.0
31e992d000-31e9932000 rw-p 31e992d000 00:00 0 
2b7279ef4000-2b7279ef5000 rw-p 2b7279ef4000 00:00 0 
2b7279f10000-2b7279f55000 rw-p 2b7279f10000 00:00 0 
2b7279f56000-2b7279f97000 rw-p 2b7279f56000 00:00 0 
2b7279f98000-2b7279fc9000 rw-p 2b7279f98000 00:00 0 
2b7279fc9000-2b727d59d000 r--p 00000000 08:03 7042461                    
/usr/lib/locale/locale-archive
2b727d59d000-2b727d5ae000 r-xp 00000000 08:03 7458245                    
/usr/lib64/python2.4/site-packages/pyodbc.so
2b727d5ae000-2b727d7ae000 ---p 00011000 08:03 7458245                    
/usr/lib64/python2.4/site-packages/pyodbc.so
2b727d7ae000-2b727d7b4000 rw-p 00011000 08:03 7458245                    
/usr/lib64/python2.4/site-packages/pyodbc.so
2b727d7b4000-2b727d7c3000 r-xp 00000000 08:03 7458273                    
/usr/lib64/python2.4/lib-dynload/datetime.so
2b727d7c3000-2b727d9c2000 ---p 0000f000 08:03 7458273                    
/usr/lib64/python2.4/lib-dynload/datetime.so
2b727d9c2000-2b727d9c6000 rw-p 0000e000 08:03 7458273                    
/usr/lib64/python2.4/lib-dynload/datetime.so
2b727d9c7000-2b727da08000 rw-p 2b727d9c7000 00:00 0 
2b727da08000-2b727da0d000 r-xp 00000000 08:03 7458297                    
/usr/lib64/python2.4/lib-dynload/stropmodule.so
2b727da0d000-2b727dc0c000 ---p 00005000 08:03 7458297                    
/usr/lib64/python2.4/lib-dynload/stropmodule.so
2b727dc0c000-2b727dc0e000 rw-p 00004000 08:03 7458297                    
/usr/lib64/python2.4/lib-dynload/stropmodule.so
2b727dc0f000-2b727dc50000 rw-p 2b727dc0f000 00:00 0 
2b727dc50000-2b727dc53000 r-xp 00000000 08:03 7459256                    
/usr/lib64/python2.4/lib-dynload/timemodule.so
2b727dc53000-2b727de53000 ---p 00003000 08:03 7459256                    
/usr/lib64/python2.4/lib-dynload/timemodule.so
2b727de53000-2b727de55000 rw-p 00003000 08:03 7459256                    
/usr/lib64/python2.4/lib-dynload/timemodule.so
2b727de55000-2b727de59000 r-xp 00000000 08:03 7458271                    
/usr/lib64/python2.4/lib-dynload/collectionsmodule.so
2b727de59000-2b727e059000 ---p 00004000 08:03 7458271                    
/usr/lib64/python2.4/lib-dynload/collectionsmodule.so
2b727e059000-2b727e05a000 rw-p 00004000 08:03 7458271                    
/usr/lib64/python2.4/lib-dynload/collectionsmodule.so
2b727e05a000-2b727e05e000 r-xp 00000000 08:03 7458257                    
/usr/lib64/python2.4/lib-dynload/_localemodule.so
2b727e05e000-2b727e25e000 ---p 00004000 08:03 7458257                    
/usr/lib64/python2.4/lib-dynload/_localemodule.so
2b727e25e000-2b727e25f000 rw-p 00004000 08:03 7458257                    
/usr/lib64/python2.4/lib-dynload/_localemodule.so
2b727e25f000-2b727e260000 rw-s 00000000 00:09 22708254                   
/SYSV790303b6 (deleted)
2b727e260000-2b727e267000 r--s 00000000 08:03 7129972                    
/usr/lib64/gconv/gconv-modules.cache
2b727e267000-2b727e268000 r-xp 00000000 08:03 7130155                    
/usr/lib64/gconv/ISO8859-1.so
2b727e268000-2b727e468000 ---p 00001000 08:03 7130155                    
/usr/lib64/gconv/ISO8859-1.so
2b727e468000-2b727e46a000 rw-p 00001000 08:03 7130155                    
/usr/lib64/gconv/ISO8859-1.so
2b727e46a000-2b727e5e3000 r-xp 00000000 08:03 3173005                    
/opt/vertica/lib64/vertica_4.1.2_odbc_3.5_unixodbc_x86_64_linux.so
2b727e5e3000-2b727e6e3000 ---p 00179000 08:03 3173005                    
/opt/vertica/lib64/vertica_4.1.2_odbc_3.5_unixodbc_x86_64_linux.so
2b727e6e3000-2b727e70b000 rw-p 00179000 08:03 3173005                    
/opt/vertica/lib64/vertica_4.1.2_odbc_3.5_unixodbc_x86_64_linux.so
2b727e70b000-2b727e710000 rw-p 2b727e70b000 00:00 0 
2b727e72b000-2b727e73d000 r-xp 00000000 08:03 7047284                    
/usr/lib64/libodbcinst.so.1.0.0
2b727e73d000-2b727e93d000 ---p 00012000 08:03 7047284                    
/usr/lib64/libodbcinst.so.1.0.0
2b727e93d000-2b727e93e000 rw-p 00012000 08:03 7047284                    
/usr/lib64/libodbcinst.so.1.0.0
2b727e93e000-2b727e948000 r-xp 00000000 08:03 457879                     
/lib64/libnss_files-2.5.so
2b727e948000-2b727eb47000 ---p 0000a000 08:03 457879                     
/lib64/libnss_files-2.5.so
2b727eb47000-2b727eb48000 r--p 00009000 08:03 457879                     
/lib64/libnss_files-2.5.so
2b727eb48000-2b727eb49000 rw-p 0000a000 08:03 457879                     
/lib64/libnss_files-2.5.so
2b7280000000-2b7280021000 rw-p 2b7280000000 00:00 0 
2b7280021000-2b7284000000 ---p 2b7280021000 00:00 0 
7fff1de3f000-7fff1de7d000 rw-p 7ffffffc0000 00:00 0                      [stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0                  [vdso]

What is the expected output? What do you see instead?

What version of the product are you using? On what operating system?

Please provide any additional information below.

Original issue reported on code.google.com by feix...@platform.com on 19 Nov 2010 at 4:08

GoogleCodeExporter commented 8 years ago 
What version of pyodbc are you using?  If not the latest, can you test with the 
latest?

Original comment by mkleehammer on 24 Nov 2010 at 8:10