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脚本
#!/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) );
}
详细操作过程
[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 日志的时区问题