Re: [MonetDB-users] Segmentation fault

4 Sep 2009


      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