Fix joins against the same table when not necessary

Let's take a GraphQL query:
query {
  findManyUser(where: { firstName: "Face" })
  {
    firstName
    lastName
    posts { id }
  }
}

This leads to two queries in query-engine:
SELECT
    "sql_load_test"."User"."firstName",
    "sql_load_test"."User"."lastName",
    "sql_load_test"."User"."id"
FROM
    "sql_load_test"."User"
WHERE "sql_load_test"."User"."firstName" = 'Face'
ORDER BY "sql_load_test"."User"."id" ASC;

This one is merely a 24ms query, which is already quite slow, but nothing compared to the following:
SELECT
    "sql_load_test"."Post"."id",
    "RelationTable"."id" AS "__RelatedModel__",
    "RelationTable"."author" AS "__ParentModel__"
FROM
    "sql_load_test"."Post"
INNER JOIN "sql_load_test"."Post" AS "RelationTable" ON "sql_load_test"."Post"."id" = "RelationTable"."id"
WHERE (("RelationTable"."author" IN (1,675,917,1494,3128,3219,3645,3984,4658,6766,8014,8598,8719,9114,9365,9876,10281,10499,11858,12399,13499,13831,13968,14370,14754,15138,15140,15861,15896,16589,16626,16804,16867,18817,19684,19780,19914,20545,20647,20926,21531,22406,24258,24625,26738,27016,27203,28583,32909,33559,33638,34349,34943,36564,36648,37009,37061,37184,37374,38326,39730,39861,41302,43395,44030,44037,44673,45298,45524,46300,47702,47748,49337,55260,57094,57771,58402,58489,58775,59041,59531,60670,61578,65303,66039,66149,66460,68329,68496,68621,69465,69659,71399,71503,71780,72900,73014,73200,73735,74959,74989,75309,76209,76925,77487,77517,78819,79912,80366,80554,81693,82285,82455,83202,83396,83531,84272,86180,87026,88696,90352,91595,92006,92899,94154,95441,96672,97534,97570,98025,99459,100308,101241,102056,102106,102985,106467,106765,107043,108679,111376,113372,114890,115961,117177,118662,121921,122597,122869,123943,124753,125448,126847,127840,131620,135129,135839,135968,136313,136783,136903,137231,137261,138095,138135,140111,141094,141522,141558,142581,143147,143252,143693,146030,146238,146590,148223,150279,152542,153248,154566,155541,158745,160794,160954,160982,164941,165886,166337,166398,166990,167718,168611,171275,172451,172675,173154,174544,176011,176568,176745,177855,178046,178927,180834,181414,181649,181687,185247,185651,188034,188281,189052,189067,189494,192726,192965,193618,194082,194102,196321,200842,204012,204026,206658,207333,208721,209396,210520,215549,216683,220716,221794,221961,222690,224381,226940,227862,228963,229871,230833,232503,232965,233520,235124,235199,235869,236456,238462,238731,239786,239874,243040,246046,247089,247207,248808,248827,250158,250467,251266,251703,254690,257960,258963,259957,260147,261309,261488,261912,262083,263384,264205,264436,264858,265425,266890,267532,269591,270070,271159,271786,272588,274291,274591,274765,276797,279526,280244,283108,284852,285358,286057,286789,287259,288251,288631,289926,290712,292004,292267,292608,293575,294875,295462,295627,296478,296757,298099,298256,299737,300768,301963,302356,304902,305101,305157,306300,308773,311362,311693,313103,315654,316120,317325,317703,318243,318535,319074,319678,322317,323966,324913,325920,328616,329638,330365,331029,331273,331578,331862,332980,334497,336229,336822,336857,337209,338241,338748,339394,339441,339764,339854,341121,341278,341632,341674,341886,343031,345193,345670,348059,348539,348675,348811,348898,353092,353324,355821,356557,356864,356951,360590,360713,361437,363016,363456,363930,365932,366231,366927,367674,369401,370100,371113,371237,374255,374271,374753,375428,376132,376579,376647,377028,378226,378895,379104,379901,379965,380268,380326,381906,381909,382368,384503,385324,385588,385701,387667,392187,392646,395766,396498,396505,397017,397254,397834,398336,398618,398876,400791,401730,401987,402973,405483,406627,407340,408074,408478,410446,410646,410893,412590,413299,414506,414556,416515,417064,417464,417475,418093,418443,418818,418983,419514,421097,421694,422210,422872,423287,424112,425851,426066,428760,430129,430754,430797,431942,432368,433249,434751,435913,436285,439123,439730,441031,442138,442300,443341,444393,444559,444642,444699,445252,445829,446288,447616,448088,450491,452934,452981,453578,453887,453905,455787,456555,457459,458664,459697,461520,462024,462036,462807,463901,466204,467306,467711,468324,471276,472885,473448,473625,474767,476228,478112,478581,479977,480841,481986,482917,484680,486045,487356,490318,491135,491199,491462,491693,491940,492599,492867,496983,498249,498259,498646,499478,499566,501664,501734,502635,503056,503825,503842,504835,505358,505515,506427,506513,506837,509324,509765,511315,512419,512564,512692,512925,513958,517331,518778,519538,520191,520585,520652,521212,523313,524079,525009,526497,527072,531403,533741,536735,536992,537291,539070,539072,539124,542431,544217,545682,546680,547401,548296,550300,550324,551142,551198,551945,552152,554330,555059,557778,559538,559912,561026,561836,562262,562276,562673,563421,564007,564193,565883,566791,567894,571168,571811,572825,573371,574000,574017,574108,574253,574267,575064,577962,578268,579199,579504,579779,579954,581400,582508,583109,583254,585607,585811,586746,587240,588373,589424,589632,589752,590664,590744,591172,591374,591544,591691,591947,592904,594750,595457,596326,596707,597552,600560,600985,602773,602816,603478,605556,606381,608214,608421,609437,613173,616483,616910,617231,617459,619209,620419,620538,621377,622538,622895,623847,625586,626046,626801,627675,628875,629335,630517,630820,630845,631181,631885,634493,634836,635872,637136,637842,640198,642698,642910,644902,646886,647480,647883,648642,649361,649791,650060,651412,654773,655680,659386,661277,661706,663078,663585,664193,664311,670033,671890,672007,672826,673842,674043,676625,676899,677354,678084,678728,681599,682315,682357,683106,683765,683839,684467,685720,686532,687303,687530,687670,687781,687856,688095,688707,690062,697085,697840,698163,698515,698626,699387,699774,700313,700828,701453,701775,702533,703958,704847,705836,706022,706811,709063,709157,710758,710966,712638,712670,712768,713050,715493,715756,716718,719524,719661,719909,720310,720808,721107,722120,722763,723913,724543,726487,727266,728666,729487,729537,731502,732617,733386,734502,735273,735814,736840,738426,738514,741729,742497,744297,749134,749839,750748,751990,753626,753701,754706,756000,756369,756910,758937,759889,760033,760063,760215,762734,763940,766511,766641,766792,769167,772950,772983,773591,778937,780894,781809,782035,782217,782798,782983,783069,783609,785380,785549,785554,785555,787269,787414,787921,789400,789543,790341,790444,792167,792448,793603,793724,794842,795948,796022,796539,800123,800689,802159,803271,803503,803711,805360,805544,805665,805965,806196,807103,807589,807921,808098,811322,811610,812563,812666,814000,816663,818249,819184,819842,821376,821864,824099,827394,827521,828053,828539,833589,833620,834433,835078,835352,837997,841110,841266,841567,841594,843059,845136,845612,846045,849809,850167,850282,850473,850629,851492,851803,852037,852864,854457,856698,857122,857435,857938,858432,859964,860349,860477,862837,864426,865911,866387,867484,867997,868705,869809,869848,870659,870973,871499,872311,873392,873455,878957,879355,881036,882399,882453,883075,883090,884024,884670,885276,886162,886589,886902,887161,887226,887290,890701,894302,895654,903000,904091,905738,906323,907244,907964,908147,908208,908461,908780,908928,912357,912619,914138,914455,915551,916897,916934,918999,919241,919485,920985,923149,923199,923295,924098,924442,925211,925930,926384,926739,927393,928633,931868,934931,935192,935207,935807,936450,939984,940337,947383,947574,948130,948392,948668,949240,949450,950575,952437,954444,954648,954654,954732,955767,956174,956638,956910,957719,961418,961485,961985,963236,965725,967031,967702,967781,968248,970795,971281,971521,971605,972567,973381,975116,976915,979240,982023,984832,987251,987596,987971,989414,991054,992010,992228,992693,994292,995118,996714,996784,996803,996833,997196,997555,999253,1000157,1000198,1001530,1002462,1003045,1003200,1003787,1005510,1006016,1006400,1006783,1007037,1007082,1008634,1009335,1009396,1010536,1011406,1011478,1011747,1012462,1014933,1015221,1017021,1017953,1018058,1018229,1018984,1019683,1020292,1020734,1022426,1025713,1026419,1028268,1028844,1029691,1031284,1032894,1034830,1036254,1036683,1037165,1037462,1037773,1038377,1039232,1040041,1040126,1040776,1041017,1042022,1042273,1042641,1043668,1043680,1046066,1047616,1048869,1049596,1050261,1050288,1050500,1051211,1053400,1054690,1056116,1057331,1058781,1058846,1060490,1060795,1061147,1061374,1061709,1061839,1063367,1063997,1066908,1067429,1067657,1067773,1068290,1071120,1071255,1071842,1072420,1072670,1073643,1079698,1080420,1081677,1082964,1084740,1090225,1090624,1092265,1092495,1098478,1099709,1099786,1100042,1101982,1103861,1105172,1106043,1107273,1107567,1111456,1111506,1112311,1112370,1112438,1113553,1113898,1113955,1114122,1115033,1117436,1119773,1120656,1122312,1123362,1123991,1124633,1125016,1125028,1125033,1125393,1125456,1125770,1126256,1126791,1128584,1128658,1129761,1130434,1130753,1131408,1131840,1132476,1133930,1134621,1135255,1138488,1140655,1141269,1141694,1145486,1146193,1146914,1147995,1148023,1148223,1148603,1148853,1149078,1150627,1150832,1152379,1153081,1153633,1159085,1159184,1160104,1160419,1160659,1162289,1163804,1164904,1165010,1165510,1166790,1168315,1168500,1170845,1171820,1172172,1172504,1174143,1174988,1176660,1177669,1179370,1180798,1181335,1182551,1184293,1184719,1187087,1190244,1190542,1191841,1194947,1195610,1196509,1201865,1202123,1202964,1203398,1204001,1205102,1205181,1205862,1207897,1209783,1209960,1210891,1211650,1211823,1212005,1212860,1213315,1213682,1213796,1214320,1214939,1215249,1216269,1217746,1219004,1219182,1219234,1219870,1220046,1220818,1220912,1222340,1222814,1222853,1223154,1224123,1225973,1226741,1227414,1228867,1229174,1230636,1232420,1233251,1236114,1236998,1237687,1239054,1239773,1240120,1240626,1242202,1243069,1244183,1244381,1245086,1247327,1249044,1249995,1250315,1250367,1250384,1253901,1256836,1257292,1257526,1258007,1258261,1258699,1259799,1259972,1260086,1261313,1261332,1261848,1262717,1262798,1263619,1263961,1264063,1264270,1265076,1265555,1266624,1266942,1268959,1270248,1271105,1273531,1273768,1275942,1275972,1279011,1281531,1282763,1283528,1283709,1285102,1286415,1288346,1289105,1290340,1291364,1292451,1294565,1299689,1300147,1300321,1300534,1300914,1301953,1302045,1304189,1304646,1304877,1307910,1308712,1311589,1315698,1316296,1316980,1319182,1319976,1320289,1320403,1320508,1320550,1320825,1323109,1325831,1325951,1326798,1327180,1327437,1327820,1328937,1330808,1331663,1331901,1333010,1333051,1335878,1337038,1337228,1337900,1339053,1339336,1340428,1341029,1341585,1342208,1342556,1349054,1350320,1350661,1351640,1353070,1353384,1353996,1354089,1355509,1355885,1357057,1358192,1359271,1364675,1365151,1365859,1368332,1369205,1370250,1370994,1371028,1371167,1371959,1372043,1372145,1372703,1373854,1375475,1376174,1376328,1376799,1376987,1377350,1380508,1380794,1381706,1382478,1383189,1384416,1385421,1388147,1390474,1394555,1397515,1398054,1398117,1398671,1400726,1404421,1404608,1404766,1404899,1405785,1406134,1406735,1406890,1407391,1407975,1408059,1408830,1408985,1409540,1409767,1410322,1410390,1411148,1411166,1411705,1413456,1414504,1415148,1415341,1417195,1418670,1420941,1421504,1422302,1422455,1423044,1423165,1427014,1429005,1433317,1433789,1433975,1435773,1437485,1438761,1440260,1440762,1441649,1442065,1442498,1443856,1444596,1445393,1445703,1446701,1448348,1449791,1450236,1450561,1450623,1450925,1452087,1452206,1452290,1452336,1452523,1452649,1452963,1453111,1453136,1453957,1454251,1454258,1454267,1456170,1456886,1457962,1460576,1461463,1462684,1464037,1464222,1464457,1467579,1468693,1468872,1470828,1471335,1471352,1472188,1472375,1474295,1474460,1475616,1476050,1477418,1478521,1480493,1480495,1481321,1481561,1484990,1485598,1488034,1489212,1490281,1490440,1490744,1491400,1491905,1495508,1496286,1497256,1498773,1499555,1499765,1501960,1503252,1506281,1506802,1507100,1507370,1508027,1510350,1511061,1511816,1512729,1512733,1512876,1512969,1513000,1513428,1513755,1515393,1515510,1515722,1515942,1518537,1519530,1519944,1520272,1522068,1522241,1522706,1523837,1523924,1524318,1524345,1524353,1526300,1528448,1528698,1529193,1529262,1529591,1532343,1532728,1532969,1533231,1533636,1533641,1533660,1535937,1536469,1536796,1539280,1539590,1539752,1543354,1543544,1545554,1546855,1547858,1547862,1550004,1550104,1550454,1550517,1551473,1552653,1554385,1554612,1555717,1556626,1556799,1557538,1559579,1560283,1560303,1560538,1561263,1562603,1563292,1565558,1565683,1567777,1568347,1568488,1570612,1571268,1573380,1573487,1575803,1575973,1576180,1576444,1577342,1578629,1579242,1580381,1580423,1582841,1583530,1585731,1585946,1586162,1586360,1589178,1589449,1591155,1591344,1592144,1594145,1594418,1595070,1596398,1597223,1598134,1598916,1599784,1601176,1601233,1601408,1603597,1604329,1604433,1604674,1604786,1604998,1605618,1606220,1606288,1611454,1611916,1611938,1612239,1612326,1612449,1616273,1617637,1617945,1618601,1618818,1619247,1620741,1626561,1627451,1628387,1629314,1631448,1631527,1633966,1634609,1637212,1637696,1637948,1639481,1639510,1639850,1639907,1640742,1645875,1647670,1648925,1650185,1651852,1654636,1654732,1655121,1658124,1658460,1659513,1662052,1662129,1662222,1662625,1662748,1665995,1666013,1667424,1668345,1669032,1669588,1670154,1671236,1671457,1671829,1673538,1674251,1674553,1674783,1675295,1677123,1677809,1678253,1678972,1679423,1679605,1679675,1681835,1682403,1683132,1683611,1684321,1684778,1685476,1688773,1691678,1692196,1693130,1693209,1694202,1694510,1695163,1695662,1696201,1698679,1698927,1698988,1699767,1701192,1701687,1702560,1704276,1706101,1707348,1708472,1709509,1713601,1714362,1715175,1715600,1718991,1719525,1720759,1724500,1724987,1725396,1727665,1727998,1730043,1730500,1730798,1731604,1732359,1732709,1737243,1737683,1738368,1742159,1742575,1742939,1743741,1743767,1745353,1746548,1747782,1747867,1748779,1749745,1749775,1750190,1750237,1750812,1751024,1751039,1751243,1751615,1752923,1756749,1759185,1759539,1760093,1760474,1760873,1762112,1763277,1763978,1765218,1766914,1767003,1769215,1769296,1773194,1774072,1774870,1775335,1776013,1776925,1779522,1780780,1783444,1783834,1784911,1785542,1785616,1785870,1786350,1788123,1788165,1790095,1791101,1792842,1793698,1794070,1797220,1797659,1798313,1799790,1799883,1801710,1804221,1804733,1806106,1807725,1807910,1808126,1808405,1808608,1811047,1812205,1812341,1816312,1816449,1818247,1818557,1820545,1820917,1821288,1821739,1821877,1823207,1824440,1825511,1827290,1828019,1831137,1831647,1832826,1833859,1836214,1837389,1837543,1837840,1837897,1839258,1841699,1841926,1844176,1845520,1846446,1847894,1848056,1849301,1849617,1849778,1850311,1853860,1854375,1854413,1855688,1858615,1858747,1859659,1860540,1861553,1862404,1862738,1863168,1865262,1865908,1866140,1866345,1869157,1870214,1871020,1872798,1873037,1874425,1874727,1875604,1875759,1876906,1880036,1880617,1882258,1882895,1883017,1883244,1883279,1885230,1885879,1888530,1888772,1889683,1891238,1891265,1891693,1893101,1895818,1897917,1900896,1901448,1901659,1901861,1902725,1904570,1904745,1905873,1907298,1907306,1907664,1908461,1909827,1911339,1914576,1915343,1916857,1917424,1918289,1919112,1919641,1921974,1922220,1922752,1924372,1924631,1926261,1926282,1926514,1926702,1928621,1928948,1929530,1929794,1930970,1932176,1932236,1937053,1938711,1939238,1940441,1941750,1942724,1942737,1943367,1944231,1944409,1944694,1947082,1947381,1947970,1948222,1948419,1948649,1951592,1956442,1959607,1959837,1960611,1961034,1961623,1961673,1963032,1963642,1964786,1965284,1966039,1966689,1968471,1968599,1969121,1969665,1970080,1970848,1972837,1974585,1975291,1975878,1977361,1979289,1980532,1985051,1985328,1985466,1988144,1989866,1990480,1992122,1992200,1993996,1994136,1994191,1995354,1995578,1995824,1999084,2000914,2003771,2003973,2005037,2005619,2005991,2006551,2007710,2008035,2015622,2016554,2016886,2017321,2018457,2018949,2020300,2021311,2021389,2021699,2022121,2022150,2022252,2022304,2022829,2023150,2023824,2025217,2026029,2026092,2027193,2027838,2028928,2029030,2029209,2029444,2029568,2030799,2034161,2034817,2036750,2040660,2041214,2041411,2041680,2041684,2041736,2041775,2042083,2043880,2044880,2045476,2046546,2048970,2051990,2052238,2053523,2056375,2057028,2058506,2062575,2063886,2067037,2067549,2070080,2070328,2072246,2074470,2074698,2075090,2076201,2078334,2078824,2079900,2079990,2080538,2080641,2082432,2083015,2083804,2083833,2084318,2088811,2088883,2089005,2089039,2090486,2090516,2090767,2091919,2091989,2092724,2093883,2094258,2095429,2098954,2099697,2103114,2103446,2104057,2106199,2107345,2108308,2109108,2109337,2109602,2110550,2110780,2111326,2111909,2114258,2114567,2115740,2115838,2116269,2117733,2118236,2118446,2120454,2121765,2122361,2122398,2124430,2124895,2125663,2127851,2128451,2128972,2132483,2133591,2134102,2138792,2139241,2139953,2140661,2142474,2143034,2143506,2145705,2146544,2146764,2146996,2147218,2148553,2150784,2151429,2151577,2151993,2155204,2156056,2156269,2157050,2157646,2157743,2158545,2160633,2161386,2161983,2163691,2165553,2167063,2169535,2170683,2171846,2172005,2175640,2176926,2177546,2178499,2178687,2178837,2181237,2181944,2183981,2186059,2186405,2186857,2187945,2191640,2191816,2192948,2194124,2194894,2195905,2196956,2197436,2197915,2200987,2201205,2204066,2206889,2207469,2208271,2208359,2208590,2208736,2209846,2209922,2210996,2211425,2212057,2212927,2213916,2214728,2215031,2215146,2215321,2215678,2215851,2217706,2218489,2219587,2219603,2220050,2220915,2220925,2221948,2222707,2223460,2224804,2225546,2226117,2228143,2230405,2230669,2234485,2235062,2235342,2236826,2238182,2240171,2242099,2243349,2245776,2246282,2246890,2247202,2249906,2250291,2250639,2251157,2251338,2254883,2255454,2257144,2257667,2257764,2261605,2261773,2262330,2264607,2264692,2267276,2268469,2274810,2275224,2275539,2277294,2277450,2279068,2279618,2280558,2280698,2282891,2285787,2286938,2288587,2288986,2289936,2291077,2291666,2292028,2293068,2295003,2296538,2296568,2297346,2297479,2297753,2297789,2299294,2300465,2301129,2301619,2302830,2306185,2306878,2307427,2307445,2309890,2310772,2310830,2311378,2312603,2313796,2313967,2314699,2317023,2317343,2318768,2319469,2320504,2320619,2321110,2321696,2325380,2325562,2326774,2327666,2327698,2330066,2332962,2333428,2333552,2333955,2334483,2336416,2336453,2337401,2337454,2337481,2338393,2341433,2341994,2342471,2343235,2344251,2344939,2345255,2346018,2346744,2348577,2349256,2352642,2353105,2353934,2354862,2356844,2356878,2359693,2361150,2362812,2366879,2367254,2368546,2370044,2370539,2371504,2371990,2372791,2373004,2373216,2373385,2373476,2373521,2374423,2375686,2377541,2377628,2379654,2380826,2382047,2385007,2385584,2385730,2386000,2386334,2386808,2387175,2389017,2389329,2390020,2390568,2391303,2391398,2392441,2394377,2394544,2395387,2396166,2396330,2397321,2399016,2399549,2399976,2402417,2402786,2402795,2402808,2403885,2404090,2406734,2408173,2408944,2409600,2410037,2411759,2412153,2412485,2412594,2412619,2413226,2414006,2414255,2415677,2416177,2416577,2417115,2417634,2418232,2418836,2423330,2423522,2424172,2424193,2426524,2426907,2427560,2427723,2430844,2432269,2434774,2435227,2439191,2443586,2444785,2445172,2445553,2446903,2447329,2448709,2448845,2448925,2449517,2449922,2450567,2450803,2451329,2451778,2452329,2452560,2453894,2455051,2455831,2456236,2456563,2457121,2458338,2459277,2459733,2460062,2460900,2461252,2461324,2464062,2465407,2466209,2466301,2467306,2467307,2468352,2469344,2472442,2473482,2476542,2478468,2478520,2479229,2480576,2481407,2482353,2482515,2483057,2485130,2485563,2486337,2488436,2488960,2490290,2492688,2492882,2493100,2495763,2497021,2497736,2498506,2499417,2500374,2500688,2501736,2503349,2503360,2503493,2506168,2506476,2506950,2506953,2507523,2507725,2508078,2508218,2508273,2510624,2510710,2511857,2513187,2514537,2518447,2518805,2520355,2520857,2520945,2523023,2523873,2524319,2525719,2527106,2528386,2529417,2529711,2529895,2530590,2531072,2532255,2534191,2534194,2534709,2536307,2539697,2540233,2540866,2541696,2542367,2542556,2543062,2545930,2546428,2548705,2550316,2550371,2550988,2556475,2556578,2558606,2559588,2563590,2564573,2565412,2565860,2569357,2569647,2571020,2571720,2573513,2573831,2575169,2575306,2577620,2579740,2580023,2580726,2582603,2582721,2584536,2584820,2585546,2586325,2587123,2588277,2589601,2589793,2589955,2590423,2590888,2591084,2591581,2593043,2593953,2594716,2595210,2595498,2595590,2595835,2596704,2598185,2598645,2599062,2599246,2601146,2602945,2603182,2606124,2608245,2608471,2608495,2608803,2610305,2610374,2610678,2610912,2610915,2611305,2611326,2611601,2613345,2613627,2613829,2616149,2617070,2617590,2618881,2618887,2620290,2621186,2621797,2622808,2623750,2624141,2624989,2625590,2626028,2626133,2626378,2626493,2626650,2627359,2627879,2628711,2629766,2629816,2630236,2633786,2634344,2635177,2635912,2639414,2640646,2640967,2641219,2642951,2643179,2643890,2645924,2646395,2648200,2648856,2649833,2650609,2651084,2653270,2655644,2657141,2658284,2659926,2660758,2661578,2661866,2663647,2664854,2664932,2665799,2667775,2669551,2671542,2672533,2672703,2674736,2675200,2678052,2679431,2680778,2682063,2682604,2683479,2684448,2685723,2686429,2687806,2689571,2690486,2691252,2692332,2692352,2695176,2695761,2695979,2697279,2699152,2699179,2699890,2699962,2700394,2700455,2700621,2701006,2701084,2701133,2701720,2701903,2702141,2702401,2702459,2704078,2704289,2707358,2709251,2711307,2712256,2712590,2713870,2714465,2715541,2715952,2717379,2719122,2720328,2721559,2722853,2723144,2724266,2724323,2725724,2726065,2727346,2731968,2732847,2734565,2738067,2738326,2738945,2739165,2739470,2739575,2739828,2740728,2741506,2743912,2744871,2745879,2746008,2746367,2748417,2749345,2749514,2752163,2754070,2755377,2756630,2758499,2758905,2760170,2761325,2761891,2762913,2764010,2764426,2765348,2768398,2768442,2770501,2770850,2771549,2771810,2775021,2775226,2776394,2776482,2778142,2778203,2779046,2779092,2779889,2780198,2781425,2781710,2781978,2783014,2783365,2783417,2783946,2786834,2789095,2789685,2789725,2789915,2790381,2790784,2791146,2791227,2792006,2792076,2792588,2792676,2792919,2793212,2793603,2793919,2794086,2794346,2794980,2796288,2796340,2796473,2796524,2796563,2798123,2798274,2798737,2799870,2801371,2801564,2802026,2803787,2805533,2807147,2807303,2809215,2812184,2812308,2812662,2812713,2815106,2816091,2816204,2816426,2817351,2817898,2818165,2819417,2820362,2820848,2821586,2821832,2822547,2823894,2825116,2825160,2825403,2826071,2827276,2827412,2828381,2828446,2828473,2828751,2828883,2832222,2833391,2834428,2834754,2835303,2836453,2837934,2838491,2840022,2841196,2844529,2845346,2845376,2848647,2848999,2849060,2851177,2851396,2853002,2853398,2854750,2855330,2855672,2856204,2856466,2857143,2858284,2858720,2858775,2859524,2860779,2861144,2862564,2862764,2862804,2865720,2866206,2867298,2868118,2868257,2870379,2870385,2871502,2871677,2872124,2872597,2875238,2876440,2878391,2878429,2878890,2880265,2880796,2881364,2881676,2884387,2885249,2885495,2887880,2888106,2888633,2891706,2892711,2894831,2894895,2895234,2895391,2895504,2899178,2899289,2899616,2899874,2900463,2901215,2901458,2902606,2903691,2903815,2904140,2905217,2907088,2907355,2907431,2908820,2909612,2910101,2910937,2910942,2914905,2914913,2915023,2915815,2916361,2916673,2917005,2920244,2920304,2920600,2922775,2924818,2926128,2928457,2929308,2930077,2930629,2932236,2932391,2932517,2932711,2932803,2933924,2935146,2937284,2939696,2940379,2940810,2941550,2941914,2943883,2944214,2946322,2946614,2946898,2947246,2950704,2951173,2952677,2952703,2953487,2954048,2956823,2958219,2958515,2959561,2961746,2962443,2962502,2963452,2964119,2964735,2965624,2967672,2970397,2971871,2972273,2976119,2977184,2977860,2978585,2978780,2980532,2980946,2981004,2981114,2981122,2981609,2982542,2983820,2983860,2984224,2984646,2984771,2985284,2986298,2987681,2988035,2988703,2989074,2989381,2989867,2990906,2993633,2995133) AND 1=1) AND 1=1) ORDER BY "RelationTable"."id" ASC;

Taking whopping 300ms to execute.
Now we don't need to join with the same table to get the same results, using a bit faster but still monstrous query:
SELECT
    "sql_load_test"."Post"."id",
    "sql_load_test"."Post"."author" AS "__ParentModel__"
FROM
    "sql_load_test"."Post"
WHERE "sql_load_test"."Post"."author" IN (1,675,917,1494,3128,3219,3645,3984,4658,6766,8014,8598,8719,9114,9365,9876,10281,10499,11858,12399,13499,13831,13968,14370,14754,15138,15140,15861,15896,16589,16626,16804,16867,18817,19684,19780,19914,20545,20647,20926,21531,22406,24258,24625,26738,27016,27203,28583,32909,33559,33638,34349,34943,36564,36648,37009,37061,37184,37374,38326,39730,39861,41302,43395,44030,44037,44673,45298,45524,46300,47702,47748,49337,55260,57094,57771,58402,58489,58775,59041,59531,60670,61578,65303,66039,66149,66460,68329,68496,68621,69465,69659,71399,71503,71780,72900,73014,73200,73735,74959,74989,75309,76209,76925,77487,77517,78819,79912,80366,80554,81693,82285,82455,83202,83396,83531,84272,86180,87026,88696,90352,91595,92006,92899,94154,95441,96672,97534,97570,98025,99459,100308,101241,102056,102106,102985,106467,106765,107043,108679,111376,113372,114890,115961,117177,118662,121921,122597,122869,123943,124753,125448,126847,127840,131620,135129,135839,135968,136313,136783,136903,137231,137261,138095,138135,140111,141094,141522,141558,142581,143147,143252,143693,146030,146238,146590,148223,150279,152542,153248,154566,155541,158745,160794,160954,160982,164941,165886,166337,166398,166990,167718,168611,171275,172451,172675,173154,174544,176011,176568,176745,177855,178046,178927,180834,181414,181649,181687,185247,185651,188034,188281,189052,189067,189494,192726,192965,193618,194082,194102,196321,200842,204012,204026,206658,207333,208721,209396,210520,215549,216683,220716,221794,221961,222690,224381,226940,227862,228963,229871,230833,232503,232965,233520,235124,235199,235869,236456,238462,238731,239786,239874,243040,246046,247089,247207,248808,248827,250158,250467,251266,251703,254690,257960,258963,259957,260147,261309,261488,261912,262083,263384,264205,264436,264858,265425,266890,267532,269591,270070,271159,271786,272588,274291,274591,274765,276797,279526,280244,283108,284852,285358,286057,286789,287259,288251,288631,289926,290712,292004,292267,292608,293575,294875,295462,295627,296478,296757,298099,298256,299737,300768,301963,302356,304902,305101,305157,306300,308773,311362,311693,313103,315654,316120,317325,317703,318243,318535,319074,319678,322317,323966,324913,325920,328616,329638,330365,331029,331273,331578,331862,332980,334497,336229,336822,336857,337209,338241,338748,339394,339441,339764,339854,341121,341278,341632,341674,341886,343031,345193,345670,348059,348539,348675,348811,348898,353092,353324,355821,356557,356864,356951,360590,360713,361437,363016,363456,363930,365932,366231,366927,367674,369401,370100,371113,371237,374255,374271,374753,375428,376132,376579,376647,377028,378226,378895,379104,379901,379965,380268,380326,381906,381909,382368,384503,385324,385588,385701,387667,392187,392646,395766,396498,396505,397017,397254,397834,398336,398618,398876,400791,401730,401987,402973,405483,406627,407340,408074,408478,410446,410646,410893,412590,413299,414506,414556,416515,417064,417464,417475,418093,418443,418818,418983,419514,421097,421694,422210,422872,423287,424112,425851,426066,428760,430129,430754,430797,431942,432368,433249,434751,435913,436285,439123,439730,441031,442138,442300,443341,444393,444559,444642,444699,445252,445829,446288,447616,448088,450491,452934,452981,453578,453887,453905,455787,456555,457459,458664,459697,461520,462024,462036,462807,463901,466204,467306,467711,468324,471276,472885,473448,473625,474767,476228,478112,478581,479977,480841,481986,482917,484680,486045,487356,490318,491135,491199,491462,491693,491940,492599,492867,496983,498249,498259,498646,499478,499566,501664,501734,502635,503056,503825,503842,504835,505358,505515,506427,506513,506837,509324,509765,511315,512419,512564,512692,512925,513958,517331,518778,519538,520191,520585,520652,521212,523313,524079,525009,526497,527072,531403,533741,536735,536992,537291,539070,539072,539124,542431,544217,545682,546680,547401,548296,550300,550324,551142,551198,551945,552152,554330,555059,557778,559538,559912,561026,561836,562262,562276,562673,563421,564007,564193,565883,566791,567894,571168,571811,572825,573371,574000,574017,574108,574253,574267,575064,577962,578268,579199,579504,579779,579954,581400,582508,583109,583254,585607,585811,586746,587240,588373,589424,589632,589752,590664,590744,591172,591374,591544,591691,591947,592904,594750,595457,596326,596707,597552,600560,600985,602773,602816,603478,605556,606381,608214,608421,609437,613173,616483,616910,617231,617459,619209,620419,620538,621377,622538,622895,623847,625586,626046,626801,627675,628875,629335,630517,630820,630845,631181,631885,634493,634836,635872,637136,637842,640198,642698,642910,644902,646886,647480,647883,648642,649361,649791,650060,651412,654773,655680,659386,661277,661706,663078,663585,664193,664311,670033,671890,672007,672826,673842,674043,676625,676899,677354,678084,678728,681599,682315,682357,683106,683765,683839,684467,685720,686532,687303,687530,687670,687781,687856,688095,688707,690062,697085,697840,698163,698515,698626,699387,699774,700313,700828,701453,701775,702533,703958,704847,705836,706022,706811,709063,709157,710758,710966,712638,712670,712768,713050,715493,715756,716718,719524,719661,719909,720310,720808,721107,722120,722763,723913,724543,726487,727266,728666,729487,729537,731502,732617,733386,734502,735273,735814,736840,738426,738514,741729,742497,744297,749134,749839,750748,751990,753626,753701,754706,756000,756369,756910,758937,759889,760033,760063,760215,762734,763940,766511,766641,766792,769167,772950,772983,773591,778937,780894,781809,782035,782217,782798,782983,783069,783609,785380,785549,785554,785555,787269,787414,787921,789400,789543,790341,790444,792167,792448,793603,793724,794842,795948,796022,796539,800123,800689,802159,803271,803503,803711,805360,805544,805665,805965,806196,807103,807589,807921,808098,811322,811610,812563,812666,814000,816663,818249,819184,819842,821376,821864,824099,827394,827521,828053,828539,833589,833620,834433,835078,835352,837997,841110,841266,841567,841594,843059,845136,845612,846045,849809,850167,850282,850473,850629,851492,851803,852037,852864,854457,856698,857122,857435,857938,858432,859964,860349,860477,862837,864426,865911,866387,867484,867997,868705,869809,869848,870659,870973,871499,872311,873392,873455,878957,879355,881036,882399,882453,883075,883090,884024,884670,885276,886162,886589,886902,887161,887226,887290,890701,894302,895654,903000,904091,905738,906323,907244,907964,908147,908208,908461,908780,908928,912357,912619,914138,914455,915551,916897,916934,918999,919241,919485,920985,923149,923199,923295,924098,924442,925211,925930,926384,926739,927393,928633,931868,934931,935192,935207,935807,936450,939984,940337,947383,947574,948130,948392,948668,949240,949450,950575,952437,954444,954648,954654,954732,955767,956174,956638,956910,957719,961418,961485,961985,963236,965725,967031,967702,967781,968248,970795,971281,971521,971605,972567,973381,975116,976915,979240,982023,984832,987251,987596,987971,989414,991054,992010,992228,992693,994292,995118,996714,996784,996803,996833,997196,997555,999253,1000157,1000198,1001530,1002462,1003045,1003200,1003787,1005510,1006016,1006400,1006783,1007037,1007082,1008634,1009335,1009396,1010536,1011406,1011478,1011747,1012462,1014933,1015221,1017021,1017953,1018058,1018229,1018984,1019683,1020292,1020734,1022426,1025713,1026419,1028268,1028844,1029691,1031284,1032894,1034830,1036254,1036683,1037165,1037462,1037773,1038377,1039232,1040041,1040126,1040776,1041017,1042022,1042273,1042641,1043668,1043680,1046066,1047616,1048869,1049596,1050261,1050288,1050500,1051211,1053400,1054690,1056116,1057331,1058781,1058846,1060490,1060795,1061147,1061374,1061709,1061839,1063367,1063997,1066908,1067429,1067657,1067773,1068290,1071120,1071255,1071842,1072420,1072670,1073643,1079698,1080420,1081677,1082964,1084740,1090225,1090624,1092265,1092495,1098478,1099709,1099786,1100042,1101982,1103861,1105172,1106043,1107273,1107567,1111456,1111506,1112311,1112370,1112438,1113553,1113898,1113955,1114122,1115033,1117436,1119773,1120656,1122312,1123362,1123991,1124633,1125016,1125028,1125033,1125393,1125456,1125770,1126256,1126791,1128584,1128658,1129761,1130434,1130753,1131408,1131840,1132476,1133930,1134621,1135255,1138488,1140655,1141269,1141694,1145486,1146193,1146914,1147995,1148023,1148223,1148603,1148853,1149078,1150627,1150832,1152379,1153081,1153633,1159085,1159184,1160104,1160419,1160659,1162289,1163804,1164904,1165010,1165510,1166790,1168315,1168500,1170845,1171820,1172172,1172504,1174143,1174988,1176660,1177669,1179370,1180798,1181335,1182551,1184293,1184719,1187087,1190244,1190542,1191841,1194947,1195610,1196509,1201865,1202123,1202964,1203398,1204001,1205102,1205181,1205862,1207897,1209783,1209960,1210891,1211650,1211823,1212005,1212860,1213315,1213682,1213796,1214320,1214939,1215249,1216269,1217746,1219004,1219182,1219234,1219870,1220046,1220818,1220912,1222340,1222814,1222853,1223154,1224123,1225973,1226741,1227414,1228867,1229174,1230636,1232420,1233251,1236114,1236998,1237687,1239054,1239773,1240120,1240626,1242202,1243069,1244183,1244381,1245086,1247327,1249044,1249995,1250315,1250367,1250384,1253901,1256836,1257292,1257526,1258007,1258261,1258699,1259799,1259972,1260086,1261313,1261332,1261848,1262717,1262798,1263619,1263961,1264063,1264270,1265076,1265555,1266624,1266942,1268959,1270248,1271105,1273531,1273768,1275942,1275972,1279011,1281531,1282763,1283528,1283709,1285102,1286415,1288346,1289105,1290340,1291364,1292451,1294565,1299689,1300147,1300321,1300534,1300914,1301953,1302045,1304189,1304646,1304877,1307910,1308712,1311589,1315698,1316296,1316980,1319182,1319976,1320289,1320403,1320508,1320550,1320825,1323109,1325831,1325951,1326798,1327180,1327437,1327820,1328937,1330808,1331663,1331901,1333010,1333051,1335878,1337038,1337228,1337900,1339053,1339336,1340428,1341029,1341585,1342208,1342556,1349054,1350320,1350661,1351640,1353070,1353384,1353996,1354089,1355509,1355885,1357057,1358192,1359271,1364675,1365151,1365859,1368332,1369205,1370250,1370994,1371028,1371167,1371959,1372043,1372145,1372703,1373854,1375475,1376174,1376328,1376799,1376987,1377350,1380508,1380794,1381706,1382478,1383189,1384416,1385421,1388147,1390474,1394555,1397515,1398054,1398117,1398671,1400726,1404421,1404608,1404766,1404899,1405785,1406134,1406735,1406890,1407391,1407975,1408059,1408830,1408985,1409540,1409767,1410322,1410390,1411148,1411166,1411705,1413456,1414504,1415148,1415341,1417195,1418670,1420941,1421504,1422302,1422455,1423044,1423165,1427014,1429005,1433317,1433789,1433975,1435773,1437485,1438761,1440260,1440762,1441649,1442065,1442498,1443856,1444596,1445393,1445703,1446701,1448348,1449791,1450236,1450561,1450623,1450925,1452087,1452206,1452290,1452336,1452523,1452649,1452963,1453111,1453136,1453957,1454251,1454258,1454267,1456170,1456886,1457962,1460576,1461463,1462684,1464037,1464222,1464457,1467579,1468693,1468872,1470828,1471335,1471352,1472188,1472375,1474295,1474460,1475616,1476050,1477418,1478521,1480493,1480495,1481321,1481561,1484990,1485598,1488034,1489212,1490281,1490440,1490744,1491400,1491905,1495508,1496286,1497256,1498773,1499555,1499765,1501960,1503252,1506281,1506802,1507100,1507370,1508027,1510350,1511061,1511816,1512729,1512733,1512876,1512969,1513000,1513428,1513755,1515393,1515510,1515722,1515942,1518537,1519530,1519944,1520272,1522068,1522241,1522706,1523837,1523924,1524318,1524345,1524353,1526300,1528448,1528698,1529193,1529262,1529591,1532343,1532728,1532969,1533231,1533636,1533641,1533660,1535937,1536469,1536796,1539280,1539590,1539752,1543354,1543544,1545554,1546855,1547858,1547862,1550004,1550104,1550454,1550517,1551473,1552653,1554385,1554612,1555717,1556626,1556799,1557538,1559579,1560283,1560303,1560538,1561263,1562603,1563292,1565558,1565683,1567777,1568347,1568488,1570612,1571268,1573380,1573487,1575803,1575973,1576180,1576444,1577342,1578629,1579242,1580381,1580423,1582841,1583530,1585731,1585946,1586162,1586360,1589178,1589449,1591155,1591344,1592144,1594145,1594418,1595070,1596398,1597223,1598134,1598916,1599784,1601176,1601233,1601408,1603597,1604329,1604433,1604674,1604786,1604998,1605618,1606220,1606288,1611454,1611916,1611938,1612239,1612326,1612449,1616273,1617637,1617945,1618601,1618818,1619247,1620741,1626561,1627451,1628387,1629314,1631448,1631527,1633966,1634609,1637212,1637696,1637948,1639481,1639510,1639850,1639907,1640742,1645875,1647670,1648925,1650185,1651852,1654636,1654732,1655121,1658124,1658460,1659513,1662052,1662129,1662222,1662625,1662748,1665995,1666013,1667424,1668345,1669032,1669588,1670154,1671236,1671457,1671829,1673538,1674251,1674553,1674783,1675295,1677123,1677809,1678253,1678972,1679423,1679605,1679675,1681835,1682403,1683132,1683611,1684321,1684778,1685476,1688773,1691678,1692196,1693130,1693209,1694202,1694510,1695163,1695662,1696201,1698679,1698927,1698988,1699767,1701192,1701687,1702560,1704276,1706101,1707348,1708472,1709509,1713601,1714362,1715175,1715600,1718991,1719525,1720759,1724500,1724987,1725396,1727665,1727998,1730043,1730500,1730798,1731604,1732359,1732709,1737243,1737683,1738368,1742159,1742575,1742939,1743741,1743767,1745353,1746548,1747782,1747867,1748779,1749745,1749775,1750190,1750237,1750812,1751024,1751039,1751243,1751615,1752923,1756749,1759185,1759539,1760093,1760474,1760873,1762112,1763277,1763978,1765218,1766914,1767003,1769215,1769296,1773194,1774072,1774870,1775335,1776013,1776925,1779522,1780780,1783444,1783834,1784911,1785542,1785616,1785870,1786350,1788123,1788165,1790095,1791101,1792842,1793698,1794070,1797220,1797659,1798313,1799790,1799883,1801710,1804221,1804733,1806106,1807725,1807910,1808126,1808405,1808608,1811047,1812205,1812341,1816312,1816449,1818247,1818557,1820545,1820917,1821288,1821739,1821877,1823207,1824440,1825511,1827290,1828019,1831137,1831647,1832826,1833859,1836214,1837389,1837543,1837840,1837897,1839258,1841699,1841926,1844176,1845520,1846446,1847894,1848056,1849301,1849617,1849778,1850311,1853860,1854375,1854413,1855688,1858615,1858747,1859659,1860540,1861553,1862404,1862738,1863168,1865262,1865908,1866140,1866345,1869157,1870214,1871020,1872798,1873037,1874425,1874727,1875604,1875759,1876906,1880036,1880617,1882258,1882895,1883017,1883244,1883279,1885230,1885879,1888530,1888772,1889683,1891238,1891265,1891693,1893101,1895818,1897917,1900896,1901448,1901659,1901861,1902725,1904570,1904745,1905873,1907298,1907306,1907664,1908461,1909827,1911339,1914576,1915343,1916857,1917424,1918289,1919112,1919641,1921974,1922220,1922752,1924372,1924631,1926261,1926282,1926514,1926702,1928621,1928948,1929530,1929794,1930970,1932176,1932236,1937053,1938711,1939238,1940441,1941750,1942724,1942737,1943367,1944231,1944409,1944694,1947082,1947381,1947970,1948222,1948419,1948649,1951592,1956442,1959607,1959837,1960611,1961034,1961623,1961673,1963032,1963642,1964786,1965284,1966039,1966689,1968471,1968599,1969121,1969665,1970080,1970848,1972837,1974585,1975291,1975878,1977361,1979289,1980532,1985051,1985328,1985466,1988144,1989866,1990480,1992122,1992200,1993996,1994136,1994191,1995354,1995578,1995824,1999084,2000914,2003771,2003973,2005037,2005619,2005991,2006551,2007710,2008035,2015622,2016554,2016886,2017321,2018457,2018949,2020300,2021311,2021389,2021699,2022121,2022150,2022252,2022304,2022829,2023150,2023824,2025217,2026029,2026092,2027193,2027838,2028928,2029030,2029209,2029444,2029568,2030799,2034161,2034817,2036750,2040660,2041214,2041411,2041680,2041684,2041736,2041775,2042083,2043880,2044880,2045476,2046546,2048970,2051990,2052238,2053523,2056375,2057028,2058506,2062575,2063886,2067037,2067549,2070080,2070328,2072246,2074470,2074698,2075090,2076201,2078334,2078824,2079900,2079990,2080538,2080641,2082432,2083015,2083804,2083833,2084318,2088811,2088883,2089005,2089039,2090486,2090516,2090767,2091919,2091989,2092724,2093883,2094258,2095429,2098954,2099697,2103114,2103446,2104057,2106199,2107345,2108308,2109108,2109337,2109602,2110550,2110780,2111326,2111909,2114258,2114567,2115740,2115838,2116269,2117733,2118236,2118446,2120454,2121765,2122361,2122398,2124430,2124895,2125663,2127851,2128451,2128972,2132483,2133591,2134102,2138792,2139241,2139953,2140661,2142474,2143034,2143506,2145705,2146544,2146764,2146996,2147218,2148553,2150784,2151429,2151577,2151993,2155204,2156056,2156269,2157050,2157646,2157743,2158545,2160633,2161386,2161983,2163691,2165553,2167063,2169535,2170683,2171846,2172005,2175640,2176926,2177546,2178499,2178687,2178837,2181237,2181944,2183981,2186059,2186405,2186857,2187945,2191640,2191816,2192948,2194124,2194894,2195905,2196956,2197436,2197915,2200987,2201205,2204066,2206889,2207469,2208271,2208359,2208590,2208736,2209846,2209922,2210996,2211425,2212057,2212927,2213916,2214728,2215031,2215146,2215321,2215678,2215851,2217706,2218489,2219587,2219603,2220050,2220915,2220925,2221948,2222707,2223460,2224804,2225546,2226117,2228143,2230405,2230669,2234485,2235062,2235342,2236826,2238182,2240171,2242099,2243349,2245776,2246282,2246890,2247202,2249906,2250291,2250639,2251157,2251338,2254883,2255454,2257144,2257667,2257764,2261605,2261773,2262330,2264607,2264692,2267276,2268469,2274810,2275224,2275539,2277294,2277450,2279068,2279618,2280558,2280698,2282891,2285787,2286938,2288587,2288986,2289936,2291077,2291666,2292028,2293068,2295003,2296538,2296568,2297346,2297479,2297753,2297789,2299294,2300465,2301129,2301619,2302830,2306185,2306878,2307427,2307445,2309890,2310772,2310830,2311378,2312603,2313796,2313967,2314699,2317023,2317343,2318768,2319469,2320504,2320619,2321110,2321696,2325380,2325562,2326774,2327666,2327698,2330066,2332962,2333428,2333552,2333955,2334483,2336416,2336453,2337401,2337454,2337481,2338393,2341433,2341994,2342471,2343235,2344251,2344939,2345255,2346018,2346744,2348577,2349256,2352642,2353105,2353934,2354862,2356844,2356878,2359693,2361150,2362812,2366879,2367254,2368546,2370044,2370539,2371504,2371990,2372791,2373004,2373216,2373385,2373476,2373521,2374423,2375686,2377541,2377628,2379654,2380826,2382047,2385007,2385584,2385730,2386000,2386334,2386808,2387175,2389017,2389329,2390020,2390568,2391303,2391398,2392441,2394377,2394544,2395387,2396166,2396330,2397321,2399016,2399549,2399976,2402417,2402786,2402795,2402808,2403885,2404090,2406734,2408173,2408944,2409600,2410037,2411759,2412153,2412485,2412594,2412619,2413226,2414006,2414255,2415677,2416177,2416577,2417115,2417634,2418232,2418836,2423330,2423522,2424172,2424193,2426524,2426907,2427560,2427723,2430844,2432269,2434774,2435227,2439191,2443586,2444785,2445172,2445553,2446903,2447329,2448709,2448845,2448925,2449517,2449922,2450567,2450803,2451329,2451778,2452329,2452560,2453894,2455051,2455831,2456236,2456563,2457121,2458338,2459277,2459733,2460062,2460900,2461252,2461324,2464062,2465407,2466209,2466301,2467306,2467307,2468352,2469344,2472442,2473482,2476542,2478468,2478520,2479229,2480576,2481407,2482353,2482515,2483057,2485130,2485563,2486337,2488436,2488960,2490290,2492688,2492882,2493100,2495763,2497021,2497736,2498506,2499417,2500374,2500688,2501736,2503349,2503360,2503493,2506168,2506476,2506950,2506953,2507523,2507725,2508078,2508218,2508273,2510624,2510710,2511857,2513187,2514537,2518447,2518805,2520355,2520857,2520945,2523023,2523873,2524319,2525719,2527106,2528386,2529417,2529711,2529895,2530590,2531072,2532255,2534191,2534194,2534709,2536307,2539697,2540233,2540866,2541696,2542367,2542556,2543062,2545930,2546428,2548705,2550316,2550371,2550988,2556475,2556578,2558606,2559588,2563590,2564573,2565412,2565860,2569357,2569647,2571020,2571720,2573513,2573831,2575169,2575306,2577620,2579740,2580023,2580726,2582603,2582721,2584536,2584820,2585546,2586325,2587123,2588277,2589601,2589793,2589955,2590423,2590888,2591084,2591581,2593043,2593953,2594716,2595210,2595498,2595590,2595835,2596704,2598185,2598645,2599062,2599246,2601146,2602945,2603182,2606124,2608245,2608471,2608495,2608803,2610305,2610374,2610678,2610912,2610915,2611305,2611326,2611601,2613345,2613627,2613829,2616149,2617070,2617590,2618881,2618887,2620290,2621186,2621797,2622808,2623750,2624141,2624989,2625590,2626028,2626133,2626378,2626493,2626650,2627359,2627879,2628711,2629766,2629816,2630236,2633786,2634344,2635177,2635912,2639414,2640646,2640967,2641219,2642951,2643179,2643890,2645924,2646395,2648200,2648856,2649833,2650609,2651084,2653270,2655644,2657141,2658284,2659926,2660758,2661578,2661866,2663647,2664854,2664932,2665799,2667775,2669551,2671542,2672533,2672703,2674736,2675200,2678052,2679431,2680778,2682063,2682604,2683479,2684448,2685723,2686429,2687806,2689571,2690486,2691252,2692332,2692352,2695176,2695761,2695979,2697279,2699152,2699179,2699890,2699962,2700394,2700455,2700621,2701006,2701084,2701133,2701720,2701903,2702141,2702401,2702459,2704078,2704289,2707358,2709251,2711307,2712256,2712590,2713870,2714465,2715541,2715952,2717379,2719122,2720328,2721559,2722853,2723144,2724266,2724323,2725724,2726065,2727346,2731968,2732847,2734565,2738067,2738326,2738945,2739165,2739470,2739575,2739828,2740728,2741506,2743912,2744871,2745879,2746008,2746367,2748417,2749345,2749514,2752163,2754070,2755377,2756630,2758499,2758905,2760170,2761325,2761891,2762913,2764010,2764426,2765348,2768398,2768442,2770501,2770850,2771549,2771810,2775021,2775226,2776394,2776482,2778142,2778203,2779046,2779092,2779889,2780198,2781425,2781710,2781978,2783014,2783365,2783417,2783946,2786834,2789095,2789685,2789725,2789915,2790381,2790784,2791146,2791227,2792006,2792076,2792588,2792676,2792919,2793212,2793603,2793919,2794086,2794346,2794980,2796288,2796340,2796473,2796524,2796563,2798123,2798274,2798737,2799870,2801371,2801564,2802026,2803787,2805533,2807147,2807303,2809215,2812184,2812308,2812662,2812713,2815106,2816091,2816204,2816426,2817351,2817898,2818165,2819417,2820362,2820848,2821586,2821832,2822547,2823894,2825116,2825160,2825403,2826071,2827276,2827412,2828381,2828446,2828473,2828751,2828883,2832222,2833391,2834428,2834754,2835303,2836453,2837934,2838491,2840022,2841196,2844529,2845346,2845376,2848647,2848999,2849060,2851177,2851396,2853002,2853398,2854750,2855330,2855672,2856204,2856466,2857143,2858284,2858720,2858775,2859524,2860779,2861144,2862564,2862764,2862804,2865720,2866206,2867298,2868118,2868257,2870379,2870385,2871502,2871677,2872124,2872597,2875238,2876440,2878391,2878429,2878890,2880265,2880796,2881364,2881676,2884387,2885249,2885495,2887880,2888106,2888633,2891706,2892711,2894831,2894895,2895234,2895391,2895504,2899178,2899289,2899616,2899874,2900463,2901215,2901458,2902606,2903691,2903815,2904140,2905217,2907088,2907355,2907431,2908820,2909612,2910101,2910937,2910942,2914905,2914913,2915023,2915815,2916361,2916673,2917005,2920244,2920304,2920600,2922775,2924818,2926128,2928457,2929308,2930077,2930629,2932236,2932391,2932517,2932711,2932803,2933924,2935146,2937284,2939696,2940379,2940810,2941550,2941914,2943883,2944214,2946322,2946614,2946898,2947246,2950704,2951173,2952677,2952703,2953487,2954048,2956823,2958219,2958515,2959561,2961746,2962443,2962502,2963452,2964119,2964735,2965624,2967672,2970397,2971871,2972273,2976119,2977184,2977860,2978585,2978780,2980532,2980946,2981004,2981114,2981122,2981609,2982542,2983820,2983860,2984224,2984646,2984771,2985284,2986298,2987681,2988035,2988703,2989074,2989381,2989867,2990906,2993633,2995133) ORDER BY "sql_load_test"."Post"."id" ASC;

Resulting in 170ms execution time.
Now if we'd be smart, we'd skip the two queries and combine them into one:
SELECT
    p."id",
    p."author" AS "__ParentModel__"
FROM
    "sql_load_test"."Post" p
INNER JOIN "sql_load_test"."User" u ON u.id = p.author
WHERE u."lastName" = 'Face' ORDER BY p."id" ASC;

This skips one roundtrip, but the resulting query is not that much faster, execution time being 170ms.
Before starting the ticket we should consider:

How easy it is to get to the last query here, running only one query instead of two.
Or should we just try to optimize the join away when joining against the same table.

Would both of these options break some use cases?

Optimizing the join away would the most awesome thing to do. I think that this might be doable in core of the query engine actually. The problem here is that we are using a RelationFilter which always results in a join. We should consider to swap this filter with a ScalarFilter in case the relation is inlined in the same table.
The benefit of this would be that all connectors would benefit from this optimization.

This should be work done after merging the Dom Branch (tm) and asyncification?

So, if we start working on the async/await tomorrow with Dom, I doubt this will be in p16.

P16 milestone only means that it is being worked on right now, if it is not done we will move it over to P17.

I will spend some time here this week :)


Add features to k8s-service module

What would you like to be added:

Would like dashes allowed in k8-service module, current error is:

ERROR: Invalid module name, can only contain letters and numbers!
If you need more help please reach out to the contributors in our slack channel at: https://slack.opta.dev

Would like to have custom health checks in same k8s-service module like in standard k8s yaml

  - name: my-service
    type: k8s-service
...
    livenessProbe:
      exec:
        command:
        - cat
        - /tmp/healthy
...

Why is this needed:

This is a request from my team to stay consistent with current environments (pre opta migration)
A request from my team to allow this while we create actual health-check endpoints AND for 3rd part containers where we do not control the code to expose endpoints

Extra info (e.g. existing slack convo link):
https://opta-group.slack.com/archives/C0240NBKUMT/p1652223456899139

release is out


Build builds automatically using GitHub actions.

:trollface:

Closing PR as you seem to have no interest in this.


Feature Request: Check for String / RegEx

Subject of the feature
when i have a string other than twitter or github
.use(require("retext-syntax-mentions"), { style: 'twittter'})

TypeError: style.test is not a function

Problem
the code did not check after init if it is an RegEx
Expected behavior
Should print a error that an RegEx is required
Alternatives
n/a

Ah good catch, there indeed is no error for incorrect configuration. Interested in creating a PR?

Released!


autoscaling component resource

Created a component resource to represent the standard pattern we use for autoscaling resources is AWS. Refactored tika code to use the new component resource.
Addresses part of #825

Motivation and Context
This will provide a simplified interface for creating autoscaling groups (and associated resources) that follow our standard pattern.
How Has This Been Tested?
This is really v1 and it has only been tested against Tika. We should open tasks to refactor existing environments to use these new resources and reduce some of the boiler plate that is scattered around.
With further expansion, we may find shortcoming to these resources as written and may need to revisit them.
Types of changes

[ ] Bug fix (non-breaking change which fixes an issue)
[ ] New feature (non-breaking change which adds functionality)
[X] Enhancement (improves on existing behavior)
[ ] Breaking change (fix or feature that would cause existing functionality to change)

Checklist:

[ ] My code follows the code style of this project. (Did you install and run the pre-commit hooks?)
[ ] My change requires a change to the documentation.
[ ] I have updated the documentation accordingly.

:+1:

closes #825


test case of background job

background job
disowned background job
co-process

add basic test case in commit ef544db215bea005e8165f7420d9e8d8b4fb66a8

update test case in commit 1b0484283043e475de5e7ffa6cdc8a657d218eae


Bug: Status line disappears when you enable command height = 0

Hello.
In Neovim 0.8 you have the option to set the command line height to zero (set ch=0), the problem is that the last status line (set ls=3) and the floating window disappear once you change the buffer and return.

Sorry, I don't get your point, could you explain it clearly?


Laravel-translatable

Laravel-translatable  work with orbit?
https://spatie.be/docs/laravel-translatable/v6/basic-usage/getting-and-settings-translations

Would like to know the same.

Would like to know the same.

not work


[Identity] Hotfix 1.2.4

Take notice that the target branch for this PR is: hotfix/identity_1.2.4.
This PR intends to update the code available at the Identity release 1.2.3 to include two bug fixes:

"[Identity] DefaultAzureCredential should properly handle the managedldentityClientId optional parameter #13973", which fixed customer issue #13894
"[Identity] ManagedIdentityCredential fix #13919", which fixed customer issue #13872

I'm only concerned because the latest beta was 1.2.4-beta.1, and this hotfix is 1.2.4. So I'm guessing I'll need to mention that the beta changes were moved to 1.2.5-beta.1?
I've set the release date for this hotfix to be: 2021-03-08, let me know if that's ok.
In any case, feedback appreciated!

I'm only concerned because the latest beta was 1.2.4-beta.1. So I'm guessing I'll need to mention that the beta changes were moved to 1.2.5-beta.1?

That must have been a mistake. It should have been 1.3.0-beta.1 if the beta was meant to add new features. I doubt that the beta had only bug fixes. Let's go ahead with 1.2.4 hot fix release, but make sure that the next beta is 1.3.0-beta.1. We can add a note in the changelog for 1.2.4 that it does not contain the features introduced in 1.2.4-beta.1 which will be continued to work on in the next update of 1.3.0-beta.1

This PR intends to update the code available at the Identity release 1.2.3 to include two bug fixes:

I see a single commit. Did we try cherry picking commits? That usually makes it easier to review already reviewed code and ensures that we don't have any extra code sneaking in.

@ramya-rao-a I cherry picked the changes by hand 😅 it seemed easier to me at the moment!
@ramya-rao-a I agree with 1.3.0-beta.1 for the next beta release! Thank you for that


How do I get deprecated packages?

Please note that we will close your issue without comment if you delete, do not read or do not fill out the issue checklist below and provide ALL the requested information. If you repeatedly fail to use the issue template, we will block you from ever submitting issues to Homebrew again.

[x ] are reporting a bug others will be able to reproduce and not asking a question. If you're not sure or want to ask a question do so on our Discourse: https://discourse.brew.sh
[x ] ran a brew command and reproduced the problem with multiple formulae? If it's a problem with a single, official formula (not cask) please file this issue at Homebrew/homebrew-core: https://github.com/Homebrew/homebrew-core/issues/new/choose. If it's a brew cask problem please file this issue at https://github.com/Homebrew/homebrew-cask/issues/new/choose. If it's a tap (e.g. Homebrew/homebrew-php) problem please file this issue at the tap.
[x ] ran brew update and can still reproduce the problem?
[ x] ran brew doctor, fixed all issues and can still reproduce the problem?
[x ] ran brew config and brew doctor and included their output with your issue?

What you were trying to do (and why)
Homebrew will only let me install phpunit 8.0 with php 7+, I don't have a clue about taps and all the other stuff. It used to just work for me with php 5.x and phpunit 6.1.4, now I have a new laptop, nothing works and it won't install what I need. Upgrading this legacy piece of software just because homebrew has decided to stop me from downloading it is out of the question as I just need to fix a bug for a client.
How can I get all the previous packages I had using homebrew without having to update the whole application?
What happened (include command output)
Latest versions installed
What you expected to happen
install older versions
Step-by-step reproduction instructions (by running brew commands)
brew install blah@blah
brew search blah - returns no older versions

[x ] are reporting a bug others will be able to reproduce and not asking a question. If you're not sure or want to ask a question do so on our Discourse: https://discourse.brew.sh

This is not a bug. You have a question on how to use Homebrew: ask it in Discourse.


Prettified symbolic Hamiltonian expressions, added a new function for showing offset charge transformations

@jkochNU Thanks for catching the List[Symbol] error. On explorer, Sai already merged jk-explorer 4 days ago, and I forked from his branch 2 days ago. I checked the errors generated by pytests on my side, and these are caused by not having pathos and dill on my environment. With these installed, I have no failing pytest entry. I do get a few warnings:
scqubits/tests/test_centraldispatch.py::TestCentralDispatch::test_register
  DeprecationWarning: `ipykernel.pylab.backend_inline` is deprecated, directly use `matplotlib_inline.backend_inline`
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipykernel/pylab/backend_inline.py: 10

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(ToggleButtons).__init__(disable=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_explorer.py::test_explorer
scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: elementwise comparison failed; this will raise an error in the future.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/traitlets/traitlets.py: 694

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(Layout).__init__(align='top').
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_gui.py::TestGUI::test_gui
scqubits/tests/test_gui.py::TestGUI::test_gui
  DeprecationWarning: Passing unrecognized arguments to super(SelectMultiple).__init__(continuous_update=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_units.py::TestUnits::test_set_units
scqubits/tests/test_units.py::TestUnits::test_units_warning
scqubits/tests/test_units.py::TestUnits::test_units_warning
  UserWarning: Changing units (by calling set_units()) after initializing qubit instances is likely to cause unintended inconsistencies.
   scqubits/tests/test_centraldispatch.py::TestCentralDispatch::test_register
  DeprecationWarning: `ipykernel.pylab.backend_inline` is deprecated, directly use `matplotlib_inline.backend_inline`
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipykernel/pylab/backend_inline.py: 10

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(ToggleButtons).__init__(disable=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_explorer.py::test_explorer
scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: elementwise comparison failed; this will raise an error in the future.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/traitlets/traitlets.py: 694

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(Layout).__init__(align='top').
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_gui.py::TestGUI::test_gui
scqubits/tests/test_gui.py::TestGUI::test_gui
  DeprecationWarning: Passing unrecognized arguments to super(SelectMultiple).__init__(continuous_update=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_units.py::TestUnits::test_set_units
scqubits/tests/test_units.py::TestUnits::test_units_warning
scqubits/tests/test_units.py::TestUnits::test_units_warning
  UserWarning: Changing units (by calling set_units()) after initializing qubit instances is likely to cause unintended inconsistencies.
   scqubits/tests/test_centraldispatch.py::TestCentralDispatch::test_register
  DeprecationWarning: `ipykernel.pylab.backend_inline` is deprecated, directly use `matplotlib_inline.backend_inline`
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipykernel/pylab/backend_inline.py: 10

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(ToggleButtons).__init__(disable=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_explorer.py::test_explorer
scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: elementwise comparison failed; this will raise an error in the future.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/traitlets/traitlets.py: 694

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(Layout).__init__(align='top').
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_gui.py::TestGUI::test_gui
scqubits/tests/test_gui.py::TestGUI::test_gui
  DeprecationWarning: Passing unrecognized arguments to super(SelectMultiple).__init__(continuous_update=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_units.py::TestUnits::test_set_units
scqubits/tests/test_units.py::TestUnits::test_units_warning
scqubits/tests/test_units.py::TestUnits::test_units_warning
  UserWarning: Changing units (by calling set_units()) after initializing qubit instances is likely to cause unintended inconsistencies.
   scqubits/tests/test_centraldispatch.py::TestCentralDispatch::test_register
  DeprecationWarning: `ipykernel.pylab.backend_inline` is deprecated, directly use `matplotlib_inline.backend_inline`
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipykernel/pylab/backend_inline.py: 10

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(ToggleButtons).__init__(disable=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_explorer.py::test_explorer
scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: elementwise comparison failed; this will raise an error in the future.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/traitlets/traitlets.py: 694

scqubits/tests/test_explorer.py::test_explorer
  DeprecationWarning: Passing unrecognized arguments to super(Layout).__init__(align='top').
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_gui.py::TestGUI::test_gui
scqubits/tests/test_gui.py::TestGUI::test_gui
  DeprecationWarning: Passing unrecognized arguments to super(SelectMultiple).__init__(continuous_update=False).
  object.__init__() takes exactly one argument (the instance to initialize)
  This is deprecated in traitlets 4.2.This error will be raised in a future release of traitlets.
   /Users/pacosynthesis/miniforge3/envs/scqubits/lib/python3.10/site-packages/ipywidgets/widgets/widget.py: 477

scqubits/tests/test_units.py::TestUnits::test_set_units
scqubits/tests/test_units.py::TestUnits::test_units_warning
scqubits/tests/test_units.py::TestUnits::test_units_warning
  UserWarning: Changing units (by calling set_units()) after initializing qubit instances is likely to cause unintended inconsistencies.
   /Users/pacosynthesis/Desktop/ScienceTech/Research/Superconducting_qubit_(NU)/Hierarchical_diagonalization/Codes/scqubits-sai/scqubits/core/units.py: 48

I looked into the warnings and found that these indeed are from ipywidgets; although people haven't yet mention the exactly same warning about the DeprecationWarning, there has been similar ones:
https://github.com/jupyter-widgets/ipyleaflet/issues/414
I've checked that I'm using the latest ipywidgets = 7.7.0
Since these warnings are not detrimental, is it good to pull and merge @jkochNU?


Goodhosts' rewrite of the hosts file renders MAMP incapable of managing its entries

copy/paste of https://github.com/goodhosts/cli/issues/24
I am running MAMP Pro and VVV simultaneously, and sometimes concurrently. When MAMP Pro has first crack at the /etc/hosts file, it ends up looking like this:
<IP_ADDRESS>	scratch.test	# MAMP PRO - Do NOT remove this entry!
::1		scratch.test	# MAMP PRO - Do NOT remove this entry!
<IP_ADDRESS>	clean.test	# MAMP PRO - Do NOT remove this entry!
::1		clean.test	# MAMP PRO - Do NOT remove this entry!
<IP_ADDRESS>	cnmd.test	# MAMP PRO - Do NOT remove this entry!
::1		cnmd.test	# MAMP PRO - Do NOT remove this entry!
<IP_ADDRESS>	boilerplate.test	# MAMP PRO - Do NOT remove this entry!
::1		boilerplate.test	# MAMP PRO - Do NOT remove this entry!
<IP_ADDRESS>	macster.local	# MAMP PRO - Do NOT remove this entry!
::1		macster.local	# MAMP PRO - Do NOT remove this entry!

etc etc. Adding and removing hosts via MAMP Pro works correctly, and shutting down MAMP Pro removes all entries it controls. All fine.
  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!
<IP_ADDRESS> boilerplate.test clean.test cnmd.test macster.local scratch.test # MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!  MAMP PRO - Do NOT remove this entry!
<IP_ADDRESS> vvv vvv.test rfa.test # VAGRANT: 32549be2774dded0939569e71b56d8f1 (default) / 465e8518-e2b5-4ae0-9348-e56e8662ab2d
<IP_ADDRESS> broadcasthost

IOW they have gone from one-per-line pairs to a single entry. This rewrite prevents MAMP from being able to manage its entries.
As technically correct as this may be, this is a bad scene. Is there a way to have GH just do its thing without modifying anything else?

Basically add a way to disable the clean inside the plugin for this ticket.

The issue persists even today... using version 1.1.4 with vagrant 2.3.0 an vbox 6.1.38

Normally while changing user files, a copy must be created as a good practice...

Below is in the readme... That suggest you are cleaning hosts file by default!!!! The plugin assumes total control of the machine that runs it...!!! (Please correct it)
Disable file hosts clean
If you want /etc/hosts file cleaned add in your VagrantFile:
config.goodhosts.disable_clean = false

In my case all the comments of hosts file is removed!!! and multiple records of each ip is created as single record....

the feature to disable cleaning there is already in the plugin


how do I set the dapr appid thru code/options? could you all add some examples for options?

Ask your question here

There's a couple of ways to do this, the simplest is to set it specifically in appsettings.json:
{
  "DaprSidekick": {
    "Sidecar": {
      "AppId": "MyApplication"
    }
  }
}

Anything in the DaprSidecarOptions can be put in the Sidecar section above.
Or you can do it in code via the AppDaprSidekick() extension method:
// Add Dapr Sidekick
services.AddDaprSidekick(Configuration, configure =>
{
    configure.Sidecar ??= new Man.Dapr.Sidekick.DaprSidecarOptions();
    configure.Sidecar.AppId = "MyApplication";
});

Or you can use the regular IPostConfigureOptions<T> pattern to register a post-configure handler into which you can inject anything to help you override the options at runtime.

thanks ! could of sworn I had tried the appsettings.json version, must have had something whacked


Fix node_count

Discarded as finally we are using the official terraform AKS module: https://github.com/Azure/terraform-azurerm-aks


How to deserialize operators?

e.g. a modifier list:
modifier = {
	factor = 2
	has_policy_flag = economic_stance_market
}
modifier = {
	factor = 0
	num_communications < 2
}

I know TextTape can do this, but I don't know how to mix TextTape and struct together. I tried JominiDeserialize and serde's visitor, but neither Operator nor OperatorValue implements Deserialize.

Thank you for bringing this up, your input on how to handle this would be appreciated.
Currently operators on struct deserialization are ignored as keys of a struct are implicitly equal to their values (and serde doesn't have any primitives for working with non-equal operators).
As a comparison, the JSON module will preserve operators
foo > bar

And translate it into
{"foo":{"GREATER_THAN":"bar"}}

I've not been entirely convinced by this output to port it over to deserialization, as there are other ways operators can be represented (like a two element array, for instance):
{"foo":[">","bar"]}

I'm assuming the end goal is to have a struct like:
struct jomini::de::Property<T> {
  pub operator: Operator,
  pub value: T
}

// ...

struct Modifier {
  factor: i32,
  num_communications: Property<i32>,
}

I think this is possible, I just need to mull over how to add this option to TextDeserializer and how to implement deserialize for Property<T>. I have a few ideas, but let me know if you have thoughts on the matter.

Thanks for your quick reply.
The property definition looks good to me. A tuple definition is absolutely better than an array(">","1.0").
But it could be a problem to distinguish EQUALS from ASSIGNMENT. Especially when there is a need to flatten to HashMap<String, Property<String>>, just like modifiers.
Although I'm not a serde expert, it seems that it can be solved by specifically implementing visit_map.
Parsing modifiers could be a tough task

2022年10月27日 下午7:42:18 Nick Babcock @.***>:

Thank you for bringing this up, your input on how to handle this would be appreciated.
Currently operators on struct deserialization are ignored as keys of a struct are implicitly equal to their values (and serde doesn't have any primitives for working with non-equal operators).
As a comparison, the JSON module will preserve operators
*foo > bar
*
And translate it into
{"foo":{"GREATER_THAN":"bar"}}
I've not been entirely convinced by this output to port it over to deserialization, as there are other ways operators can be represented (like a two element array, for instance):
{"foo":[">","bar"]}
I'm assuming the end goal is to have a struct like:
struct jomini::de::Property {
pub operator: Operator,
pub value: T
}
// ...
struct Modifier {
factor: i32,
num_communications: Property,
}
I think this is possible, I just need to mull over how to add this option to TextDeserializer and how to implement deserialize for Property. I have a few ideas, but let me know if you have thoughts on the matter.
—
Reply to this email directly, view it on GitHub[https://github.com/rakaly/jomini/issues/105#issuecomment-1293401398], or unsubscribe[https://github.com/notifications/unsubscribe-auth/ABS4INJQQU6Q5II7WZXDUI3WFJTBLANCNFSM6AAAAAARPTB7RM].
You are receiving this because you authored the thread.[追踪用途的图像][https://github.com/notifications/beacon/ABS4INPC634KSCGQATUO7IDWFJTBLA5CNFSM6AAAAAARPTB7ROWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSNC66TM.gif]

How does #106 sound? It introduces a type called Property that the deserializer will look for, and if present will deserialize the operator. It's a bit of a hack, but seems useful.


Keep Screen On not working on Fedora 39 (KDE Plasma)

Tested versions
Reproduced in v4.2.1.stable.mono.official [b09f793f5] and v4.3.dev5.official [c9c17d6ca] in both x11 and wayland and in all rendering methods.
System information
Godot v4.2.1.stable.mono - Fedora Linux 39 (KDE Plasma) - X11 - Vulkan (Forward+) - dedicated NVIDIA GeForce GTX 1650 (nvidia; 550.54.14) - Intel(R) Core(TM) i3-10100F CPU @ 3.60GHz (8 Threads)
Issue description
Screen turns off after normal time despite a project running with keep_screen_on enabled.
Steps to reproduce
Create a project, save a scene with anything in it, then run it and wait for the screen to turn off.
Minimal reproduction project (MRP)
N/A

Same on Ubuntu 22.04 Gnome.
Godot v4.2.2.stable.mono - Ubuntu 22.04.4 LTS 22.04 - X11 - Vulkan (Forward+) - dedicated NVIDIA GeForce GTX 1050 Ti (nvidia; 535.171.04) - Intel(R) Core(TM) i5-6600 CPU @ 3.30GHz (4 Threads)

Reproduced in Godot 4.3 stable on Gentoo with X 21.1.13 and elogind 252.9.


Performances drawing Cells

Improve performances for drawing cell, particularly drawing the circle background (use drawRect:?)

Hi @jmig , I just found the same issue when scrolling very fast. Maybe we can draw static contents firstly (such as day label), and draw dynamic contents with 0.* sec delay (such as background color). Are you working on this issue? I want to implement this feature but I don't know how to do it. If you have any ideas and have no time coding, please feel free to let me know.


Update apache-hive-migrate-workloads.md

Updated the language

@ashishthaps1 : Thanks for your contribution! The author(s) have been notified to review your proposed change.

#sign-off

@hrasheed-msft: I'm sorry - only the author of this article, @msft-tacox, can sign off on your changes. But we do have an exception process - if you are on the Microsoft content or product team for this product area, you can ask the PR review team to review and merge it by sending mail to the techdocprs alias.

@ktoliver : Thanks for your contribution! The author(s) have been notified to review your proposed change.


adding describe function

left a comment here: https://github.com/moov-io/pinblock/issues/2#issuecomment-1593481913

this logic implemented on format package

@mfdeveloper508 it looks good! Let's use require.Contains and I think we are good to go! Thank you for your work!!!


net: openthread: Allow to disable automatic network attachment

Add OpenThread configuration option, which allows to configure and start
OpenThread stack operation manually. This mode should be used in NCP
devices, as well as is needed for certification purposes, where
OpenTread stack have to be configured by the test framework and not
initialize and join the network on its own.
Signed-off-by: Robert Lubos<EMAIL_ADDRESS>

CC @edmont


chainloop org member invite create does not send emails to recipient

When invoking a chainloop org member invite create the identified --recipient, which does not send out an invite to join the organization.
SMTP could be configured to enable the Chainloop hosted control plane to issue invites, or the client could print an invitation URL to bind a user to an organization via browser.
There are also other ways to handle this feature as well, but I don't hold a strong opinion on implementation.  I am just noting the application behavior.

Thanks, @anoncam, for reporting this issue. As you have found, chainloop invitations do not send out emails nor require explicit acceptance. Basically, the receiver of the invitation will join the organization the next time they chainloop auth login
I think email notification and explicit acceptance make sense since it seems a ubiquitous pattern, but I'd split this feature into two phases. I personally would be happy if we just implement the first part for now, but I'd like to get your take.

Send an email to the receiver telling them that they have been invited and that they need to login in to chainloop to join them.
Include in the email a unique invitation link, and potentially also output it in the terminal as you suggested.

re: smtp. we already have some code in one of our plugins that could serve as inspiration https://github.com/chainloop-dev/chainloop/blob/8568ca437e2b77b60a374fb43acee41dd5e3153e/app/controlplane/plugins/core/smtp/v1/extension.go#L196

So I am interpreting this from the hosted control plane perspective @migmartri.  In the Chainloop hosted cp it looks like the only thing to do is set up smtp using something like Amazon SES etc.
For self-hosted control planes, it makes sense to let the configuration be the deployer's concern.
Does that make sense? I'm not sure this is an issue given the context now.

Sounds good to me, so basically what I think a first version of this feature could be

Add support to configure an SMTP interface per Chainloop instance.
When a user is invited, send an email letting them know about the fact. The email should contain a configurable link that could point to the Web User Interface login page or in its absence mention chainloop auth login command.


Not able to connect to the user using Postgres python package

I have created a docker image of postgres along with Kafka stream using docker-compose.

version: "3"

services:
  zookeeper:
    image: confluentinc/cp-zookeeper:latest
    environment:
      ZOOKEEPER_CLIENT_PORT: 2181
      ZOOKEEPER_TICK_TIME: 2000
    networks:
      - stream-network
  kafka:
    image: confluentinc/cp-kafka:latest
    depends_on:
      - zookeeper
    ports:
      - 9092:9092
    environment:
      KAFKA_ZOOKEEPER_CONNECT: zookeeper:2181
      KAFKA_ADVERTISED_LISTENERS: PLAINTEXT://kafka:29092,PLAINTEXT_HOST://localhost:9092
      KAFKA_LISTENER_SECURITY_PROTOCOL_MAP: PLAINTEXT:PLAINTEXT,PLAINTEXT_HOST:PLAINTEXT
      KAFKA_INTER_BROKER_LISTENER_NAME: PLAINTEXT
      KAFKA_OFFSETS_TOPIC_REPLICATION_FACTOR: 3
    networks:
        - stream-network
  streamer:
    build:
      context: ./streamingProducer/
    networks:
      - stream-network
    depends_on:
      - kafka
  consumer:
    build:
      context: ./streamingConsumer/
    networks:
      - stream-network
    depends_on:
      - kafka
      - postgres
  postgres:
    # image: postgres
    # restart: always
    # environment:
    #   POSTGRES_USER: docker
    #   POSTGRES_PASSWORD: docker
    #   POSTGRES_DB: test
    #   PGDATA: /var/lib/postgresql/data/pgdata
    # ports:
    #   - "5432:5432"
    # healthcheck:
    #   test: ["CMD-SHELL", "pg_isready -U docker"]
    # volumes:
    #   - ./data/postgres/pgdata:/var/lib/postgresql/data/pgdata
      build: './db'
      restart: always
      environment:
        - "FILLA_DB_USER=filla"
        - "FILLA_DB_PASSWORD=filla"
        - "FILLA_DB_DATABASE=filladb1"
        - "POSTGRES_USER=postgres"
        - "POSTGRES_PASSWORD=password"
      ports:
        - "5432:5432"
      networks:
        - stream-network

The docker image of Postgres seems to run fine, the log looks completely good

`postgres_1   | creating configuration files ... ok
zookeeper_1  | ===> User
postgres_1   | running bootstrap script ... ok
zookeeper_1  | uid=0(root) gid=0(root) groups=0(root)
zookeeper_1  | ===> Configuring ...
postgres_1   | performing post-bootstrap initialization ... sh: locale: not found
postgres_1   | 2020-05-27 11:52:45.209 UTC [29] WARNING:  no usable system locales were found
slimmerai_consumer_1 exited with code 0
postgres_1   | ok
postgres_1   | syncing data to disk ... ok
postgres_1   | initdb: warning:
postgres_1   | enabling "trust" authentication for local connections
postgres_1   | You can change this by editing pg_hba.conf or using the option -A, or
postgres_1   | --auth-local and --auth-host, the next time you run initdb.
postgres_1   |
postgres_1   | Success. You can now start the database server using:
postgres_1   |
postgres_1   |     pg_ctl -D /var/lib/postgresql/data -l logfile start
postgres_1   |
postgres_1   | waiting for server to start....2020-05-27 11:52:46.729 UTC [34] LOG:  starting PostgreSQL 12.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.2.0) 9.2.0, 64-bit
postgres_1   | 2020-05-27 11:52:46.736 UTC [34] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1   | 2020-05-27 11:52:46.767 UTC [35] LOG:  database system was shut down at 2020-05-27 11:52:46 UTC
postgres_1   | 2020-05-27 11:52:46.771 UTC [34] LOG:  database system is ready to accept connections
postgres_1   |  done
postgres_1   | server started
postgres_1   |
postgres_1   | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/01-filladb.sh
postgres_1   | CREATE ROLE
postgres_1   | CREATE DATABASE
postgres_1   | GRANT
postgres_1   |
postgres_1   | 2020-05-27 11:52:46.989 UTC [34] LOG:  received fast shutdown request
postgres_1   | waiting for server to shut down....2020-05-27 11:52:46.991 UTC [34] LOG:  aborting any active transactions
postgres_1   | 2020-05-27 11:52:46.996 UTC [34] LOG:  background worker "logical replication launcher" (PID 41) exited with exit code 1
postgres_1   | 2020-05-27 11:52:46.996 UTC [36] LOG:  shutting down
postgres_1   | 2020-05-27 11:52:47.010 UTC [34] LOG:  database system is shut down
postgres_1   |  done
postgres_1   | server stopped
postgres_1   |
postgres_1   | PostgreSQL init process complete; ready for start up.
postgres_1   |
postgres_1   | 2020-05-27 11:52:47.100 UTC [1] LOG:  starting PostgreSQL 12.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.2.0) 9.2.0, 64-bit
postgres_1   | 2020-05-27 11:52:47.101 UTC [1] LOG:  listening on IPv4 address "<IP_ADDRESS>", port 5432
postgres_1   | 2020-05-27 11:52:47.101 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres_1   | 2020-05-27 11:52:47.104 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1   | 2020-05-27 11:52:47.125 UTC [45] LOG:  database system was shut down at 2020-05-27 11:52:47 UTC
postgres_1   | 2020-05-27 11:52:47.129 UTC [1] LOG:  database system is ready to accept connections
`

And when I log into the database docker container, I can see the users and all the db being created.
But when I try to access the db using python package
`import psycopg2
from psycopg2 import Error
try:
connection = psycopg2.connect(user = "postgres",
password = "password",
host = "localhost",
port = "5432",
database = "filladb1")
cursor = connection.cursor()

print("Table connected successfully in PostgreSQL ")

except (Exception, psycopg2.DatabaseError) as error :
print ("Error while creating PostgreSQL table", error)`
It throws an error:
Error while creating PostgreSQL table FATAL:  role "postgres" does not exist
Not sure, what am I doing wrong, any help would be appreciated. Thanks.

[ ]

Questions like this should be asked over at the Docker Community Forums, Docker Community Slack, or Stack Overflow. Since these repos aren't really a user-help forum
Since the issue isn't related to our postgres image I'm going to close, there's nothing we can do to alleviate the issue as it's not our image

host = "localhost",

FYI, assuming that you were trying to connect from one container to another, you probably just needed to connect to the host of postgres (i.e the name of the service).

As of now, I am not trying to connect from one container to another. The Postgres db is running in one container and I am trying to run the python script on my laptops terminal to see if the connection is established.
import psycopg2
from psycopg2 import Error

try:
connection = psycopg2.connect(user = "postgres",
password = "password",
host = "localhost",
port = "5432",
database = "filladb1")

cursor = connection.cursor()

print("Table connected successfully in PostgreSQL ")

I think there are some issues with docker-proxy and IPv6, and localhost often resolves to ::1 first, so I'd suggest trying <IP_ADDRESS> explicitly.


Failed to build on Ubuntu 18.04 with Ryzen CPU

Error when build from source on Ubuntu 18.04 tag:build_template
System information

OS Platform and Distribution: Ubuntu 18.04
TensorFlow installed from source 1.14
TensorFlow version: 1.14
Python version: 3.6
Bazel version (if compiling from source): 0.24.1
GCC/Compiler version (if compiling from source): 7.4
CUDA/cuDNN version: 10.0
GPU model and memory: RTX 2060
CPU: Ryzen 5 2600

Describe the problem
I follow tutorial https://www.tensorflow.org/install/source, but It always throw error like this
Provide the exact sequence of commands / steps that you executed before running into the problem
bazel build --cxxopt="-D_GLIBCXX_USE_CXX11_ABI=0" -- define=tensorflow_mkldnn_contraction_kernel=0 --verbose_failures  //tensorflow/tools/pip_package:build_pip_package
or
bazel build --cxxopt="-D_GLIBCXX_USE_CXX11_ABI=0" //tensorflow/tools/pip_package:build_pip_package
or
bazel build --config=cuda //tensorflow/tools/pip_package:build_pip_package
**Any other info / logs**
ERROR: /home/tuan/Downloads/tensorflow-1.14.0/tensorflow/core/BUILD:3079:1: C++ compilation of rule '//tensorflow/core:core_cpu_base' failed (Exit 1): crosstool_wrapper_driver_is_not_gcc failed: error executing command
  (cd /home/tuan/.cache/bazel/_bazel_tuan/5cac32750bec0be81932199159ef575e/execroot/org_tensorflow && \
  exec env - \
    CUDA_TOOLKIT_PATH=/usr/local/cuda \
    GCC_HOST_COMPILER_PATH=/usr/bin/gcc \
    PATH=/home/tuan/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin \
    PWD=/proc/self/cwd \
    PYTHON_BIN_PATH=/usr/bin/python3 \
    PYTHON_LIB_PATH=/usr/local/lib/python3.6/dist-packages \
    TF_CONFIGURE_IOS=0 \
    TF_CUDA_CLANG=0 \
    TF_CUDA_COMPUTE_CAPABILITIES=7.5 \
    TF_NEED_CUDA=1 \
    TF_NEED_OPENCL_SYCL=0 \
    TF_NEED_ROCM=0 \
    TF_NEED_TENSORRT=1 \
  external/local_config_cuda/crosstool/clang/bin/crosstool_wrapper_driver_is_not_gcc -MD -MF bazel-out/k8-opt/bin/tensorflow/core/_objs/core_cpu_base/graph_constructor.pic.d '-frandom-seed=bazel-out/k8-opt/bin/tensorflow/core/_objs/core_cpu_base/graph_constructor.pic.o' -D__CLANG_SUPPORT_DYN_ANNOTATION__ -DEIGEN_MPL2_ONLY '-DEIGEN_MAX_ALIGN_BYTES=64' '-DEIGEN_HAS_TYPE_TRAITS=0' -DTF_USE_SNAPPY -iquote . -iquote bazel-out/k8-opt/genfiles -iquote bazel-out/k8-opt/bin -iquote external/com_google_absl -iquote bazel-out/k8-opt/genfiles/external/com_google_absl -iquote bazel-out/k8-opt/bin/external/com_google_absl -iquote external/eigen_archive -iquote bazel-out/k8-opt/genfiles/external/eigen_archive -iquote bazel-out/k8-opt/bin/external/eigen_archive -iquote external/local_config_sycl -iquote bazel-out/k8-opt/genfiles/external/local_config_sycl -iquote bazel-out/k8-opt/bin/external/local_config_sycl -iquote external/nsync -iquote bazel-out/k8-opt/genfiles/external/nsync -iquote bazel-out/k8-opt/bin/external/nsync -iquote external/gif_archive -iquote bazel-out/k8-opt/genfiles/external/gif_archive -iquote bazel-out/k8-opt/bin/external/gif_archive -iquote external/jpeg -iquote bazel-out/k8-opt/genfiles/external/jpeg -iquote bazel-out/k8-opt/bin/external/jpeg -iquote external/protobuf_archive -iquote bazel-out/k8-opt/genfiles/external/protobuf_archive -iquote bazel-out/k8-opt/bin/external/protobuf_archive -iquote external/com_googlesource_code_re2 -iquote bazel-out/k8-opt/genfiles/external/com_googlesource_code_re2 -iquote bazel-out/k8-opt/bin/external/com_googlesource_code_re2 -iquote external/farmhash_archive -iquote bazel-out/k8-opt/genfiles/external/farmhash_archive -iquote bazel-out/k8-opt/bin/external/farmhash_archive -iquote external/fft2d -iquote bazel-out/k8-opt/genfiles/external/fft2d -iquote bazel-out/k8-opt/bin/external/fft2d -iquote external/highwayhash -iquote bazel-out/k8-opt/genfiles/external/highwayhash -iquote bazel-out/k8-opt/bin/external/highwayhash -iquote external/zlib_archive -iquote bazel-out/k8-opt/genfiles/external/zlib_archive -iquote bazel-out/k8-opt/bin/external/zlib_archive -iquote external/local_config_cuda -iquote bazel-out/k8-opt/genfiles/external/local_config_cuda -iquote bazel-out/k8-opt/bin/external/local_config_cuda -Ibazel-out/k8-opt/bin/external/local_config_cuda/cuda/_virtual_includes/cuda_headers_virtual -isystem external/eigen_archive -isystem bazel-out/k8-opt/genfiles/external/eigen_archive -isystem bazel-out/k8-opt/bin/external/eigen_archive -isystem external/nsync/public -isystem bazel-out/k8-opt/genfiles/external/nsync/public -isystem bazel-out/k8-opt/bin/external/nsync/public -isystem external/gif_archive/lib -isystem bazel-out/k8-opt/genfiles/external/gif_archive/lib -isystem bazel-out/k8-opt/bin/external/gif_archive/lib -isystem external/protobuf_archive/src -isystem bazel-out/k8-opt/genfiles/external/protobuf_archive/src -isystem bazel-out/k8-opt/bin/external/protobuf_archive/src -isystem external/farmhash_archive/src -isystem bazel-out/k8-opt/genfiles/external/farmhash_archive/src -isystem bazel-out/k8-opt/bin/external/farmhash_archive/src -isystem external/zlib_archive -isystem bazel-out/k8-opt/genfiles/external/zlib_archive -isystem bazel-out/k8-opt/bin/external/zlib_archive -isystem external/local_config_cuda/cuda -isystem bazel-out/k8-opt/genfiles/external/local_config_cuda/cuda -isystem bazel-out/k8-opt/bin/external/local_config_cuda/cuda -isystem external/local_config_cuda/cuda/cuda/include -isystem bazel-out/k8-opt/genfiles/external/local_config_cuda/cuda/cuda/include -isystem bazel-out/k8-opt/bin/external/local_config_cuda/cuda/cuda/include '-std=c++11' -Wno-builtin-macro-redefined '-D__DATE__="redacted"' '-D__TIMESTAMP__="redacted"' '-D__TIME__="redacted"' -fPIC -U_FORTIFY_SOURCE '-D_FORTIFY_SOURCE=1' -fstack-protector -Wall -fno-omit-frame-pointer -no-canonical-prefixes -fno-canonical-system-headers -DNDEBUG -g0 -O2 -ffunction-sections -fdata-sections '-D_GLIBCXX_USE_CXX11_ABI=0' -DEIGEN_AVOID_STL_ARRAY -Iexternal/gemmlowp -Wno-sign-compare -fno-exceptions '-ftemplate-depth=900' '-DGOOGLE_CUDA=1' '-DGOOGLE_TENSORRT=1' -msse3 -pthread '-DGOOGLE_CUDA=1' '-DGOOGLE_TENSORRT=1' -c tensorflow/core/graph/graph_constructor.cc -o bazel-out/k8-opt/bin/tensorflow/core/_objs/core_cpu_base/graph_constructor.pic.o)
Execution platform: @bazel_tools//platforms:host_platform
In file included from external/protobuf_archive/src/google/protobuf/arena_impl.h:40:0,
                 from external/protobuf_archive/src/google/protobuf/arena.h:51,
                 from bazel-out/k8-opt/genfiles/tensorflow/core/framework/graph.pb.h:24,
                 from ./tensorflow/core/graph/graph_constructor.h:19,
                 from tensorflow/core/graph/graph_constructor.cc:16:
external/protobuf_archive/src/google/protobuf/map.h: In instantiation of 'void google::protobuf::Map<Key, T>::InnerMap::iterator_base<KeyValueType>::SearchFrom(google::protobuf::Map<Key, T>::size_type) [with KeyValueType = google::protobuf::Map<unsigned int, std::basic_string<char> >::KeyValuePair; Key = unsigned int; T = std::basic_string<char>; google::protobuf::Map<Key, T>::size_type = long unsigned int]':
external/protobuf_archive/src/google/protobuf/map.h:400:19:   required from 'google::protobuf::Map<Key, T>::InnerMap::iterator_base<KeyValueType>::iterator_base(const google::protobuf::Map<Key, T>::InnerMap*) [with KeyValueType = google::protobuf::Map<unsigned int, std::basic_string<char> >::KeyValuePair; Key = unsigned int; T = std::basic_string<char>]'
external/protobuf_archive/src/google/protobuf/map.h:516:31:   required from 'google::protobuf::Map<Key, T>::InnerMap::iterator google::protobuf::Map<Key, T>::InnerMap::begin() [with Key = unsigned int; T = std::basic_string<char>; google::protobuf::Map<Key, T>::InnerMap::iterator = google::protobuf::Map<unsigned int, std::basic_string<char> >::InnerMap::iterator_base<google::protobuf::Map<unsigned int, std::basic_string<char> >::KeyValuePair>]'
external/protobuf_archive/src/google/protobuf/map.h:1037:29:   required from 'google::protobuf::Map<Key, T>::iterator google::protobuf::Map<Key, T>::begin() [with Key = unsigned int; T = std::basic_string<char>]'
external/protobuf_archive/src/google/protobuf/map.h:1147:29:   required from 'void google::protobuf::Map<Key, T>::clear() [with Key = unsigned int; T = std::basic_string<char>]'
external/protobuf_archive/src/google/protobuf/map_field_inl.h:188:3:   required from 'void google::protobuf::internal::MapField<Derived, Key, T, key_wire_type, value_wire_type, default_enum_value>::Clear() [with Derived = tensorflow::DeviceStepStats_ThreadNamesEntry_DoNotUse; Key = unsigned int; T = std::basic_string<char>; google::protobuf::internal::WireFormatLite::FieldType kKeyFieldType = (google::protobuf::internal::WireFormatLite::FieldType)13; google::protobuf::internal::WireFormatLite::FieldType kValueFieldType = (google::protobuf::internal::WireFormatLite::FieldType)9; int default_enum_value = 0]'
bazel-out/k8-opt/genfiles/tensorflow/core/framework/step_stats.pb.h:2329:23:   required from here
external/protobuf_archive/src/google/protobuf/map.h:423:9: internal compiler error: Segmentation fault
         GOOGLE_DCHECK(m_->index_of_first_non_null_ == m_->num_buckets_ ||
         ^
Please submit a full bug report,

I build tensorflow 1.14, 2.0 on Intel CPU and Nvidia GPU does not have any problems.

Can you try adding -march=native, as mentioned here?

Can you try adding -march=native, as mentioned here?

thank you for your reply. But It still have error. I have to use prebuild package

@babytut
Is this still an issue

yes, I still can not build it.

I also change to build Tensorflow 2.2.0 from source. But it still have same error. Does anyone use AMD like me have same error ?

FYI, I had similar problems with threadripper. I "solved" this by using fewer build threads with --jobs=N flag. Try to run prime95 in "torture" mode. If it fails, your system is not stable enough to build something as large as TF. Usually this is due to memory compatibility problems.

Confirmed: replacing memory with ECC memory allows me to build 2.4.0 RC3 with parallelism of 64 on my machine without any issues.

Thank you for your help. I will compile TF as you suggest.


fix(ci): docker arg is named TARGETARCH.

What type of PR is this?
/kind bug
Any specific area of the project related to this PR?
/area CI
What this PR does / why we need it:
Use correct TARGETARCH name isntead of TARGET_ARCH.
Which issue(s) this PR fixes:
Fixes #
Special notes for your reviewer:
Does this PR introduce a user-facing change?:

NONE

/milestone 0.35.0

[APPROVALNOTIFIER] This PR is APPROVED
This pull-request has been approved by: FedeDP
The full list of commands accepted by this bot can be found here.
The pull request process is described here

Needs approval from an approver in each of these files:

OWNERS [FedeDP]

Approvers can indicate their approval by writing /approve in a comment
Approvers can cancel approval by writing /approve cancel in a comment

[APPROVALNOTIFIER] This PR is APPROVED
This pull-request has been approved by: Andreagit97, FedeDP, jasondellaluce
The full list of commands accepted by this bot can be found here.
The pull request process is described here

Needs approval from an approver in each of these files:

OWNERS [Andreagit97,FedeDP,jasondellaluce]

Approvers can indicate their approval by writing /approve in a comment
Approvers can cancel approval by writing /approve cancel in a comment