cron job fails every night #163

New Issue

kae · 2023-01-25T08:28:02Z

kae commented

2023-01-25 08:28:02 +00:00

Jan 25 03:03:01 ws CRON[1563815]: (kae) CMD (/usr/local/bin/update_mm_db)
Jan 25 03:03:02 ws [musicmuster] dbconfig.<module> - D: Database: musicmuster_prod
Jan 25 03:03:02 ws [musicmuster] musicmuster.<module> - D: Updating database
Jan 25 03:03:02 ws [musicmuster] dbconfig.Session - D: Session acquired, file='/home/kae/mm/app/musicmuster.py', function='<module>', functionlineno=1763, Session=<sqlalchemy.orm.scoping.scoped_session object at 0x7f62cb7d38e0>
Jan 25 03:03:03 ws [musicmuster] dbconfig.Session - D:  Session released
Jan 25 03:03:03 ws mariadbd[1656]: 2023-01-25  3:03:03 12105 [Warning] Aborted connection 12105 to db: 'musicmuster_prod' user: 'musicmuster' host: 'localhost' (Got an error reading communication packets)
Jan 25 03:03:03 ws CRON[1563814]: pam_unix(cron:session): session closed for user kae

``` Jan 25 03:03:01 ws CRON[1563815]: (kae) CMD (/usr/local/bin/update_mm_db) Jan 25 03:03:02 ws [musicmuster] dbconfig.<module> - D: Database: musicmuster_prod Jan 25 03:03:02 ws [musicmuster] musicmuster.<module> - D: Updating database Jan 25 03:03:02 ws [musicmuster] dbconfig.Session - D: Session acquired, file='/home/kae/mm/app/musicmuster.py', function='<module>', functionlineno=1763, Session=<sqlalchemy.orm.scoping.scoped_session object at 0x7f62cb7d38e0> Jan 25 03:03:03 ws [musicmuster] dbconfig.Session - D: Session released Jan 25 03:03:03 ws mariadbd[1656]: 2023-01-25 3:03:03 12105 [Warning] Aborted connection 12105 to db: 'musicmuster_prod' user: 'musicmuster' host: 'localhost' (Got an error reading communication packets) Jan 25 03:03:03 ws CRON[1563814]: pam_unix(cron:session): session closed for user kae ```

kae added the

bug

label 2023-01-25 08:28:02 +00:00

kae commented

2023-01-26 11:45:44 +00:00

All of app/utilities.py:check_db runs, but control doesn't return to call:

    if args.check_db:
        log.debug("Updating database")
        with Session() as session:
            check_db(session)
            log.debug("check_db return")
        log.debug("session closed")

The last two log.debug statements do not execute.

All of app/utilities.py:check_db runs, but control doesn't return to call: ``` if args.check_db: log.debug("Updating database") with Session() as session: check_db(session) log.debug("check_db return") log.debug("session closed") ``` The last two log.debug statements do not execute.

kae commented

2023-01-27 10:54:20 +00:00

Two separate issues. mariadb error closed with #e736cb8

Lack of mail is a certificate issue, being fixed.

Two separate issues. mariadb error closed with #e736cb8 Lack of mail is a certificate issue, being fixed.

kae commented

2023-01-27 17:48:44 +00:00

Mail fixed.

kae closed this issue

2023-01-27 17:48:44 +00:00

Sign in to join this conversation.