>Description:
Corrupted tables cause REPLACE to complain about Duplicate entries.
Or maybe REPLACE gets confused and causes table corruption.
It doesn't happen all of the time which is the frustrating part of this.
>How-To-Repeat:
DBD::mysql::db do failed: Duplicate entry '309861948-sadamswhite'
for key 6 at /opt/Dante/bin/lemure line 965, <GEN6> chunk 611488.
REPLACE INTO Stop_981763200 VALUES (981759118,981763200,
'sadams',172045839,32,0,2,0,'309861948','6105278054','6778111',1,
3634676432,'rcn.com',4082,45,48000,28800,1074007340,277044,9807938,1);:
Duplicate entry '309861948-sadams' for key 6
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Joseph Christian
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.28-gamma (Source distribution)
>Environment:
System: SunOS lager.auth.rcn.net 5.6 Generic_105181-11 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 /opt/lib/gcc-lib/sparc-sun-solaris2.6/egcs-2.91.60/specs
gcc version egcs-2.91.60 19981201 (egcs-1.1.1 release)
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1606856 Dec 16 1998 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jun 26 1998 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1013196 Dec 16 1998 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1606856 Dec 16 1998 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jun 26 1998 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1013196 Dec 16 1998 /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
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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