Hello, I am trying to deploy Kratos on K8S environ...
# talk-kratos
b
Hello, I am trying to deploy Kratos on K8S environment using multiple replicas with postgres pool transaction as database. Unfortunately, I encounter the following issue while executing multiple time the registration/login flow using APIs :
ERROR: prepared statement \"lrupsc_3_2\" does not exist (SQLSTATE 26000)
Copy code
kratos-668496c875-xv99k {"http_request":{"headers":{"accept":"application/json","accept-encoding":"gzip","content-type":"application/json","referer":"https://<KRATOS_ADMIN_URL>/identities/%7B%7B.login_user_should_be_success.identity_id%7D%7D","user-agent":"Go-http-client/2.0","x-forwarded-for":"<REAL_IP>","x-forwarded-host":"<KRATOS_ADMIN_URL>","x-forwarded-port":"443","x-forwarded-proto":"https","x-forwarded-scheme":"https","x-real-ip":"<REAL_IP>","x-request-id":"aa336875b858d308776562b2a70d9e0a","x-scheme":"https"},"host":"<KRATOS_ADMIN_URL>","method":"GET","path":"/admin/identities/%7B%7B.login_user_should_be_success.identity_id%7D%7D","query":null,"remote":"<POD_IP>:<POD_PORT>","scheme":"https"},"level":"info","msg":"started handling request","time":"2022-06-13T16:04:02Z"}
                                                                                  
kratos-668496c875-xv99k {"audience":"application","error":{"message":"ERROR: prepared statement \"lrupsc_3_2\" does not exist (SQLSTATE 26000)"},"http_request":{"headers":{"accept":"application/json","accept-encoding":"gzip","content-type":"application/json","referer":"https://<KRATOS_ADMIN_URL>/identities/%7B%7B.login_user_should_be_success.identity_id%7D%7D","user-agent":"Go-http-client/2.0","x-forwarded-for":"<REAL_IP>","x-forwarded-host":"<KRATOS_ADMIN_URL>","x-forwarded-port":"443","x-forwarded-proto":"https","x-forwarded-scheme":"https","x-real-ip":"<REAL_IP>","x-request-id":"aa336875b858d308776562b2a70d9e0a","x-scheme":"https"},"host":"<KRATOS_ADMIN_URL>","method":"GET","path":"/admin/identities/%7B%7B.login_user_should_be_success.identity_id%7D%7D","query":null,"remote":"<POD_IP>:<POD_PORT>","scheme":"https"},"http_response":{"status_code":500},"level":"error","msg":"An error occurred while handling a request","service_name":"Ory Kratos","service_version":"","time":"2022-06-13T16:04:02Z"}
                                                                                               
kratos-668496c875-xv99k {"http_request":{"headers":{"accept":"application/json","accept-encoding":"gzip","content-type":"application/json","referer":"https://<KRATOS_ADMIN_URL>/identities/%7B%7B.login_user_should_be_success.identity_id%7D%7D","user-agent":"Go-http-client/2.0","x-forwarded-for":"<REAL_IP>","x-forwarded-host":"<KRATOS_ADMIN_URL>","x-forwarded-port":"443","x-forwarded-proto":"https","x-forwarded-scheme":"https","x-real-ip":"<REAL_IP>","x-request-id":"aa336875b858d308776562b2a70d9e0a","x-scheme":"https"},"host":"<KRATOS_ADMIN_URL>","method":"GET","path":"/admin/identities/%7B%7B.login_user_should_be_success.identity_id%7D%7D","query":null,"remote":"<POD_IP>:<POD_PORT>","scheme":"https"},"http_response":{"headers":{"cache-control":"private, no-cache, no-store, must-revalidate","content-type":"application/json"},"size":186,"status":500,"text_status":"Internal Server Error","took":1432720},"level":"info","msg":"completed handling request","time":"2022-06-13T16:04:02Z"}
Have you already tried to use PG pool as database ? Is there a way to solve this issue changing Kratos configuration ?