Hello All, I am using sqlite-3.3.3 with yam and pysqlite on a RedHat Enterprise Linux 4 IA64 machine. I get a lot of "unaligned access" message while using yum.
# yum update Setting up Update Process Setting up repositories os 100% |=========================| 951 B 00:00 build_tools 100% |=========================| 951 B 00:00 Reading repository metadata in from local files yum(26535): unaligned access to 0x6000000000404f44, ip=0x2000000004e683e0 yum(26535): unaligned access to 0x6000000000405094, ip=0x2000000004e683e0 yum(26535): unaligned access to 0x6000000000405154, ip=0x2000000004e683e0 yum(26535): unaligned access to 0x600000000040e9f4, ip=0x2000000004e683e0 No Packages marked for Update/Obsoletion I have noticed some warnings while compiling sqlite-3.3.3 ./libtool --mode=compile gcc -O2 -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -c ./src/vdbe.c gcc -O2 -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -c ./src/vdbe.c -fPIC -DPIC -o .libs/vdbe.o ./src/vdbe.c: In function `sqlite3VdbeExec': ./src/vdbe.c:2000: warning: cast to pointer from integer of different size ./src/vdbe.c:2016: warning: cast from pointer to integer of different size gcc -O2 -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -c ./src/vdbe.c -o vdbe.o >/dev/null 2>&1 ... ... gcc -O2 -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -c ./src/table.c -fPIC -DPIC -o .libs/table.o ./src/table.c: In function `sqlite3_get_table': ./src/table.c:148: warning: cast to pointer from integer of different size ./src/table.c: In function `sqlite3_free_table': ./src/table.c:193: warning: cast from pointer to integer of different size gcc -O2 -g -DOS_UNIX=1 -DHAVE_USLEEP=1 -DHAVE_FDATASYNC=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0 -DSQLITE_OMIT_CURSOR -c ./src/table.c -o table.o >/dev/null 2>&1 The following confirms that the issue is coming from sqlite python Python 2.3.4 (#1, Feb 2 2005, 11:44:21) [GCC 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite >>> db = sqlite.connect("//var/cache/yum/os/primary.xml.gz.sqlite") >>> cur = db.cursor() >>> cur.execute("select * from db_info") python(26534): unaligned access to 0x600000000008dfe4, ip=0x20000000039503e0 python(26534): unaligned access to 0x600000000008e134, ip=0x20000000039503e0 python(26534): unaligned access to 0x600000000008e1f4, ip=0x20000000039503e0 Is this a bug in sqlite. Thanks in advance for the help. Regards Chandan Dutta Chowdhury