Hi,
Since the upgrade of the VOMS server we're experiencing some issues
with the EMI 3 system (we're using SLC 6).
I tried the upgrade (from EMI 2 to EMI 3), and
I also tried the clean install, but the new VOMS still isn't working
properly.
I followed the instructions from
http://italiangrid.github.io/voms/documentation/sysadmin-guide/3.0.0/,
and imported the original database after install.
Furthermore VOMS services started successfully:
[root@grid11 ~]# service voms-admin status
VOMS admin container: [ OK ]
VO (hungrid): [ UP ]
But I still have these errors (
/var/log/voms-admin/voms-admin-hungrid.log):
2013-11-07 09:02:12.093Z - INFO [VOMSConfiguration] - Setting CONF_DIR
from context: //etc/voms-admin
2013-11-07 09:02:12.103Z - INFO [VOMSService] - VOMS-Admin starting for
VO: hungrid
2013-11-07 09:02:14.265Z - INFO [VOMSExecutorService] - Scheduling task
UpdateCATask with period: 3600 seconds
2013-11-07 09:02:14.267Z - INFO [VOMSExecutorService] - Scheduling task
TaskStatusUpdater with period: 30 seconds
2013-11-07 09:02:14.267Z - INFO [VOMSExecutorService] - Scheduling task
ExpiredRequestsPurgerTask with period: 300 seconds
2013-11-07 09:02:14.268Z - INFO [VOMSExecutorService] - Scheduling task
UserStatsTask with period: 3600 seconds
2013-11-07 09:02:15.542Z - INFO [DefaultMembershipCheckBehaviour] -
Expired users will be suspended after a grace period of 7 days.
2013-11-07 09:02:15.559Z - INFO [VOMSExecutorService] - Scheduling task
MembershipCheckerTask with period: 600 seconds
2013-11-07 09:02:15.559Z - INFO [VOMSService] - VOMS-Admin started
succesfully.
2013-11-07 09:02:24.483Z - INFO [VOMSCADAO] - Adding
[log in to unmask] to trusted CA
database.
2013-11-07 09:02:24.572Z - INFO [VOMSCADAO] - Adding
[log in to unmask] to trusted CA
database.
2013-11-07 09:02:24.699Z - INFO [VOMSCADAO] - Adding
[log in to unmask] to
trusted CA database.
2013-11-07 09:02:25.260Z - ERROR [JDBCExceptionReporter] - Unknown
column 'request8_.approver_ca' in 'field list'
2013-11-07 09:02:25.260Z - ERROR [DatabaseTransactionTaskWrapper] - An
unexpected exception was caught while executing task TaskStatusUpdater
2013-11-07 09:02:25.264Z - ERROR [DatabaseTransactionTaskWrapper] -
could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.loader.Loader.doList(Loader.java:2216)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.loader.Loader.list(Loader.java:2099)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.glite.security.voms.admin.persistence.dao.hibernate.GenericHibernateDAO.findByCriteria(GenericHibernateDAO.java:133)
~[classes/:na]
at
org.glite.security.voms.admin.persistence.dao.hibernate.TaskDAOHibernate.getActiveTasks(TaskDAOHibernate.java:125)
~[classes/:na]
at
org.glite.security.voms.admin.core.tasks.TaskStatusUpdater.run(TaskStatusUpdater.java:39)
~[classes/:na]
at
org.glite.security.voms.admin.core.tasks.DatabaseTransactionTaskWrapper.run(DatabaseTransactionTaskWrapper.java:50)
~[classes/:na]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[na:1.7.0_19]
at
java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
[na:1.7.0_19]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
[na:1.7.0_19]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
[na:1.7.0_19]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
[na:1.7.0_19]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_19]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_19]
at java.lang.Thread.run(Thread.java:722) [na:1.7.0_19]
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown
column 'request8_.approver_ca' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
~[mysql-connector-java-5.0.7.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
~[mysql-connector-java-5.0.7.jar:na]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
~[mysql-connector-java-5.0.7.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
~[mysql-connector-java-5.0.7.jar:na]
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
~[mysql-connector-java-5.0.7.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
~[mysql-connector-java-5.0.7.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
~[mysql-connector-java-5.0.7.jar:na]
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
~[c3p0-0.9.1.jar:0.9.1]
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
at org.hibernate.loader.Loader.doList(Loader.java:2213)
~[hibernate-3.2.6.ga.jar:3.2.6.ga]
... 17 common frames omitted
Any help would be appreciated.
Cheers,
Andras
|