SQLite
Hex Artifact Content
Not logged in

Ticket change [428b056fa1] - Ticket [5eaa61ea18] sigbus on disk ful in WAL mode status still Open with 1 other change by drh 2012-11-13 09:28:13.
0000: 44 20 32 30 31 32 2d 31 31 2d 31 33 54 30 39 3a  D 2012-11-13T09:
0010: 32 38 3a 31 33 2e 34 31 31 0a 4a 20 2b 63 6f 6d  28:13.411.J +com
0020: 6d 65 6e 74 20 5c 6e 5c 6e 3c 68 72 3e 3c 69 3e  ment \n\n<hr><i>
0030: 64 72 68 5c 73 61 64 64 65 64 5c 73 6f 6e 5c 73  drh\sadded\son\s
0040: 32 30 31 32 2d 31 31 2d 31 33 5c 73 30 39 3a 32  2012-11-13\s09:2
0050: 38 3a 31 33 3a 3c 2f 69 3e 3c 62 72 3e 5c 6e 59  8:13:</i><br>\nY
0060: 65 73 2c 5c 73 74 68 65 5c 73 73 71 6c 69 74 65  es,\sthe\ssqlite
0070: 33 5c 73 73 68 65 6c 6c 5c 73 77 61 73 5c 73 72  3\sshell\swas\sr
0080: 75 6e 5c 73 61 73 5c 73 72 75 6e 2e 5c 73 5c 73  un\sas\srun.\s\s
0090: 49 5c 73 61 6c 73 6f 5c 73 72 65 70 65 61 74 65  I\salso\srepeate
00a0: 64 5c 73 74 68 65 5c 73 65 78 70 65 72 69 6d 65  d\sthe\sexperime
00b0: 6e 74 5c 73 6d 75 6c 74 69 70 6c 65 5c 73 74 69  nt\smultiple\sti
00c0: 6d 65 73 5c 73 77 69 74 68 5c 73 76 61 6c 67 72  mes\swith\svalgr
00d0: 69 6e 64 2c 5c 73 66 6f 72 5c 73 77 68 61 74 5c  ind,\sfor\swhat\
00e0: 73 69 74 5c 73 69 73 5c 73 77 6f 72 74 68 2e 5c  sit\sis\sworth.\
00f0: 73 5c 73 4e 6f 5c 73 69 73 73 75 65 73 5c 73 6f  s\sNo\sissues\so
0100: 62 73 65 72 76 65 64 2e 5c 72 5c 6e 5c 72 5c 6e  bserved.\r\n\r\n
0110: 46 75 72 74 68 65 72 6d 6f 72 65 2c 5c 73 49 5c  Furthermore,\sI\
0120: 73 74 72 69 65 64 5c 73 63 72 65 61 74 69 6e 67  stried\screating
0130: 5c 73 77 72 69 74 65 2d 61 68 65 61 64 5c 73 6c  \swrite-ahead\sl
0140: 6f 67 5c 73 66 69 6c 65 73 5c 73 74 68 61 74 5c  og\sfiles\sthat\
0150: 73 6e 65 65 64 65 64 5c 73 74 6f 5c 73 62 65 5c  sneeded\sto\sbe\
0160: 73 72 65 63 6f 76 65 72 65 64 5c 73 28 73 69 6e  srecovered\s(sin
0170: 63 65 5c 73 74 68 65 5c 73 6f 72 69 67 69 6e 61  ce\sthe\sorigina
0180: 6c 5c 73 70 72 6f 62 6c 65 6d 5c 73 73 74 61 74  l\sproblem\sstat
0190: 65 6d 65 6e 74 5c 73 73 61 69 64 5c 73 74 68 61  ement\ssaid\stha
01a0: 74 5c 73 74 68 65 5c 73 73 65 67 66 61 75 6c 74  t\sthe\ssegfault
01b0: 5c 73 6f 63 63 75 72 72 65 64 5c 73 64 75 72 69  \soccurred\sduri
01c0: 6e 67 5c 73 72 65 63 6f 76 65 72 79 29 5c 73 61  ng\srecovery)\sa
01d0: 6e 64 5c 73 72 65 63 6f 76 65 72 5c 73 74 68 65  nd\srecover\sthe
01e0: 6d 2c 5c 73 61 73 5c 73 72 6f 6f 74 2c 5c 73 77  m,\sas\sroot,\sw
01f0: 69 74 68 5c 73 7a 65 72 6f 5c 73 73 70 61 63 65  ith\szero\sspace
0200: 5c 73 6c 65 66 74 5c 73 6f 6e 5c 73 74 68 65 5c  \sleft\son\sthe\
0210: 73 64 65 76 69 63 65 2e 5c 73 5c 73 53 74 69 6c  sdevice.\s\sStil
0220: 6c 5c 73 6e 6f 5c 73 70 72 6f 62 6c 65 6d 73 2e  l\sno\sproblems.
0230: 5c 72 5c 6e 5c 72 5c 6e 54 68 65 5c 73 73 65 67  \r\n\r\nThe\sseg
0240: 66 61 75 6c 74 5c 73 6f 63 63 75 72 73 5c 73 6f  fault\soccurs\so
0250: 6e 5c 73 61 5c 73 6c 69 6e 65 5c 73 74 68 61 74  n\sa\sline\sthat
0260: 5c 73 69 73 5c 73 61 74 74 65 6d 70 74 69 6e 67  \sis\sattempting
0270: 5c 73 74 6f 5c 73 77 72 69 74 65 5c 73 69 6e 74  \sto\swrite\sint
0280: 6f 5c 73 61 5c 73 6e 65 77 6c 79 5c 73 61 6c 6c  o\sa\snewly\sall
0290: 6f 63 61 74 65 64 5c 73 6d 6d 61 70 2d 65 64 5c  ocated\smmap-ed\
02a0: 73 66 69 6c 65 5c 73 28 74 68 65 5c 73 64 62 2e  sfile\s(the\sdb.
02b0: 73 71 6c 69 74 65 2d 73 68 6d 5c 73 66 69 6c 65  sqlite-shm\sfile
02c0: 2c 5c 73 73 70 65 63 69 66 69 63 61 6c 6c 79 29  ,\sspecifically)
02d0: 2e 5c 73 5c 73 49 74 5c 73 61 70 70 65 61 72 73  .\s\sIt\sappears
02e0: 5c 73 74 68 61 74 5c 73 4c 69 6e 75 78 5c 73 77  \sthat\sLinux\sw
02f0: 69 6c 6c 5c 73 61 6c 6c 6f 77 5c 73 64 69 73 6b  ill\sallow\sdisk
0300: 5c 73 73 70 61 63 65 5c 73 66 6f 72 5c 73 6d 6d  \sspace\sfor\smm
0310: 61 70 2d 65 64 5c 73 66 69 6c 65 73 5c 73 74 6f  ap-ed\sfiles\sto
0320: 5c 73 62 65 5c 73 6f 76 65 72 63 6f 6d 6d 69 74  \sbe\sovercommit
0330: 74 65 64 2e 5c 73 5c 73 54 68 61 74 5c 73 69 73  ted.\s\sThat\sis
0340: 5c 73 74 6f 5c 73 73 61 79 2c 5c 73 62 61 73 65  \sto\ssay,\sbase
0350: 64 5c 73 6f 6e 5c 73 6d 79 5c 73 65 78 70 65 72  d\son\smy\sexper
0360: 69 6d 65 6e 74 73 2c 5c 73 79 6f 75 5c 73 63 61  iments,\syou\sca
0370: 6e 5c 73 6d 6d 61 70 5c 73 6d 6f 72 65 5c 73 73  n\smmap\smore\ss
0380: 70 61 63 65 5c 73 74 68 61 6e 5c 73 79 6f 75 5c  pace\sthan\syou\
0390: 73 68 61 76 65 5c 73 6f 6e 5c 73 64 69 73 6b 5c  shave\son\sdisk\
03a0: 73 61 6e 64 5c 73 74 68 65 5c 73 6d 6d 61 70 28  sand\sthe\smmap(
03b0: 29 5c 73 63 61 6c 6c 5c 73 73 74 69 6c 6c 5c 73  )\scall\sstill\s
03c0: 77 6f 72 6b 73 2e 5c 73 5c 73 50 65 72 68 61 70  works.\s\sPerhap
03d0: 73 5c 73 79 6f 75 5c 73 73 79 73 74 65 6d 5c 73  s\syou\ssystem\s
03e0: 69 73 5c 73 63 6f 6e 66 69 67 75 72 65 64 5c 73  is\sconfigured\s
03f0: 69 6e 5c 73 73 6f 6d 65 5c 73 77 61 79 5c 73 64  in\ssome\sway\sd
0400: 69 66 66 65 72 65 6e 74 5c 73 66 72 6f 6d 5c 73  ifferent\sfrom\s
0410: 6d 69 6e 65 5c 73 28 70 65 72 68 61 70 73 5c 73  mine\s(perhaps\s
0420: 69 74 5c 73 69 73 5c 73 61 6c 73 6f 5c 73 75 6e  it\sis\salso\sun
0430: 64 65 72 5c 73 6d 65 6d 6f 72 79 5c 73 70 72 65  der\smemory\spre
0440: 73 73 75 72 65 29 5c 73 73 6f 5c 73 74 68 61 74  ssure)\sso\sthat
0450: 5c 73 74 68 65 5c 73 6d 6d 61 70 2d 65 64 5c 73  \sthe\smmap-ed\s
0460: 72 65 67 69 6f 6e 5c 73 69 73 5c 73 62 65 63 6f  region\sis\sbeco
0470: 6d 69 6e 67 5c 73 75 6e 6d 61 70 70 65 64 5c 73  ming\sunmapped\s
0480: 73 6f 6d 65 68 6f 77 3f 0a 4b 20 35 65 61 61 36  somehow?.K 5eaa6
0490: 31 65 61 31 38 38 31 30 34 30 62 31 37 34 34 39  1ea1881040b17449
04a0: 63 61 30 34 33 62 36 66 38 66 64 39 63 61 35 35  ca043b6f8fd9ca55
04b0: 64 63 33 0a 55 20 64 72 68 0a 5a 20 34 37 34 33  dc3.U drh.Z 4743
04c0: 61 34 62 61 36 38 62 63 62 35 33 63 37 30 65 36  a4ba68bcb53c70e6
04d0: 62 38 61 32 65 33 66 36 63 64 37 63 0a           b8a2e3f6cd7c.