[
https://issues.apache.org/jira/browse/HIVE-29130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raghav Aggarwal updated HIVE-29130:
-----------------------------------
Description:
Running the following schematool command is failing
{code:java}
schematool -dbType mysql -initSchema --verbose {code}
Attaching the schematool logs before and after HIVE-25495
{code:java}
0: jdbc:mysql://localhost:3307/hive> Closing: 0:
jdbc:mysql://localhost:3307/hivebeeline> beeline> 'java.lang.String
org.jline.reader.EndOfFileException.getPartialLine()'2025-08-09 20:33:02,845
ERROR schematool.MetastoreSchemaTool: Schema initialization FAILED! Metastore
state would be inconsistent!Schema initialization FAILED! Metastore state would
be inconsistent!2025-08-09 20:33:02,845 ERROR schematool.MetastoreSchemaTool:
Underlying cause: java.io.IOException : Schema script failed, errorcode
2Underlying cause: java.io.IOException : Schema script failed, errorcode
2org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization
FAILED! Metastore state would be inconsistent! at
org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:66)
at
org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:486)
at
org.apache.hive.beeline.schematool.HiveSchemaTool.main(HiveSchemaTool.java:206)
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
org.apache.hadoop.util.RunJar.run(RunJar.java:330) at
org.apache.hadoop.util.RunJar.main(RunJar.java:245)Caused by:
java.io.IOException: Schema script failed, errorcode 2 at
org.apache.hive.beeline.schematool.HiveSchemaTool.execSql(HiveSchemaTool.java:122)
at
org.apache.hive.beeline.schematool.HiveSchemaTool.execSql(HiveSchemaTool.java:99)
at
org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:62)
... 6 more2025-08-09 20:33:02,846 ERROR schematool.MetastoreSchemaTool:
*** schemaTool failed ****** schemaTool failed ***
{code}
> schematool failure post Jline3
> ------------------------------
>
> Key: HIVE-29130
> URL: https://issues.apache.org/jira/browse/HIVE-29130
> Project: Hive
> Issue Type: Bug
> Reporter: Raghav Aggarwal
> Assignee: Raghav Aggarwal
> Priority: Major
>
> Running the following schematool command is failing
> {code:java}
> schematool -dbType mysql -initSchema --verbose {code}
> Attaching the schematool logs before and after HIVE-25495
> {code:java}
> 0: jdbc:mysql://localhost:3307/hive> Closing: 0:
> jdbc:mysql://localhost:3307/hivebeeline> beeline> 'java.lang.String
> org.jline.reader.EndOfFileException.getPartialLine()'2025-08-09 20:33:02,845
> ERROR schematool.MetastoreSchemaTool: Schema initialization FAILED! Metastore
> state would be inconsistent!Schema initialization FAILED! Metastore state
> would be inconsistent!2025-08-09 20:33:02,845 ERROR
> schematool.MetastoreSchemaTool: Underlying cause: java.io.IOException :
> Schema script failed, errorcode 2Underlying cause: java.io.IOException :
> Schema script failed, errorcode
> 2org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization
> FAILED! Metastore state would be inconsistent! at
> org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:66)
> at
> org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:486)
> at
> org.apache.hive.beeline.schematool.HiveSchemaTool.main(HiveSchemaTool.java:206)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> org.apache.hadoop.util.RunJar.run(RunJar.java:330) at
> org.apache.hadoop.util.RunJar.main(RunJar.java:245)Caused by:
> java.io.IOException: Schema script failed, errorcode 2 at
> org.apache.hive.beeline.schematool.HiveSchemaTool.execSql(HiveSchemaTool.java:122)
> at
> org.apache.hive.beeline.schematool.HiveSchemaTool.execSql(HiveSchemaTool.java:99)
> at
> org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:62)
> ... 6 more2025-08-09 20:33:02,846 ERROR schematool.MetastoreSchemaTool:
> *** schemaTool failed ****** schemaTool failed ***
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
