Uploaded image for project: 'Mobile App'
  1. Mobile App
  2. MOBILEAPP-114

Push notifications fail when sent to too many users

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 1.21.0
    • None
    • None
    • None
    • 4.10 M7

      Unable to setup the schedulable that checks for failed pushs

      org.quartz.JobPersistenceException: Couldn't store job: Data truncation: Data too long for column 'JOB_DATA' at row 1 [See nested exception: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'JOB_DATA' at row 1]
              at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1123)
              at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.executeVoid(JobStoreSupport.java:1067)
              at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3780)
              at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3778)
              at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3864)
              at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
              at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1063)
              at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:855)
              at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:249)
              at org.ametys.plugins.core.schedule.Scheduler.scheduleJob(Scheduler.java:392)
              at org.ametys.plugins.mobileapp.PushNotificationManager.pushNotifications(PushNotificationManager.java:204)
              at org.ametys.plugins.mobileapp.observer.ContentValidatedObserver.observe(ContentValidatedObserver.java:223)
              at org.ametys.core.observation.ObservationManager$ParallelAsyncObserve._observe(ObservationManager.java:512)
              at org.ametys.core.observation.ObservationManager$AbstractAsyncObserve.call(ObservationManager.java:449)
              at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
              at java.base/java.lang.Thread.run(Thread.java:1583)
      Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'JOB_DATA' at row 1
              at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
              at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertJobDetail(StdJDBCDelegate.java:624)
              at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1117)
              ... 17 more
      

            cedric Cédric Damioli
            cedric Cédric Damioli
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: