API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2016
215
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.54 KB | None | 0 0
raw download clone embed print report
  1. Traceback (most recent call last):
  2. File "/tmp/zeppelin_pyspark-5396407671469726353.py", line 267, in <module>
  3. raise Exception(traceback.format_exc())
  4. Exception: Traceback (most recent call last):
  5. File "/tmp/zeppelin_pyspark-5396407671469726353.py", line 260, in <module>
  6. exec(code)
  7. File "<stdin>", line 10, in <module>
  8. File "/software/zeppelin-0.6.2-bin-all/interpreter/spark/pyspark/pyspark.zip/pyspark/sql/readwriter.py", line 153, in load
  9. return self._df(self._jreader.load())
  10. File "/software/zeppelin-0.6.2-bin-all/interpreter/spark/pyspark/py4j-0.10.1-src.zip/py4j/java_gateway.py", line 933, in __call__
  11. answer, self.gateway_client, self.target_id, self.name)
  12. File "/software/zeppelin-0.6.2-bin-all/interpreter/spark/pyspark/pyspark.zip/pyspark/sql/utils.py", line 63, in deco
  13. return f(*a, **kw)
  14. File "/software/zeppelin-0.6.2-bin-all/interpreter/spark/pyspark/py4j-0.10.1-src.zip/py4j/protocol.py", line 312, in get_return_value
  15. format(target_id, ".", name), value)
  16. Py4JJavaError: An error occurred while calling o135.load.
  17. : java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  18. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)
  19. at org.apache.spark.sql.hive.client.HiveClientImpl.<init>(HiveClientImpl.scala:171)
  20. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  21. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  22. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  23. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  24. at org.apache.spark.sql.hive.client.IsolatedClientLoader.createClient(IsolatedClientLoader.scala:258)
  25. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:359)
  26. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:263)
  27. at org.apache.spark.sql.hive.HiveSharedState.metadataHive$lzycompute(HiveSharedState.scala:39)
  28. at org.apache.spark.sql.hive.HiveSharedState.metadataHive(HiveSharedState.scala:38)
  29. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog$lzycompute(HiveSharedState.scala:46)
  30. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog(HiveSharedState.scala:45)
  31. at org.apache.spark.sql.hive.HiveSessionState.catalog$lzycompute(HiveSessionState.scala:50)
  32. at org.apache.spark.sql.hive.HiveSessionState.catalog(HiveSessionState.scala:48)
  33. at org.apache.spark.sql.hive.HiveSessionState$$anon$1.<init>(HiveSessionState.scala:63)
  34. at org.apache.spark.sql.hive.HiveSessionState.analyzer$lzycompute(HiveSessionState.scala:63)
  35. at org.apache.spark.sql.hive.HiveSessionState.analyzer(HiveSessionState.scala:62)
  36. at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:49)
  37. at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:64)
  38. at org.apache.spark.sql.SparkSession.baseRelationToDataFrame(SparkSession.scala:382)
  39. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:143)
  40. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:122)
  41. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  42. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  43. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  44. at java.lang.reflect.Method.invoke(Method.java:498)
  45. at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:237)
  46. at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
  47. at py4j.Gateway.invoke(Gateway.java:280)
  48. at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:128)
  49. at py4j.commands.CallCommand.execute(CallCommand.java:79)
  50. at py4j.GatewayConnection.run(GatewayConnection.java:211)
  51. at java.lang.Thread.run(Thread.java:745)
  52. Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  53. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523)
  54. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
  55. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
  56. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
  57. at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
  58. at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
  59. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
  60. ... 33 more
  61. Caused by: java.lang.reflect.InvocationTargetException
  62. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  63. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  64. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  65. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  66. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
  67. ... 39 more
  68. Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:derby:;databaseName=metastore_db;create=true, username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
  69. java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  70. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  71. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  72. at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
  73. at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
  74. at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
  75. at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
  76. at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
  77. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  78. at org.apache.derby.jdbc.Driver20.connect(Unknown Source)
  79. at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
  80. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  81. at java.sql.DriverManager.getConnection(DriverManager.java:208)
  82. at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
  83. at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
  84. at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
  85. at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501)
  86. at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298)
  87. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  88. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  89. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  90. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  91. at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
  92. at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
  93. at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
  94. at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
  95. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
  96. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
  97. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
  98. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  99. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  100. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  101. at java.lang.reflect.Method.invoke(Method.java:498)
  102. at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
  103. at java.security.AccessController.doPrivileged(Native Method)
  104. at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
  105. at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
  106. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
  107. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
  108. at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)
  109. at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)
  110. at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)
  111. at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)
  112. at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
  113. at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
  114. at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)
  115. at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)
  116. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593)
  117. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571)
  118. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)
  119. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
  120. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
  121. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
  122. at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
  123. at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
  124. at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
  125. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  126. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  127. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  128. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  129. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
  130. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
  131. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
  132. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
  133. at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
  134. at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
  135. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
  136. at org.apache.spark.sql.hive.client.HiveClientImpl.<init>(HiveClientImpl.scala:171)
  137. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  138. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  139. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  140. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  141. at org.apache.spark.sql.hive.client.IsolatedClientLoader.createClient(IsolatedClientLoader.scala:258)
  142. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:359)
  143. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:263)
  144. at org.apache.spark.sql.hive.HiveSharedState.metadataHive$lzycompute(HiveSharedState.scala:39)
  145. at org.apache.spark.sql.hive.HiveSharedState.metadataHive(HiveSharedState.scala:38)
  146. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog$lzycompute(HiveSharedState.scala:46)
  147. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog(HiveSharedState.scala:45)
  148. at org.apache.spark.sql.hive.HiveSessionState.catalog$lzycompute(HiveSessionState.scala:50)
  149. at org.apache.spark.sql.hive.HiveSessionState.catalog(HiveSessionState.scala:48)
  150. at org.apache.spark.sql.hive.HiveSessionState$$anon$1.<init>(HiveSessionState.scala:63)
  151. at org.apache.spark.sql.hive.HiveSessionState.analyzer$lzycompute(HiveSessionState.scala:63)
  152. at org.apache.spark.sql.hive.HiveSessionState.analyzer(HiveSessionState.scala:62)
  153. at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:49)
  154. at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:64)
  155. at org.apache.spark.sql.SparkSession.baseRelationToDataFrame(SparkSession.scala:382)
  156. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:143)
  157. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:122)
  158. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  159. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  160. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  161. at java.lang.reflect.Method.invoke(Method.java:498)
  162. at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:237)
  163. at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
  164. at py4j.Gateway.invoke(Gateway.java:280)
  165. at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:128)
  166. at py4j.commands.CallCommand.execute(CallCommand.java:79)
  167. at py4j.GatewayConnection.run(GatewayConnection.java:211)
  168. at java.lang.Thread.run(Thread.java:745)
  169. Caused by: java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  170. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  171. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  172. ... 99 more
  173. Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  174. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  175. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  176. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  177. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  178. ... 96 more
  179. Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  180. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
  181. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
  182. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
  183. at java.security.AccessController.doPrivileged(Native Method)
  184. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
  185. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
  186. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  187. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  188. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  189. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  190. at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
  191. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  192. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  193. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  194. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  195. at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
  196. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  197. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  198. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  199. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  200. at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
  201. at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
  202. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  203. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  204. at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
  205. at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
  206. at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
  207. at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
  208. at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
  209. ... 96 more
  210. ------
  211. NestedThrowables:
  212. java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:derby:;databaseName=metastore_db;create=true, username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
  213. java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  214. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  215. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  216. at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
  217. at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
  218. at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
  219. at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
  220. at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
  221. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  222. at org.apache.derby.jdbc.Driver20.connect(Unknown Source)
  223. at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
  224. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  225. at java.sql.DriverManager.getConnection(DriverManager.java:208)
  226. at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
  227. at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
  228. at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
  229. at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501)
  230. at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298)
  231. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  232. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  233. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  234. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  235. at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
  236. at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
  237. at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
  238. at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
  239. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
  240. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
  241. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
  242. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  243. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  244. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  245. at java.lang.reflect.Method.invoke(Method.java:498)
  246. at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
  247. at java.security.AccessController.doPrivileged(Native Method)
  248. at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
  249. at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
  250. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
  251. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
  252. at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)
  253. at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)
  254. at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)
  255. at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)
  256. at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
  257. at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
  258. at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)
  259. at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)
  260. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593)
  261. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571)
  262. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)
  263. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
  264. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
  265. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
  266. at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
  267. at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
  268. at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
  269. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  270. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  271. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  272. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  273. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
  274. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
  275. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
  276. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
  277. at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
  278. at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
  279. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
  280. at org.apache.spark.sql.hive.client.HiveClientImpl.<init>(HiveClientImpl.scala:171)
  281. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  282. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  283. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  284. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  285. at org.apache.spark.sql.hive.client.IsolatedClientLoader.createClient(IsolatedClientLoader.scala:258)
  286. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:359)
  287. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:263)
  288. at org.apache.spark.sql.hive.HiveSharedState.metadataHive$lzycompute(HiveSharedState.scala:39)
  289. at org.apache.spark.sql.hive.HiveSharedState.metadataHive(HiveSharedState.scala:38)
  290. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog$lzycompute(HiveSharedState.scala:46)
  291. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog(HiveSharedState.scala:45)
  292. at org.apache.spark.sql.hive.HiveSessionState.catalog$lzycompute(HiveSessionState.scala:50)
  293. at org.apache.spark.sql.hive.HiveSessionState.catalog(HiveSessionState.scala:48)
  294. at org.apache.spark.sql.hive.HiveSessionState$$anon$1.<init>(HiveSessionState.scala:63)
  295. at org.apache.spark.sql.hive.HiveSessionState.analyzer$lzycompute(HiveSessionState.scala:63)
  296. at org.apache.spark.sql.hive.HiveSessionState.analyzer(HiveSessionState.scala:62)
  297. at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:49)
  298. at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:64)
  299. at org.apache.spark.sql.SparkSession.baseRelationToDataFrame(SparkSession.scala:382)
  300. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:143)
  301. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:122)
  302. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  303. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  304. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  305. at java.lang.reflect.Method.invoke(Method.java:498)
  306. at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:237)
  307. at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
  308. at py4j.Gateway.invoke(Gateway.java:280)
  309. at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:128)
  310. at py4j.commands.CallCommand.execute(CallCommand.java:79)
  311. at py4j.GatewayConnection.run(GatewayConnection.java:211)
  312. at java.lang.Thread.run(Thread.java:745)
  313. Caused by: java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  314. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  315. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  316. ... 99 more
  317. Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  318. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  319. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  320. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  321. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  322. ... 96 more
  323. Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  324. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
  325. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
  326. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
  327. at java.security.AccessController.doPrivileged(Native Method)
  328. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
  329. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
  330. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  331. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  332. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  333. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  334. at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
  335. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  336. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  337. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  338. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  339. at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
  340. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  341. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  342. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  343. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  344. at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
  345. at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
  346. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  347. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  348. at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
  349. at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
  350. at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
  351. at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
  352. at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
  353. ... 96 more
  354. ------
  355. at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:436)
  356. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:788)
  357. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
  358. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
  359. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  360. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  361. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  362. at java.lang.reflect.Method.invoke(Method.java:498)
  363. at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
  364. at java.security.AccessController.doPrivileged(Native Method)
  365. at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
  366. at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
  367. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
  368. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
  369. at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)
  370. at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)
  371. at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)
  372. at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)
  373. at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
  374. at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
  375. at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)
  376. at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)
  377. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593)
  378. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571)
  379. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)
  380. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
  381. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
  382. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
  383. at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
  384. at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
  385. at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
  386. ... 44 more
  387. Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:derby:;databaseName=metastore_db;create=true, username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
  388. java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  389. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  390. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  391. at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
  392. at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
  393. at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
  394. at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
  395. at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
  396. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  397. at org.apache.derby.jdbc.Driver20.connect(Unknown Source)
  398. at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
  399. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  400. at java.sql.DriverManager.getConnection(DriverManager.java:208)
  401. at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
  402. at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
  403. at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
  404. at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501)
  405. at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298)
  406. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  407. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  408. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  409. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  410. at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
  411. at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
  412. at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
  413. at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
  414. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
  415. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
  416. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
  417. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  418. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  419. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  420. at java.lang.reflect.Method.invoke(Method.java:498)
  421. at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
  422. at java.security.AccessController.doPrivileged(Native Method)
  423. at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
  424. at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
  425. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
  426. at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
  427. at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)
  428. at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)
  429. at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)
  430. at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)
  431. at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
  432. at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
  433. at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)
  434. at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)
  435. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593)
  436. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571)
  437. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)
  438. at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
  439. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
  440. at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
  441. at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
  442. at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
  443. at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
  444. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  445. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  446. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  447. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  448. at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
  449. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
  450. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
  451. at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
  452. at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
  453. at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
  454. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
  455. at org.apache.spark.sql.hive.client.HiveClientImpl.<init>(HiveClientImpl.scala:171)
  456. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  457. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  458. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  459. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  460. at org.apache.spark.sql.hive.client.IsolatedClientLoader.createClient(IsolatedClientLoader.scala:258)
  461. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:359)
  462. at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:263)
  463. at org.apache.spark.sql.hive.HiveSharedState.metadataHive$lzycompute(HiveSharedState.scala:39)
  464. at org.apache.spark.sql.hive.HiveSharedState.metadataHive(HiveSharedState.scala:38)
  465. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog$lzycompute(HiveSharedState.scala:46)
  466. at org.apache.spark.sql.hive.HiveSharedState.externalCatalog(HiveSharedState.scala:45)
  467. at org.apache.spark.sql.hive.HiveSessionState.catalog$lzycompute(HiveSessionState.scala:50)
  468. at org.apache.spark.sql.hive.HiveSessionState.catalog(HiveSessionState.scala:48)
  469. at org.apache.spark.sql.hive.HiveSessionState$$anon$1.<init>(HiveSessionState.scala:63)
  470. at org.apache.spark.sql.hive.HiveSessionState.analyzer$lzycompute(HiveSessionState.scala:63)
  471. at org.apache.spark.sql.hive.HiveSessionState.analyzer(HiveSessionState.scala:62)
  472. at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:49)
  473. at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:64)
  474. at org.apache.spark.sql.SparkSession.baseRelationToDataFrame(SparkSession.scala:382)
  475. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:143)
  476. at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:122)
  477. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  478. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  479. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  480. at java.lang.reflect.Method.invoke(Method.java:498)
  481. at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:237)
  482. at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
  483. at py4j.Gateway.invoke(Gateway.java:280)
  484. at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:128)
  485. at py4j.commands.CallCommand.execute(CallCommand.java:79)
  486. at py4j.GatewayConnection.run(GatewayConnection.java:211)
  487. at java.lang.Thread.run(Thread.java:745)
  488. Caused by: java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  489. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  490. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  491. ... 99 more
  492. Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  493. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  494. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  495. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  496. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  497. ... 96 more
  498. Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  499. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
  500. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
  501. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
  502. at java.security.AccessController.doPrivileged(Native Method)
  503. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
  504. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
  505. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  506. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  507. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  508. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  509. at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
  510. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  511. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  512. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  513. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  514. at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
  515. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  516. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  517. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  518. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  519. at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
  520. at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
  521. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  522. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  523. at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
  524. at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
  525. at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
  526. at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
  527. at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
  528. ... 96 more
  529. ------
  530. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  531. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  532. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  533. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  534. at com.jolbox.bonecp.PoolUtil.generateSQLException(PoolUtil.java:192)
  535. at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:422)
  536. at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
  537. at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501)
  538. at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298)
  539. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  540. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  541. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  542. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  543. at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
  544. at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
  545. at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
  546. at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
  547. at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
  548. ... 73 more
  549. Caused by: java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  550. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  551. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  552. at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
  553. at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
  554. at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
  555. at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
  556. at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
  557. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  558. at org.apache.derby.jdbc.Driver20.connect(Unknown Source)
  559. at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
  560. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  561. at java.sql.DriverManager.getConnection(DriverManager.java:208)
  562. at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
  563. at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
  564. ... 85 more
  565. Caused by: java.sql.SQLException: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@6b20fc7e, see the next exception for details.
  566. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  567. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  568. ... 99 more
  569. Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  570. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  571. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
  572. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
  573. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  574. ... 96 more
  575. Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /software/zeppelin-0.6.2-bin-all/bin/metastore_db.
  576. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
  577. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
  578. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
  579. at java.security.AccessController.doPrivileged(Native Method)
  580. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
  581. at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
  582. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  583. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  584. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  585. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  586. at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
  587. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  588. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  589. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  590. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  591. at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
  592. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  593. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  594. at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
  595. at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
  596. at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
  597. at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
  598. at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
  599. at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
  600. at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
  601. at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
  602. at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
  603. at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
  604. at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
  605. ... 96 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!