unable to parse query protobuf [afs: Invalid empty predicate ] - trying to continue - AFS

AFS Troubleshooting Guide

Product
AFS
AFS_Version
7.9
Platform
Debian
Category
Reference Guide

Issue

One of the predicate of the query was malformed, it will be ignored.

Solution(s)

It is recommended to check how queries have been built and to modify them accordingly.

Issue

When launching a publication through a PaF, the AFS v7.8 PaF Manager keeps returning the following error on SQLite database:

afs_pafmanager log :
Error while scheduling
{ PAF Name / ref }
: Could not fetch next row : database disk image is malformed in ( SQL command )

Any attempt to restart the PaF Manager fails.

Possible root cause(s)

This issue might occur when:

  • The Mongo database got oomkilled and the oomkill process corrupted the PaF Manager SQLite database.

Solution(s)

It is recommended to use this solution only if a standard PaF Manager restart procedure failed. Resetting the PaF Manager database resets the PaFs' history. Any new PaF launched gets the ID 1.

Reinitialize the PaF Manager database

  1. Stop the PaF Manager using the following command:

    As root user

    systemctl stop afs-pafmanager.service

  2. Remove .db files located in /usr/local/afs7/PaFManager/db/status/ with the following command:

    As root user

    rm /usr/local/afs7/PaFManager/db/status/*.db

  3. Start the PaF Manager using the following command:

    As root user

    systemctl start afs-pafmanager.service

Reinstall all PaFs

Resetting the PaF Manager removes all existing PaFs.

You need to reinstall them using the following script:

ft_install_all_pafs