Problems running as Windows service

Get Help
1

I'm having some issue.

I opened a cmd as Admin.
Here is how I configured NSSM :

metabase

metabase2

Service is in Auto and running :
metabase4

Two tables has been created :
metabase

The error I receive when I try to access http://localhost:3000/setup :

ERR_CONNECTION_REFUSED

2

@Exe Completely different errors and problems. Check the logs. Your service name is not the same, so sounds like you got multiple things running. Delete everything, make sure it's shut down and start over.

3

It was a typo error. Fixed my question. Is there a way to check logs ?

4

@Exe I would highly recommend that you read the NSSM documentation, so you can see where logs are being stored - the "I/O" tab.

Use Java 11 or 17, not 18: https://www.metabase.com/docs/latest/operations-guide/java-versions.html

5

I'm now using Java 17. I noticed when I remove all environment variable, it's working fine. When I add the environment variable, Metabase doesn't start but it creates two table in my MySQL db. What can I check ?

MB_DB_TYPE=mysql
MB_DB_DBNAME=metabaseappdb
MB_DB_PORT=3306
MB_DB_USER=root
MB_DB_PASS=SECRET
MB_DB_HOST=localhost
6

@Exe Without seeing the logs it's impossible to know what the problem is.

7

I checked my task manager and Java(TM) Platform SE binary is eating my CPU.
It happened when I run Metabase-Service.

metabase_proc
metabase_proc664×590 25.2 KB

Here is my CPU

cpu

Log :

#
# There is insufficient memory for the Java Runtime Environment to continue.
# Native memory allocation (mmap) failed to map 197132288 bytes for G1 virtual space
# Possible reasons:
# The system is out of physical RAM or swap space
# The process is running with CompressedOops enabled, and the Java Heap may be blocking the growth of the native heap
# Possible solutions:
# Reduce memory load on the system
# Increase physical memory or swap space
# Check if swap backing store is full
# Decrease Java heap size (-Xmx/-Xms)
# Decrease number of Java threads
# Decrease Java thread stack sizes (-Xss)
# Set larger code cache with -XX:ReservedCodeCacheSize=
# JVM is running with Zero Based Compressed Oops mode in which the Java heap is
# placed in the first 32GB address space. The Java Heap base address is the
# maximum limit for the native heap growth. Please use -XX:HeapBaseMinAddress
# to set the Java Heap base and to place the Java Heap above 32GB virtual address.
# This output file may be truncated or incomplete.
#
# Out of Memory Error (os_windows.cpp:3535), pid=26112, tid=11224
#
# JRE version: Java(TM) SE Runtime Environment (17.0.3.1+2) (build 17.0.3.1+2-LTS-6)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (17.0.3.1+2-LTS-6, mixed mode, sharing, tiered, compressed oops, compressed class ptrs, g1 gc, windows-amd64)
# Core dump will be written. Default location: E:\Metabase\hs_err_pid24316.mdmp
#

8

@Exe I don't know what the problem is. You must have some incorrect setup somewhere. I don't use Windows, so I cannot help you. Try using Docker instead, which also exists on Windows.