TeamCity 2019.1 'Composite' builds not displaying latest build from the 'Classic' UI main page
Hello,
We just upgraded from 2018.4 to 2019.1. We started getting reports that the builds were not happening on their scheduled triggers. In investigating this it looks like the main page, using the 'Classic' UI, doesn't appear to be updating our 'Composite' builds with the latest build information. It appears to display the builds properly in the new 'Experimental' UI. Our other non-composite projects do not appear to have this issue.
The work-around is to navigate to the configurations' Overview or History page, which lists all the builds, including the latest. I wanted to see if anybody else has run in to this or if JetBrains is already aware. If there is a setting I can change to solve this that would be wonderful, but since it's working in the 'New' UI and not the 'Classic' I believe this may be a new bug.
I held off filing an issue until I could determine if it was already known. Thanks for the help, I appreciate it.
EDIT: Restarting the TeamCity server did not help. It is the same from multiple browsers on multiple machines.
Jim
Please sign in to leave a comment.
Hi, could you please attach screenshots from both classic and new UI?
Sorry for the sizes of the images. I was trying to capture at least 2 of our 'Composite' builds in the screen shots. If you look at the build numbers in the images below, you will see the build number for the 'Oregon/Composite' build is #0.8.0.169 in the 'Classic UI', and #0.8.0.176 in the 'New Experimental UI'. Same issue with the 'Illinois/Composite' build.
Using the Classic UI, the main page is no longer updating to show the latest builds.
Thanks for the help,
Jim
Classic UI
New Experimental UI
Thanks, could you please also attach screenshots from the History and build configuration Overview tabs in the Classic UI?
Sure. Please let me know if these aren't the screens that you are referring to. I'm using the 'Oregon/Composite' builds for these screenshots.
Oregon - Composite - Overview (Classic UI)
Oregon - Composite - History (Classic UI)
> Using the Classic UI, the main page is no longer updating to show the latest builds.
Does it mean that when you refresh the page in classic UI it starts showing fresh builds, but it does not update itself?
No, it never displays the latest builds. It seems stuck on those builds. I'm not 100% certain but I think it stopped updating as soon as the upgrade happened to 2019.1, but I'm not positive of this. It was a couple of days until team members brought the issue to my attention.
If you have access to database, could you please execute the following query:
where <composite configuration id> is id of affected build configuration.
Here you go. This was from the 'Oregon/Composite' build. Please let me know if you need something else or would like it in a different format.
build_number,id,build_id,build_type_id,modification_id,personal_modification_id,personal_user_id,is_personal,is_canceled,is_changes_detached,is_deleted,branch_name,queued_time,remove_from_queue_time,chain_modification_id
0.8.0.177,19433,19433,bt72,-1,NULL,NULL,0,0,0,0,NULL,1559286002403,1559286002985,-1
0.8.0.176,19386,19386,bt72,-1,NULL,NULL,0,0,0,0,NULL,1559199614108,1559199614613,-1
0.8.0.175,19343,19343,bt72,-1,NULL,NULL,0,0,0,0,NULL,1559113210022,1559113210100,-1
0.8.0.174,19303,19303,bt72,-1,NULL,NULL,0,0,0,0,NULL,1559026811955,1559026811989,-1
0.8.0.173,19288,19288,bt72,-1,NULL,NULL,0,0,0,0,NULL,1558940407511,1558940407538,-1
0.8.0.172,19281,19281,bt72,-1,NULL,NULL,0,0,0,0,NULL,1558854004343,1558854004370,-1
0.8.0.171,19277,19277,bt72,-1,NULL,NULL,0,0,0,0,NULL,1558767600936,1558767601044,-1
0.8.0.170,19257,19257,bt72,-1,NULL,NULL,0,0,0,0,NULL,1558681210781,1558681211354,-1
0.8.0.169,19229,19229,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558636522146,1558636522181,NULL
0.8.0.168,19206,19206,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558594801990,1558594802197,NULL
0.8.0.167,19165,19165,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558508401325,1558508401596,NULL
0.8.0.166,19134,19134,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558422017900,1558422017968,NULL
0.8.0.165,19106,19106,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558335615664,1558335615847,NULL
0.8.0.164,19099,19099,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558249216583,1558249216629,NULL
0.8.0.163,19093,19093,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558162815404,1558162815464,NULL
0.8.0.162,19071,19071,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1558076412144,1558076412177,NULL
0.8.0.161,19045,19045,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557990013241,1557990013276,NULL
0.8.0.160,19012,19012,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557903613464,1557903613519,NULL
0.8.0.159,18975,18975,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557817212857,1557817212931,NULL
0.8.0.158,18948,18948,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557730813014,1557730813080,NULL
0.8.0.157,18941,18941,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557644412576,1557644412706,NULL
0.8.0.156,18936,18936,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557558011936,1557558011989,NULL
0.8.0.155,18911,18911,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557471613489,1557471613533,NULL
0.8.0.154,18880,18880,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557424434464,1557424434524,NULL
0.8.0.153,18859,18859,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557385215390,1557385215431,NULL
0.8.0.152,18836,18836,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557298816595,1557298816646,NULL
0.8.0.151,18796,18796,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557212415165,1557212415245,NULL
0.8.0.150,18757,18757,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557126014777,1557126014836,NULL
0.8.0.149,18752,18752,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1557039613782,1557039613842,NULL
0.8.0.148,18746,18746,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556953214068,1556953214096,NULL
0.8.0.147,18711,18711,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556866813278,1556866813307,NULL
0.8.0.146,18688,18688,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556780414451,1556780414482,NULL
0.8.0.145,18658,18658,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556694016448,1556694016548,NULL
0.8.0.144,18615,18615,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556607615703,1556607615729,NULL
0.8.0.143,18571,18571,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556521215618,1556521215665,NULL
0.8.0.142,18564,18564,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556434816954,1556434817007,NULL
0.8.0.141,18555,18555,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556348400244,1556348400283,NULL
0.8.0.140,18520,18520,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556262001086,1556262001139,NULL
0.8.0.139,18482,18482,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556175601417,1556175601450,NULL
0.8.0.138,18441,18441,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556089200572,1556089200601,NULL
0.8.0.137,18396,18396,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1556002819390,1556002819445,NULL
0.8.0.136,18355,18355,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555916401112,1555916401147,NULL
0.8.0.135,18349,18349,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555830006728,1555830006759,NULL
0.8.0.134,18345,18345,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555743611285,1555743611425,NULL
0.8.0.133,18324,18324,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555657212684,1555657212723,NULL
0.8.0.132,18302,18302,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555570815709,1555570815740,NULL
0.8.0.131,18265,18265,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555484418029,1555484418063,NULL
0.8.0.130,18225,18225,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555398017696,1555398017772,NULL
0.8.0.129,18197,18197,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555311618898,1555311618932,NULL
0.8.0.128,18187,18187,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555225202878,1555225202922,NULL
0.8.0.127,18181,18181,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555138805884,1555138805915,NULL
0.8.0.126,18144,18144,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1555052407437,1555052407467,NULL
0.8.0.125,18106,18106,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554966008409,1554966008452,NULL
0.8.0.124,18069,18069,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554879610405,1554879610451,NULL
0.8.0.123,18023,18023,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554793213893,1554793213951,NULL
0.8.0.122,17978,17978,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554706805836,1554706805906,NULL
0.8.0.121,17970,17970,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554620403275,1554620403409,NULL
0.8.0.120,17965,17965,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554534000763,1554534000793,NULL
0.8.0.119,17924,17924,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554447601085,1554447601115,NULL
0.8.0.118,17886,17886,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554361219586,1554361219633,NULL
0.8.0.117,17846,17846,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554274818152,1554274818180,NULL
0.8.0.116,17805,17805,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554188418183,1554188418212,NULL
0.8.0.115,17754,17754,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554102016941,1554102017012,NULL
0.8.0.114,17748,17748,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1554015618603,1554015618638,NULL
0.8.0.113,17742,17742,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553929200835,1553929200896,NULL
0.8.0.112,17705,17705,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553842801299,1553842801370,NULL
0.8.0.111,17660,17660,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553756401728,1553756401768,NULL
0.8.0.110,17618,17618,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553670003362,1553670003413,NULL
0.8.0.109,17588,17588,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553583602685,1553583602720,NULL
0.8.0.108,17566,17566,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553497203009,1553497203054,NULL
0.8.0.107,17563,17563,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553410808068,1553410808113,NULL
0.8.0.106,17559,17559,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553324411834,1553324411881,NULL
0.8.0.105,17537,17537,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553238012979,1553238013029,NULL
0.8.0.104,17516,17516,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553151600088,1553151600134,NULL
0.8.0.103,17487,17487,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553065219914,1553065219954,NULL
0.8.0.102,17467,17467,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1553015785184,1553015785224,NULL
0.8.0.101,17455,17455,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552978819213,1552978819242,NULL
0.8.0.100,17433,17433,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552892417419,1552892417454,NULL
0.8.0.99,17428,17428,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552806002388,1552806002417,NULL
0.8.0.98,17425,17425,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552719606075,1552719606105,NULL
0.8.0.97,17403,17403,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552633203453,1552633203502,NULL
0.8.0.96,17366,17366,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552546800591,1552546800624,NULL
0.8.0.95,17330,17330,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552460414910,1552460414955,NULL
0.8.0.94,17290,17290,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552374004328,1552374004360,NULL
0.8.0.93,17248,17248,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552287605471,1552287605502,NULL
0.8.0.92,17243,17243,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552204818228,1552204818259,NULL
0.8.0.91,17238,17238,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552118408963,1552118409011,NULL
0.8.0.90,17190,17190,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1552032019216,1552032019247,NULL
0.8.0.89,17166,17166,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551945606020,1551945606049,NULL
0.8.0.88,17144,17144,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551859210848,1551859210881,NULL
0.8.0.87,17118,17118,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551772813389,1551772813417,NULL
0.8.0.86,17088,17088,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551686419089,1551686419131,NULL
0.8.0.85,17084,17084,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551600008746,1551600008781,NULL
0.8.0.84,17081,17081,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551513618551,1551513618598,NULL
0.8.0.83,17059,17059,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551427207012,1551427207043,NULL
0.8.0.82,17024,17024,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551340810514,1551340810543,NULL
0.8.0.81,16987,16987,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551254415584,1551254415615,NULL
0.8.0.80,16953,16953,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551168018691,1551168018842,NULL
0.8.0.79,16914,16914,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1551081613507,1551081613542,NULL
0.8.0.78,16905,16905,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550995200471,1550995200510,NULL
0.8.0.77,16899,16899,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550908806522,1550908806566,NULL
0.8.0.76,16858,16858,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550822406928,1550822406963,NULL
0.8.0.75,16811,16811,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550736007788,1550736007817,NULL
0.8.0.74,16794,16794,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550697637508,1550697637548,NULL
0.8.0.73,16776,16776,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550649610544,1550649610604,NULL
0.8.0.72,16751,16751,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550563215393,1550563215422,NULL
0.8.0.71,16739,16739,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550476800335,1550476800379,NULL
0.8.0.70,16734,16734,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550390407716,1550390407753,NULL
0.8.0.69,16730,16730,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550304015673,1550304015710,NULL
0.8.0.68,16715,16715,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550217617947,1550217617978,NULL
0.8.0.67,16685,16685,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550131200996,1550131201036,NULL
0.8.0.66,16663,16663,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1550044805272,1550044805302,NULL
0.8.0.65,16632,16632,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549958406820,1549958406847,NULL
0.8.0.64,16595,16595,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549872009333,1549872009375,NULL
0.8.0.63,16593,16593,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549785618307,1549785618340,NULL
0.8.0.62,16589,16589,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549699206482,1549699206523,NULL
0.8.0.61,16538,16538,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549612806349,1549612806387,NULL
0.8.0.60,16514,16514,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549526409804,1549526409838,NULL
0.8.0.59,16478,16478,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549440010468,1549440010506,NULL
0.8.0.58,16443,16443,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549353612177,1549353612210,NULL
0.8.0.57,16437,16437,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549328326733,1549328326769,NULL
0.8.0.56,16416,16416,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549267215175,1549267215211,NULL
0.8.0.55,16411,16411,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549180802573,1549180802611,NULL
0.8.0.54,16409,16409,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549094410465,1549094410521,NULL
0.8.0.53,16388,16388,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1549008009687,1549008009745,NULL
0.8.0.52,16360,16360,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548921614458,1548921614505,NULL
0.8.0.51,16327,16327,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548835206240,1548835206280,NULL
0.8.0.50,16312,16312,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548748804992,1548748805048,NULL
0.8.0.49,16295,16295,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548662401332,1548662401363,NULL
0.8.0.48,16292,16292,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548576001913,1548576001960,NULL
0.8.0.47,16290,16290,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548489600720,1548489600754,NULL
0.8.0.46,16270,16270,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548403217679,1548403217713,NULL
0.8.0.45,16256,16256,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548316816282,1548316816312,NULL
0.8.0.44,16240,16240,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548230416232,1548230416294,NULL
0.8.0.43,16223,16223,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548144012214,1548144012250,NULL
0.8.0.42,16219,16219,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1548057610434,1548057610484,NULL
0.8.0.41,16213,16213,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1547971209017,1547971209053,NULL
0.8.0.40,16208,16208,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1547884808756,1547884808807,NULL
0.8.0.39,16186,16186,bt72,NULL,NULL,NULL,0,0,0,0,NULL,1547798402185,1547798402222,NULL
0.8.0.38,16162,16162,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547712010554,1547712010579,-1
0.8.0.37,16139,16139,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547625618959,1547625618985,-1
0.8.0.36,16112,16112,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547539205824,1547539205852,-1
0.8.0.35,16090,16090,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547452813245,1547452813267,-1
0.8.0.34,16086,16086,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547366405779,1547366405807,-1
0.8.0.33,16083,16083,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547280016879,1547280016902,-1
0.8.0.32,16061,16061,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547193603541,1547193604681,-1
0.8.0.31,16037,16037,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547107204035,1547107204061,-1
0.8.0.30,16024,16024,bt72,-1,NULL,NULL,0,0,0,0,NULL,1547020812464,1547020812488,-1
0.8.0.29,16006,16006,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546934417185,1546934417206,-1
0.8.0.28,15984,15984,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546848019203,1546848019226,-1
0.8.0.27,15980,15980,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546761608347,1546761608379,-1
0.8.0.26,15979,15979,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546675217526,1546675217548,-1
0.8.0.25,15951,15951,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546588801710,1546588801732,-1
0.8.0.24,15938,15938,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546502408729,1546502408750,-1
0.8.0.23,15923,15923,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546416000199,1546416000244,-1
0.8.0.22,15920,15920,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546329613651,1546329613680,-1
0.8.0.21,15910,15910,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546243206915,1546243206949,-1
0.8.0.20,15907,15907,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546156816819,1546156816905,-1
0.8.0.19,15904,15904,bt72,-1,NULL,NULL,0,0,0,0,NULL,1546070404927,1546070404952,-1
0.8.0.18,15886,15886,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545984005316,1545984005345,-1
0.8.0.17,15874,15874,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545897604568,1545897604596,-1
0.8.0.16,15864,15864,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545811211998,1545811212027,-1
0.8.0.15,15861,15861,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545724818776,1545724818802,-1
0.8.0.14,15857,15857,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545638407231,1545638407338,-1
0.8.0.13,15855,15855,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545552017352,1545552017375,-1
0.8.0.12,15852,15852,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545465605298,1545465605329,-1
0.8.0.11,15845,15845,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545379212705,1545379212724,-1
0.8.0.10,15821,15821,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545292819447,1545292819467,-1
0.8.0.9,15782,15782,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545206411105,1545206411127,-1
0.8.0.8,15762,15762,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545120014777,1545120014800,-1
0.8.0.7,15747,15747,bt72,-1,NULL,NULL,0,0,0,0,NULL,1545033606934,1545033606965,-1
0.8.0.6,15746,15746,bt72,-1,NULL,NULL,0,0,0,0,NULL,1544947214768,1544947214792,-1
0.8.0.5,15743,15743,bt72,-1,NULL,NULL,0,0,0,0,NULL,1544860805018,1544860805041,-1
0.8.0.4,15724,15724,bt72,-1,NULL,NULL,0,0,0,0,NULL,1544774411248,1544774411268,-1
0.8.0.3,15698,15698,bt72,-1,NULL,NULL,0,0,0,0,NULL,1544688016648,1544688016666,-1
0.8.0.2,15691,15691,bt72,-1,NULL,NULL,0,0,0,0,NULL,1544647911632,1544647911701,-1
0.8.0.1,15674,15674,bt72,-1,NULL,NULL,0,0,0,0,NULL,1544567054243,1544567054280,-1
(177 row(s) affected)
Another piece of information. I don't know if this will help with diagnosing the issue. Out team uses some automation to grab the latest builds for our deployment & testing. Apparently using the URLs also returns the wrong build, so it's more then just the Classic UI. I asked him to write something up so I could pass it along. I did remove the server name from the URLs, as they wouldn't work anyway. Here's what he said:
http://[SERVER.NAME]/guestAuth/repository/downloadAll/Monaco_Illinois_CompositeTrunkIllinoisGames/.lastFinished
When I navigate to the above link, a download starts, but for the wrong build number. In this case, build 0.9.0.121 is downloaded. When visiting team city, I can see that the latest build for the project is 0.9.0.136. When using classic UI, viewing the entire Monaco project, the latest build is incorrectly displayed as 0.9.0.121 (the same build that was downloaded) see this link:
http://[SERVER.NAME]/project.html?projectId=Monaco&fromExperimentalUI=true
On both the classic and experimental UI, when viewing the single project, the latest build is correctly displayed as 136. It is only on the Classic UI, when viewing the entire Monaco summary, which allows you to view multiple projects, that the latest build number is incorrectly displayed as 121.
Thank you! I see that for some reason previous version of TeamCity stored NULL instead of -1 in modification_id of builds in this configuration. It is a bug, we'll try to find out when it was introduced and when it was fixed. We'll also think about workaround for your case.
BTW, could you please check what version of TeamCity produced build with number: #0.8.0.38,16162 ? You can see it in build log in verbose mode. There will be message like:
TeamCity server version is 2019.1.1 EAP (build 66059)
For that build, since it's a 'Composite' build, I don't see anything like that in the build log. It consists of exactly 1 line, which is:
"[02:00:14]Build finished"
I don't see any 'verbose' option on the page. Please let me know if there is something I'm missing. Thank you.
Jim
Maybe you're using Tail view? Please switch to Tree view. There is a combobox with different modes:
* Errors
* Important messages
* All messages
* Verbose
Ok, if I download the log I get the information. Here's what I found:
0.8.0.38: [02:00:10]i: TeamCity server version is 2018.1.2 (build 58537)
0.8.0.39: [02:00:02]i: TeamCity server version is 2018.2.1 (build 61078)
Not sure if it's relevant, but on those log lines there is an extra 'i' present between the time stamp and the ':'.
Jim
Could you please also tell me what triggered builds: #0.8.0.39 and #0.8.0.170 ? There is a "Triggered by" label on build results page.
Looking at the time stamp, these would have both been triggered by a schedule trigger.
0.8.0.170: Triggered by: Schedule Trigger on 24 May 19 02:00
0.8.0.39: Triggered by: Schedule Trigger on 18 Jan 19 02:00
I pulled those off of the 'Overview' page.
Jim
So far I managed to reproduce the following problem: https://youtrack.jetbrains.com/issue/TW-60704
But it occurs only if composite build does not have snapshot dependencies at all. Can this be the case here?
That is correct. We have multiple 'Composite' projects that do not use Snapshot Dependencies and they are all having this issue. I took a quick screenshot for you to see how it's configured:
Do you think it will be possible to create an SQL command to 'fix' the NULL data, for the Composite builds, in our database? Is that something you were looking in to?
I don't know enough about the product or SQL to know if that's a bad idea. If so we'll have to work-around it until a proper fix is pushed out.
Thank you,
Jim
Great! This problem should not reproduce in 2019.1 anymore, but in your case we need to fix data in database.
For this please execute the following SQL query:
update build_state set modification_id = -1, chain_modification_id = -1 where build_type_id = 'bt72' and build_state_id >= 16186 and build_state_id <= 19229
You'll need to restart the server after that.
I'm using SQL Server Management Studio. I highlight the 'teamcity' database and choose 'New Query'. I then paste in your command and choose 'Execute'.
I received this when I executed that:
Msg 207, Level 16, State 1, Line 1
Invalid column name 'build_state_id'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'build_state_id'.
Sorry, fixed query:
update build_state set modification_id = -1, chain_modification_id = -1 where build_type_id = 'bt72' and id >= 16186 and id <= 19229
Thanks, I'll give it a shot. Also, do I have to run a separate command to fix each 'Composite' build we have? I rant your previous command for our 'Illinois/Composite' build configuration and noticed the build_type_id was different. Is this command specific only to our 'Oregon/Composite' build configuration?
Thanks again for all your support, it's really appreciated.
Jim
I ran the command for the OSL Composite build and it's displaying correctly now. I'll keep an eye on it to see if new builds get left behind or if the issue is fixed.
I also see that, for each Composite build, I'll have to run a different command. I see how you created the 'fix' command and I'll get the data for each configuration and fix it up.
Thanks a ton for helping with this!
Jim
How many such composite build configurations without snapshot dependencies do you have?
The query has to be modified for each case because of different ids. I'll need results of the previous select query for all of them one by one:
Then I'll be able to provide you with update queries for them.
No worries, I already grabbed the various id's. I see how you limited the command to just act on the invalid line items. I went through and modified the command for each id with the proper range. I updated 2 of our configurations (out of 5) but had to take off. I'll finish up the rest tomorrow and let you know if we still see any issues.
The two configurations I updated (the one you sent to me and a 2nd one I updated) showed the proper builds on the main page. I'll check tomorrow morning after their scheduled builds to make sure they are continuing to update.
Again, I really appreciate the help with this.
Jim
I am glad this workaround works. Happy building!
Pavel,
I updated all of our Composite builds (there are 5 of them). I noticed one of them was still incorrect. I can see what's wrong, but I don't know why it's different. I wanted to send you this info in case there is something else going on you should look at, or in case I screwed up. I'm including all of the commands I used to modify the 5 builds as well as the table results for the one that has the issues.
The outlier build is 'Monaco_Manitoba_CompositeManitobaManitobaGames'. The builds that I didn't modify have the value '13454' for their chain_modification_id. I can modify the commands to change this, but before I did anything I wanted to ask you about it.
Thank you very much,
Jim
Configuration IDs for all 5 Composite Builds
Commands Used to Query the Build Information
Commands Used to repair the 5 Composite Builds
Manitoba/Composite Table Results
Query Used: select h.build_number, b.* from build_state b join build_type_mapping m on m.int_id = b.build_type_id join history h on h.build_state_id = b.id where m.ext_id = 'Monaco_Manitoba_CompositeManitobaManitobaGames' order by b.build_id desc;
build_number,id,build_id,build_type_id,modification_id,personal_modification_id,personal_user_id,is_personal,is_canceled,is_changes_detached,is_deleted,branch_name,queued_time,remove_from_queue_time,chain_modification_id
0.6.2.13,18822,18822,bt54,-1,NULL,NULL,0,0,0,0,NULL,1557268934954,1557268934985,-1
0.6.2.12,18458,18458,bt54,-1,NULL,NULL,0,0,0,0,NULL,1556131479510,1556131479544,-1
0.6.2.11,18449,18449,bt54,-1,NULL,NULL,0,0,0,0,NULL,1556119782843,1556119782889,-1
0.6.2.10,18280,18280,bt54,-1,NULL,NULL,0,0,0,0,NULL,1555518617938,1555518617974,-1
0.6.2.9,17653,17653,bt54,-1,NULL,NULL,0,0,0,0,NULL,1553744717651,1553744717687,-1
0.6.2.8,17591,17591,bt54,-1,NULL,NULL,0,0,0,0,NULL,1553609375002,1553609375045,-1
0.6.2.7,17410,17410,bt54,-1,NULL,NULL,0,0,0,0,NULL,1552664146717,1552664146757,-1
0.6.2.6,17358,17358,bt54,-1,NULL,NULL,0,0,0,0,NULL,1552516459449,1552516459494,-1
0.6.2.5,17033,17033,bt54,-1,NULL,NULL,0,0,0,0,NULL,1551377078550,1551377078589,-1
0.6.2.4,16233,16233,bt54,-1,NULL,NULL,0,0,0,0,NULL,1548199905883,1548199905927,-1
0.6.2.3,16202,16202,bt54,-1,NULL,NULL,0,0,0,0,NULL,1547853519329,1547853519370,-1
0.6.2.2,16177,16177,bt54,-1,NULL,NULL,0,0,0,0,NULL,1547767024006,1547767024050,-1
0.6.2.1,16008,16008,bt54,-1,NULL,NULL,0,0,0,0,NULL,1546962402071,1546962402102,13454
0.6.1.9,15804,15804,bt54,-1,NULL,NULL,0,0,0,0,NULL,1545251153136,1545251153164,13454
0.6.1.8,15777,15777,bt54,-1,NULL,NULL,0,0,0,0,NULL,1545174328197,1545174328223,13454
0.6.1.7,15755,15755,bt54,-1,NULL,NULL,0,0,0,0,NULL,1545083752241,1545083752277,13454
0.6.1.6,15736,15736,bt54,-1,NULL,NULL,0,0,0,0,NULL,1544824503974,1544824504002,13454
0.6.1.5,15715,15715,bt54,-1,NULL,NULL,0,0,0,0,NULL,1544741351858,1544741351885,13454
0.6.1.4,15700,15700,bt54,-1,NULL,NULL,0,0,0,0,NULL,1544719503171,1544719503201,13454
0.6.1.3,15629,15629,bt54,-1,NULL,NULL,0,0,0,0,NULL,1544225303421,1544225303454,13454
0.6.1.2,15622,15622,bt54,-1,NULL,NULL,0,0,0,0,NULL,1544209981833,1544209981864,13454
0.6.1.1,15519,15519,bt54,-1,NULL,NULL,0,0,0,0,NULL,1543872110998,1543872111042,13454
0.6.0.279,14892,14892,bt54,-1,NULL,NULL,0,0,0,0,NULL,1540938349853,1540938349882,13454
0.6.0.278,14792,14792,bt54,-1,NULL,NULL,0,0,0,0,NULL,1540419559209,1540419559239,13454
0.6.0.277,14777,14777,bt54,-1,NULL,NULL,0,0,0,0,NULL,1540396692139,1540396692174,13454
0.6.0.276,14547,14547,bt54,-1,NULL,NULL,0,0,0,0,NULL,1539110434518,1539110434550,13454
0.6.0.275,14499,14499,bt54,-1,NULL,NULL,0,0,0,0,NULL,1538773214814,1538773214849,13454
0.6.0.274,14437,14437,bt54,-1,NULL,NULL,0,0,0,0,NULL,1538603804088,1538603804124,13454
0.6.0.273,14190,14190,bt54,-1,NULL,NULL,0,0,0,0,NULL,1537399659744,1537399659772,13454
0.6.0.272,14137,14137,bt54,-1,NULL,NULL,0,0,0,0,NULL,1537226298143,1537226298225,13454
0.6.0.271,14126,14126,bt54,-1,NULL,NULL,0,0,0,0,NULL,1537214982444,1537214982478,13454
0.6.0.270,14097,14097,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536987101646,1536987101689,13454
0.6.0.269,14090,14090,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536965921601,1536965921631,13454
0.6.0.268,14052,14052,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536890664057,1536890664085,13454
0.6.0.267,14032,14032,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536865714902,1536865714932,13454
0.6.0.266,14028,14028,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536858000684,1536858000715,13454
0.6.0.7,14024,14024,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536848055121,1536848055158,13454
0.6.0.6,14019,14019,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536812977497,1536812977527,13454
0.6.0.5,14017,14017,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536811430234,1536811430259,13454
0.6.0.4,13998,13998,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536788868733,1536788868766,13454
0.6.0.3,13990,13990,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536775845582,1536775845613,13454
0.6.0.2,13989,13989,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536775667213,1536775667243,13454
0.6.0.1,13988,13988,bt54,-1,NULL,NULL,0,0,0,0,NULL,1536771648422,1536771700290,13454
(43 row(s) affected)
Ok, I see. You should set chain_modification_id for these builds to 13454. It should fix the problem.
So not '-1'. The script would be:
update build_state set modification_id = -1, chain_modification_id = 13454 where build_type_id = 'bt54' and id >= 16177 and id <= 18822
Does that look correct? The other 4 builds all had '-1' for all of the builds.
Jim
Yes, this is correct.