INFO:     Started server process [2322886]
INFO:     Waiting for application startup.
2026-09-03 02:02:42,683 - INFO - Starting FastAPI application...
2026-09-03 02:02:42,700 - INFO - MySQL connection pool initialized: localhost:3306
2026-09-03 02:02:42,712 - INFO - Database tables initialized successfully
2026-09-03 02:02:42,719 - INFO - Importing public key from: /home/rxco/public_html/connector-app/keys/PGPPublicKey.asc
2026-09-03 02:02:42,725 - INFO - Import result: 0 imported
2026-09-03 02:02:42,725 - INFO - Set encryption recipient: 7F474ABE432B79B6ADE35A7A1A00E976D4B8366A
2026-09-03 02:02:42,747 - INFO - Private key import: 0 imported
2026-09-03 02:02:42,747 - INFO - ConsultationProcessor initialized
2026-09-03 02:02:42,747 - INFO - PollingService initialized with 3 minute interval
2026-09-03 02:02:42,747 - INFO - SFTP polling loop started
2026-09-03 02:02:42,748 - INFO - Starting scheduled SFTP scan...
2026-09-03 02:02:42,748 - INFO - SFTP polling service started - scanning every 3 minutes
2026-09-03 02:02:42,905 - INFO - SFTP polling enabled (ingress_mode=both)
2026-09-03 02:02:42,905 - INFO - FastAPI application started successfully
INFO:     Application startup complete.
INFO:     Uvicorn running on http://127.0.0.1:8012 (Press CTRL+C to quit)
2026-09-03 02:02:42,945 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-03 02:02:43,239 - INFO - Authentication (publickey) successful!
2026-09-03 02:02:43,239 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-03 02:02:43,337 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-03 02:02:43,441 - INFO - [chan 0] sftp session closed.
2026-09-03 02:02:43,441 - INFO - Scanning SFTP directory for files...
2026-09-03 02:02:43,637 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-03 02:02:43,923 - INFO - Authentication (publickey) successful!
2026-09-03 02:02:43,924 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-03 02:02:44,017 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-03 02:02:44,095 - INFO - [chan 0] sftp session closed.
2026-09-03 02:02:44,096 - INFO - Found 1 zip files to process
2026-09-03 02:02:44,096 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-09-03 02:02:44,320 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-03 02:02:44,515 - INFO - Authentication (publickey) successful!
2026-09-03 02:02:44,516 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-03 02:02:44,613 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-03 02:02:44,705 - INFO - [chan 0] sftp session closed.
2026-09-03 02:02:44,705 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-09-03 02:02:44,751 - WARNING - gpg returned a non-zero error code: 2
2026-09-03 02:02:44,752 - INFO - Decrypted file to /tmp/tmpf0o0j2le/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-09-03 02:02:44,752 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-09-03 02:02:44,752 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-09-03 02:02:44,753 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-09-03 02:02:44,754 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-09-03 02:02:44,770 - ERROR - [consultation_id=3bcecd65-9d61-4016-94ea-5413d08e3e2c] 1Rx API error 400 (attempt 1/3): {"data":null,"error":{"code":400,"message":"Invalid patient phone number for order id 404-7623963-2495509. Supported format is xxxxxxxxxx. ","status":"Bad Request"}}
2026-09-03 02:02:44,772 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 0.68s (active=0)
2026-09-03 02:02:44,772 - INFO - SFTP scan completed - Duration: 2.02s, Found: 1, Processed: 1
INFO:     Shutting down
INFO:     Waiting for application shutdown.
2026-09-03 02:03:57,697 - INFO - Shutting down FastAPI application...
2026-09-03 02:03:57,698 - INFO - Stopping SFTP polling service...