ThreadManager failed to create thread LogFlusher: boost::thread_resource_error

Use this forum to discuss Vertica error codes, what they mean and how to fix the issue that generated them

Moderator: NorbertKrupa

Post Reply
Fred Kun
Newbie
Newbie
Posts: 1
Joined: Fri Mar 17, 2017 12:19 pm

ThreadManager failed to create thread LogFlusher: boost::thread_resource_error

Post by Fred Kun » Fri Mar 17, 2017 12:31 pm

When I enter the command,it stuck
[dbadmin@mpp-2 ~]$ vsql

I check the vertica.log
2017-03-17 10:06:49.526 Init Session:0x7fb0440121c0 [Session] <INFO> [PQuery] TX:0(mpp-2-1596:0x9c15) SELECT c1, c2, c3, c4, c5 FROM bcetl.disp_type5_normal AS t ORDER BY c1,c2,c3,c4,c5 LIMIT 7 OFFSET 0
2017-03-17 10:06:49.531 Init Session:0x7fb0440121c0-a0000000005fab [Txn] <INFO> Begin Txn: a0000000005fab 'SELECT c1, c2, c3, c4, c5 FROM bcetl.disp_type5_normal AS t ORDER BY c1,c2,c3,c4,c5 LIMIT 7 OFFSET 0'
2017-03-17 10:06:49.535 Init Session:0x7fb0440121c0-a0000000005fab [Session] <INFO> [BQuery] TX:a0000000005fab(mpp-2-1596:0x9c15) SELECT c1, c2, c3, c4, c5 FROM bcetl.disp_type5_normal AS t ORDER BY c1,c2,c3,c4,c5 LIMIT 7 OFFSET 0
2017-03-17 10:06:49.536 Init Session:0x7fb0440121c0-a0000000005fab <LOG> @v_vdb_bcetl_node0002: 00000/3316: Executing statement: 'SELECT c1, c2, c3, c4, c5 FROM bcetl.disp_type5_normal AS t ORDER BY c1,c2,c3,c4,c5 LIMIT 7 OFFSET 0'
2017-03-17 10:06:49.649 Spread Client:0xa18a990 [Dist] <INFO> Dist::cancelPlan: canceling state EXECUTION COMPILED(2): a0000000005fac
2017-03-17 10:06:49.649 Spread Client:0xa18a990 [Dist] <INFO> Dist::cancelPlan: canceled state EXECUTION COMPILED(2): a0000000005fac
2017-03-17 10:06:50.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread LogFlusher: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:06:50.162 Connection listener:0xa21b620 <ERROR> @v_vdb_bcetl_node0002: {ConnectionMain} 53000/5001: ThreadManager failed to create thread Init Session: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:06:50.162 Connection listener:0xa21b620 [Session] <INFO> Connection listener exiting
2017-03-17 10:06:51.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread UDxSideProcessMonitor: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:06:51.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread WOSReaper: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:06:51.001 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread AgeOutEvents: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:06:51.001 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread Cluster Inviter: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:06:59.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread LowDiskSpaceCheck: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:07:09.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread NodeReplacer: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:07:09.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread HeartbeatLogger: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:07:09.001 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread SystemMonitor: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:07:27.191 Spread Client:0xa18a990 <PANIC> @v_vdb_bcetl_node0002: VX001/3927: Message could not be deserialized: ThreadManager failed to create thread DistCall Dispatch: boost::thread_resource_error:
LOCATION: messageReceived, /scratch_a/release/15809/vbuild/vertica/Dist/DistCalls.cpp:11485
2017-03-17 10:07:39.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread AnalyzeRowCount: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:07:39.001 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread Reaper: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:07:40.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread AddressCollector: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:09:39.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread TM Mergeout(01): boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:09:39.000 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread TM Mergeout(00): boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:09:39.001 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread RebalanceCluster: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73
2017-03-17 10:09:39.001 Timer Service:0xa4e8b30 <ERROR> @v_vdb_bcetl_node0002: {run} 53000/5001: ThreadManager failed to create thread TM Moveout: boost::thread_resource_error
HINT: Please raise the number of processes per user
LOCATION: createThread, /scratch_a/release/15809/vbuild/vertica/Session/ThreadManager.cpp:73

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1674
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: ThreadManager failed to create thread LogFlusher: boost::thread_resource_error

Post by JimKnicely » Sat Mar 18, 2017 8:49 pm

Hi Fred,

Notice the hint that is repeated over and over again in the log:
HINT: Please raise the number of processes per user

What is the process limit on v_vdb_bcetl_node0002 ?

You can use the ulimit -u command to get that answer.

Refer to this link to get an idea of what the setting should be:
https://my.vertica.com/docs/8.0.x/HTML/ ... sLimit.htm
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Error Codes”

Who is online

Users browsing this forum: No registered users and 1 guest