INFO:     Started server process [1823550]
INFO:     Waiting for application startup.
2026-05-07 11:16:28,054 - INFO - Starting FastAPI application...
2026-05-07 11:16:28,066 - INFO - MySQL connection pool initialized: localhost:3306
2026-05-07 11:16:28,067 - INFO - Database tables initialized successfully
2026-05-07 11:16:28,255 - INFO - Importing public key from: /home/rxco/public_html/connector-app/keys/PGPPublicKey.asc
2026-05-07 11:16:28,260 - INFO - Import result: 0 imported
2026-05-07 11:16:28,260 - INFO - Set encryption recipient: 7F474ABE432B79B6ADE35A7A1A00E976D4B8366A
2026-05-07 11:16:28,282 - INFO - Private key import: 0 imported
2026-05-07 11:16:28,282 - INFO - ConsultationProcessor initialized
2026-05-07 11:16:28,282 - INFO - PollingService initialized with 3 minute interval
2026-05-07 11:16:28,282 - INFO - SFTP polling loop started
2026-05-07 11:16:28,283 - INFO - Starting scheduled SFTP scan...
2026-05-07 11:16:28,283 - INFO - SFTP polling service started - scanning every 3 minutes
2026-05-07 11:16:28,283 - INFO - SFTP polling enabled (ingress_mode=both)
2026-05-07 11:16:28,283 - INFO - FastAPI application started successfully
INFO:     Application startup complete.
ERROR:    [Errno 98] error while attempting to bind on address ('127.0.0.1', 8012): address already in use
INFO:     Waiting for application shutdown.
2026-05-07 11:16:28,444 - INFO - Shutting down FastAPI application...
2026-05-07 11:16:28,444 - INFO - Stopping SFTP polling service...
2026-05-07 11:16:28,469 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-07 11:16:28,796 - INFO - Authentication (publickey) successful!
2026-05-07 11:16:28,797 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-07 11:16:28,876 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-07 11:16:28,995 - INFO - [chan 0] sftp session closed.
2026-05-07 11:16:28,996 - INFO - Scanning SFTP directory for files...
2026-05-07 11:16:29,172 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-07 11:16:29,395 - INFO - Authentication (publickey) successful!
2026-05-07 11:16:29,395 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-07 11:16:29,478 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-07 11:16:29,595 - INFO - [chan 0] sftp session closed.
2026-05-07 11:16:29,596 - INFO - Found 1 zip files to process
2026-05-07 11:16:29,596 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-05-07 11:16:29,770 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-07 11:16:29,948 - INFO - Authentication (publickey) successful!
2026-05-07 11:16:29,948 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-07 11:16:30,040 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-07 11:16:30,201 - INFO - [chan 0] sftp session closed.
2026-05-07 11:16:30,202 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,308 - INFO - Uploaded to S3: connector-service-request-response/encrypted/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,308 - INFO - Saved encrypted file to S3: connector-service-request-response/encrypted/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,351 - WARNING - gpg returned a non-zero error code: 2
2026-05-07 11:16:35,351 - INFO - Decrypted file to /tmp/tmpyezg8zu3/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,389 - INFO - Uploaded to S3: connector-service-request-response/decrypted/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,389 - INFO - Saved decrypted file to S3: connector-service-request-response/decrypted/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,428 - INFO - Uploaded to S3: connector-service-request-response/requests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 11:16:35,428 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-05-07 11:16:35,429 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-05-07 11:16:35,462 - INFO - Uploaded JSON to S3: connector-service-request-response/requests/extracted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-07 11:16:35,462 - INFO - Saved extracted JSON to S3: connector-service-request-response/requests/extracted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-07 11:16:35,462 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-05-07 11:16:35,501 - INFO - Uploaded JSON to S3: connector-service-request-response/requests/1rx_request_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-07 11:16:35,502 - INFO - Saved 1Rx request to S3: connector-service-request-response/requests/1rx_request_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-07 11:16:35,503 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-05-07 11:16:35,519 - ERROR - [consultation_id=3bcecd65-9d61-4016-94ea-5413d08e3e2c] 1Rx API error 400: {"data":null,"error":{"code":400,"message":"Invalid patient phone number for order id 404-7623963-2495509. Supported format is xxxxxxxxxx. ","status":"Bad Request"}}
2026-05-07 11:16:35,520 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 5.92s (active=0)
2026-05-07 11:16:35,520 - INFO - SFTP scan completed - Duration: 7.24s, Found: 1, Processed: 1
2026-05-07 11:16:35,520 - INFO - SFTP polling loop stopped
2026-05-07 11:16:35,521 - INFO - SFTP polling service stopped
2026-05-07 11:16:35,521 - INFO - FastAPI application shutdown complete
INFO:     Application shutdown complete.