Package: mysql-server Version: 3.23.49-8.11 Severity: important After upgrading this package from security.debian.org, the delete operation (at least) has broken. I have a cron job which deletes all data in certain tables, and repopulates them from an external data source. This is achieved by simply doing "delete from tbl_foo", and this operation now fails with the following error.
mysql> delete from tbl_Country; ERROR 1: Can't create/write to file './journals/tbl_Country.ISM' (Errcode: 17) Deleting single rows still works, as do inserts. OS errcode 17 is "File exists", and the named file does indeed exist, owned by mysql:mysql, permissions 640. The parent directory has the same ownership, with permissions 700. Testing this by creating a new database, creating a table, then inserting some rows and trying "delete from test_table" fails with the same error. Tagged as important as a security update has effectively caused a severe breakage in the operation of the database for me, and I'm still trying to figure out what's changed. There have been no other changes to system setup or configuration. -- System Information Debian Release: 3.0 Architecture: i386 Kernel: Linux castor 2.4.27 #1 SMP Tue Aug 24 10:28:48 BST 2004 i686 Locale: LANG=C, LC_CTYPE=C Versions of packages mysql-server depends on: ii adduser 3.47 Add and remove users and groups ii debconf 1.2.35 Debian configuration management sy ii libc6 2.2.5-11.8 GNU C Library: Shared libraries an ii libdbi-perl 1.21-2woody2 The Perl5 Database Interface by Ti ii libmysqlclient10 3.23.49-8.11 mysql database client library ii libstdc++2.10-glibc2.2 1:2.95.4-11woody1 The GNU stdc++ library ii libwrap0 7.6-9 Wietse Venema's TCP wrappers libra ii mysql-client 3.23.49-8.11 mysql database client binaries ii perl 5.6.1-8.9 Larry Wall's Practical Extraction ii psmisc 20.2-2.1 Utilities that use the proc filesy ii zlib1g 1:1.1.4-1.0woody0 compression library - runtime -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
