>Description:
>How-To-Repeat:
# Server version 3.22.14b-gamma
#
# Table structure for table 'Admin'
#
CREATE TABLE Admin (
adminid varchar(15) DEFAULT '' NOT NULL,
origin varchar(15) DEFAULT '' NOT NULL,
level enum('frontdesk','administrator','accounting','reporting') DEFAULT 'frontdesk'
NOT NULL,
PRIMARY KEY (adminid),
KEY origin (origin),
KEY level (level)
);
#
# Dumping data for table 'Admin'
#
INSERT INTO Admin VALUES ('dihen','bandung','frontdesk');
INSERT INTO Admin VALUES ('endang','salatiga','frontdesk');
INSERT INTO Admin VALUES ('hendarko','cianjur','frontdesk');
INSERT INTO Admin VALUES ('xbram','salatiga','administrator');
INSERT INTO Admin VALUES ('juni','bandung','accounting');
There were intensive and time-consuming select and update processes on other tables
(thru Perl DBI/DBD) before the simptom began. And when I shutdown the mysqld and
restart it again, the simpton disappeared. But this morning the same thing happened
again with other table (which contain approx. 1200 records) and i am sure that there
were no more than 20 select/update activities before.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: System Administrator
>Organization: StarNet ISP
>MySQL support: none [none | licence | email support | extended email support ]
>Synopsis: Incorrect select result
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.14b-gamma (Source distribution)
>Environment:
System: BSD/OS andromeda.starindo.net 3.0 BSDI BSD/OS 3.0 Kernel #0: Wed Apr 16
15:15:49 MDT 1997 [EMAIL PROTECTED]:/home/polk/sys-3.0patches/compile/GENERIC
i386
Some paths: /usr/bin/perl /usr/bin/make /usr/contrib/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: gcc version 2.7.2.1
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.004_04 built for i386-bsdos
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
