>Description:
We have to tables: t_daten(autoincrement on dat_id) and t_daten_detail. For each
record in t_daten are on or more records in t_daten. The records are filled in from a
java program via jdbc. An another program selects the data. At the the data will be
deleted with: delete from t_daten, t_daten_detail using t_daten, t_daten_detail where
t_daten.dat_id = t_daten_detail.ddet_dat_id and dat_id < xxx. Once a day the table
crashes because of the error 145: If I repair the the the following information is
printed:(I do not know to complete text) link points outside .. of file..
I think that the indexfile is corrupted. Is it possible that there is a bug in the new
version with the multi-table delete-statement?
There are about 155 inserts in 3 minutes in t_daten and about 370 inserts in
t_daten_detail in 3 minutes.
>How-To-Repeat:
inserting many rows in both tables and parallel deleting rows of this tables
with the following statemnt:
delete from t_daten, t_daten_detail using t_daten,
t_daten_detail where t_daten.dat_id = t_daten_detail.ddet_dat_id and dat_id < xxx;
t_daten:
create table t_daten
(
dat_id bigint not null AUTO_INCREMENT,
dat_ts timestamp,
dat_imp_ts timestamp,
dat_boe_id varchar(5),
dat_wp varchar(30),
dat_action varchar(5),
dat_exch_ident varchar(8),
primary key (dat_id)
);
t_daten_detail:
create table t_daten_detail
(
ddet_dat_id bigint not null,
ddet_feld varchar(30) not null,
ddet_wert varchar(40),
primary key ddet_dat_id, ddet_feld
);
>Fix:
make two deletes on each table could work. We still haven't tested.
>Submitter-Id: <submitter ID>
>Originator: Markus Hager
>Organization:
BLUeBULL Capital Markets Consulting GmbH
>MySQL support: [none ]
>Synopsis: <sorry, I don't know what to write>
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-4.0.9-gamma (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.39 Distrib 4.0.9-gamma, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.9-gamma
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 21 days 3 hours 28 min 4 sec
Threads: 6 Questions: 12508338 Slow queries: 76 Opens: 39656 Flush tables: 1 Open
tables: 4 Queries per second avg: 6.847
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux arger.in.bluebull.com 2.4.18-24.8.0 #1 Fri Jan 31 06:51:30 EST 2003 i686
i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking
--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Jan 31 14:31 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x 2 root root 1235468 Sep 6 01:12 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 6 00:59 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 6 00:50 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static'
'--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb'
'--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server'
'--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6
-fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc'
---------------------------------------------------------------------
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
