Rambling: 26-02-18

Published 2026-02-17 22:25 Updated 2026-02-18 15:35 459 words 3 min read

碎碎念: 期末 · C碎碎念: 期末 · ARandom Notes: Summary of Several Recent Technical AdvancementsChitchat: Today is my birthday.Random Thoughts: Senior Year Coming-of-Age CeremonyRambling Thoughts: February 25, 2026Rambling Thoughts: February 26, 2022Random Thoughts: 26-02-20Rambling: 26-02-18-2Rambling: 26-02-18碎碎念: 26-02-17Rambling: 26-02-15Rambling Thoughts: 26-02-14Chatter: 26-01-16 Friends, Interpersonal RelationshipsRandom Thoughts: 26-01-01 2025, Annual ReviewRamblings: 2025-10-19Rambling: October 17, 2025 (Supplement)碎碎念: 2025-10-13 (补、密码保护)Rambling: Please forgive my introverted self.Rambling Thoughts: 2025-09-23Ramblings: Perfectly Transplanted PureSuck ThemeRambling Diary: 2025-07-16Trivial Musings: 2025-07-05Murmurings: 2025-06-13Random Thoughts: 2025-06-09Rambling Thoughts: 2025-05-18 A photo taken in the evening.Trivial Thoughts: 2025-05-05Rambling: 2025-04-30Chatty: 2025-04-20Chop Chop Nian: 2025-04-19Rambling: April 13, 2025Ramble: 2025-03-09-2Chatter: 2025-03-09Rambling: I'm too lazy to even write an annual summary.Random Thoughts: November 17, 2024Daily Musings: October 8, 2024, to October 18, 2024Ramblings: 2024-09-29Trivial Musings: September 24, 2024Random Thoughts: 2024-09-23Daily Ramblings: 2024-10-05Random Thoughts: 2024-10-03 Drank a taro boba milk teaRandom Thoughts: 2024-10-03 May the world be forever free from war.Rambling: 2024-09-15碎碎念: 2024-09-01Ramblings: 2024-08-29 Who changed my playlist?碎碎念: 2024-08-29 我抑郁症?Ramblings: 2024-08-29Chatter: 2024-08-26Chatter: 2024-08-22Random Thoughts: 2024-08-18Chatter: 2024-08-11Trivial Ramblings: 2024-08-08碎碎念: 2024-08-06 梦Chatter: 2024-08-06Chatter: 2024-08-04Murmurings: 2024-07-21Trivial Musings: July 13, 2024Ramblings: 2024-07-08Trivial Thoughts: 2024-07-03Murmurings: 2024-07-02Stream of Consciousness: July 1, 2024Rambling Thoughts: 2024-06-30Rambling Thoughts: June 28, 2024Chatter: 2024-06-27碎碎念: 2024-06-26Trivial Musings: 2024-06-22碎碎念: 2024-06-20Rambling: 2024-06-18Trivial Murmurs: 2024-06-17Random Thoughts: 2024-06-15Random Thoughts: June 14, 2024Rambling: 2024 High School Senior Rooftop Shouting碎碎念: 2024-06-06Chatter: 2024-05-30 1Random Thoughts: 2024-05-30 twoRambling Diary: 2024-05-27Rambling Thoughts: 2024-05-26碎碎念: 2024-05-23碎碎念: 2024-05-22Rambling Notes: 2024-05-19碎碎念: 2024-05-17Ramblings: 2024-05-14Rambling Thoughts: 2024-05-13Ramble: 2024-05-12碎碎念: 2024-05-10碎碎念: 2024-05-08碎碎念: 2024-05-06碎碎念: 2024-05-05 M:8 三碎碎念: 2024-05-05碎碎念: 2024-05-05 M:7 二Rambling Thoughts: 2024-05-05 M:7 OneRambling: May 2, 2024 Thursday M:3 light rain碎碎念: 生日Rambling: 2024-04-29 M:7Random Thoughts: 2024-04-27 M:8
Recently, I upgraded the umami version to 3.0.3, and the upgrade process went smoothly without any issues. (Actually, I set up a completely new umami v3 and then migrated the v2 data into the new v3. I was really worried about potential issues during the v2 to v3 upgrade, so I was entirely looking forward to trying umami's pixel tracking. I had seen pixel tracking in Microsoft's promotional emails before, and after seeing that umami v3 added pixel tracking, I've been eager to try it.)

Translated by AI model Qwen/Qwen3-8B.

Source Language: Simplified Chinese, Target Language: english, Translation Time: 2026-05-01 14:41

.

AI translation is for reference only. Accuracy is not guaranteed, please refer to the original text.

Recently I upgraded the umami version to 3.0.3, and the upgrade process went smoothly with no issues.

(: Actually, I set up a completely new umami v3 and migrated the v2 data to the new v3, just afraid that upgrading from v2 to v3 might cause problems)

I was completely looking forward to umami's Pixel Tracking feature. I once saw pixel tracking in Microsoft's promotional emails, and when I saw umami v3 added pixel tracking, I wanted to try it right away.

The upgrade process went smoothly, but then a bug occurred later.

After the upgrade, I found that the umami links deployed on Vercel and the pixel tracking functionality were not working properly, unable to track normally.

Just opening the link or the pixel tracking link, the database didn't update the statistics, and there were no error messages.

I checked the Vercel logs for a long time and had doubts about a certain log entry.

In the /p/abc log, there was a query log from prisma, but no write log to the database.

image-1
image-1

At first, I thought I had turned off the triggers during the database migration, but didn't re-enable them, which caused the statistics update operation to not trigger during queries.

But eventually, I tested it locally and confirmed that there was indeed an INSERT operation to the database.

After a period of tough testing and troubleshooting, I finally determined that it was the hasBlockedIp function in the src/lib/detect.ts file that was causing the issue. This function is used to determine if the request comes from a blocked IP address. However, when clientIp is undefined or an empty string, the function attempts to execute ipaddr.parse(clientIp), which causes an exception and interrupts the entire statistics process. (Actually, I still don't understand why clientIp would be undefined

Note: It seems the issue has been fixed, but it hasn't been fully resolved.

I updated the production environment code again, and also submitted a PR.


The Chinese translation in umami v3 is mostly machine-translated, and some translations are incorrect. For example, the English word breakdown was translated as 故障. I personally think it should be translated as 细分. 故障 is nonsense. I can't tolerate some of these translation errors, so I also submitted a PR.

image-2
image-2

Now it seems like it's not yet reached 2/18, but I'll just post tomorrow's rambling in advance.

If you enjoyed this, leave a comment~