Bugs item #1993999, was opened at 2008-06-14 17:09
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1993999&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL 2.24
>Status: Closed
>Resolution: Works For Me
Priority: 6
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: copy into platex
Initial Comment:
To simulate the crash just create the table:
CREATE TABLE PlateX(
plateID bigint NOT NULL,
spRerun int NOT NULL,
mjd int NOT NULL,
plate smallint NOT NULL,
tile smallint NOT NULL,
mapMjd int NOT NULL,
nExp smallint NOT NULL,
tai real NOT NULL,
raBoresight float NOT NULL,
decBoresight float NOT NULL,
taiHMS varchar(64) NOT NULL,
expTime real NOT NULL,
expTimeB1 real NOT NULL,
expTimeB2 real NOT NULL,
expTimeR1 real NOT NULL,
expTimeR2 real NOT NULL,
helioRV real NOT NULL,
ra real NOT NULL,
"dec" real NOT NULL,
cx float NOT NULL,
cy float NOT NULL,
cz float NOT NULL,
htmID bigint NOT NULL,
sn1_0 real NOT NULL,
sn1_1 real NOT NULL,
sn1_2 real NOT NULL,
sn2_0 real NOT NULL,
sn2_1 real NOT NULL,
sn2_2 real NOT NULL,
dateObs varchar(12) NOT NULL,
timeSys varchar(8) NOT NULL,
quality varchar(12) NOT NULL,
name varchar(32) NOT NULL,
program varchar(16) NOT NULL,
version varchar(64) NOT NULL,
observer varchar(64) NOT NULL,
camVer varchar(64) NOT NULL,
spec2DVer varchar(64) NOT NULL,
utilsVer varchar(64) NOT NULL,
spec1DVer varchar(64) NOT NULL,
readVer varchar(64) NOT NULL,
combVer varchar(64) NOT NULL,
extinction_u real NOT NULL,
extinction_g real NOT NULL,
extinction_r real NOT NULL,
extinction_i real NOT NULL,
extinction_z real NOT NULL,
rOffset1 real NOT NULL,
rSigma1 real NOT NULL,
grOff1 real NOT NULL,
grSigma1 real NOT NULL,
rOffset2 real NOT NULL,
rSigma2 real NOT NULL,
grOff2 real NOT NULL,
grSigma2 real NOT NULL,
sfd_used tinyint NOT NULL,
xygrSig1 real NOT NULL,
xygrSig2 real NOT NULL,
mpgrSig1 real NOT NULL,
mpgrSig2 real NOT NULL,
mpgrOff1 real NOT NULL,
mpgrOff2 real NOT NULL,
isPrimary tinyint NOT NULL,
cartridgeID smallint NOT NULL,
plateVersion varchar(32) NOT NULL,
haMin real NOT NULL,
haMax real NOT NULL,
mjdDesign int NOT NULL,
theta real NOT NULL,
fscanVersion varchar(32) NOT NULL,
fmapVersion varchar(32) NOT NULL,
fscanMode varchar(32) NOT NULL,
fscanSpeed int NOT NULL,
programType int NOT NULL,
programName varchar(32) NOT NULL,
loadVersion int NOT NULL,
expID blob NULL,
CONSTRAINT pk_PlateX_plateID PRIMARY KEY
(
plateID
)
);
Load the file in attach. This file contains one line for insertion which will
crash the mserver.
The command to insert used was:
COPY 1 RECORDS INTO PlateX from '/ufs/goncalve/SkyServer/skyserver/PlateX.out'
USING DELIMITERS '\t', '\n';
the crash is:
>[New Thread 4060334992 (LWP 20079)]
[New Thread 4056136592 (LWP 20080)]
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 4056136592 (LWP 20080)]
0x0044c3d7 in memset () from /lib/libc.so.6
Missing separate debuginfos, use: debuginfo-install bzip2.i386 e2fsprogs.i386
glibc.i686 keyutils.i386 krb5.i386 libselinux.i386 ncurses.i386 openssl.i686
pcre.i386 readline.i386 zlib.i386
Romulo
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-06-17 09:30
Message:
Logged In: YES
user_id=43556
Originator: NO
added test to BugTracker/copy_into_crash.SF-1993999.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1993999&group_id=56967
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
