Random error psycopg2.errors.UndefinedFunction: function splitgraph_api.get_tagged_images

[mingfang]

I'm using a splitfile to build images and while it works most of the time, sometimes it fails with these errors

Gathering remote metadata...
error: psycopg2.errors.UndefinedFunction: function splitgraph_api.get_tagged_images(unknown, unknown) does not exist
error: LINE 1: SELECT image_hash, tag FROM "splitgraph_api"."get_tagged_ima...
error:                                     ^
error: HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

This started to happen after upgrading to v0.3.9 and using the new sgr build --layered-query feature.

[mildbyte]

Is this running against data.splitgraph.com or your own custom remote engine? Can you rerun this with sgr --verbosity DEBUG build and, when it happens again, provide that output and the logs of the local/remote engine? Looks like the API functions on the engine go missing, which is definitely not supposed to happen.

[mingfang]

I'm getting this on my local engine. My setup is based on this https://github.com/splitgraph/splitgraph/tree/master/examples/push-to-other-engine The problem doesn't happen all the time. I'm testing out a guess that this is caused by multiple simultaneous "local" splitfile builds hitting the same "remote" engine at the same time. It could be some race condition happened on the remote engine.