Author |
Message |
tschaikowskinksi Brekeke Member
Joined: 11 Apr 2011 Posts: 23
|
Posted: Wed Apr 27, 2011 1:35 am Post subject: 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/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 |
|
Back to top |
|
lakeview Brekeke Master Guru
Joined: 15 Nov 2007 Posts: 319
Location: Florida
|
Posted: Wed Apr 27, 2011 12:18 pm Post subject: |
|
|
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". |
|
Back to top |
|
tschaikowskinksi Brekeke Member
Joined: 11 Apr 2011 Posts: 23
|
Posted: Wed Apr 27, 2011 11:14 pm Post subject: |
|
|
Hi lakeview,
I've almost done that about 10 times. No change.
Best Marco |
|
Back to top |
|
lakeview Brekeke Master Guru
Joined: 15 Nov 2007 Posts: 319
Location: Florida
|
Posted: Thu Apr 28, 2011 10:36 am Post subject: |
|
|
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? |
|
Back to top |
|
tschaikowskinksi Brekeke Member
Joined: 11 Apr 2011 Posts: 23
|
Posted: Thu Apr 28, 2011 11:15 pm Post subject: |
|
|
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 |
|
Back to top |
|
lakeview Brekeke Master Guru
Joined: 15 Nov 2007 Posts: 319
Location: Florida
|
Posted: Tue May 03, 2011 10:19 am Post subject: |
|
|
Does MySQL avoid the issue? |
|
Back to top |
|
tschaikowskinksi Brekeke Member
Joined: 11 Apr 2011 Posts: 23
|
Posted: Mon May 09, 2011 5:23 am Post subject: |
|
|
No issues so far with mysql But the standard DB should also do it's job. Sorry not for me |
|
Back to top |
|
lakeview Brekeke Master Guru
Joined: 15 Nov 2007 Posts: 319
Location: Florida
|
Posted: Mon May 09, 2011 10:26 am Post subject: |
|
|
Im glad to know it. |
|
Back to top |
|
|