API tools faq
paste
Advertisement
finfoot

metabase-java-no-create-thread

finfoot
Jul 13th, 2018
161
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.45 KB | None | 0 0
raw download clone embed print report
  1. METABASE LOG:
  2.  
  3. ---> first error that was skipped [is that of any importance? what does this do?]
  4. 07-13 09:15:03 INFO metabase.db :: Database Migrations Current ... ✅
  5. com.mchange.v2.cfg.DelayedLogItem [ level -> FINE, text -> "The configuration file for resource identifier 'hocon:/reference,/application,/c3p0,/' could not be found. Skipping.", exception -> null]
  6.  
  7.  
  8. ---> then looking good:
  9. 07-13 09:15:05 INFO metabase.core :: Looks like this is a new installation ... preparing setup wizard
  10. 07-13 09:15:05 INFO metabase.core :: Please use the following url to setup your Metabase installation:
  11. http://localhost:3000/setup/
  12.  
  13.  
  14. ---> ERROR while doing the initial registration under http://localhost:3000/setup/
  15.  
  16. also "top" wasnt available in a second terminal for short time with this outcome:
  17. root@myserver:/home# top
  18. bash: fork: retry: Resource temporarily unavailable
  19.  
  20. ---> further with the log after setting up an admin account and trying to connect to a remote DB (postgresql):
  21. 07-13 09:33:48 ERROR metabase.driver :: Failed to connect to database: java.sql.SQLException: No suitable driver found for jdbc:postgresql://https://myserver.net:5432/mydbase?OpenSourceSubProtocolOverride=true
  22. 07-13 09:33:48 DEBUG metabase.middleware :: POST /api/setup/validate 400 (5 ms) (0 DB calls).
  23. {:errors {:dbname "java.sql.SQLException: No suitable driver found for jdbc:postgresql://https:///myserver:5432/mydbase?OpenSourceSubProtocolOverride=true"}}
  24.  
  25. --> and further log while I was using the web interface.
  26. 07-13 09:36:13 DEBUG metabase.middleware :: POST /api/setup/validate 200 (147 ms) (0 DB calls). Jetty threads: 8/50 (3 busy, 5 idle, 0 queued)
  27. 07-13 09:37:35 INFO models.user :: Adding user 1 to All Users permissions group...
  28. 07-13 09:37:35 INFO models.user :: Adding user 1 to Admin permissions group...
  29. 07-13 09:37:35 DEBUG sync.util :: Sync operations in flight: {:sync #{2}}
  30. 07-13 09:37:35 INFO sync.util :: STARTING: Sync postgres Database 2 'test_win'
  31. 07-13 09:37:35 DEBUG sync.util :: Sync operations in flight: {:sync #{2}, :sync-metadata #{2}}
  32. 07-13 09:37:35 INFO sync.util :: STARTING: Sync metadata for postgres Database 2 'test_win'
  33. 07-13 09:37:35 DEBUG metabase.middleware :: POST /api/setup 200 (527 ms) (20 DB calls). Jetty threads: 8/50 (3 busy, 5 idle, 0 queued)
  34. 07-13 09:37:35 WARN server.HttpChannel :: /api/setup
  35.  
  36. ---> and here is one example of =THE ERROR=
  37. java.lang.OutOfMemoryError: unable to create new native thread
  38. at java.lang.Thread.start0(Native Method)
  39. at java.lang.Thread.start(Thread.java:717)
  40. at java.util.concurrent.ThreadPoolExecutor.addWorker(ThreadPoolExecutor.java:957)
  41. at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1378)
  42. at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
  43. at clojure.core$future_call.invokeStatic(core.clj:6687)
  44. at clojure.core$future_call.invoke(core.clj:6677)
  45. at ring.middleware.gzip$piped_gzipped_input_stream.invokeStatic(gzip.clj:42)
  46. at ring.middleware.gzip$piped_gzipped_input_stream.invoke(gzip.clj:38)
  47. at clojure.lang.AFn.applyToHelper(AFn.java:154)
  48. at clojure.lang.AFn.applyTo(AFn.java:144)
  49. at clojure.core$apply.invokeStatic(core.clj:648)
  50. at clojure.core$update_in.invokeStatic(core.clj:5950)
  51. at clojure.core$update_in.doInvoke(core.clj:5939)
  52. at clojure.lang.RestFn.invoke(RestFn.java:445)
  53. at ring.middleware.gzip$gzipped_response.invokeStatic(gzip.clj:61)
  54. at ring.middleware.gzip$gzipped_response.invoke(gzip.clj:55)
  55. at ring.middleware.gzip$wrap_gzip$fn__54900.invoke(gzip.clj:77)
  56. at ring.adapter.jetty$proxy_handler$fn__54746.invoke(jetty.clj:25)
  57. at ring.adapter.jetty.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
  58. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  59. at org.eclipse.jetty.server.Server.handle(Server.java:499)
  60. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
  61. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
  62. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
  63. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
  64. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
  65. at java.lang.Thread.run(Thread.java:748)
  66.  
  67. ---> and another one
  68. 07-13 09:37:36 ERROR sync.util :: Error running sync step: unable to create new native thread
  69. ("driver.generic_sql.query_processor$do_in_transaction.invokeStatic(query_processor.clj:522)"
  70. "driver.generic_sql.query_processor$do_in_transaction.invoke(query_processor.clj:521)"
  71. "driver.generic_sql.query_processor$run_query_without_timezone.invokeStatic(query_processor.clj:536)"
  72. "driver.generic_sql.query_processor$run_query_without_timezone.invoke(query_processor.clj:535)"
  73. "driver.generic_sql.query_processor$execute_query$fn__51390.invoke(query_processor.clj:558)"
  74. "driver.generic_sql.query_processor$do_with_try_catch.invokeStatic(query_processor.clj:502)"
  75. "driver.generic_sql.query_processor$do_with_try_catch.invoke(query_processor.clj:497)"
  76. "driver.generic_sql.query_processor$execute_query.invokeStatic(query_processor.clj:555)"
  77. "driver.generic_sql.query_processor$execute_query.invoke(query_processor.clj:551)"
  78. "driver$fn__25845$G__25652__25852.invoke(driver.clj:61)"
  79. "driver$make_current_db_time_fn$fn__25961$fn__25962.invoke(driver.clj:358)"
  80. "driver$make_current_db_time_fn$fn__25961.invoke(driver.clj:356)"
  81. "driver$fn__25780$G__25632__25787.invoke(driver.clj:61)"
  82. "sync.sync_metadata.sync_timezone$fn__35243$sync_timezone_BANG___35248$fn__35249.invoke(sync_timezone.clj:20)"
  83. "sync.sync_metadata.sync_timezone$fn__35243$sync_timezone_BANG___35248.invoke(sync_timezone.clj:13)"
  84. "sync.sync_metadata$fn__35485$sync_db_metadata_BANG___35490$fn__35491$fn__35492.invoke(sync_metadata.clj:24)"
  85. "sync.util$do_with_error_handling.invokeStatic(util.clj:124)"
  86. "sync.util$do_with_error_handling.invoke(util.clj:119)"
  87. "sync.util$do_with_error_handling.invokeStatic(util.clj:122)"
  88. "sync.util$do_with_error_handling.invoke(util.clj:119)"
  89. "driver$fn__25884.invokeStatic(driver.clj:245)"
  90. "driver$fn__25884.invoke(driver.clj:245)"
  91. "driver$fn__25819$G__25626__25828.invoke(driver.clj:61)"
  92. "sync.util$sync_in_context$fn__32553.invoke(util.clj:115)"
  93. "sync.util$with_db_logging_disabled$fn__32550.invoke(util.clj:106)"
  94. "sync.util$with_start_and_finish_logging$fn__32545.invoke(util.clj:92)"
  95. "sync.util$with_sync_events$fn__32542.invoke(util.clj:75)"
  96. "sync.util$with_duplicate_ops_prevented$fn__32533.invoke(util.clj:54)"
  97. "sync.util$do_sync_operation.invokeStatic(util.clj:142)"
  98. "sync.util$do_sync_operation.invoke(util.clj:139)"
  99. "sync.sync_metadata$fn__35485$sync_db_metadata_BANG___35490$fn__35491.invoke(sync_metadata.clj:23)"
  100. "sync.sync_metadata$fn__35485$sync_db_metadata_BANG___35490.invoke(sync_metadata.clj:20)"
  101. "sync$fn__35535$sync_database_BANG___35540$fn__35541$fn__35542.invoke(sync.clj:28)"
  102. "sync.util$do_with_error_handling.invokeStatic(util.clj:124)"
  103. "sync.util$do_with_error_handling.invoke(util.clj:119)"
  104. "sync.util$do_with_error_handling.invokeStatic(util.clj:122)"
  105. "sync.util$do_with_error_handling.invoke(util.clj:119)"
  106. "driver$fn__25884.invokeStatic(driver.clj:245)"
  107. "driver$fn__25884.invoke(driver.clj:245)"
  108. "driver$fn__25819$G__25626__25828.invoke(driver.clj:61)"
  109. "sync.util$sync_in_context$fn__32553.invoke(util.clj:115)"
  110. "sync.util$with_db_logging_disabled$fn__32550.invoke(util.clj:106)"
  111. "sync.util$with_start_and_finish_logging$fn__32545.invoke(util.clj:92)"
  112. "sync.util$with_sync_events$fn__32542.invoke(util.clj:75)"
  113. "sync.util$with_duplicate_ops_prevented$fn__32533.invoke(util.clj:54)"
  114. "sync.util$do_sync_operation.invokeStatic(util.clj:142)"
  115. "sync.util$do_sync_operation.invoke(util.clj:139)"
  116. "sync$fn__35535$sync_database_BANG___35540$fn__35541.invoke(sync.clj:26)"
  117. "sync$fn__35535$sync_database_BANG___35540.invoke(sync.clj:19)"
  118. "events.sync_database$process_sync_database_event$fn__55998.invoke(sync_database.clj:34)")
  119.  
  120. --> This looks again ok:
  121. 07-13 09:37:36 INFO sync.util :: FINISHED: Sync metadata for postgres Database 2 'test_win' (543 ms)
  122. 07-13 09:37:36 DEBUG sync.util :: Sync operations in flight: {:sync #{2}, :analyze #{2}}
  123. 07-13 09:37:36 INFO sync.util :: STARTING: Analyze data for postgres Database 2 'test_win'
  124. 07-13 09:37:36 INFO sync.util :: FINISHED: Analyze data for postgres Database 2 'test_win' (3 ms)
  125. 07-13 09:37:36 DEBUG sync.util :: Sync operations in flight: {:sync #{2}, :cache-field-values #{2}}
  126. 07-13 09:37:36 INFO sync.util :: STARTING: Cache field values in postgres Database 2 'test_win'
  127. 07-13 09:37:36 INFO sync.util :: FINISHED: Cache field values in postgres Database 2 'test_win' (811 µs)
  128. 07-13 09:37:36 INFO sync.util :: FINISHED: Sync postgres Database 2 'test_win' (569 ms)
  129. 07-13 09:37:39 DEBUG metabase.middleware :: POST /api/setup 400 (4 ms) (0 DB calls).
  130.  
  131. --> This not:
  132. {:errors {:token "Token does not match the setup token."}}
  133.  
  134. ----> "top" shows java using most resources but nothing is happening at the http://localhost:3000/setup/ when clicking "Next"
  135. Top:
  136. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
  137. 10976 finfoot 20 0 3142228 1.200g 19652 S 1.0 60.0 2:30.42 java
  138. 11396 root 20 0 42684 1864 1384 R 0.3 0.1 0:00.15 top
  139.  
  140.  
  141. some further reading from top for java
  142. MEMORY stays at 60.1. CPU use is changing but process is sleeping...
  143.  
  144. 10976 finfoot 20 0 3142228 1.201g 19652 S 1.0 60.1 2:44.56 java
  145. 10976 finfoot 20 0 3142228 1.201g 19652 S 0.7 60.1 2:44.58 java
  146. 10976 finfoot 20 0 3142228 1.201g 19652 S 1.3 60.1 2:44.62 java
  147. 10976 finfoot 20 0 3142228 1.201g 19652 S 0.7 60.1 2:44.64 java
  148. 10976 finfoot 20 0 3142228 1.201g 19652 S 0.7 60.1 2:44.66 java
  149. 10976 finfoot 20 0 3142228 1.201g 19652 S 1.0 60.1 2:44.69 java
  150. 10976 finfoot 20 0 3142228 1.201g 19652 S 1.0 60.1 2:44.72 java
  151. 10976 finfoot 20 0 3142228 1.201g 19652 S 0.7 60.1 2:44.74 java
  152. 10976 finfoot 20 0 3142228 1.201g 19652 S 1.0 60.1 2:44.77 java
  153. 10976 finfoot 20 0 3142228 1.201g 19652 S 0.7 60.1 2:44.79 java
  154. 10976 finfoot 20 0 3142228 1.201g 19652 S 0.3 60.1 2:44.80 java
  155. 10976 finfoot 20 0 3142228 1.201g 19652 S 1.0 60.1 2:44.83 java
  156.  
  157.  
  158.  
  159. ------> next try:
  160.  
  161. pkill java
  162.  
  163. start metabase again (/etc/init.d/metabase start)
  164. many times in the log: unable to create new thread.
  165. According to the log the DBs (the sample database and the external one I tried to connect before) were successfully analyzed
  166. But nothing accessabel through localhost:3000 [/setup... /admin etc.]
  167. HTTP ERROR: 500 unable to create native thread
  168.  
  169. after stopping metabase with: /etc/init.d/metabase stop
  170. this comes up in the log:
  171. OpenJDK 64-Bit Server VM warning: Exception java.lang.OutOfMemoryError occurred dispatching signal SIGTERM to handler- the VM may need to be forcibly terminated
  172.  
  173. This time java is using a little less but still a lot: 41% of memory
  174. from:top | grep java
  175. 12398 finfoot 20 0 3134708 858812 19584 S 0.0 41.0 1:07.97 java
  176. 12398 finfoot 20 0 3134708 858812 19584 S 0.7 41.0 1:07.99 java
  177. 12398 finfoot 20 0 3134708 858812 19584 S 0.7 41.0 1:08.01 java
  178.  
  179. The webinterface is not reacting at all. Always HTTP ERROR: 500
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!