Blog Archive

Life Lately and infinite loops

I may have kindof recreated a bug at work that ran an infinite loop that created 40k++ records on our PROD database and impacted a page on my MANAGER'S timesheet.

It's not that bad though, my manager knows of the issue. We've worked out a plan to prevent the issue from happening again (implement better data validation both on UI and backend), but the problem also piqued our curiosity on how infinite loops work.

Being that I'm more interested in the mystery of these loops, I want to uncover what happens during an infinite loop first before I actually apply the bug fixes. I'm sorry! But in my defense, my boss was also curious! Scenario:
I submitted a form that inserts records on a database based on the date range I provided on the UI form. Date range starts on December 14, 2018 and ends on September 21, 2018. Yep it's backwards and that's the issue because the backend took it. Please don't comment on the quality of our code. HAHA

Now, backend logic would loop through the dates on a daily increment and run an insert statement per date. Problem is, since the end date is a past date, the loop will never reach it, thus creating an infinite loop.

The bug created 41,046 records that dates back to December 14, 1901 all the way to January 19, 2038. And for some reason it left out April 1995 to December 2018. So what the hell happened?

Thank God for Google because all of my questions were answered.

I learned that January 19, 2038 is an important date in software development.

January 19, 2038 would be the maximum value a datetime variable in a 32bit integer data type can handle.

Now adding 1 day to that would be an abomination. Datetime couldn't read January 20, 2038. The variable would overflow, wrapping it in a negative value, which the system would interpret as... *drumroll please*

December 14 freaking 1901.

So that's what happened.

The infinite loop started on December 14, 2018 (input start date) and inserted records all the way to January 19, 2038. When it got past that day, December 14, 1901 came next on the calendar and on and on it went until April 1995. Or more accurately, after 10mins of running over the loop -- which is the default remote query timeout value set on our SQL server.

So today... I learned about the 2038 bug, a remake of the Y2K bug where 32bit datatypes storing datetime values would overflow and reset to 1901. Hopefully we already know what to do. Google has a lot of info on it already. And it's still 20 years from now, I wonder what I'd be doing then hehe.

Case closed.

Back to the real life lately...

I, uhhh, have a new bag!

My new everyday bag with Velma from my old Kipling

I'm retiring my 2-year old bag because the fabric tore somehow huhu. My husband bought me a new bag, and it's the most expensive bag I've owned so far (even more expensive than my luggage, apparently). Thank youuuuu my love! This counts as my anniv, birthday, and Christmas gift already so a girl shall ask no more hahahaha.


I was so torn when I found my everyday bag got torn (pun intended). I kept looking for the same model in Kipling stores but I couldn't find it. Either it's phased out or I may have actually brought an imitation one haha. It's a Kipling Anette I bought from TJ Maxx in Minnesota, it's kindof an outlet store for overrun things but I can't be so sure hahaha. Anyway. No luck finding something similar here so I looked at other stores. Never found something I liked at SM Dept store except for those parang Pac-safe anti-theft bags that are overly expensive, so pass. The next day I tried looking at the The Travel Club just to spy on cute bags to search on Shopee/Lazada, I don't care for imitation I just want something nice and sturdy haha. Then I found this...


I've love the functional aesthetic of Hedgren bags but it's one of those super unjustifiably expensive things I'll only get to mindlessly buy if my pay grade was at 6-digits you know? But there it was looking all nice and perfect. So I took it to Shopee, Lazada, Zalora (baka may discount), and FB Marketplace to look for this one model I like. It's Hedgren Appeal, the one with a 13inch compartment. But to no luck. Nobody sells a good enough replica of it. :(

I went to the store for the second time before heading home just to take a final look at it and decide if it's worth the occasional splurge. This is an item I definitely cannot afford without maxing myself out, you know what I mean? Like you have extra but it's not meant for such kinda bags. So my husband rescued me! YEHEY! I have a new bag!

.
.
.

Uhhh, so that's the highlight of my week lol.
Share:

Friday's 10 Happy Things

Hey goys, here I am squeezing my brain for happy things, let's go!

1. I loved the sermon last Sunday, actually no, I uhm, needed it. Worship is for God. It's all about Him. He is the audience, and we are the performers.
2. It's swelday today yeheeeeyy
3. Sierra Burgess is a Big Loser is out today. Excited to watch it.
4. Also excited to continue episode two of Designated Survivor.
5. I uhm, designed something quickly for the boss today. Aaaand I learned how to warp text! Finally? What kind of designer am I! Apparently I've been doing things the hard way, typing on a circular path instead of hitting the Text Warp tool. Thanks boss for the Photoshop tip!


Bebas Neue, Day Roman, Miama Nueva, Krinkes Decor
Pinterest, The Noun Project, Mockup World

6. I finally ordered a dashcam. I got a Xiaomi Yi from Shopee for ₱1709 only because of the sale, free shipping voucher, and credit card discount hehe. Hopefully I can manage to install it properly without damaging my car lol, I just want the wires hidden properly help me Lord.
7. Was able to request a cashout for my below-threshold Nuffnang earnings (because they're closing down operations already)! Looking forward to it... the cashout I mean. I'm sad about Nuffnang closing down, I've a lengthy draft about it. :(
8. Also, got a PR posting request from Nuffnang too. Prolly the last I'm getting from them, but yey for the extra money.
9. Grocery tomorrow! I wish I could convince my husband that grocery shopping is fun :(
10. Costa iced mocha is delicious! I'm kindof building an iced mocha preference and so far from all the coffee shops I've tried, Nitro 7's still tops. Next comes Costa!

Happy weekend people! Excited for the next two weeks! :D 

Share:

Get in shape during the Holiday season with Taiwan Excellence premium-grade gym gear

As Filipinos, the holiday season kicks off as early as September. It is a time of festivities, parties, and wonderful reunions with family and friends. In these times, keeping up a consistent gym schedule can be tough. Fortunately, Taiwan Excellence is introducing its state-of-the-art exercise equipment to tone and buff up during this frenetic time.




Burn the unwanted calories from that leche flan with the Johnson Health Tech. Co., Ltd.'s Upright Bike-Matrix U50. It has a Comfort Arc Seat that is designed to provide comfort while regulating perspiration, improving calves and hamstrings, and strengthening abdominals.

This sophisticated stationary bicycle has an ergonomic design, and provides an easy step-through access. It also has an Exact Force feature to let fitness enthusiasts adjust the resistance of the pedal depending on his stamina.


If you would rather look for adventure outside, the Tern Taiwan Ltd.'s Verge X20 is worth checking out. This portable bike can be easily folded as it weighs only 9.9 kilograms. Moreover, the Verge X20 makes biking more exciting as it is equipped with Kinetic Pro X wheels. This rubber hoop can strengthen muscles and improve aerodynamics to make you go faster. It also helps condition your metabolic rate.


Fitness fanatics can couple these bicycles with Unite Creative Design Co., Ltd.'s Compression seamless bike sports pants. Compared to others, this innovative elastic apparel is made with environmental friendly materials. Aside from providing protection, it also helps on reducing blood pressure and improve heart rhythm.


Finish your look off with sports goggles. First Rank Co., Ltd. offers JET-S58, a stylish set that has a double-coating technology that enhances the durability of anti-fog performance. This helps users see when swimming, and guard eyes from water or chemicals.

While it is great to celebrate Christmas, it also important to tone up and improve endurance. Say goodbye to holiday weight and take home these smart, functional, and stylish products for a stronger physical health. These innovations are carefully evaluated and sealed by TAITRA with the guidance from the Bureau of Foreign Trade to promote Taiwan's revolutionary products.

For more information about its accredited products, visit www.taiwanexcellence.org or like Taiwan Excellence on Facebook.

###

About Taiwan Excellence
The symbol of Taiwan Excellence honors Taiwan’s most innovative products, which provide tremendous value to users worldwide. Products bearing this symbol have been selected for specific Taiwan Excellence Awards, based on their excellence in design, quality, marketing, Taiwanese R&D, and manufacturing. Initiated by the Ministry of Economic Affairs (MOEA), R.O.C. in 1992, the symbol of Taiwan Excellence is recognized by 102 countries.

Organized by Bureau of Foreign Trade (BOFT), MOEA
The Bureau of Foreign Trade (BOFT) under the Ministry of Economic Affairs (MOEA), R.O.C. is responsible for implementing policies and regulations governing foreign trade and economic cooperation. Established in January 1969, the BOFT's role and position have been adapted regularly to meet the needs of the ever-changing international economic and trade environments. BOFT guides and works with the Taiwan External Trade Development Council (TAITRA) in numerous promotional trade projects and activities, both internationally and domestically. Having worked closely with TAITRA for several decades, BOFT continues to commission TAITRA for various critical government projects relating to business, trade, and investment, while promoting Taiwan internationally.

Implemented by Taiwan External Trade Development Council (TAITRA)
Founded in 1970 to help promote foreign trade, the Taiwan External Trade Development Council (TAITRA) is the foremost non-profit, quasi-governmental trade promotion organization in Taiwan. Jointly sponsored by the government, industry associations, and several commercial organizations, TAITRA assists Taiwanese businesses and manufacturers in strengthening their international competitiveness and in dealing with the challenges they face in foreign markets. TAITRA boasts a well-coordinated trade promotion and information network of over 1,200 international marketing specialists stationed throughout its Taipei headquarters and 50 overseas offices worldwide. Together with its sister organizations, the Taiwan Trade Center (TTC) and the Taipei World Trade Center (TWTC), TAITRA has created a wealth of trade opportunities through effective promotion strategies.
Share:

The Layout Currently

Sharing this for backup purposes! :)

Mockup from magicmockups.com

Listing out the features so I know which template to refer to in case I wanted to extract a certain feature:✔  Top horizontal navigation bar
✔  Custom status message box (ie. "Category: label" instead of Blogger's original "Showing posts with the label x. Show all")
✔  Inline Google ads using <!-- adsense --> markup
✔  Disqus comment count
✔  Back to top button
✔  Blog Archive widget on a page
✔  Original blog search widget
Share: