Следующая проблема - имеется форум IPB 3.4.3, со вчерашнего дня неожиданно начались необъяснимые тормоза движка и появляются ошибки БД следующего типа:
mySQL query error: SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.moved_to, t.views, t.posts, t.topic_answered_pid,m.*,pp.* FROM ibf_topics t LEFT JOIN ibf_members m ON ( m.member_id=t.starter_id ) LEFT JOIN ibf_profile_portal pp ON ( m.member_id=pp.pp_member_id ) WHERE t.tid IN (16228,16227,16226,16225,16224,16223,16222,16221,16220,16219)
mySQL query error: SELECT p.pid as id, p.post_date, p.topic_id,t.title, t.posts, t.views FROM ibf_posts p LEFT JOIN ibf_topics t ON ( t.tid=p.topic_id ) WHERE t.forum_id IN (222,6,66,7,876,1698,1717,903,594,19,22,2351,380,20,8,15,433,386,432,428,79,210,228,21,550,592,671,711,781,907,991,1077,1201,1338,1489,1552,1613,1723,1767,1922,1949,2266,2469,2470,2471,2352,195,196,197,198,199,271,377,378,25,2324,266,537,27,35,262,29,56,53,158,159,274,499,32,150,86,318,1660,1661,1662,1663,654,534,655,240,138,647,48,51,299,232,55,57,54,186,339,412,236,164,357,353,300,50,301,302,303,376,286,278,285,282,902,1234,1383,1384,1385,1744,280,283,284,157,1359,1345,1340,1043,510,446,1561,2394,1291,1292,1293,1294,1323,1324,201,1775,96,97,413,414,1102,223,103,407,1575,105,294,231,104,2235,361,436,605,116,108,2134,109,205,106,131,1087,126,1214,964,1021,1022,1026,1589,127,1935,1937,1942,1941,1938,1940,1939,1936,1632,2314,810,2441,264,2464,683,806,2542,2435,135,908,154,1822,1736,220,212,168,2,747,1543,1168,1167,1166,272,1792,2566,1980,1216,1261,1624,1541,1542,1376,1944,1657,1658,1461,813,717,489,648,1563,1564,1569,214,215,297,2079,1652,1653,1654,166,167,329,176,326,288,381,360,182,183,330,336,384,187,188,189,281,191,192,193,194,200,208,267,268,269,257,202,2122,2126,2188,2127,2129,160,221,672,970,390,349,382,139,101,123,224,277,87,327,16,389,275,305,165,80,162,163,185,289,290,291,292,293,551,566,567,801,952,1061,1244,1427,2223,2434,2538,247,320,244,254,308,239,368,967,843,681,227,472,473,535,888,1366,128,2121,298,1777,2238,2029,2030,1743,2031,1963,1955,1738,1739,1740,276,385,373,306,307,374,356,961,1361,152,153,111,112,211,219,344,226,230,296,98,190,334,366,309,310,311,319,911,1979,422,321,322,323,324,325,332,633,1379,1720,335,358,337,338,351,340,2167,2242,2168,971,972,354,359,367,1000,1082,2239,1850,95,115,1186,2521,363,730,107,5,14,13,375,36,47,58,28,38,650,649,426,651,693,449,498,395,699,835,623,626,91,369,370,371,372,1659,169,207,596,383,213,217,218,348,2463,352,462,598,393,394,400,401,437,601,408,517,409,1399,487,564,777,1066,1258,507,508,509,958,963,427,423,695,696,697,698,1053,216,581,582,583,1796,295,2008,477,478,448,479,415,102,689,691,1627,1666,2303,529,424,635,724,726,464,465,466,467,468,469,470,619,620,622,676,632,471,450,451,562,556,532,530,563,565,531,845,765,26,1570,1571,1572,1014,497,494,527,834,493,523,522,919,500,1685,503,1254,1093,1005,670,571,846,364,1386,1538,134,2148,701,703,23,705,331,155,704,41,304,30,40,248,511,512,513,514,714,2052,2053,2054,2055,2056,515,516,611,545,718,538,539,1997,2000,2001,612,2004,2006,2007,518,2185,2186,2540,520,521,265,541,542,543,544,1665,1994,1995,411,475,536,554,2289,1619,1276,1761,716,624,405,1002,1017,2539,789,615,614,646,652,2003,2100,659,1576,663,660,604,625,2405,677,678,1055,1057,679,1058,548,627,631,629,957,634,641,643,645,637,644,256,175,114,751,753,755,739,741,258,829,392,397,402,421,657,658,661,662,836,664,682,686,680,720,438,555,700,784,783,673,785,819,1056,715,687,260,702,712,710,1582,1583,1626,1722,2016,2021,2070,2169,480,731,736,732,733,943,759,1733,735,1064,1059,758,1250,804,944,918,737,738,767,2461,910,1577,938,939,778,883,1009,909,1019,1259,2050,889,1183,1202,1236,1238,1247,1467,740,742,1643,1246,814,1297,1298,831,2113,1299,749,750,752,754,953,1060,1179,1180,1181,782,779,796,2544,798,800,1076,1080,1603,1675,1051,133,812,1045,1759,1749,1773,2049,816,817,818,824,977,821,822,823,985,986,950,825,826,827,828,830,838,839,840,841,837,842,844,847,854,855,858,863,864,865,866,869,870,848,849,850,878,851,852,853,856,857,859,860,861,862,893,894,895,896,884,885,867,868,879,871,872,992,2203,2206,917,881,882,805,901,2028,1052,2256,915,2037,1590,1553,1754,1945,1981,2067,1991,1988,2027,920,923,925,926,949,921,922,940,931,987,932,929,930,962,933,942,954,1046,934,935,936,945,946,947,948,937,1560,1587,1348,1011,1012,1016,951,1184,1142,1040,973,1033,1044,1086,955,974,975,1042,1015,968,965,988,989,1593,978,990,1600,993,994,979,980,996,982,1010,1274,997,995,1030,984,1006,927,1001,959,941,1007,1008,924,1065,1078,1079,956,1041,1708,1712,1713,429,526,552,553,1013,897,2571,2563,2304,2570,1400,1100,279,2554,983,2299,1409,976,966,1031,1307,1605,1604,1257,557,1296,1325,1038,1267,1024,1025,1615,558,1295,1631,1309,1578,1614,559,1084,1085,1483,1620,255,1621,1622,1592,1623,1606,1607,1608,1609,1610,1028,1029,2247,2248,1169,1070,1071,1072,1704,1705,1349,1706,1308,1067,37,621,2406,425,2408,410,492,491,748,743,653,1588,1068,1069,1073,1094,1095,1096,1097,1098,1099,1115,1131,1132,1300,1301,1219,1304,1110,1111,1158,1255,1343,1233,1546,1387,1105,1133,1107,1672,1104,1113,1673,1674,1545,1103,1601,1135,609,603,606,916,1204,1207,1235,2033,1117,1148,1127,1128,1129,1130,1160,1125,1126,1161,1162,1112,1106,1143,1145,1136,1139,1178,1177,1175,1176,2177,1157,1263,1264,1265,1266,1118,1119,1120,1174,1108,1122,1326,1123,1485,1121,1329,1170,1171,1172,1406,1159,1256,1535,1537,1251,1302,1303,1116,1153,1154,1155,1156,1149,1150,1151,1152,1147,1245,1137,1138,1230,1140,1318,1319,1144,1146,1124,1163,1203,1357,1356,1978,483,313,1544,1895,2074,1403,1404,1986,1330,1346,1347,1194,1187,1193,1195,2362,2440,1199,2387,2472,1196,1197,2371,1288,1243,1210,1225,2292,2293,2296,2297,2357,1260,2335,2334,1205,2369,1277,1200,2462,2503,2504,1287,1221,1209,2306,1215,1312,1226,1220,1222,2341,2342,1224,1185,1231,1252,1364,1365,1310,1333,1278,1279,1280,1273,981,1286,1331,1289,2376,2568,1281,1306,1271,1284,1351,1285,2375,2484,1268,1283,1369,1465,1269,1316,1360,1270,1275,1305,1533,1377,1313,1317,1372,1321,1322,1334,1335,1336,1337,1282,1405,1173,1637,1339,2178,2179,1628,1629,1630,1923,1924,1925,2572,2379,1667,2381,2026,1344,1370,1371,1441,1378,1374,1640,1487,1443,1445,1447,246,457,1027,243,1262,877,1725,2515,1388,1389,1390,1391,1228,1375,1402,1047,1429,1481,1594,1703,2333,1253,1411,1413,1415,1417,1419,1423,1425,1368,1020,482,1469,1088,2260,2261,1511,1517,1493,1495,1497,1499,1513,1519,1521,1523,1525,1527,1529,1531,1540,1539,2279,2280,2281,2230,913,912,2302,2505,1547,1548,1549,1550,2093,132,1950,1645,1646,1715,1989,1714,1716,1983,706,484,707,560,416,418,728,1242,1362,1217,1565,1573,1566,1567,1039,1568,2023,447,786,1350,618,549,341,685,2187,2236,2237,1581,1591,1616,1617,1584,833,1595,1642,2045,2084,1596,1597,1618,1602,445,476,1625,1647,1633,1634,2269,2316,2317,1598,1599,1676,1648,1649,1650,887,794,2398,2399,2400,1664,2397,2378,1668,1670,1669,2403,1821,1686,1687,1688,1689,1690,1691,1700,1702,1696,1701,1721,1707,1692,1693,1694,1718,1697,333,1709,1710,1711,540,1018,431,533,756,891,892,1719,1762,1763,1764,1054,2298,1760,1757,1758,1750,1751,1752,1779,1753,2044,1769,745,1772,1987,1951,744,799,1109,757,890,2010,2011,2012,2013,2014,2015,1768,1770,1771,2551,2114,1774,1776,2063,2064,2065,2066,1780,1793,1795,1902,1824,1827,1828,2567,1782,1919,1920,1921,1790,1805,1794,1823,1797,1798,1799,1801,1802,1819,2046,2061,2068,1800,1815,2060,1808,1809,1907,1918,1785,1784,1842,1836,1833,1786,1787,1843,1825,1826,1897,1832,1834,1835,1829,1830,1831,1837,1838,1848,1849,1898,1856,1851,1858,2104,2108,1855,2111,1867,1868,1869,1870,1871,2119,1865,1859,1862,2545,1896,1861,1864,2501,2107,1877,1878,2077,2088,1880,1881,1882,1883,1884,1927,1888,1926,1931,1930,2149,2227,1886,2071,2082,2115,2094,1875,2095,2270,2183,1901,2062,2543,2089,2265,1889,2087,2075,2086,1899,1900,1904,2058,2069,2076,2109,2110,2112,2166,2353,1893,1933,2072,2078,2294,2295,1905,1906,1811,1813,1840,1841,1839,1803,1791,1817,1818,1812,1810,1788,1814,1804,1928,1984,2101,2323,1863,1872,1934,2130,1932,2244,2283,2243,2287,1948,2284,2307,2425,2426,2427,2231,2232,2233,2234,2041,2042,1964,1551,1965,2355,2354,803,2043,1956,1957,1958,1966,1967,1968,1969,1976,2264,2207,2229,2384,2057,1953,1952,1063,1164,746,797,820,1959,1960,1961,1962,1977,2092,1970,1971,1972,1973,1974,1975,2326,2391,1982,2564,2080,1990,2522,1993,1996,1998,2038,2039,1559,580,613,2002,2048,2005,546,1558,1756,2009,2017,2018,2020,2019,2022,1437,1367,1435,1382,1381,1380,1741,1742,2032,1737,2257,2313,2047,1891,2051,2228,2059,2073,2081,2202,2085,2103,2090,2091,2096,2097,2098,2099,2105,2159,2205,2300,2301,2106,1852,1853,1854,1929,2518,2519,2520,2170,2171,2116,2117,2118,668,665,1463,666,667,2396,2123,2124,2125,2494,2164,2492,2136,2155,2156,2157,2506,2428,2135,2137,2222,2132,2488,2153,2128,2497,342,2498,2499,2221,2131,2490,2491,2133,2418,2419,2420,2421,2422,2423,2495,2138,2370,2140,2141,2142,2165,2224,2444,2144,2145,2146,2147,2325,2537,2150,2151,2152,2285,2286,2225,2158,2485,2249,2173,2161,2252,2253,2184,2189,2172,2251,2163,2195,2198,347,346,406,2245,2204,2552,2174,2250,1354,1353,1049,1352,1727,2180,2181,2182,2193,2240,2241,2194,2216,628,519,404,776,815,1373,2476,969,2196,2197,2199,2200,2201,2213,2214,2215,2212,2288,2208,2209,2217,2218,2219,2523,2220,761,880,250,1491,420,2262,561,2336,2254,2162,2278,273,2263,2267,2268,2277,2271,2272,2273,2274,2318,2319,2320,2321,2322,2291,2290,2483,2541,2359,2372,1229,1249,1208,1223,2358,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2548,2308,2311,2312,2517,2481,2327,2328,2329,2330,2331,2332,441,442,1034,2305,1211,1212,1290,2309,2310,2315,2340,2343,2344,2337,2338,2339,2373,2345,2346,2348,2349,2350,2356,2282,2360,2361,2477,2478,2479,2480,2364,2365,2367,2368,2401,2402,2417,2559,2560,2411,2412,2415,2374,2475,2377,2024,2025,1198,2385,2388,2392,2393,1766,1992,2424,1655,1035,444,443,2407,2409,2410,2404,2413,2414,2416,2139,2143,2553,2154,2429,2430,2436,2437,2438,2439,2433,2432,2431,2486,2487,1755,1728,252,2442,2443,2120,2474,2192,2458,2459,2460,2546,2465,2466,2467,2468,2496,2489,2493,2500,2255,2502,2525,2527,2530,2531,2569,2524,2573,2574,2575,2576,2577,2578,2579,2580,2528,2529,2532,2533,2534,2535,2536,2555,2585,2589,2596,2561,2562,2565,2547,2550,2558,2556,2557,2581,2582,2583,2584,2586,2587,2588,2594,2590,2592,2593,2591,2595) AND p.queued IN (0,1,2) AND t.approved IN (1,0,-1) AND t.topic_archive_status IN (0,3) AND ( p.pid IN (0,171531,172092,172424,172066,172046,171902,172443,172752,174298,174104,174097,172866,171789,171770,171532,171543,171530,171528,171544,171545,171768,171553,171550,171548,174299,174303,179777,179892,179750,179743,179269,179902,181034,181175,181174,181139,181101,179268,178771,176096,175647,175132,174306,176816,176833,178300,177879,177864,177697,171521,171518,153513,154618,153459,153435,149488,154936,155868,160852,158917,158832,158650,148605,148312,139261,139252,139246,139237,142128,142197,147272,144798,143640,142213,161246,161376,169429,170773,168074,166817,166813,171107,171111,171506,171480,171419,171116,166603,166600,164032,162412,162276,161858,164165,164181,166521,166042,165679,164665,181925,181945,377653,377670,377621,377620,377609,377683,377828,378409,378228,378227,378018,377441,377281,375615,375493,375446,375191,376023,376505,377275,377188,377169,376726,378438,378465,381369,381928,381224,380743,380650,383862,384662,387945,387780,384940,384779,379993,379837,379409,379379,378959,378762,379414,379421,379779,379736,379448,379439,367492,366864,273695,274067,272792,247747,247152,282596,282651,291371,291358,290355,289937,246851,246240,197591,197587,197214,196929,197709,232270,246238,246137,245817,245689,291375,291377,343067,343076,342830,342821,342811,343089,343136,349082,347829,344955,344781,342783,342778,292851,292339,291382,291380,293173,295814,342745,342735,340321,298927,390435) ) AND t.state != 'link' AND p.author_id = 718 ORDER BY post_date desc LIMIT 0,201
Никаких дополнительных модификаций и хуков не устанавливал еще с того года. Проблема появилась внезапно.
Сами по себе ошибки появляются не постоянно, а через раз. Сначала думал, что DDOS, т.к. на форуме все действия стали совершаться вдвойне более медленно, чем обычно. Но техподдержка хостинга ответила, что никакой DDOS активности не обнаружено. Вместе с тем, сказали, что на index.php приходится большая нагрузка (там как раз форум и установлен).
Находясь на нашем сайте, вы соглашаетесь на использование файлов cookie, а также с нашим положением о конфиденциальности Политика конфиденциальности и пользовательским соглашением Условия использования.
Вопрос
Leo_Skywalker
Приветствую!
Следующая проблема - имеется форум IPB 3.4.3, со вчерашнего дня неожиданно начались необъяснимые тормоза движка и появляются ошибки БД следующего типа:
Никаких дополнительных модификаций и хуков не устанавливал еще с того года. Проблема появилась внезапно.
Сами по себе ошибки появляются не постоянно, а через раз. Сначала думал, что DDOS, т.к. на форуме все действия стали совершаться вдвойне более медленно, чем обычно. Но техподдержка хостинга ответила, что никакой DDOS активности не обнаружено. Вместе с тем, сказали, что на index.php приходится большая нагрузка (там как раз форум и установлен).
Прошу помочь, кто чем может.
Ссылка на комментарий
Поделиться на других сайтах
9 ответов на этот вопрос
Рекомендуемые сообщения
Присоединиться к обсуждению
Вы можете ответить сейчас, а зарегистрироваться позже. Если у вас уже есть аккаунт, войдите, чтобы ответить от своего имени.