If you were logged in you would be able to see more operations.
|
|
|
QuickBuild
Created: 17/Feb/22 07:41 AM
Updated: 09/Jan/23 05:11 AM
|
|
Component/s: |
None
|
Affects Version/s: |
11.0.27
|
Fix Version/s: |
None
|
|
Original Estimate:
|
Unknown
|
Remaining Estimate:
|
Unknown
|
Time Spent:
|
Unknown
|
Environment:
|
ubuntu16.04
|
|
Hello Robin.
while monitoring my qb job, I found some job had been "failed" status due to cancling job.
It occurs few times a day in my qb server.
I'm wonder that you already knew about this kind of situation and how to protect this happens
Thanks, Nick.
**for example.
[qb-soc-cp-base-57:80)] ERROR, buildid: 284356, error code: com.pmease.quickbuild.grid.GridTaskFuture
Finished: Wed, 19 Jan 2022 15:41:23 +0900
2022-01-19 15:41:24 Build [Repo:SHANNON/DEV/SMP1650/SMP1650T][BASE:/PARTIAL:/SHELVE:2790658][""]<br>[CMD:makel_shannon.sh S5308AP ERD_SIT_T0 SGC NR_V1560 N ... ](#284356) was stopped.
**how I found this from DB
SELECT A.QB_ID, A.QB_BEGIN_DATE,A.QB_MASTER_NODE_ADDRESS, A.QB_STATUS ,A.QB_STATUS_DATE ,B.QB_TIMESTAMP,B.QB_ACTION
FROM QB_BUILD A, (SELECT SUBSTR(QB_ACTION,INSTR(QB_ACTION,'(#')+2,6) AS NQID ,QB_TIMESTAMP,QB_ACTION FROM QB_AUDIT WHERE QB_ACTION LIKE '%was stopped.' AND QB_TIMESTAMP > '2022-01-01 00:00:00') B
WHERE A.QB_STATUS=2
AND A.QB_BEGIN_DATE > '2022-01-01 00:00:00'
AND A.QB_ID = B.NQID;
|
Description
|
Hello Robin.
while monitoring my qb job, I found some job had been "failed" status due to cancling job.
It occurs few times a day in my qb server.
I'm wonder that you already knew about this kind of situation and how to protect this happens
Thanks, Nick.
**for example.
[qb-soc-cp-base-57:80)] ERROR, buildid: 284356, error code: com.pmease.quickbuild.grid.GridTaskFuture
Finished: Wed, 19 Jan 2022 15:41:23 +0900
2022-01-19 15:41:24 Build [Repo:SHANNON/DEV/SMP1650/SMP1650T][BASE:/PARTIAL:/SHELVE:2790658][""]<br>[CMD:makel_shannon.sh S5308AP ERD_SIT_T0 SGC NR_V1560 N ... ](#284356) was stopped.
**how I found this from DB
SELECT A.QB_ID, A.QB_BEGIN_DATE,A.QB_MASTER_NODE_ADDRESS, A.QB_STATUS ,A.QB_STATUS_DATE ,B.QB_TIMESTAMP,B.QB_ACTION
FROM QB_BUILD A, (SELECT SUBSTR(QB_ACTION,INSTR(QB_ACTION,'(#')+2,6) AS NQID ,QB_TIMESTAMP,QB_ACTION FROM QB_AUDIT WHERE QB_ACTION LIKE '%was stopped.' AND QB_TIMESTAMP > '2022-01-01 00:00:00') B
WHERE A.QB_STATUS=2
AND A.QB_BEGIN_DATE > '2022-01-01 00:00:00'
AND A.QB_ID = B.NQID; |
Show » |
Change by Robin Shen [09/Jan/23 05:11 AM]
|
Field |
Original Value |
New Value |
Status
|
Open
[ 1
]
|
Closed
[ 6
]
|
Resolution
|
|
Cannot Reproduce
[ 5
]
|
|