Databases
StackOverflow2013
Postsdbo
POApache locks session files for no reason
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POApache locks session files for no reason
    primarykey
    data
    text
    <p>I keep running into stale, locked, (php) session files on my apache server which keep the threads from closing and thus eating away my server resources.</p> <p>Its an Ubuntu box and having session_write_close(); in the automatically appended script doenst help. I keep ending up with locked session files which are local (memory disk) and with no other processes trying to access it... </p> <p>I just dont know where to look anymore...</p> <hr> <p>To clearify things a bit:</p> <ul> <li>we're running ubuntu stock apache2 (MPM prefork i believe) with standard PHP session handling</li> <li>the sessions are stored on a ramdrive so fsck-ing the thing wont do much ;)</li> </ul> <p>The problem arises inconsistently and on different time intervals. But after looking at the open files (via <code>lsof | grep sess_</code>) i keep seeing apache2 threads holding on to those files.</p> <pre><code>apache2 28405 www-data 30uW REG 0,18 38652 2737432 /data/ramdrive/sess_8f95700e5d2ed8daf2e2d12625ed7d53 </code></pre> <p>Since i dont have the issue ATM i have no actual live data, but it looked something like this: doing an strace -p on the aforementioned id i would see something in the line of </p> <pre><code>F_LOCK(30, </code></pre> <p>something... doing an <code>ls -l /proc/[apache pid]/fd/30</code> (BTW everytime its always 30!) it would point to some session file</p> <p>The actual file contained no weird stuff and looked pretty sane... </p> <p>Does the fact that when it happened all FD's pointed to 30 (so it would end up being <code>/proc/123123/fd/30</code> and <code>/proc/123124/fd/30</code> etc) does that have to do with anything?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGekkie
    1. USGekkie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POApache locks session files for no reason
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO"MPM prefork i believe" If you're using both Apache 2 and PHP that come with Ubuntu, then yes. It forces `apache2-mpm-prefork` (or the not-necessarily stable `apache2-mpm-itk`) if you install `libapache2-mod-php5`.
      singulars
      1. POApache locks session files for no reason
      1. USPowerlord
    2. COI'm noticing a similar problem. No solution as yet to it. Restarting the apache process at regular intervals is not a viable solution for me however.
      singulars
      1. POApache locks session files for no reason
      1. USDavid Gillen
 

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