-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Package: ulogd-mysql Version: 1.02-1 Severity: important
ulogd-mysql plugin destrois its database (The only table ulog) arround once a day. If I fix the problem by "myisamch -r ..." the table will be destroid directely afterwards again. This game runs 1-2 times then the database will stay ok for arround one day (Sometimes two). The First Error looks in myisamch: Checking MyISAM file: /var/lib/mysql/ulogd/ulog.MYI Data records: 358065 Deleted blocks: 0 - - check file-size - - check record delete-chain - - check key delete-chain - - check index reference - - check data record references index: 1 myisamchk: error: Found key at page 5839872 that points to record outside datafile - - check record links myisamchk: error: Checksum for key: 1 doesn't match checksum for records myisamchk: error: Checksum for key: 2 doesn't match checksum for records MyISAM-table '/var/lib/mysql/ulogd/ulog.MYI' is corrupted Fix it using switch "-r" or "-o" The second directely after the fix will report no error but about one hour later I get the following error: Checking MyISAM file: /var/lib/mysql/ulogd/ulog.MYI Data records: 358251 Deleted blocks: 0 - - check file-size myisamchk: error: Size of datafile is: 42633964 Should be: 42649968 - - check record delete-chain - - check key delete-chain - - check index reference - - check data record references index: 1 myisamchk: error: Found 7600 keys of 358251 - - check record links myisamchk: error: Record-count is not ok; is 358120 Should be: 358251 myisamchk: warning: Found 358120 parts Should be: 358251 parts MyISAM-table '/var/lib/mysql/ulogd/ulog.MYI' is corrupted Fix it using switch "-r" or "-o" It is no filesystem issue as I have some more databases on the same filesystem which are correct. - -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (800, 'testing'), (70, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.4.29 Locale: LANG=de_DE, LC_CTYPE=de_DE (charmap=ISO-8859-1) (ignored: LC_ALL set to de_DE) Versions of packages ulogd-mysql depends on: ii libc6 2.3.2.ds1-20 GNU C Library: Shared libraries an ii libmysqlclient10 3.23.56-2 LGPL-licensed client library for M ii ulogd 1.02-1 The Netfilter Userspace Logging Da - -- no debconf information - -- Klaus Ethgen http://www.ethgen.de/ pub 2048R/D1A4EDE5 2000-02-26 Klaus Ethgen <[EMAIL PROTECTED]> Fingerprint: D7 67 71 C4 99 A6 D4 FE EA 40 30 57 3C 88 26 2B -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) iQEVAwUBQhZIuJ+OKpjRpO3lAQKFRQgAiaUNQ6nt7isKEBDuHVrUtNGns6MMOIUv wAyYc0r4bv03H5Wfl9oJphotPYmqbGZEAUscx3jjWX9yR74OK8sSG2VLZS5TLTkt 0GP7746prdaUunHGr3QNxb8ynW4oJ/C0ZPGk8gebEMzyUXcN3buToUVJQuRnEZH3 mZChzm78yfr3zSpETZvuFqhDuLru1KXQBe9JPQ0E2k6m2VsIqji1dbzpTelh3T8J 91kdKaWeCfry6tqAuY+0c7hh6ccvRaKtYSAC/BjDGIOiyBZgTRdR5HSo8/TaC685 0LGZdgJwk+cMDZt2uwsJy4okj2b8O7RNJiUkINicDpPl6zVxNoRItg== =GA7D -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
