table not found T_REGISTERED

[tschaikowskinksi]

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/networkpatterns.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

[lakeview]

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".

[tschaikowskinksi]

Hi lakeview,

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

Best Marco

[lakeview]

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?

[tschaikowskinksi]

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

[lakeview]

Does MySQL avoid the issue?

[tschaikowskinksi]

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

[lakeview]

Im glad to know it.