It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

error in script file line: 303330 java.io.IOException: org.hsqldb.HsqlException: Value too long

ksk jira Feb 16, 2016

Hi,  

we are getting the following issue after JIRA restarted.. we are not able to login. 

if any body has such situation and fix ..please share.

Thanks. 

Pavan 

 

 

1 answer

0 votes
Nic Brough [Adaptavist] Community Leader Feb 17, 2016

Your  dev/test database is damaged, and may not be recoverable.  I'd get a clean JIRA install and get a copy of your production data and restore that into it.  If the error occurs again, then you'll probably want to shift to using a proper database (ideally the same as the production one, so you can use a database dump to make the copies)

ksk jira Feb 17, 2016

Hi Nic,

 

Thanks for the reply..its happened on the PROD, do we have any other alternative to  recover or need fresh install and configurations ? 

since we have other plugins i am looking for the up and running the existing one. 

Thanks,

Pavan

Nic Brough [Adaptavist] Community Leader Feb 17, 2016

You are repeatedly told NOT to use HSQL for production systems during installation and in the admin screens, and this is one of the reasons why.  You could easily have lost everything in here. 

You might be able to rescue this, but there's no guarantee.  Go to the database directory and find the file jiradb.script - copy it to make sure there is a backup, then open the original in a text editor.  Go to line 303330 in there and shorten the data in the field you find.  Start JIRA back up and see if that works.  If it does, then you should run the XML export of the system and shut it down again.  Then set up a new system with a proper database and import the XML.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in United States

Topic Tuesday: Agile

Another week, another Topic Tuesday!  Agile has been on my mind a lot lately because I've seen good implementations and bad implementations, but now as a Jira admin it matters more to me whether...

32 views 0 0
View post

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you