Re: [MonetDB-users] Segmentation fault

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. 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