Thanks for the fix, every thing seems to work fine with sqlite-3.3.4 Regards Chandan Dutta Chowdhury
-----Original Message----- From: Chowdhury, Chandan Dutta Sent: Saturday, February 11, 2006 12:32 PM To: [EMAIL PROTECTED]; sqlite-users@sqlite.org Subject: RE: [sqlite] unaligned access with sqlite 3.3.3 on IA64 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 7:41 PM To: sqlite-users@sqlite.org; Chowdhury, Chandan Dutta Subject: Re: [sqlite] unaligned access with sqlite 3.3.3 on IA64 "Chowdhury, Chandan Dutta" <[EMAIL PROTECTED]> wrote: > 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 need additional clues. Can you please recompile with -g, run this in a debugger, and let me know exactly where the misaligned access occurs? I am holding up the release of 3.3.4 on this issue. -- D. Richard Hipp <[EMAIL PROTECTED]> ________________________________________________________ I am not a gdb expert (not even a developer), I am more of a sysadmin, so Plz excuse if the info is not what you want . Here is what I could find. The problem seems to come from sqlite3Parser and sqlite3RunParser A call to sqlite3RunParser like this (marked with ===========) sqlite3RunParser (pParse=0x60000fffffff9270, zSql=0x6000000000011f20 "CREATE INDEX packageId ON packages (pkgId)", pzErrMsg=0x60000fffffff9370) at ./src/tokenize.c:391 Calls sqlite3Parser like this (marked with ===========) Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=1, yyminor= {z = 0x6000000000011f49 ")", dyn = 0, n = 1}, pParse=0x60000fffffff9270) at parse.c:3185 3185 The warning is produced here (marked with ===========) gdb) 3218 int yymx; (gdb) sqlite3(8812): unaligned access to 0x60000000000145e4, ip=0x2000000000094d41 3303 } (gdb) Plz get back for any more info Regards Chandan Dutta Chowdhury Log of gdb(full log attached) ======================================================================== ===== Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=13, yyminor= {z = 0x6000000000011f20 "CREATE INDEX packageId ON packages (pkgId)", dyn = 0, n = 6}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=132, yyminor= {z = 0x6000000000011f27 "INDEX packageId ON packages (pkgId)", dyn = 0, n = 5}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=23, yyminor= {z = 0x6000000000011f2d "packageId ON packages (pkgId)", dyn = 0, n = 9}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=97, yyminor= {z = 0x6000000000011f37 "ON packages (pkgId)", dyn = 0, n = 2}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=23, yyminor= {z = 0x6000000000011f3a "packages (pkgId)", dyn = 0, n = 8}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=19, yyminor= {z = 0x6000000000011f43 "(pkgId)", dyn = 0, n = 1}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=23, yyminor= {z = 0x6000000000011f44 "pkgId)", dyn = 0, n = 5}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) Continuing. Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=20, yyminor= {z = 0x6000000000011f49 ")", dyn = 0, n = 1}, pParse=0x60000fffffff9270) at parse.c:3185 3185 (gdb) n 3189 /* if( yymajor==0 ) return; // not sure why this was here... */ (gdb) 3190 yypParser->yyidx = 0; (gdb) 3197 sqlite3ParserARG_STORE; (gdb) 3198 (gdb) 3199 #ifndef NDEBUG (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3217 }else if( yyact == YY_ERROR_ACTION ){ (gdb) 3218 int yymx; (gdb) 3303 } (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3217 }else if( yyact == YY_ERROR_ACTION ){ (gdb) 3218 int yymx; (gdb) 3303 } (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3217 }else if( yyact == YY_ERROR_ACTION ){ (gdb) 3218 int yymx; (gdb) 3303 } (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3217 }else if( yyact == YY_ERROR_ACTION ){ (gdb) 3218 int yymx; (gdb) 3303 } (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3217 }else if( yyact == YY_ERROR_ACTION ){ (gdb) 3218 int yymx; (gdb) 3303 } (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3210 if( yyendofinput && yypParser->yyidx>=0 ){ (gdb) 3211 yymajor = 0; (gdb) 3212 }else{ (gdb) 3215 }else if( yyact < YYNSTATE + YYNRULE ){ (gdb) 3303 } (gdb) Line number 3305 out of range; parse.c has 3303 lines. (gdb) Line number 3305 out of range; parse.c has 3303 lines. (gdb) ======================================================================== ===== sqlite3RunParser (pParse=0x60000fffffff9270, zSql=0x6000000000011f20 "CREATE INDEX packageId ON packages (pkgId)", pzErrMsg=0x60000fffffff9370) at ./src/tokenize.c:391 ======================================================================== ===== 391 sqlite3Parser(pEngine, tokenType, pParse->sLastToken, pParse); (gdb) 392 lastTokenParsed = tokenType; (gdb) 393 if( pParse->rc!=SQLITE_OK ){ (gdb) 361 while( !sqlite3MallocFailed() && zSql[i]!=0 ){ (gdb) 401 if( zSql[i]==0 && nErr==0 && pParse->rc==SQLITE_OK ){ (gdb) 402 if( lastTokenParsed!=TK_SEMI ){ (gdb) 403 sqlite3Parser(pEngine, TK_SEMI, pParse->sLastToken, pParse); (gdb) ======================================================================== ===== Breakpoint 2, sqlite3Parser (yyp=0x6000000000012fc0, yymajor=1, yyminor= {z = 0x6000000000011f49 ")", dyn = 0, n = 1}, pParse=0x60000fffffff9270) at parse.c:3185 3185 ======================================================================== ===== (gdb) 3189 /* if( yymajor==0 ) return; // not sure why this was here... */ (gdb) 3190 yypParser->yyidx = 0; (gdb) 3197 sqlite3ParserARG_STORE; (gdb) 3198 (gdb) 3199 #ifndef NDEBUG (gdb) 3208 yy_shift(yypParser,yyact,yymajor,&yyminorunion); (gdb) 3209 yypParser->yyerrcnt--; (gdb) 3217 }else if( yyact == YY_ERROR_ACTION ){ ======================================================================== ===== (gdb) 3218 int yymx; (gdb) sqlite3(8812): unaligned access to 0x60000000000145e4, ip=0x2000000000094d41 3303 } (gdb) ======================================================================== =====