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

Reply via email to