[#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

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

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