{"issue":{"created_at":"2011-12-05T10:26:50Z","state":"closed","updated_at":"2011-12-05T11:51:24Z","comments":2,"user":{"gravatar_id":"4145eb9ef11c1a98710e5411de9b4bcd","id":713708,"url":"https://api.github.com/users/bamisalami","login":"bamisalami","avatar_url":"https://secure.gravatar.com/avatar/4145eb9ef11c1a98710e5411de9b4bcd?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"Kijk vooral eventjes na de laatste regels:\r\n```InnoDB: which exceeds the log group capacity 9433498.\r\nInnoDB: If you are using big BLOB or TEXT rows, you must set the\r\nInnoDB: combined size of log files at least 10 times bigger than the\r\nInnoDB: largest such row.\r\n111203  6:30:29 [Note] Plugin 'FEDERATED' is disabled.\r\n111203  6:30:31  InnoDB: Initializing buffer pool, size = 128.0M\r\n111203  6:30:32  InnoDB: Completed initialization of buffer pool\r\nInnoDB: The log sequence number in ibdata files does not match\r\nInnoDB: the log sequence number in the ib_logfiles!\r\n111203  6:30:33  InnoDB: Database was not shut down normally!\r\nInnoDB: Starting crash recovery.\r\nInnoDB: Reading tablespace information from the .ibd files...\r\nInnoDB: Restoring possible half-written data pages from the doublewrite\r\nInnoDB: buffer...\r\n111203  6:30:39  InnoDB: Started; log sequence number 2 3102204741\r\n111203  6:30:43 [Note] Event Scheduler: Loaded 0 events\r\n111203  6:30:43 [Note] /usr/sbin/mysqld: ready for connections.\r\nVersion: '5.1.58-1ubuntu1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)\r\n111203  6:31:20 [ERROR] /usr/sbin/mysqld: Table './spotweb/spots' is marked as crashed and should be repaired\r\n111204 20:27:15 [ERROR] /usr/sbin/mysqld: Table './spotweb/spots' is marked as crashed and should be repaired\r\n111204 20:27:15 [Warning] Checking table:   './spotweb/spots'\r\n```\r\nIk vroeg me af wat de oorzaak kan zijn, nooit gehad.","assignee":null,"number":1310,"id":2447708,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"labels":[],"title":"Database crashed","closed_at":"2011-12-05T11:51:24Z","html_url":"https://github.com/spotweb/spotweb/issues/1310","url":"https://api.github.com/repos/spotweb/spotweb/issues/1310","milestone":null},"action":"created","comment":{"created_at":"2011-12-05T11:51:24Z","updated_at":"2011-12-05T11:51:24Z","user":{"gravatar_id":"4145eb9ef11c1a98710e5411de9b4bcd","id":713708,"url":"https://api.github.com/users/bamisalami","login":"bamisalami","avatar_url":"https://secure.gravatar.com/avatar/4145eb9ef11c1a98710e5411de9b4bcd?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"Vreemd inderdaad gewoon een VPS. Maar als het een lokaal probleem is sluit ik het issue. Reparatie gelukt en probleem verholpen.","id":3015988,"url":"https://api.github.com/repos/spotweb/spotweb/issues/comments/3015988"}}