table not found T_REGISTERED

1. Brekeke Product Name and version: 2.4.8.6/286.3

2. Java version:1.6

3. OS type and the version:Linux

4. UA (phone), gateway or other hardware/software involved:

5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/ ... terns.html :6

6. Your problem:

The registered database is not working anymore. I've tried stop/start tomcat delete the entire db directory. But I always get that Error:


java.sql.SQLException: Table not found: T_REGISTERED in statement [ALTER TABLE t_registered]
org.hsqldb.jdbc.jdbcUtil.sqlException (jdbcUtil.java:67)
org.hsqldb.jdbc.jdbcStatement.fetchResult (jdbcStatement.java:1576)
org.hsqldb.jdbc.jdbcStatement.execute (jdbcStatement.java:625)
com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.initTable (null:-1)
com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.open (null:-1)
com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.init (null:-1)
com.brekeke.net.sip.sv.registrar.Registrar.init (null:-1)
com.brekeke.net.sip.sv.SIPsvListener.<init> (null:-1)
com.brekeke.ondo.sv.main (null:-1)

I've noticed that the db file is growing very fast inside the file there are only (.........) dots


In the log.log file there is another error:

com.brekeke.net.sip.sv.registrar.RegisteredDBCanNotOpenException: Connection error:jdbc:hsqldb:hsql://127.0.0.1:socket creation$
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.getConnection(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.initConnection(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.open(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.<init>(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.initDatabase(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.initApp(Unknown Source)
at com.brekeke.sipadmin.web.Initializer.initialize(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.brekeke.web.GateServlet.init(Unknown Source)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)

I don't know what the port issue should be? The other tables are seem to be ok.

Any idea?

Thanks marco

It seems the Register Database has been broken..

Delete "../WEB-INF/work/sv/db" folder.
and copy "../WEB-INF/work/sv/db_backup" folder to "../WEB-INF/work/sv/db".

Hi lakeview,

I've almost done that about 10 times. No change.

Best Marco

Hi
When did the problem start happening?
Are you running multiple SIP servers on the same PC?
Are you using a virtual environment such as VMware for SIP Server?
Which Linux distribution are you using for SIP server?

Hi,

- Sorry but I don't remember when that happened. As for now I decieded to use mysql for database connection as I have already spend a lot of time on this issue.
- Debian sqeeze.
- Only one Sip Server is running and I have almost tried erverthing related to that (stopping tomcate killing all java processes, delete db folder completely).
- It's a physical machine.

Thanks Marco

Does MySQL avoid the issue?

No issues so far with mysql But the standard DB should also do it's job. Sorry not for me

Im glad to know it.