Databases
StackOverflow2013
Postsdbo
POWebsite Down After Performing PHP Action
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWebsite Down After Performing PHP Action
    primarykey
    data
    text
    <p>Say I have a website hosted on a remote server. I navigate to a page on this website and attempt to perform a specific action (the details of which I can go into more depth if necessary, but for the time being let me just say that the action involves running a program on the server with data obtained from a database.)</p> <p>The page just continually loads. So, I attempt to navigate to the main website. That now continually loads without resolve as well. After about a day the website comes back, so perhaps there is some automated process that kills tasks after a certain time has passed. My question is this:</p> <p>Am I able to kill this task or perform any action to allow me to navigate to the website without waiting a full day? I can go into more detail if necessary.</p> <p>Thanks.</p> <p>By request, some more in-depth information.</p> <p>The PHP script retrieves text-based information from the database. Based on this information the PHP script calls an executable program. The output from the executable is output to the screen.</p> <p>I've checked mysql processlist and found a process that took a particularly long time. I killed it, so it may be that the executable is continually running. If so, how would I go about determining this, and if not is there anything else it could potentially be? Thanks. </p> <p><strong>Solved</strong>: Alright, so basically Mike Purcell's advice which was to show the process list of mysql processes and kill any ones that I saw that took a substantially long time. Once that was done, it was just a matter of restarting mysql and httpd. Thanks again to everyone who commented.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USVincent Russo
    1. USVincent Russo
    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
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWebsite Down After Performing PHP Action
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs rest of the site database-driven, and using the same exact database (user credentials, etc?)
      singulars
      1. POWebsite Down After Performing PHP Action
      1. USpp19dd
    2. COthe possibilities approach infinity.
      singulars
      1. POWebsite Down After Performing PHP Action
      1. This table or related slice is empty.
    3. COCan you give more detail like the synoptic of action: Your input in browser, does this call a php script, then the script an executable, etc... Because you do not provide enough info and like Dagon said, the possibilities approach infinity.
      singulars
      1. POWebsite Down After Performing PHP Action
      1. USgrifos
 

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