4 ms·

Looks like the line numbers were lost: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae1495ba2da84517dce6081/src/os.h#L65-L75 https://github.com/macky

Looks like the line numbers were lost: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae1495ba2da84517dce6081/src/os.h#L65-L75 https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... It's because McAfee started using SQLite, angry users would stumble upon the files, do a minimum of searching or thinking, and be furious at SQLite developers.

sedatk 3y ago
I wonder why users were angry about some files in their temp folder. Did McAfee fail to cleanup those files, or were they too big? Edit: more information here: https://www2.sqlite.org/cvstrac/wiki?p=McafeeProblem https://www2.sqlite.org/cvstrac/wiki?p=McafeeProblem Apparently, McAfee kept those files locked when it was using them, so the files couldn't be deleted and people got angry that they couldn't clean them up. Sounds like a loud minority to me.
- banana_giraffe 3y ago
  There's some level of power user that will try to fix things, not understand what's going on, and yell at the world when they break things further. I used to have a popular freely available 3rd party DLL that was included in lots of software packages. Because I was silly, it had my email address in the metadata that'd show up if you clicked "Properties" in Explorer. I'd get plenty of emails from random people asking for and sometimes _demanding_ help with software I've never heard of. I'm sure if I had an easy to find website with my name and a forum on it, it'd be full of such angry comments.
  - thakoppno 3y ago
    > There's some level of power user that will try to fix things, not understand what's going on, and yell at the world when they break things further. That appears to me to be quite like a Chesterton fence. Everyone encounters these eventually. https://en.m.wiktionary.org/wiki/Chesterton%27s_fence https://en.m.wiktionary.org/wiki/Chesterton%27s_fence
- giantrobot 3y ago
  > Sounds like a loud minority to me. Imagine for a moment the cross section of Windows users that 1) have McAfee running 2) poke around the Windows temp folders and/or run some sort of "cleaner" to "optimize" their system and 3) don't recognize the name "sqlite". I can imagine the exact type of user, peak Dunning-Kruger and utterly insufferable. Even just seeing their e-mails before deleting them would be maddening. I think most people on HN can vividly imagine the sort or remember back when they were that insufferable twat.
  - rootw0rm 3y ago
    I was that person once. I was 12 and couldn't understand why MS-DOS disk maintenance tools shouldn't be used on PC-DOS because obviously repair tools can only fix things
    - tempestn 3y ago
      Children really are peak Dunning-Kruger.
    - dale_glass 3y ago
      That's interesting. Some DOS clones had a different FAT format?
- ajsnigrutin 3y ago
  It's a good thing, that there's a clear instructional video on how to remove McAffee antivirus from your computer then: https://www.youtube.com/watch?v=bKgf5PaBzyg https://www.youtube.com/watch?v=bKgf5PaBzyg (yes, it's the funny one)
- chasil 3y ago
  In Linux, these files are unlinked, so they are invisible in the filesystem. It is legal to unlink an active file descriptor, but continue reads/writes to it. I think that lsof can still see these temporary files; I'm not sure how I first noticed it. Windows implements a POSIX kernel layer, so perhaps this functionality could be coaxed out of it.
  - bombcar 3y ago
    lsof shows “open file handles” which can include deleted files. Can be useful when you have a disk showing tons of usage but you can’t find any big files.
  - eurleif 3y ago
    Apparently, recent Windows uses POSIX semantics by default: https://news.ycombinator.com/item?id=23745019 https://news.ycombinator.com/item?id=23745019
  - Arnavion 3y ago
    If a file is opened with `FILE_SHARE_DELETE` then it can be deleted while held open. This flag has existed since forever. It's just that unlike Linux this isn't the default, and no developer would think of setting it. I think the only common software I saw using it when I still used Windows was the media player mpv.
  - hinkley 3y ago
    I knew two guys long long ago that used to circumvent the per user disk quota on shared machines, which was tiny and not conducive to power users. One found a deep dark corner of the file system, and used it to hold binaries the rest of us used. I think his idea was that if it wasn’t for personal gain it was easier to answer difficult questions, which at some point came up and he got a pass, since it would take more disk space if we had private copies. The other was keeping file handles open to deleted files, as you describe. I don’t recall how this worked, but I suspect it involved uncompressing data into a file descriptor, then reading it back. I guess as long as his terminal window was open it was more stable than tmp (he may have also been using screen).
arp242 3y ago
Daniel Stenberg has also gotten some ... interesting ... emails because people found the curl license somewhere and assumed he was responsible for $stuff. https://daniel.haxx.se/blog/2016/01/11/tales-from-my-inbox-part/ https://daniel.haxx.se/blog/2016/01/11/tales-from-my-inbox-p... https://daniel.haxx.se/blog/2016/01/19/subject-urgent-warning/ https://daniel.haxx.se/blog/2016/01/19/subject-urgent-warnin... https://daniel.haxx.se/blog/2018/02/16/why-is-your-email-in-my-car/ https://daniel.haxx.se/blog/2018/02/16/why-is-your-email-in-... https://daniel.haxx.se/blog/2021/02/19/i-will-slaughter-you/ https://daniel.haxx.se/blog/2021/02/19/i-will-slaughter-you/
- bennettnate5 3y ago
  I've always wondered if Daniel gets a particular amount of email of this sort because his address includes "haxx"--for someone without tech savvy, it's not all that much of a jump to assume an email that includes something sounding like hacking is the email of the hacker that has attacked them.
  - pavlov 3y ago
    Yes, that seems to be the likely explanation at least for the second linked email which closes with: ”Please see attached screen dump for a screen shot of your contact info included in Spotify (or what more likely seems to be a hacked Spotify developed illegally by a third party).”
- anilakar 3y ago
  The last one has to be an elaborate troll. Only a 4chan user would type "RIP Terry A. Davis" anywhere.
  - lcrz 3y ago
    Check the ‘apology’ follow up. The person claims to be schizophrenic. Even the apology mail makes no sense and is full of paranoia and read like a group stalking delusion.
  - Greed 3y ago

sedatk 3y ago

I wonder why users were angry about some files in their temp folder. Did McAfee fail to cleanup those files, or were they too big? Edit: more information here: https://www2.sqlite.org/cvstrac/wiki?p=McafeeProblem https://www2.sqlite.org/cvstrac/wiki?p=McafeeProblem Apparently, McAfee kept those files locked when it was using them, so the files couldn't be deleted and people got angry that they couldn't clean them up. Sounds like a loud minority to me.

banana_giraffe 3y ago
There's some level of power user that will try to fix things, not understand what's going on, and yell at the world when they break things further. I used to have a popular freely available 3rd party DLL that was included in lots of software packages. Because I was silly, it had my email address in the metadata that'd show up if you clicked "Properties" in Explorer. I'd get plenty of emails from random people asking for and sometimes _demanding_ help with software I've never heard of. I'm sure if I had an easy to find website with my name and a forum on it, it'd be full of such angry comments.
- thakoppno 3y ago
  > There's some level of power user that will try to fix things, not understand what's going on, and yell at the world when they break things further. That appears to me to be quite like a Chesterton fence. Everyone encounters these eventually. https://en.m.wiktionary.org/wiki/Chesterton%27s_fence https://en.m.wiktionary.org/wiki/Chesterton%27s_fence
giantrobot 3y ago
> Sounds like a loud minority to me. Imagine for a moment the cross section of Windows users that 1) have McAfee running 2) poke around the Windows temp folders and/or run some sort of "cleaner" to "optimize" their system and 3) don't recognize the name "sqlite". I can imagine the exact type of user, peak Dunning-Kruger and utterly insufferable. Even just seeing their e-mails before deleting them would be maddening. I think most people on HN can vividly imagine the sort or remember back when they were that insufferable twat.
- rootw0rm 3y ago
  I was that person once. I was 12 and couldn't understand why MS-DOS disk maintenance tools shouldn't be used on PC-DOS because obviously repair tools can only fix things
  - tempestn 3y ago
    Children really are peak Dunning-Kruger.
  - dale_glass 3y ago
    That's interesting. Some DOS clones had a different FAT format?
ajsnigrutin 3y ago
It's a good thing, that there's a clear instructional video on how to remove McAffee antivirus from your computer then: https://www.youtube.com/watch?v=bKgf5PaBzyg https://www.youtube.com/watch?v=bKgf5PaBzyg (yes, it's the funny one)
chasil 3y ago
In Linux, these files are unlinked, so they are invisible in the filesystem. It is legal to unlink an active file descriptor, but continue reads/writes to it. I think that lsof can still see these temporary files; I'm not sure how I first noticed it. Windows implements a POSIX kernel layer, so perhaps this functionality could be coaxed out of it.
- bombcar 3y ago
  lsof shows “open file handles” which can include deleted files. Can be useful when you have a disk showing tons of usage but you can’t find any big files.
- eurleif 3y ago
  Apparently, recent Windows uses POSIX semantics by default: https://news.ycombinator.com/item?id=23745019 https://news.ycombinator.com/item?id=23745019
- Arnavion 3y ago
  If a file is opened with `FILE_SHARE_DELETE` then it can be deleted while held open. This flag has existed since forever. It's just that unlike Linux this isn't the default, and no developer would think of setting it. I think the only common software I saw using it when I still used Windows was the media player mpv.
- hinkley 3y ago
  I knew two guys long long ago that used to circumvent the per user disk quota on shared machines, which was tiny and not conducive to power users. One found a deep dark corner of the file system, and used it to hold binaries the rest of us used. I think his idea was that if it wasn’t for personal gain it was easier to answer difficult questions, which at some point came up and he got a pass, since it would take more disk space if we had private copies. The other was keeping file handles open to deleted files, as you describe. I don’t recall how this worked, but I suspect it involved uncompressing data into a file descriptor, then reading it back. I guess as long as his terminal window was open it was more stable than tmp (he may have also been using screen).

arp242 3y ago

Daniel Stenberg has also gotten some ... interesting ... emails because people found the curl license somewhere and assumed he was responsible for $stuff. https://daniel.haxx.se/blog/2016/01/11/tales-from-my-inbox-part/ https://daniel.haxx.se/blog/2016/01/11/tales-from-my-inbox-p... https://daniel.haxx.se/blog/2016/01/19/subject-urgent-warning/ https://daniel.haxx.se/blog/2016/01/19/subject-urgent-warnin... https://daniel.haxx.se/blog/2018/02/16/why-is-your-email-in-my-car/ https://daniel.haxx.se/blog/2018/02/16/why-is-your-email-in-... https://daniel.haxx.se/blog/2021/02/19/i-will-slaughter-you/ https://daniel.haxx.se/blog/2021/02/19/i-will-slaughter-you/

bennettnate5 3y ago
I've always wondered if Daniel gets a particular amount of email of this sort because his address includes "haxx"--for someone without tech savvy, it's not all that much of a jump to assume an email that includes something sounding like hacking is the email of the hacker that has attacked them.
- pavlov 3y ago
  Yes, that seems to be the likely explanation at least for the second linked email which closes with: ”Please see attached screen dump for a screen shot of your contact info included in Spotify (or what more likely seems to be a hacked Spotify developed illegally by a third party).”
anilakar 3y ago
The last one has to be an elaborate troll. Only a 4chan user would type "RIP Terry A. Davis" anywhere.
- lcrz 3y ago
  Check the ‘apology’ follow up. The person claims to be schizophrenic. Even the apology mail makes no sense and is full of paranoia and read like a group stalking delusion.
- Greed 3y ago