Hi,

I've tried to load a good chunk of the Internet census into our MonetDB
- about 100M rows. Although the import scripts completed, it seems it
shot down Monet:

2013-08-28 04:10:35 MSG merovingian[9857]: database 'census' (10773) was
killed by signal SIGBUS
2013-08-28 10:47:59 MSG merovingian[9857]: database 'census' has crashed
after start on 2013-08-28 01:14:07, attempting restart, up min/avg/max:
4m/4d/3w, crash average: 1.00 0.10 0.03 (8-7=1)

This is then followed by

2013-08-28 10:48:32 MSG census[19161]: # still reading write-ahead log
"/mnt/monetdb/census/sql_logs/sql/log.990" (0% done)
[...]
2013-08-28 10:53:12 MSG census[19161]: # still reading write-ahead log
"/mnt/monetdb/census/sql_logs/sql/log.990" (4% done)
2013-08-28 10:53:34 MSG merovingian[9857]: database 'census' (19161) has
crashed (dumped core)

Restarting it, yielded the same results for a few times. Once or twice
it got to 35% in the WAL

2013-08-28 15:34:27 MSG census[14420]: # still reading write-ahead log
"/mnt/monetdb/census/sql_logs/sql/log.990" (35% done)
2013-08-28 15:34:59 MSG merovingian[9857]: database 'census' (14420) has
crashed (dumped core)
2013-08-28 15:34:59 ERR merovingian[9857]: client error: database
'census' has crashed after starting, manual intervention needed, check
monetdbd's logfile for details
2013-08-28 15:34:59 ERR merovingian[9857]: client error: client (local)
sent challenge in incomplete block:
2013-08-28 15:34:59 ERR merovingian[9857]: client error: client (local)
sent challenge in incomplete block:
2013-08-28 15:34:59 MSG merovingian[9857]: database 'census' has crashed
after start on 2013-08-28 14:43:34, attempting restart, up min/avg/max:
4m/4d/3w, crash average: 1.00 0.90 0.30 (16-7=9)

Since then, it won't start (I don't know what caused the client error BTW).

Data loss is not a concern, but we'd sure like to know if this can be
fixed or if we should start looking at another DB...

Thanks for any help,
Ralph

--
Ralph Holz
I8 - Network Architectures and Services
Technische Universität München
http://www.net.in.tum.de/de/mitarbeiter/holz/
Phone +49.89.289.18043
PGP: A805 D19C E23E 6BBB E0C4  86DC 520E 0C83 69B0 03EF
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list