Database problems

BogPoet · Post by **BogPoet** » Mon Dec 22, 2003 5:21 pm

Has anybody else getting a database connection error when trying to access the forums? I had, but now everything seemed to be working allright, until I tried to edit a post (the Portuguese Top 50):

EBTForum.com wrote:General Error

Error in deleting post

DEBUG MODE

SQL Error : 2013 Lost connection to MySQL server during query

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (32619)

Line : 417
File : /home/eurobill/www/phpBB2/includes/functions_search.php

Is there anything that can be done? I have been promised riots when I don't update the Top 50 on time...

EDIT - Well, at least I managed to post this... Let's see if I can edit...

EDIT2 - Hmm... I'll try the PTop50 again.

aplfi · Post by **aplfi** » Mon Dec 22, 2003 5:48 pm

I had same kind of problem.

Ganymede · Post by **Ganymede** » Tue Dec 23, 2003 9:15 pm

I think there's still something not quite right. I get errors when trying to acces the posts since last visit

Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '1166755153' for key 1

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1166755153, '25500553778e5264a4b42d19a7a83853', 'a:7:{s:14:"search_results";s:21:"603, 2565, 2575, 2577";s:17:"total_match_count";i:4;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 679
File : /home/eurobill/www/phpBB2/search.php

and when using the search function:

Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '178691368' for key 1

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(178691368, '25500553778e5264a4b42d19a7a83853', 'a:7:{s:14:"search_results";s:3719:"15, 21, 22, 30, 52, 55, 56, 57, 64, 66, 84, 104, 109, 110, 136, 149, 154, 182, 192, 198, 199, 209, 210, 211, 212, 216, 217, 225, 226, 227, 228, 240, 244, 247, 257, 260, 267, 268, 274, 281, 287, 292, 293, 295, 316, 318, 320, 323, 324, 334, 344, 350, 355, 369, 370, 373, 378, 379, 385, 390, 397, 398, 399, 409, 422, 425, 427, 431, 435, 437, 438, 439, 446, 451, 452, 453, 456, 457, 458, 461, 466, 468, 470, 471, 472, 473, 474, 475, 479, 483, 486, 487, 489, 494, 495, 499, 500, 502, 503, 504, 505, 514, 518, 519, 526, 533, 534, 538, 540, 546, 548, 555, 558, 559, 561, 562, 566, 567, 568, 570, 574, 576, 577, 587, 589, 590, 591, 593, 596, 598, 603, 607, 615, 623, 625, 630, 631, 632, 636, 641, 642, 649, 650, 658, 665, 672, 682, 685, 696, 697, 699, 704, 706, 707, 719, 720, 722, 725, 728, 730, 734, 735, 741, 742, 750, 751, 757, 761, 766, 771, 775, 777, 779, 786, 787, 791, 803, 806, 810, 812, 820, 821, 822, 825, 832, 833, 836, 838, 839, 840, 841, 842, 846, 848, 851, 857, 861, 864, 868, 869, 870, 876, 877, 880, 881, 882, 888, 889, 890, 893, 894, 897, 898, 904, 909, 912, 913, 914, 915, 916, 917, 921, 924, 926, 927, 934, 937, 940, 942, 944, 949, 951, 952, 962, 963, 966, 968, 969, 974, 985, 1002, 1003, 1020, 1026, 1032, 1038, 1044, 1058, 1083, 1084, 1094, 1115, 1124, 1125, 1133, 1147, 1148, 1152, 1155, 1156, 1158, 1160, 1161, 1168, 1175, 1179, 1183, 1185, 1208, 1209, 1214, 1215, 1216, 1218, 1231, 1232, 1233, 1238, 1239, 1243, 1247, 1252, 1258, 1259, 1263, 1264, 1269, 1271, 1272, 1279, 1280, 1290, 1304, 1317, 1322, 1325, 1326, 1327, 1328, 1332, 1334, 1337, 1339, 1342, 1343, 1349, 1355, 1357, 1359, 1370, 1371, 1385, 1388, 1398, 1400, 1401, 1428, 1429, 1432, 1436, 1439, 1452, 1455, 1462, 1467, 1485, 1501, 1506, 1508, 1510, 1514, 1520, 1521, 1523, 1524, 1526, 1528, 1534, 1537, 1541, 1550, 1553, 1558, 1559, 1562, 1563, 1567, 1568, 1572, 1574, 1577, 1581, 1582, 1583, 1585, 1587, 1589, 1591, 1592, 1593, 1594, 1600, 1605, 1612, 1613, 1614, 1617, 1619, 1628, 1636, 1639, 1641, 1644, 1648, 1651, 1653, 1654, 1655, 1658, 1660, 1663, 1668, 1682, 1689, 1690, 1691, 1692, 1698, 1702, 1704, 1706, 1707, 1712, 1714, 1715, 1719, 1720, 1721, 1722, 1723, 1726, 1727, 1729, 1730, 1732, 1733, 1734, 1735, 1736, 1739, 1741, 1745, 1748, 1751, 1752, 1753, 1756, 1760, 1761, 1765, 1766, 1785, 1786, 1787, 1796, 1798, 1801, 1802, 1806, 1809, 1816, 1817, 1818, 1819, 1820, 1835, 1836, 1837, 1840, 1841, 1847, 1850, 1855, 1857, 1859, 1860, 1861, 1866, 1867, 1869, 1870, 1871, 1872, 1873, 1874, 1877, 1878, 1880, 1884, 1890, 1891, 1895, 1900, 1902, 1907, 1919, 1921, 1922, 1923, 1924, 1928, 1929, 1930, 1931, 1933, 1936, 1937, 1938, 1939, 1943, 1945, 1948, 1949, 1951, 1955, 1961, 1974, 1976, 1977, 1991, 1992, 1995, 2003, 2007, 2016, 2017, 2026, 2028, 2030, 2036, 2037, 2038, 2044, 2046, 2047, 2058, 2062, 2066, 2075, 2079, 2081, 2085, 2086, 2087, 2089, 2094, 2095, 2096, 2100, 2102, 2105, 2107, 2110, 2111, 2116, 2122, 2123, 2124, 2125, 2126, 2128, 2129, 2132, 2137, 2147, 2149, 2150, 2157, 2158, 2164, 2166, 2167, 2168, 2177, 2181, 2193, 2194, 2195, 2197, 2200, 2206, 2212, 2221, 2231, 2233, 2241, 2243, 2246, 2250, 2254, 2258, 2260, 2263, 2264, 2266, 2267, 2269, 2271, 2285, 2292, 2294, 2296, 2297, 2305, 2306, 2308, 2310, 2311, 2314, 2315, 2316, 2322, 2323, 2324, 2327, 2328, 2332, 2337, 2340, 2342, 2344, 2347, 2348, 2349, 2356, 2360, 2361, 2363, 2367, 2372, 2375, 2376, 2383, 2391, 2397, 2398, 2399, 2402, 2410, 2414, 2415, 2416, 2417, 2419, 2428, 2433, 2434, 2437, 2441, 2443, 2445, 2450, 2451, 2454, 2455, 2458, 2460, 2470, 2471, 2473, 2477, 2479, 2480, 2481, 2483, 2484, 2486, 2487, 2491, 2506, 2511, 2513, 2514, 2516, 2517, 2518, 2522, 2524, 2528, 2529, 2539, 2540, 2545, 2546, 2550, 2552, 2553, 2559, 2560, 2562, 2563, 2565";s:17:"total_match_count";i:662;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 679
File : /home/eurobill/www/phpBB2/search.php

avij · Post by **avij** » Tue Dec 23, 2003 9:23 pm

Most probably the database server at OVH can't keep up with the load. We'll be taking this into consideration.

bhoeyb · Post by **bhoeyb** » Tue Dec 23, 2003 11:39 pm

aplfi wrote:I had same kind of problem.

Me 2.

BogPoet · Post by **BogPoet** » Mon Jan 05, 2004 12:03 pm

EBTForum.com wrote:Could not obtain post/user information.

DEBUG MODE

SQL Error : 1053 Server shutdown in progress

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 921 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 810, 15

Line : 393
File : /home/eurobill/www/phpBB2/viewtopic.php

I got this when I clicked on the Suspicious users thread on the EBT Users part of the forum. I then clicked "Back" on my browser, clicked again... and abracadabra, it worked...

Ganymede · Post by **Ganymede** » Mon Jan 05, 2004 5:36 pm

This one sounds dangerous:

phpBB : Critical Error

Could not connect to the database

Elmo · Post by **Elmo** » Mon Jan 05, 2004 6:50 pm

Ganymede wrote:This one sounds dangerous:
phpBB : Critical Error

Could not connect to the database

I have had this one several times too!

So I'm not the only one...

EDIT: when I wanted to post this post, I got this error:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@forum.eurobilltracker.eu and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.29 Server at forum.eurobilltracker.eu Port 80

nodisch18 · Post by **nodisch18** » Mon Jan 05, 2004 6:57 pm

Elmo wrote:
Ganymede wrote:This one sounds dangerous:
phpBB : Critical Error

Could not connect to the database
I have had this one several times too! So I'm not the only one...

for me the same, the other error i haven't seen yet...

Elmo · Post by **Elmo** » Mon Jan 05, 2004 7:03 pm

And now I got THIS one:

Could not obtain post count

DEBUG MODE

SQL Error : 2013 Lost connection to MySQL server during query

SELECT COUNT(post_id) AS total_posts FROM phpbb_posts

Line : 273
File : /home/eurobill/www/phpBB2/includes/functions_search.php

What is wrong with this forum?

Blueman · Post by **Blueman** » Mon Jan 05, 2004 7:10 pm

test

ahhh it works again

BogPoet · Post by **BogPoet** » Mon Jan 05, 2004 11:30 pm

CRAAAAAAAAAAAAAAAACOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!

Elmo · Post by **Elmo** » Mon Jan 05, 2004 11:37 pm

The forum has been nice this evening!

BogPoet · Post by **BogPoet** » Mon Jan 05, 2004 11:48 pm

Not for me, it hasn't. I spent half an hour getting "phpBB: Critical error, etc, etc..." So, that was why I posted a big cry for help...

Post by **Craco** » Tue Jan 06, 2004 12:37 am

I heard somebody calling my name??

The forum has been behaving terrible.. We have been put by OVH onto the MySQL-server for big databases as our DB had grown to 38,5MB. This server is sometimes heavily loaded as we can all experience.. I got the DB down to 33MB by clearing some data of the search tables and i asked OVH-support to put us back to the normal sql-server.

Meanwhile we are looking for another hosting-solution as the current solution has hit the limits and there is no room for growth anymore.

If you have any Private Messages that you don't need anymore, please delete those as they are taking space also on the DB.

Greetzz,