Bill Blue Button Null Pointer Exception and MySQLIntegrityConstraintViolationException

[Mustansar Mehmood]

Hi,
     We have a 0.8 BBB with Sakai 2.9 and latest version of bbb-tool for sakai. Creating a meeting doesnt seem to be working. Here is what we see on the Sakai logs.

This error stands out more than others apparently.
'com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'HOST_URL' cannot be null'

Has there been any database schema changes in bbb-tool for sakai?
2012-08-28 13:33:39,221  INFO http-bio-8443-exec-10 org.apache.myfaces.shared_tomahawk.config.MyfacesConfig - Starting up Tomahawk on the RI-JSF-Implementation.
2012-08-28 13:34:07,624 ERROR http-bio-8443-exec-10 org.sakaiproject.bbb.impl.BBBStorageManager - Caught exception whilst storing meeting. Rolling back ...
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'HOST_URL' cannot be null
    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:411)
    at com.mysql.jdbc.Util.getInstance(Util.java:386)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4098)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4030)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2134)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1369)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
    at org.sakaiproject.bbb.impl.BBBStorageManager.storeMeeting(BBBStorageManager.java:196)
    at org.sakaiproject.bbb.impl.BBBMeetingManagerImpl.createMeeting(BBBMeetingManagerImpl.java:245)
    at org.sakaiproject.bbb.tool.entity.BBBMeetingEntityProvider.createEntity(BBBMeetingEntityProvider.java:225)
    at org.sakaiproject.entitybroker.rest.EntityHandlerImpl.handleEntityAccess(EntityHandlerImpl.java:667)
    at org.sakaiproject.entitybroker.util.servlet.DirectServlet.dispatch(DirectServlet.java:183)
    at org.sakaiproject.entitybroker.servlet.SakaiDirectServlet.dispatch(SakaiDirectServlet.java:146)
    at org.sakaiproject.entitybroker.util.servlet.DirectServlet.handleRequest(DirectServlet.java:154)
    at org.sakaiproject.entitybroker.util.servlet.DirectServlet.service(DirectServlet.java:132)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
2012-08-28 13:34:07,647  WARN http-bio-8443-exec-10 org.sakaiproject.email.impl.BasicEmailService - send: javax.mail.internet.AddressException: Missing '"' in string ``"<no-reply@codeforge>'' at position 21
2012-08-28 13:34:07,647 ERROR http-bio-8443-exec-10 org.sakaiproject.entitybroker.impl.external.SakaiExternalIntegrationProvider - Direct request failure: NullPointerException:null:Direct request failure: NullPointerException:null:
 Sakai version: 2.9-SNAPSHOT(TRUNK)
 
Server: codeforge(codeforge) [codeforge-1346093188136]
 
Request URI: /direct/bbb-meeting/new
 Path Info: /bbb-meeting/new
 Context path: /direct
 Method: POST
 
Server: codeforge-1346093188136
 User agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.19 (KHTML, like Gecko) Ubuntu/12.04 Chromium/18.0.1025.168 Chrome/18.0.1025.168 Safari/535.19
 Browser ID: Lin-Mozilla
 IP address: 168.7.55.164
 User ID: admin
 User EID: admin
 User Display ID: admin
 
Full stacktrace:
NullPointerException:null:
java.lang.NullPointerException
    at org.sakaiproject.bbb.impl.BBBAPIWrapper.endMeeting(BBBAPIWrapper.java:394)
    at org.sakaiproject.bbb.impl.BBBMeetingManagerImpl.createMeeting(BBBMeetingManagerImpl.java:264)
    at org.sakaiproject.bbb.tool.entity.BBBMeetingEntityProvider.createEntity(BBBMeetingEntityProvider.java:225)
    at org.sakaiproject.entitybroker.rest.EntityHandlerImpl.handleEntityAccess(EntityHandlerImpl.java:667)
    at org.sakaiproject.entitybroker.util.servlet.DirectServlet.dispatch(DirectServlet.java:183)
    at org.sakaiproject.entitybroker.servlet.SakaiDirectServlet.dispatch(SakaiDirectServlet.java:146)
    at org.sakaiproject.entitybroker.util.servlet.DirectServlet.handleRequest(DirectServlet.java:154)
    at org.sakaiproject.entitybroker.util.servlet.DirectServlet.service(DirectServlet.java:132)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)

WARN Direct request failure: NullPointerException:null:Direct request failure: NullPointerException:null:
 Sakai version: 2.9-SNAPSHOT(TRUNK)
 
Server: codeforge(codeforge) [codeforge-1346093188136]
 
Request URI: /direct/bbb-meeting/new
 Path Info: /bbb-meeting/new
 Context path: /direct
 Method: POST
 
Server: codeforge-1346093188136
 User agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.19 (KHTML, like Gecko) Ubuntu/12.04 Chromium/18.0.1025.168 Chrome/18.0.1025.168 Safari/535.19
 Browser ID: Lin-Mozilla
 IP address: 168.7.55.164
 User ID: admin
 User EID: admin
 User Display ID: admin
  :java.lang.NullPointerException





Any ideas how to get past that ?

-- 
Mustansar Mehmood
Educational System Developer& Integrator

Information Technology  
6100 Main St. MS 119
Houston Texas 77005

Phone:(713)348-2523
Fax  :(713)348 6099 
email:must...@rice.edu





I have yet to see any problem, however complicated, which, when,you  looked at it in the right way, did not become still more complicated. 
    -- Poul Anderson 

[Jesus Federico]

Hi Mustansar,

What is the latest version you have for the bbb-tool?, We have been testing the tool for a while and right now we are on 1.0.7-rc3, the latest build available in the master branch is 20120724_142000, even though the last snapshot https://github.com/blindsidenetworks/bigbluebutton-sakai/tree/1.0.7-rc2-SNAPSHOT has the tag  20120606_144500

Yes, there have been few changes in the schema since the first beta releases, the schema right now it should look like this https://github.com/blindsidenetworks/bigbluebutton-sakai/blob/master/bbb-tool/database/mysql/bbb-mysql_1-0-7.sql

If you run your Sakai server with auto.ddl=true your database should be updated automatically once tomcat starts.

On the other hand, what beta are you using for your Sakai 2.9 server? The last time we tried out the tool on 2.9 it was on 2.9-b2 and it run ok. But after that there were some changes on Sakai  that broke the tool. We decided to wait until a more stable version for Sakai 2.9 were released. So, even though the tool has been tested and it works for 2.9, by now there is no guaranty that it will work with no errors.

Jesus Federico

email:m...@rice.edu