Forum Activity for @strumelia

Strumelia
@strumelia
03/20/18 07:32:40AM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

see the AWS bill details here showing where the usage is happening... one 'normal' one from January, then the suddenly changed to the giant one from February...and continues on now even higher than that...
february-AWS.jpg february-AWS.jpg - 341KB
Strumelia
@strumelia
03/20/18 07:26:21AM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

Thanks for checking that Brian!
I have to go out for a few hours now, but will open a ticket as soon as I get back... thank you!

p.s. I also think this is why my monthly bill for AWS S3 backup is zooming over $20 for the past two months... previously was always about $3 and I've changed nothing...i only use it for the JR routine backups.
Strumelia
@strumelia
03/19/18 08:16:21PM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

Strumelia:
There have been no log errors, and System Check has been all green lights. Pausing and resuming the queues doesn't seem to have any effect in getting them going again. Deleting the entries deletes them all, but when I check back again the next day they are there again and sleeping or 'working' endlessly.
When I check the versions of backups available in the DB Backup 'restore' tools for both hourly and daily backups, they seem to show the expected versions there.

Ok so on the fotmd site, I just now deleted the Daily Backup processes for both March 18 and 19 (both of which were still 'working' or pending). It's 11:30 pm here, March 19.... soon to be March 20th. My queue viewer is cleared of them and is working other things normally. The daily backup should start again soon on schedule. I just ran an integrity check. I need to go to bed now and I'll check back here in about 9 hours to see if the Daily Backup got stuck again.
Thanks. :)

P.S. come to think of it, I haven't seen any entries in the activity Error Log in a long time, on either site. Maybe that's a little odd there, not sure.
updated by @strumelia: 03/19/18 08:32:48PM
Strumelia
@strumelia
03/19/18 05:00:52PM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

brian:
In your first screenshot however, the daily backup that started on the 18th is clearly "hung" - it's been running for 20 hours - and there is now a SECOND backup that is waiting to be worked (for the 19th). So delete the first one - it's not running any more.
Let me know if that helps.

I've been deleting these things regularly but they keep re-happening daily... mostly on the FOTMD site. I just posted two new screenshots- showing how this keeps happening and the Daily Backup always now runs forEVER, stuck like glue. Or it starts/starts/starts and completes sometimes hours later.
I remember previously it used to be just very tidy and did its thing normally and then switched off again. It's not like my fotmd site has grown all that huge in that time.
updated by @strumelia: 03/19/18 05:31:22PM
Strumelia
@strumelia
03/19/18 04:57:46PM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

Oh wow... I just now did a selective search in my activity log for "backup" on my two sites, and you can see that on the pennywhistle site the backups start and complete relatively quickly. But look at the timestamps for the FOTMD site backups and you can see a big problem there... here are the two comparison screenshots:
FOTMDbackup log.png FOTMDbackup log.png - 517KB
Strumelia
@strumelia
03/19/18 04:41:06PM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

Oh, here are the now-typical screenshots I'm seeing all the time:
queue2.png queue2.png - 52KB
Strumelia
@strumelia
03/19/18 04:40:05PM
3,605 posts

DB Backups now always stuck in Queue


Using Jamroom

For some time now off and on, but happening almost constantly now, when i go to my dashboard's Queue Viewer I keep seeing the Daily Backup and hourly Backups seemingly 'stuck' or sleeping for long periods of time. Please see these two recent screenshots as examples.
There have been no log errors, and System Check has been all green lights. Pausing and resuming the queues doesn't seem to have any effect in getting them going again. Deleting the entries deletes them all, but when I check back again the next day they are there again and sleeping or 'working' endlessly.

When I check the versions of backups available in the DB Backup 'restore' tools for both hourly and daily backups, they seem to show the expected versions there.

My (much smaller) pennywhistle site doesn't seem to have this issue with the Daily Backup, but I often find the hourly back there in 'sleeping' mode.
However my main larger FOTMD.com site is now almost always showing the Daily Backup stuck in time in the queue. I remember this happening about 6 months ago for a few weeks, but then it seemed to fix itself, maybe after some update or another. I never mentioned it because it stopped happening.

Not sure if this is related or not, but since it has to do with my site's backups:
For the past two months my AWS S3 backup bucket (I use AWS/S3 only for my two jamroom sites) has gone from about $3 per month first to $15 and now to over $20 this month...! (yikes, I'll need to do something about that) Anyway, I'm wondering if these 'stuck' backups have anything to do with my new gigantic AWS S3 bills. They started happening around the same time period as far as I can tell.
But before I figure that out, I just want to get this DB backup to quit clogging up or going to sleep without finishing its task.

Thanks for any help!

updated by @strumelia: 06/24/18 07:52:57AM
Strumelia
@strumelia
03/19/18 03:13:11PM
3,605 posts

A site selling stuff to non-members?


Using Jamroom

Oh right. Of course!

Thanks for getting Nate to look at zapping the Eskin.
Sounds like some possibilities here. :)
updated by @strumelia: 03/19/18 03:13:25PM
Strumelia
@strumelia
03/19/18 01:55:53PM
3,605 posts

A site selling stuff to non-members?


Using Jamroom

Gentlemen, this sounds promising.
Sometime over the next 6 months I was hoping to create a new simple mobile responsive site to sell my tshirts, retail, using my Paypal account. I'm sitting on a lot of shirt inventory that has stopped moving because of my current antiquated site.

The thing is, I could pay monthly or per purchase fees to Etsy or Wix or Ebay...PLUS the per-purchase Paypal fees... but I have 1/2 of my current Jamroom hosted server sitting empty and available for me...and it wouldn't cost me anything additional per month once a JR site was set up there.... would only cost me the paypal per-purchase fees.

Yeah Paul, a custom message on that page could do wonders to keep people from clicking away in disgust when suddenly confronted with those deadly words "create account" ...LoL sad but true.
updated by @strumelia: 03/19/18 01:57:30PM
Strumelia
@strumelia
03/19/18 01:17:46PM
3,605 posts

A site selling stuff to non-members?


Using Jamroom

brian:
To be 100% honest, creating an account to buy something is pretty much the standard now. Check out Amazon.com - you can't just buy something from them without having an account. Have your users told you that creating an account is a hassle or do you just feel that would be the case? Jamroom's cart makes it pretty easy as it is integrated into the checkout flow.

Maybe you are right....it's something that i just felt would be the case. I realized after you said this, that when I buy things from various vendors on amazon (without my having to 'join' any of those vendors' sites)... that in reality I already HAVE joined... joined Amazon itself. lol Same true for Etsy, Ebay...

So... a jamroom site for this would need to allow members to join quickly as PART OF the ordering process...not a cumbersome two-step process of first creating an account, and then having to separately return to the site to choose items and place an order.

You are saying the JR cart integrates JOINING with ORDERING in a smooth hassle free flow, using Paypal checkout on jamroom? (if I choose and set up my existing PP seller's account in the Jamroom merchandising modules). ?

What JR skin would be appropriate for this kind of simple tshirt selling, using the JR cart and Paypal?
Do you think this would be a relatively simple JR site to set up?
  49