WinCF Servers

I see that WinCF had an issue. Did the other CF server have an issue as well? One of my customers uses CF to send pages via Email. It stopped working for hours. I sent in a ticket about 10 minutes ago, but wanted to know on here what happened to the server so I can properly advise my customer.

Thanks,
-Ben

There are two domains that we have sent notice to on WinCF2, wincf is resolved now, WinCF2 has an issue with 3 domains causing the engine to basically run itself out of resources, and we have already upped them a LOT

Those two have gotten notice, without reply before long we will be forced to turn off their domains for nwo we are monitoring it closely.

Thank you for the explanation. Out of curiosity, when you email the domains, do you contact the resellers or the domain owners directly? I am essentially curious if it were to happen that one of my customers had an out of control website, would I be contacted (which is what I would want), or would they be contacted?

Thanks,
-Ben

Resellers are contacted if it is reseller, if direct client to us we go direct.

It looks like WinCF2 is having issues again. I, unfortunately, have a customer that coded his paging system in ColdFusion, and this is used by many area hospitals and clinics for emergency paging. Any ideas why these servers are having such issues?

Thank you,
-Ben

I have been on a flight today and got a few hours of sleep after 3 days of non stop working. I am going to ask the techs about this. There was one highly abusive site we stopped it and for th nxt 16 hours it only had 2 times for 30 seconds total that there were problems. I need to check on the status of those abuse issues and see where we are with them.

Just to update, we have found that the fault lies with the ODBC connections to Access DBs hanging the ODBC service up, in turn hanging the jrun processes. We have send a handful of notices regarding some very large active Access DBs, if even half these will move to SQL there will be a great improvement. In the meantime we are watching CF very closely at all levels and working to fix any timeout or blank page load ASAP.

Edit:

just got one very positive return back in, downsided a very large mdb that was causing the hang sometimes. Hoping for more of the same.

Wouldn’t bother me if they were not allowed at all.:slight_smile:
There is no shortage of SQL Servers here.

We have seen a load of progress, only restarted cf services 2 times in last 24 hours now :slight_smile: Just waiting on about 5 more access DBs it move over and it will be in really good shape.

Stephen,

I signed up a new customer earlier in the week and got their site moved over. They are hosted on WinCF2. Multiple times going to the site they get an ODBC timeout error essentially that it couldn’t connect to the MySQL6 server. It appears that while the locking issues may be down, there are still other issues present. Is there anything we can do?

Thanks,
-Ben

I noticed tihis a couple of times today too.

hrm, I have not seen report of that, but I know CF itself has been quite stable (no crashes in over 15 hours, two days in a row)

I have nto seen reports of mysql timing out, but will take a look at logs.

Stephen,

I know you’ve been busy with the Win23 issues, but was hoping for an update. I have a client that does quite a bit of traffic and his site, unfortunately, is CF driven with a MS SQL backend. I know that he watches his site for any type of downtime, and we’re trying to set the correct expectation. One of his questions is what type of proactive monitoring is being done and how quickly from the server locking to it being back up is it resolved?

Thanks,
-Ben

We are continuously monitoring our server for 24 hours. Also, if any issue comes we resolve it in with in 2-3 min.

Server is working very fine.

Can you please explain how you are monitoring it? Do you have something there that if it doesn’t respond to CF, you will be notified such that the likelihood of a customer finding a site down before you is small?

Just trying to get a handle on things so I can set the correct expectation with this potential customer. He had issues before with his CF/MS Access site when I was running that server (before changing jobs) and it seems his site would have more downtime on these servers than the one he’s currently on. I realize you’re doing a great job on trying to keep on top of it, but customers will rarely understand that other than their site is down multiple times a day.

Thanks,
-Ben

In our monitoring system we are monitoring services of server. We have per-minute check for various services on every server. As soon as we see a notification it is attended immediately.

I continue to have issues on this service with the following error:

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver][mysqld-4.0.26-standard-log]Lost connection to MySQL server during query

This is from WinCF2 when running a very basic select query. My customer hasn’t noticed it yet, but everytime I go to the site, I seem to see one of these issues. This generally points to CF or the MySQL server having link issues. The bad thing is that if I refresh it, it seems to start working again. However, I can’t tell my client “just hit refresh every time”, as their clients aren’t going to.

Thanks,
-Ben

Please send us a ticket with link and details in which you are getting this issue. We will check it.

Ben, this one is rather easy :slight_smile:

In the DSN dialogue it has an option to “keep connections open through requests” and that is disabled on the MySQl servers, so it fails to keep a connection.

Sadly the default for it is to be that way if made from hsphere, we can change it manually with a ticket :slight_smile:

Ticket #LZT-69286-398. Please fix at your earliest convenience.

Thanks,
-Ben