FishEye, Crucible 4.4 버전이 릴리스 되었습니다. 자세한 사항은 FishEye 4.4 릴리스노트 를 참조하십시요..
페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동

 문제

Issue are not created via Email Requests in JIRA Service Desk

After making the following action:

  • Upgrade database

The following appears in the atlassian-jira.log

atlassian-scheduler-quartz1.clustered_Worker-2 ERROR ServiceRunner     [atlassian.mail.incoming.jepp] Error while serializing message
com.sun.mail.util.MessageRemovedIOException
atlassian-scheduler-quartz1.clustered_QuartzSchedulerThread ERROR      [org.quartz.core.ErrorLogger] An error occurred while scanning for the next trigger to fire.
org.quartz.JobPersistenceException: Couldn't acquire next trigger: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2814)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2757)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3788)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2753)
	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1

 

 진단

Environment

  • A migration/upgrade of MySQL database was done recently
  • JIRA is running on MySQL 5.6.x
  • The MySQL driver is relatively old (for instance version 5.1.10).
  • Checking the services in Scheduler Details for MailPullerJobRunner, it seems that the services have stuck

 원인

An outdated driver for the database is used:

 

Database Version                              : MySQL - 5.6.29
Database Driver                               : MySQL-AB JDBC Driver - mysql-connector-java-5.1.10 ( Revision: ${svn.Revision} )

 

 해결방법

  1. Download the most up-to-date driver from http://dev.mysql.com/downloads/connector/j (Platform Independent one).
  2. Replace the MySQL driver (.jar file) in $JIRA_INSTALL/lib with the later version.
  3. Restart JIRA.
  4. Verify that services are running again.

 

  • 레이블 없음