A senior engineer at SF Express was fired for accidentally deleting a database!

兰博

A senior engineer at SF Express was fired for accidentally deleting a database! [Copy link]

 

According to gossips from Weibo netizens, a senior engineer at SF Technology Data Center accidentally deleted a production database, causing a service to be unavailable for 10 hours. In accordance with company regulations, SF dismissed engineer Deng and notified the company on its intranet.

According to an internal report,

Deng selected the wrong RUSS database and intended to delete the executed SQL. When selecting to delete, due to his careless operation, the cursor jumped back to the instance of the RUSS database. Without seeing the selected content clearly, he deleted it through delete. At the same time, Deng ignored the pop-up window reminder and pressed Enter directly, resulting in the deletion of the RUSS production database.

Due to the careless operation of the operation and maintenance staff, the OMCS operation monitoring and control system failed, and the temporary online dispatch function on the system was unavailable for 590 minutes.

… This failure caused serious negative impact on the business.

兰博

I am just puzzled. SF Express is a big company. If the database is deleted, there should be a backup.

Arvinˇ

It also sounded a wake-up call for myself. It is indeed very risky to delete the database at will.

star_66666

Awesome, no backup? For such a big express company, the person in charge of R&D should be severely punished, the low-level workers are always the scapegoats, most Chinese companies are like this, so sad

star_66666

The employee made a mistake, but the leader bears the main responsibility. Like leaders, like employees. It is shameless to always punish employees heavily.

star_66666

The employee made a mistake, but the leader bears the main responsibility. Like leaders, like employees. It is shameless to always punish employees heavily.

littleshrimp

Important database operations should require authorization from superiors, just like bank counters.

qwqwqw2088

The deletion of databases in general software requires multi-level protection and confirmation. It feels like it is not just about deleting the database.

chunyang

There must be backups, but performing hot backup recovery after discovering a problem requires a series of operations, which may involve higher permissions. In order to recover the mistake, whether the person who made the mistake reported it in time, remedied it in time, and whether he took actions that wasted time or even caused more and bigger problems in order to cover up the mistake, the outside world still does not know. In short, things are not as simple as just deleting the database.

chunyang

It is normal to dismiss employees who make mistakes that lead to serious consequences. In a well-managed enterprise, the relevant leaders will certainly be held accountable, and even the internal regulations and operating procedures will be revised. On June 6, 1994, a Tu-154 passenger plane from Xi'an to Guangzhou crashed shortly after takeoff. The scene was horrible. My upstairs neighbor was on the plane at the time. And I may have taken this plane before, even several times. The cause of the crash was not the pilot's error or the mechanical failure of the aircraft, but the ground maintenance personnel were careless during the operation and maintenance, plugging the two attitude sensors into each other in reverse, causing the flight instruments involved to indicate completely wrong. The air crash caused Northwest Airlines to fall into operational difficulties, and it was soon acquired and ceased to exist. The relevant responsible persons were sentenced to prison instead of being fired. Their leaders and even the entire company paid a heavy price for this.

港定

The most feared word in technical work is "seriousness". A decimal point, a symbol, or a negligence can lead to a disaster.

wrnypl1

The nRF24L01 wireless transmission module can achieve one-to-many, many-to-one, and many-to-many. According to the characteristics of the nRF24L01 chip, it can achieve that the data will not affect each other when multiple devices are running at the same time. This involves the pairing problem. When I did this, I thought of changing the receiving and sending addresses in real time. This method is indeed usable, especially in one-to-many situations, but it is not very good in many-to-one situations, and there will be data loss. Therefore, for many-to-one, it is recommended to use multi-channel receiving data, and combined with my method, I believe it can be solved. I didn't do that part. If someone has done it, I hope you can share it for learning. After all, OPEN SOURCE is a good method.

476700838

How to delete a database. The format of the drop command is: drop table tb ---tb indicates the name of the data table, the same below. The format of the truncate command is: truncate table tb ---tb indicates the name of the data table

led2015

In fact, it is all caused by chaotic management. If there are strict regulations and everyone is treated equally, there will be no loopholes.