spotweb/spotweb — Issue #1310: Database crashed
Author: bamisalami
Created: 2011-12-05 10:26:50+00:00
State: open

Kijk vooral eventjes na de laatste regels:
```InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
111203 6:30:29 [Note] Plugin 'FEDERATED' is disabled.
111203 6:30:31 InnoDB: Initializing buffer pool, size = 128.0M
111203 6:30:32 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
111203 6:30:33 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
111203 6:30:39 InnoDB: Started; log sequence number 2 3102204741
111203 6:30:43 [Note] Event Scheduler: Loaded 0 events
111203 6:30:43 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.58-1ubuntu1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
111203 6:31:20 [ERROR] /usr/sbin/mysqld: Table './spotweb/spots' is marked as crashed and should be repaired
111204 20:27:15 [ERROR] /usr/sbin/mysqld: Table './spotweb/spots' is marked as crashed and should be repaired
111204 20:27:15 [Warning] Checking table: './spotweb/spots'
```
Ik vroeg me af wat de oorzaak kan zijn, nooit gehad.