Sreejith, I'm afraid with the information you provide, we cannot help much (if at all). In general, there are no specific setting or limitation for parallel loading, other than that the latter, if performed using MonetDB's standard COPY INTO statements, is governed by MonetDB transaction processing according to MonetDB's optimistic concurrency protocol. This might results in abortions due to (potential) conflicts, but should not lead to crashes. Given that we have no idea what you shell scripts, ControlM process and or .dat files look like, or how they work, we cannot say anything about them. Also, you log snippet only shows the restart message after the crash. It would (have) be(en) more informative to see also all message since (and including) the last successful client connection before the crash until (and including) the first successful client connection after the restart. Best, Stefan ----- On Mar 27, 2018, at 8:35 AM, Sreejith Sharma Sreejith.Sharma@harman.com wrote:
All,
We have a scenario where we load the data via the shell scripts from .dat file using ControlM process. We notice the DB crashes intermittently post the load. Is there any limitation or settings on multiple session loads? Or what happens if load is parallel?
2018-03-27 00:21:54 MSG merovingian[45726]: database 'TEST_MDP' has crashed after start on 2018-03-13 05:04:41, attempting restart, up min/avg/max: 2m/4d/2w, crash average: 1.00 1.00 0.80 (35-9=26
MonetDB : 11.27.13
OS : CentOS 6
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |