You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@inlong.apache.org by "e-mhui (via GitHub)" <gi...@apache.org> on 2023/06/19 08:22:46 UTC

[GitHub] [inlong] e-mhui opened a new issue, #8279: [Bug][Sort] NPE when run MySqlLoadSqlParseTest

e-mhui opened a new issue, #8279:
URL: https://github.com/apache/inlong/issues/8279

   ### What happened
   
   When running MySqlLoadSqlParseTest, there was an error in mysql cdc. 
   ```
   Caused by: java.lang.NullPointerException
   	at io.debezium.connector.mysql.MySqlValueConverters.schemaBuilder(MySqlValueConverters.java:167) ~[debezium-connector-mysql-1.5.4.Final.jar:1.5.4.Final]
   	at io.debezium.relational.TableSchemaBuilder.addField(TableSchemaBuilder.java:360) ~[debezium-core-1.5.4.Final.jar:1.5.4.Final]
   	at io.debezium.relational.TableSchemaBuilder.lambda$create$2(TableSchemaBuilder.java:119) ~[debezium-core-1.5.4.Final.jar:1.5.4.Final]
   	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:1.8.0_302]
   	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) ~[?:1.8.0_302]
   	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1384) ~[?:1.8.0_302]
   	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482) ~[?:1.8.0_302]
   	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472) ~[?:1.8.0_302]
   	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) ~[?:1.8.0_302]
   	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) ~[?:1.8.0_302]
   	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:1.8.0_302]
   	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:485) ~[?:1.8.0_302]
   	at io.debezium.relational.TableSchemaBuilder.create(TableSchemaBuilder.java:117) ~[debezium-core-1.5.4.Final.jar:1.5.4.Final]
   	at io.debezium.relational.RelationalDatabaseSchema.buildAndRegisterSchema(RelationalDatabaseSchema.java:130) ~[debezium-core-1.5.4.Final.jar:1.5.4.Final]
   	at io.debezium.relational.HistorizedRelationalDatabaseSchema.recover(HistorizedRelationalDatabaseSchema.java:52) ~[debezium-core-1.5.4.Final.jar:1.5.4.Final]
   ```
   
   From the source code,  mysql depends on debezium version 1.5.4-Final, while oracle and mongodb depend on 1.6.4-Final. When running MySqlLoadSqlParseTest`,  debezium-1.6.4-Final is used first, causing a NullPointerException error. 
   
   The temporary solution is to comment out the dependencies of oracle and mongodb in the pom.xml.
   
   ```xml
   <!--        <dependency>-->
   <!--            <groupId>org.apache.inlong</groupId>-->
   <!--            <artifactId>sort-connector-mongodb-cdc</artifactId>-->
   <!--            <version>${project.version}</version>-->
   <!--            <scope>test</scope>-->
   <!--        </dependency>-->
   <!--        <dependency>-->
   <!--            <groupId>org.apache.inlong</groupId>-->
   <!--            <artifactId>sort-connector-oracle-cdc</artifactId>-->
   <!--            <version>${project.version}</version>-->
   <!--            <scope>test</scope>-->
   <!--        </dependency>-->
   
   ```
   
   ### What you expected to happen
   
   Successfully run `MySqlLoadSqlParseTest`
   
   ### How to reproduce
   
   Run `Successfully run MySqlLoadSqlParseTest`
   
   ### Environment
   
   _No response_
   
   ### InLong version
   
   master
   
   ### InLong Component
   
   InLong Sort
   
   ### Are you willing to submit PR?
   
   - [X] Yes, I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [inlong] dockerzhang closed issue #8279: [Bug][Sort] NPE when run MySqlLoadSqlParseTest

Posted by "dockerzhang (via GitHub)" <gi...@apache.org>.
dockerzhang closed issue #8279: [Bug][Sort] NPE when run MySqlLoadSqlParseTest
URL: https://github.com/apache/inlong/issues/8279


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [inlong] e-mhui commented on issue #8279: [Bug][Sort] NPE when run MySqlLoadSqlParseTest

Posted by "e-mhui (via GitHub)" <gi...@apache.org>.
e-mhui commented on issue #8279:
URL: https://github.com/apache/inlong/issues/8279#issuecomment-1656553286

   <img width="1046" alt="image" src="https://github.com/apache/inlong/assets/111486498/528bafd7-459c-4ca0-b959-b78a63812270">
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [inlong] e-mhui commented on issue #8279: [Bug][Sort] NPE when run MySqlLoadSqlParseTest

Posted by "e-mhui (via GitHub)" <gi...@apache.org>.
e-mhui commented on issue #8279:
URL: https://github.com/apache/inlong/issues/8279#issuecomment-1656549359

   io.debezium.text.ParsingException: Unrecognized dataType for varchar(255)
   <img width="1496" alt="image" src="https://github.com/apache/inlong/assets/111486498/c77f11bf-37be-4f68-a822-697fb52c642c">
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org