Skip to content

Instantly share code, notes, and snippets.

@magaton

magaton/README.md

Last active June 25, 2021 11:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save magaton/7abcbc6f87243b9f142b279a78af9f40 to your computer and use it in GitHub Desktop.
Save magaton/7abcbc6f87243b9f142b279a78af9f40 to your computer and use it in GitHub Desktop.
Download ZIP
apoc.log problem in the trigger and apoc.periodic.iterate
Raw
README.md

The problem: I have 20430 lines in CSV. Each line is one order. Orders are made by clients (I have 100 clients)

On each row, I MERGE Order and Client and connect them with MADE relatuonship (Client)-[:MADE]->(Order)

There is a trigger that kicks off when MADE relationship is created. Trigger contains apoc.log.info CALL.

With batchSize=1 and batchSize=100I am getting very different number of log messages.

I would expect that all 20430 orders are showing up in logs, but this is not the case. Graph looks ok. All orders, clients and their relationship is inserted in the graph.

I am executing the cypher below in cypher shell:

  • bin/cypher-shell -u neo4j -p admin -d neo4j -f /Users/magaton/Projects/grandstack/neo4j/cypher/apoc-log.cypher --param 'batchSize => 1'
  • bin/cypher-shell -u neo4j -p admin -d neo4j -f /Users/magaton/Projects/grandstack/neo4j/cypher/apoc-log.cypher --param 'batchSize => 100'
Raw
apoc-log.cypher
CREATE CONSTRAINT ON (c:Client) ASSERT c.id IS UNIQUE;
CREATE CONSTRAINT ON (o:Order) ASSERT o.id IS UNIQUE;
CALL apoc.trigger.removeAll();
CALL apoc.trigger.add("volume-calculation-test",
"UNWIND [rel in $createdRelationships WHERE type(rel) = 'MADE'] AS rel
WITH startNode(rel) AS per, endNode(rel) AS order
CALL apoc.log.info('##### Order ' + order.id + ' ##### MADE BY Client: ' + per.id)
SET order.status='processed'
RETURN order",
{phase:'before'})
YIELD name, installed, paused
RETURN name, installed, paused;
CALL apoc.trigger.list() YIELD name, installed, paused RETURN name, installed, paused;
CALL apoc.periodic.iterate(
"LOAD CSV WITH HEADERS FROM ('https://github.com/magaton/slashco-mlm/blob/master/orders-22-01.csv?raw=true')AS line RETURN line",
"WITH line, date(line.date) as date
MERGE (order:Order {id:line.id})
ON CREATE SET order.createDate=date, order.effectiveDate=date, order.referer=line.referer, order.post=line.post, order.type=line.type
MERGE (client:Client {id:line.client})
WITH order, client
MERGE (client)-[:MADE]->(order)
RETURN order", {batchSize:$batchSize, parallel:false, retries: 3})
YIELD batch, operations, timeTaken
RETURN batch, operations, timeTaken;
Raw
apoc.conf
apoc.user.log.type=raw
apoc.trigger.enabled=true
Raw
neo4j.log.batchSize1
2021-06-25 10:29:33.694+0000 INFO Starting...
2021-06-25 10:29:35.713+0000 INFO ======== Neo4j 4.2.4 ========
2021-06-25 10:29:43.250+0000 INFO Performing postInitialization step for component 'security-users' with version 2 and status CURRENT
2021-06-25 10:29:43.250+0000 INFO Updating the initial password in component 'security-users'
2021-06-25 10:29:47.576+0000 INFO Called db.clearQueryCaches(): Query cache already empty.
2021-06-25 10:29:52.691+0000 INFO Bolt enabled on localhost:7687.
2021-06-25 10:29:53.450+0000 INFO Remote interface available at http://localhost:7474/
2021-06-25 10:29:53.451+0000 INFO Started.
2021-06-25 10:30:11.125+0000 INFO starting batching from `LOAD CSV WITH HEADERS FROM ('https://github.com/magaton/slashco-mlm/blob/master/orders-22-01.csv?raw=true')AS line RETURN line` operation using iteration `WITH line, date(line.date) as date
MERGE (order:Order {id:line.id})
ON CREATE SET order.createDate=date, order.effectiveDate=date, order.referer=line.referer, order.post=line.post, order.type=line.type
MERGE (client:Client {id:line.client})
WITH order, client
MERGE (client)-[:MADE]->(order)
RETURN order` in separate thread
2021-06-25 10:30:13.213+0000 INFO ##### Order 10000000 ##### MADE BY Client: c30
2021-06-25 10:30:13.285+0000 INFO ##### Order 10000010 ##### MADE BY Client: c45
2021-06-25 10:30:13.317+0000 INFO ##### Order 10000020 ##### MADE BY Client: c73
2021-06-25 10:30:13.349+0000 INFO ##### Order 10000030 ##### MADE BY Client: c60
2021-06-25 10:30:13.380+0000 INFO ##### Order 10000040 ##### MADE BY Client: c72
2021-06-25 10:30:13.412+0000 INFO ##### Order 10000050 ##### MADE BY Client: c97
2021-06-25 10:30:13.448+0000 INFO ##### Order 10000060 ##### MADE BY Client: c28
2021-06-25 10:30:13.481+0000 INFO ##### Order 10000070 ##### MADE BY Client: c84
2021-06-25 10:30:13.514+0000 INFO ##### Order 10000080 ##### MADE BY Client: c52
2021-06-25 10:30:13.546+0000 INFO ##### Order 10000090 ##### MADE BY Client: c59
2021-06-25 10:30:23.222+0000 INFO ##### Order 10003900 ##### MADE BY Client: c66
2021-06-25 10:30:23.251+0000 INFO ##### Order 10003910 ##### MADE BY Client: c22
2021-06-25 10:30:23.278+0000 INFO ##### Order 10003920 ##### MADE BY Client: c17
2021-06-25 10:30:23.307+0000 INFO ##### Order 10003930 ##### MADE BY Client: c12
2021-06-25 10:30:23.334+0000 INFO ##### Order 10003940 ##### MADE BY Client: c27
2021-06-25 10:30:23.362+0000 INFO ##### Order 10003950 ##### MADE BY Client: c9
2021-06-25 10:30:23.389+0000 INFO ##### Order 10003960 ##### MADE BY Client: c25
2021-06-25 10:30:23.417+0000 INFO ##### Order 10003970 ##### MADE BY Client: c16
2021-06-25 10:30:23.446+0000 INFO ##### Order 10003980 ##### MADE BY Client: c33
2021-06-25 10:30:23.473+0000 INFO ##### Order 10003990 ##### MADE BY Client: c21
2021-06-25 10:30:33.239+0000 INFO ##### Order 10007870 ##### MADE BY Client: c11
2021-06-25 10:30:33.265+0000 INFO ##### Order 10007880 ##### MADE BY Client: c74
2021-06-25 10:30:33.291+0000 INFO ##### Order 10007890 ##### MADE BY Client: c60
2021-06-25 10:30:33.317+0000 INFO ##### Order 10007900 ##### MADE BY Client: c72
2021-06-25 10:30:33.344+0000 INFO ##### Order 10007910 ##### MADE BY Client: c22
2021-06-25 10:30:33.370+0000 INFO ##### Order 10007920 ##### MADE BY Client: c81
2021-06-25 10:30:33.396+0000 INFO ##### Order 10007930 ##### MADE BY Client: c83
2021-06-25 10:30:33.422+0000 INFO ##### Order 10007940 ##### MADE BY Client: c27
2021-06-25 10:30:33.450+0000 INFO ##### Order 10007950 ##### MADE BY Client: c49
2021-06-25 10:30:33.478+0000 INFO ##### Order 10007960 ##### MADE BY Client: c45
2021-06-25 10:30:43.243+0000 INFO ##### Order 10011570 ##### MADE BY Client: c7
2021-06-25 10:30:43.270+0000 INFO ##### Order 10011580 ##### MADE BY Client: c5
2021-06-25 10:30:43.297+0000 INFO ##### Order 10011590 ##### MADE BY Client: c40
2021-06-25 10:30:43.324+0000 INFO ##### Order 10011600 ##### MADE BY Client: c44
2021-06-25 10:30:43.351+0000 INFO ##### Order 10011610 ##### MADE BY Client: c12
2021-06-25 10:30:43.378+0000 INFO ##### Order 10011620 ##### MADE BY Client: c18
2021-06-25 10:30:43.405+0000 INFO ##### Order 10011630 ##### MADE BY Client: c76
2021-06-25 10:30:43.432+0000 INFO ##### Order 10011640 ##### MADE BY Client: c76
2021-06-25 10:30:43.459+0000 INFO ##### Order 10011650 ##### MADE BY Client: c51
2021-06-25 10:30:43.486+0000 INFO ##### Order 10011660 ##### MADE BY Client: c5
2021-06-25 10:30:53.255+0000 INFO ##### Order 10015330 ##### MADE BY Client: c88
2021-06-25 10:30:53.282+0000 INFO ##### Order 10015340 ##### MADE BY Client: c91
2021-06-25 10:30:53.309+0000 INFO ##### Order 10015350 ##### MADE BY Client: c12
2021-06-25 10:30:53.335+0000 INFO ##### Order 10015360 ##### MADE BY Client: c56
2021-06-25 10:30:53.361+0000 INFO ##### Order 10015370 ##### MADE BY Client: c4
2021-06-25 10:30:53.387+0000 INFO ##### Order 10015380 ##### MADE BY Client: c98
2021-06-25 10:30:53.413+0000 INFO ##### Order 10015390 ##### MADE BY Client: c83
2021-06-25 10:30:53.439+0000 INFO ##### Order 10015400 ##### MADE BY Client: c81
2021-06-25 10:30:53.465+0000 INFO ##### Order 10015410 ##### MADE BY Client: c59
2021-06-25 10:30:53.491+0000 INFO ##### Order 10015420 ##### MADE BY Client: c51
2021-06-25 10:31:03.265+0000 INFO ##### Order 10019090 ##### MADE BY Client: c56
2021-06-25 10:31:03.292+0000 INFO ##### Order 10019100 ##### MADE BY Client: c88
2021-06-25 10:31:03.319+0000 INFO ##### Order 10019110 ##### MADE BY Client: c31
2021-06-25 10:31:03.346+0000 INFO ##### Order 10019120 ##### MADE BY Client: c61
2021-06-25 10:31:03.373+0000 INFO ##### Order 10019130 ##### MADE BY Client: c19
2021-06-25 10:31:03.399+0000 INFO ##### Order 10019140 ##### MADE BY Client: c6
2021-06-25 10:31:03.426+0000 INFO ##### Order 10019150 ##### MADE BY Client: c70
2021-06-25 10:31:03.452+0000 INFO ##### Order 10019160 ##### MADE BY Client: c38
2021-06-25 10:31:03.479+0000 INFO ##### Order 10019170 ##### MADE BY Client: c13
2021-06-25 10:31:03.506+0000 INFO ##### Order 10019180 ##### MADE BY Client: c63
2021-06-25 10:31:13.281+0000 INFO ##### Order 10022870 ##### MADE BY Client: c39
2021-06-25 10:31:13.308+0000 INFO ##### Order 10022880 ##### MADE BY Client: c39
2021-06-25 10:31:13.335+0000 INFO ##### Order 10022890 ##### MADE BY Client: c72
2021-06-25 10:31:13.362+0000 INFO ##### Order 10022900 ##### MADE BY Client: c11
2021-06-25 10:31:13.389+0000 INFO ##### Order 10022910 ##### MADE BY Client: c47
2021-06-25 10:31:13.416+0000 INFO ##### Order 10022920 ##### MADE BY Client: c39
2021-06-25 10:31:13.442+0000 INFO ##### Order 10022930 ##### MADE BY Client: c66
2021-06-25 10:31:13.468+0000 INFO ##### Order 10022940 ##### MADE BY Client: c78
2021-06-25 10:31:13.494+0000 INFO ##### Order 10022950 ##### MADE BY Client: c59
2021-06-25 10:31:13.521+0000 INFO ##### Order 10022960 ##### MADE BY Client: c15
2021-06-25 10:31:23.296+0000 INFO ##### Order 10026660 ##### MADE BY Client: c35
2021-06-25 10:31:23.322+0000 INFO ##### Order 10026670 ##### MADE BY Client: c22
2021-06-25 10:31:23.349+0000 INFO ##### Order 10026680 ##### MADE BY Client: c73
2021-06-25 10:31:23.375+0000 INFO ##### Order 10026690 ##### MADE BY Client: c66
2021-06-25 10:31:23.401+0000 INFO ##### Order 10026700 ##### MADE BY Client: c5
2021-06-25 10:31:23.429+0000 INFO ##### Order 10026710 ##### MADE BY Client: c54
2021-06-25 10:31:23.455+0000 INFO ##### Order 10026720 ##### MADE BY Client: c75
2021-06-25 10:31:23.482+0000 INFO ##### Order 10026730 ##### MADE BY Client: c40
2021-06-25 10:31:23.508+0000 INFO ##### Order 10026740 ##### MADE BY Client: c2
2021-06-25 10:31:23.535+0000 INFO ##### Order 10026750 ##### MADE BY Client: c5
2021-06-25 10:31:33.300+0000 INFO ##### Order 10030420 ##### MADE BY Client: c56
2021-06-25 10:31:33.327+0000 INFO ##### Order 10030430 ##### MADE BY Client: c48
2021-06-25 10:31:33.353+0000 INFO ##### Order 10030440 ##### MADE BY Client: c88
2021-06-25 10:31:33.380+0000 INFO ##### Order 10030450 ##### MADE BY Client: c29
2021-06-25 10:31:33.406+0000 INFO ##### Order 10030460 ##### MADE BY Client: c54
2021-06-25 10:31:33.433+0000 INFO ##### Order 10030470 ##### MADE BY Client: c3
2021-06-25 10:31:33.460+0000 INFO ##### Order 10030480 ##### MADE BY Client: c30
2021-06-25 10:31:33.487+0000 INFO ##### Order 10030490 ##### MADE BY Client: c48
2021-06-25 10:31:33.514+0000 INFO ##### Order 10030500 ##### MADE BY Client: c66
2021-06-25 10:31:33.541+0000 INFO ##### Order 10030510 ##### MADE BY Client: c21
2021-06-25 10:31:43.323+0000 INFO ##### Order 10034210 ##### MADE BY Client: c35
2021-06-25 10:31:43.350+0000 INFO ##### Order 10034220 ##### MADE BY Client: c89
2021-06-25 10:31:43.375+0000 INFO ##### Order 10034230 ##### MADE BY Client: c67
2021-06-25 10:31:43.401+0000 INFO ##### Order 10034240 ##### MADE BY Client: c20
2021-06-25 10:31:43.428+0000 INFO ##### Order 10034250 ##### MADE BY Client: c4
2021-06-25 10:31:43.454+0000 INFO ##### Order 10034260 ##### MADE BY Client: c86
2021-06-25 10:31:43.480+0000 INFO ##### Order 10034270 ##### MADE BY Client: c43
2021-06-25 10:31:43.506+0000 INFO ##### Order 10034280 ##### MADE BY Client: c72
2021-06-25 10:31:43.533+0000 INFO ##### Order 10034290 ##### MADE BY Client: c96
2021-06-25 10:31:43.559+0000 INFO ##### Order 10034300 ##### MADE BY Client: c70
2021-06-25 10:31:53.325+0000 INFO ##### Order 10037970 ##### MADE BY Client: c74
2021-06-25 10:31:53.352+0000 INFO ##### Order 10037980 ##### MADE BY Client: c93
2021-06-25 10:31:53.379+0000 INFO ##### Order 10037990 ##### MADE BY Client: c39
2021-06-25 10:31:53.406+0000 INFO ##### Order 10038000 ##### MADE BY Client: c9
2021-06-25 10:31:53.433+0000 INFO ##### Order 10038010 ##### MADE BY Client: c33
2021-06-25 10:31:53.460+0000 INFO ##### Order 10038020 ##### MADE BY Client: c80
2021-06-25 10:31:53.487+0000 INFO ##### Order 10038030 ##### MADE BY Client: c41
2021-06-25 10:31:53.513+0000 INFO ##### Order 10038040 ##### MADE BY Client: c17
2021-06-25 10:31:53.539+0000 INFO ##### Order 10038050 ##### MADE BY Client: c36
2021-06-25 10:31:53.566+0000 INFO ##### Order 10038060 ##### MADE BY Client: c18
2021-06-25 10:32:03.336+0000 INFO ##### Order 10041760 ##### MADE BY Client: c79
2021-06-25 10:32:03.363+0000 INFO ##### Order 10041770 ##### MADE BY Client: c80
2021-06-25 10:32:03.390+0000 INFO ##### Order 10041780 ##### MADE BY Client: c90
2021-06-25 10:32:03.416+0000 INFO ##### Order 10041790 ##### MADE BY Client: c4
2021-06-25 10:32:03.443+0000 INFO ##### Order 10041800 ##### MADE BY Client: c61
2021-06-25 10:32:03.470+0000 INFO ##### Order 10041810 ##### MADE BY Client: c14
2021-06-25 10:32:03.497+0000 INFO ##### Order 10041820 ##### MADE BY Client: c36
2021-06-25 10:32:03.525+0000 INFO ##### Order 10041830 ##### MADE BY Client: c91
2021-06-25 10:32:03.550+0000 INFO ##### Order 10041840 ##### MADE BY Client: c93
2021-06-25 10:32:03.576+0000 INFO ##### Order 10041850 ##### MADE BY Client: c74
2021-06-25 10:32:13.343+0000 INFO ##### Order 10045550 ##### MADE BY Client: c19
2021-06-25 10:32:13.370+0000 INFO ##### Order 10045560 ##### MADE BY Client: c72
2021-06-25 10:32:13.397+0000 INFO ##### Order 10045570 ##### MADE BY Client: c47
2021-06-25 10:32:13.424+0000 INFO ##### Order 10045580 ##### MADE BY Client: c55
2021-06-25 10:32:13.450+0000 INFO ##### Order 10045590 ##### MADE BY Client: c8
2021-06-25 10:32:13.477+0000 INFO ##### Order 10045600 ##### MADE BY Client: c16
2021-06-25 10:32:13.504+0000 INFO ##### Order 10045610 ##### MADE BY Client: c51
2021-06-25 10:32:13.531+0000 INFO ##### Order 10045620 ##### MADE BY Client: c14
2021-06-25 10:32:13.558+0000 INFO ##### Order 10045630 ##### MADE BY Client: c76
2021-06-25 10:32:13.584+0000 INFO ##### Order 10045640 ##### MADE BY Client: c25
2021-06-25 10:32:23.368+0000 INFO ##### Order 10049370 ##### MADE BY Client: c29
2021-06-25 10:32:23.395+0000 INFO ##### Order 10049380 ##### MADE BY Client: c6
2021-06-25 10:32:23.422+0000 INFO ##### Order 10049390 ##### MADE BY Client: c78
2021-06-25 10:32:23.448+0000 INFO ##### Order 10049400 ##### MADE BY Client: c26
2021-06-25 10:32:23.475+0000 INFO ##### Order 10049410 ##### MADE BY Client: c98
2021-06-25 10:32:23.502+0000 INFO ##### Order 10049420 ##### MADE BY Client: c42
2021-06-25 10:32:23.529+0000 INFO ##### Order 10049430 ##### MADE BY Client: c13
2021-06-25 10:32:23.556+0000 INFO ##### Order 10049440 ##### MADE BY Client: c100
2021-06-25 10:32:23.582+0000 INFO ##### Order 10049450 ##### MADE BY Client: c35
2021-06-25 10:32:23.609+0000 INFO ##### Order 10049460 ##### MADE BY Client: c2
2021-06-25 10:32:33.390+0000 INFO ##### Order 10053180 ##### MADE BY Client: c8
2021-06-25 10:32:33.417+0000 INFO ##### Order 10053190 ##### MADE BY Client: c46
2021-06-25 10:32:33.444+0000 INFO ##### Order 10053200 ##### MADE BY Client: c95
2021-06-25 10:32:33.469+0000 INFO ##### Order 10053210 ##### MADE BY Client: c40
2021-06-25 10:32:33.495+0000 INFO ##### Order 10053220 ##### MADE BY Client: c27
2021-06-25 10:32:33.522+0000 INFO ##### Order 10053230 ##### MADE BY Client: c72
2021-06-25 10:32:33.548+0000 INFO ##### Order 10053240 ##### MADE BY Client: c10
2021-06-25 10:32:33.574+0000 INFO ##### Order 10053250 ##### MADE BY Client: c7
2021-06-25 10:32:33.600+0000 INFO ##### Order 10053260 ##### MADE BY Client: c23
2021-06-25 10:32:33.627+0000 INFO ##### Order 10053270 ##### MADE BY Client: c46
2021-06-25 10:32:43.407+0000 INFO ##### Order 10057020 ##### MADE BY Client: c34
2021-06-25 10:32:43.434+0000 INFO ##### Order 10057030 ##### MADE BY Client: c88
2021-06-25 10:32:43.460+0000 INFO ##### Order 10057040 ##### MADE BY Client: c63
2021-06-25 10:32:43.487+0000 INFO ##### Order 10057050 ##### MADE BY Client: c54
2021-06-25 10:32:43.513+0000 INFO ##### Order 10057060 ##### MADE BY Client: c76
2021-06-25 10:32:43.539+0000 INFO ##### Order 10057070 ##### MADE BY Client: c5
2021-06-25 10:32:43.565+0000 INFO ##### Order 10057080 ##### MADE BY Client: c37
2021-06-25 10:32:43.591+0000 INFO ##### Order 10057090 ##### MADE BY Client: c49
2021-06-25 10:32:43.617+0000 INFO ##### Order 10057100 ##### MADE BY Client: c35
2021-06-25 10:32:43.643+0000 INFO ##### Order 10057110 ##### MADE BY Client: c68
2021-06-25 10:32:53.413+0000 INFO ##### Order 10060860 ##### MADE BY Client: c35
2021-06-25 10:32:53.439+0000 INFO ##### Order 10060870 ##### MADE BY Client: c28
2021-06-25 10:32:53.465+0000 INFO ##### Order 10060880 ##### MADE BY Client: c43
2021-06-25 10:32:53.491+0000 INFO ##### Order 10060890 ##### MADE BY Client: c61
2021-06-25 10:32:53.516+0000 INFO ##### Order 10060900 ##### MADE BY Client: c35
2021-06-25 10:32:53.543+0000 INFO ##### Order 10060910 ##### MADE BY Client: c87
2021-06-25 10:32:53.569+0000 INFO ##### Order 10060920 ##### MADE BY Client: c72
2021-06-25 10:32:53.595+0000 INFO ##### Order 10060930 ##### MADE BY Client: c66
2021-06-25 10:32:53.622+0000 INFO ##### Order 10060940 ##### MADE BY Client: c69
2021-06-25 10:32:53.648+0000 INFO ##### Order 10060950 ##### MADE BY Client: c59
2021-06-25 10:33:03.432+0000 INFO ##### Order 10064700 ##### MADE BY Client: c37
2021-06-25 10:33:03.459+0000 INFO ##### Order 10064710 ##### MADE BY Client: c70
2021-06-25 10:33:03.484+0000 INFO ##### Order 10064720 ##### MADE BY Client: c6
2021-06-25 10:33:03.510+0000 INFO ##### Order 10064730 ##### MADE BY Client: c94
2021-06-25 10:33:03.536+0000 INFO ##### Order 10064740 ##### MADE BY Client: c93
2021-06-25 10:33:03.562+0000 INFO ##### Order 10064750 ##### MADE BY Client: c33
2021-06-25 10:33:03.588+0000 INFO ##### Order 10064760 ##### MADE BY Client: c56
2021-06-25 10:33:03.614+0000 INFO ##### Order 10064770 ##### MADE BY Client: c99
2021-06-25 10:33:03.640+0000 INFO ##### Order 10064780 ##### MADE BY Client: c77
2021-06-25 10:33:03.667+0000 INFO ##### Order 10064790 ##### MADE BY Client: c78
2021-06-25 10:33:13.454+0000 INFO ##### Order 10068530 ##### MADE BY Client: c55
2021-06-25 10:33:13.480+0000 INFO ##### Order 10068540 ##### MADE BY Client: c58
2021-06-25 10:33:13.506+0000 INFO ##### Order 10068550 ##### MADE BY Client: c72
2021-06-25 10:33:13.531+0000 INFO ##### Order 10068560 ##### MADE BY Client: c85
2021-06-25 10:33:13.557+0000 INFO ##### Order 10068570 ##### MADE BY Client: c3
2021-06-25 10:33:13.582+0000 INFO ##### Order 10068580 ##### MADE BY Client: c99
2021-06-25 10:33:13.608+0000 INFO ##### Order 10068590 ##### MADE BY Client: c5
2021-06-25 10:33:13.634+0000 INFO ##### Order 10068600 ##### MADE BY Client: c26
2021-06-25 10:33:13.660+0000 INFO ##### Order 10068610 ##### MADE BY Client: c4
2021-06-25 10:33:13.686+0000 INFO ##### Order 10068620 ##### MADE BY Client: c95
2021-06-25 10:33:23.470+0000 INFO ##### Order 10072370 ##### MADE BY Client: c63
2021-06-25 10:33:23.497+0000 INFO ##### Order 10072380 ##### MADE BY Client: c53
2021-06-25 10:33:23.523+0000 INFO ##### Order 10072390 ##### MADE BY Client: c97
2021-06-25 10:33:23.550+0000 INFO ##### Order 10072400 ##### MADE BY Client: c43
2021-06-25 10:33:23.576+0000 INFO ##### Order 10072410 ##### MADE BY Client: c12
2021-06-25 10:33:23.602+0000 INFO ##### Order 10072420 ##### MADE BY Client: c79
2021-06-25 10:33:23.630+0000 INFO ##### Order 10072430 ##### MADE BY Client: c44
2021-06-25 10:33:23.657+0000 INFO ##### Order 10072440 ##### MADE BY Client: c31
2021-06-25 10:33:23.682+0000 INFO ##### Order 10072450 ##### MADE BY Client: c61
2021-06-25 10:33:23.708+0000 INFO ##### Order 10072460 ##### MADE BY Client: c42
2021-06-25 10:33:33.476+0000 INFO ##### Order 10076150 ##### MADE BY Client: c48
2021-06-25 10:33:33.503+0000 INFO ##### Order 10076160 ##### MADE BY Client: c56
2021-06-25 10:33:33.528+0000 INFO ##### Order 10076170 ##### MADE BY Client: c64
2021-06-25 10:33:33.553+0000 INFO ##### Order 10076180 ##### MADE BY Client: c69
2021-06-25 10:33:33.579+0000 INFO ##### Order 10076190 ##### MADE BY Client: c51
2021-06-25 10:33:33.606+0000 INFO ##### Order 10076200 ##### MADE BY Client: c52
2021-06-25 10:33:33.631+0000 INFO ##### Order 10076210 ##### MADE BY Client: c46
2021-06-25 10:33:33.656+0000 INFO ##### Order 10076220 ##### MADE BY Client: c44
2021-06-25 10:33:33.682+0000 INFO ##### Order 10076230 ##### MADE BY Client: c92
2021-06-25 10:33:33.708+0000 INFO ##### Order 10076240 ##### MADE BY Client: c58
2021-06-25 10:33:43.495+0000 INFO ##### Order 10079940 ##### MADE BY Client: c53
2021-06-25 10:33:43.521+0000 INFO ##### Order 10079950 ##### MADE BY Client: c1
2021-06-25 10:33:43.547+0000 INFO ##### Order 10079960 ##### MADE BY Client: c20
2021-06-25 10:33:43.572+0000 INFO ##### Order 10079970 ##### MADE BY Client: c21
2021-06-25 10:33:43.598+0000 INFO ##### Order 10079980 ##### MADE BY Client: c100
2021-06-25 10:33:43.623+0000 INFO ##### Order 10079990 ##### MADE BY Client: c81
2021-06-25 10:33:43.649+0000 INFO ##### Order 10080000 ##### MADE BY Client: c22
2021-06-25 10:33:43.674+0000 INFO ##### Order 10080010 ##### MADE BY Client: c87
2021-06-25 10:33:43.723+0000 INFO ##### Order 10080020 ##### MADE BY Client: c20
2021-06-25 10:33:43.749+0000 INFO ##### Order 10080030 ##### MADE BY Client: c43
2021-06-25 10:33:53.496+0000 INFO ##### Order 10083660 ##### MADE BY Client: c79
2021-06-25 10:33:53.522+0000 INFO ##### Order 10083670 ##### MADE BY Client: c88
2021-06-25 10:33:53.547+0000 INFO ##### Order 10083680 ##### MADE BY Client: c27
2021-06-25 10:33:53.574+0000 INFO ##### Order 10083690 ##### MADE BY Client: c64
2021-06-25 10:33:53.599+0000 INFO ##### Order 10083700 ##### MADE BY Client: c86
2021-06-25 10:33:53.625+0000 INFO ##### Order 10083710 ##### MADE BY Client: c73
2021-06-25 10:33:53.650+0000 INFO ##### Order 10083720 ##### MADE BY Client: c47
2021-06-25 10:33:53.676+0000 INFO ##### Order 10083730 ##### MADE BY Client: c14
2021-06-25 10:33:53.701+0000 INFO ##### Order 10083740 ##### MADE BY Client: c86
2021-06-25 10:33:53.727+0000 INFO ##### Order 10083750 ##### MADE BY Client: c90
2021-06-25 10:34:03.504+0000 INFO ##### Order 10087510 ##### MADE BY Client: c66
2021-06-25 10:34:03.537+0000 INFO ##### Order 10087520 ##### MADE BY Client: c54
2021-06-25 10:34:03.562+0000 INFO ##### Order 10087530 ##### MADE BY Client: c24
2021-06-25 10:34:03.589+0000 INFO ##### Order 10087540 ##### MADE BY Client: c65
2021-06-25 10:34:03.615+0000 INFO ##### Order 10087550 ##### MADE BY Client: c9
2021-06-25 10:34:03.642+0000 INFO ##### Order 10087560 ##### MADE BY Client: c18
2021-06-25 10:34:03.667+0000 INFO ##### Order 10087570 ##### MADE BY Client: c98
2021-06-25 10:34:03.693+0000 INFO ##### Order 10087580 ##### MADE BY Client: c97
2021-06-25 10:34:03.719+0000 INFO ##### Order 10087590 ##### MADE BY Client: c88
2021-06-25 10:34:03.746+0000 INFO ##### Order 10087600 ##### MADE BY Client: c13
2021-06-25 10:34:13.528+0000 INFO ##### Order 10091350 ##### MADE BY Client: c5
2021-06-25 10:34:13.554+0000 INFO ##### Order 10091360 ##### MADE BY Client: c100
2021-06-25 10:34:13.580+0000 INFO ##### Order 10091370 ##### MADE BY Client: c9
2021-06-25 10:34:13.605+0000 INFO ##### Order 10091380 ##### MADE BY Client: c42
2021-06-25 10:34:13.631+0000 INFO ##### Order 10091390 ##### MADE BY Client: c7
2021-06-25 10:34:13.658+0000 INFO ##### Order 10091400 ##### MADE BY Client: c83
2021-06-25 10:34:13.684+0000 INFO ##### Order 10091410 ##### MADE BY Client: c14
2021-06-25 10:34:13.710+0000 INFO ##### Order 10091420 ##### MADE BY Client: c3
2021-06-25 10:34:13.736+0000 INFO ##### Order 10091430 ##### MADE BY Client: c29
2021-06-25 10:34:13.762+0000 INFO ##### Order 10091440 ##### MADE BY Client: c43
2021-06-25 10:34:23.548+0000 INFO ##### Order 10095170 ##### MADE BY Client: c20
2021-06-25 10:34:23.574+0000 INFO ##### Order 10095180 ##### MADE BY Client: c19
2021-06-25 10:34:23.599+0000 INFO ##### Order 10095190 ##### MADE BY Client: c21
2021-06-25 10:34:23.625+0000 INFO ##### Order 10095200 ##### MADE BY Client: c72
2021-06-25 10:34:23.651+0000 INFO ##### Order 10095210 ##### MADE BY Client: c99
2021-06-25 10:34:23.676+0000 INFO ##### Order 10095220 ##### MADE BY Client: c1
2021-06-25 10:34:23.702+0000 INFO ##### Order 10095230 ##### MADE BY Client: c40
2021-06-25 10:34:23.728+0000 INFO ##### Order 10095240 ##### MADE BY Client: c40
2021-06-25 10:34:23.755+0000 INFO ##### Order 10095250 ##### MADE BY Client: c26
2021-06-25 10:34:23.781+0000 INFO ##### Order 10095260 ##### MADE BY Client: c36
2021-06-25 10:34:33.552+0000 INFO ##### Order 10099000 ##### MADE BY Client: c81
2021-06-25 10:34:33.579+0000 INFO ##### Order 10099010 ##### MADE BY Client: c89
2021-06-25 10:34:33.603+0000 INFO ##### Order 10099020 ##### MADE BY Client: c71
2021-06-25 10:34:33.628+0000 INFO ##### Order 10099030 ##### MADE BY Client: c89
2021-06-25 10:34:33.654+0000 INFO ##### Order 10099040 ##### MADE BY Client: c98
2021-06-25 10:34:33.679+0000 INFO ##### Order 10099050 ##### MADE BY Client: c42
2021-06-25 10:34:33.703+0000 INFO ##### Order 10099060 ##### MADE BY Client: c75
2021-06-25 10:34:33.729+0000 INFO ##### Order 10099070 ##### MADE BY Client: c55
2021-06-25 10:34:33.755+0000 INFO ##### Order 10099080 ##### MADE BY Client: c17
2021-06-25 10:34:33.782+0000 INFO ##### Order 10099090 ##### MADE BY Client: c49
2021-06-25 10:34:43.564+0000 INFO ##### Order 20000660 ##### MADE BY Client: c20
2021-06-25 10:34:43.590+0000 INFO ##### Order 20000670 ##### MADE BY Client: c15
2021-06-25 10:34:43.616+0000 INFO ##### Order 20000680 ##### MADE BY Client: c28
2021-06-25 10:34:43.642+0000 INFO ##### Order 20000690 ##### MADE BY Client: c95
2021-06-25 10:34:43.668+0000 INFO ##### Order 20000700 ##### MADE BY Client: c18
2021-06-25 10:34:43.694+0000 INFO ##### Order 20000710 ##### MADE BY Client: c90
2021-06-25 10:34:43.720+0000 INFO ##### Order 20000720 ##### MADE BY Client: c9
2021-06-25 10:34:43.745+0000 INFO ##### Order 20000730 ##### MADE BY Client: c23
2021-06-25 10:34:43.771+0000 INFO ##### Order 20000740 ##### MADE BY Client: c53
2021-06-25 10:34:43.797+0000 INFO ##### Order 20000750 ##### MADE BY Client: c48
2021-06-25 10:34:53.584+0000 INFO ##### Order 20004520 ##### MADE BY Client: c7
2021-06-25 10:34:53.610+0000 INFO ##### Order 20004530 ##### MADE BY Client: c69
2021-06-25 10:34:53.635+0000 INFO ##### Order 20004540 ##### MADE BY Client: c51
2021-06-25 10:34:53.661+0000 INFO ##### Order 20004550 ##### MADE BY Client: c24
2021-06-25 10:34:53.686+0000 INFO ##### Order 20004560 ##### MADE BY Client: c98
2021-06-25 10:34:53.712+0000 INFO ##### Order 20004570 ##### MADE BY Client: c34
2021-06-25 10:34:53.738+0000 INFO ##### Order 20004580 ##### MADE BY Client: c26
2021-06-25 10:34:53.764+0000 INFO ##### Order 20004590 ##### MADE BY Client: c73
2021-06-25 10:34:53.791+0000 INFO ##### Order 20004600 ##### MADE BY Client: c87
2021-06-25 10:34:53.817+0000 INFO ##### Order 20004610 ##### MADE BY Client: c3
2021-06-25 10:35:03.602+0000 INFO ##### Order 20008330 ##### MADE BY Client: c13
2021-06-25 10:35:03.629+0000 INFO ##### Order 20008340 ##### MADE BY Client: c87
2021-06-25 10:35:03.654+0000 INFO ##### Order 20008350 ##### MADE BY Client: c87
2021-06-25 10:35:03.680+0000 INFO ##### Order 20008360 ##### MADE BY Client: c54
2021-06-25 10:35:03.705+0000 INFO ##### Order 20008370 ##### MADE BY Client: c40
2021-06-25 10:35:03.730+0000 INFO ##### Order 20008380 ##### MADE BY Client: c46
2021-06-25 10:35:03.756+0000 INFO ##### Order 20008390 ##### MADE BY Client: c76
2021-06-25 10:35:03.782+0000 INFO ##### Order 20008400 ##### MADE BY Client: c48
2021-06-25 10:35:03.808+0000 INFO ##### Order 20008410 ##### MADE BY Client: c31
2021-06-25 10:35:03.833+0000 INFO ##### Order 20008420 ##### MADE BY Client: c45
2021-06-25 10:35:13.626+0000 INFO ##### Order 20012160 ##### MADE BY Client: c63
2021-06-25 10:35:13.652+0000 INFO ##### Order 20012170 ##### MADE BY Client: c83
2021-06-25 10:35:13.677+0000 INFO ##### Order 20012180 ##### MADE BY Client: c5
2021-06-25 10:35:13.702+0000 INFO ##### Order 20012190 ##### MADE BY Client: c81
2021-06-25 10:35:13.727+0000 INFO ##### Order 20012200 ##### MADE BY Client: c85
2021-06-25 10:35:13.752+0000 INFO ##### Order 20012210 ##### MADE BY Client: c18
2021-06-25 10:35:13.777+0000 INFO ##### Order 20012220 ##### MADE BY Client: c25
2021-06-25 10:35:13.802+0000 INFO ##### Order 20012230 ##### MADE BY Client: c51
2021-06-25 10:35:13.828+0000 INFO ##### Order 20012240 ##### MADE BY Client: c64
2021-06-25 10:35:13.853+0000 INFO ##### Order 20012250 ##### MADE BY Client: c74
2021-06-25 10:35:23.641+0000 INFO ##### Order 20016010 ##### MADE BY Client: c60
2021-06-25 10:35:23.667+0000 INFO ##### Order 20016020 ##### MADE BY Client: c71
2021-06-25 10:35:23.692+0000 INFO ##### Order 20016030 ##### MADE BY Client: c22
2021-06-25 10:35:23.718+0000 INFO ##### Order 20016040 ##### MADE BY Client: c58
2021-06-25 10:35:23.743+0000 INFO ##### Order 20016050 ##### MADE BY Client: c27
2021-06-25 10:35:23.770+0000 INFO ##### Order 20016060 ##### MADE BY Client: c17
2021-06-25 10:35:23.796+0000 INFO ##### Order 20016070 ##### MADE BY Client: c11
2021-06-25 10:35:23.822+0000 INFO ##### Order 20016080 ##### MADE BY Client: c27
2021-06-25 10:35:23.848+0000 INFO ##### Order 20016090 ##### MADE BY Client: c21
2021-06-25 10:35:23.875+0000 INFO ##### Order 20016100 ##### MADE BY Client: c92
2021-06-25 10:35:33.663+0000 INFO ##### Order 20019760 ##### MADE BY Client: c16
2021-06-25 10:35:33.713+0000 INFO ##### Order 20019770 ##### MADE BY Client: c9
2021-06-25 10:35:33.741+0000 INFO ##### Order 20019780 ##### MADE BY Client: c9
2021-06-25 10:35:33.767+0000 INFO ##### Order 20019790 ##### MADE BY Client: c73
2021-06-25 10:35:33.793+0000 INFO ##### Order 20019800 ##### MADE BY Client: c98
2021-06-25 10:35:33.819+0000 INFO ##### Order 20019810 ##### MADE BY Client: c8
2021-06-25 10:35:33.845+0000 INFO ##### Order 20019820 ##### MADE BY Client: c6
2021-06-25 10:35:33.871+0000 INFO ##### Order 20019830 ##### MADE BY Client: c67
2021-06-25 10:35:33.897+0000 INFO ##### Order 20019840 ##### MADE BY Client: c21
2021-06-25 10:35:33.923+0000 INFO ##### Order 20019850 ##### MADE BY Client: c64
2021-06-25 10:35:43.673+0000 INFO ##### Order 20023610 ##### MADE BY Client: c89
2021-06-25 10:35:43.698+0000 INFO ##### Order 20023620 ##### MADE BY Client: c96
2021-06-25 10:35:43.723+0000 INFO ##### Order 20023630 ##### MADE BY Client: c20
2021-06-25 10:35:43.748+0000 INFO ##### Order 20023640 ##### MADE BY Client: c96
2021-06-25 10:35:43.774+0000 INFO ##### Order 20023650 ##### MADE BY Client: c9
2021-06-25 10:35:43.800+0000 INFO ##### Order 20023660 ##### MADE BY Client: c16
2021-06-25 10:35:43.826+0000 INFO ##### Order 20023670 ##### MADE BY Client: c77
2021-06-25 10:35:43.852+0000 INFO ##### Order 20023680 ##### MADE BY Client: c82
2021-06-25 10:35:43.878+0000 INFO ##### Order 20023690 ##### MADE BY Client: c19
2021-06-25 10:35:43.904+0000 INFO ##### Order 20023700 ##### MADE BY Client: c6
2021-06-25 10:35:53.695+0000 INFO ##### Order 20027420 ##### MADE BY Client: c70
2021-06-25 10:35:53.720+0000 INFO ##### Order 20027430 ##### MADE BY Client: c9
2021-06-25 10:35:53.746+0000 INFO ##### Order 20027440 ##### MADE BY Client: c28
2021-06-25 10:35:53.772+0000 INFO ##### Order 20027450 ##### MADE BY Client: c57
2021-06-25 10:35:53.797+0000 INFO ##### Order 20027460 ##### MADE BY Client: c99
2021-06-25 10:35:53.823+0000 INFO ##### Order 20027470 ##### MADE BY Client: c4
2021-06-25 10:35:53.848+0000 INFO ##### Order 20027480 ##### MADE BY Client: c65
2021-06-25 10:35:53.873+0000 INFO ##### Order 20027490 ##### MADE BY Client: c1
2021-06-25 10:35:53.899+0000 INFO ##### Order 20027500 ##### MADE BY Client: c24
2021-06-25 10:35:53.925+0000 INFO ##### Order 20027510 ##### MADE BY Client: c98
2021-06-25 10:36:03.714+0000 INFO ##### Order 20031270 ##### MADE BY Client: c41
2021-06-25 10:36:03.740+0000 INFO ##### Order 20031280 ##### MADE BY Client: c51
2021-06-25 10:36:03.766+0000 INFO ##### Order 20031290 ##### MADE BY Client: c46
2021-06-25 10:36:03.791+0000 INFO ##### Order 20031300 ##### MADE BY Client: c9
2021-06-25 10:36:03.817+0000 INFO ##### Order 20031310 ##### MADE BY Client: c95
2021-06-25 10:36:03.843+0000 INFO ##### Order 20031320 ##### MADE BY Client: c64
2021-06-25 10:36:03.869+0000 INFO ##### Order 20031330 ##### MADE BY Client: c25
2021-06-25 10:36:03.894+0000 INFO ##### Order 20031340 ##### MADE BY Client: c78
2021-06-25 10:36:03.921+0000 INFO ##### Order 20031350 ##### MADE BY Client: c8
2021-06-25 10:36:03.952+0000 INFO ##### Order 20031360 ##### MADE BY Client: c22
2021-06-25 10:36:13.726+0000 INFO ##### Order 20035110 ##### MADE BY Client: c70
2021-06-25 10:36:13.752+0000 INFO ##### Order 20035120 ##### MADE BY Client: c84
2021-06-25 10:36:13.779+0000 INFO ##### Order 20035130 ##### MADE BY Client: c100
2021-06-25 10:36:13.804+0000 INFO ##### Order 20035140 ##### MADE BY Client: c67
2021-06-25 10:36:13.830+0000 INFO ##### Order 20035150 ##### MADE BY Client: c67
2021-06-25 10:36:13.855+0000 INFO ##### Order 20035160 ##### MADE BY Client: c46
2021-06-25 10:36:13.881+0000 INFO ##### Order 20035170 ##### MADE BY Client: c19
2021-06-25 10:36:13.907+0000 INFO ##### Order 20035180 ##### MADE BY Client: c39
2021-06-25 10:36:13.933+0000 INFO ##### Order 20035190 ##### MADE BY Client: c13
2021-06-25 10:36:13.958+0000 INFO ##### Order 20035200 ##### MADE BY Client: c74
2021-06-25 10:36:23.733+0000 INFO ##### Order 20038940 ##### MADE BY Client: c3
2021-06-25 10:36:23.759+0000 INFO ##### Order 20038950 ##### MADE BY Client: c92
2021-06-25 10:36:23.790+0000 INFO ##### Order 20038960 ##### MADE BY Client: c93
2021-06-25 10:36:23.815+0000 INFO ##### Order 20038970 ##### MADE BY Client: c17
2021-06-25 10:36:23.841+0000 INFO ##### Order 20038980 ##### MADE BY Client: c15
2021-06-25 10:36:23.867+0000 INFO ##### Order 20038990 ##### MADE BY Client: c62
2021-06-25 10:36:23.893+0000 INFO ##### Order 20039000 ##### MADE BY Client: c30
2021-06-25 10:36:23.918+0000 INFO ##### Order 20039010 ##### MADE BY Client: c15
2021-06-25 10:36:23.944+0000 INFO ##### Order 20039020 ##### MADE BY Client: c28
2021-06-25 10:36:23.969+0000 INFO ##### Order 20039030 ##### MADE BY Client: c64
2021-06-25 10:36:33.740+0000 INFO ##### Order 20042720 ##### MADE BY Client: c62
2021-06-25 10:36:33.766+0000 INFO ##### Order 20042730 ##### MADE BY Client: c78
2021-06-25 10:36:33.792+0000 INFO ##### Order 20042740 ##### MADE BY Client: c28
2021-06-25 10:36:33.817+0000 INFO ##### Order 20042750 ##### MADE BY Client: c72
2021-06-25 10:36:33.843+0000 INFO ##### Order 20042760 ##### MADE BY Client: c91
2021-06-25 10:36:33.869+0000 INFO ##### Order 20042770 ##### MADE BY Client: c99
2021-06-25 10:36:33.895+0000 INFO ##### Order 20042780 ##### MADE BY Client: c36
2021-06-25 10:36:33.920+0000 INFO ##### Order 20042790 ##### MADE BY Client: c7
2021-06-25 10:36:33.946+0000 INFO ##### Order 20042800 ##### MADE BY Client: c71
2021-06-25 10:36:33.972+0000 INFO ##### Order 20042810 ##### MADE BY Client: c76
2021-06-25 10:36:43.761+0000 INFO ##### Order 20046540 ##### MADE BY Client: c4
2021-06-25 10:36:43.787+0000 INFO ##### Order 20046550 ##### MADE BY Client: c13
2021-06-25 10:36:43.813+0000 INFO ##### Order 20046560 ##### MADE BY Client: c36
2021-06-25 10:36:43.839+0000 INFO ##### Order 20046570 ##### MADE BY Client: c39
2021-06-25 10:36:43.864+0000 INFO ##### Order 20046580 ##### MADE BY Client: c58
2021-06-25 10:36:43.890+0000 INFO ##### Order 20046590 ##### MADE BY Client: c68
2021-06-25 10:36:43.916+0000 INFO ##### Order 20046600 ##### MADE BY Client: c36
2021-06-25 10:36:43.942+0000 INFO ##### Order 20046610 ##### MADE BY Client: c67
2021-06-25 10:36:43.967+0000 INFO ##### Order 20046620 ##### MADE BY Client: c76
2021-06-25 10:36:43.993+0000 INFO ##### Order 20046630 ##### MADE BY Client: c84
2021-06-25 10:36:53.765+0000 INFO ##### Order 20050400 ##### MADE BY Client: c35
2021-06-25 10:36:53.791+0000 INFO ##### Order 20050410 ##### MADE BY Client: c41
2021-06-25 10:36:53.817+0000 INFO ##### Order 20050420 ##### MADE BY Client: c67
2021-06-25 10:36:53.842+0000 INFO ##### Order 20050430 ##### MADE BY Client: c23
2021-06-25 10:36:53.868+0000 INFO ##### Order 20050440 ##### MADE BY Client: c58
2021-06-25 10:36:53.893+0000 INFO ##### Order 20050450 ##### MADE BY Client: c71
2021-06-25 10:36:53.918+0000 INFO ##### Order 20050460 ##### MADE BY Client: c39
2021-06-25 10:36:53.944+0000 INFO ##### Order 20050470 ##### MADE BY Client: c32
2021-06-25 10:36:53.970+0000 INFO ##### Order 20050480 ##### MADE BY Client: c25
2021-06-25 10:36:53.996+0000 INFO ##### Order 20050490 ##### MADE BY Client: c26
2021-06-25 10:37:03.785+0000 INFO ##### Order 20054010 ##### MADE BY Client: c89
2021-06-25 10:37:03.811+0000 INFO ##### Order 20054020 ##### MADE BY Client: c6
2021-06-25 10:37:03.853+0000 INFO ##### Order 20054030 ##### MADE BY Client: c1
2021-06-25 10:37:03.879+0000 INFO ##### Order 20054040 ##### MADE BY Client: c21
2021-06-25 10:37:03.904+0000 INFO ##### Order 20054050 ##### MADE BY Client: c40
2021-06-25 10:37:03.930+0000 INFO ##### Order 20054060 ##### MADE BY Client: c16
2021-06-25 10:37:03.959+0000 INFO ##### Order 20054070 ##### MADE BY Client: c14
2021-06-25 10:37:03.984+0000 INFO ##### Order 20054080 ##### MADE BY Client: c35
2021-06-25 10:37:04.009+0000 INFO ##### Order 20054090 ##### MADE BY Client: c13
2021-06-25 10:37:04.035+0000 INFO ##### Order 20054100 ##### MADE BY Client: c16
2021-06-25 10:37:13.796+0000 INFO ##### Order 20057550 ##### MADE BY Client: c91
2021-06-25 10:37:13.906+0000 INFO ##### Order 20057560 ##### MADE BY Client: c16
2021-06-25 10:37:13.958+0000 INFO ##### Order 20057570 ##### MADE BY Client: c34
2021-06-25 10:37:14.022+0000 INFO ##### Order 20057580 ##### MADE BY Client: c6
2021-06-25 10:37:14.079+0000 INFO ##### Order 20057590 ##### MADE BY Client: c4
2021-06-25 10:37:14.151+0000 INFO ##### Order 20057600 ##### MADE BY Client: c25
2021-06-25 10:37:14.200+0000 INFO ##### Order 20057610 ##### MADE BY Client: c14
2021-06-25 10:37:14.230+0000 INFO ##### Order 20057620 ##### MADE BY Client: c94
2021-06-25 10:37:14.279+0000 INFO ##### Order 20057630 ##### MADE BY Client: c18
2021-06-25 10:37:14.336+0000 INFO ##### Order 20057640 ##### MADE BY Client: c51
2021-06-25 10:37:23.822+0000 INFO ##### Order 20061130 ##### MADE BY Client: c84
2021-06-25 10:37:23.854+0000 INFO ##### Order 20061140 ##### MADE BY Client: c6
2021-06-25 10:37:23.880+0000 INFO ##### Order 20061150 ##### MADE BY Client: c71
2021-06-25 10:37:23.923+0000 INFO ##### Order 20061160 ##### MADE BY Client: c75
2021-06-25 10:37:23.948+0000 INFO ##### Order 20061170 ##### MADE BY Client: c83
2021-06-25 10:37:23.990+0000 INFO ##### Order 20061180 ##### MADE BY Client: c56
2021-06-25 10:37:24.016+0000 INFO ##### Order 20061190 ##### MADE BY Client: c60
2021-06-25 10:37:24.041+0000 INFO ##### Order 20061200 ##### MADE BY Client: c37
2021-06-25 10:37:24.066+0000 INFO ##### Order 20061210 ##### MADE BY Client: c20
2021-06-25 10:37:24.092+0000 INFO ##### Order 20061220 ##### MADE BY Client: c67
2021-06-25 10:37:33.824+0000 INFO ##### Order 20064920 ##### MADE BY Client: c21
2021-06-25 10:37:33.850+0000 INFO ##### Order 20064930 ##### MADE BY Client: c50
2021-06-25 10:37:33.876+0000 INFO ##### Order 20064940 ##### MADE BY Client: c89
2021-06-25 10:37:33.901+0000 INFO ##### Order 20064950 ##### MADE BY Client: c86
2021-06-25 10:37:33.927+0000 INFO ##### Order 20064960 ##### MADE BY Client: c33
2021-06-25 10:37:33.952+0000 INFO ##### Order 20064970 ##### MADE BY Client: c55
2021-06-25 10:37:33.978+0000 INFO ##### Order 20064980 ##### MADE BY Client: c51
2021-06-25 10:37:34.004+0000 INFO ##### Order 20064990 ##### MADE BY Client: c37
2021-06-25 10:37:34.029+0000 INFO ##### Order 20065000 ##### MADE BY Client: c54
2021-06-25 10:37:34.055+0000 INFO ##### Order 20065010 ##### MADE BY Client: c24
2021-06-25 10:37:43.834+0000 INFO ##### Order 20068570 ##### MADE BY Client: c3
2021-06-25 10:37:43.860+0000 INFO ##### Order 20068580 ##### MADE BY Client: c99
2021-06-25 10:37:43.886+0000 INFO ##### Order 20068590 ##### MADE BY Client: c5
2021-06-25 10:37:43.912+0000 INFO ##### Order 20068600 ##### MADE BY Client: c26
2021-06-25 10:37:43.937+0000 INFO ##### Order 20068610 ##### MADE BY Client: c4
2021-06-25 10:37:43.963+0000 INFO ##### Order 20068620 ##### MADE BY Client: c95
2021-06-25 10:37:43.989+0000 INFO ##### Order 20068630 ##### MADE BY Client: c73
2021-06-25 10:37:44.014+0000 INFO ##### Order 20068640 ##### MADE BY Client: c69
2021-06-25 10:37:44.039+0000 INFO ##### Order 20068650 ##### MADE BY Client: c85
2021-06-25 10:37:44.065+0000 INFO ##### Order 20068660 ##### MADE BY Client: c3
2021-06-25 10:37:53.860+0000 INFO ##### Order 20071810 ##### MADE BY Client: c14
2021-06-25 10:37:53.896+0000 INFO ##### Order 20071820 ##### MADE BY Client: c69
2021-06-25 10:37:53.923+0000 INFO ##### Order 20071830 ##### MADE BY Client: c84
2021-06-25 10:37:53.949+0000 INFO ##### Order 20071840 ##### MADE BY Client: c29
2021-06-25 10:37:53.977+0000 INFO ##### Order 20071850 ##### MADE BY Client: c57
2021-06-25 10:37:54.007+0000 INFO ##### Order 20071860 ##### MADE BY Client: c42
2021-06-25 10:37:54.032+0000 INFO ##### Order 20071870 ##### MADE BY Client: c45
2021-06-25 10:37:54.061+0000 INFO ##### Order 20071880 ##### MADE BY Client: c54
2021-06-25 10:37:54.099+0000 INFO ##### Order 20071890 ##### MADE BY Client: c28
2021-06-25 10:37:54.150+0000 INFO ##### Order 20071900 ##### MADE BY Client: c43
2021-06-25 10:38:03.876+0000 INFO ##### Order 20075250 ##### MADE BY Client: c5
2021-06-25 10:38:03.902+0000 INFO ##### Order 20075260 ##### MADE BY Client: c29
2021-06-25 10:38:03.928+0000 INFO ##### Order 20075270 ##### MADE BY Client: c98
2021-06-25 10:38:03.954+0000 INFO ##### Order 20075280 ##### MADE BY Client: c86
2021-06-25 10:38:03.980+0000 INFO ##### Order 20075290 ##### MADE BY Client: c61
2021-06-25 10:38:04.006+0000 INFO ##### Order 20075300 ##### MADE BY Client: c78
2021-06-25 10:38:04.032+0000 INFO ##### Order 20075310 ##### MADE BY Client: c76
2021-06-25 10:38:04.057+0000 INFO ##### Order 20075320 ##### MADE BY Client: c59
2021-06-25 10:38:04.083+0000 INFO ##### Order 20075330 ##### MADE BY Client: c30
2021-06-25 10:38:04.109+0000 INFO ##### Order 20075340 ##### MADE BY Client: c27
2021-06-25 10:38:13.884+0000 INFO ##### Order 20078810 ##### MADE BY Client: c72
2021-06-25 10:38:13.910+0000 INFO ##### Order 20078820 ##### MADE BY Client: c92
2021-06-25 10:38:13.959+0000 INFO ##### Order 20078830 ##### MADE BY Client: c58
2021-06-25 10:38:13.984+0000 INFO ##### Order 20078840 ##### MADE BY Client: c89
2021-06-25 10:38:14.010+0000 INFO ##### Order 20078850 ##### MADE BY Client: c24
2021-06-25 10:38:14.036+0000 INFO ##### Order 20078860 ##### MADE BY Client: c67
2021-06-25 10:38:14.061+0000 INFO ##### Order 20078870 ##### MADE BY Client: c31
2021-06-25 10:38:14.087+0000 INFO ##### Order 20078880 ##### MADE BY Client: c59
2021-06-25 10:38:14.113+0000 INFO ##### Order 20078890 ##### MADE BY Client: c78
2021-06-25 10:38:14.139+0000 INFO ##### Order 20078900 ##### MADE BY Client: c43
2021-06-25 10:38:23.892+0000 INFO ##### Order 20082620 ##### MADE BY Client: c24
2021-06-25 10:38:23.918+0000 INFO ##### Order 20082630 ##### MADE BY Client: c72
2021-06-25 10:38:23.944+0000 INFO ##### Order 20082640 ##### MADE BY Client: c89
2021-06-25 10:38:23.970+0000 INFO ##### Order 20082650 ##### MADE BY Client: c50
2021-06-25 10:38:24.011+0000 INFO ##### Order 20082660 ##### MADE BY Client: c73
2021-06-25 10:38:24.037+0000 INFO ##### Order 20082670 ##### MADE BY Client: c22
2021-06-25 10:38:24.065+0000 INFO ##### Order 20082680 ##### MADE BY Client: c39
2021-06-25 10:38:24.092+0000 INFO ##### Order 20082690 ##### MADE BY Client: c3
2021-06-25 10:38:24.118+0000 INFO ##### Order 20082700 ##### MADE BY Client: c77
2021-06-25 10:38:24.161+0000 INFO ##### Order 20082710 ##### MADE BY Client: c31
2021-06-25 10:38:33.906+0000 INFO ##### Order 20086440 ##### MADE BY Client: c82
2021-06-25 10:38:33.932+0000 INFO ##### Order 20086450 ##### MADE BY Client: c3
2021-06-25 10:38:33.957+0000 INFO ##### Order 20086460 ##### MADE BY Client: c27
2021-06-25 10:38:33.983+0000 INFO ##### Order 20086470 ##### MADE BY Client: c79
2021-06-25 10:38:34.009+0000 INFO ##### Order 20086480 ##### MADE BY Client: c24
2021-06-25 10:38:34.035+0000 INFO ##### Order 20086490 ##### MADE BY Client: c16
2021-06-25 10:38:34.060+0000 INFO ##### Order 20086500 ##### MADE BY Client: c1
2021-06-25 10:38:34.107+0000 INFO ##### Order 20086510 ##### MADE BY Client: c60
2021-06-25 10:38:34.133+0000 INFO ##### Order 20086520 ##### MADE BY Client: c74
2021-06-25 10:38:34.159+0000 INFO ##### Order 20086530 ##### MADE BY Client: c94
2021-06-25 10:38:43.918+0000 INFO ##### Order 20090270 ##### MADE BY Client: c10
2021-06-25 10:38:43.944+0000 INFO ##### Order 20090280 ##### MADE BY Client: c36
2021-06-25 10:38:43.970+0000 INFO ##### Order 20090290 ##### MADE BY Client: c6
2021-06-25 10:38:43.996+0000 INFO ##### Order 20090300 ##### MADE BY Client: c88
2021-06-25 10:38:44.023+0000 INFO ##### Order 20090310 ##### MADE BY Client: c96
2021-06-25 10:38:44.052+0000 INFO ##### Order 20090320 ##### MADE BY Client: c57
2021-06-25 10:38:44.079+0000 INFO ##### Order 20090330 ##### MADE BY Client: c93
2021-06-25 10:38:44.105+0000 INFO ##### Order 20090340 ##### MADE BY Client: c57
2021-06-25 10:38:44.131+0000 INFO ##### Order 20090350 ##### MADE BY Client: c67
2021-06-25 10:38:44.158+0000 INFO ##### Order 20090360 ##### MADE BY Client: c22
2021-06-25 10:38:53.939+0000 INFO ##### Order 20094050 ##### MADE BY Client: c59
2021-06-25 10:38:53.966+0000 INFO ##### Order 20094060 ##### MADE BY Client: c23
2021-06-25 10:38:54.009+0000 INFO ##### Order 20094070 ##### MADE BY Client: c21
2021-06-25 10:38:54.035+0000 INFO ##### Order 20094080 ##### MADE BY Client: c12
2021-06-25 10:38:54.063+0000 INFO ##### Order 20094090 ##### MADE BY Client: c6
2021-06-25 10:38:54.089+0000 INFO ##### Order 20094100 ##### MADE BY Client: c36
2021-06-25 10:38:54.114+0000 INFO ##### Order 20094110 ##### MADE BY Client: c64
2021-06-25 10:38:54.141+0000 INFO ##### Order 20094120 ##### MADE BY Client: c52
2021-06-25 10:38:54.167+0000 INFO ##### Order 20094130 ##### MADE BY Client: c85
2021-06-25 10:38:54.198+0000 INFO ##### Order 20094140 ##### MADE BY Client: c92
2021-06-25 10:39:03.960+0000 INFO ##### Order 20097550 ##### MADE BY Client: c11
2021-06-25 10:39:03.986+0000 INFO ##### Order 20097560 ##### MADE BY Client: c50
2021-06-25 10:39:04.011+0000 INFO ##### Order 20097570 ##### MADE BY Client: c2
2021-06-25 10:39:04.036+0000 INFO ##### Order 20097580 ##### MADE BY Client: c73
2021-06-25 10:39:04.062+0000 INFO ##### Order 20097590 ##### MADE BY Client: c16
2021-06-25 10:39:04.087+0000 INFO ##### Order 20097600 ##### MADE BY Client: c6
2021-06-25 10:39:04.113+0000 INFO ##### Order 20097610 ##### MADE BY Client: c18
2021-06-25 10:39:04.138+0000 INFO ##### Order 20097620 ##### MADE BY Client: c99
2021-06-25 10:39:04.164+0000 INFO ##### Order 20097630 ##### MADE BY Client: c51
2021-06-25 10:39:04.190+0000 INFO ##### Order 20097640 ##### MADE BY Client: c75
2021-06-25 10:39:13.969+0000 INFO ##### Order 20101430 ##### MADE BY Client: c55
2021-06-25 10:39:13.994+0000 INFO ##### Order 20101440 ##### MADE BY Client: c100
2021-06-25 10:39:14.020+0000 INFO ##### Order 20101450 ##### MADE BY Client: c55
2021-06-25 10:39:14.045+0000 INFO ##### Order 20101460 ##### MADE BY Client: c98
2021-06-25 10:39:14.070+0000 INFO ##### Order 20101470 ##### MADE BY Client: c26
2021-06-25 10:39:14.096+0000 INFO ##### Order 20101480 ##### MADE BY Client: c47
2021-06-25 10:39:14.122+0000 INFO ##### Order 20101490 ##### MADE BY Client: c54
2021-06-25 10:39:14.148+0000 INFO ##### Order 20101500 ##### MADE BY Client: c36
2021-06-25 10:39:14.174+0000 INFO ##### Order 20101510 ##### MADE BY Client: c22
2021-06-25 10:39:14.200+0000 INFO ##### Order 20101520 ##### MADE BY Client: c56
Raw
neo4j.log.batchSize100
2021-06-25 10:57:30.067+0000 INFO Starting...
2021-06-25 10:57:32.020+0000 INFO ======== Neo4j 4.2.4 ========
2021-06-25 10:57:40.469+0000 INFO Performing postInitialization step for component 'security-users' with version 2 and status CURRENT
2021-06-25 10:57:40.469+0000 INFO Updating the initial password in component 'security-users'
2021-06-25 10:57:44.809+0000 INFO Called db.clearQueryCaches(): Query cache already empty.
2021-06-25 10:57:49.910+0000 INFO Bolt enabled on localhost:7687.
2021-06-25 10:57:50.709+0000 INFO Remote interface available at http://localhost:7474/
2021-06-25 10:57:50.709+0000 INFO Started.
2021-06-25 11:00:32.506+0000 INFO starting batching from `LOAD CSV WITH HEADERS FROM ('https://github.com/magaton/slashco-mlm/blob/master/orders-22-01.csv?raw=true')AS line RETURN line` operation using iteration `WITH line, date(line.date) as date
MERGE (order:Order {id:line.id})
ON CREATE SET order.createDate=date, order.effectiveDate=date, order.referer=line.referer, order.post=line.post, order.type=line.type
MERGE (client:Client {id:line.client})
WITH order, client
MERGE (client)-[:MADE]->(order)
RETURN order` in separate thread
2021-06-25 11:00:34.387+0000 INFO ##### Order 10000000 ##### MADE BY Client: c30
2021-06-25 11:00:34.414+0000 INFO ##### Order 10000010 ##### MADE BY Client: c45
2021-06-25 11:00:34.414+0000 INFO ##### Order 10000020 ##### MADE BY Client: c73
2021-06-25 11:00:34.415+0000 INFO ##### Order 10000030 ##### MADE BY Client: c60
2021-06-25 11:00:34.415+0000 INFO ##### Order 10000040 ##### MADE BY Client: c72
2021-06-25 11:00:34.415+0000 INFO ##### Order 10000050 ##### MADE BY Client: c97
2021-06-25 11:00:34.415+0000 INFO ##### Order 10000060 ##### MADE BY Client: c28
2021-06-25 11:00:34.415+0000 INFO ##### Order 10000070 ##### MADE BY Client: c84
2021-06-25 11:00:34.416+0000 INFO ##### Order 10000080 ##### MADE BY Client: c52
2021-06-25 11:00:34.416+0000 INFO ##### Order 10000090 ##### MADE BY Client: c59
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment