本地搭建gstore环境崩溃，无法使用

Discussion

Home Discussion Board CCKS2022: Open domain knowledge-graph-based question answering 本地搭建gstore环境崩溃，无法使用

Aqsz

本地搭建gstore环境崩溃，无法使用

posted in CCKS2022: Open domain knowledge-graph-based question answering

2022-07-01 14:29

```sql
select ?y where { ?x <中文名> "不能说的秘密" . ?x <片长> ?y . }
```
这条语句能在http://pkubase.gstore.cn/ 查询到结果，但是本地搭建的环境会导致系统崩溃。本地环境使用gstore github 中提到的最新docker镜像构建。

```shell
finish getting important objID, the cache size is 78914860
now add cache of objID2values...
begin three StringIndexFile
Value File Preload used 23 ms
load cache successfully!
finish load
triple num: 65535841
pre num: 401177
entity num: 11311724
literal num: 13945718
transaction log has been created.
query log file is not exists, now create it.
queryLog: logs/endpoint/20220701.log
backup path: ./backups
remote_ip: 172.17.0.1
request time :20220701 14:14:41
request remote ip:172.17.0.1
request method:GET
request http_version:1.1
request type:GET
request path:/%3Foperation%3Dquery%26username%3Droot%26password%3D123456%26db_name%3Dpkubase%26format%3Djson%26sparql%3Dselect%20%3Fy%20where%20%7B%20%3Fx%20%3C%E4%B8%AD%E6%96%87%E5%90%8D%3E%20%22%E4%B8%8D%E8%83%BD%E8%AF%B4%E7%9A%84%E7%A7%98%E5%AF%86%22%20.%20%3Fx%20%3C%E7%89%87%E9%95%BF%3E%20%3Fy%20.%20%7D
request path:/?operation=query&username=root&password=123456&db_name=pkubase&format=json&sparql=select ?y where { ?x <中文名> "不能说的秘密" . ?x <片长> ?y . }
check identity successfully.
thread 140486730237696 -- HTTP: this is query
Thread:30 run
check: select ?y where { ?x <中文名> "不能说的秘密" . ?x <片长> ?y . }
the database is loaded..
current_database:pkubase
find name:pkubase
lock the database
test debug1...
begin query...
after Parsing, used 0ms.
read priviledge of update lock acquired
================================================================================
SELECT
Var: 	?y
GroupPattern:
{
	?x	<中文名>	"不能说的秘密".
	?x	<片长>	?y.
}
================================================================================
=============================
||well-designed at dep = 0||
=============================
================================================================================
{
	?x	<中文名>	"不能说的秘密".
	?x	<片长>	?y.
}
================================================================================
useful vars (SELECT + GROUPBY + ORDERBY): Varset: ?y
triple patterns:
?x	<中文名>	"不能说的秘密"
?x	<片长>	?y
after checkCache, used 0 ms.
QueryCache miss
IN buildBasicSignature
now to check the query var list order:
0 ?y
select variables: [?y, 0 0]
graph variables: [?y, 0 0]	[?x, 1 1]
before new IDList!
sub var id: 1
sub var id: 1
obj var id: 0
OUT encodeBasicQuery
after Encode, used 2 ms.
after FillCand, used 0 ms.
this BasicQuery use query strategy 0
after Retrieve, used 0ms.
start constant filter here

Var0 ?y
		[0] after constant filter, candidate size = 0

Var1 ?x
		[1] after constant filter, candidate size = 2

pre filter start here
	Var1 ?x
[20220701 14:14:42] stopped abnormally, restarting server...
ghttp begin initialize...
init param...
the current settings are as below:
key : value
------------------------------------------------------------
BackupTime : 2000	# 4 am (GMT+8)
backup_path : "./backups"
buffer_maxium : 100
db_home : .
db_path : "."
db_suffix : .db
debug_level : simple
gstore_mode : single
max_database_num : 100
max_output_size : 10000000
max_querylog_size : 80000000
max_user_num : 1000
operation_logs : true
querylog_path : "logs/endpoint/"
root_password : "123456"
root_username : "root"
system_path : "data/system/system.nt"
system_username : "system"
thread_maxium : 1000
thread_num : 30
version : 0.9.1

server port: 9000 database name: pkubase
```
另一个例子，查询语句中的C++不能正常解析
```shell
finish load
triple num: 65535841
pre num: 401177
entity num: 11311724
literal num: 13945718
transaction log has been created.
queryLog: logs/endpoint/20220701.log
backup path: ./backups
remote_ip: 172.17.0.1
request time :20220701 14:23:20
request remote ip:172.17.0.1
request method:GET
request http_version:1.1
request type:GET
request path:/%3Foperation%3Dquery%26username%3Droot%26password%3D123456%26db_name%3Dpkubase%26format%3Djson%26sparql%3Dselect%20%3Fx%20where%20%7B%20%3Cc%2B%2B%3E%20%3C%E5%88%9B%E5%A7%8B%E4%BA%BA%3E%20%3Fy.%20%3Fy%20%3C%E5%9B%BD%E7%B1%8D%3E%20%3Fx.%20%7D
request path:/?operation=query&username=root&password=123456&db_name=pkubase&format=json&sparql=select ?x where { <c++> <创始人> ?y. ?y <国籍> ?x. }
check identity successfully.
thread 140486738630400 -- HTTP: this is query
Thread:30 run
check: select ?x where { <c  > <创始人> ?y. ?y <国籍> ?x. }
the database is loaded..
current_database:pkubase
find name:pkubase
lock the database
test debug1...
begin query...
catch run_time error exception
query failed:[Syntax Error]:line 1:18 mismatched input '<' expecting {'(', '{', '}', '[', 'true', 'false', K_SELECT, K_BIND, K_SERVICE, K_MINUS, K_FILTER, K_GRAPH, K_VALUES, K_OPTIONAL, IRIREF, PNAME_NS, PNAME_LN, BLANK_NODE_LABEL, VAR1, VAR2, INTEGER, DECIMAL, DOUBLE, INTEGER_POSITIVE, DECIMAL_POSITIVE, DOUBLE_POSITIVE, INTEGER_NEGATIVE, DECIMAL_NEGATIVE, DOUBLE_NEGATIVE, STRING_LITERAL1, STRING_LITERAL2, STRING_LITERAL_LONG1, STRING_LITERAL_LONG2, NIL, ANON}
response result:
{
    "StatusCode": 1005,
    "StatusMsg": "[Syntax Error]:line 1:18 mismatched input '<' expecting {'(', '{', '}', '[', 'true', 'false', K_SELECT, K_BIND, K_SERVICE, K_MINUS, K_FILTER, K_GRAPH, K_VALUES, K_OPTIONAL, IRIREF, PNAME_NS, PNAME_LN, BLANK_NODE_LABEL, VAR1, VAR2, INTEGER, DECIMAL, DOUBLE, INTEGER_POSITIVE, DECIMAL_POSITIVE, DOUBLE_POSITIVE, INTEGER_NEGATIVE, DECIMAL_NEGATIVE, DOUBLE_NEGATIVE, STRING_LITERAL1, STRING_LITERAL2, STRING_LITERAL_LONG1, STRING_LITERAL_LONG2, NIL, ANON}"
}
```

23 comments