It actually restarted automatically.

Basically, I was running 2 copy() jobs in 2 different Unix sessions. Each file has about 50 million records, and I had over 60 files.

Then the questions becomes, is there a better way to load these csv files? More efficient and crash proof method?

On Sun, May 10, 2009 at 3:48 PM, Fabian Groffen Fabian.Groffen@cwi.nl wrote:

On 10-05-2009 15:43:26 -0400, Mag Gam wrote:

...

While loading a lot of data, I noticed my MonetDB crashed

In the log files I get this error:

MSG merovingian[17779]: database 'demo' already running since 2009-05-10 14:12:21, up min/avg/max: 66/21400/101789, crash average: 0.00 0.00 0.00 (9-8=0) MSG merovingian[17779]: proxying client 127.0.0.1:51882 for database 'demo' to mapi:monetdb://srv011:50001/ MSG merovingian[17779]: starting a proxy failed: failed to connect: Connection refused ERR merovingian[17779]: client error: failed to connect: Connection refused MSG merovingian[17779]: database 'demo' already running since 2009-05-10 14:12:21, up min/avg/max: 66/21400/101789, crash average: 0.00 0.00 0.00 (9-8=0)

Any ideas?

Have you tried stopping 'demo' and starting it again?  It seems not to respond any more to connections.

---

The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

'top' isn't really showing anything.

Just that 60% of the 1 CPU was being utilized.

On Sun, May 10, 2009 at 3:53 PM, Martin Kersten Martin.Kersten@cwi.nl wrote:

Fabian Groffen wrote:

...

On 10-05-2009 15:43:26 -0400, Mag Gam wrote:

...

While loading a lot of data, I noticed my MonetDB crashed

In the log files I get this error:

MSG merovingian[17779]: database 'demo' already running since 2009-05-10 14:12:21, up min/avg/max: 66/21400/101789, crash average: 0.00 0.00 0.00 (9-8=0) MSG merovingian[17779]: proxying client 127.0.0.1:51882 for database 'demo' to mapi:monetdb://srv011:50001/ MSG merovingian[17779]: starting a proxy failed: failed to connect: Connection refused ERR merovingian[17779]: client error: failed to connect: Connection refused MSG merovingian[17779]: database 'demo' already running since 2009-05-10 14:12:21, up min/avg/max: 66/21400/101789, crash average: 0.00 0.00 0.00 (9-8=0)

Any ideas?

Have you tried stopping 'demo' and starting it again?  It seems not to respond any more to connections.

Are you sure it crashed? isn't it performing some expensive constraint checking. Look at top to see what it is doing.

...

---

The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

---

The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users