search

walterwanderley / sqlc-grpc

Create a gRPC server from code generated by sqlc
MIT License
126 stars 13 forks source link

authors example has some issues #6

Closed gedw99 closed 1 year ago

gedw99 commented 1 year ago

Grapha and minio is up

Swagger not up.

I ran gen.sh first and then docker-compose up.

I use podman with the docker and docker compose alias's.

I on on v0.15.4. I tried main also. Exactly same problem

any ideas ?

sqlite && docker-compose up
[+] Running 5/0
 ✔ Container sqlite-prometheus-1     Created                                                                        0.0s 
 ✔ Container sqlite-minio-1          Created                                                                        0.0s 
 ✔ Container sqlite-grafana-1        Created                                                                        0.0s 
 ✔ Container sqlite-app-1            Created                                                                        0.0s 
 ✔ Container sqlite-createbuckets-1  Created                                                                        0.0s 
Attaching to sqlite-app-1, sqlite-createbuckets-1, sqlite-grafana-1, sqlite-minio-1, sqlite-prometheus-1
sqlite-app-1            | [00] Starting service
sqlite-createbuckets-1  | mc: <ERROR> Unable to initialize new alias from the provided credentials. Get "http://minio:9000/probe-bucket-sign-k9wtvvkvzzli/?location=": dial tcp 10.89.0.5:9000: connect: connection refused.
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.489Z caller=main.go:520 level=info msg="No time or size retention was set so using the default time retention" duration=15d
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.509Z caller=main.go:564 level=info msg="Starting Prometheus Server" mode=server version="(version=2.43.0, branch=HEAD, revision=edfc3bcd025dd6fe296c167a14a216cab1e552ee)"
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.513Z caller=main.go:569 level=info build_context="(go=go1.19.7, platform=linux/amd64, user=root@8a0ee342e522, date=20230321-12:56:07, tags=netgo,builtinassets)"
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.517Z caller=main.go:570 level=info host_details="(Linux 6.2.8-200.fc37.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Mar 22 19:11:02 UTC 2023 x86_64 9ef338ce7d0a (none))"
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.518Z caller=main.go:571 level=info fd_limits="(soft=524288, hard=524288)"
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.534Z caller=main.go:572 level=info vm_limits="(soft=unlimited, hard=unlimited)"
sqlite-prometheus-1     | ts=2023-04-10T12:22:13.976Z caller=web.go:561 level=info component=web msg="Start listening for connections" address=0.0.0.0:9090
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.054Z caller=main.go:1005 level=info msg="Starting TSDB ..."
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.149Z caller=dir_locker.go:77 level=warn component=tsdb msg="A lockfile from a previous execution already existed. It was replaced" file=/prometheus/data/lock
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.313Z caller=tls_config.go:232 level=info component=web msg="Listening on" address=[::]:9090
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.321Z caller=tls_config.go:235 level=info component=web msg="TLS is disabled." http2=false address=[::]:9090
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.591Z caller=head.go:587 level=info component=tsdb msg="Replaying on-disk memory mappable chunks if any"
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.610Z caller=head.go:658 level=info component=tsdb msg="On-disk memory mappable chunks replay completed" duration=100.999µs
sqlite-prometheus-1     | ts=2023-04-10T12:22:14.617Z caller=head.go:664 level=info component=tsdb msg="Replaying WAL, this may take a while"
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.005Z caller=head.go:735 level=info component=tsdb msg="WAL segment loaded" segment=0 maxSegment=2
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.032Z caller=head.go:735 level=info component=tsdb msg="WAL segment loaded" segment=1 maxSegment=2
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.037Z caller=head.go:735 level=info component=tsdb msg="WAL segment loaded" segment=2 maxSegment=2
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.055Z caller=head.go:772 level=info component=tsdb msg="WAL replay completed" checkpoint_replay_duration=157.999µs wal_replay_duration=437.259916ms wbl_replay_duration=15µs total_replay_duration=445.196878ms
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.097Z caller=main.go:1026 level=info fs_type=XFS_SUPER_MAGIC
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.105Z caller=main.go:1029 level=info msg="TSDB started"
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.175Z caller=main.go:1209 level=info msg="Loading configuration file" filename=/etc/config/prometheus.yml
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.446Z caller=main.go:1246 level=info msg="Completed loading of configuration file" filename=/etc/config/prometheus.yml totalDuration=271.058708ms db_storage=26µs remote_storage=34µs web_handler=14µs query_engine=15µs scrape=40.914805ms scrape_sd=100.999µs notify=25µs notify_sd=18µs rules=25µs tracing=133.999µs
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.508Z caller=main.go:990 level=info msg="Server is ready to receive web requests."
sqlite-prometheus-1     | ts=2023-04-10T12:22:15.523Z caller=manager.go:974 level=info component="rule manager" msg="Starting rule manager..."
sqlite-createbuckets-1  | Bucket created successfully `myminio/somebucketname`.
sqlite-createbuckets-1  | mc: Please use 'mc anonymous'
sqlite-minio-1          | MinIO Object Storage Server
sqlite-minio-1          | Copyright: 2015-2023 MinIO, Inc.
sqlite-minio-1          | License: GNU AGPLv3 <https://www.gnu.org/licenses/agpl-3.0.html>
sqlite-minio-1          | Version: RELEASE.2023-04-07T05-28-58Z (go1.20.3 linux/amd64)
sqlite-minio-1          | 
sqlite-minio-1          | Status:         1 Online, 0 Offline. 
sqlite-minio-1          | API: http://10.89.0.5:9000  http://127.0.0.1:9000     
sqlite-minio-1          | Console: http://10.89.0.5:9001 http://127.0.0.1:9001   
sqlite-minio-1          | 
sqlite-minio-1          | Documentation: https://min.io/docs/minio/linux/index.html
sqlite-minio-1          | Warning: The standard parity is set to 0. This can lead to data loss.
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.165294853Z level=info msg="Starting Grafana" version=9.4.7 commit=4add91f03d branch=HEAD compiled=2023-03-16T23:56:52Z
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.198932692Z level=warn msg="\"sentry\" frontend logging provider is deprecated and will be removed in the next major version. Use \"grafana\" provider instead."
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.20144368Z level=info msg="Config loaded from" file=/usr/share/grafana/conf/defaults.ini
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.207613651Z level=info msg="Config loaded from" file=/etc/grafana/grafana.ini
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.210742636Z level=info msg="Config overridden from command line" arg="default.paths.data=/var/lib/grafana"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.211534632Z level=info msg="Config overridden from command line" arg="default.paths.logs=/var/log/grafana"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.238635503Z level=info msg="Config overridden from command line" arg="default.paths.plugins=/var/lib/grafana/plugins"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.244856473Z level=info msg="Config overridden from command line" arg="default.paths.provisioning=/etc/grafana/provisioning"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.249893449Z level=info msg="Config overridden from command line" arg="default.log.mode=console"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.251173443Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_DATA=/var/lib/grafana"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.25820341Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_LOGS=/var/log/grafana"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.265415375Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_PLUGINS=/var/lib/grafana/plugins"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.266438371Z level=info msg="Config overridden from Environment variable" var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.267039368Z level=info msg="Path Home" path=/usr/share/grafana
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.267884364Z level=info msg="Path Data" path=/var/lib/grafana
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.286100277Z level=info msg="Path Logs" path=/var/log/grafana
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.287173272Z level=info msg="Path Plugins" path=/var/lib/grafana/plugins
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.288096267Z level=info msg="Path Provisioning" path=/etc/grafana/provisioning
sqlite-grafana-1        | logger=settings t=2023-04-10T12:22:20.288862264Z level=info msg="App mode production"
sqlite-grafana-1        | logger=sqlstore t=2023-04-10T12:22:20.306623179Z level=info msg="Connecting to DB" dbtype=sqlite3
sqlite-grafana-1        | logger=migrator t=2023-04-10T12:22:21.23584875Z level=info msg="Starting DB migrations"
sqlite-grafana-1        | logger=migrator t=2023-04-10T12:22:21.625210895Z level=info msg="migrations completed" performed=0 skipped=481 duration=184.423121ms
sqlite-grafana-1        | logger=plugin.finder t=2023-04-10T12:22:23.254275131Z level=warn msg="Skipping finding plugins as directory does not exist" path=/usr/share/grafana/plugins-bundled
sqlite-grafana-1        | logger=secrets t=2023-04-10T12:22:23.260041103Z level=info msg="Envelope encryption state" enabled=true currentprovider=secretKey.v1
sqlite-grafana-1        | logger=query_data t=2023-04-10T12:22:23.618365395Z level=info msg="Query Service initialization"
sqlite-createbuckets-1 exited with code 0
sqlite-grafana-1        | logger=live.push_http t=2023-04-10T12:22:23.894026081Z level=info msg="Live Push Gateway initialization"
sqlite-grafana-1        | logger=infra.usagestats.collector t=2023-04-10T12:22:35.102585868Z level=info msg="registering usage stat providers" usageStatsProvidersLen=2
sqlite-grafana-1        | logger=provisioning.datasources t=2023-04-10T12:22:35.157692268Z level=warn msg="[Deprecated] the datasource provisioning config is outdated. please upgrade" filename=/etc/grafana/provisioning/datasources/datasource.yml
sqlite-grafana-1        | logger=provisioning.alerting t=2023-04-10T12:22:35.449101672Z level=info msg="starting to provision alerting"
sqlite-grafana-1        | logger=provisioning.alerting t=2023-04-10T12:22:35.449879691Z level=info msg="finished to provision alerting"
sqlite-grafana-1        | logger=ngalert.state.manager t=2023-04-10T12:22:35.465129079Z level=info msg="Warming state cache for startup"
sqlite-grafana-1        | logger=grafanaStorageLogger t=2023-04-10T12:22:35.559340473Z level=info msg="storage starting"
sqlite-grafana-1        | logger=ngalert.state.manager t=2023-04-10T12:22:35.753192398Z level=info msg="State cache has been initialized" states=0 duration=288.053318ms
sqlite-grafana-1        | logger=ticker t=2023-04-10T12:22:35.756696487Z level=info msg=starting first_tick=2023-04-10T12:22:40Z
sqlite-grafana-1        | logger=ngalert.multiorg.alertmanager t=2023-04-10T12:22:35.800006587Z level=info msg="starting MultiOrg Alertmanager"
sqlite-grafana-1        | logger=http.server t=2023-04-10T12:22:35.876121521Z level=info msg="HTTP Server Listen" address=[::]:3000 protocol=http subUrl= socket=
sqlite-app-1            | [00] go: downloading go.uber.org/automaxprocs v1.5.2
sqlite-app-1            | [00] go: downloading google.golang.org/grpc v1.54.0
sqlite-app-1            | [00] go: downloading github.com/grpc-ecosystem/grpc-gateway/v2 v2.15.2
sqlite-app-1            | [00] go: downloading google.golang.org/genproto v0.0.0-20230223222841-637eb2293923
sqlite-app-1            | [00] go: downloading google.golang.org/protobuf v1.30.0
sqlite-app-1            | [00] go: downloading github.com/grpc-ecosystem/go-grpc-middleware v1.4.0
sqlite-app-1            | [00] go: downloading golang.org/x/net v0.9.0
sqlite-app-1            | [00] go: downloading github.com/hashicorp/raft v1.4.0
sqlite-app-1            | [00] go: downloading go.uber.org/multierr v1.11.0
sqlite-app-1            | [00] go: downloading github.com/golang/protobuf v1.5.3
sqlite-app-1            | [00] go: downloading github.com/armon/go-metrics v0.4.1
sqlite-app-1            | [00] go: downloading golang.org/x/sys v0.7.0
sqlite-app-1            | [00] go: downloading github.com/cespare/xxhash/v2 v2.2.0
sqlite-app-1            | [00] go: downloading golang.org/x/text v0.9.0
sqlite-app-1            | [00] # go.uber.org/multierr
sqlite-app-1            | [00] /go/pkg/mod/go.uber.org/multierr@v1.11.0/error.go:209:13: undefined: atomic.Bool
sqlite-app-1            | [00] note: module requires Go 1.19
sqlite-app-1            | [00] # github.com/superfly/litefs
sqlite-app-1            | [00] /go/pkg/mod/github.com/superfly/litefs@v0.3.0/db.go:1476:14: db.shmMu.TryLock undefined (type sync.Mutex has no field or method TryLock)
sqlite-app-1            | [00] /go/pkg/mod/github.com/superfly/litefs@v0.3.0/store.go:918:34: undefined: any
sqlite-app-1            | [00] note: module requires Go 1.19
sqlite-grafana-1        | logger=context userId=1 orgId=1 uname=admin t=2023-04-10T12:27:25.042645591Z level=info msg="Request Completed" method=GET path=/api/live/ws status=-1 remote_addr=10.89.0.4 time_ms=70 duration=70.086907ms size=0 referer= handler=/api/live/ws
sqlite-grafana-1        | logger=live t=2023-04-10T12:27:26.404472643Z level=info msg="Initialized channel handler" channel=grafana/dashboard/uid/7_VGtoLma address=grafana/dashboard/uid/7_VGtoLma
sqlite-app-1            | [00] (error exit: exit status 2)
gedw99 commented 1 year ago

saw module requires Go 1.19 a fair bit with lifefs complaining

[00] Starting service
[00] # github.com/superfly/litefs
�[00] /go/pkg/mod/github.com/superfly/litefs@v0.3.0/db.go:1476:14: db.shmMu.TryLock undefined (type sync.Mutex has no field or method TryLock)
[00] /go/pkg/mod/github.com/superfly/litefs@v0.3.0/store.go:918:34: undefined: any
[00] note: module requires Go 1.19
[00] Starting service
[00] go: downloading go.uber.org/automaxprocs v1.5.2
[00] go: downloading google.golang.org/grpc v1.54.0
[00] go: downloading github.com/grpc-ecosystem/grpc-gateway/v2 v2.15.2
[00] go: downloading google.golang.org/genproto v0.0.0-20230223222841-637eb2293923
[00] go: downloading google.golang.org/protobuf v1.30.0
[00] go: downloading github.com/grpc-ecosystem/go-grpc-middleware v1.4.0
[00] go: downloading golang.org/x/net v0.9.0
[00] go: downloading github.com/hashicorp/raft v1.4.0
[00] go: downloading go.uber.org/multierr v1.11.0
[00] go: downloading github.com/golang/protobuf v1.5.3
[00] go: downloading github.com/armon/go-metrics v0.4.1
[00] go: downloading golang.org/x/sys v0.7.0
[00] go: downloading github.com/cespare/xxhash/v2 v2.2.0
[00] go: downloading golang.org/x/text v0.9.0
[00] # go.uber.org/multierr
[00] /go/pkg/mod/go.uber.org/multierr@v1.11.0/error.go:209:13: undefined: atomic.Bool
[00] note: module requires Go 1.19
[00] # github.com/superfly/litefs
�[00] /go/pkg/mod/github.com/superfly/litefs@v0.3.0/db.go:1476:14: db.shmMu.TryLock undefined (type sync.Mutex has no field or method TryLock)
[00] /go/pkg/mod/github.com/superfly/litefs@v0.3.0/store.go:918:34: undefined: any
[00] note: module requires Go 1.19
[00] (error exit: exit status 2)
gedw99 commented 1 year ago

I booted up the booktest

similar issues, but got Jaeger http://localhost:16686 this time.

But again no swagger

walterwanderley commented 1 year ago

Fixed in the latest version.