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
ThreadManager failed to create thread LogFlusher: boost::thread_resource_error
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: ThreadManager failed to create thread LogFlusher: boost::thread_resource_error
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
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](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.