[2026-04-21T00:09:02+00:00] INFO Worker PID set {"job_id":225,"pid":5}
[2026-04-21T00:09:02+00:00] INFO Report job started {"job_id":225,"status":"Coming Soon","from":null,"to":"2026-04-21","property_types":["Residential"],"subtypes":[],"use_close_date":false,"temp_table":"temp_mls_data_coming_soon"}
[2026-04-21T00:09:03+00:00] INFO Temp table truncated {"table":"temp_mls_data_coming_soon"}
[2026-04-21T00:09:03+00:00] INFO Spark initial request {"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=%28StandardStatus+eq+%27Coming+Soon%27%29+and+%28PropertyType+eq+%27Residential%27%29+and+ModificationTimestamp+le+2026-04-21T23%3A59%3A59Z&%24select=ListingId%2CStandardStatus%2CModificationTimestamp%2CCloseDate&%24orderby=ModificationTimestamp+asc%2CListingKey+asc&%24top=1000"}
[2026-04-21T00:09:04+00:00] INFO Spark API response {"status":200,"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=%28StandardStatus+eq+%27Coming+Soon%27%29+and+%28PropertyType+eq+%27Residential%27%29+and+ModificationTimestamp+le+2026-04-21T23%3A59%3A59Z&%24select=ListingId%2CStandardStatus%2CModificationTimestamp%2CCloseDate&%24orderby=ModificationTimestamp+asc%2CListingKey+asc&%24top=1000","count":174,"duration_ms":1412}
[2026-04-21T00:09:05+00:00] INFO MLS page processed {"page":1,"total_inserted":174}
[2026-04-21T00:09:05+00:00] INFO Spark nextLink {"nextLink":null}
[2026-04-21T00:09:05+00:00] INFO MLS data loaded {"status":"Coming Soon","count":174,"table":"temp_mls_data_coming_soon"}
[2026-04-21T00:09:05+00:00] INFO Computing missing in DB {"table":"temp_mls_data_coming_soon"}
[2026-04-21T00:09:05+00:00] INFO Missing in DB computed {"count":0}
[2026-04-21T00:09:05+00:00] INFO Computing missing in MLS {"status":"Coming Soon"}
[2026-04-21T00:09:05+00:00] INFO Missing in MLS computed {"count":3}
[2026-04-21T00:09:05+00:00] INFO Prepared report payload {"missing_db_bytes":2,"missing_mls_bytes":292,"memory_mb":2}
[2026-04-21T00:09:05+00:00] INFO Report payload written to file {"job_id":225,"label":"missing_db","path":"logs/reports/data/report-225-missing_db.json","bytes":2}
[2026-04-21T00:09:05+00:00] INFO Report payload written to file {"job_id":225,"label":"missing_mls","path":"logs/reports/data/report-225-missing_mls.json","bytes":292}
[2026-04-21T00:09:05+00:00] INFO Report completed {"job_id":225,"missing_db":0,"missing_mls":3}