On Monday 31 July 2006 15:03, you wrote: > Christoph Haas ([EMAIL PROTECTED]): > > The current "Etch" version of python-sqlalchemy does not seem to be > > able to connect to PostgreSQL when python-psycopg is installed (as > > "Suggested:") but python-psycopg2 is not. > > > > Error message: > > *** glibc detected *** malloc(): memory corruption: 0x0818ee38 *** > > > > However when python-psycopg2 is installed, too, then the program runs > > well. > > I have downgraded my python-sqlalchemy package version to 0.2.3, removed > python-psycopg2 (2.0.2-1) package (python-psycopg in version 1.1.21-9 is > still installed) and my app. *still* works with PostgreSQL 8.1 (8.1.4-5) > > Could you provide more info?
I will try. The error happens when running the "First Steps" demo program at http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html exactly at the "users.create()" statement. The connection string looks a bit different here though: db = create_engine('postgres://username:[EMAIL PROTECTED]:5432/mydatabase') I have postgresql-8.1 (8.1.4-4) installed. It's a Sarge server that I dist-ugpraded to Etch today. It happens both with python2.3 and python2.4. The last lines of an strace of this program: open("/usr/lib/python23.zip/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/plat-linux2/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/lib-tk/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/lib-dynload/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/local/lib/python2.3/site-packages/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/site-packages/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/site-packages/Numeric/psycopg2", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/Numeric/psycopg2.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/Numeric/psycopg2module.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/Numeric/psycopg2.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/Numeric/psycopg2.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/site-packages/sqlalchemy/databases/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/sqlalchemy/databases/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/sqlalchemy/databases/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/sqlalchemy/databases/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/sqlalchemy/databases/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/home/janus/v2/experimente/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/home/janus/v2/experimente/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/home/janus/v2/experimente/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/home/janus/v2/experimente/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/home/janus/v2/experimente/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python23.zip/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python23.zip/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/plat-linux2/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/plat-linux2/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/lib-tk/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-tk/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/lib-dynload/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/lib-dynload/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/local/lib/python2.3/site-packages/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg.py", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/local/lib/python2.3/site-packages/psycopg.pyc", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) stat64("/usr/lib/python2.3/site-packages/psycopg", 0xbfffbd0c) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/psycopg.so", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/usr/lib/python2.3/site-packages/psycopgmodule.so", O_RDONLY|O_LARGEFILE) = 4 fstat64(4, {st_mode=S_IFREG|0644, st_size=52960, ...}) = 0 open("/usr/lib/python2.3/site-packages/psycopgmodule.so", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`0\0\000"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=52960, ...}) = 0 mmap2(NULL, 56228, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x40752000 mmap2(0x4075d000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0xa) = 0x4075d000 close(5) = 0 open("/etc/ld.so.cache", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=20796, ...}) = 0 mmap2(NULL, 20796, PROT_READ, MAP_PRIVATE, 5, 0) = 0x40760000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/libpq.so.4", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\\\0"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=119440, ...}) = 0 mmap2(NULL, 118412, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x40766000 mmap2(0x40782000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x1c) = 0x40782000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/libcrypt.so.1", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\10\0\000"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=21872, ...}) = 0 mmap2(NULL, 184636, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x40783000 mmap2(0x40788000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x4) = 0x40788000 mmap2(0x4078a000, 155964, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4078a000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/libkrb5.so.3", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\364\0"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=508328, ...}) = 0 mmap2(NULL, 507140, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x407b1000 mmap2(0x4082b000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x7a) = 0x4082b000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/libk5crypto.so.3", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`5\0\000"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=151252, ...}) = 0 mmap2(NULL, 150752, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x4082d000 mmap2(0x40851000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x24) = 0x40851000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/libcom_err.so.2", O_RDONLY) = 5 read(5, "[EMAIL PROTECTED]"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=5824, ...}) = 0 mmap2(NULL, 8880, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x404e5000 mmap2(0x404e7000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x1) = 0x404e7000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/libresolv.so.2", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p$\0\000"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=59172, ...}) = 0 mmap2(NULL, 71784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x40852000 mmap2(0x40860000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0xd) = 0x40860000 mmap2(0x40862000, 6248, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40862000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/libnsl.so.1", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\3405\0"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=76792, ...}) = 0 mmap2(NULL, 88096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x40864000 mmap2(0x40876000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x11) = 0x40876000 mmap2(0x40878000, 6176, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40878000 close(5) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/libkrb5support.so.0", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 \n\0\000"..., 512) = 512 fstat64(5, {st_mode=S_IFREG|0644, st_size=14504, ...}) = 0 mmap2(NULL, 17416, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x4087a000 mmap2(0x4087e000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x3) = 0x4087e000 close(5) = 0 munmap(0x40760000, 20796) = 0 close(4) = 0 close(3) = 0 open("/dev/tty", O_RDWR|O_NONBLOCK|O_NOCTTY) = 3 writev(3, [{"*** glibc detected *** ", 23}, {"malloc(): memory corruption", 27}, {": 0x", 4}, {"0822b7e0", 8}, {" ***\n", 5}], 5*** glibc detected *** malloc(): memory corruption: 0x0822b7e0 *** ) = 67 rt_sigprocmask(SIG_UNBLOCK, [ABRT], NULL, 8) = 0 kill(21239, SIGABRT) = 0 --- SIGABRT (Aborted) @ 0 (0) --- +++ killed by SIGABRT +++ Process 21239 detached What other information could help? Christoph P.S.: Thanks for the quick reaction. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]