RE: [sqlite] unaligned access with sqlite 3.3.3 on IA64

2006-02-12 Thread Chowdhury, Chandan Dutta 
 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 0x60404f44, 
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405094, 
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405154, 
> ip=0x24e683e0
> yum(26535): unaligned access to 0x6040e9f4, 
> ip=0x24e683e0 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=0x6fff9270, 
zSql=0x60011f20 "CREATE INDEX packageId ON packages
(pkgId)",
pzErrMsg=0x6fff9370) at ./src/tokenize.c:391

Calls sqlite3Parser  like this   (marked with ===)

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=1, yyminor=
  {z = 0x60011f49 ")", dyn = 0, n = 1},
pParse=0x6fff9270) at parse.c:3185
3185

The warning is produced here  (marked with ===)
gdb)
3218  int yymx;
(gdb)
sqlite3(8812): unaligned access to 0x600145e4,
ip=0x20094d41
3303}
(gdb)


Plz get back for any more info

Regards
Chandan Dutta Chowdhury

Log of gdb(full log attached)

=
Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=13,
yyminor=
  {z = 0x60011f20 "CREATE INDEX packageId ON packages
(pkgId)", dyn = 0, n = 6},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=132,
yyminor=
  {z = 0x60011f27 "INDEX packageId ON packages (pkgId)", dyn
= 0, n = 5},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=23,
yyminor=
  {z = 0x60011f2d "packageId ON packages (pkgId)", dyn = 0,
n = 9},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=97,
yyminor=
  {z = 0x60011f37 "ON packages (pkgId)", dyn = 0, n = 2},
pParse=0x6fff9270)
at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=23,
yyminor=
  {z = 0x60011f3a "packages (pkgId)", dyn = 0, n = 8},
pParse=0x6fff9270)
at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=19,
yyminor=
  {z = 0x60011f43 "(pkgId)", dyn = 0, n = 1},
pParse=0x6fff9270)
at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=23,
yyminor=
  {z = 0x60011f44 "pkgId)", dyn = 0, n = 5},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=20,
yyminor=
  {z = 0x60011f49 ")", dyn = 0, n = 1},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb) n
3189/* if( yymajor==0 ) return; // not sure why this was here...
*/
(gdb)
3190yypParser->yyidx = 0;
(gdb)
3197  sqlite3ParserARG_STORE;
(gdb)
3198
(gdb)
3199#ifndef NDEBUG
(gdb)
3208  yy_shift(yypParser,yyact,yymajor,);
(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,);
(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,);
(gdb)
3209  yypParser->yyerrcnt--;
(gdb)
3217}else if( yyact == YY_ERROR_ACTION ){
(gdb)
3

RE: [sqlite] unaligned access with sqlite 3.3.3 on IA64

2006-02-10 Thread Chowdhury, Chandan Dutta 
 

-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 0x60404f44, 
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405094, 
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405154, 
> ip=0x24e683e0
> yum(26535): unaligned access to 0x6040e9f4, 
> ip=0x24e683e0 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=0x6fff9270, 
zSql=0x60011f20 "CREATE INDEX packageId ON packages
(pkgId)",
pzErrMsg=0x6fff9370) at ./src/tokenize.c:391

Calls sqlite3Parser  like this   (marked with ===)

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=1, yyminor=
  {z = 0x60011f49 ")", dyn = 0, n = 1},
pParse=0x6fff9270) at parse.c:3185
3185

The warning is produced here  (marked with ===)
gdb)
3218  int yymx;
(gdb)
sqlite3(8812): unaligned access to 0x600145e4,
ip=0x20094d41
3303}
(gdb)


Plz get back for any more info

Regards
Chandan Dutta Chowdhury

Log of gdb(full log attached)

=
Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=13,
yyminor=
  {z = 0x60011f20 "CREATE INDEX packageId ON packages
(pkgId)", dyn = 0, n = 6},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=132,
yyminor=
  {z = 0x60011f27 "INDEX packageId ON packages (pkgId)", dyn
= 0, n = 5},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=23,
yyminor=
  {z = 0x60011f2d "packageId ON packages (pkgId)", dyn = 0,
n = 9},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=97,
yyminor=
  {z = 0x60011f37 "ON packages (pkgId)", dyn = 0, n = 2},
pParse=0x6fff9270)
at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=23,
yyminor=
  {z = 0x60011f3a "packages (pkgId)", dyn = 0, n = 8},
pParse=0x6fff9270)
at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=19,
yyminor=
  {z = 0x60011f43 "(pkgId)", dyn = 0, n = 1},
pParse=0x6fff9270)
at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=23,
yyminor=
  {z = 0x60011f44 "pkgId)", dyn = 0, n = 5},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb)
Continuing.

Breakpoint 2, sqlite3Parser (yyp=0x60012fc0, yymajor=20,
yyminor=
  {z = 0x60011f49 ")", dyn = 0, n = 1},
pParse=0x6fff9270) at parse.c:3185
3185
(gdb) n
3189/* if( yymajor==0 ) return; // not sure why this was here...
*/
(gdb)
3190yypParser->yyidx = 0;
(gdb)
3197  sqlite3ParserARG_STORE;
(gdb)
3198
(gdb)
3199#ifndef NDEBUG
(gdb)
3208  yy_shift(yypParser,yyact,yymajor,);
(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,);
(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,);
(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,);
(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,);
(gdb)
3209

Re: [sqlite] unaligned access with sqlite 3.3.3 on IA64

2006-02-10 Thread drh 
"Chowdhury, Chandan Dutta" <[EMAIL PROTECTED]> wrote:
> Reading repository metadata in from local files
> yum(26535): unaligned access to 0x60404f44,
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405094,
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405154,
> ip=0x24e683e0
> yum(26535): unaligned access to 0x6040e9f4,
> ip=0x24e683e0
> 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]>