Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Okay, the problem is solved. It is a problem that will occur in every Linux server. So, if you are working with one of these, you need to read this.</p> <p>The reason was the default limit of files the Linux server had per each process.</p> <p>Seems that ever single linux server comes with this limitation of 1024 files opened by each process, you can check your limit with:</p> <pre><code># ulimit -n </code></pre> <p>To increase this number </p> <pre><code># ulimit -n 5000 (for example) </code></pre> <p>Each socket creates a new virtual file.</p> <p>For some reason my server was not displaying any error, the server just got frozen, stopping the log and no signal or evidence of anything. It was when I set up a copy of the server in another machine, when it started to send </p> <pre><code>warn: error raised: Error: accept EMFILE warn: error raised: Error: accept EMFILE warn: error raised: Error: accept EMFILE ... </code></pre> <p>Be careful because if you are not root, you will only change this for the current session and not permanently.</p> <p>Trick: If you want to cound the number of files, in this case, the number of files opened by your node process, take note of your process id and call this command.</p> <pre><code># ls -l /proc/XXXXX/fd | wc -l </code></pre> <p>Where XXXXX is the process id. This will help you to know if this is your problem, once you launch your node server, you can use this command to check if it reaches a top, and it stops growing after it gets frozen. (by default 1024 or "ulimit -n").</p> <p>If you only want to check which files are open by the process:</p> <pre><code># ls -l /proc/XXXXX/fd </code></pre> <p>Hope this can help you. Any way if you are setting up a node js server I'm pretty sure you want to do that to be sure it won't melt.</p> <p>Finally if you need help in future errors without log, you can try to <code>strace</code>ing or <code>dtruss</code>ing process</p> <pre><code># strace -p &lt;process-id&gt; </code></pre> <p>should do the job.</p>
    singulars
    1. This table or related slice is empty.
    1. PONode.js SSL server frozen, high CPU, not crashed but no connections
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJavier Cobos
    1. USJavier Cobos
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PONode.js SSL server frozen, high CPU, not crashed but no connections
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, that helped me a lot! Although I have another problem with that. You wrote that each socket create new virtual file. Now, for example if You have one user and he sends new actions through sockets then every one action creates new file. When You have 1000 users, each one send 1 socket then You will have 1000 new files? So more actions === more files and finally server must reach the limit. How did You solved that? Or maybe I do something in wrong way? For me every socket.emit action creates new files.
      singulars
      1. PO
      1. USRob
    2. COWhat do you mean with actions?, each user maintains a connection thus a file. But there'll be a new connection per tab in the browser.
      singulars
      1. PO
      1. USJavier Cobos
    3. COOh, I forgot to delete my comment after resolving my issue. I've had a bug- almost every action created connection with memcache without closing it so server's console showed me that every socket emit action create new file. After I added closing memcache connection everything is ok.
      singulars
      1. PO
      1. USRob
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload