Jahia Install Forum > Error on startup...

0 (0 Good)
0 (0 Bad)

Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)

by  chris »  2012/02/10 16:00

Hello,

we receive the following error on the first startup after successful installation on a linux system:

2012-02-10 16:18:44,411: ERROR [main] ConnectionHelper$RetryManager, org.apache.jackrabbit.core.util.db.ConnectionHelper: Failed to execute SQL (stacktrace on DEBUG log level)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:438)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:359)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:339)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:335)
....

The installation script created several tables (around 30 tables). The database is mysql 5. For installation we used the Jahia_xCM_v6.5.1.0_r39069.jar.

Thanks for your help.

 

Greetings from Germany,

Chris

  • Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)
    2012/02/10 16:00

    chris <p> Hello,</p> <p> we receive the following error on the first startup after successful installation on a linux system:</p> <p> 2012-02-10 16:18:44,411: ERROR [main] ConnectionHelper$RetryManager, org.apache.jackrabbit.core.util.db.ConnectionHelper: Failed to execute SQL (stacktrace on DEBUG log level)<br /> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table &#39;jahia.jr_v_bundle&#39; doesn&#39;t exist<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.getInstance(Util.java:382)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:438)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:359)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:339)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:335)<br /> ....</p> <p> The installation script created several tables (around 30 tables). The database is mysql 5. For installation we used the Jahia_xCM_v6.5.1.0_r39069.jar.</p> <p> Thanks for your help.</p> <p> &nbsp;</p> <p> Greetings from Germany,</p> <p> Chris</p>

  • Number of messages  5
    Registration date Feb 10, 2012
    0 (0 Good)
    0 (0 Bad)

    Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)

    by  shyrkov »  2012/02/10 16:20

    Hello Chris,

    there seems to be a problem creating tables. Default Jahia installation has around 50 of them.

    Could you check our installation log file? It should be in the <install-path>/logs/install.log

    By any chance could you provide the following data:

    1) <install-path>/logs/install.log

    2) <install-path>/logs/install.properties

    ?

     

    Kind regards

    Sergiy

  • Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)
    2012/02/10 16:20

    shyrkov <p> Hello Chris,</p> <p> there seems to be a problem creating tables. Default Jahia installation has around 50 of them.</p> <p> Could you check our installation log file? It should be in the &lt;install-path&gt;/logs/install.log</p> <p> By any chance could you provide the following data:</p> <p> 1) &lt;install-path&gt;/logs/install.log</p> <p> 2) &lt;install-path&gt;/logs/install.properties</p> <p> ?</p> <p> &nbsp;</p> <p> Kind regards</p> <p> Sergiy</p>

  • Number of messages  407
    Registration date Feb 10, 2012
    0 (0 Good)
    0 (0 Bad)

    Re: Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)

    by  chris »  2012/02/13 11:00

    Hello Sergiy,

     

    thank you for your fast response and help.

    We solved the problem. The problem was a lack of rights for the existing database user jahia therefore the user was not able to execute all sql command from the install script.

    Kind regards,

    Chris

     

  • Re: Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)
    2012/02/13 11:00

    chris <p> Hello Sergiy,</p> <p> &nbsp;</p> <p> thank you for your fast response and help.</p> <p> We solved the problem. The problem was a lack of rights for the existing database user jahia therefore the user was not able to execute all sql command from the install script.</p> <p> Kind regards,</p> <p> Chris</p> <p> &nbsp;</p>

  • Number of messages  5
    Registration date Feb 13, 2012
    Contact
    Share
    Feedback

    Get in touch

    Whether you are a current user or if you are just evaluating Jahia, we are here to help.

    Contact us

    Share this page