gridd-alpha ERROR: syntax error at or near "q" at character 1

[voltumna]

Dear all, I have JUST cloned the project and used the command as per documentation https://grid.hyperledger.org/docs/0.1/grid_on_sawtooth.html and I get the error gridd-alpha ERROR: syntax error at or near "q" at character 1 and gridd-beta ERROR: syntax error at or near "q" at character 1

I noticed that in the examples/sawtooth/docker-compose.yaml you have the query

289     entrypoint: |
290       bash -c "
291         # we need to wait for the db to have started.
292         until PGPASSWORD=grid_example psql -h db-alpha -U grid -c '\q' > /dev/null 2>&1; do
293             >&2 echo \"Database is unavailable - sleeping\"
294             sleep 1
295         done

for both gridd-alpha and gridd-beta

I was able to fix this by adding an extra '\' in front of the 'q':

289     entrypoint: |
290       bash -c "
291         # we need to wait for the db to have started.
292         until PGPASSWORD=grid_example psql -h db-alpha -U grid -c '\\q' > /dev/null 2>&1; do
293             >&2 echo \"Database is unavailable - sleeping\"
294             sleep 1
295         done

Can you please look at if your main docker-compse.yaml neets updating for this?

thanks Maurizio

[shannynalayna]

Hi @voltumna 👋🏻 We've noticed this issue comes up when using docker-compose v2. We've also found that it's pretty simple to turn this "feature" of Docker off, by going into your Docker desktop setup, settings, then unchecking the Use docker-compose v2 box.

[voltumna]

Hello, Thanks for the update, I am not using Windows but Linux via command line so there is no docker desktop.

You might then want to update the docker-compose.yaml file to reflect the right instructions for people using the latest stable docker-compose library which is now 2.4.1

Thanks

Maurizio

On Tue, 26 Apr 2022, 22:39 Shannyn, @.***> wrote:

Hi @voltumna https://github.com/voltumna 👋🏻 We've noticed this issue comes up when using docker-compose v2. We've also found that it's pretty simple to turn this "feature" of Docker off, by going into your Docker desktop setup, settings, then unchecking the Use docker-compose v2 box.

— Reply to this email directly, view it on GitHub https://github.com/hyperledger/grid/issues/1394#issuecomment-1110227456, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJXIKSLRWK5O3SQQ4EG66DVHBH7LANCNFSM5UM5VZVA . You are receiving this because you were mentioned.Message ID: @.***>

[voltumna]

I have shared a reworked docker-compose.yaml for docker 2.x, which works for me https://github.com/hyperledger/grid/issues/1396

[finavatar]

I have shared a reworked docker-compose.yaml for docker 2.x, which works for me #1396

Hi, Thank you so much for sharing your solution to this issue. I've spent a lot of time trying to figure this out and it hasn't been easy for someone like me who is new to hyperledger, to docker, to bash, etc...

And thank you also for sharing another solution to another issue where you removed the '\n' (continuation line) so that the command works as one whole line.

I would just wish that hyperledger documentation is up to date by taking your solutions into consideration - to help future newbies.