nvdv2 sync error

[wcc526]

2021-03-10 06:12:18+0000 [-] [Thread-11] [anchore_engine.services.policy_engine.engine.feeds.sync/sync()] [INFO] Download complete. Syncing to db (feed=github, group=github:python, operation_id=f292de4eb683457d8fe81df5122054b3)
2021-03-10 06:12:18+0000 [-] [Thread-11] [anchore_engine.services.policy_engine.engine.feeds.sync/sync()] [ERROR] Error syncing github/github:python (operation_id=f292de4eb683457d8fe81df5122054b3)
2021-03-10 06:12:18+0000 [-] [Thread-11] [anchore_engine.services.policy_engine.engine.feeds.feeds/notify_event()] [INFO] Event: {"type": "system.feeds.sync.group_failed", "level": "error", "message": "Feed group sync failed", "details": {"cause": "(sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back\n[SQL: SELECT feeds.name AS feeds_name, feeds.description AS feeds_description, feeds.access_tier AS feeds_access_tier, feeds.last_full_sync AS feeds_last_full_sync, feeds.last_update AS feeds_last_update, feeds.created_at AS feeds_created_at, feeds.enabled AS feeds_enabled \nFROM feeds \nWHERE feeds.name = %(name_1)s]\n[parameters: [immutabledict({})]]"}, "timestamp": "2021-03-10T06:12:18.463767", "resource": {"user_id": "admin", "type": "feed_group", "id": "github/github:python"}, "source": {"request_id": null, "servicename": "policy_engine", "hostid": "anchore-quickstart", "base_url": "http://policy-engine:8228"}} (operation_id=f292de4eb683457d8fe81df5122054b3)
2021-03-10 06:12:18+0000 [-] [Thread-11] [anchore_engine.services.policy_engine.engine.feeds.feeds/notify_event()] [INFO] Event: {"type": "system.feeds.sync.feed_failed", "level": "error", "message": "Feed sync failed", "details": {"cause": "One or more groups failed to sync"}, "timestamp": "2021-03-10T06:12:18.565019", "resource": {"user_id": "admin", "type": "feed", "id": "github"}, "source": {"request_id": null, "servicename": "policy_engine", "hostid": "anchore-quickstart", "base_url": "http://policy-engine:8228"}} (operation_id=f292de4eb683457d8fe81df5122054b3)
2021-03-10 06:12:18+0000 [-] [Thread-11] [anchore_engine.services.policy_engine.engine.tasks/execute()] [INFO] Feed sync complete (operation_id=f292de4eb683457d8fe81df5122054b3)
2021-03-10 06:12:18+0000 [-] [Thread-11] [anchore_engine.services.policy_engine.engine.feeds.feeds/notify_event()] [INFO] Event: {"type": "system.feeds.sync.completed", "level": "info", "message": "Feeds sync task completed", "details": {"sync_feed_types": ["vulnerabilities", "nvdv2", "github"]}, "timestamp": "2021-03-10T06:12:18.658413", "resource": {"user_id": "admin", "type": "feeds", "id": null}, "source": {"request_id": null, "servicename": "policy_engine", "hostid": "anchore-quickstart", "base_url": "http://policy-engine:8228"}} (operation_id=f292de4eb683457d8fe81df5122054b3)

[zhill]

@wcc526 unfortunately this isn't enough information for us to triage. The system can fail a sync and recover on the next attempt due to many different issues.

We'll need the anchore version you are running, as well as output of anchore-cli system feeds list to see if it is always failing or just failed once and recovered.