java.io.IOException: Error writing to server

[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R java.io.IOException: Error writing to server
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at sun.net.www.protocol.http.HttpURLConnection.writeRequests(HttpURLConnection.java:594)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at sun.net.www.protocol.http.HttpURLConnection.writeRequests(HttpURLConnection.java:606)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1228)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at com.topsoft.util.HttpPostUrl.sendPost(HttpPostUrl.java:292)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at com.topsoft.component.engraveseal.EngraveSealCompAction.sendDate(EngraveSealCompAction.java:2359)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at com.topsoft.job.EngraveOfficialJob.execute(EngraveOfficialJob.java:94)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at sun.reflect.GeneratedMethodAccessor5318.invoke(Unknown Source)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[21-2-20 15:00:15:378 CST] 00000037 SystemErr     R 	at java.lang.reflect.Method.invoke(Method.java:611)

1、接口请求报错如上,本地可以请求接口,但A服务器不行。

调试了很久,发现是A服务器网络问题。之前A服务器测试telnet可以通接口服务器,就没往网络方面想,后来实在没办法,就把A服务器服务重新换台服务器部署了,然后换的服务器接通网络,请求就成功了。

2、如果本地都调不通,可能是数据传输太大,或者服务器限制传输大小。这个需要自己去缩小数据量,查看服务器是否有限制等排查。

root@zhaosai conf]# sqoop import --connect jdbc:mysql://192.168.160.130:3306/mydb --username root -P --table news --hive-import --hive-table mydb.news --incremental append --check-column id --last-value 0 --split-by id --target-dir /hdfs://zhaosai:9000/user/hive/warehouse/news --num-mappers 1 23/06/07 17:23:56 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7 Enter password: 23/06/07 17:24:04 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override 23/06/07 17:24:04 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc. 23/06/07 17:24:04 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 23/06/07 17:24:04 INFO tool.CodeGenTool: Beginning code generation Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 23/06/07 17:24:04 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `news` AS t LIMIT 1 23/06/07 17:24:04 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `news` AS t LIMIT 1 23/06/07 17:24:04 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /opt/programs/hadoop-2.7.6 注: /tmp/sqoop-root/compile/b07035b094b6ac39b87f2ef11261c934/news.java使用或覆盖了已过时的 API。 注: 有关详细信息, 请使用 -Xlint:deprecation 重新编译。 23/06/07 17:24:05 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/b07035b094b6ac39b87f2ef11261c934/news.jar 23/06/07 17:24:05 INFO tool.ImportTool: Maximal id query for free form incremental import: SELECT MAX(`id`) FROM `news` 23/06/07 17:24:05 ERROR tool.ImportTool: Import failed: java.io.IOException: java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'field list' at org.apache.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:322) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:511) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200) at org.apache.sqoop.tool.ImportTool.getMaxColumnId(ImportTool.java:238) at org.apache.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:309)
06-08
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值