DB issue

[AshnaSabu123]

While trying to execute the below command we are getting the following error. Please have a look into it. COMMAND : SELECT * FROM iasql_install('aws_account');

ERROR: 08001: could not establish connection DETAIL: missing "=" after "loopback_dblink_iasql_test" in connection info string CONTEXT: SQL statement "SELECT dblink_connect('iasqlopconn', 'loopback_dblink_' || _db_id)" PL/pgSQL function until_iasql_operation(iasql_operation_optype_enum,text[]) line 18 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

Awaiting for you response.

[dfellis]

Hi @AshnaSabu123

That error is saying that the expected link of the database to itself has disappeared (which we use to allow the engine to inject itself into these blocking calls and do the work you're asking for), which implies the engine is not functioning.

Could you please run:

docker logs iasql-engine_change_engine_1 > logs.txt

Near the end of that file should be a stacktrace of what caused it to crash, and I could use that to try and figure out what went wrong for you.

You could also share the entire logfile, but local running has debug logging enabled, and that might leak credentials or other sensitive information, so if you do I'd edit those out, first.

[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');