随着实时数据库的数据的不断存储,数据亮已经达到了9位数,而页面还要统计总条数,导致查询超时失败,返回的结果一直是0,经过排查是超时导致
influxDB java.net.SocketTimeoutException: Read timed out 问题
原因是http超时
解决方法:
引入okhttp
static OkHttpClient.Builder client = new OkHttpClient.Builder().readTimeout(100000,TimeUnit.SECONDS);
// 设置很大的超时时间
然后在influx初始化连接的时候,引入okhttpclient
influxDB = InfluxDBFactory.connect(url, username, password,client);
附一个我自己的java文件
import lombok.Data;
import lombok.extern.slf4j.Slf4j;
import okhttp3.OkHttpClient;
import org.influxdb.InfluxDB;
import org.influxdb.InfluxDBFactory;
import org.influxdb.dto.Point;
import org.influxdb.dto.Query;
import org.influxdb.dto.QueryResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.apache.commons.beanutils.BeanUtils;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.TimeUnit;
@Repository
@Slf4j
@Component
public class BaseInfluxDB<T> {
@Autowired
private InfluxDB influxDB;
//配置数据库和数据保存策略
private String dataBaseName="water_database";
static OkHttpClient.Builder client = new OkHttpClient.Builder()
.readTimeout(1000000, TimeUnit.SECONDS);
@Value("${spring.influx.url}")
private String url;
/**
* 用户名
*/
@Value("${spring.influx.user}")
private String user;
/**
* 密码
*/
@Value("${spring.influx.password}")
private String password;
/**
* 数据库
*/
@Value("${spring.influx.database}")
private String database;
/**
* 保留策略
*/
@Value("${spring.influx.retentionpolicy}")
private String retentionPolicyName;
public boolean insert(String measurement,Map<String, String> tags, Map<String, Object> fields){
boolean flag=false;
try{
Point.Builder builder = Point.measurement(measurement); //表名字
builder.tag(tags);
builder.fields(fields);
influxDB.write(dataBaseName, retentionPolicyName, builder.build()); //数据库名字和 策略名字
flag=true;
}catch (Exception exception){
exception.printStackTrace();
}
return flag;
}
//基本查询
public List<T> query(String command ,Class<T> clazz){
InfluxDB connect = InfluxDBFactory.connect(url, user, password,client);
List<T> resultList = new ArrayList<T>();
try{
QueryResult queryResult = connect.query(new Query(command, dataBaseName)); //数据库和查询语句
List<QueryResult.Result> results = queryResult.getResults(); //查询结果
for(QueryResult.Result result :results){
List<QueryResult.Series> seriess = result.getSeries();//有结果组装返回对象
if(seriess!=null){
//直接返回对象
for(QueryResult.Series series :seriess){
String name = series.getName();
List<List<Object>> value = series.getValues();
List<String> key = series.getColumns();
for(List<Object> object :value){
Map<String,Object> beanProperMap =new HashMap<>();
//匹配属性和属性值
for(int i=0;i<object.size();i++){
String k=key.get(i);
Object v =object.get(i);
beanProperMap.put(k,v);
}
//创建对象并且赋值
T bean =clazz.newInstance();
try {
BeanUtils.populate(bean,beanProperMap);
} catch (Exception e) {
e.printStackTrace();
}
//保存集合
resultList.add(bean);
}
}
}
}
}catch (Exception exception){
exception.printStackTrace();
}
return resultList;
}
}