coldfusion - Railo websites can't connect during MySQL backup -


I have a weekly backup that runs for one of my websites (CCM) for a MySQL database. This backup is approximately 1.2 GB and takes approximately 30 minutes to run.

When this database runs back up, all my other railway websites can not connect to "Down" for the time of backup.

One of the errors I managed to achieve was: 

  "[show] railo.runtime.exp.RequestTimeoutException: Request (: 119) in timeout Runs (1200 seconds) and closed. Open locks at this time (c: /railo/webapps/root/ccms/parsed/photo.view.cfm, c: / railo / webapps / root / ccms / parsed /profile.view.cfm, c: /railo/webapps/root/ccms/parsed/album.view.cfm, c: /railo/webapps/root/ccms/parsed/public.dologin.cfm). "  
 I believe that the required tables for those pages ("CCMS" website) are being locked due to backup,  
 But, that is the reason why the time is due to other railway websites? For example, the error I pasted above was actually taken from a different website, not the "CCMS" website which refers to the error in the website I try and run fails and an error Which references the "CCMS" website, which is backed up, how can I avoid this?  
 Any insights will be appreciated. Thanks   
 
 
 One possibility is that because your timeout can take 20 minutes, every time a request arrives The site that is being supported is waiting for DB.  
 In order to manage the requests, there is a pool of workers thread in Railo and now one of them is tied. As soon as the request persists, any request on the affected site binds to another thread. Eventually there are no more employees in the pool and all requests are queued after the start of the proceedings.  
 I am not an expert on debugging railways, but the above versions seem right to me. You may consider running separate railroad processes for individual sites, which will separate them or significantly reduce your DB timeout (if acceptable).

Comments

Post a Comment

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

I was trying to use the program to use mifrewan on 4 node clusters. Distributing node 0 data in nodes 1, 2 and 3. In the program, from '90 'to variable values ​​of' dior 'to be calculated. Therefore the node is distributing data and collecting results in an omitted fashion (for different values ​​of var 'dir') when do {*******} Whereas (dir Loop is given, Mippun is hanging, and no output is found. But when I comment on two {*******} (dir The loop output is obtained for the initial value of variable dir dir = -90 ), and that output is correct. The problem occurs when the loop is given. Can anyone help me in solving this problem. #include "mpi.h" int main (int argc, char * argv []) Float dir = -90; Int rank, nanoprakash; MPI_Status status; MPI_Init (& amp; argc, & argv); MPI_Comm_rank (MPI_COMM_WORLD, & amp; Rank); MPI_Comm_size (MPI_COMM_WORLD, & amp; numprocs); If (rank == 0) {/ / data to begin / / (dest = 1; dest ...
Read more

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

I can not find anything in the source about using coupons after subscribing to a user's plan. Is it possible to use a coupon to credit a user's membership after initial subscription? If not, what is the best option? Specifically, I want to give a user 100% coupon for that month, when they take 5 [site specific actions]. This is possible, but may not be the best idea. Coupons are currently applied to the stripe, then apply again at the customer level and each client can have a single coupon. So if you are already offering discounts to the coupon, then the customer who is currently in the present will also give up. It also means that if you are using a recently-added multiple subscription capacity, then all of the user's subscription will be ready for the month. Coupons can be set to "Once", only once (as the only name) can be used by any customer, so if this credit can earn more than once, You will have to maintain a 100% discount coupon continuousl...
Read more

java - Unable to get JDBC connection in Spring application to MySQL -

मैंने स्प्रिंग में डीबी कॉन्फ़िगरेशन का पालन किया है: & lt; bean id = "dataSource" Class = "org.apache.commons.dbcp.BasicDataSource" नष्ट-विधि = "बंद" & gt; & Lt; प्रॉपर्टी नाम = "url" मान = "jdbc: dburl" / & gt; & Lt; संपत्ति नाम = "driverClassName" मान = "com.mysql.jdbc.Driver" / & gt; & Lt; संपत्ति नाम = "उपयोगकर्ता नाम" मान = "उपयोगकर्ता नाम" / & gt; & Lt; संपत्ति नाम = "पासवर्ड" मान = "पासवॉर्फ" / & gt; & Lt; प्रॉपर्टी नाम = "हटाए गए हटाए गए" मान = "सही" / & gt; & Lt; गुण नाम = "प्रारंभिक आकार" मान = "3" / & gt; & Lt; संपत्ति नाम = "अधिकतमअक्टिव" मान = "5" / & gt; & Lt; / सेम ​​& gt; डीबी से गुण मूल्यों को लोड करने के लिए अतिरिक्त कॉन्फ़िगरेशन। & lt; bean id = "config1" class = "org.apache.commons.configuration....
Read more