StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18056363
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-05T10:49:38.907
FavoriteCount
0
LastActivityDate
2013-08-05T11:19:50.740
LastEditDate
2013-08-05T11:19:50.740
LastEditorUserId
1700513
OwnerUserId
1700513
ParentId
18053527
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
In Linux threads are defined as "tasks". Each task is an individual execution unit within a process. They all have their individual task id <code>tid</code> - related to process ids (<code>pid</code>s). Each process comes with one main task when it starts and that "main" task identifies the process and indeed the process id <code>pid</code> is the task id <code>tid</code> of the main task. The process state in terms of execution resembles that of the main task including the status <code>R</code>, <code>D</code>, <code>S</code>... So if your process is marked as <code>D</code> (Disk sleep) it just means that the main task is in disk sleep. All other tasks (threads) could be doing anything else. Check <code>/proc/[pid]/task/[tid]/stat</code> for individual task states. Also <code>ps -eLf</code> to display ps entries for tasks. Try this code: <pre><code>#include <pthread.h> #include <stdlib.h> #include <stdio.h> void * thread_sleep() { long long int i = -1; while (i--); exit(0); return NULL; } int main() { pthread_t thread; pthread_create(&thread, NULL, thread_sleep, NULL); getchar(); return 0; } </code></pre> Run it and do <pre><code>cat /proc/$PID/stat cat /proc/$PID/task/*/stat </code></pre> You will notice that the process has status <code>S</code> (waiting for terminal input) as does the first task (same <code>tid</code> as the process <code>pid</code>) while the other thread is <code>R</code>. If you set <code>i</code> to something smaller it will actually finish at some point.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIs thread still running when the process in "Disk Sleep"?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSergey L.
UserOwnerUserId
1. USSergey L.
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POIs thread still running when the process in "Disk Sleep"?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.