Chapter 8 (1/2)
It was the second re-activation of the DB due to the sara more than 90 of the memory on the server If it was temporary, there would be no proble would freeze the moment memory reaches 100
It was the second re-activation of the DB due to the sara more than 90 of the memory on the server If it was temporary, there would be no proble would freeze the moment memory reaches 100
“Hyung, is it alright to re-activate this on a whim?”
“Nope”
“I don’t think this is right”
“Me too… I am of the same opinion”
Ring Ring (telephone sounds)
The telephones in the conference roo them a moment to breathe It was the complaints from the students whose screen froze
“When can I register for the courses again?”
“It will be back to normal soon”
-it’s not ht?
“Yes It’s happening to all the 3rd years So you don’t need to worry”
The worries of the students were about just one thing
Am I the only one who has this problem? While I’m stuck, wouldn’t my preferred course fill up? – They worried about these
‘hmm……’
Even as he was answering the calls, YongHo’s attention was soBut fro off
“Look at that, that sunbae still has the time to wander off even in this situation”
“Don’t say that, SuMin”
“I can’t understand why SungGyu-sunbae would cover for someone like him”
“But he’s kind!”
“Kind? Didn’t you see that he was only wearing briefs in the clubroom?”
At SuMin’s words, HyeJin turned around, face red She then changed topic
“Th…There’s another call, let et it”
HyeJin picked up the telephone in a hurry, YongHo, as focusing on the bugalso heard their conversation If so(≈165m2) room, then one couldn’t not hear it
‘Why does she hate me so much?’
YongHo hadn’t really done anything wrong Other than settling his food and lodging, he had done nothing to feel bad about
‘But anyway, Line 107, that is where SQL(Structured Query Language, used in relational database) is run…’
YongHo looked at the details of the bug
‘Hmm… But what does this mean?”
Even though he’s a 4th year, and he had done ram related part time jobs, he was still a student It wasn’t the first time he had seen content like this, but he couldn’t really understand anything
title: A Table Lock has occurred
Details: Due to the SELECT FOR UPDATE statement, a Table Lock has occurred Due to the lock, other users trying to access the related table are waiting and is causing the current error
Solution: Change the SELECT FOR UPDATE to SELECT FOR UPDATE WAIT 3 to make other users end their sessions after around 3 seconds
‘I need to tell this somehow……”
The bugs up till now, YongHo had knowledge of it But so like SQL… that was an exception All he kneas so from 3rd year when he listened to the Database course
‘Let’s indirectly throw it to SungGyu-Hyung”
He first wanted to confire was running towards 100 They could eat lunch only after 2 more re-activations happened
YongHo quietly called SungGyu as about to enter the conference room
“Hyung, wait a sec”
“Sorry?”
“Just talk to me for a sec”