Neo4j 设置时间

把Neo4j数据库日志的时间改成本地时间

neo4j.conf 里加上 dbms.db.timezone=SYSTEM 即可

下面的方法弃用

这个方法只能把写到文件的日志里的时间转成自己想要的时区的时间,原理是用的pl脚本

首先需要启动neo4j数据库,等数据库启动后,执行utc.pl脚本,然后就可以看到日志里的时间转成想要的时区的时间了,
缺点是只是把文件里的时间改变了,并没有改变neo4j里的时间 时区,所以控制台输出的还是原来没转化的。

脚本和方法如下
1. 首先新建utc.pl脚本,并用chmod设置权限
2. 启动neo4j数据库
3. 执行 utc.pl 脚本 ./utc.pl logs/debug.log > logs/debug.utc.log
4. 查看logs目录下的debug.utc.log,看是否起作用

utc.pl脚本

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
#!/usr/bin/perl -w
use strict;
use Time::Local; #needed for timegm()

my $file = $ARGV[0] or die "USAGE: $0 <filename>\n";

open(my $data, '<', $file) or die "Could not open '$file' $!\n";

while (my $line = <$data>) {
# where a line might start as
# 2017-01-11 23:22:28.372+0000 INFO ... .... ....
chomp $line;
# check to make sure the line begins with a YYYY-MM-DD HH
if ( $line =~ /\d\d\d\d-\d\d-\d\d \d\d/ ) {
my $newstring = UTC2LocalString($line);
print "$newstring\n";
}
else {
print "$line\n";
}
}


sub UTC2LocalString
{
# below attributed to Marshall at http://www.perlmonks.org/?node_id=873435
my $t = shift;
my ($datehour, $rest) = split(/:/,$t,2);
# $datehour will represent YYYY-MM-DD HH (i.e. 2017-01-14 12)
# $rest represents the rest of the line after
# and this will reassemble and return $datehour (adjusted) + $rest
my ($year, $month, $day, $hour) =
$datehour =~ /(\d+)-(\d\d)-(\d\d)\s+(\d\d)/;

# proto: $time = timegm($sec,$min,$hour,$mday,$mon,$year);
my $epoch = timegm (0,0,$hour,$day,$month-1,$year);

# proto: ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) =
# localtime(time);
my ($lyear,$lmonth,$lday,$lhour,$isdst) =
(localtime($epoch))[5,4,3,2,-1];

$lyear += 1900; # year is 1900 based
$lmonth++; # month number is zero based
#print "isdst: $isdst\n"; #debug flag day-light-savings time
return ( sprintf("%04d-%02d-%02d %02d:%s",
$lyear,$lmonth,$lday,$lhour,$rest) );
}

详细操作过程

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
[wkq@wkq neo4j-community-3.4.1]$ ll
total 288
drwxr-xr-x. 3 wkq wkq 4096 Jun 11 23:11 bin
drwxrwxr-x. 2 wkq wkq 51 Jul 4 16:31 certificates
drwxr-xr-x. 2 wkq wkq 31 Jul 4 16:53 conf
drwxr-xr-x. 4 wkq wkq 45 Jul 4 16:31 data
drwxr-xr-x. 2 wkq wkq 10 Jun 11 22:57 import
drwxrwxr-x. 2 wkq wkq 4096 Jul 4 16:31 lib
-rw-r--r--. 1 wkq wkq 84668 Jun 11 22:57 LICENSES.txt
-rw-r--r--. 1 wkq wkq 36005 Jun 11 22:57 LICENSE.txt
drwxr-xr-x. 2 wkq wkq 4096 Jul 4 16:55 logs
-rw-r--r--. 1 wkq wkq 5983 Jun 11 22:57 NOTICE.txt
drwxr-xr-x. 2 wkq wkq 10 Jun 11 22:57 plugins
-rw-r--r--. 1 wkq wkq 1596 Jun 11 22:57 README.txt
drwxr-xr-x. 2 wkq wkq 10 Jul 4 16:58 run
-rw-r--r--. 1 wkq wkq 96 Jun 11 22:57 UPGRADE.txt
-rwxrwxrwx. 1 wkq wkq 1538 Jul 4 16:37 utc.pl
[wkq@wkq neo4j-community-3.4.1]$ ./bin/neo4j console
Active database: graph.db
Directories in use:
home: /data/stale/data01/neo4j/neo4j-community-3.4.1
config: /data/stale/data01/neo4j/neo4j-community-3.4.1/conf
logs: /data/stale/data01/neo4j/neo4j-community-3.4.1/logs
plugins: /data/stale/data01/neo4j/neo4j-community-3.4.1/plugins
import: NOT SET
data: /data/stale/data01/neo4j/neo4j-community-3.4.1/data
certificates: /data/stale/data01/neo4j/neo4j-community-3.4.1/certificates
run: /data/stale/data01/neo4j/neo4j-community-3.4.1/run
Starting Neo4j.
2018-07-04 08:59:51.364+0000 INFO ======== Neo4j 3.4.1 ========
2018-07-04 08:59:51.392+0000 INFO Starting...
2018-07-04 08:59:53.202+0000 INFO Bolt enabled on 0.0.0.0:7687.
2018-07-04 08:59:54.849+0000 INFO Started.
2018-07-04 08:59:55.631+0000 WARN Low configured threads: (max={} - required={})={} < warnAt={} for {}
2018-07-04 08:59:55.649+0000 INFO Remote interface available at http://localhost:7474/


[wkq@wkq neo4j-community-3.4.1]$ ./utc.pl logs/debug.log > logs/debug.utc.log

[wkq@wkq neo4j-community-3.4.1]$ cd logs/
[wkq@wkq logs]$ ll
total 140
-rw-rw-r--. 1 wkq wkq 48884 Jul 4 17:02 debug.log
-rw-rw-r--. 1 wkq wkq 48884 Jul 4 17:03 debug.utc.log
-rw-rw-r--. 1 wkq wkq 40654 Jul 4 17:02 gc.log.0.current
-rw-rw-r--. 1 wkq wkq 850 Jul 4 17:02 http.log


[wkq@wkq logs]$ tail -100 debug.log
2018-07-04 08:59:53.285+0000 INFO [o.n.k.i.DiagnosticsManager] Id usage:
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] ArrayPropertyStore: used=1 high=0
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] NodeStore: used=0 high=-1
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] PropertyIndexStore: used=0 high=-1
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] ArrayPropertyStore: used=1 high=0
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] PropertyStore: used=0 high=-1
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] RelationshipStore: used=0 high=-1
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] RelationshipTypeStore: used=0 high=-1
2018-07-04 08:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] LabelTokenStore: used=0 high=-1
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] SchemaStore: used=1 high=0
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] RelationshipGroupStore: used=1 high=0
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] NeoStore: used=15 high=14
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for NEO_STORE_ID_USAGE END ---
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for NEO_STORE_RECORDS START ---
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] Neostore records:
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] TIME (Creation time): 1530693102899
2018-07-04 08:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] RANDOM_NUMBER (Random number for store id): 8927400069693653901
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LOG_VERSION (Current log version): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_TRANSACTION_ID (Last committed transaction): 1
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] STORE_VERSION (Store format version): 16094931155187206
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] FIRST_GRAPH_PROPERTY (First property record containing graph properties): -1
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_CONSTRAINT_TRANSACTION (Last committed transaction containing constraint changes): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TRANSACTION_ID (Transaction id most recent upgrade was performed at): 1
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TIME (Time of last upgrade): 1530693102899
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_TRANSACTION_CHECKSUM (Checksum of last committed transaction): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TRANSACTION_CHECKSUM (Checksum of transaction id the most recent upgrade was performed at): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_CLOSED_TRANSACTION_LOG_VERSION (Log version where the last transaction commit entry has been written into): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_CLOSED_TRANSACTION_LOG_BYTE_OFFSET (Byte offset in the log file where the last transaction commit entry has been written into): 16
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_TRANSACTION_COMMIT_TIMESTAMP (Commit time timestamp for last committed transaction): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TRANSACTION_COMMIT_TIMESTAMP (Commit timestamp of transaction the most recent upgrade was performed at): 0
2018-07-04 08:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for NEO_STORE_RECORDS END ---
2018-07-04 08:59:53.289+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for TRANSACTION_RANGE START ---
2018-07-04 08:59:53.289+0000 INFO [o.n.k.i.DiagnosticsManager] Transaction log:
2018-07-04 08:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] Oldest transaction 2 found in log with version 0
2018-07-04 08:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for TRANSACTION_RANGE END ---
2018-07-04 08:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for KernelDiagnostics:StoreFiles START ---
2018-07-04 08:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] Disk space on partition (Total / Free / Free %): 5995761762304 / 5630701182976 / 93
2018-07-04 08:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] Storage files: (filename : modification date - size)
2018-07-04 08:59:53.291+0000 INFO [o.n.k.i.DiagnosticsManager] index:
2018-07-04 08:59:53.292+0000 INFO [o.n.k.i.DiagnosticsManager] - Total: 2018-07-04T16:31:43+0800 - 0.00 B
2018-07-04 08:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.counts.db.a: 2018-07-04T16:31:43+0800 - 96.00 B
2018-07-04 08:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labelscanstore.db: 2018-07-04T16:59:52+0800 - 40.00 kB
2018-07-04 08:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db.names: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db.names.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db.labels: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db.labels.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.arrays: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.arrays.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index.keys: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index.keys.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.strings: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.strings.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipgroupstore.db: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipgroupstore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipstore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipstore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db.names: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db.names.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.schemastore.db: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 08:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.schemastore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 08:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.transaction.db.0: 2018-07-04T16:58:15+0800 - 88.00 B
2018-07-04 08:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] store_lock: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 08:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] Storage summary:
2018-07-04 08:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] Total size of store: 112.31 kB
2018-07-04 08:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] Total size of mapped files: 112.00 kB
2018-07-04 08:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for KernelDiagnostics:StoreFiles END ---
2018-07-04 08:59:54.850+0000 INFO [o.n.k.i.DiagnosticsManager] --- SERVER STARTED START ---
2018-07-04 08:59:55.649+0000 INFO [o.n.k.i.DiagnosticsManager] --- SERVER STARTED END ---
2018-07-04 09:02:17.230+0000 ERROR [o.n.b.r.DefaultBoltConnection] Unexpected error detected in bolt session '1402ecfffe7d5b64-00001f8c-00000001-a464075b467c9fad-e3b5926d'. The client is unauthorized due to authentication failure.
org.neo4j.bolt.v1.runtime.BoltConnectionFatality: The client is unauthorized due to authentication failure.
at org.neo4j.bolt.v1.runtime.BoltStateMachine.handleFailure(BoltStateMachine.java:742)
at org.neo4j.bolt.v1.runtime.BoltStateMachine.handleFailure(BoltStateMachine.java:728)
at org.neo4j.bolt.v1.runtime.BoltStateMachine.access$500(BoltStateMachine.java:62)
at org.neo4j.bolt.v1.runtime.BoltStateMachine$State$1.init(BoltStateMachine.java:435)
at org.neo4j.bolt.v1.runtime.BoltStateMachine.init(BoltStateMachine.java:145)
at org.neo4j.bolt.v1.messaging.BoltMessageRouter.lambda$onInit$0(BoltMessageRouter.java:70)
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:195)
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:143)
at org.neo4j.bolt.runtime.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:170)
at org.neo4j.bolt.runtime.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$2(ExecutorBoltScheduler.java:153)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


[wkq@wkq logs]$ tail -100 debug.utc.log
2018-07-04 16:59:53.285+0000 INFO [o.n.k.i.DiagnosticsManager] Id usage:
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] ArrayPropertyStore: used=1 high=0
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] NodeStore: used=0 high=-1
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] PropertyIndexStore: used=0 high=-1
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] ArrayPropertyStore: used=1 high=0
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] PropertyStore: used=0 high=-1
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] RelationshipStore: used=0 high=-1
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] RelationshipTypeStore: used=0 high=-1
2018-07-04 16:59:53.286+0000 INFO [o.n.k.i.DiagnosticsManager] StringPropertyStore: used=1 high=0
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] LabelTokenStore: used=0 high=-1
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] SchemaStore: used=1 high=0
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] RelationshipGroupStore: used=1 high=0
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] NeoStore: used=15 high=14
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for NEO_STORE_ID_USAGE END ---
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for NEO_STORE_RECORDS START ---
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] Neostore records:
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] TIME (Creation time): 1530693102899
2018-07-04 16:59:53.287+0000 INFO [o.n.k.i.DiagnosticsManager] RANDOM_NUMBER (Random number for store id): 8927400069693653901
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LOG_VERSION (Current log version): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_TRANSACTION_ID (Last committed transaction): 1
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] STORE_VERSION (Store format version): 16094931155187206
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] FIRST_GRAPH_PROPERTY (First property record containing graph properties): -1
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_CONSTRAINT_TRANSACTION (Last committed transaction containing constraint changes): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TRANSACTION_ID (Transaction id most recent upgrade was performed at): 1
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TIME (Time of last upgrade): 1530693102899
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_TRANSACTION_CHECKSUM (Checksum of last committed transaction): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TRANSACTION_CHECKSUM (Checksum of transaction id the most recent upgrade was performed at): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_CLOSED_TRANSACTION_LOG_VERSION (Log version where the last transaction commit entry has been written into): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_CLOSED_TRANSACTION_LOG_BYTE_OFFSET (Byte offset in the log file where the last transaction commit entry has been written into): 16
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] LAST_TRANSACTION_COMMIT_TIMESTAMP (Commit time timestamp for last committed transaction): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] UPGRADE_TRANSACTION_COMMIT_TIMESTAMP (Commit timestamp of transaction the most recent upgrade was performed at): 0
2018-07-04 16:59:53.288+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for NEO_STORE_RECORDS END ---
2018-07-04 16:59:53.289+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for TRANSACTION_RANGE START ---
2018-07-04 16:59:53.289+0000 INFO [o.n.k.i.DiagnosticsManager] Transaction log:
2018-07-04 16:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] Oldest transaction 2 found in log with version 0
2018-07-04 16:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for TRANSACTION_RANGE END ---
2018-07-04 16:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for KernelDiagnostics:StoreFiles START ---
2018-07-04 16:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] Disk space on partition (Total / Free / Free %): 5995761762304 / 5630701182976 / 93
2018-07-04 16:59:53.290+0000 INFO [o.n.k.i.DiagnosticsManager] Storage files: (filename : modification date - size)
2018-07-04 16:59:53.291+0000 INFO [o.n.k.i.DiagnosticsManager] index:
2018-07-04 16:59:53.292+0000 INFO [o.n.k.i.DiagnosticsManager] - Total: 2018-07-04T16:31:43+0800 - 0.00 B
2018-07-04 16:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.counts.db.a: 2018-07-04T16:31:43+0800 - 96.00 B
2018-07-04 16:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.293+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labelscanstore.db: 2018-07-04T16:59:52+0800 - 40.00 kB
2018-07-04 16:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db.names: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.294+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.labeltokenstore.db.names.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db.labels: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.295+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.nodestore.db.labels.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.arrays: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.arrays.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.296+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index.keys: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.index.keys.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.strings: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.propertystore.db.strings.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.297+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipgroupstore.db: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipgroupstore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipstore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshipstore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.298+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db.names: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.relationshiptypestore.db.names.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.schemastore.db: 2018-07-04T16:31:42+0800 - 8.00 kB
2018-07-04 16:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.schemastore.db.id: 2018-07-04T16:59:52+0800 - 9.00 B
2018-07-04 16:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] neostore.transaction.db.0: 2018-07-04T16:58:15+0800 - 88.00 B
2018-07-04 16:59:53.299+0000 INFO [o.n.k.i.DiagnosticsManager] store_lock: 2018-07-04T16:31:42+0800 - 0.00 B
2018-07-04 16:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] Storage summary:
2018-07-04 16:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] Total size of store: 112.31 kB
2018-07-04 16:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] Total size of mapped files: 112.00 kB
2018-07-04 16:59:53.300+0000 INFO [o.n.k.i.DiagnosticsManager] --- STARTED diagnostics for KernelDiagnostics:StoreFiles END ---
2018-07-04 16:59:54.850+0000 INFO [o.n.k.i.DiagnosticsManager] --- SERVER STARTED START ---
2018-07-04 16:59:55.649+0000 INFO [o.n.k.i.DiagnosticsManager] --- SERVER STARTED END ---
2018-07-04 17:02:17.230+0000 ERROR [o.n.b.r.DefaultBoltConnection] Unexpected error detected in bolt session '1402ecfffe7d5b64-00001f8c-00000001-a464075b467c9fad-e3b5926d'. The client is unauthorized due to authentication failure.
org.neo4j.bolt.v1.runtime.BoltConnectionFatality: The client is unauthorized due to authentication failure.
at org.neo4j.bolt.v1.runtime.BoltStateMachine.handleFailure(BoltStateMachine.java:742)
at org.neo4j.bolt.v1.runtime.BoltStateMachine.handleFailure(BoltStateMachine.java:728)
at org.neo4j.bolt.v1.runtime.BoltStateMachine.access$500(BoltStateMachine.java:62)
at org.neo4j.bolt.v1.runtime.BoltStateMachine$State$1.init(BoltStateMachine.java:435)
at org.neo4j.bolt.v1.runtime.BoltStateMachine.init(BoltStateMachine.java:145)
at org.neo4j.bolt.v1.messaging.BoltMessageRouter.lambda$onInit$0(BoltMessageRouter.java:70)
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:195)
at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:143)
at org.neo4j.bolt.runtime.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:170)
at org.neo4j.bolt.runtime.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$2(ExecutorBoltScheduler.java:153)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

References:

[1] config_dbms.db.timezone
[2] timezone-setting-for-neo4j-log
[3] how-do-i-convert-neo4j-logs-from-base-utc-to-local-timezone
[4] neo4j 日志的时区问题