Thingsboard не запускается после раскомментирования POSTGRESQL,

Я раскомментировал PostgreSQL и создал базу данных Thingsboard с помощью PGADMIn. Теперь я сталкиваюсь с этой ошибкой. Вот журнал. Plz help: Что это за " .PSQLException: ОШИБКА: отношение"component_descriptor"не существует"

2018-08-21 15:54:06,488 [main] INFO o.t.s.ThingsboardServerApplication - Starting ThingsboardServerApplication v2.1.0 on nishad-VirtualBox with PID 25141 (/usr/share/thingsboard/bin/thingsboard.jar started by thingsboard in /usr/share/thingsboard/bin)
2018-08-21 15:54:06,507 [main] INFO o.t.s.ThingsboardServerApplication - No active profile set, falling back to default profiles: default
2018-08-21 15:54:06,795 [main] INFO o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@6379eb: startup date [Tue Aug 21 15:54:06 IST 2018]; root of context hierarchy
2018-08-21 15:54:06,827 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 5.2.4.Final
2018-08-21 15:54:12,886 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
2018-08-21 15:54:14,067 [main] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
2018-08-21 15:54:14,415 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.rule.RuleNodeRepository.
2018-08-21 15:54:14,416 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.asset.AssetRepository.
2018-08-21 15:54:14,417 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.component.ComponentDescriptorRepository.
2018-08-21 15:54:14,417 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.rule.RuleChainRepository.
2018-08-21 15:54:14,418 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.attributes.AttributeKvRepository.
2018-08-21 15:54:14,418 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.timeseries.TsKvRepository.
2018-08-21 15:54:14,419 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.user.UserRepository.
2018-08-21 15:54:14,419 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.timeseries.TsKvLatestRepository.
2018-08-21 15:54:14,419 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.device.DeviceCredentialsRepository.
2018-08-21 15:54:14,420 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.relation.RelationRepository.
2018-08-21 15:54:14,420 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.tenant.TenantRepository.
2018-08-21 15:54:14,420 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.device.DeviceRepository.
2018-08-21 15:54:14,421 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.widget.WidgetTypeRepository.
2018-08-21 15:54:14,421 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.widget.WidgetsBundleRepository.
2018-08-21 15:54:14,421 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.dashboard.DashboardRepository.
2018-08-21 15:54:14,422 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.user.UserCredentialsRepository.
2018-08-21 15:54:14,422 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.alarm.AlarmRepository.
2018-08-21 15:54:14,422 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.settings.AdminSettingsRepository.
2018-08-21 15:54:14,423 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.event.EventRepository.
2018-08-21 15:54:14,423 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.customer.CustomerRepository.
2018-08-21 15:54:14,423 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.audit.AuditLogRepository.
2018-08-21 15:54:14,424 [main] INFO o.s.d.r.c.RepositoryConfigurationExtensionSupport - Spring Data Redis - Could not safely identify store assignment for repository candidate interface org.thingsboard.server.dao.sql.dashboard.DashboardInfoRepository.
2018-08-21 15:54:15,448 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.cache.annotation.ProxyCachingConfiguration' of type [class org.springframework.cache.annotation.ProxyCachingConfiguration$$EnhancerBySpringCGLIB$$e2f258e7] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:15,540 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$99e022c9] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:15,686 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration' of type [class org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration$$EnhancerBySpringCGLIB$$328deb03] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:15,724 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'objectPostProcessor' of type [class org.springframework.security.config.annotation.configuration.AutowireBeanFactoryObjectPostProcessor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:15,729 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@7446d8d5' of type [class org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:15,764 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration' of type [class org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration$$EnhancerBySpringCGLIB$$57628db5] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:15,787 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [class org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-08-21 15:54:16,960 [main] INFO o.s.b.c.e.t.TomcatEmbeddedServletContainer - Tomcat initialized with port(s): 8080 (http)
2018-08-21 15:54:16,983 [main] INFO o.a.catalina.core.StandardService - Starting service Tomcat
2018-08-21 15:54:16,989 [main] INFO o.a.catalina.core.StandardEngine - Starting Servlet Engine: Apache Tomcat/8.5.6
2018-08-21 15:54:17,170 [localhost-startStop-1] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
2018-08-21 15:54:17,171 [localhost-startStop-1] INFO o.s.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 10376 ms
2018-08-21 15:54:20,444 [localhost-startStop-1] INFO o.s.o.j.LocalContainerEntityManagerFactoryBean - Building JPA container EntityManagerFactory for persistence unit 'default'
2018-08-21 15:54:20,485 [localhost-startStop-1] INFO o.h.jpa.internal.util.LogHelper - HHH000204: Processing PersistenceUnitInfo [
name: default
...]
2018-08-21 15:54:21,032 [localhost-startStop-1] INFO org.hibernate.Version - HHH000412: Hibernate Core {5.0.11.Final}
2018-08-21 15:54:21,045 [localhost-startStop-1] INFO org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found
2018-08-21 15:54:21,049 [localhost-startStop-1] INFO org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist
2018-08-21 15:54:21,369 [localhost-startStop-1] INFO o.h.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
2018-08-21 15:54:22,461 [localhost-startStop-1] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL94Dialect
2018-08-21 15:54:22,779 [localhost-startStop-1] INFO o.h.e.j.e.i.LobCreatorBuilderImpl - HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2018-08-21 15:54:22,785 [localhost-startStop-1] INFO org.hibernate.type.BasicTypeRegistry - HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@3f1af3fc
2018-08-21 15:54:25,511 [localhost-startStop-1] INFO o.h.h.i.QueryTranslatorFactoryInitiator - HHH000397: Using ASTQueryTranslatorFactory
2018-08-21 15:54:28,492 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'characterEncodingFilter' to: [/]
2018-08-21 15:54:28,496 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'hiddenHttpMethodFilter' to: [/]
2018-08-21 15:54:28,497 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'httpPutFormContentFilter' to: [/]
2018-08-21 15:54:28,501 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'requestContextFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.DelegatingFilterProxyRegistrationBean - Mapping filter: 'springSecurityFilterChain' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'buildRestLoginProcessingFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'buildRestPublicLoginProcessingFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'buildJwtTokenAuthenticationProcessingFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'buildRefreshTokenProcessingFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'buildWsJwtTokenAuthenticationProcessingFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'corsFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.FilterRegistrationBean - Mapping filter: 'resourceUrlEncodingFilter' to: [/]
2018-08-21 15:54:28,504 [localhost-startStop-1] INFO o.s.b.w.s.ServletRegistrationBean - Mapping servlet: 'dispatcherServlet' to [/]
2018-08-21 15:54:29,053 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: host.name=nishad-VirtualBox
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.version=1.8.0_181
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.vendor=Oracle Corporation
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.home=/usr/lib/jvm/java-8-oracle/jre
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.class.path=/usr/share/thingsboard/bin/thingsboard.jar
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.io.tmpdir=/tmp
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: java.compiler=
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: os.name=Linux
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: os.arch=amd64
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: os.version=4.15.0-29-generic
2018-08-21 15:54:29,054 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: user.name=thingsboard
2018-08-21 15:54:29,055 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: user.home=/usr/share/thingsboard
2018-08-21 15:54:29,055 [main] INFO o.t.s.s.e.EnvironmentLogService - Thingsboard server environment: user.dir=/usr/share/thingsboard/bin
2018-08-21 15:54:29,092 [main] INFO o.t.s.s.c.d.CurrentServerInstanceService - Current server instance: [localhost;9001]
2018-08-21 15:54:29,094 [main] INFO o.t.s.s.c.d.DummyDiscoveryService - Initializing...
2018-08-21 15:54:29,097 [main] INFO o.t.s.s.c.r.ConsistentClusterRoutingService - Initializing Cluster routing service!
2018-08-21 15:54:29,112 [main] INFO o.t.s.s.c.r.ConsistentClusterRoutingService - Cluster routing service initialized!
2018-08-21 15:54:29,460 [main] INFO o.t.s.s.c.AnnotationComponentDiscoveryService - Processing scanned component: ComponentDescriptor(type=FILTER, scope=TENANT, name=originator type, clazz=org.thingsboard.rule.engine.filter.TbOriginatorTypeFilterNode, configurationDescriptor={"nodeDefinition":{"details":"If Originator Type of incoming message is expected - send Message via True chain, otherwise False chain is used.","description":"Filter incoming messages by message Originator Type","inEnabled":true,"outEnabled":true,"relationTypes":["True","False","Failure"],"customRelations":false,"defaultConfiguration":{"originatorTypes":["DEVICE"]},"uiResources":["static/rulenode/rulenode-core-config.js","static/rulenode/rulenode-core-config.css"],"configDirective":"tbFilterNodeOriginatorTypeConfig","icon":"","iconUrl":"","docUrl":""}}, actions=null)
2018-08-21 15:54:29,541 [main] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 42P01
2018-08-21 15:54:29,541 [main] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - ERROR: relation "component_descriptor" does not exist
Position: 301
2018-08-21 15:54:29,766 [main] ERROR o.t.s.s.c.AnnotationComponentDiscoveryService - Can't initialize component org.thingsboard.rule.engine.filter.TbOriginatorTypeFilterNode, due to could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:242)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:436)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy154.findByClazz(Unknown Source)
at org.thingsboard.server.dao.sql.component.JpaBaseComponentDescriptorDao.findByClazz(JpaBaseComponentDescriptorDao.java:81)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy155.findByClazz(Unknown Source)
at org.thingsboard.server.dao.component.BaseComponentDescriptorService.findByClazz(BaseComponentDescriptorService.java:71)
at org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.scanAndPersistComponent(AnnotationComponentDiscoveryService.java:147)
at org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.registerRuleNodeComponents(AnnotationComponentDiscoveryService.java:89)
at org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.discoverComponents(AnnotationComponentDiscoveryService.java:203)
at org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.init(AnnotationComponentDiscoveryService.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:366)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:311)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:134)
at )

0 ответов

Другие вопросы по тегам