When the uploading video fails, the status of the task of the application of the current channel [4: under review (platform)], not [3: failed (channel release)], the sequence of queue execution amplifies the program bug

1. When the upload video fails, the status of the task of the application of the application is [4: under review (platform)], not [3: failed (channel release)]. View the release log table, 1 Douyin content, and send it to 5 Douyin accounts at the same time. 3 of these accounts failed to upload videos. The task ID of the channel application: 159, 162, 163. as shown in Figure 1

Figure 1

2. Check the task table of the application of the channel, the task ID of the application’s task ID: 159, 162, and 163 corresponding 3 records, the expected status [3: failed (channel release)]. However, the task ID of the application of the channel: 162 and 163 corresponding 3 records, and the status [4: under review (platform)]. as shown in Figure 2

Figure 2

3. Check the code implementation carefully. After uploading the video fails, modify the status of the application task of the channel [3: Failed (Channel Release)]. Then insert the release log table. The whole release process ends.

4. Finally decide to analyze the task ID of the analysis task: the task ID of the application of other channels under 40: 160, 161. When the task ID of the channel’s application: 160 is successfully uploaded, perform the operation of creating the video. In this operation, when it is updated to 4, it is based on the task ID, not the task ID of the channel-based application. as shown in Figure 3

Figure 3

5. Then the time process of this bug can be speculated: when the task ID of the channel’s application: 159 failed to upload the video, modify the status [3: Failed (channel release)]. When the task ID of the channel application: 160 is successfully created, the status of the task table of the application of the channel is modified in batches based on the task ID: 40 [4: under review (platform)]. Then the task ID of the application of the channel at this time: 162 and 163 failed to upload the video, modify the status [3: failed (channel release)], and the modification failed, because the modification condition is the status [releasing (channel release)].

6. Check the task ID of the application of the channel: 159 The time node for the failure to upload the video: 2021-07-15 11:35:11, which is earlier than the task ID of the channel application: 160 Create the time node for the successful video. as shown in Figure 4

Figure 4

7. Check the task ID of the application of the channel: 162, 163 When the upload video failed to upload the video: 2021-07-15 11:35:38, 2021-07-15 At 11:35:48, the task ID of the application’s task later than the channel’s application: 160 creates a successful time node for the video. as shown in Figure 5

Figure 5

8. The task ID of the application of the channel: 160 The time node of the successful upload of the video: 2021-07-15 11:34:57. The task ID of the channel application: 160 creates a successful time node of the video, but it is definitely later than 2021-07-15 11:34:57. Subsequent plans to add fields: item_created_at to table: cpa_douyin_video. Note: The time of the video content was created. as shown in Figure 6

Figure 6