Can't init databases mysql 4.0.26

MySQL, PostgreSQL, SQLite
memo1003
Posts: 24
Joined: 2005-07-08 23:34

Can't init databases mysql 4.0.26

Post by memo1003 » 2005-11-20 02:52

Hallo,
gestern um 19:00 uhr ist mein mysql datenbank ausgefallen.

im error log finde ich:

Code: Select all

Number of processes running now: 0
051119 19:02:33  mysqld restarted
InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 8388608 bytes!
051119 19:02:45 Can't init databases
051119 19:02:45 Aborting

051119 19:02:48  InnoDB: Warning: shutting down a not properly started
                 InnoDB: or created database!
051119 19:02:48 /usr/sbin/mysqld-max: Shutdown Complete

051119 19:02:49  mysqld ended

ich hebe um diese uhrzeit nicht neugestartet...

ich habe das erst um 2 uhr bemerkt und versucht mysql zu starten.
Jetzt bekomme ich dies hier:

Code: Select all

051120 02:48:02  mysqld started
InnoDB: Error: log file /var/lib/mysql/ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 8388608 bytes!
051120  2:48:02 Can't init databases
051120  2:48:02 Aborting

051120  2:48:02  InnoDB: Warning: shutting down a not properly started
                 InnoDB: or created database!
051120  2:48:02 /usr/sbin/mysqld: Shutdown Complete

051120 02:48:02  mysqld ended
habe nichts verändert da ich um 19:00 uhr nichtmal zuhause war.

log von var/log/warn:

Code: Select all

Nov 19 19:04:06 s412ffrt54 kernel: oom-killer: gfp_mask=0x1d2
Nov 19 19:04:07 s412ffrt54 kernel: DMA per-cpu:
Nov 19 19:04:07 s412ffrt54 kernel: cpu 0 hot: low 2, high 6, batch 1
Nov 19 19:04:07 s412ffrt54 kernel: cpu 0 cold: low 0, high 2, batch 1
Nov 19 19:04:07 s412ffrt54 kernel: cpu 1 hot: low 2, high 6, batch 1
Nov 19 19:04:07 s412ffrt54 kernel: cpu 1 cold: low 0, high 2, batch 1
Nov 19 19:04:07 s412ffrt54 kernel: Normal per-cpu:
Nov 19 19:04:07 s412ffrt54 kernel: cpu 0 hot: low 32, high 96, batch 16
Nov 19 19:04:07 s412ffrt54 kernel: cpu 0 cold: low 0, high 32, batch 16
Nov 19 19:04:07 s412ffrt54 kernel: cpu 1 hot: low 32, high 96, batch 16
Nov 19 19:04:07 s412ffrt54 kernel: cpu 1 cold: low 0, high 32, batch 16
Nov 19 19:04:07 s412ffrt54 kernel: HighMem per-cpu:
Nov 19 19:04:07 s412ffrt54 kernel: cpu 0 hot: low 14, high 42, batch 7
Nov 19 19:04:07 s412ffrt54 kernel: cpu 0 cold: low 0, high 14, batch 7
Nov 19 19:04:07 s412ffrt54 kernel: cpu 1 hot: low 14, high 42, batch 7
Nov 19 19:04:07 s412ffrt54 kernel: cpu 1 cold: low 0, high 14, batch 7
Nov 19 19:04:07 s412ffrt54 kernel: 
Nov 19 19:04:07 s412ffrt54 kernel: Free pages:        9064kB (112kB HighMem)
Nov 19 19:04:07 s412ffrt54 kernel: Active:120767 inactive:123073 dirty:0 writeback:0 unstable:0 free:2266 slab:4589 mapped:245413 pagetables:1916
Nov 19 19:04:07 s412ffrt54 kernel: DMA free:4008kB min:16kB low:32kB high:48kB active:4256kB inactive:3812kB present:16384kB
Nov 19 19:04:07 s412ffrt54 kernel: lowmem_reserve[]: 0 880 998
Nov 19 19:04:07 s412ffrt54 kernel: Normal free:4944kB min:936kB low:1872kB high:2808kB active:421308kB inactive:428192kB present:901120kB
Nov 19 19:04:07 s412ffrt54 kernel: lowmem_reserve[]: 0 0 948
Nov 19 19:04:07 s412ffrt54 kernel: HighMem free:112kB min:128kB low:256kB high:384kB active:57504kB inactive:60288kB present:121392kB
Nov 19 19:04:07 s412ffrt54 kernel: lowmem_reserve[]: 0 0 0
Nov 19 19:04:07 s412ffrt54 kernel: DMA: 10*4kB 36*8kB 8*16kB 1*32kB 1*64kB 1*128kB 1*256kB 0*512kB 1*1024kB 1*2048kB 0*4096kB = 4008kB
Nov 19 19:04:07 s412ffrt54 kernel: Normal: 260*4kB 338*8kB 19*16kB 0*32kB 0*64kB 1*128kB 1*256kB 1*512kB 0*1024kB 0*2048kB 0*4096kB = 4944kB
Nov 19 19:04:07 s412ffrt54 kernel: HighMem: 0*4kB 0*8kB 3*16kB 0*32kB 1*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 112kB
Nov 19 19:04:07 s412ffrt54 kernel: Swap cache: add 19429759, delete 19429741, find 34594087/36668590, race 2+1144
Nov 19 19:04:07 s412ffrt54 kernel: Free swap  = 0kB
Nov 19 19:04:07 s412ffrt54 kernel: Total swap = 530136kB
Nov 19 19:04:07 s412ffrt54 kernel: Out of Memory: Killed process 4435 (mysqld-max).

was kann ich tun?

MYSQL 4.0.26
Suse linux 9.2
root server von s4y

Roger Wilco
Administrator
Administrator
Posts: 6001
Joined: 2004-05-23 12:53

Re: Can't init databases mysql 4.0.26

Post by Roger Wilco » 2005-11-20 10:45

Entweder du verzichtest ganz auf InnoDB (skip-innodb in die my.cnf) oder du korrigierst deine InnoDB-Logs. Am einfachsten (aber auch am radikalsten) wäre es, die Datein ib_logfile0 und ib_logfile1 zu löschen. Danach sollte MySQL wieder starten.

memo1003
Posts: 24
Joined: 2005-07-08 23:34

Re: Can't init databases mysql 4.0.26

Post by memo1003 » 2005-11-20 11:36

habe meninen mysql gesichert und alles neu instaliert da nicht mehr was gebracht hatte :cry:

auf dem server laufen nur phpbb foren, kann ich da auf InnoDB verzichten?