SERP Hacker support forum - serposcope

Support forum for open-source softwares built by serphacker.com : serposcope the rank checker.

You are not logged in.

#1 2017-02-15 13:53:08

MatCool
Member
Registered: 2017-02-15
Posts: 2

Please Help! Error: where GOOGLE_SEARCH ID

I'm adding 1500 new domains in 5 different groups and click recheck SERP.
After this On main page lost all domains list and in in all projects - all info about serp.

I error log I found:
[2017-02-15 15:07:59,515] [qtp3447021-1307] ERROR c.s.s.d.AbstractDB - SQL error
com.querydsl.core.QueryException: Caught JdbcSQLException for delete from "GOOGLE_SEARCH"
where "GOOGLE_SEARCH"."ID" = ?
       at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) ~[serposcope.jar:na]
       at com.querydsl.sql.Configuration.translate(Configuration.java:459) ~[serposcope.jar:na]
       at com.querydsl.sql.dml.SQLDeleteClause.execute(SQLDeleteClause.java:222) ~[serposcope.jar:na]
       at com.serphacker.serposcope.db.google.GoogleSearchDB.delete(GoogleSearchDB.java:184) ~[serposcope.jar:na]
       at serposcope.controllers.google.GoogleGroupController.deleteSearch(GoogleGroupController.java:551) [serposcope.jar:na]
       at serposcope.controllers.google.GoogleGroupController.delete(GoogleGroupController.java:484) [serposcope.jar:na]
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
       at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
       at ninja.params.ControllerMethodInvoker.invoke(ControllerMethodInvoker.java:57) [serposcope.jar:na]
       at ninja.FilterChainEnd.next(FilterChainEnd.java:49) [serposcope.jar:na]
       at serposcope.filters.AdminFilter.filter(AdminFilter.java:39) [serposcope.jar:na]
       at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope.jar:na]
       at serposcope.filters.XSRFFilter.filter(XSRFFilter.java:35) [serposcope.jar:na]
       at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope.jar:na]
       at serposcope.filters.GoogleGroupFilter.filter(GoogleGroupFilter.java:71) [serposcope.jar:na]
       at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope.jar:na]
       at serposcope.filters.CanReadFilter.filter(CanReadFilter.java:52) [serposcope.jar:na]
       at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope.jar:na]
       at serposcope.filters.AuthFilter.filter(AuthFilter.java:40) [serposcope.jar:na]
       at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope.jar:na]
       at serposcope.filters.BaseFilter.filter(BaseFilter.java:61) [serposcope.jar:na]
       at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope.jar:na]
       at ninja.NinjaDefault.onRouteRequest(NinjaDefault.java:102) [serposcope.jar:na]
       at ninja.servlet.NinjaServletDispatcher.service(NinjaServletDispatcher.java:86) [serposcope.jar:na]
       at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:287) [serposcope.jar:na]
       at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:277) [serposcope.jar:na]
       at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:182) [serposcope.jar:na]
       at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [serposcope.jar:na]
       at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) [serposcope.jar:na]
       at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:119) [serposcope.jar:na]
       at com.google.inject.servlet.GuiceFilter$1.call(GuiceFilter.java:133) [serposcope.jar:na]
       at com.google.inject.servlet.GuiceFilter$1.call(GuiceFilter.java:130) [serposcope.jar:na]
       at com.google.inject.servlet.GuiceFilter$Context.call(GuiceFilter.java:203) [serposcope.jar:na]
       at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:130) [serposcope.jar:na]
       at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) [serposcope.jar:na]
       at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) [serposcope.jar:na]
       at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) [serposcope.jar:na]
       at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) [serposcope.jar:na]
       at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) [serposcope.jar:na]
       at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [serposcope.jar:na]
       at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [serposcope.jar:na]
       at org.eclipse.jetty.server.Server.handle(Server.java:497) [serposcope.jar:na]
       at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) [serposcope.jar:na]
       at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) [serposcope.jar:na]
       at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) [serposcope.jar:na]
       at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [serposcope.jar:na]
       at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [serposcope.jar:na]
       at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_1359: PUBLIC.GOOGLE_SEARCH_GROUP FOREIGN KEY(GOOGLE_SEARCH_ID) REFERENCES PUBLIC.GOOGLE_SEARCH(ID) (7)"; SQL statement:
delete from "GOOGLE_SEARCH"
where "GOOGLE_SEARCH"."ID" = ? [23503-189]
       at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ~[serposcope.jar:na]
       at org.h2.message.DbException.get(DbException.java:179) ~[serposcope.jar:na]
       at org.h2.message.DbException.get(DbException.java:155) ~[serposcope.jar:na]
       at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:426) ~[serposcope.jar:na]
       at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:443) ~[serposcope.jar:na]
       at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:318) ~[serposcope.jar:na]
       at org.h2.table.Table.fireConstraints(Table.java:920) ~[serposcope.jar:na]
       at org.h2.table.Table.fireAfterRow(Table.java:938) ~[serposcope.jar:na]
       at org.h2.command.dml.Delete.update(Delete.java:100) ~[serposcope.jar:na]
       at org.h2.command.CommandContainer.update(CommandContainer.java:78) ~[serposcope.jar:na]
       at org.h2.command.Command.executeUpdate(Command.java:253) ~[serposcope.jar:na]
       at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157) ~[serposcope.jar:na]
       at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143) ~[serposcope.jar:na]
       at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[serposcope.jar:na]
       at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[serposcope.jar:na]
       at com.querydsl.sql.dml.SQLDeleteClause.execute(SQLDeleteClause.java:208) ~[serposcope.jar:na]
       ... 47 common frames omitted

Please help me ! What I may do ?

Offline

#2 2017-02-15 13:59:24

MatCool
Member
Registered: 2017-02-15
Posts: 2

Re: Please Help! Error: where GOOGLE_SEARCH ID

It is Sysconfig:

serposcope.version          : 2.6.0
serposcope.datadir          : /home/ggggg/serposcope
serposcope.logdir           : /home/ggggg/serposcope/logs
serposcope.db.url           : jdbc:h2:/home/ggggg/serposcope/db;MODE=MySQL
serposcope.db.debug         : false
serposcope.listenAddress    : 222.122.122.250
serposcope.listenPort       : 7134java.runtime.name=OpenJDK Runtime Environment
sun.boot.library.path=/usr/local/openjdk8/jre/lib/amd64
java.vm.version=25.121-b13
serposcope.conf=/home/ggggg/ggggg/www/serposcope/serposcope.conf
java.vm.vendor=Oracle Corporation
java.vendor.url=http://java.oracle.com/
path.separator=:
java.vm.name=OpenJDK 64-Bit Server VM
file.encoding.pkg=sun.io
user.country=US
sun.java.launcher=SUN_STANDARD
sun.os.patch.level=unknown
java.vm.specification.name=Java Virtual Machine Specification
user.dir=/usr/local/etc/nginx
java.runtime.version=1.8.0_121-b13
java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
java.endorsed.dirs=/usr/local/openjdk8/jre/lib/endorsed
os.arch=amd64
java.io.tmpdir=/tmp/
line.separator=

java.vm.specification.vendor=Oracle Corporation
os.name=FreeBSD
sun.jnu.encoding=US-ASCII
java.library.path=/usr/local/lib
java.specification.name=Java Platform API Specification
java.class.version=52.0
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
os.version=9.2-RELEASE-p4
user.home=/home/ggggg
user.timezone=Europe/Moscow
java.awt.printerjob=sun.print.PSPrinterJob
file.encoding=utf-8
java.specification.version=1.8
java.class.path=/home/ggggg/ggggg/www/serposcope/serposcope.jar
user.name=zznine
java.vm.specification.version=1.8
sun.java.command=/home/ggggg/ggggg/www/serposcope/serposcope.jar
java.home=/usr/local/openjdk8/jre
sun.arch.data.model=64
user.language=en
java.specification.vendor=Oracle Corporation
awt.toolkit=sun.awt.X11.XToolkit
java.vm.info=mixed mode
java.version=1.8.0_121
java.ext.dirs=/usr/local/openjdk8/jre/lib/ext:/usr/java/packages/lib/ext
sun.boot.class.path=/usr/local/openjdk8/jre/lib/resources.jar:/usr/local/openjdk8/jre/lib/rt.jar:/usr/local/openjdk8/jre/lib/sunrsasign.jar:/usr/local/openjdk8/jre/lib/jsse.jar:/usr/local/openjdk8/jre/lib/jce.jar:/usr/local/openjdk8/jre/lib/charsets.jar:/usr/local/openjdk8/jre/lib/jfr.jar:/usr/local/openjdk8/jre/classes
java.awt.headless=true
java.vendor=Oracle Corporation
file.separator=/
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
sun.io.unicode.encoding=UnicodeLittle
sun.cpu.endian=little
sun.cpu.isalist=

Last edited by MatCool (2017-02-15 13:59:48)

Offline

#3 2017-02-22 10:02:12

serphacker
Administrator
Registered: 2014-06-13
Posts: 411

Re: Please Help! Error: where GOOGLE_SEARCH ID

please use mysql, serposcope using h2 (default database) is not recommended when more than 1k keywords

Offline

Board footer