Database problems

if you have anything to say about this forum, this is the place

Moderators: Fons, avij, Phaseolus

User avatar
BogPoet
Euro-Master
Euro-Master
Posts: 1249
Joined: Wed Apr 16, 2003 1:05 am
Location: Loulé/Lisboa

Database problems

Post by BogPoet »

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.
Tracking (again) Image
User avatar
aplfi
Euro-Master
Euro-Master
Posts: 2486
Joined: Sat Nov 15, 2003 2:19 pm
Location: Nokia/Finland

Post by aplfi »

I had same kind of problem.
User avatar
Ganymede
Euro-Expert
Euro-Expert
Posts: 634
Joined: Tue Oct 14, 2003 12:51 am
Location: Mt. Olympus

Post by Ganymede »

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
I don't háve a life.
User avatar
avij
Forum Moderator
Forum Moderator
Posts: 6175
Joined: Mon May 27, 2002 10:45 pm
Location: Helsinki Finland
Contact:

Post by avij »

Most probably the database server at OVH can't keep up with the load. We'll be taking this into consideration.
User avatar
bhoeyb
Euro-Master
Euro-Master
Posts: 4268
Joined: Thu Apr 18, 2002 3:58 pm
Location: Herentals - Belgium
Contact:

Post by bhoeyb »

aplfi wrote:I had same kind of problem.
Me 2.
User avatar
BogPoet
Euro-Master
Euro-Master
Posts: 1249
Joined: Wed Apr 16, 2003 1:05 am
Location: Loulé/Lisboa

Post by BogPoet »

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...
Tracking (again) Image
User avatar
Ganymede
Euro-Expert
Euro-Expert
Posts: 634
Joined: Tue Oct 14, 2003 12:51 am
Location: Mt. Olympus

Post by Ganymede »

This one sounds dangerous:
phpBB : Critical Error

Could not connect to the database
I don't háve a life.
User avatar
Elmo
Euro-Master
Euro-Master
Posts: 4232
Joined: Mon Oct 14, 2002 4:16 pm
Location: Leiden (Netherlands)

Post by Elmo »

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

Could not connect to the database
I have had this one several times too! :o :o 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
Of all the words of mice and men, the saddest are 'It might have been.' - Kurt Vonnegut
User avatar
nodisch18
Euro-Master
Euro-Master
Posts: 1497
Joined: Sat Jun 29, 2002 8:25 pm
Location: Sint-Oedenrode
Contact:

Post by nodisch18 »

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! :o :o So I'm not the only one...
for me the same, the other error i haven't seen yet...
User avatar
Elmo
Euro-Master
Euro-Master
Posts: 4232
Joined: Mon Oct 14, 2002 4:16 pm
Location: Leiden (Netherlands)

Post by Elmo »

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? :evil: :evil:
Of all the words of mice and men, the saddest are 'It might have been.' - Kurt Vonnegut
User avatar
Blueman
Euro-Master
Euro-Master
Posts: 2229
Joined: Mon Dec 23, 2002 1:44 am
Location: Helmond, The Netherlands
Contact:

Post by Blueman »

test

ahhh it works again
Blue is the color that makes people wild!
User avatar
BogPoet
Euro-Master
Euro-Master
Posts: 1249
Joined: Wed Apr 16, 2003 1:05 am
Location: Loulé/Lisboa

Post by BogPoet »

CRAAAAAAAAAAAAAAAACOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!
Tracking (again) Image
User avatar
Elmo
Euro-Master
Euro-Master
Posts: 4232
Joined: Mon Oct 14, 2002 4:16 pm
Location: Leiden (Netherlands)

Post by Elmo »

The forum has been nice this evening! :o :o :D :D :) :)
Of all the words of mice and men, the saddest are 'It might have been.' - Kurt Vonnegut
User avatar
BogPoet
Euro-Master
Euro-Master
Posts: 1249
Joined: Wed Apr 16, 2003 1:05 am
Location: Loulé/Lisboa

Post by BogPoet »

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... :wink:
Tracking (again) Image
User avatar
Craco
Forum Administrator
Forum Administrator
Posts: 488
Joined: Sat Feb 02, 2002 12:23 pm
Location: Belgium, Beringen
Contact:

Post by Craco »

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,
Post Reply

Return to “Forum feedback”