Re: Problem with SQLite 3.7.6

[Jean-Yves Moulin <jym%eileo.net@localhost>]

Hi,

On 16 Apr 2011, at 18:17 , Adam Ciarciński wrote:

> Please, provide the information.
>> 
>> Can you tell me how to reproduce the problem so that we can debug it?



I'm also experiencing problem with sqlite3.7.6.

When trying to load a dump in a clean database:
# touch test.db
# sqlite3 test.db < /tmp/dump.sql

(this command is working on FreeBSD and mac-osx, with older version of sqlite3).


On most NetBSD servers, sqlite3 is in an endless loop, taking 100% of cpu and 
doesn't do anything (all of these servers are xen domU or dom0... )

On one other server (it's a native NetBSD, no xen here), sqlite3 segfault :

   865      1 sqlite3  fcntl(0x3, 0x8, 0x7f7fffffb900) = 0
   865      1 sqlite3  fcntl(0x3, 0x8, 0x7f7fffffb900) = 0
   865      1 sqlite3  access("/srv/home/jym/test.db-journal", 0) = 0
   865      1 sqlite3  __stat30("/srv/home/jym/test.db-journal", 
0x7f7fffffb8f0) = 0
   865      1 sqlite3  __fstat30(0x3, 0x7f7fffffb8c0) = 0
   865      1 sqlite3  __fstat30(0x3, 0x7f7fffffb8c0) = 0
   865      1 sqlite3  unlink("/srv/home/jym/test.db-wal") Err#2 ENOENT
   865      1 sqlite3  __fstat30(0x3, 0x7f7fffffb8c0) = 0
   865      1 sqlite3  fcntl(0x3, 0x8, 0x7f7fffffb970) = 0
   865      1 sqlite3  __stat30("/srv/home/jym/test.db", 0x7f7fffffb830) = 0
   865      1 sqlite3  open("/srv/home/jym/test.db-journal", 0x202, 0x1a4) = 5
   865      1 sqlite3  SIGSEGV SIG_DFL


Sometimes, segault is not exactly at the same point:

1886      1 sqlite3  fcntl(0x3, 0x8, 0x7f7fffffb910) = 0
  1886      1 sqlite3  access("/root/test.db-journal", 0) = 0
  1886      1 sqlite3  __stat30("/root/test.db-journal", 0x7f7fffffb900) = 0
  1886      1 sqlite3  __fstat30(0x3, 0x7f7fffffb8d0) = 0
  1886      1 sqlite3  __fstat30(0x3, 0x7f7fffffb8d0) = 0
  1886      1 sqlite3  unlink("/root/test.db-wal") Err#2 ENOENT
  1886      1 sqlite3  __fstat30(0x3, 0x7f7fffffb8d0) = 0
  1886      1 sqlite3  fcntl(0x3, 0x8, 0x7f7fffffb980) = 0
  1886      1 sqlite3  __stat30("/root/test.db", 0x7f7fffffb840) = 0
  1886      1 sqlite3  open("/root/test.db-journal", 0x202, 0x1a4) = 5
  1886      1 sqlite3  open("/root", 0, 0)         = 6
  1886      1 sqlite3  fcntl(0x6, 0x1, 0)          = 0
  1886      1 sqlite3  fcntl(0x6, 0x2, 0x1)        = 0
  1886      1 sqlite3  fcntl(0x5, 0x1, 0)          = 0
  1886      1 sqlite3  fcntl(0x5, 0x2, 0x1)        = 0
  1886      1 sqlite3  SIGSEGV SIG_DFL


All servers are amd64 with custom kernel (sqlite3 is working fine on i386 
servers).

I can do some other test if needed.

Best,
jym