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/roster
InnoDB: tuple 0: len 50; hex
646a61646f407275746765727320202020202020202020202020202020202020202020202020202020202020202020202020;
asc [username] ;; 1: len 3; hex 000cfa; asc ;;
InnoDB: record RECORD: info bits 0 0: len 50; hex
646a61636f62736540756d642e756d6963682020202020202020202020202020202020202020202020202020202020202020;
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-4
Architecture: 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
