Issues with connecting to ciab on Linux Server

Help
1

I spun up yesterday a ciab free lincense instance on a Poweredge 2x Xeon + 768GB RAM.

I use the following docker-compose to spin it up:

version: '2'
services:
  memsql:
    cpus: 2
    mem_limit: 64g
    image: 'memsql/cluster-in-a-box:latest'
    ports:
      - 3336:3306
      - 9090:8080
    environment:
      LICENSE_KEY: 'long_license_key'
      ROOT_PASSWORD: 'complex_password'
      START_AFTER_INIT: 'Y'

I have hidden the real license key and password in the copy above.

I run docker-compose up and it spins up ok, only issue I notice in the log is:

memsql_1 | 03448809 2022-10-17 04:53:24.984 ERROR: Cannot open license key file at '/opt/singlestoredb-server-7.8.17-69cee1f1a3/lib/license'

I open studio by going to http://localhost:9090 and it opens on login screen. When I type root / complex_password, the UI responds with incorrect credentials, try again

In the logs, when I try and log in to Studio, I see:

memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:56 +0000] "GET /proxy?hostname=localhost&port=3306 HTTP/1.1" 200 0

But I cannot get it to connect, nor Table Plus. The full log is below.

What are the max settings for CPU and Memory I can use on ciab?

What could be the issued with my setup that is stopping connections locally?

papa@monster:~/singlestore$ sudo docker-compose up
[sudo] password for papa:
Starting singlestore_memsql_1 … done
Attaching to singlestore_memsql_1
memsql_1 | Starting Cluster
memsql_1 | {}
memsql_1 | ==> /var/lib/memsql/01158d42-48cf-4173-b8e0-2e0c6d42a17c/tracelogs/memsql.log <==
memsql_1 | 04094281 2022-10-17 04:53:25.624 INFO: Safe Restart Thread: Thread 115023: ReconcileRefDbsWithMetadata: Reconciling reference databases with metadata.
memsql_1 | 04094329 2022-10-17 04:53:25.624 INFO: Safe Restart Thread: Thread 115023: ReconcileRefDbsWithMetadata: Done reconciling reference databases with metadata.
memsql_1 | 04100310 2022-10-17 04:53:25.630 INFO: Safe Restart Thread: Thread 115023: WaitForLSNWithTimeout: Sync ReplicationManagement success sync to lsn 0xb. ReplicationManagement thread at 0xb.
memsql_1 | 04100362 2022-10-17 04:53:25.630 INFO: Safe Restart Thread: Thread 115023: SafeRestartThreadFn: Safe Restart completed.
memsql_1 | 04119691 2022-10-17 04:53:25.649 INFO: Query information_schema.‘SELECT @@memsql_id’ submitted for asynchronous compilation
memsql_1 | 04201964 2022-10-17 04:53:25.732 INFO: Query information_schema.‘SELECT node_id FROM INFORMATION_SCHEMA.lmv_nodes’ submitted for asynchronous compilation
memsql_1 | 04206466 2022-10-17 04:53:25.736 INFO: Query information_schema.‘SELECT @@memsql_id’ submitted 89 milliseconds ago, queued for 6 milliseconds, compiled asynchronously in 83 milliseconds
memsql_1 | 04227756 2022-10-17 04:53:25.757 INFO: Query information_schema.‘SELECT @@memsql_version’ submitted for asynchronous compilation
memsql_1 | 04497480 2022-10-17 04:53:26.027 INFO: Query information_schema.‘SELECT node_id FROM INFORMATION_SCHEMA.lmv_nodes’ submitted 301 milliseconds ago, queued for 8 milliseconds, compiled asynchronously in 293 milliseconds
memsql_1 | 04499257 2022-10-17 04:53:26.029 INFO: Query information_schema.‘SELECT @@memsql_version’ submitted 274 milliseconds ago, queued for 5 milliseconds, compiled asynchronously in 269 milliseconds
memsql_1 |
memsql_1 | ==> /var/lib/memsql/7ac01f73-bc03-4e77-a536-b3dae32936b4/tracelogs/memsql.log <==
memsql_1 | 03448809 2022-10-17 04:53:24.984 ERROR: Cannot open license key file at ‘/opt/singlestoredb-server-7.8.17-69cee1f1a3/lib/license’
memsql_1 | 03450152 2022-10-17 04:53:24.986 INFO: System Information: sockets (2), physical cores (20), virtual cores (40), model name (Intel(R) Xeon(R) CPU E5-2660 v3 @ 2.60GHz), memory (270360875008), uname (Linux a78ee7438544 5.15.0-50-generic #56-Ubuntu SMP Tue Sep 20 13:23:26 UTC 2022 x86_64)
memsql_1 | 03450188 2022-10-17 04:53:24.986 INFO: Thread 115121: UpgradeShardedDbIdForKalm: Starting sharded db id upgrade for kalm.
memsql_1 | 03450288 2022-10-17 04:53:24.986 INFO: Completed recovery of system databases. Beginning recovery of user databases.
memsql_1 | 03454234 2022-10-17 04:53:24.990 INFO: Initializing cluster management.
memsql_1 | 03454263 2022-10-17 04:53:24.990 INFO: Consensus node started…
memsql_1 | 03454674 2022-10-17 04:53:24.990 INFO: Thread 115021: Fn: Initializing Replication Management Thread
memsql_1 | 03454796 2022-10-17 04:53:24.990 INFO: Starting the accept loop.
memsql_1 | 04231058 2022-10-17 04:53:25.767 INFO: Query information_schema.‘SELECT node_id FROM INFORMATION_SCHEMA.lmv_nodes’ submitted for asynchronous compilation
memsql_1 | 04257454 2022-10-17 04:53:25.793 INFO: Query information_schema.‘SELECT @@memsql_version’ submitted for asynchronous compilation
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 |
memsql_1 | ==> /var/lib/memsql/memsql_exporter.log <==
memsql_1 |
memsql_1 | ==> /var/lib/memsql/7ac01f73-bc03-4e77-a536-b3dae32936b4/tracelogs/memsql.log <==
memsql_1 | 04592394 2022-10-17 04:53:26.128 INFO: Query information_schema.‘SELECT node_id FROM INFORMATION_SCHEMA.lmv_nodes’ submitted 365 milliseconds ago, queued for 6 milliseconds, compiled asynchronously in 359 milliseconds
memsql_1 | 04594650 2022-10-17 04:53:26.130 INFO: Query information_schema.‘SELECT @@memsql_version’ submitted 340 milliseconds ago, queued for 5 milliseconds, compiled asynchronously in 335 milliseconds
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 | 2022/10/17 04:53:26 env.go:90 Log Opened
memsql_1 | 2022/10/17 04:53:26 server.go:74 Listening on 0.0.0.0:8080
memsql_1 | 2022/10/17 04:53:26 server.go:93 HTTPS configuration was not detected, serving with HTTP
memsql_1 |
memsql_1 | ==> /var/lib/memsql/memsql_exporter.log <==
memsql_1 | ime=“2022-10-17T04:53:26Z” level=info msg=“Arguments: [@/opt/singlestoredb-server-7.8.17-69cee1f1a3/memsql_exporter/conf/memsql_exporter_ma.args]” source=“memsql_exporter.go:764”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Starting memsql_exporter (version=7.8.17, branch=, revision=69cee1f)” source=“memsql_exporter.go:779”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Build context (go=devel +2a0dd053ec Fri Feb 5 19:53:15 2021 +0000, user=, date=)” source=“memsql_exporter.go:780”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Read DSN from /etc/memsql/memsql_exporter.cnf” source=“memsql_exporter.go:805”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Enabled scrapers:” source=“memsql_exporter.go:821”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.global_status_gauge_vars" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.memory.counters" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.distributed.partitions" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.events" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.tables" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.processlist" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.tablestats" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.global_status_counting_vars" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.mv_activities" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.mv_activities_extended_cumulative" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.system_info" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.pipeline_batches" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.info_schema.mv_nodes" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.show_workload_management_status" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.show_status_extended" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --collect.show_variables" source=“memsql_exporter.go:825”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Enabled cluster scrapers:” source=“memsql_exporter.go:833”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.distributed.partitions" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_activities" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_workload_management_status" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.system_info" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.tables" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_processlist" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.tablestats" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.events" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_activities_extended_cumulative" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.pipeline_batches" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_nodes" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_global_status" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_global_variables" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_sysinfo_mem" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_sysinfo_disk" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_sysinfo_net" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --cluster-collect.info_schema.mv_sysinfo_cpu" source=“memsql_exporter.go:837”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Enabled samplers:” source=“memsql_exporter.go:844”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --sample.events" source=“memsql_exporter.go:848”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --sample.node" source=“memsql_exporter.go:848”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --sample.activity" source=“memsql_exporter.go:848”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --sample.activity_extended" source=“memsql_exporter.go:848”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --sample.pipeline_batches" source=“memsql_exporter.go:848”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=" --sample.cluster_info" source=“memsql_exporter.go:848”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Notify OK” source=“memsql_exporter.go:911”
memsql_1 | time=“2022-10-17T04:53:26Z” level=info msg=“Listening on :9104” source=“memsql_exporter.go:919”
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:53:30 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:53:35 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:53:40 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:53:45 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:53:50 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:53:55 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:00 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:05 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:10 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:15 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:20 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 |
memsql_1 | ==> /var/lib/memsql/01158d42-48cf-4173-b8e0-2e0c6d42a17c/tracelogs/memsql.log <==
memsql_1 | 64128676 2022-10-17 04:54:25.658 INFO: Query (null).‘SELECT TABLE_NAME, DATABASE_NAME, PARTITION, CHANGED, TOKEN FROM INFORMATION_SCHEMA.MV_ROW_CHANGE_COUNTS WHERE (CHANGED > @ OR PARTITION > @) ORDER BY DATABASE_NAME ASC, TABLE_NAME ASC, PARTITION ASC /* stats_collection_query /’ submitted for asynchronous compilation
memsql_1 | 64167807 2022-10-17 04:54:25.698 INFO: Query information_schema.'SELECT WITH(binary_serialization_internal=1) MV_ROW_CHANGE_COUNTS.TABLE_NAME AS TABLE_NAME, MV_ROW_CHANGE_COUNTS.DATABASE_NAME AS DATABASE_NAME, MV_ROW_CHANGE_COUNTS.PARTITION AS PARTITION, MV_ROW_CHANGE_COUNTS.CHANGED AS CHANGED, MV_ROW_CHANGE_COUNTS.TOKEN AS TOKEN FROM ( SELECT _MV_ROW_CHANGE_COUNTS.TABLE_NAME AS TABLE_NAME, _MV_ROW_CHANGE_COUNTS.DATABASE_NAME AS DATABASE_NAME, _MV_ROW_CHANGE_COUNTS.PARTITION AS PARTITION, _MV_ROW_CHANGE_COUNTS.CHANGED AS CHANGED, _MV_ROW_CHANGE_COUNTS.TOKEN AS TOKEN FROM _MV_ROW_CHANGE_COUNTS as _MV_ROW_CHANGE_COUNTS WITH (disable_encoded_joins = TRUE) WHERE (((_MV_ROW_CHANGE_COUNTS.CHANGED > @) OR (_MV_ROW_CHANGE_COUNTS.PARTITION > @)) AND (NOT @)) ) AS MV_ROW_CHANGE_COUNTS ORDER BY 2, 1, 3 /!90623 OPTION(NO_QUERY_REWRITE=1, INTERPRETER_MODE=INTERPRET_FIRST)/’ submitted for asynchronous compilation
memsql_1 | 64373468 2022-10-17 04:54:25.903 INFO: Query (null).'SELECT TABLE_NAME, DATABASE_NAME, PARTITION, CHANGED, TOKEN FROM INFORMATION_SCHEMA.MV_ROW_CHANGE_COUNTS WHERE (CHANGED > @ OR PARTITION > @) ORDER BY DATABASE_NAME ASC, TABLE_NAME ASC, PARTITION ASC / stats_collection_query /’ submitted 256 milliseconds ago, queued for 14 milliseconds, compiled asynchronously in 242 milliseconds
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:25 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 |
memsql_1 | ==> /var/lib/memsql/01158d42-48cf-4173-b8e0-2e0c6d42a17c/tracelogs/memsql.log <==
memsql_1 | 64576647 2022-10-17 04:54:26.106 INFO: Query information_schema.'SELECT WITH(binary_serialization_internal=1) MV_ROW_CHANGE_COUNTS.TABLE_NAME AS TABLE_NAME, MV_ROW_CHANGE_COUNTS.DATABASE_NAME AS DATABASE_NAME, MV_ROW_CHANGE_COUNTS.PARTITION AS PARTITION, MV_ROW_CHANGE_COUNTS.CHANGED AS CHANGED, MV_ROW_CHANGE_COUNTS.TOKEN AS TOKEN FROM ( SELECT _MV_ROW_CHANGE_COUNTS.TABLE_NAME AS TABLE_NAME, _MV_ROW_CHANGE_COUNTS.DATABASE_NAME AS DATABASE_NAME, _MV_ROW_CHANGE_COUNTS.PARTITION AS PARTITION, _MV_ROW_CHANGE_COUNTS.CHANGED AS CHANGED, _MV_ROW_CHANGE_COUNTS.TOKEN AS TOKEN FROM _MV_ROW_CHANGE_COUNTS as _MV_ROW_CHANGE_COUNTS WITH (disable_encoded_joins = TRUE) WHERE (((_MV_ROW_CHANGE_COUNTS.CHANGED > @) OR (_MV_ROW_CHANGE_COUNTS.PARTITION > @)) AND (NOT @)) ) AS MV_ROW_CHANGE_COUNTS ORDER BY 2, 1, 3 /!90623 OPTION(NO_QUERY_REWRITE=1, INTERPRETER_MODE=INTERPRET_FIRST)*/’ submitted 425 milliseconds ago, queued for 19 milliseconds, compiled asynchronously in 406 milliseconds
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:30 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:35 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:40 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:45 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:50 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:54:55 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:00 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:05 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:10 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /connect/localhost HTTP/1.1” 200 2745
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/node_modules/.pnpm/typeface-inconsolata@0.0.44/node_modules/typeface-inconsolata/files/inconsolata-latin-400.woff2 HTTP/1.1” 200 17009
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/node_modules/.pnpm/monaco-editor@0.20.0/node_modules/monaco-editor/esm/vs/base/browser/ui/codiconLabel/codicon/codicon.ttf HTTP/1.1” 200 36552
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/node_modules/.pnpm/typeface-inconsolata@0.0.44/node_modules/typeface-inconsolata/files/inconsolata-latin-700.woff2 HTTP/1.1” 200 19905
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/styles.62c8dd348c76e0859f84.js HTTP/1.1” 200 232
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/styles.62c8dd348c76e0859f84.css HTTP/1.1” 200 57148
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/block-browser.66898e020a384fe14740.js HTTP/1.1” 200 2303
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/node_modules/.pnpm/oauth2+glpat-oetDejvNzUjw82XGUQqx@gitlab.com+singl_ed6dcf9fbcc31dd08837e88cc478b676/node_modules/@single-js/common/lib/components/form/select-arrow.svg HTTP/1.1” 200 283
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/vendors~app~block-browser.e5094f5efa4d1311a305.js HTTP/1.1” 200 146184
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/app.9e3bb612a565a3a2c0da.js HTTP/1.1” 200 392327
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/src/assets/images/banner-logo.svg HTTP/1.1” 200 3925
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/vendors~cluster-controller~create-cluster.8d9171c865f0de7532e5.js HTTP/1.1” 200 14032
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/src/assets/images/banner.svg HTTP/1.1” 200 1011
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/node_modules/.pnpm/typeface-lato@0.0.44/node_modules/typeface-lato/files/lato-latin-400.woff2 HTTP/1.1” 200 23336
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/cluster-controller.bb847a4bf6f1cbc497e5.js HTTP/1.1” 200 43562
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/f982f5d5dc6bdbd18ac1.worker.js HTTP/1.1” 200 282316
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:12 +0000] “GET /dist/vendors~cluster-controller.ebe8dc12efeee60fcacf.js HTTP/1.1” 200 791257
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:13 +0000] “GET /api/clusters HTTP/1.1” 200 274
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:13 +0000] “GET /dist/favicon.ico HTTP/1.1” 200 6534
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:13 +0000] “GET /dist/node_modules/.pnpm/typeface-lato@0.0.44/node_modules/typeface-lato/files/lato-latin-700.woff2 HTTP/1.1” 200 22820
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:55:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 |
memsql_1 | ==> /var/lib/memsql/01158d42-48cf-4173-b8e0-2e0c6d42a17c/tracelogs/memsql.log <==
memsql_1 | 172621112 2022-10-17 04:56:14.151 ERROR: [0 messages supressed] ProcessHandshakeResponsePacket() failed. Sending back 1045: Access denied for user ‘root’@‘localhost’ (using password: YES)
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:14 +0000] “GET /proxy?hostname=localhost&port=3306 HTTP/1.1” 200 0
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:56:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:57:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:58:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:04:59:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:00:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:01:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:02:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:08 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:13 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:18 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:23 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 |
memsql_1 | ==> /var/lib/memsql/01158d42-48cf-4173-b8e0-2e0c6d42a17c/tracelogs/memsql.log <==
memsql_1 | 603719832 2022-10-17 05:03:25.250 INFO: Query (null).‘SELECT HEARTBEAT_NO_LOGGING agg.AGGREGATOR_ACTIVITY_NAME, coalesce(sum(leaves.memory_bs)*1000/agg.elapsed_time_ms/0x400/0x400, 0):>bigint,coalesce(agg.elapsed_time_ms/agg.numRuns, @):>bigint as avg_runtime, coalesce(sum(leaves.cpu_time_ms)/agg.numRuns, @):>bigint as avg_cpu_time FROM (select aggregator_activity_name, sum(elapsed_time_ms) as elapsed_time_ms, sum(success_count) as numRuns from information_schema._WM_AGG_TABLE group by 1) agg left join information_schema._WM_LEAF_TABLE leaves on agg.aggregator_activity_name = leaves.aggregator_activity_name group by agg.AGGREGATOR_ACTIVITY_NAME’ submitted for asynchronous compilation
memsql_1 | 604528876 2022-10-17 05:03:26.059 INFO: Query (null).‘SELECT HEARTBEAT_NO_LOGGING agg.AGGREGATOR_ACTIVITY_NAME, coalesce(sum(leaves.memory_bs)*1000/agg.elapsed_time_ms/0x400/0x400, 0):>bigint,coalesce(agg.elapsed_time_ms/agg.numRuns, @):>bigint as avg_runtime, coalesce(sum(leaves.cpu_time_ms)/agg.numRuns, @):>bigint as avg_cpu_time FROM (select aggregator_activity_name, sum(elapsed_time_ms) as elapsed_time_ms, sum(success_count) as numRuns from information_schema._WM_AGG_TABLE group by 1) agg left join information_schema._WM_LEAF_TABLE leaves on agg.aggregator_activity_name = leaves.aggregator_activity_name group by agg.AGGREGATOR_ACTIVITY_NAME’ submitted 847 milliseconds ago, queued for 41 milliseconds, compiled asynchronously in 806 milliseconds
memsql_1 |
memsql_1 | ==> /var/lib/singlestoredb-studio/studio.log <==
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:28 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:33 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:38 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:43 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:48 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:53 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:03:58 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:03 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:09 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:14 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:19 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:24 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:29 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:34 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:39 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:44 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:49 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:54 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:56 +0000] “GET /proxy?hostname=localhost&port=3306 HTTP/1.1” 200 0
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:04:59 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:05:04 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:05:09 +0000] “GET /api/ping HTTP/1.1” 200 17
memsql_1 | 172.27.0.1 - - [17/Oct/2022:05:05:14 +0000] “GET /api/ping HTTP/1.1” 200 17
m

2

Cluster-in-a-box (CIAB) is typically used with a free license. The limits for the free license are shown here:

I don’t have a specific solution for you, but if you go to the free trial page for on-prem and go through the steps, it will give you a free version license from portal.singlestore.com

Then you can use that license wherever needed. You could side step the problem by using sdb-deploy and sdb-admin to install a cluster with one aggregator and one leaf. Use the license from the portal when needed in the installation steps.

1 Like