Hi guys, I've been running 4.0.12 on Linux for a while now without any problems, however recently I've been having problems. This is an extract from the mysql.err log file for yesterday....
Number of processes running now: 1 mysqld process hanging, pid 8304 - killed 030813 09:25:24 mysqld restarted Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line /usr/sbin/mysqld: ready for connections. Version: '4.0.12-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 mysqld: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned int, int, int): Assertion `pos != (~(my_off_t) 0)' failed. Number of processes running now: 1 mysqld process hanging, pid 25840 - killed 030813 09:41:17 mysqld restarted Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line /usr/sbin/mysqld: ready for connections. Version: '4.0.12-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 mysqld: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned int, int, int): Assertion `pos != (~(my_off_t) 0)' failed. Number of processes running now: 1 mysqld process hanging, pid 28646 - killed 030813 10:27:35 mysqld restarted Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line /usr/sbin/mysqld: ready for connections. Version: '4.0.12-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 mysqld: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned int, int, int): Assertion `pos != (~(my_off_t) 0)' failed. And so on... the log file was 28Kb in size. Anyone got any idea why the assertion is failing and whether the warning about user change needs fixing and what I need to do to fix it! And whether the assertion has anything to do with mysqld hanging. TIA Steve Childs. Experienced Newbie. ;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]