We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How can I correlate "merge phase X" messages in the logs with a specific process? — Vertica Forum

How can I correlate "merge phase X" messages in the logs with a specific process?

Aniket_SchneideAniket_Schneide
in General Discussion
We have been seeing messages like this during periods where Vertica is responding particularly slowly: 2013-05-26 09:01:38.816 nameless:0x2aab3caa78c0 [EE] Beginning intermediate merge phase 1: 346 buffers to merge in increments of 19. The session IDs for these events don't seem to correspond to anything else. Are these tuple mover events? Is there any way to determine which specific processes these messages are being generated by?

Comments

  • Aniket_SchneideAniket_Schneide
    Bumping this since we just ran into it again. Still not sure what these messages mean.
  • Prasanta_PalPrasanta_Pal - Select Field - Employee
    The log lines are not related with Merge out. Generally merge out logs would have tags like "[TM] " in place of "[EE] ". So these lines are related with some other Vertica internal process or may be logging something about WOS level activity.
  • Aniket_SchneideAniket_Schneide
    What internal process other than the tuple mover would be merging down so much data as to put CPU load on the cluster?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...