Brian,
the error message means that you updated a secondary
key of a row but InnoDB did not find the index entry
in the secondary index. The bug may be due to
an error in purge, insert buffer, or the buffer
pool. I am currently running tests on this and
studying it.
Could you please run CHECK TABLE on the table
webassign.rosterInnoDB and send the output to
me?
Also the CREATE TABLE statement would help in
hunting the bug.
You can repair your table by dropping it and
reimporting it, but the output of CHECK TABLE
should be seen first.
Regards,
Heikki
>Hello,
>
>I'm using mysql 3.23.40 with InnoDB tables. Recently I've been
>seeing several of the following messages in my logs related to indexes.
>InnoDB: error in sec index entry update in
>InnoDB: index user_ table webassign/rosterInnoDB: tuple 0: len 50; hex \
>646a61646f40727574676572732020202020202020202020202020202020202020202020202
02020202020 \
>20202020202020; asc [username] ;; 1:
len 3; hex \
>000cfa; asc ;; InnoDB: record RECORD: info bits 0 0: len 50; hex \
>646a61636f62736540756d642e756d696368202020202020202020202020202020202020202
02020202020 \
>20202020202020; asc [username] ;; 1: len 3; hex
000044; asc D;;
>I'm not sure what other information to give to describe the problem.
>I do not know exactly what caused the errors to appear nor how to
>duplicate the errors.
>I see no ill effects of the error. I have omitted the usernames reported
>in the error above but those users are still retrievable.
>Please let me know if more information is needed or if anyone else
>has experienced this problem.Thanks very much in advance,Brian Pittman
>System: SunOS 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-4Architecture: sun4
>Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
>GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs
>gcc version 2.95.3 20010315 (release)
>Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''LIBC:
>-rw-r--r-- 1 bin bin 1607728 Dec 28 1999 /lib/libc.a
>lrwxrwxrwx 1 root root 11 Apr 14 1998 /lib/libc.so ->
./libc.so.1
>-rwxr-xr-x 1 bin bin 1014088 Dec 28 1999 /lib/libc.so.1
>-rw-r--r-- 1 bin bin 1607728 Dec 28 1999 /usr/lib/libc.a
>lrwxrwxrwx 1 root root 11 Apr 14 1998 /usr/lib/libc.so ->
./libc.so.1
>-rwxr-xr-x 1 bin bin 1014088 Dec 28 1999 /usr/lib/libc.so.1
>Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock \
>--with-low-memory --with-mit-threads=yes --without-perl
--enable-thread-safe-client \
>--with-berkeley-db --with-innodb
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
