MastersForum

Zitat von »myabba|schoki«

Ich bekomme MySQL-Fehlermeldungen, dass
a) nicht genug Speicher vorhanden ist
b) keine weiteren Dateien geöffnet werden können
c) auf eine temporäre Datei nicht zugegriffen werden kann.

Spricht vieles dafür, dass der Datenbankserver über seine Kapazität hinaus betrieben wird.

Zitat von »Attila«

Welche Größen erreicht das ganze denn mittlerweile? (Datenbank / RAM /HDD /CPU verbrauch?) Hab da gar keine Vorstellungen.
Was für Kosten entstehen denn dabei? Sonst müssen wir halt mal n bisschen was dazu legen.

Zitat von »sylence«

Auf der HDD ist noch genug Platz, RAM ist auch frei, zumindest innerhalb des Containers. Viel mehr finde ich im Netz zu diesem Fehler leider auch nicht. Auf den Host selbst habe ich leider keinen Zugriff, das kann nur Jack erledigen. :/

Zitat

Fatal error: Invalid SQL: SELECT DISTINCT post.userID AS ownPosts,thread_visit.lastVisitTime,IF(thread_subscription.userID IS NOT NULL, 1, 0) AS subscribed,if (thread.ratings>0 AND thread.ratings>=1,thread.rating/thread.ratings,0) AS ratingResult, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 591) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 591) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 591 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (45688,50155,50168,41468,49594,50163,45910,50014,50165,42876,50092,50161,23482,50157,42880,50153,50000,50152,50115,50150) ORDER BY thread.isAnnouncement DESC, thread.isSticky DESC, thread.lastPostTime DESC

Zitat

Fatal error: Invalid SQL: SELECT DISTINCT post.userID AS ownPosts,thread_visit.lastVisitTime,IF(thread_subscription.userID IS NOT NULL, 1, 0) AS subscribed,if (thread.ratings>0 AND thread.ratings>=1,thread.rating/thread.ratings,0) AS ratingResult, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 591) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 591) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 591 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (41468,49594,45688,50155,50168,50163,45910,50014,50165,42876,50092,50161,23482,50157,42880,50153,50000,50152,50115,50150) ORDER BY thread.isAnnouncement DESC, thread.isSticky DESC, thread.lastPostTime DESC
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1
Information:
error message: Invalid SQL: SELECT DISTINCT post.userID AS ownPosts,thread_visit.lastVisitTime,IF(thread_subscription.userID IS NOT NULL, 1, 0) AS subscribed,if (thread.ratings>0 AND thread.ratings>=1,thread.rating/thread.ratings,0) AS ratingResult, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 591) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 591) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 591 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (41468,49594,45688,50155,50168,50163,45910,50014,50165,42876,50092,50161,23482,50157,42880,50153,50000,50152,50115,50150) ORDER BY thread.isAnnouncement DESC, thread.isSticky DESC, thread.lastPostTime DESC
error code: 1
sql type: MySQLDatabase
sql error: Can't create/write to file '/tmp/#sql_3f83_0.MYD' (Errcode: 17)
sql error number: 1
sql version:
file: /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.8
wcf version: 1.1.9 (Tempest)
date: Thu, 17 Oct 2013 16:01:07 +0000
request: /index.php?page=Board&boardID=5
referer:
Stacktrace:
#0 /opt/lampp/htdocs/mastersforum.de/public_html/lib/data/thread/ThreadList.class.php(110): MySQLDatabase->sendQuery('SELECT??DISTINC...')
#1 /opt/lampp/htdocs/mastersforum.de/public_html/lib/data/thread/BoardThreadList.class.php(153): ThreadList->readThreads()
#2 /opt/lampp/htdocs/mastersforum.de/public_html/lib/page/BoardPage.class.php(163): BoardThreadList->readThreads()
#3 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/page/AbstractPage.class.php(90): BoardPage->readData()
#4 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/page/AbstractPage.class.php(46): AbstractPage->show()
#5 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#6 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Board', Array, 'page')
#7 /opt/lampp/htdocs/mastersforum.de/public_html/index.php(8): RequestHandler::handle(Array)
#8 {main}