Create Sign up Log in
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Community resources
Community resources
- Community
- Answers Developer Questions
- Questions
- Unable to start Jira in localhost
Unable to start Jira in localhost
Hi all,
I have a problem with my local JIRA instance, this error appear when start and I don't found solution. The instance run correctly last week and now show this error. I changed the password, database name and I show always the same error.
Any solution?
Edit: The MySql exception doesn't show user/server correctly, the exception shows "''@'%'" when the user is "jira" and server is "localhost".
Thanks an regards.
****************
JIRA starting...
****************
2015-04-20 13:43:14,613 localhost-startStop-1 INFO [atlassian.jira.startup.JiraStartupLogger]
___ Environment _____________________________
JIRA Build : 6.0.8#6109-sha1:57cf0994e68656877c0b65494d19956a638f4633
Build Date : Wed Aug 28 00:00:00 CEST 2013
JIRA Installation Type : Standalone
Application Server : Apache Tomcat/7.0.29 - Servlet API 3.0
Java Version : 1.7.0_60 - Oracle Corporation
Current Working Directory : XXX\atlassian-jira-6.0.8-standalone\bin
Maximum Allowable Memory : 683MB
Total Memory : 467MB
Free Memory : 270MB
Used Memory : 197MB
Memory Pool: Code Cache : Code Cache: init = 2555904(2496K) used = 2328064(2273K) committed = 2555904(2496K) max = 50331648(49152K)
Memory Pool: PS Eden Space : PS Eden Space: init = 100663296(98304K) used = 130815696(127749K) committed = 201326592(196608K) max = 214433792(209408K)
Memory Pool: PS Survivor Space : PS Survivor Space: init = 16777216(16384K) used = 20441944(19962K) committed = 20447232(19968K) max = 20447232(19968K)
Memory Pool: PS Old Gen : PS Old Gen: init = 268435456(262144K) used = 55724032(54418K) committed = 268435456(262144K) max = 536870912(524288K)
Memory Pool: PS Perm Gen : PS Perm Gen: init = 22020096(21504K) used = 17199440(16796K) committed = 22020096(21504K) max = 402653184(393216K)
JVM Input Arguments : -XX:MaxPermSize=384m -Xms384m -Xmx768m -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Dmail.mime.decodeparameters=true -XX:+PrintGCDateStamps -Djava.util.logging.config.file=XXX\atlassian-jira-6.0.8-standalone\conf\logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xdebug -Xrunjdwp:transport=dt_socket,address=8000,server=y,suspend=n -Djava.endorsed.dirs=XXX\atlassian-jira-6.0.8-standalone\endorsed -Dcatalina.base=XXX\atlassian-jira-6.0.8-standalone -Dcatalina.home=XXX\atlassian-jira-6.0.8-standalone -Djava.io.tmpdir=XXX\atlassian-jira-6.0.8-standalone\temp
Java Compatibility Information : JIRA version = 6.0.8, Java Version = 1.7.0_60
___ Java System Properties ________________
atlassian.standalone : JIRA
awt.toolkit : sun.awt.windows.WToolkit
catalina.base : XXX\atlassian-jira-6.0.8-standalone
catalina.home : XXX\atlassian-jira-6.0.8-standalone
catalina.useNaming : true
common.loader : ${catalina.base}/lib,
${catalina.base}/lib/*.jar,
${catalina.home}/lib,
${catalina.home}/lib/*.jar
file.encoding : Cp1252
file.encoding.pkg : sun.io
java.awt.graphicsenv : sun.awt.Win32GraphicsEnvironment
java.awt.headless : true
java.awt.printerjob : sun.awt.windows.WPrinterJob
java.class.version : 51.0
java.home : D:\Desarrollo\Java\JDK\x64\jdk1.7.0_60\jre
java.io.tmpdir : XXX\atlassian-jira-6.0.8-standalone\temp
java.naming.factory.initial : org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs : org.apache.naming
java.runtime.name : Java(TM) SE Runtime Environment
java.runtime.version : 1.7.0_60-b19
java.specification.name : Java Platform API Specification
java.specification.vendor : Oracle Corporation
java.specification.version : 1.7
java.util.logging.config.file : XXX\atlassian-jira-6.0.8-standalone\conf\logging.properties
java.util.logging.manager : org.apache.juli.ClassLoaderLogManager
java.vendor : Oracle Corporation
java.vendor.url : http://java.oracle.com/
java.vendor.url.bug : http://bugreport.sun.com/bugreport/
java.version : 1.7.0_60
java.vm.info : mixed mode
java.vm.name : Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name : Java Virtual Machine Specification
java.vm.specification.vendor : Oracle Corporation
java.vm.specification.version : 1.7
java.vm.vendor : Oracle Corporation
java.vm.version : 24.60-b09
mail.mime.decodeparameters : true
org.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER : true
os.arch : amd64
os.name : Windows 7
os.version : 6.1
package.access : sun.,
org.apache.catalina.,
org.apache.coyote.,
org.apache.tomcat.,
org.apache.jasper.
package.definition : sun.,
java.,
org.apache.catalina.,
org.apache.coyote.,
org.apache.tomcat.,
org.apache.jasper.
server.loader :
shared.loader :
sun.arch.data.model : 64
sun.boot.library.path : D:\Desarrollo\Java\JDK\x64\jdk1.7.0_60\jre\bin
sun.cpu.endian : little
sun.cpu.isalist : amd64
sun.desktop : windows
sun.io.unicode.encoding : UnicodeLittle
sun.java.command : org.apache.catalina.startup.Bootstrap start
sun.java.launcher : SUN_STANDARD
sun.jnu.encoding : Cp1252
sun.management.compiler : HotSpot 64-Bit Tiered Compilers
sun.os.patch.level : Service Pack 1
tomcat.util.buf.StringCache.byte.enabled : true
tomcat.util.scan.DefaultJarScanner.jarsToSkip : bootstrap.jar,
commons-daemon.jar,
tomcat-juli.jar,
annotations-api.jar,
el-api.jar,
jsp-api.jar,
servlet-api.jar,
catalina.jar,
catalina-ant.jar,
catalina-ha.jar,
catalina-tribes.jar,
jasper.jar,
jasper-el.jar,
ecj-*.jar,
tomcat-api.jar,
tomcat-util.jar,
tomcat-coyote.jar,
tomcat-dbcp.jar,
tomcat-jni.jar,
tomcat-spdy.jar,
tomcat-i18n-en.jar,
tomcat-i18n-es.jar,
tomcat-i18n-fr.jar,
tomcat-i18n-ja.jar,
tomcat-juli-adapters.jar,
catalina-jmx-remote.jar,
catalina-ws.jar,
tomcat-jdbc.jar,
commons-beanutils*.jar,
commons-codec*.jar,
commons-collections*.jar,
commons-dbcp*.jar,
commons-digester*.jar,
commons-fileupload*.jar,
commons-httpclient*.jar,
commons-io*.jar,
commons-lang*.jar,
commons-logging*.jar,
commons-math*.jar,
commons-pool*.jar,
jstl.jar,
geronimo-spec-jaxrpc*.jar,
wsdl4j*.jar,
ant.jar,
ant-junit*.jar,
aspectj*.jar,
jmx.jar,
h2*.jar,
hibernate*.jar,
httpclient*.jar,
jmx-tools.jar,
jta*.jar,
log4j*.jar,
mail*.jar,
slf4j*.jar,
xercesImpl.jar,
xmlParserAPIs.jar,
xml-apis.jar,
dnsns.jar,
ldapsec.jar,
localedata.jar,
sunjce_provider.jar,
sunmscapi.jar,
sunpkcs11.jar,
jhall.jar,
tools.jar,
sunec.jar,
zipfs.jar,
apple_provider.jar,
AppleScriptEngine.jar,
CoreAudio.jar,
dns_sd.jar,
j3daudio.jar,
j3dcore.jar,
j3dutils.jar,
jai_core.jar,
jai_codec.jar,
mlibwrapper_jai.jar,
MRJToolkit.jar,
vecmath.jar,
junit.jar,
junit-*.jar,
ant-launcher.jar
user.country : ES
user.dir : XXX\atlassian-jira-6.0.8-standalone\bin
user.home : C:\Users\usuario
user.language : es
user.name : usuario
user.script :
user.timezone : Europe/Paris
user.variant :
2015-04-20 13:43:14,964 localhost-startStop-1 INFO [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory 'XXX\atlassian-jira-6.0.8-standalone\home' is validated and locked for exclusive use by this instance.
2015-04-20 13:43:14,994 localhost-startStop-1 INFO [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from XXX\atlassian-jira-6.0.8-standalone\home\dbconfig.xml
2015-04-20 13:43:15,094 localhost-startStop-1 INFO [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2015-04-20 13:43:15,094 localhost-startStop-1 INFO [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2015-04-20 13:43:15,104 localhost-startStop-1 INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2015-04-20 13:43:16,640 localhost-startStop-1 ERROR [atlassian.jira.startup.LauncherContextListener] Unable to start JIRA.
com.atlassian.jira.exception.DataAccessException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user ''@'%' for column 'customvalue' in table 'customfieldoption'
at com.atlassian.jira.upgrade.util.UpgradeUtils.getExactColumnName(UpgradeUtils.java:180)
at com.atlassian.jira.upgrade.util.UpgradeUtils.getJIRABuildVersionNumber(UpgradeUtils.java:257)
at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.getDbBuildNumber(MinimumUpgradableVersionCheck.java:81)
at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.isOk(MinimumUpgradableVersionCheck.java:34)
at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.doStartupChecks(JiraDatabaseConfigChecklist.java:63)
at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:51)
at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:35)
at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:101)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:315)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:215)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:96)
at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:30)
at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:69)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:64)
at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:54) <+5> (StandardContext.java:4791) (StandardContext.java:5285) (LifecycleBase.java:150) (ContainerBase.java:1559) (ContainerBase.java:1549)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql</database-type>
<jdbc-datasource>
<url>jdbc:mysql://localhost:3306/jiradb?useUnicode=true&amp;characterEncoding=UTF8&amp;sessionVariables=storage_engine=InnoDB</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>jira</username>
<password>jira60</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-while-idle>true</pool-test-while-idle>
<validation-query-timeout>3</validation-query-timeout>
</jdbc-datasource>
</jira-database-config>
2 answers
1 accepted
Comments for this post are closed
Community moderators have prevented the ability to post new answers.
The problem are in mysql server, I reinstall the server and the problems have disappeared.
Pedro Souza
Atlassian Team
April 20, 2015 edited Atlassian Team members are employees working across the company in a wide variety of roles.
Hi Francisco,
As it seems to be related to the database user, I would suggest you to try to start with a different user, maybe using 'root' as a test, so we can adjust the user permissions or create a new user if you confirm that you can start using a different user.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pedro, Thanks for the response. I tested with root user and the error occurs. this line is strange, it seems that Jira is not getting the user / server correctly. {code} com.atlassian.jira.exception.DataAccessException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user ''@'%' for column 'customvalue' in table 'customfieldoption' {code}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Was this helpful?
Thanks!
TAGS
Atlassian Community Events
- FAQ
- Community Guidelines
- About
- Privacy policy
- Notice at Collection
- Terms of use
- © 2024 Atlassian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.