One error and one warning since 9.3.7

[talcher]

Hello the EJBCA team,

I upgraded EJBCA to 9.3.7, using WildFly 35.0.1.

Since then, a few errors have been logged every hour at sharp. They look like that:

{
    "timestamp":"2026-04-23T14:00:00.013+02:00",
    "sequence":410912,
    "loggerClassName":"org.jboss.as.ejb3.logging.EjbLogger_$logger",
    "loggerName":"org.jboss.as.ejb3.timer",
    "level":"ERROR",
    "message":"WFLYEJB0020: Error invoking timeout for timer: [id=V4-UUID timedObjectId=ejbca.ejbca-ejb.ScepKeyRenewalSessionBean auto-timer?:false persistent?:false timerService=TimerServiceImpl(ejbca.ejbca-ejb.ScepKeyRenewalSessionBean) previousRun=Thu Apr 23 00:00:00 CEST 2026 initialExpiration=null intervalDuration(in milli sec)=0 nextExpiration=Thu Apr 23 15:00:00 CEST 2026 timerState=IN_TIMEOUT info=ScepKeyRenewal] ScheduleExpression [second=0;minute=0;hour=*;dayOfMonth=*;month=*;dayOfWeek=*;year=*;timezoneID=null;start=null;end=null]",
    "threadName":"EJB default - 1",
    "threadId":229,
    "mdc":{},
    "ndc":"",
    "hostName":"hostname",
    "processName":"jboss-modules.jar",
    "processId":101873,
    "exception":
    {   
        "refId":1,
        "exceptionType":"jakarta.ejb.EJBTransactionRolledbackException",
        "message":"JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=11947) Lock wait timeout exceeded; try restarting transaction] [n/a]",
        "frames":
...

Moreover, everytime I click on "Crypto Tokens" in the Web UI, I get this log:

WARNING [jakarta.enterprise.resource.webcontainer.faces.taglib] (default task-7: 73982343) JSF1103: The metadata facet must be a direct child of the view in viewId /cryptotoken/cryptotoken.xhtml

and when I test any key, I get this other log twice:

WARNING [jakarta.enterprise.resource.webcontainer.faces.taglib] (default task-5: 02417773) JSF1103: The metadata facet must be a direct child of the view in viewId /cryptotoken/cryptotoken.xhtml

Is there a way for me to correct the error or stop the warning from popping?

Tell me if you need more input!

Thank you,

talcher

[primetomas]

The last ones can be ignored. What kind of database are you running?

[talcher]

Thanks for the answer.
I am using MariaDB, 10.11 I would say.

[primetomas]

We haven't found any reason, and haven't seen it before. Is there anything else in the log related to the new SCEP renewal service?

[talcher]

Thank you, Tomas.

Is this what you are looging for:

[...]
            {
                "class":"org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionBean",
                "method":"renewScepKeys",
                "line":71
            },
[...]
            {
                "class":"org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionLocal$$$view55",
                "method":"renewScepKeys"
            },
            {
                "class":"org.ejbca.core.protocol.scep.ScepKeyRenewalSessionBean",
                "method":"timeoutHandler",
                "line":63
            },
[...]

Those are the only lines mathing "scep" in the sooo long log.

[primetomas]

Your logs doesn't look like what I'm used to. Wildfly creates a server.log file where you can set log levels and a lot. It doesn't look like that though...
How do you collect those logs?
https://docs.keyfactor.com/ejbca/latest/logging
https://docs.keyfactor.com/ejbca/latest/enabling-debug-logging

[talcher]

Sorry. I did not choose the right log file.

Here are the lines that you may need:

WARN  [org.mariadb.jdbc.message.server.ErrorPacket] (EJB default - 2) Error: 1205-HY000: Lock wait timeout exceeded; try restarting transaction

WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) SQL Error: 1205, SQLState: HY000

ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) (conn=142081) Lock wait timeout exceeded; try restarting transaction

INFO  [org.hibernate.event.internal.DefaultLoadEventListener] (EJB default - 2) HHH000327: Error performing load command: org.hibernate.PessimisticLockException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at org.hibernate@6.6.3.Final//org.hibernate.dialect.MySQLDialect.lambda$buildSQLExceptionConversionDelegate$3(MySQLDialect.java:1238)
    at org.hibernate@6.6.3.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionBean.renewScepKeys(ScepKeyRenewalDataSessionBean.java:71)
    at [...]
Caused by: java.sql.SQLException: (conn=142081) Lock wait timeout exceeded; try restarting transaction
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionLocal$$$view55.renewScepKeys(Unknown Source)
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalSessionBean.timeoutHandler(ScepKeyRenewalSessionBean.java:63)
    at [...]

ERROR [org.jboss.as.ejb3.invocation] (EJB default - 2) WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component GlobalConfigurationSessionBean for method public abstract org.cesecore.configuration.ConfigurationBase org.cesecore.configuration.GlobalConfigurationSession.getCachedConfigurationAndLockWrites(java.lang.String): jakarta.ejb.EJBTransactionRolledbackException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at org.jboss.as.ejb3@35.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:202)
    at org.jboss.as.ejb3@35.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:375)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionBean.renewScepKeys(ScepKeyRenewalDataSessionBean.java:71)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionLocal$$$view55.renewScepKeys(Unknown Source)
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalSessionBean.timeoutHandler(ScepKeyRenewalSessionBean.java:63)
    at [...]
Caused by: jakarta.persistence.LockTimeoutException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at [...]
Caused by: org.hibernate.PessimisticLockException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at [...]
Caused by: java.sql.SQLException: (conn=142081) Lock wait timeout exceeded; try restarting transaction
    at [...]

ERROR [org.jboss.as.ejb3.invocation] (EJB default - 2) WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component ScepKeyRenewalDataSessionBean for method public abstract void org.ejbca.core.protocol.scep.ScepKeyRenewalDataSession.renewScepKeys() throws jakarta.transaction.SystemException: jakarta.ejb.EJBTransactionRolledbackException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at org.jboss.as.ejb3@35.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:202)
    at org.jboss.as.ejb3@35.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:375)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionBean.renewScepKeys(ScepKeyRenewalDataSessionBean.java:71)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionLocal$$$view55.renewScepKeys(Unknown Source)
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalSessionBean.timeoutHandler(ScepKeyRenewalSessionBean.java:63)
    at [...]
Caused by: jakarta.persistence.LockTimeoutException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at [...]
Caused by: org.hibernate.PessimisticLockException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at [...]
Caused by: java.sql.SQLException: (conn=142081) Lock wait timeout exceeded; try restarting transaction
    at [...]

ERROR [org.jboss.as.ejb3.timer] (EJB default - 2) WFLYEJB0020: Error invoking timeout for timer: [id=93784488-b805-41b5-9316-6d1aa4d2ce72 timedObjectId=ejbca.ejbca-ejb.ScepKeyRenewalSessionBean auto-timer?:false persistent?:false timerService=TimerServiceImpl(ejbca.ejbca-ejb.ScepKeyRenewalSessionBean) previousRun=Fri Apr 24 12:00:00 CEST 2026 initialExpiration=null intervalDuration(in milli sec)=0 nextExpiration=Wed May 06 16:00:00 CEST 2026 timerState=IN_TIMEOUT info=ScepKeyRenewal] ScheduleExpression [second=0;minute=0;hour=*;dayOfMonth=*;month=*;dayOfWeek=*;year=*;timezoneID=null;start=null;end=null]: jakarta.ejb.EJBTransactionRolledbackException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at org.jboss.as.ejb3@35.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:202)
    at org.jboss.as.ejb3@35.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:375)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionBean.renewScepKeys(ScepKeyRenewalDataSessionBean.java:71)
    at [...]
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalDataSessionLocal$$$view55.renewScepKeys(Unknown Source)
    at deployment.ejbca.ear.ejbca-ejb.jar//org.ejbca.core.protocol.scep.ScepKeyRenewalSessionBean.timeoutHandler(ScepKeyRenewalSessionBean.java:63)
    at [...]
Caused by: jakarta.persistence.LockTimeoutException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at [...]
Caused by: org.hibernate.PessimisticLockException: JDBC exception executing SQL [select gcd1_0.configurationId,gcd1_0.data,gcd1_0.rowProtection,gcd1_0.rowVersion from GlobalConfigurationData gcd1_0 where gcd1_0.configurationId=? for update nowait] [(conn=142081) Lock wait timeout exceeded; try restarting transaction] [n/a]
    at [...]
Caused by: java.sql.SQLException: (conn=142081) Lock wait timeout exceeded; try restarting transaction
    at [...]

INFO  [org.jboss.as.ejb3.timer] (EJB default - 2) WFLYEJB0021: Timer: [id=93784488-b805-41b5-9316-6d1aa4d2ce72 timedObjectId=ejbca.ejbca-ejb.ScepKeyRenewalSessionBean auto-timer?:false persistent?:false timerService=TimerServiceImpl(ejbca.ejbca-ejb.ScepKeyRenewalSessionBean) previousRun=Fri Apr 24 12:00:00 CEST 2026 initialExpiration=null intervalDuration(in milli sec)=0 nextExpiration=Wed May 06 16:00:00 CEST 2026 timerState=IN_TIMEOUT info=ScepKeyRenewal] ScheduleExpression [second=0;minute=0;hour=*;dayOfMonth=*;month=*;dayOfWeek=*;year=*;timezoneID=null;start=null;end=null] will be retried

INFO  [org.jboss.as.ejb3.timer] (EJB default - 2) WFLYEJB0023: Retrying timeout for timer: [id=93784488-b805-41b5-9316-6d1aa4d2ce72 timedObjectId=ejbca.ejbca-ejb.ScepKeyRenewalSessionBean auto-timer?:false persistent?:false timerService=TimerServiceImpl(ejbca.ejbca-ejb.ScepKeyRenewalSessionBean) previousRun=Fri Apr 24 12:00:00 CEST 2026 initialExpiration=null intervalDuration(in milli sec)=0 nextExpiration=Wed May 06 16:00:00 CEST 2026 timerState=IN_TIMEOUT info=ScepKeyRenewal] ScheduleExpression [second=0;minute=0;hour=*;dayOfMonth=*;month=*;dayOfWeek=*;year=*;timezoneID=null;start=null;end=null]

INFO  [org.ejbca.config.ScepConfiguration] (EJB default - 2) Upgrading ScepConfiguration from version 3.0 to 8.0

INFO  [org.ejbca.core.protocol.scep.ScepKeyRenewalSessionBean] (EJB default - 2) Renewed keys for SCEP alias

This line pattern is repeated regularly at sharp hours.