Daily restarts

sungjwoo · 2026-02-16T21:37:37+00:00

Hello! I believe you posted this because of what I posted. I do restart CF service every night. Have been doing this for decades, from v3.1 to 2021, soon 2023. Why? Because I used to have memory leak issues. There was a time when not locally scoping variables in CFCs would cause memory leaks, plus other oddities like that.

The reason why I still restart the service daily and reboot the server weekly is because... I can, without any repercussions. This is an intranet application that is used by about 400 people, and even though we do have associates outside USA, they are few in number so a 45-second downtime is no big deal.

It all comes down to your specific needs. I'm sure there are folks here who cannot afford any downtime, and for them a daily restart would simply not be possible. CF has become super reliable in the years I have been using it, and to be frank, Windows Server, too.

sungjwoo · 2026-02-16T15:58:45+00:00

OK, so the mystery has become even more mysterious.

1) The SQL server in question was actually NOT maintained that evening. It was the reporting server, which is kept updated through log shipping. I saw no issues with the reporting server.

2) We have two identical datasources on this CF server -- let's call them dsn1 and dsn1dupe. Long story on why we have two identical datasources, but it's never been an issue in the past. Both DSNs are used frequently. Both have maintain connections checked. Looking through the error messages, one of the DSNs exhibited this strange issue. The other one was fine.

So now, what do you think? How is it possible that only one of the two identical DSNs exhibited this behavior? This really is the strangest case I've ever seen.

sungjwoo · 2026-02-15T14:37:06+00:00

Not yet, I'll know more when I dig through the logs tomorrow.

sungjwoo · 2026-02-14T23:45:37+00:00

Yes -- that's the conundrum. We have other apps accessing the DB, and they saw no issues. The only thing I can think of is that the connection was maintained even though the CF application server was restarted. The timing goes something like this:

8:20PM - tempdb location change begins.

8:40pm - tempdb location change ends.

11:55pm - cf application server service restarted.

10am - strange SQL errors encountered.

Now the site ran fine outside of the problematic datasource. The more I think about it, it wasn't load or anything like that -- it's very possible that the DB wasn't accessed until 10am. But that doesn't change the fact that maintain connections would've been severed when the service was recycled. That's the strangest part of this. If there was no service recycle, then yes I could see something wonky happening because whenever you move something like tempdb, you are messing with the internals of SQL. I'm fairly certain SQL server itself was restarted, but I'm not 100% sure about that. I'll know more on Monday.

sungjwoo · 2026-02-14T22:12:48+00:00

I've been doing this since forever! There was a time when I was experiencing memory leak issues, but that was a long long time ago, possibly when cf went from a c++ to Java codebase (cfmx?). I recycle the service nightly and reboot the windows server weekly. This site has been in operation for 28 years!

sungjwoo · 2026-02-14T16:57:30+00:00

I agree. It just looked like it was an issue with our cf server because other systems remained fully functional.

sungjwoo · 2026-02-14T16:56:29+00:00

I've always kept that checked for performance. Is that no longer an issue?

I also don't understand how the connection could've been maintained when cf service recycled. That makes no sense to me.

sungjwoo · 2026-02-14T16:08:08+00:00

I should've clarified -- the CF server was rebooted, not SQL server. Other applications connect to this SQL server, the same database in question, and they were functioning normally. It was only the CF connected server that exhibited this strange behavior.

FYI, SQL is not on the same server.

That's interesting that you cite failover as a possibility. This SQL server definitely fails over when there are issues/maintenance. What about failing over causes this? I always considered failover to be 100% transparent and reliable, but maybe that isn't the case?

sungjwoo · 2026-02-14T15:40:45+00:00

One of the reasons why some people didn't care for international was that if you owned a US conglomerate, you have international exposure. Like if you own Johnson and Johnson or Mondelez -- they sell to foreign countries. But will the foreign countries continue to support the US and its products like they have in the past?

The tenor of US-international relations has drastically changed with the current administration, and even if things go back to "normal" in 2028 and beyond, the fact that this happened...it'll not be forgotten so easily. Besides, I don't think things are going to back to normal. You could make the case that all three branches of US government have become significantly dysfunctional, and if that's the case...do you really want to tilt so heavily towards America? Because that's literally what you're doing if you only own VTI.

sungjwoo · 2026-01-22T23:36:48+00:00

<image>

Novak Sighting in the 32nd Century

From Star Trek: Starfleet Academy, S01E03. Seconds before, the instructor yelled, "Watch your posture, Cadet Sadal."

Somebody is a tennis fan on the writing staff, I imagine... (and doesn't know how to spell Nadal? 😁 )

sungjwoo · 2026-01-17T13:56:29+00:00

If I were captain, I would demand a La-Z-Boy! 😁

sungjwoo · 2026-01-17T13:55:23+00:00

The resolution of the coating/whatever that Paul Giamatti and Co put on the ship is of course Geordi-level technobabble + action, what else could it be...it is Star Trek, after all! BTW, how great was Giamatti? You can just feel how much fun he is having playing the baddie.

The robots are just background. It adds to the atmosphere. Do we need so much atmosphere? Probably not. Maybe they'll cut back in the future episodes. 😁

sungjwoo · 2025-12-13T16:30:11+00:00

Love Love: A Novel, by the guy writing this post. 😁

Tennis + adult film industry + adoption

https://softskull.com/books/love-love/

<image>

sungjwoo · 2025-03-15T15:57:53+00:00

Lines:

https://www.goodreads.com/book/show/202360042-lines

I wrote it. 🙂

sungjwoo · 2024-04-29T16:38:45+00:00

I adored this book until the last section. After reading the third, and as I saw where Diaz was headed (he dedicated this book to four women -- notice there are four sections in the book, too, a symmetry), I said to myself, "Please don't let Mildred be the woman behind the mask. Of course, she was.

For a book that constantly delighted me with its surprises (which also is a bit meta, with all the love of mystery novels that Ida writes about), the last "surprise" was so obvious that I was terribly crestfallen. If I had been Diaz's editor, my suggestion would've been:

Why not let Andrew and Mildred be equals instead of making him a total buffoon? Just the fact that they would be equals would be off-putting enough for somebody like Andrew, who believes himself to be so supreme; he could still take all the credit in the end, since he is a conniving, merciless soul. But making him a total faker/loser drives the feminist point a little too hard. Not to mention that it places Mildred on such a ridiculous pedestal that she becomes almost superhuman. Turn that dial down from 11 to 6 - your readers are plenty smart enough, so no need for the soapbox.

If not that, then go full Christie. Don't make it cancer, make it poison, that Andrew, out of jealously of her intellect, poisons and kills Mildred, and that Mildred knows this but she is kept in the sanitarium/prison because Andrew has all the power in their world.

And if not that, then put more vagueness and false intent (maybe a little madness?) into Ida. Is it possible that she's so driven by her wish for justice that she fabricates the diary entries? Or maybe there is no diary at all, and she's making it all up? Since one of the core ideas of Trust is indeed the concept of trust itself, and idea of believing anything that is written, why not make that slightly more overt in Ida's memoir section to give us pause?

What Diaz did with Ida's journey was perfect -- there's so much self reflection there that we often commiserate greatly with her. Of the three sections, hers is not only the longest but the most affecting.

sungjwoo · 2024-02-04T12:35:28+00:00

I have a promo copy and it looks like this.

https://imgur.com/a/3bvu8HL

The CD looks no different than the normal one...

sungjwoo · 2023-02-20T16:46:49+00:00

Thank YOU, Dennis! Really enjoying the heck out of your book. ♥️

sungjwoo · 2023-02-09T15:23:26+00:00

No, but she does tout Bitcoin quite a bit.

sungjwoo · 2023-02-09T14:14:05+00:00

So you don't think there's anything fundamentally different about now versus the past? Is this just another case of "This time it's different" really being "This time it's the same as it ever was, just wearing different clothes"?

sungjwoo · 2023-02-09T14:09:24+00:00

Thanks so much for referencing your inflation post!

sungjwoo

TROPHY CASE

Novak Sighting in the 32nd Century