You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@skywalking.apache.org by GitBox <gi...@apache.org> on 2018/12/22 08:05:01 UTC

[GitHub] rainmakerho commented on issue #2080: org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -657805 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement: select * from service_inventory where is_address=? and mapping_last_update_time>? LIMIT 50 [42102-196]

rainmakerho commented on issue #2080: org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -657805 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement: select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
URL: https://github.com/apache/incubator-skywalking/issues/2080#issuecomment-449553815
 
 
   I test connection(jdbc:h2:mem:skywalking-oap-dbf) with H2 Console, result is successful.
   
   #### webapp.log only one waring message, 
   - [main] c.c.c.ConfigServicePropertySourceLocator : Could not locate PropertySource: I/O error on GET request for "http://localhost:8888/application/default": Connection refused: connect; nested exception is java.net.ConnectException: Connection refused: connect
   
   #### skywalking-oap-server.log have one waring message and many error messages,
   - com.coxautodev.graphql.tools.SchemaClassScanner -5281 [main] WARN  [] - Schema type was defined but can never be accessed, and can be safely deleted: NodeType
   - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -9266 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:00:55,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -12234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:00:58,282 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -15281 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:01,251 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -18250 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:04,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -21234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:07,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -24234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:10,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -27234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:13,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -30234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:16,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -33234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:19,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -36234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:22,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -39234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:25,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -42234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:28,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -45234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:31,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -48234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:34,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -51234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:37,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -54234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:40,235 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -57234 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:43,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -60232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:46,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -63232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:49,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -66232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:51,280 - org.apache.skywalking.oap.server.core.storage.ttl.DataTTLKeeperTimer -68279 [pool-9-thread-1] INFO  [] - Beginning to remove expired metrics from the storage.
   2018-12-22 16:01:51,280 - org.apache.skywalking.oap.server.core.storage.ttl.DataTTLKeeperTimer -68279 [pool-9-thread-1] INFO  [] - Metrics in minute dimension before 201812221431, are going to be removed.
   2018-12-22 16:01:51,280 - org.apache.skywalking.oap.server.core.storage.ttl.DataTTLKeeperTimer -68279 [pool-9-thread-1] INFO  [] - Metrics in hour dimension before 2018122104, are going to be removed.
   2018-12-22 16:01:51,280 - org.apache.skywalking.oap.server.core.storage.ttl.DataTTLKeeperTimer -68279 [pool-9-thread-1] INFO  [] - Metrics in day dimension before 20181107, are going to be removed.
   2018-12-22 16:01:51,280 - org.apache.skywalking.oap.server.core.storage.ttl.DataTTLKeeperTimer -68279 [pool-9-thread-1] INFO  [] - Metrics in month dimension before 201706, are going to be removed.
   2018-12-22 16:01:52,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -69232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:55,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -72232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:01:58,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -75232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:01,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -78232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:04,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -81232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:07,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -84232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:10,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -87232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:13,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -90232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:16,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -93232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:19,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -96232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:22,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -99232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   2018-12-22 16:02:25,233 - org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ServiceInventoryCacheDAO -102232 [pool-10-thread-1] ERROR [] - Table "SERVICE_INVENTORY" not found; SQL statement:
   select * from service_inventory where is_address=?  and mapping_last_update_time>? LIMIT 50  [42102-196]
   
   Thank for your help.
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services