TrueMember Posted April 14, 2020 Share Posted April 14, 2020 Hi folks, I'm trying do a system like a queue, but doesn't work like i expected. OS: Windows (IIS) PHP: 5.2 So, let me tell you, what i'm doing. 1º Click in one button and insert the entry into database $stmt = odbc_prepare($conn, 'INSERT INTO queue (ask_date, run_date, executed, user_id) VALUES (GETDATE(), NULL, 0, ?)'); 2º After that i will run a script to check values executed = 0 $handle = new COM('WScript.Shell'); $handle->Run("php generate.php", 0, false); 3º Check values executed = 0 and update de column executed to 1 (generate.php) $sql = "SELECT * FROM queue WHERE executed=0;"; $rsQueue = odbc_exec($conn, $sql); while (odbc_fetch_row($rsQueue )) { //code here } My problem is, when i click in button it will open always new process (php.exe). (2 clicks - 2 processes; 3 clicks - 3 processes; etc..) My ideia is, first button click execute the script (2º) but the other times if script is running, only add the content to queue table to be executed in current process. Someone have any ideia? Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/ Share on other sites More sharing options...
gw1500se Posted April 14, 2020 Share Posted April 14, 2020 Can you not have the script check itself? If there is already a copy running, just exit. The PHP script won't know or care either way. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576821 Share on other sites More sharing options...
kicken Posted April 14, 2020 Share Posted April 14, 2020 Dont launch your second script from the first. Set it up as a system service (using nssm) or as a scheduled task. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576822 Share on other sites More sharing options...
TrueMember Posted April 14, 2020 Author Share Posted April 14, 2020 1 hour ago, gw1500se said: Can you not have the script check itself? If there is already a copy running, just exit. The PHP script won't know or care either way. How do you think I can do that? I don't got your point. 1 hour ago, kicken said: Dont launch your second script from the first. Set it up as a system service (using nssm) or as a scheduled task. Why? I need lunch to execute the task immediately. I can shedule a job, but i need it run at every 5 minutos to check any entry to be executed. (i have another jobs and shouldn't not be a good solution) Thanks all Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576826 Share on other sites More sharing options...
gw1500se Posted April 14, 2020 Share Posted April 14, 2020 When the script starts check for a specific file in, say, \temp. If it is there, exit. If it is not then create the file and proceed. You will need to remove the file when the script exits and manage the file if the script or machine crashes. With Kicken's suggestion, set up your schedule for the script to be executed every 5 minutes. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576827 Share on other sites More sharing options...
TrueMember Posted April 14, 2020 Author Share Posted April 14, 2020 5 minutes ago, gw1500se said: When the script starts check for a specific file in, say, \temp. If it is there, exit. If it is not then create the file and proceed. You will need to remove the file when the script exits and manage the file if the script or machine crashes. Ok, but i have another question to you. Script is running and i write something in one folder but if someone click in button when the script is running? I'm inside the while loop, i will get the new rows added with executed=0? 5 minutes ago, gw1500se said: With Kicken's suggestion, set up your schedule for the script to be executed every 5 minutes. I don't like this option, because i have another jobs running and the server is very weak. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576829 Share on other sites More sharing options...
gw1500se Posted April 14, 2020 Share Posted April 14, 2020 Up to now, based on your OP, the implication was that script 2 was independent. Now you need to explain what that script does and how it interacts with 1 and 3. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576831 Share on other sites More sharing options...
TrueMember Posted April 14, 2020 Author Share Posted April 14, 2020 29 minutes ago, gw1500se said: Up to now, based on your OP, the implication was that script 2 was independent. Now you need to explain what that script does and how it interacts with 1 and 3. Of course. Second point call an independent script (generate.php). The script include a while loop (point 3) and inside the "while" will read each line (with executed=0), with values stored in database i will call a form (via curl) and i go to save the html code returned (each iteration can take 40seconds). Do you understood? Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576836 Share on other sites More sharing options...
kicken Posted April 14, 2020 Share Posted April 14, 2020 1 hour ago, TrueMember said: Why? I need lunch to execute the task immediately. I can shedule a job, but i need it run at every 5 minutos to check any entry to be executed. (i have another jobs and shouldn't not be a good solution) Is there a reason you're running it as a separate task in the first place? Most of the time this is done because the work can be time consuming and you don't want the user to have to wait and trying to accomplish that with on-demand task launching can be problematic in PHP in my experience. The best way to accomplish that kind of separation is to simply keep the scripts separate entirely using either a scheduled task or service for one half. There's generally nothing wrong with setting up a job to just run every minute (or whatever you require) to check for work. If there is some, do it. If there isn't, exit. It might feel wasteful to run a script over and over with nothing to do but it's really not an issue and doesn't need to be avoided. The downside to a scheduled task is you can only run it once a minute, if you need faster response times than a minute then you move to a service and either check for work more frequently or communicate with the service via a socket or a job server/queue server (gearman, redis, beanstalked, memcached, etc). For example, I have an application that allows admins to import user accounts from LDAP. The process can take a bit for large imports so similar to you I just INSERT a record into an ldap_import_request table from my web app. On the server I use nssm to run a PHP script as a service and that script essentially runs a loop looking for new records. while (true){ $pendingRequests = loadPendingImportRequests(); foreach ($pendingRequests as $request){ processImportRequest($request); } sleep(1); //Avoid eating up CPU when idle. } You can get more advanced if you want, but I find this simple loop/table setup is fairly effective. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576840 Share on other sites More sharing options...
TrueMember Posted April 14, 2020 Author Share Posted April 14, 2020 1 hour ago, kicken said: Is there a reason you're running it as a separate task in the first place? Yes, actualy the results shows imediatly, but, i have many problem with many requests at same time, because, as i said before, the server is very weak and old (can't be changed). The server blocks and need be restarted some times a day. So, I thought in that solution, each time every user click in button, the content go to the queue and can be executed individually. Answering to your question, while the task are running in background the user can continue doing her job and when the job is completed, will sent an email. while (true){ $pendingRequests = loadPendingImportRequests(); foreach ($pendingRequests as $request){ processImportRequest($request); } sleep(1); //Avoid eating up CPU when idle. } In you example, you have an infinite loop, it will never stop. Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576845 Share on other sites More sharing options...
kicken Posted April 14, 2020 Share Posted April 14, 2020 41 minutes ago, TrueMember said: In you example, you have an infinite loop, it will never stop. Yes, that's the point. It loops endlessly as a service checking for work to do. When it finds some, it does it. Otherwise it just sleeps, checking each second for new work. You can adjust the sleep period based on what your requirements are, or implement some method so it sleeps until specifically triggered to check for work (ie, through a socket). Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576849 Share on other sites More sharing options...
TrueMember Posted April 15, 2020 Author Share Posted April 15, 2020 11 hours ago, kicken said: Yes, that's the point. It loops endlessly as a service checking for work to do. When it finds some, it does it. Otherwise it just sleeps, checking each second for new work. You can adjust the sleep period based on what your requirements are, or implement some method so it sleeps until specifically triggered to check for work (ie, through a socket). Infinite loop is a good option? I don't think so, maybe i'm wrong. Can i check inside loop if i have new rows in database? If yes, keep going the job, else, i will leave the cicly and change something to 0 (this means, the script not running). Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576879 Share on other sites More sharing options...
Barand Posted April 15, 2020 Share Posted April 15, 2020 1 hour ago, TrueMember said: Infinite loop is a good option? I don't think so Your operating system is full of infinite loops. Imagine how it would be if mouse-click detection only ran every five minutes. Quote Link to comment https://forums.phpfreaks.com/topic/310574-alternative-queue-system/#findComment-1576887 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.