Query Execution error

[AshnaSabu123]

Hi @dfellis

We tried to execute the query SELECT * from iasql_install('aws_iam','aws_cloudwatch','aws_ecr','aws_ecs_fargate','aws_elb','aws_secury_group','aws_vpc'); but we are getting the below error. Please have a look into it and revert back.

postgresql_1 | SQL statement "SELECT until_iasql_operation('INSTALL', _mods)" postgresql_1 | PL/pgSQL function iasql_module_install(text[]) line 3 at PERFORM postgresql_1 | PL/pgSQL function iasql_install(text[]) line 3 at RETURN QUERY postgresql_1 | 2022-05-31 06:34:07.563 UTC [34] ERROR: control reached end of function without RETURN postgresql_1 | 2022-05-31 06:34:07.563 UTC [34] CONTEXT: PL/pgSQL function until_iasql_operation(iasql_operation_optype_enum,text[]) postgresql_1 | SQL statement "SELECT until_iasql_operation('INSTALL', _mods)" postgresql_1 | PL/pgSQL function iasql_module_install(text[]) line 3 at PERFORM postgresql_1 | PL/pgSQL function iasql_install(text[]) line 3 at RETURN QUERY postgresql_1 | 2022-05-31 06:34:07.563 UTC [34] STATEMENT: SELECT * from iasql_install('aws_iam','aws_cloudwatch','aws_ecr','aws_ecs_fargate','aws_elb','aws_security_group','aws_vpc');

[aguillenv]

Hello @AshnaSabu123,

I'm part of the IaSQL team, I can try to assist you while @dfellis comes online.

I'm sorry you are having this issue installing modules. Could you please run the following command and review the logs of the change engine container?

docker logs $(docker ps --filter "name=change" --format "{{.Names}}") > logs.txt

If you share with us the stacktrace of this error (should be near the end of that file) we could use that to figure out what went wrong for you. You could also share the entire file, but please first edit it first if there are any credentials in it.

The current stack trace you are sharing with us is from the database and does not tell us much information about it.

Thank you!

[AshnaSabu123]

Hi,

On checking the docker logs we are getting the below trace. Please have a check on it .

2022-06-01 06:12:38.535 UTC [1] LOG: database system is ready to accept connections 2022-06-01 06:33:27.208 UTC [37] ERROR: canceling statement due to user request 2022-06-01 06:33:27.208 UTC [37] CONTEXT: SQL statement "SELECT pg_sleep(1)" PL/pgSQL function until_iasql_operation(iasql_operation_optype_enum,text[]) line 45 at PERFORM SQL statement "SELECT until_iasql_operation('INSTALL', _mods)" PL/pgSQL function iasql_module_install(text[]) line 3 at PERFORM PL/pgSQL function iasql_install(text[]) line 3 at RETURN QUERY 2022-06-01 06:33:27.208 UTC [37] STATEMENT: SELECT * from iasql_install('aws_iam','aws_cloudwatch','aws_ecr','aws_ecs_fargate','aws_elb','aws_security_group','aws_vpc');

[aguillenv]

When running IaSQL locally, the docker-compose command will run 2 containers for you. If you execute the docker ps command you will see something like:

The log trace you are sharing with us are the ones from the postgres container, but the logs from the change_engine are the ones that give us more context on what's going wrong for you and let us understand and solve the issue. If you could please share them with us that would be really helpful. The command would be something like: docker logs $(docker ps --filter "name=change" --format "{{.Names}}") > logs.txt

Thank you!