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.

Sign up for GitHub

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

Jump to bottom

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

Open
whatSocks opened this issue Jul 29, 2021 · 2 comments
Open

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

whatSocks opened this issue Jul 29, 2021 · 2 comments

Comments

@whatSocks
Copy link

whatSocks commented Jul 29, 2021 •
edited
Loading

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
Copy link
Author

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
Copy link

help me!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@whatSocks @wyzfj0305