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 日志的时区问题