Consistent Crash in Page Cache

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Consistent Crash in Page Cache

Ashish Goyal
  We are facing consistent crash in SQLite Linux while freeing the Page
Cache when WAL-index has changed. Here is the stack trace:

#0  0x0000003c000325e5 in raise ()
#1  0x0000003c00033dc5 in abort ()
#2  0x0000003c000704f7 in __libc_message ()
#3  0x0000003c00075f3e in malloc_printerr ()
#4  0x0000003c00078d8d in _int_free ()
#5  0x000000000058ed12 in sqlite3MemFree (pPrior=0x7fb13e7aa500) at
#6  0x000000000058facf in sqlite3_free (p=0x7fb13e7aa500) at sqlite3.c:24674
#7  0x000000000059d44b in pcache1Free (p=0x7fb13e7aa500) at sqlite3.c:45379
#8  0x000000000059d5a4 in pcache1FreePage (p=0x7fb13e7ac5b8) at
#9  0x000000000059d9d4 in pcache1TruncateUnsafe (pCache=0x7fb46800ee58,
iLimit=1) at sqlite3.c:45668
#10 0x000000000059e2a4 in pcache1Truncate (p=0x7fb46800ee58, iLimit=1) at
#11 0x000000000059cb69 in sqlite3PcacheTruncate (pCache=0x7fb46802ec68,
pgno=0) at sqlite3.c:44797
#13 0x000000000059f8e0 in pager_reset (pPager=0x7fb46802eb38) at
#14 0x00000000005a1070 in pagerBeginReadTransaction (pPager=0x7fb46802eb38)
at sqlite3.c:50140
#15 0x00000000005a338e in sqlite3PagerSharedLock (pPager=0x7fb46802eb38) at
#16 0x00000000005ad150 in lockBtree (pBt=0x7fb46802e678) at sqlite3.c:61943
#17 0x00000000005ad940 in sqlite3BtreeBeginTrans (p=0x7fb46802e618,
wrflag=0) at sqlite3.c:62308
#18 0x00000000005c90af in sqlite3VdbeExec (p=0x7fb46803a148) at
#19 0x00000000005c27b0 in sqlite3Step (p=0x7fb46803a148) at sqlite3.c:76699

The crash generally happens when core is very large more than 14 GB. Is
this due to high memory usage of process or system running out of memory.

There is only one reference to this stack where there were some memory

Any pointers would be useful.

sqlite-users mailing list
[hidden email]