Subversion Repositories SmartDukaan

Last modification

• Rev 37553 2026-09-09 13:11:25
• Author: amit

• Log message:

  web offer sync: all_banks is TINYINT(1), so never cast it to Number
  
  ClassCastException: java.lang.Boolean cannot be cast to java.lang.Number, thrown from
  selectPublishableOffers on every ingest since 2026-09-08. Confirmed against the live
  driver: SELECT all_banks returns java.lang.Boolean.
  
  MySQL Connector/J maps TINYINT(1) to Boolean while Hibernate may hand back a Number,
  so the value must be read through isTrue() - the same shape as ScopeConfig.isTrue and
  OfferScopeRepositoryImpl.isTrue, both of which exist for exactly this reason and both
  of which I had in front of me when writing the cast.
  
  The failure was silent by design: CircularIngestRunner swallows sync exceptions so a
  web-offer problem can never fail a good ingest. The circular kept publishing, the
  document's processed_at kept moving, and the only symptom was that web_offer.synced_at
  stopped advancing - which is what should have been checked before reporting the sync
  as working on 8 September.