Re: [MonetDB-users] Segmentation fault

7 Sep 2009

      I'm loading a dump-file on a Ubuntu-machine running Aug2009 version.
The file was created on a Windows-machine using the Aug2009 version.
It has not been changed.

I'm afraid I don't understand the answers.
Should I make any changes to the dump-file?

Below You find a copy of the server as well as the client consoles:

----------- Server --------------
...
ubuntu@EMMA:~$ sudo mserver5 --dbinit="include sql;"
[sudo] password for ubuntu: 
# MonetDB server v5.12.4, based on kernel v1.30.4
# Serving database 'demo', using 2 threads
# Compiled for i486-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
#warning: please don't forget to set your vault key!
#(see /etc/monetdb5.conf)
# Listening for connection requests on mapi:monetdb://EMMA:50000/
# MonetDB/SQL module v2.30.4 loaded
Segmentation fault
ubuntu@EMMA:~$
-------------------- Client -----------------------
ubuntu@EMMA:~$ sudo mclient -lsql --time
sql>\

-----Ursprungligt meddelande-----
Från: Martin Kersten [mailto:Martin.Kersten@cwi.nl] 
Skickat: den 4 september 2009 20:24
Till: monetdb-users@lists.sourceforge.net
Ämne: Re: [MonetDB-users] Segmentation fault

Stefan Manegold wrote:
...
On Fri, Sep 04, 2009 at 06:50:12PM +0200, Martin Kersten wrote:
...
...
Thank you for your fast reply.
I have attached a file with the first 100 lines.
The entire file is 1.5 GBytes, the zip is 260 Mbytes.
THank you for the snippet. One issue is already clear.
You use quoted string input without telling the system
to respect quote character. If you don't specify that,
Sten Hjelmqvist wrote:
the value between two field separators is interpreted
as the complete string value.
Was/is that also already the case in the "old" bulk loader in the Aug2009
release?
Indeed, in the august09 version it is not yet needed.
# MonetDB/SQL module v2.32.0 loaded
....
&3
&2 2 -1
&1 0 2 3 2
% sys.dim_store,	sys.dim_store,	sys.dim_store # table_name
% id,	storenumber,	name # name
% smallint,	smallint,	char # type
% 1,	1,	50 # length
[ 1,	3,	"Butik #3                                          "	]
[ 2,	5,	"Matpressen
...
The following applied to your script works.
COPY 2 RECORDS INTO "dim_store" FROM stdin USING DELIMITERS '\t','\n','"';
...
/Sten
-----Ursprungligt meddelande-----
Från: Martin Kersten [mailto:Martin.Kersten@cwi.nl] 
Skickat: den 4 september 2009 16:16
Till: Communication channel for MonetDB users
Ämne: Re: [MonetDB-users] Segmentation fault
Sten Hjelmqvist wrote:
...
Using MonetDB Aug 2009 on a Ubuntu Server 9.04 with 4Gbyte memory and 
60Gbyte free disk space.
I import a large database, ~1.5Gbyte ,  using \
After a while the database exits with msg: ">Segmentation fault"
This is a message that should not have happened.
What is in that file? MonetDB SQL statements or csv tuples?
Can you sent a snippet (first part).
regards, Martin
Can I reconfigure the database to avoid this?
---------------------------------------
Sten Hjelmqvist
DataKonsult
MERdata AB
Sveavägen 33, 111 34 Stockholm
Mobil    : 0708 305616
E-mejl   : sten.hjelmqvist@merdata.se mailto:sten.hjelmqist@merdata.se
Webb     : www.merdata.se http://www.main.se/
---------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
------------------------------------------------------------------------
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
------------------------------------------------------------------------
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users