INFO:     Started server process [1856048]
INFO:     Waiting for application startup.
2026-05-07 13:51:28,943 - INFO - Starting FastAPI application...
2026-05-07 13:51:28,955 - INFO - MySQL connection pool initialized: localhost:3306
2026-05-07 13:51:28,956 - INFO - Database tables initialized successfully
2026-05-07 13:51:29,136 - INFO - Importing public key from: /home/rxco/public_html/connector-app/keys/PGPPublicKey.asc
2026-05-07 13:51:29,141 - INFO - Import result: 0 imported
2026-05-07 13:51:29,141 - INFO - Set encryption recipient: 7F474ABE432B79B6ADE35A7A1A00E976D4B8366A
2026-05-07 13:51:29,163 - INFO - Private key import: 0 imported
2026-05-07 13:51:29,163 - INFO - ConsultationProcessor initialized
2026-05-07 13:51:29,163 - INFO - PollingService initialized with 3 minute interval
2026-05-07 13:51:29,163 - INFO - SFTP polling loop started
2026-05-07 13:51:29,164 - INFO - SFTP polling service started - scanning every 3 minutes
2026-05-07 13:51:29,164 - INFO - Starting scheduled SFTP scan...
2026-05-07 13:51:29,164 - INFO - SFTP polling enabled (ingress_mode=both)
2026-05-07 13:51:29,321 - 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 13:51:29,324 - INFO - Shutting down FastAPI application...
2026-05-07 13:51:29,324 - INFO - Stopping SFTP polling service...
2026-05-07 13:51:29,342 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-07 13:51:29,669 - INFO - Authentication (publickey) successful!
2026-05-07 13:51:29,670 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-07 13:51:29,760 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-07 13:51:29,871 - INFO - [chan 0] sftp session closed.
2026-05-07 13:51:29,872 - INFO - Scanning SFTP directory for files...
2026-05-07 13:51:30,046 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-07 13:51:30,256 - INFO - Authentication (publickey) successful!
2026-05-07 13:51:30,257 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-07 13:51:30,332 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-07 13:51:30,423 - INFO - [chan 0] sftp session closed.
2026-05-07 13:51:30,423 - INFO - Found 1 zip files to process
2026-05-07 13:51:30,423 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-05-07 13:51:30,593 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-07 13:51:30,804 - INFO - Authentication (publickey) successful!
2026-05-07 13:51:30,805 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-07 13:51:30,888 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-07 13:51:31,001 - INFO - [chan 0] sftp session closed.
2026-05-07 13:51:31,001 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 13:51:31,071 - 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 13:51:31,071 - 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 13:51:31,114 - WARNING - gpg returned a non-zero error code: 2
2026-05-07 13:51:31,114 - INFO - Decrypted file to /tmp/tmpdkble8yv/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-07 13:51:31,153 - 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 13:51:31,153 - 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 13:51:31,194 - 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 13:51:31,194 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-05-07 13:51:31,195 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-05-07 13:51:31,252 - 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 13:51:31,252 - 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 13:51:31,252 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-05-07 13:51:31,294 - 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 13:51:31,294 - 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 13:51:31,295 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-05-07 13:51:31,302 - 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 13:51:31,304 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 0.88s (active=0)
2026-05-07 13:51:31,304 - INFO - SFTP scan completed - Duration: 2.14s, Found: 1, Processed: 1
2026-05-07 13:51:31,304 - INFO - SFTP polling loop stopped
2026-05-07 13:51:31,304 - INFO - SFTP polling service stopped
2026-05-07 13:51:31,305 - INFO - FastAPI application shutdown complete
INFO:     Application shutdown complete.