Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 6.0.5 GA, 6.0.6 GA
    • Fix Version/s: 6.0.X EE
    • Labels:
      None
    • Environment:
      Windows XP Professional
      Glassfish v3
      Sun JDK 1.6.0_21
      MySQL Server 5.1.48 @ Red Hat Enterprise Linux 5.5
      Liferay 6.0.5 GA (manually deploy on Glassfish)

      Description

      After

      -) setting up the database connection on Glassfish
      -) creating the file portal-ext.properties \

      portal-ext.properties
      jdbc.default.jndi.name=jdbc/LiferayPool
      transaction.isolation.portal=4
      

      -) and dropping dropping portlet.jar, portal-service.jar & mysql-connector-5.1.13.jar into glassfish's domains\domain1\lib directory

      I'll get the following exception during auto-deployment:

      [#|2010-08-24T08:09:57.399+0200|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=25;_ThreadName=Thread-1;|08:09:57,399 ERROR [SchedulerMessageListener:53] Unable to process message {destinationName=liferay/scheduler_engine, responseDestinationName=null, responseId=null, payload=com.liferay.portal.kernel.scheduler.messaging.SchedulerRequest@cbb4da, values=null}
      com.liferay.portal.kernel.scheduler.SchedulerException: Unable to start scheduler
      	at com.liferay.portal.scheduler.quartz.QuartzSchedulerEngineImpl.start(QuartzSchedulerEngineImpl.java:276)
      	at com.liferay.portal.scheduler.messaging.SchedulerMessageListener.doReceive(SchedulerMessageListener.java:85)
      	at com.liferay.portal.scheduler.messaging.SchedulerMessageListener.receive(SchedulerMessageListener.java:50)
      	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
      	at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      	at java.lang.Thread.run(Thread.java:619)
      Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Unknown column '' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '' in 'field list']]
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:623)
      	at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:466)
      	at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
      	at com.liferay.portal.scheduler.quartz.QuartzSchedulerEngineImpl.start(QuartzSchedulerEngineImpl.java:273)
      	... 7 more
      Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Unknown column '' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '' in 'field list']
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1567)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:946)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:830)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.execute(JobStoreSupport.java:802)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3708)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3704)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:798)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:621)
      	... 10 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '' in 'field list'
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
      	at com.mysql.jdbc.Util.getInstance(Util.java:384)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
      	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
      	at com.mysql.jdbc.BlobFromLocator.length(BlobFromLocator.java:338)
      	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3463)
      	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:2132)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1549)
      	... 18 more
      |#]
      

      It seems to be the same issue as LPS-12129 but is has been closed without providing a solution for the problem.

      After some debugging I think the exception occurs when liferay is trying to read some information out of QUARTZ_TRIGGERS using a SELECT statement without aliases.

        Attachments

          Activity

            People

            • Votes:
              5 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 32 weeks, 1 day ago