search

neo4j-contrib / neo4j-etl

Data import from relational databases to Neo4j.
https://neo4j.com/developer/neo4j-etl/
Other
214 stars 46 forks source link

[PostgreSQL] hanging after "An illegal reflective access operation has occurred" #81

Open whatSocks opened 3 years ago

whatSocks commented 3 years ago

hanging after:

- Creating RDBMS to CSV mappings...
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.postgresql.jdbc.TimestampUtils (file:/blablabla/Application/graphApps/_global/neo4j-etl-ui/dist/neo4j-etl.jar) to field java.util.TimeZone.defaultTimeZone
WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
- Using database plugin for postgresql - PostgreSQL
- Crawling schemas
- Retrieving all schemas
- Retrieving all catalogs
- Processed 3 rows for <retrieveAllSchemas>
- Retrieved 3 schemas
- Total time taken for <crawlSchemas> - 00:00:00.054 hours
- 98.1% - 00:00:00.053 - <retrieveSchemas>
-  0.0% - 00:00:00.000 - <sortAndFilterSchemas>

- Retrieving database information
- Not retrieving additional database information, since this was not requested
- Retrieving JDBC driver information
- Not retrieving additional JDBC driver information, since this was not requested
- Retrieving SchemaCrawler crawl information
- Total time taken for <crawlDatabaseInfo> - 00:00:00.001 hours
-  0.0% - 00:00:00.000 - <retrieveDatabaseInfo>
-  0.0% - 00:00:00.000 - <retrieveAdditionalDatabaseInfo>
-  0.0% - 00:00:00.000 - <retrieveJdbcDriverInfo>
-  0.0% - 00:00:00.000 - <retrieveAdditionalJdbcDriverInfo>
-  0.0% - 00:00:00.000 - <retrieveCrawlHeaderInfo>

- Crawling column data types
- Retrieving system column data types
- Not retrieving user column data types, since this was not requested
- Total time taken for <crawlColumnDataTypes> - 00:00:45.521 hours
-100.0% - 00:00:45.521 - <retrieveSystemColumnDataTypes>
-  0.0% - 00:00:00.000 - <retrieveUserDefinedColumnDataTypes>

- Crawling tables
- Retrieving tables
- Retrieving tables for schema <information_schema>
- Processed 0 rows for <retrieveTables>
- Retrieving tables for schema <pg_catalog>
- Processed 0 rows for <retrieveTables>
- Retrieving tables for schema <public>
- Processed 186 rows for <retrieveTables>
- Retrieved 186 tables
- Retrieving table columns
- Retrieving foreign keys
- Retrieving primary keys and indexes
- Retrieving indexes
- Retrieving primary keys
- Total time taken for <crawlTables> - 00:01:13.955 hours
-  0.2% - 00:00:00.183 - <retrieveTables>
- 14.7% - 00:00:10.863 - <retrieveColumns>
- 32.8% - 00:00:24.266 - <retrieveForeignKeys>
-  0.1% - 00:00:00.052 - <filterAndSortTables>
- 52.2% - 00:00:38.588 - <retrieveIndexes>
-  0.0% - 00:00:00.000 - <retrieveTableConstraintInformation>
-  0.0% - 00:00:00.000 - <isRetrieveTableConstraintDefinitions>
-  0.0% - 00:00:00.000 - <retrieveTriggerInformation>
-  0.0% - 00:00:00.000 - <retrieveViewInformation>
-  0.0% - 00:00:00.000 - <retrieveTableDefinitions>
-  0.0% - 00:00:00.000 - <retrieveIndexInformation>
-  0.0% - 00:00:00.000 - <retrieveAdditionalTableAttributes>
-  0.0% - 00:00:00.000 - <retrieveTablePrivileges>
-  0.0% - 00:00:00.000 - <retrieveAdditionalColumnAttributes>
-  0.0% - 00:00:00.000 - <retrieveTableColumnPrivileges>

- Crawling routines
- Retrieved 0 routines
- Not retrieving synonyms, since this was not requested
- Not retrieving sequences, since this was not requested
Mapping...

there's no way to quit after giving up on this process, which is confusing

whatSocks commented 3 years ago

I deleted the ETL app (manually checked the directory to make sure it wasn't there since there seems to be some issue with delete) and reinstalled. I'm getting a different log, but it still seems stuck:

- Using database plugin for postgresql - PostgreSQL
- Crawling schemas
- Retrieving all schemas
- Retrieving all catalogs
- Processed 3 rows for <retrieveAllSchemas>
- Including schema public
- Retrieved 1 schemas
- Including schema public
- Total time taken for <crawlSchemas> - 00:00:00.054 hours
-100.0% - 00:00:00.054 - <retrieveSchemas>
-  0.0% - 00:00:00.000 - <sortAndFilterSchemas>

- Retrieving database information
- Not retrieving additional database information, since this was not requested
- Retrieving JDBC driver information
- Not retrieving additional JDBC driver information, since this was not requested
- Retrieving SchemaCrawler crawl information
- Total time taken for <crawlDatabaseInfo> - 00:00:00.001 hours
-  0.0% - 00:00:00.000 - <retrieveDatabaseInfo>
-  0.0% - 00:00:00.000 - <retrieveAdditionalDatabaseInfo>
-  0.0% - 00:00:00.000 - <retrieveJdbcDriverInfo>
-  0.0% - 00:00:00.000 - <retrieveAdditionalJdbcDriverInfo>
-  0.0% - 00:00:00.000 - <retrieveCrawlHeaderInfo>

- Crawling column data types
- Retrieving system column data types
- Not retrieving user column data types, since this was not requested
- Total time taken for <crawlColumnDataTypes> - 00:00:46.137 hours
-100.0% - 00:00:46.137 - <retrieveSystemColumnDataTypes>
-  0.0% - 00:00:00.000 - <retrieveUserDefinedColumnDataTypes>

- Crawling tables
- Retrieving tables
- Retrieving tables for schema <public>
- Processed 186 rows for <retrieveTables>
- Retrieved 186 tables
- Retrieving table columns
- Retrieving foreign keys
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Including schema public
- Retrieving primary keys and indexes
- Retrieving indexes
- Retrieving primary keys
- Total time taken for <crawlTables> - 00:01:08.819 hours
-  0.1% - 00:00:00.068 - <retrieveTables>
- 16.0% - 00:00:11.039 - <retrieveColumns>
- 35.2% - 00:00:24.229 - <retrieveForeignKeys>
-  0.1% - 00:00:00.071 - <filterAndSortTables>
- 48.5% - 00:00:33.409 - <retrieveIndexes>
-  0.0% - 00:00:00.000 - <retrieveTableConstraintInformation>
-  0.0% - 00:00:00.000 - <isRetrieveTableConstraintDefinitions>
-  0.0% - 00:00:00.000 - <retrieveTriggerInformation>
-  0.0% - 00:00:00.000 - <retrieveViewInformation>
-  0.0% - 00:00:00.000 - <retrieveTableDefinitions>
-  0.0% - 00:00:00.000 - <retrieveIndexInformation>
-  0.0% - 00:00:00.000 - <retrieveAdditionalTableAttributes>
-  0.0% - 00:00:00.000 - <retrieveTablePrivileges>
-  0.0% - 00:00:00.000 - <retrieveAdditionalColumnAttributes>
-  0.0% - 00:00:00.000 - <retrieveTableColumnPrivileges>

- Crawling routines
- Retrieved 0 routines
- Not retrieving synonyms, since this was not requested
- Not retrieving sequences, since this was not requested
wyzfj0305 commented 2 years ago

help me!