Campaigns getting stuck

Discussion in 'Common issues' started by Lakjin, Sep 24, 2016.

  1. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,450
    Likes Received:
    2,432
    @Lakjin - you have to have something in the application log at Backend > Misc > Application log.
    What frm.mwz says related to verbose logging is this, it might help you understand where it happens.
     
  2. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    Thanks. I will try verbose.

    As for application log, I don't see any error logs related to sending. However, I see a BUNCH of 404 errors like this:

    2016/10/14 13:32:42 [error] [exception.CHttpException.404] CHttpException: The system is unable to find the requested action "jb4543m4raa69". in /home/xxx/public_html/apps/common/framework/web/CController.php:483
    Stack trace:
    #0 /home/xxx/public_html/apps/common/framework/web/CController.php(270): CController->missingAction('jb4543m4raa69')
    #1 /home/xxx/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('jb4543m4raa69')
    #2 /home/xxx/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('campaigns/jb454...')
    #3 /home/xxx/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
    #4 /home/xxx/public_html/apps/init.php(227): CApplication->run()
    #5 /home/xxx/public_html/index.php(18): require_once('/home/xxx/pub...')
    #6 {main}
    REQUEST_URI=/campaigns/jb4543m4raa69/track-url/bt5068mmdsfa9/9d50dc8fc531f3c91ac22062286608ea2dd9d6e1

    I dont know why these errors happen -- the URI /campaigns/jb4543m4raa69/track-url/bt5068mmdsfa9/9d50dc8fc531f3c91ac22062286608ea2dd9d6e1 is completely valid and loads perfectly (I just tried it). There are a lot of 404 errors for different URIs like this.
     
  3. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,718
    Likes Received:
    681
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    search the forum for
    "[error] [exception.CHttpException.404] CHttpException"
     
  4. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    Is there any specific post you are referring to? I searched and didnt' find anything related to what I'm getting.
     
  5. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,718
    Likes Received:
    681
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    It may be easier if you PM me with access to mwz and server, and also your skype handle, so we can fix it.
     
  6. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    Sorry, but I cannot do that. I do appreciate your help though.
     
  7. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,450
    Likes Received:
    2,432
  8. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    I can do that quite easily :-D However, I'm still curious -- why are they happening? Does that mean a user was unable to load the page they were trying to go to?
     
  9. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,450
    Likes Received:
    2,432
    @Lakjin - Say a user unsubscribes. Then later he opens the email again, then pam, 404.
     
  10. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    But why? I would still want a user to go to my website if they click a link, even if they unsubscribe.
     
  11. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,718
    Likes Received:
    681
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    If the subscriber is still on the list with status 'unsubscribed' it would probably count the click (and not show a 404), since all links would be still in the dbf. Only if the subscriber is removed from the list, would the links probly not work anymore, haven't tested that yet though.
     
  12. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    If this is true, then the 404 errors are for a different reason for me as we do not delete unsubscribed users.
     
  13. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,718
    Likes Received:
    681
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    When I tested a second unsubscribe (ie clicking on the tracked unsubscribe link again), it worked, brought up the form and not 404 (and confirmed the unsubscribed subscriber was already unsubscribed).
    From this I would conclude that your 404's may have a different cause, and you are right in above post.
     
  14. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    @twisted1919 @frm.mwz My campaigns got stuck again today. I ran the send campaign command with --verbose and got this:

    [2016-10-26 06:22:45] - Loading 5 campaigns, starting with offset 0...
    [2016-10-26 06:22:45] - No campaign found, stopping.

    However, there are 6 campaigns at 'processing'. What is going on?
     
  15. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    Digging into this problem further, it looks like the status for the stuck campaigns is at 'processing' in the campaigns table, that is why the send-campaigns command returns no campaign found. That means the send-campaigns workers are sometimes not changing the status of processing campaigns back to sending after they complete a batch.
     
  16. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    This may be the problem:

    [2016-10-26 10:20:17] - Exception thrown: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
    [2016-10-26 10:20:17] - Sending failed with: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

    Can there be error logging that tries to reconnect to MySQL if it goes down like this?
     
  17. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,718
    Likes Received:
    681
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    This usually means that you are asking to much of your dbf server and need to either scale it down, or adjust settings or upgrade.

    DBF server settings would be my first attempt ;)
     
  18. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    Naw, database overload is not the issue. Our server has plenty of resources and we do not use even close to the number of max DB connections.

    Something else is up, I've started logging to see what is what. Will update when I find out more.
     
  19. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,718
    Likes Received:
    681
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    ...it might be the peaks, not the averages...
     
  20. Lakjin

    Lakjin Active Member

    Joined:
    Mar 1, 2015
    Messages:
    391
    Likes Received:
    30
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    6
    As I said, overloading is not the issue.
     

Share This Page