Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Check transaction guard in apoc.import.json #2025

Closed
conker84 opened this issue Jun 19, 2021 · 0 comments · Fixed by #2108 or #2429
Closed

Check transaction guard in apoc.import.json #2025

conker84 opened this issue Jun 19, 2021 · 0 comments · Fixed by #2108 or #2429

Comments

@conker84
Copy link
Contributor

conker84 commented Jun 19, 2021

Try with this in order to reproduce it

create constraint on (g:Stream) assert g.neo4jImportId is unique;
create constraint on (g:User) assert g.neo4jImportId is unique;
create constraint on (g:Team) assert g.neo4jImportId is unique;
create constraint on (g:Language) assert g.neo4jImportId is unique;
create constraint on (g:Game) assert g.neo4jImportId is unique;
​
/* alternatively this could be a bit faster
create index on :Stream(neo4jImportId);
create index on :Language(neo4jImportId);
create index on :Team(neo4jImportId);
create index on :Game(neo4jImportId);
create index on :User(neo4jImportId);
*/
​
call dbms.setConfigValue('dbms.transaction.timeout','0');
​
CALL apoc.import.json("https://devrel-data-science.s3.us-east-2.amazonaws.com/twitch_all.json", 
  {txBatchSize:100000, unwindBatchSize:10000});
​
call dbms.listQueries() yield queryId, query, elapsedTimeMillis;

Check constraints, at least it should output the necessary constraints and abort if they don't exist

vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Jun 21, 2021
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Jul 20, 2021
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Aug 18, 2021
conker84 added a commit that referenced this issue Sep 30, 2021
#2205)

* Fixes #2025: Check transaction guard in apoc.import.json (#2108)

* ignoring test

Co-authored-by: Giuseppe Villani <giuseppe.villani@larus-ba.it>
Co-authored-by: Andrea Santurbano <santand@gmail.com>
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Dec 14, 2021
conker84 pushed a commit that referenced this issue Jan 13, 2022
* Fixes #2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
github-actions bot pushed a commit that referenced this issue Jan 13, 2022
* Fixes #2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Feb 21, 2022
… (4.3) (neo4j-contrib#2429)

* Fixes neo4j-contrib#2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Feb 24, 2022
… (4.3) (neo4j-contrib#2429)

* Fixes neo4j-contrib#2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Mar 17, 2022
… (4.3) (neo4j-contrib#2429)

* Fixes neo4j-contrib#2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Mar 23, 2022
… (4.3) (neo4j-contrib#2429)

* Fixes neo4j-contrib#2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
vga91 added a commit to vga91/neo4j-apoc-procedures that referenced this issue Mar 29, 2022
… (4.3) (neo4j-contrib#2429)

* Fixes neo4j-contrib#2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
conker84 pushed a commit that referenced this issue Apr 7, 2022
* Fixes #2025: Check transaction guard in apoc.import.json

* changes review

* changed createConstraint in tests

* changed transactionIsTerminated

* changed labels handling with quote

* changed test

* changes review

* edited CREATE_NODE and CREATE_RELS

* changes tests - multilabel handling

* removed ignore annotation
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant