遇到一些数据库的问题 #31

R0ser1 · 2022-08-29T12:50:47Z

R0ser1
Aug 29, 2022

对SQL是全部失败不知道是什么原因造成的，如果我只导入一个jar是可以插入数据库我把很多jar放一起分析之后永远存在数据库问题，搜索一番似乎是值过于大？不知这种问题该如何解决。
2022-08-29 01:09:23.964 WARN 11844 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 22001, SQLState: 22001
2022-08-29 01:09:23.964 ERROR 11844 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Value too long for column "NAME0 VARCHAR(255)": "'org.eclipse.persistence.internal.sessions.factories.ObjectPersistenceRuntimeXMLProject_11_1_1$StoredProcedureArgumentInstantiat... (272)"; SQL statement:
insert into methods (actions, classname, has_default_constructor, has_parameters, is_abstract, is_action_contains_swap, is_action_initialed, is_body_parse_error, is_contains_out_of_mem_options, is_contains_source, is_endpoint, is_from_abstract_class, is_getter, is_ignore, is_initialed, is_netty_endpoint, is_public, is_serializable, is_setter, is_sink, is_source, is_static, modifiers, name, name0, parameter_size, polluted_position, return_type, signature, sub_signature, vul, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-200]
2022-08-29 01:09:51.998 INFO 11844 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-08-29 01:09:52.061 ERROR 11844 --- [ main] o.s.boot.SpringApplication : Application run failed

java.lang.IllegalStateException: Failed to execute CommandLineRunner
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:822) [spring-boot-2.4.5.jar:2.4.5]
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:803) [spring-boot-2.4.5.jar:2.4.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:346) [spring-boot-2.4.5.jar:2.4.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1340) [spring-boot-2.4.5.jar:2.4.5]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1329) [spring-boot-2.4.5.jar:2.4.5]
at tabby.App.main(App.java:36) [main/:na]
Caused by: org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:280) ~[spring-orm-5.3.6.jar:5.3.6]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233) ~[spring-orm-5.3.6.jar:5.3.6]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566) ~[spring-orm-5.3.6.jar:5.3.6]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.3.6.jar:5.3.6]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.3.6.jar:5.3.6]
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:654) ~[spring-tx-5.3.6.jar:5.3.6]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:407) ~[spring-tx-5.3.6.jar:5.3.6]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.6.jar:5.3.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.6.jar:5.3.6]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.6.jar:5.3.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.6.jar:5.3.6]
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:174) ~[spring-data-jpa-2.4.8.jar:2.4.8]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.6.jar:5.3.6]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.6.jar:5.3.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.6.jar:5.3.6]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.6.jar:5.3.6]
at com.sun.proxy.$Proxy92.saveAll(Unknown Source) ~[na:na]
at tabby.dal.caching.service.MethodRefService.save(MethodRefService.java:36) ~[main/:na]
at tabby.core.container.DataContainer.save(DataContainer.java:80) ~[main/:na]
at tabby.core.scanner.CallGraphScanner.save(CallGraphScanner.java:70) ~[main/:na]
at tabby.core.scanner.CallGraphScanner.run(CallGraphScanner.java:43) ~[main/:na]
at tabby.core.Analyser.runSootAnalysis(Analyser.java:110) ~[main/:na]
at tabby.core.Analyser.run(Analyser.java:81) ~[main/:na]
at tabby.App.lambda$run$0(App.java:89) [main/:na]
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:819) [spring-boot-2.4.5.jar:2.4.5]
... 5 common frames omitted
Caused by: org.hibernate.exception.DataException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3297) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3824) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[na:1.8.0_221]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:345) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3212) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2380) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562) ~[spring-orm-5.3.6.jar:5.3.6]
... 27 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLDataException: Value too long for column "NAME0 VARCHAR(255)": "'org.eclipse.persistence.internal.sessions.factories.ObjectPersistenceRuntimeXMLProject_11_1_1$StoredProcedureArgumentInstantiat... (272)"; SQL statement:
insert into methods (actions, classname, has_default_constructor, has_parameters, is_abstract, is_action_contains_swap, is_action_initialed, is_body_parse_error, is_contains_out_of_mem_options, is_contains_source, is_endpoint, is_from_abstract_class, is_getter, is_ignore, is_initialed, is_netty_endpoint, is_public, is_serializable, is_setter, is_sink, is_source, is_static, modifiers, name, name0, parameter_size, polluted_position, return_type, signature, sub_signature, vul, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:457) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]
at org.h2.value.TypeInfo.getValueTooLongException(TypeInfo.java:535) ~[h2-1.4.200.jar:1.4.200]
at org.h2.value.TypeInfo.cast(TypeInfo.java:520) ~[h2-1.4.200.jar:1.4.200]
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:378) ~[h2-1.4.200.jar:1.4.200]
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:845) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.dml.Insert.insertRows(Insert.java:187) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.dml.Insert.update(Insert.java:151) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.CommandContainer.update(CommandContainer.java:198) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Command.executeUpdate(Command.java:251) ~[h2-1.4.200.jar:1.4.200]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:191) ~[h2-1.4.200.jar:1.4.200]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:152) ~[h2-1.4.200.jar:1.4.200]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-3.4.5.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]
... 47 common frames omitted

R0ser1 · 2022-08-29T13:13:27Z

R0ser1
Aug 29, 2022
Author

java.lang.IllegalStateException: Failed to execute CommandLineRunner 以及 Failed to invoke procedure apoc.periodic.iterate: Caused by: java.net.UnknownHostException: C; Error code 'Neo.ClientError.Procedure.ProcedureCallFailed 也是经常的遇到。不知道是什么原因。是在save到neo4j的时候

0 replies

wh1t3p1g · 2022-08-29T13:57:39Z

wh1t3p1g
Aug 29, 2022
Maintainer

你好：
第一个问题，已经修复，重新build一下
第二个问题，看起来可能是数据库配置的问题，如果后面遇到补充一下细节才能判断问题所在

1 reply

R0ser1 Aug 29, 2022
Author

好的感谢师傅。麻烦了。

R0ser1 · 2022-09-02T12:08:35Z

R0ser1
Sep 2, 2022
Author

现在产生了一些新的问题我不清楚是否是我的电脑问题。I7 8代吧 16G 分配了10G给java 我是先把他分析的结果保存db，再将将函数属性图导入Neo4j中其中我们jar包一共130M 分析了1个多小时，导入到Neo4j 导入了20个小时了目前neo4j 大小为1.4G 还在导入。这个速度是我电脑的原因吗呜呜呜~~ 目前到Save Has relationship 这一步了。

1 reply

wh1t3p1g Sep 2, 2022
Maintainer

数据库需要配置一下优化哈，不然会很慢

R0ser1 · 2022-09-02T14:03:07Z

R0ser1
Sep 2, 2022
Author

OK 也就是索引那一步对吗

2 replies

wh1t3p1g Sep 2, 2022
Maintainer

是的

R0ser1 Sep 2, 2022
Author

OK 感谢师傅嘿xd:)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

遇到一些数据库的问题 #31

{{title}}

Replies: 4 comments 4 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

遇到一些数据库的问题 #31

R0ser1 Aug 29, 2022

Replies: 4 comments · 4 replies

R0ser1 Aug 29, 2022 Author

wh1t3p1g Aug 29, 2022 Maintainer

R0ser1 Aug 29, 2022 Author

R0ser1 Sep 2, 2022 Author

wh1t3p1g Sep 2, 2022 Maintainer

R0ser1 Sep 2, 2022 Author

wh1t3p1g Sep 2, 2022 Maintainer

R0ser1 Sep 2, 2022 Author

R0ser1
Aug 29, 2022

Replies: 4 comments 4 replies

R0ser1
Aug 29, 2022
Author

wh1t3p1g
Aug 29, 2022
Maintainer

R0ser1 Aug 29, 2022
Author

R0ser1
Sep 2, 2022
Author

wh1t3p1g Sep 2, 2022
Maintainer

R0ser1
Sep 2, 2022
Author

wh1t3p1g Sep 2, 2022
Maintainer

R0ser1 Sep 2, 2022
Author