SQLite
Artifact Content
Not logged in

Artifact ba0773221d7d6f2d318769276c437df09510d1da:

Ticket change [ba0773221d] - Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3|5eaa61ea18] sigbus on disk ful in WAL mode status still Open with 3 other changes by drh 2012-11-13 01:24:10.
D 2012-11-13T01:24:10.051
J comment Attempts\sto\sprepare\sa\squery\son\sa\sWAL\sdatabase\swhen\sthe\sdisk\sspace\sis\scritically\slow\sresult\sin\sthe\sprocess\skilled\swith\sBUS.\r\nThe\scrash\shappens\sin\swalIndexWriteHdr\sinvoked\sfrom\swalIndexRecover:\r\n<verbatim>\r\n\s643\sstatic\svoid\swalIndexWriteHdr(Wal\s*pWal){\r\n\s[...]\r\n\s650\s\s\swalChecksumBytes(1,\s(u8*)&pWal->hdr,\snCksum,\s0,\spWal->hdr.aCksum);\r\n\s651\s\s\smemcpy((void\s*)&aHdr[1],\s(void\s*)&pWal->hdr,\ssizeof(WalIndexHdr));\s<<\ssigbus\shere\r\n</verbatim>\r\n\r\nSince\si\sdon't\sknow\sif\sI'll\sbe\sable\sto\sattache\sa\sPoC\safter\ssubmitting\sthis\sticket,\sI'm\sadding\sit\shere\sin\sbase64.\r\n\r\n<verbatim>\r\nbase64\s-d\s>\smountme.bz2\s<<\sEOF\r\nQlpoOTFBWSZTWdl2FE4AAEd////////v7/5e/////L9v/+xv38ZSbAdOQV4FRCTR3/3s0ARNY3on\r\naVG5ydncNEgTQE09IyngieU8gh6TINNPUAGmjQ2o0HpDQNNHqHqAAADTQ9RoeU0GR5Q8kBoZNqeo\r\nNEJpkRojCniamZNJo02oAzUNNGmyg0DIAAAAABoAAAAAANAaAAAxFE0Jij0J6hp5NR6Rk0ANAZBo\r\nGgAAAADQAAAAAAAAABoDQAgNDINMmmgYTQGhpk0aYEZGTQZDJkGRpkaNMg0aAGCNNBiGgAZNDJgI\r\n0GjQJFJRNNNDIGjTIbU0HqABoaaZDINAAAADQBiAGIGjQyNNGgAZMI0ZNDJoU3MeFxkkc3Z41hbW\r\n8jDkSjtOhgCTZvZDyAuQe9MlnyUJRsnBSKCqYknJpalrzfoZNLCdV70TdiIXxMRuU2IRkQJqG8QZ\r\nOQb+iYlGMFPlV0OmpxTALbroIwQMEAHxal5pbiPEEKHH0kN2QtWKoGkgJsW5O0ayrdAnCOCFYLWw\r\nlLfOMYqAyp0kAifKYYjJCJmGkTTtwu6OsOY0RUoOiYDGtSQctLi3zirl93O1IcPEMJd2yfKOo5VC\r\ntWwG8FR62hLdnPEziKCWNRAajF4aK+BaiAUlAZ2KQdmyNlQkNBaRNnI7pJPgEa24whyQSEgCKdFC\r\n/aaQiZaWUYc9gZLodGIx76jQRmC3DBQYgKCBI5zBjgkBPQAMNSLg5jVDAwp0lCg6hCZ3cBnTAKCr\r\ncB3YAkh1CQjQRAjhACk7EMgIYG/qJECI59jLeOZbEgNUsCyBI1VUxJGKqGBEkyVYgcIAm0kNpA2k\r\nEk0adiIMAxDQmwQlHkcPEajEqCMs0KPm/J9/zgpwGR8bJkqz2cyCKk0efK1+mDyI2XAXOKDBngnh\r\nufJHQ/UIOjK+VQ2Co9F59shqwue3JMARlIR+wwrBKYWf7aqVbNpnE2YHnSYYO78LCCQlXsSBlmIB\r\ngq+Mhwc5o4DY3koqRgDooKXZs6xZl9Pu99c/JOtbNB8swjv0DLMzBv1CaRMihk7i65cnPsysYte/\r\ng2qofXNK7kUHLlkQDswL2sD2Qxg18u1zVCzMcRKmYKwk+dyYVqIGgU9AWSAGFQncaikWEUsdh1cy\r\nDMTB1MUJJmoPKklNQgJliXgmCc48b5DvnmlACYCBG40dGAieggokSkAKv+aEPAwFF0hGpNk0JRQM\r\nhQpUWBdCAbFtYhjq4Qnk2IF16/kvnNfAx5nFlgNSp3At7mGEVQwmTWM2Pah6bczg7MK84eAyvC0S\r\nqZiDAVigjMRQUGiL+XmKkF1Sm6e/kUVALAMBBOMBKbkBCQEbxxkumARAAyffwCvK4lyRZC1cImG/\r\nO6CB4G0G2dmooW+OATX2TIF8lYiCl4hSdrvCgNAxQgtgsr8iCzICwdQCJPjc8hDYS67AulWQxxmw\r\n1WMNwqrviGcCT9CYWMaONSepUu5bLC9KfhepOKSBVBmQ8AZBSyB1ntos5HzRZMwLjGu6tPVUQKOd\r\nozKDukqH+aYanaMEJAE+T6suVBNc/fNGBlP1+ZqyEaJCdpvPRVi/VJMHdoKy2QHNOxo3k8kUx7rg\r\nw8E49w6q6osXLYPmkQ2hELLO5TWp7D8RhybGAo6WXzt66MIRIkZ1kgghKRKYMAgB7YcebZbV7ada\r\nB/Asgf4nIUJ8iKZ1qbCYDBkg7H8sTf6oDqczF/X79LiIqxb1boNG662tp/Vz7JfwSCL6w4+2fqk3\r\nym9/ynQJUzxwAZf7EwajzMXWBxQgiIjYJJ0YJATYEIr+KoYlEwFWSnnjkI3piIP1ycNM6496w1SD\r\nV/Xf8tkMAB4Ffbf/i7kinChIbLsKJwA=\r\nEOF\r\n\r\nThen:\r\nbunzip2\smountme.bz2\r\nmount\s-o\sloop\smountme\s/mnt\r\n\r\nFinally:\r\n#\ssqlite3\s/mnt/db.sqlite3\s\r\nSQLite\sversion\s3.7.14.1\s2012-10-04\s19:37:12\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\s.tables\r\nBus\serror\r\n</verbatim>
J priority Immediate
J resolution Open
K 5eaa61ea1881040b17449ca043b6f8fd9ca55dc3
U drh
Z 4cf958bed5c89fbb35c48ccc9f18605d