uttinie
uttinie
新taskmanage sql job的日志如下，中间出现过一次taskmanger节点下线： ``` 22/09/15 22:05:02 WARN OpenmldbSession: Fail to register table tutorial.s1, error: Path does not exist: file:/opt/xxx/data/OnlineLearning/cache/openmldb_offline_storage/tutorial/s1; 22/09/15 22:05:02 WARN OpenmldbSession: Fail to register table tutorial.s2, error: Path...
``` 10.97.152.110:6527/tutorial> set @@sync_job=true; SUCCEED 10.97.152.110:6527/tutorial> select * from t1; Get exception: SQL parse error: Fail to transform data provider op: table t1 not exists in database [tutorial] (At /__w/OpenMLDB/OpenMLDB/hybridse/src/vm/sql_compiler.cc:275)...
``` 10.97.152.110:6527/tutorial> use tutorial; SUCCEED: Database changed 10.97.152.110:6527/tutorial> desc t1; ---- ------------ ----------- ------ --------- # Field Type Null Default ---- ------------ ----------- ------ --------- 1 id BigInt YES 2...
zookeeper server log： ``` 2022-09-15 14:54:26,898 [myid:1] - WARN [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:22181:ZooKeeperServer@903] - Connection request from old client /10.97.152.110:36414; will be dropped if server is in r-o mode 2022-09-15 14:54:26,898 [myid:1] -...
``` [root@gz5-tysearch-bms-Indexer-97-152-110 tysearch]# grep -C5 0x205ea539ae40000 zookeeper.out 2022-09-15 21:00:43,286 [myid:1] - INFO [WorkerReceiver[myid=1]:FastLeaderElection@595] - Notification: 1 (message format version), 2 (n.leader), 0x1000007e8 (n.zxid), 0x3 (n.round), LOOKING (n.state), 2 (n.sid), 0x2...
版本：0.6.2 集群1060份请求样本数据压测，去除10d窗口qps 4w，带10d窗口性能降低至30qps，长窗口优化是否是处理这方面 数据内容为20220814后一周约800w条数据（数据分布整体均匀），超时时间设定为60d
> > 版本：0.6.2 集群1060份请求样本数据压测，去除10d窗口qps 4w，带10d窗口性能降低至30qps，长窗口优化是否是处理这方面 数据内容为20220814后一周约800w条数据（数据分布整体均匀），超时时间设定为60d > > @uttinie 需要几点帮忙确认的地方： > > * 先执行deploy with long_windows options，再导入数据? > * 连接sql_client查看预聚合表信息`select * from __INTERNAL_DB.PRE_AGG_META_INFO;` > * 连接ns_client， > ``` > use...
> > pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver > > @uttinie > > * 导入数据是否按照时间顺序，由小到大导入的？ > * `pro_ver`的取值有多少？只有`12.0`和`6.1`两个取值么？ > * 可以在ns client上，执行 > > ``` > use demo_db > showtable > ``` > > *...
``` 10.97.152.110:6527/demo_db> select * from __INTERNAL_DB.PRE_AGG_META_INFO; -------------------------------------------------------------------- -------------- --------- --------------------------- ------------- ------------- ---------------------- ----------------- ------------- ------------ aggr_table aggr_db base_db base_table aggr_func aggr_col partition_cols order_by_col bucket_size filter_col -------------------------------------------------------------------- -------------- --------- ---------------------------...
online server load data failed，but same sql success inoffline mode [job_161_error.zip](https://github.com/4paradigm/OpenMLDB/files/9502013/job_161_error.zip)