Getting 'cannot log in' errors and SQL erros from repo.
I'll try to provide as much context here as possible. Let me know if you need any more information.
We have a Jazz server set up for our software engineering class. The students are developing a Java project in Rational Team Concert. They are divided into groups of two, and each group has a workspace. Both students are 'team-members' of their workspaces. They're keeping the projects on their workspaces so that they can load them from anywhere, work on them, and submit their changes. Everything was working fine until a few days ago. Now the Jazz server seems to have blown up. We're getting a lot of different errors. Some students are not having any problems, some are having problems with working with large check-in's, and some cannot use their repositories at all. Here's one of the more extreme cases. In Team Artifacts, create a new connection, provide the URI of the Jazz server, and log in. Create a new repository workspace and select the team's workspace. Select 'Load Eclipse Projects' and select the project to be loaded. While the project attempts to download, an error along the lines of "cannot connect to x.x" keeps flashing next to the project folder, where x.x is the address of the Jazz server. Eventually we get the following errors: http://img227.imageshack.us/my.php?image=ss1hk6.jpg http://img227.imageshack.us/my.php?image=ss2cb6.jpg It looks like there is something wrong with the SQL database on the server. Any suggestions? Thanks for you help! |
2 answers
Error Code: -1218 You are running out of bufferpool space. Try the solution in comment 11 in bug 59952. - Dmitry |
The error seems to have occurred when our server restarted over the weekend.
Another student has reported the issue with the full stacktrace below: CRJAZ0265I The virtual storage or database resource is not available. SQL: select t1.ITEM_ID, t1.STATE_ID from SCM.WORKSPACE t1 where (t1.OWNER_ITEM_ID = '_qpwegH-xEd2_pI9tNhIUhQ') SQL Exception #1 SQL Message: DB2 SQL error: SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096 SQL State: 57011 Error Code: -1218 CRJAZ0265I The virtual storage or database resource is not available. SQL: select t1.ITEM_ID, t1.STATE_ID from SCM.WORKSPACE t1 where (t1.OWNER_ITEM_ID = '_qpwegH-xEd2_pI9tNhIUhQ') SQL Exception #1 SQL Message: DB2 SQL error: SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096 SQL State: 57011 Error Code: -1218 There were errors during download. It is recommended that components be reloaded. The reload will be incremental, loading only the missing items. You can further reduce the reload time by reloading just the projects out of sync. Failed to download /iTrust/.classpath CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/iTrust HTTP Tests.launch CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/itrust-build.xml CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/.djunitplugin CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/iTrust Unit Tests.launch CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/WebRoot/loginPage.jsp CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/WebRoot/logout.jsp CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/WebRoot/resetPassword.jsp CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/WebRoot/privacyPolicy.jsp CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/WebRoot/displayWikiDatabase.jsp CRJAZ0098I Return code 500 from http request: Internal Server Error Failed to download /iTrust/WebRoot/resources/menuIE.css CRJAZ0098I Return code 500 from http request: Internal Server ...etc.... Any help would be very much appreciated! |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.