`runtime error: invalid memory address or nil pointer dereference` when executing sqlboiler command #1129

sora-ichigo · 2022-04-30T05:09:12Z

sora-ichigo
Apr 30, 2022

I got error runtime error: invalid memory address or nil pointer dereference when command sqlboiler executing.

I have done a lot of research and read the source code for sqlboiler, but I need help because I couldn't figure it out on my own. 🙇

assumption

I use docker for execute sqlboiler.

version: '3'
services:
  db:
    image: mysql:8.0
    platform: linux/amd64
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: portfolio
  app:
    image: golang:1.18
    volumes:
      - .:/app
      - gomod:/go/pkg/mod
    working_dir: /app
    depends_on:
      - db
volumes:
  gomod:

I use golang-migrate for migration.

migration file

CREATE TABLE IF NOT EXISTS blogs (
id VARCHAR(36) NOT NULL,
title VARCHAR(255) NOT NULL,
posted_at DATE NOT NULL,
site_url VARCHAR(255) NOT NULL,
thumbnail_url VARCHAR(255) NOT NULL
);

$ docker compose app ./bin/migrate -path migrations/ -database "mysql://root:root@tcp(db:3306)/portfolio" up
20220429141011/u create_blogs_table (49.475834ms)

What version of SQLBoiler are you using (`sqlboiler --version`)?

$ docker compose app ./bin/sqlboiler --version
SQLBoiler v4.11.0

What is your database and version (eg. Postgresql 10)

mysql:8.0
(docker image)

Command Log

sqlboiler.toml

output = "models"
pkgname = "models"
no-tests = true
add-global-variants = true

[mysql]
  dbname  = "portfolio"
  host    = "db"
  port    = 3306
  user    = "root"
  pass    = "root"
  sslmode = "false"

execute `sqlboiler -d mysql`

$ docker compose app bash
root@ccc0f25e6c7f:/app# ./bin/sqlboiler -d ./bin/sqlboiler-mysql                                                                           
using driver: ./bin/sqlboiler-mysql                                                                                                        
runtime error: invalid memory address or nil pointer dereference                                                                           
{"config":{"driver_name":"mysql","driver_config":{"add-enum-types":false,"blacklist":null,"dbname":"portfolio","enum-null-prefix":"Null","host":"db","pass":"root","port":3306,"sslmode":"false","user":"root","w
hitelist":null},"pkg_name":"models","out_folder":"models","debug":true,"add_global":true,"enum_null_prefix":"Null","no_tests":true,"struct_tag_casing":"snake","relation_tag":"-","imports":{"all":{"Standard":["
\"database/sql\"","\"fmt\"","\"reflect\"","\"strings\"","\"sync\"","\"time\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/sqlbo
iler/v4/queries\"","\"github.com/volatiletech/sqlboiler/v4/queries/qm\"","\"github.com/volatiletech/sqlboiler/v4/queries/qmhelper\"","\"github.com/volatiletech/strmangle\""]},"test":{"Standard":["\"bytes\"","\
"reflect\"","\"testing\""],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/randomize\"","\"github.com/volatiletech/st
rmangle\""]},"singleton":{"boil_queries":{"Standard":null,"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/drivers\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/sqlboile
r/v4/queries/qm\""]},"boil_types":{"Standard":["\"strconv\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/strmangle\""]}},"test_
singleton":{"boil_main_test":{"Standard":["\"database/sql\"","\"flag\"","\"fmt\"","\"math/rand\"","\"os\"","\"path/filepath\"","\"strings\"","\"testing\"","\"time\""],"ThirdParty":["\"github.com/spf13/viper\""
,"\"github.com/volatiletech/sqlboiler/v4/boil\""]},"boil_queries_test":{"Standard":["\"bytes\"","\"fmt\"","\"io\"","\"io/ioutil\"","\"math/rand\"","\"regexp\""],"ThirdParty":["\"github.com/volatiletech/sqlboil
er/v4/boil\""]},"boil_suites_test":{"Standard":["\"testing\""],"ThirdParty":null}}},"aliases":{},"auto_columns":{},"inflections":{"Plural":{},"PluralExact":{},"Singular":{},"SingularExact":{},"Irregular":{}},"
version":"4.11.0"},"driver_config":{"add-enum-types":false,"blacklist":null,"dbname":"portfolio","enum-null-prefix":"Null","host":"db","pass":"root","port":3306,"sslmode":"false","user":"root","whitelist":null
version":"4.11.0"},"driver_config":{"add-enum-types":false,"blacklist":null,"dbname":"portfolio","enum-null-prefix":"Null","host":"db","pass":"root","port":3306,"sslmode":"false","user":"root","whitelist":null
},"schema":"","dialect":{"lq":0,"rq":0,"use_index_placeholders":false,"use_last_insert_id":false,"use_schema":false,"use_default_keyword":false,"use_top_clause":false,"use_output_clause":false,"use_case_when_e
xists_clause":false,"use_auto_columns":false},"tables":null,"templates":null}                           
Error: exit status 1                                
driver (./bin/sqlboiler-mysql) exited non-zero                                                          
github.com/volatiletech/sqlboiler/v4/drivers.execute                                                    
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/drivers/binary_driver.go:73                                                                                                                     
github.com/volatiletech/sqlboiler/v4/drivers.binaryDriver.Assemble                                      
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/drivers/binary_driver.go:21                                                                                                                     
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).initDBInfo                                    
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/boilingcore.go:408                                                                                                                  
github.com/volatiletech/sqlboiler/v4/boilingcore.New                                                    
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/boilingcore.go:86                                                                                                                   
main.preRun                                         
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:219                                                                                                                                     
github.com/spf13/cobra.(*Command).execute                                                               
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:845                                        
github.com/spf13/cobra.(*Command).ExecuteC                                                              
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:974                                        
github.com/spf13/cobra.(*Command).Execute                                                               
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:902                                        
main.main                                           
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:122                                                                                                                                     
runtime.main                                        
        /usr/local/go/src/runtime/proc.go:250                                                           
runtime.goexit                                      
        /usr/local/go/src/runtime/asm_arm64.s:1259                                                      
unable to fetch table data                          
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).initDBInfo                                    
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/boilingcore.go:410                                                                                                                  
github.com/volatiletech/sqlboiler/v4/boilingcore.New                                                    
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/boilingcore.go:86                                                                                                                   
main.preRun                                         
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:219                                                                                                                                     
github.com/spf13/cobra.(*Command).execute                                                               
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:845                                        
github.com/spf13/cobra.(*Command).ExecuteC         
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:974                                        
github.com/spf13/cobra.(*Command).Execute                                                               
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:902                                        
main.main                                           
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:122                                                                                                                                     
runtime.main                                        
        /usr/local/go/src/runtime/proc.go:250                                                           
runtime.goexit                                      
        /usr/local/go/src/runtime/asm_arm64.s:1259                                                      
unable to initialize tables                         
github.com/volatiletech/sqlboiler/v4/boilingcore.New                                                    
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/boilingcore.go:88                                                                                                                   
main.preRun                                         
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:219                                                                                                                                     
github.com/spf13/cobra.(*Command).execute                                                               
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:845                                        
github.com/spf13/cobra.(*Command).ExecuteC                                                              
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:974                                        
github.com/spf13/cobra.(*Command).Execute                                                               
        /go/pkg/mod/github.com/spf13/[email protected]/command.go:902                                        
main.main                                           
        /go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:122                                                                                                                                     
runtime.main                                        
        /usr/local/go/src/runtime/proc.go:250                                                           
runtime.goexit                                      
        /usr/local/go/src/runtime/asm_arm64.s:1259

Answered by sora-ichigo

May 1, 2022

It has worked in v4.10.0, not v4.11.0.

View full answer

sora-ichigo · 2022-04-30T05:12:45Z

sora-ichigo
Apr 30, 2022
Author

This is the implementation in problem.
sora-ichigo/portfolio-backend#7

0 replies

sora-ichigo · 2022-05-01T06:34:36Z

sora-ichigo
May 1, 2022
Author

It has worked in v4.10.0, not v4.11.0.

0 replies

sora-ichigo · 2022-05-01T06:38:00Z

sora-ichigo
May 1, 2022
Author

Is this a bug in v4.11.0?

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

`runtime error: invalid memory address or nil pointer dereference` when executing sqlboiler command #1129

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 3 comments

{{title}}

{{title}}

{{title}}

Select a reply

runtime error: invalid memory address or nil pointer dereference when executing sqlboiler command #1129

sora-ichigo Apr 30, 2022

assumption

What version of SQLBoiler are you using (sqlboiler --version)?

What is your database and version (eg. Postgresql 10)

Command Log

Replies: 3 comments

sora-ichigo Apr 30, 2022 Author

sora-ichigo May 1, 2022 Author

sora-ichigo May 1, 2022 Author

`runtime error: invalid memory address or nil pointer dereference` when executing sqlboiler command #1129

sora-ichigo
Apr 30, 2022

What version of SQLBoiler are you using (`sqlboiler --version`)?

sora-ichigo
Apr 30, 2022
Author

sora-ichigo
May 1, 2022
Author

sora-ichigo
May 1, 2022
Author