0

my MySQL Server doesnt starts because a file is missing.

The funny thing is that the file is visible for ls -al but other commands cant find the file.

ls -al shows the files

And thats the error. A few files works.

stat cant find the file or directory

If i use shutdown -rF now to check the filesystem i get no error.

Whats the problem? :(

Filesystem: EXT3
Debian version: 6.0.10

Some informations about the disk

PatrickB
  • 3,225
  • 5
  • 31
  • 55
  • verify that *all* your partitions are checked i.e. sda1 and sda5 '$ sudo dumpe2fs /dev/your-partition |grep "Last checked"' Because shutdown -rF sometimes didn't work for me at debian. – hbogert Aug 04 '14 at 09:08
  • sda1: Mon Aug 4 10:29:52 2014 / sda2: Attempt to read block from filesystem resulted in short read (at the try to open /dev/sda2) Cant find a valid Filesystem-Superblock. / sda5: Bad magic number in super-block in try to open /dev/sda5 (no valid file system super block) – PatrickB Aug 04 '14 at 09:18
  • can you try mysqlbinlog binlog_name to see if the file is broken? Binlogs have the proper permissions? Did you tried to start without binlog enable? – Antonios Aug 04 '14 at 09:28
  • Hmm with each dpkg --configure -a the /var/lib/mysql directory changes their owner to root/root -.- – PatrickB Aug 04 '14 at 09:50
  • Works @Anotnis. I disabled the binlog ^^ – PatrickB Aug 04 '14 at 09:55

1 Answers1

0

Disabling the mysql binlog was the fix.

Thanks @Antonis

PatrickB
  • 3,225
  • 5
  • 31
  • 55