java.lang.IllegalStateException: HTTP request not available

Atlassian JIRA | Kah Loun Foong [Atlassian] | 11 months ago
tip
Do you find the tips below useful? Click on the to mark them and say thanks to rp . Or join the community to write better ones.
  1. 0

    h3. Summary Bamboo 5.10.2 have a few errors with MySQL h3. Environment * MySQL 5.5.27 * mysql-connector-java-5.1.38-bin.jar h3. Steps to Reproduce # Install Bamboo 5.10.2 # Configure MySQL database configuration The page http://localhost:8085/setup/performSetupDatabaseConnection.action loading non stop # After waiting for a while, reloading the URL http://localhost:8085 will redirect to http://localhost:8085/setup/setupSelectImport.action to proceed with the Setup # Enable "Manage trusted keys" in Security settings # Access {{Administration >> Security >> Trusted keys}} There is an error in the UI "The trusted key can't be read from the server." # Click on the button "Add key" to add trusted key There is an error in the UI "The trusted key can't be added. View the server logs for the details." h3. Expected Results # In Step 2, the page should auto redirect to http://localhost:8085/setup/setupSelectImport.action to proceed with the Setup # There shouldn't be any error in Step 5 # Add Trusted Key is successful h3. Actual Results # In Step 2, the below exception is thrown in the atlassian-bamboo.log file: {noformat} 2016-03-07 17:26:43,741 WARN [http-nio-8085-exec-23] [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 2016-03-07 17:26:43,741 ERROR [http-nio-8085-exec-23] [JDBCExceptionReporter] Table 'bamboo5102.rememberme_token' doesn't exist 2016-03-07 17:26:43,818 INFO [http-nio-8085-exec-23] [SpringObjectFactoryProxy] Switching to Struts-Spring object factory 2016-03-07 17:26:43,819 INFO [http-nio-8085-exec-23] [SpringObjectFactory] Setting autowire strategy to name 2016-03-07 17:26:43,819 INFO [http-nio-8085-exec-23] [StrutsSpringObjectFactory] Struts-Spring integration initialised successfully 2016-03-07 17:26:43,844 ERROR [http-nio-8085-exec-23] [ExceptionMappingInterceptor] HTTP request not available java.lang.IllegalStateException: HTTP request not available at com.google.common.base.Preconditions.checkState(Preconditions.java:173) at com.atlassian.bamboo.util.RequestCacheThreadLocal.getNonNullRequest(RequestCacheThreadLocal.java:124) ... 2016-03-07 17:26:43,986 ERROR [http-nio-8085-exec-23] [FiveOhOh] 500 Exception was thrown. org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.bamboo.security.RememberMeTokenImpl#753665]; SQL [select rememberme0_.id as id52_0_, rememberme0_.USERNAME as USERNAME52_0_, rememberme0_.CREATED as CREATED52_0_, rememberme0_.TOKEN as TOKEN52_0_ from REMEMBERME_TOKEN rememberme0_ where rememberme0_.id=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.bamboo.security.RememberMeTokenImpl#753665] ... 2016-03-07 17:26:56,146 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Unsuccessful: create table TRUSTED_KEY (id bigint not null, HOST varchar(255) not null, SSH_KEY varchar(4000) not null, APPROVED bit not null, primary key (id), unique (HOST, SSH_KEY)) 2016-03-07 17:26:56,147 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Specified key was too long; max key length is 767 bytes 2016-03-07 17:27:43,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Unsuccessful: create index tk_host_idx on TRUSTED_KEY (HOST) 2016-03-07 17:27:43,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Table 'bamboo5102.trusted_key' doesn't exist {noformat} # In Step 5 and 6, the below exception is thrown in the atlassian-bamboo.log file: {noformat} 2016-03-07 18:28:00,252 INFO [http-nio-8085-exec-10] [AccessLogFilter] kahloun.foong GET http://localhost:8085/rest/admin/latest/security/trustedKey 24536kb 2016-03-07 18:28:00,257 WARN [http-nio-8085-exec-10] [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 2016-03-07 18:28:00,258 ERROR [http-nio-8085-exec-10] [JDBCExceptionReporter] Table 'bamboo5102.trusted_key' doesn't exist 2016-03-07 18:28:00,259 WARN [http-nio-8085-exec-10] [BambooRuntimeExceptionMapper] Unexpected error from REST call org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id53_0_, this_.HOST as HOST53_0_, this_.SSH_KEY as SSH3_53_0_, this_.APPROVED as APPROVED53_0_ from TRUSTED_KEY this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ... Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bamboo5102.trusted_key' doesn't exist {noformat} h3. Notes # In Step 2, even though the error log showing that REMEMBERME_TOKEN table does not exist, the table REMEMBERME_TOKEN does exist in the database. The second restart does not have this error # The table trusted_key fail to be created in the database due to SSH_KEY is too large to be added to Unique constraint: Specified key was too long; max key length is 767 bytes

    Atlassian JIRA | 11 months ago | Kah Loun Foong [Atlassian]
    java.lang.IllegalStateException: HTTP request not available
  2. 0

    h3. Summary Bamboo 5.10.2 have a few errors with MySQL h3. Environment * MySQL 5.5.27 * mysql-connector-java-5.1.38-bin.jar h3. Steps to Reproduce # Install Bamboo 5.10.2 # Configure MySQL database configuration The page http://localhost:8085/setup/performSetupDatabaseConnection.action loading non stop # After waiting for a while, reloading the URL http://localhost:8085 will redirect to http://localhost:8085/setup/setupSelectImport.action to proceed with the Setup # Enable "Manage trusted keys" in Security settings # Access {{Administration >> Security >> Trusted keys}} There is an error in the UI "The trusted key can't be read from the server." # Click on the button "Add key" to add trusted key There is an error in the UI "The trusted key can't be added. View the server logs for the details." h3. Expected Results # In Step 2, the page should auto redirect to http://localhost:8085/setup/setupSelectImport.action to proceed with the Setup # There shouldn't be any error in Step 5 # Add Trusted Key is successful h3. Actual Results # In Step 2, the below exception is thrown in the atlassian-bamboo.log file: {noformat} 2016-03-07 17:26:43,741 WARN [http-nio-8085-exec-23] [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 2016-03-07 17:26:43,741 ERROR [http-nio-8085-exec-23] [JDBCExceptionReporter] Table 'bamboo5102.rememberme_token' doesn't exist 2016-03-07 17:26:43,818 INFO [http-nio-8085-exec-23] [SpringObjectFactoryProxy] Switching to Struts-Spring object factory 2016-03-07 17:26:43,819 INFO [http-nio-8085-exec-23] [SpringObjectFactory] Setting autowire strategy to name 2016-03-07 17:26:43,819 INFO [http-nio-8085-exec-23] [StrutsSpringObjectFactory] Struts-Spring integration initialised successfully 2016-03-07 17:26:43,844 ERROR [http-nio-8085-exec-23] [ExceptionMappingInterceptor] HTTP request not available java.lang.IllegalStateException: HTTP request not available at com.google.common.base.Preconditions.checkState(Preconditions.java:173) at com.atlassian.bamboo.util.RequestCacheThreadLocal.getNonNullRequest(RequestCacheThreadLocal.java:124) ... 2016-03-07 17:26:43,986 ERROR [http-nio-8085-exec-23] [FiveOhOh] 500 Exception was thrown. org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.bamboo.security.RememberMeTokenImpl#753665]; SQL [select rememberme0_.id as id52_0_, rememberme0_.USERNAME as USERNAME52_0_, rememberme0_.CREATED as CREATED52_0_, rememberme0_.TOKEN as TOKEN52_0_ from REMEMBERME_TOKEN rememberme0_ where rememberme0_.id=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.bamboo.security.RememberMeTokenImpl#753665] ... 2016-03-07 17:26:56,146 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Unsuccessful: create table TRUSTED_KEY (id bigint not null, HOST varchar(255) not null, SSH_KEY varchar(4000) not null, APPROVED bit not null, primary key (id), unique (HOST, SSH_KEY)) 2016-03-07 17:26:56,147 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Specified key was too long; max key length is 767 bytes 2016-03-07 17:27:43,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Unsuccessful: create index tk_host_idx on TRUSTED_KEY (HOST) 2016-03-07 17:27:43,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Table 'bamboo5102.trusted_key' doesn't exist {noformat} # In Step 5 and 6, the below exception is thrown in the atlassian-bamboo.log file: {noformat} 2016-03-07 18:28:00,252 INFO [http-nio-8085-exec-10] [AccessLogFilter] kahloun.foong GET http://localhost:8085/rest/admin/latest/security/trustedKey 24536kb 2016-03-07 18:28:00,257 WARN [http-nio-8085-exec-10] [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 2016-03-07 18:28:00,258 ERROR [http-nio-8085-exec-10] [JDBCExceptionReporter] Table 'bamboo5102.trusted_key' doesn't exist 2016-03-07 18:28:00,259 WARN [http-nio-8085-exec-10] [BambooRuntimeExceptionMapper] Unexpected error from REST call org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id53_0_, this_.HOST as HOST53_0_, this_.SSH_KEY as SSH3_53_0_, this_.APPROVED as APPROVED53_0_ from TRUSTED_KEY this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ... Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bamboo5102.trusted_key' doesn't exist {noformat} h3. Notes # In Step 2, even though the error log showing that REMEMBERME_TOKEN table does not exist, the table REMEMBERME_TOKEN does exist in the database. The second restart does not have this error # The table trusted_key fail to be created in the database due to SSH_KEY is too large to be added to Unique constraint: Specified key was too long; max key length is 767 bytes

    Atlassian JIRA | 11 months ago | Kah Loun Foong [Atlassian]
    java.lang.IllegalStateException: HTTP request not available
  3. 0
    samebug tip
    Check if there is no nexus running. If not, delete sonatype-work/nexus/nexus.lock .
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Google Maps Api

    GitHub | 2 years ago | danielgomezrico
    java.lang.IllegalStateException: google.api-key not set
  6. 0

    Confusing logging message in IncompletePaymentTransactionTask

    GitHub | 2 years ago | pierre
    org.killbill.notificationq.NotificationQueueException: java.lang.IllegalStateException: Janitor IncompletePaymentTransactionTask cannot retrieve PaymentPluginApi c9b4fe7b-eb0c-48f8-b3d8-9840eb33ced5, skipping

  1. jf-ast 3 times, last 1 week ago
  2. SteVio1989 16 times, last 3 weeks ago
  3. Hronom 2 times, last 1 month ago
  4. raytest 1 times, last 1 month ago
  5. fervidnerd 2 times, last 3 months ago
9 more registered users
63 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.IllegalStateException

    HTTP request not available

    at com.google.common.base.Preconditions.checkState()
  2. Guava
    Preconditions.checkState
    1. com.google.common.base.Preconditions.checkState(Preconditions.java:173)
    1 frame
  3. com.atlassian.bamboo
    RequestCacheThreadLocal.getNonNullRequest
    1. com.atlassian.bamboo.util.RequestCacheThreadLocal.getNonNullRequest(RequestCacheThreadLocal.java:124)
    1 frame