[#3962] sqlite test case dump when build with 3.4 toolchain

Document created by Aaronwu Employee on Aug 28, 2013
Version 1Show Document
  • View in full screen mode

[#3962] sqlite test case dump when build with 3.4 toolchain

Submitted By: Mingquan Pan

Open Date

2008-03-07 02:24:22     Close Date

2008-04-28 01:58:07

Priority:

Medium     Assignee:

Bernd Schmidt

Status:

Closed     Fixed In Release:

N/A

Found In Release:

N/A     Release:

Category:

N/A     Board:

N/A

Processor:

N/A     Silicon Revision:

Is this bug repeatable?:

Yes     Resolution:

N/A

Uboot version or rev.:

    Toolchain version or rev.:

3.4 toolchain of 08r1-8

App binary format:

N/A     

Summary: sqlite test case dump when build with 3.4 toolchain

Details:

 

sqlite test case dump when build with 3.4 toolchain.

 

 

bfin> bootelf^M

Loading .text @ 0x00001000 (997296 bytes)^M

Loading .rodata @ 0x000f5000 (231716 bytes)^M

Loading __ksymtab @ 0x0012d924 (14320 bytes)^M

Loading __ksymtab_gpl @ 0x00131114 (4016 bytes)^M

Loading __ksymtab_strings @ 0x001320c4 (43892 bytes)^M

Loading __param @ 0x0013cc38 (300 bytes)^M

Loading .data @ 0x0013d000 (77824 bytes)^M

Loading .init.text @ 0x00150000 (91156 bytes)^M

Loading .init.data @ 0x00166414 (3340 bytes)^M

Loading .init.setup @ 0x00167120 (588 bytes)^M

Loading .initcall.init @ 0x0016736c (428 bytes)^M

Loading .con_initcall.init @ 0x00167518 (4 bytes)^M

Loading .init.ramfs @ 0x0016751c (3816092 bytes)^M

Loading .text_l1 @ 0xffa00000 (8064 bytes)^M

sh_addr: FFA00000, p_paddr: 0050AFB8^M

Loading from: 0250B000 to 0050AFB8, size: 8064^M

Loading .data_l1 @ 0xff800000 (192 bytes)^M

sh_addr: FF800000, p_paddr: 0050CF38^M

Loading from: 0250D000 to 0050CF38, size: 192^M

Clearing .bss @ 0x0050d000 (59648 bytes)^M

## Starting application at 0x00150000 ...^M

Linux version 2.6.22.18-ADI-2008R1-svn4400 (test@uclinux45-toochain34) (gcc version 3.4.6 (ADI svn)) #185 Thu Mar 6 10:32:08 CST 2008^M

early printk enabled on early_BFuart0^M

Hardware Trace Active and Enabled^M

Warning: limiting memory to 56MB due to hardware anomaly 05000263^M

Recovering from Watchdog event^M

Blackfin support (C) 2004-2007 Analog Devices, Inc.^M

Compiled for ADSP-BF537 Rev 0.2^M

Blackfin Linux support by   blackfin.uclinux.org/^M

Processor Speed: 500 MHz core clock and 100 MHz System Clock^M

Board Memory: 64MB^M

Kernel Managed Memory: 64MB^M

Memory map:^M

  text      = 0x00001000-0x000f47b0^M

  rodata    = 0x000f5000-0x0013cd64^M

  data      = 0x0013d000-0x00150000^M

    stack   = 0x0013e000-0x00140000^M

  init      = 0x00150000-0x0050d000^M

  bss       = 0x0050d000-0x0051b900^M

  available = 0x0051b900-0x037ff000^M

  DMA Zone  = 0x03f00000-0x04000000^M

Instruction Cache Enabled^M

Data Cache Enabled (write-through)^M

Built 1 zonelists.  Total pages: 14224^M

Kernel command line: root=/dev/mtdblock0 rw earlyprintk=serial,uart0,57600^M

Configuring Blackfin Priority Driven Interrupts^M

PID hash table entries: 256 (order: 8, 1024 bytes)^M

bfin-rtc: invalid date; resetting^M

console handover: boot [early_BFuart0] -> real [ttyBF0]^M

Dentry cache hash table entries: 8192 (order: 3, 32768 bytes)^M

Inode-cache hash table entries: 4096 (order: 2, 16384 bytes)^M

Memory available: 51532k/65536k RAM, (3828k init code, 973k kernel code, 425k data, 1024k dma, 7756k reserved)^M

Blackfin Scratchpad data SRAM: 4 KB^M

Blackfin Data A SRAM: 16 KB (15 KB free)^M

Blackfin Data B SRAM: 16 KB (16 KB free)^M

Blackfin Instruction SRAM: 48 KB (40 KB free)^M

Security Framework v1.0.0 initialized^M

Mount-cache hash table entries: 512^M

NET: Registered protocol family 16^M

Blackfin GPIO Controller^M

Blackfin DMA Controller^M

stamp_init(): registering device resources^M

Generic PHY: Registered new driver^M

NET: Registered protocol family 2^M^TIP route cache hash table entries: 1024 (order: 0, 4096 bytes)^M

TCP established hash table entries: 2048 (order: 2, 16384 bytes)^M

TCP bind hash table entries: 2048 (order: 1, 8192 bytes)^M

TCP: Hash tables configured (established 2048 bind 2048)^M

TCP reno registered^M

io scheduler noop registered^M

io scheduler anticipatory registered (default)^M

io scheduler cfq registered^M

bfin-wdt: initialized: timeout=20 sec (nowayout=0)^M

Serial: Blackfin serial driver^M

bfin-uart.1: ttyBF0 at MMIO 0xffc00400 (irq = 18) is a BFIN-UART^M

RAMDISK driver initialized: 16 RAM disks of 4096K size 1024 blocksize^M

SMSC LAN83C185: Registered new driver^M

bfin_mac_mdio: probed^M

bfin_mac: attached PHY driver [SMSC LAN83C185] (mii_bus:phy_addr=0:01, irq=-1, mdc_clk=2500000Hz(mdc_div=19)@sclk=100MHz)^M

bfin_mac: Version 1.1, Blackfin BF53[67] BF527 on-chip Ethernet MAC driver^M

bfin-spi bfin-spi.0: Blackfin BF5xx on-chip SPI Contoller Driver, Version 1.0, regs_base@ffc00500, dma channel@7^M

rtc-bfin rtc-bfin: rtc core: registered rtc-bfin as rtc0^M

TCP cubic registered^M

NET: Registered protocol family 1^M

NET: Registered protocol family 17^M

rtc-bfin rtc-bfin: setting the system clock to 1970-01-01 00:00:02 (2)^M

Freeing unused kernel memory: 3828k freed^M

dma_alloc_init: dma_page @ 0x0050a000 - 256 pages at 0x03f00000^M

 

...

 

 

sqlite3 wishlist.db < /usr/wishlist.sql

root:/> sqlite3 wishlist.db ".dump"

BEGIN TRANSACTION;

CREATE TABLE item (

ntid integer priJump to address 0 - 0x0fff_id

arDeferet nud Exception context

ptCaURRENT PROCESS:

BLoCOMM=sqlite3 PID=107

) TEXT = 0x03380040-0x033bac20y k  DATA = 0x033bac24-0x033c5464

ot-STACK = 0x033c9f640x0ha33c5a74   USll,

  null

)

return a INTddress: [0ALUEx00000002]; contents of:t

 

SEQUENCER STATUS:               Not tainted

SEQSTAT: 0006202d  IPEND: 0030  SYSCFG: 0006

  HWERRCAUSE: 0x18

  EXCAUSE   : 0x2d

RETE: <0x00000000> /* Maybe null pointer? */

RETN: <0x004a2000> [ sqlite3 + 0x0 ]

RETX: <0x00000002> /* Maybe null pointer? */

RETS: <0x033800aa> [ sqlite3 + 0x6a ]

PC  : <0x00000002> /* Maybe null pointer? */

DCPLB_FAULT_ADDR: <0x033c48f8> [ sqlite3 + 0x448f8 ]

ICPLB_FAULT_ADDR: <0x00000002> /* Maybe null pointer? */

 

PROCESSOR STATE:

R0 : 033c4910    R1 : 033c5464    R2 : 033c536c    R3 : 00000000

R4 : 00000000    R5 : 00000003    R6 : 00000000    R7 : 033c89ac

P0 : 00000020    P1 : 00000001    P2 : 00000002    P3 : 00000001

P4 : 033c5464    P5 : 033c48f8    FP : 033c8960    SP : 004a1f24

LB0: 033b3f15    LT0: 033b3f08    LC0: 00000000

LB1: 033b7845    LT1: 033b7844    LC1: 00000000

B0 : 00000000    L0 : 00000000    M0 : 00000000    I0 : 033c085c

B1 : 00000000    L1 : 00000000    M1 : 00000000    I1 : 00000002

B2 : 00000000    L2 : 00000000    M2 : 00000000    I2 : 00000000

B3 : 00000000    L3 : 00000000    M3 : 00000000    I3 : 033c432c

A0.w: 00000000   A0.x: 00000000   A1.w: 00000000   A1.x: 00000000

USP : 033c8954  ASTAT: 02002000

 

Hardware Trace:

   0 Target : <0x0000426c> { _trap_c + 0x0 }

     Source : <0xffa0073c> { _exception_to_level5 + 0xb4 }

   1 Target : <0xffa00688> { _exception_to_level5 + 0x0 }

     Source : <0xffa005e4> { _ex_trap_c + 0x5c }

   2 Target : <0xffa00588> { _ex_trap_c + 0x0 }

     Source : <0xffa007dc> { _trap + 0x28 }

   3 Target : <0xffa007b4> { _trap + 0x0 }

     Source : <0x033800a8> [ sqlite3 + 0x68 ]

   4 Target : <0x033800a2> [ sqlite3 + 0x62 ]

     Source : <0x033800b0> [ sqlite3 + 0x70 ]

   5 Target : <0x033800aa> [ sqlite3 + 0x6a ]

     Source : <0x033800a0> [ sqlite3 + 0x60 ]

   6 Target : <0x03380084> [ sqlite3 + 0x44 ]

     Source : <0x033bac0e> [ sqlite3 + 0x3abce ]

   7 Target : <0x033bac0a> [ sqlite3 + 0x3abca ]

     Source : <0x033b9374> [ sqlite3 + 0x39334 ]

   8 Target : <0x033b9366> [ sqlite3 + 0x39326 ]

     Source : <0x033b9356> [ sqlite3 + 0x39316 ]

   9 Target : <0x033b9334> [ sqlite3 + 0x392f4 ]

     Source : <0x033b91f4> [ sqlite3 + 0x391b4 ]

  10 Target : <0x033b91f4> [ sqlite3 + 0x391b4 ]

     Source : <0x033b93b0> [ sqlite3 + 0x39370 ]

  11 Target : <0x033b93a4> [ sqlite3 + 0x39364 ]

     Source : <0x033b91f0> [ sqlite3 + 0x391b0 ]

  12 Target : <0x033b91ec> [ sqlite3 + 0x391ac ]

     Source : <0x033b91e6> [ sqlite3 + 0x391a6 ]

  13 Target : <0x033b91da> [ sqlite3 + 0x3919a ]

     Source : <0x033b93a0> [ sqlite3 + 0x39360 ]

  14 Target : <0x033b9394> [ sqlite3 + 0x39354 ]

     Source : <0x033b91d6> [ sqlite3 + 0x39196 ]

  15 Target : <0x033b91ce> [ sqlite3 + 0x3918e ]

     Source : <0x033b93b0> [ sqlite3 + 0x39370 ]

Stack from 004a1e80:

        00000000 00000000 033c4880 0003000b 032186fc 006a40c0 033c9fa1 00000002

        00000008 004a1ee8 033c5874 00000000 00000000 00000000 00000000 00000000

        00036b3c 004a1ee8 fffffff7 033c5874 00000008 00000001 00000000 0000000d

        00000003 004a1ee8 00000000 00000000 00000000 ffa00914 00036b08 00000004

        00000000 ffa00740 00142644 00142644 00142638 00000003 0a0a0a0a 00000001

        033b6512 00000002 00000030 0006202d 00000000 004a2000 00000002 00000002

 

Call Trace:

 

 

CREATE INDEX item_user on item (user_id);

COMMIT;

SIGSEGV

root:/>

 

Follow-ups

 

--- Bernd Schmidt                                            2008-03-17 08:47:04

I seem to recall there used to be a similar bug that got closed.  Is this the

same issue?

 

The bug description doesn't tell me anything about when the test case was run

successfully for the last time.

 

--- Bernd Schmidt                                            2008-04-25 11:44:05

I have a suspicion that this was caused by revision 4403 on March 5.  Can you

try again with an updated kernel?

 

--- Mingquan Pan                                             2008-04-28 01:58:06

Yeah, the case is ok now in trunk version svn4594.

 

Loading .text @ 0x00001000 (1038576 bytes)

Loading .exit.text.refok @ 0x000fe8f0 (324 bytes)

Loading .rodata @ 0x000fea40 (253288 bytes)

Loading __ksymtab @ 0x0013c7a8 (14888 bytes)

Loading __ksymtab_gpl @ 0x001401d0 (4168 bytes)

Loading __ksymtab_strings @ 0x00141218 (45848 bytes)

Loading __param @ 0x0014c530 (300 bytes)

Clearing .bss @ 0x0014c660 (54812 bytes)

Loading .data @ 0x00159c7c (82820 bytes)

Loading .init.text @ 0x0016e000 (95508 bytes)

Loading .init.data @ 0x00185514 (13224 bytes)

Loading .init.setup @ 0x001888bc (604 bytes)

Loading .initcall.init @ 0x00188b18 (448 bytes)

Loading .con_initcall.init @ 0x00188cd8 (4 bytes)

Loading .init.ramfs @ 0x00188cdc (3893495 bytes)

Loading .text_l1 @ 0xffa00000 (6972 bytes)

sh_addr: FFA00000, p_paddr: 0053F5D3

Loading from: 02533000 to 0053F5D3, size: 6972

Loading .data_l1 @ 0xff800000 (192 bytes)

sh_addr: FF800000, p_paddr: 0054110F

Loading from: 02535000 to 0054110F, size: 192

## Starting application at 0x0016e000 ...

Linux version 2.6.24.4-ADI-2008R2-pre-svn4594 (test@uclinux45-toochain34) (gcc

version 3.4.6 (ADI svn)) #189 Mon Apr 28 13:31:53 CST 2008

console [early_BFuart0] enabled

early printk enabled on early_BFuart0

Warning: limiting memory to 56MB due to hardware anomaly 05000263

Board Memory: 64MB

Kernel Managed Memory: 64MB

Memory map:

  fixedcode = 0x00000000400-0x00000000490

  text      = 0x000000001000-0x00000000fe8f0

  rodata    = 0x00000000fea40-0x0000000014c65c

  bss       = 0x0000000014c660-0x00000000159c7c

  data      = 0x00000000159c7c-0x0000000016e000

    stack   = 0x0000000016c000-0x0000000016e000

  init      = 0x0000000016e000-0x00000000542000

  available = 0x00000000542000-0x0000000037ff000

  DMA Zone  = 0x000000003f00000-0x000000004000000

Hardware Trace Active and Enabled

Reset caused by Software reset

Blackfin support (C) 2004-2008 Analog Devices, Inc.

Compiled for ADSP-BF537 Rev 0.2

Blackfin Linux support by   blackfin.uclinux.org/

Processor Speed: 500 MHz core clock and 100 MHz System Clock

NOMPU: setting up cplb tables for global access

Instruction Cache Enabled

Data Cache Enabled (write-through)

Built 1 zonelists in Zone order, mobility grouping off.  Total pages: 14224

Kernel command line: root=/dev/mtdblock0 rw earlyprintk=serial,uart0,57600

Configuring Blackfin Priority Driven Interrupts

PID hash table entries: 256 (order: 8, 1024 bytes)

console handover: boot [early_BFuart0] -> real [ttyBF0]

Dentry cache hash table entries: 8192 (order: 3, 32768 bytes)

Inode-cache hash table entries: 4096 (order: 2, 16384 bytes)

Memory available: 51376k/65536k RAM, (3920k init code, 1014k kernel code, 446k

data, 1024k dma, 7756k reserved)

Blackfin Scratchpad data SRAM: 4 KB

Blackfin Data A SRAM: 16 KB (15 KB free)

Blackfin Data B SRAM: 16 KB (16 KB free)

Blackfin Instruction SRAM: 48 KB (41 KB free)

Security Framework initialized

Mount-cache hash table entries: 512

net_namespace: 64 bytes

NET: Registered protocol family 16

Blackfin GPIO Controller

Blackfin DMA Controller

stamp_init(): registering device resources

NET: Registered protocol family 2

IP route cache hash table entries: 1024 (order: 0, 4096 bytes)

TCP established hash table entries: 2048 (order: 2, 16384 bytes)

TCP bind hash table entries: 2048 (order: 1, 8192 bytes)

TCP: Hash tables configured (established 2048 bind 2048)

TCP reno registered

io scheduler noop registered

io scheduler anticipatory registered (default)

io scheduler cfq registered

Serial: Blackfin serial driver

bfin-uart.1: ttyBF0 at MMIO 0x00000000ffc00400 (irq = 18) is a BFIN-UART

RAMDISK driver initialized: 16 RAM disks of 4096K size 1024 blocksize

bfin_mac_mdio: probed

bfin_mac: attached PHY driver [SMSC LAN83C185] (mii_bus:phy_addr=0:000000001,

irq=-1, mdc_clk=2500000Hz(mdc_div=19)@sclk=100MHz)

bfin_mac bfin_mac.0: Blackfin on-chip Ethernet MAC driver, Version 1.1

bfin-spi bfin-spi.0: Blackfin BF5xx on-chip SPI Controller Driver, Version 1.0,

regs_base@00000000ffc00500, dma channel@7

rtc-bfin rtc-bfin: rtc core: registered rtc-bfin as rtc0

bfin-wdt: initialized: timeout=20 sec (nowayout=0)

TCP cubic registered

NET: Registered protocol family 1

NET: Registered protocol family 17

rtc-bfin rtc-bfin: setting system clock to 1970-01-01 00:00:49 UTC (49)

Freeing unused kernel memory: 3920k freed

dma_alloc_init: dma_page @ 0x0000000053f000 - 256 pages at 0x000000003f00000

                           _____________________________________

        a8888b.           / Welcome to the uClinux distribution \

       d888888b.         /       _     _                         \

       8P"YP"Y88        /       | |   |_|            __  __ (TM)  |

       8|o||o|88  _____/        | |    _ ____  _   _ \ \/ /       |

       8'    .88       \        | |   | |  _ \| | | | \  /        |

       8`._.' Y8.       \       | |__ | | | | | |_| | /  \        |

      d/      `8b.       \      \____||_|_| |_|\____|/_/\_\       |

     dP   .    Y8b.       \   For embedded processors including   |

    d8:'  "  `::88b        \    the Analog Devices Blackfin      /

   d8"         'Y88b        \___________________________________/

  :8P    '      :888

   8a.   :     _a88P         For further information, check out:

._/"Yaa_:   .| 88P|            -   blackfin.uclinux.org/

\    YP"    `| 8P  `.          -   docs.blackfin.uclinux.org/

/     \.___.d|    .'           -   www.uclinux.org/

`--..__)8888P`._.'  jgs/a:f    -   www.analog.com/blackfin

 

Have a lot of fun...

 

 

BusyBox v1.10.0 (2008-04-15 10:18:20 CST) built-in shell (msh)

Enter 'help' for a list of built-in commands.

 

root:/> successful boot attempt

 

*******************************************************************

STEP 3: Start Sqlite testing

 

 

sqlite3 wishlist.db < /usr/wishlist.sql

root:/> sqlite3 wishlist.db ".dump"

BEGIN TRANSACTION;

CREATE TABLE item (

  id integer primary key not null,

  user_id integer not null,

  externalkey varchar(40),

  description text

);

CREATE TABLE user (

  id integer primary key not null,

  name varchar(40) not null,

  password char(32) not null,

  email varchar(60) not null

);

INSERT INTO "user" VALUES(0,'foo','123','foo@test');

CREATE INDEX item_user on item (user_id);

COMMIT;

root:/>

Case 1 ...PASS

sqlite_test "foo"

                               +----------------+

                                W I S H  L I S T

                               +----------------+

                               * foo <foo@test>

Case 1 ...PASS

 

SQLITE TEST PASS

 

 

 

    Files

    Changes

    Commits

    Dependencies

    Duplicates

    Associations

    Tags

 

File Name     File Type     File Size     Posted By

No Files Were Found

Attachments

    Outcomes