apache / arrow-adbc

Database connectivity API standard and libraries for Apache Arrow
https://arrow.apache.org/adbc/
Apache License 2.0
329 stars 84 forks source link

go: fix failing Snowflake tests #1364

Closed lidavidm closed 6 months ago

lidavidm commented 6 months ago
    driver_test.go:892: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:892
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:928
            Error:          Received unexpected error:
                            I/O: 003013 (42501): SQL access control error:
                            Requested role 'ACCOUNTADMIN' is not assigned to the executing user.  Specify another role to activate. (42501)
            Test:           TestSnowflake/TestJwtPrivateKey
    driver_test.go:903: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:903
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:928
            Error:          Received unexpected error:
                            I/O: 001003 (42000): SQL compilation error:
                            syntax error line 1 at position 15 unexpected '@voltrondata.com'. (42000)
            Test:           TestSnowflake/TestJwtPrivateKey
    driver_test.go:914: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:914
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:940
            Error:          Received unexpected error:
                            I/O: 390144 (08004): JWT token is invalid. [55e96461-8d13-4b95-9d1e-3b03e025b84b] (08004)
            Test:           TestSnowflake/TestJwtPrivateKey
    driver_test.go:892: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:892
                                        /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/panic.go:884
                                        /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/panic.go:260
                                        /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/signal_unix.go:839
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:915
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:940
            Error:          Received unexpected error:
                            I/O: 003013 (42501): SQL access control error:
                            Requested role 'ACCOUNTADMIN' is not assigned to the executing user.  Specify another role to activate. (42501)
            Test:           TestSnowflake/TestJwtPrivateKey
    driver_test.go:903: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:903
                                        /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/panic.go:884
                                        /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/panic.go:260
                                        /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/signal_unix.go:839
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:915
                                        /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:940
            Error:          Received unexpected error:
                            I/O: 001003 (42000): SQL compilation error:
                            syntax error line 1 at position 15 unexpected '@voltrondata.com'. (42000)
            Test:           TestSnowflake/TestJwtPrivateKey
    suite.go:87: test panicked: runtime error: invalid memory address or nil pointer dereference
        goroutine 1174 [running]:
        runtime/debug.Stack()
            /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/debug/stack.go:24 +0x65
        github.com/stretchr/testify/suite.failOnPanic(0xc00053bd40, {0x196a240, 0x2a4dc30})
            /home/runner/go/pkg/mod/github.com/stretchr/testify@v1.8.4/suite/suite.go:87 +0x3b
        github.com/stretchr/testify/suite.Run.func1.1()
            /home/runner/go/pkg/mod/github.com/stretchr/testify@v1.8.4/suite/suite.go:183 +0x252
        panic({0x196a240, 0x2a4dc30})
            /opt/hostedtoolcache/go/1.19.13/x64/src/runtime/panic.go:884 +0x212
        github.com/apache/arrow-adbc/go/adbc/driver/snowflake_test.(*SnowflakeTests).TestJwtPrivateKey.func3({0xc00069ecd8, 0x16})
            /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:915 +0x2b5
        github.com/apache/arrow-adbc/go/adbc/driver/snowflake_test.(*SnowflakeTests).TestJwtPrivateKey(0xc000ae8dc0)
            /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:940 +0x259
        reflect.Value.call({0xc0006540c0?, 0xc0000b5278?, 0x0?}, {0x1b8743c, 0x4}, {0xc0000c1e70, 0x1, 0xc0000c1d80?})
            /opt/hostedtoolcache/go/1.19.13/x64/src/reflect/value.go:584 +0x8c5
        reflect.Value.Call({0xc0006540c0?, 0xc0000b5278?, 0xc000ae8dc0?}, {0xc0000c1e70?, 0x7f5f06f752e0?, 0xd0?})
            /opt/hostedtoolcache/go/1.19.13/x64/src/reflect/value.go:368 +0xbc
        github.com/stretchr/testify/suite.Run.func1(0xc00053bd40)
            /home/runner/go/pkg/mod/github.com/stretchr/testify@v1.8.4/suite/suite.go:197 +0x4b6
        testing.tRunner(0xc00053bd40, 0xc0001e4cf0)
            /opt/hostedtoolcache/go/1.19.13/x64/src/testing/testing.go:1446 +0x10b
        created by testing.(*T).Run
            /opt/hostedtoolcache/go/1.19.13/x64/src/testing/testing.go:1493 +0x35f
=== RUN   TestValidation/TestMetadataGetObjectsColumns/no_filter
    validation.go:442: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/validation/validation.go:442
                                        /home/runner/go/pkg/mod/github.com/stretchr/testify@v1.8.4/suite/suite.go:112
            Error:          Received unexpected error:
                            003030 (02000): Uncaught exception of type 'STATEMENT_ERROR' on line 23 at position 11 : SQL compilation error:
                            Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.
            Test:           TestValidation/TestMetadataGetObjectsColumns/no_filter
=== RUN   TestValidation/TestMetadataGetObjectsColumns/filter:_in%
    validation.go:442: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/validation/validation.go:442
                                        /home/runner/go/pkg/mod/github.com/stretchr/testify@v1.8.4/suite/suite.go:112
            Error:          Received unexpected error:
                            003030 (02000): Uncaught exception of type 'STATEMENT_ERROR' on line 23 at position 11 : SQL compilation error:
                            Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.
            Test:           TestValidation/TestMetadataGetObjectsColumns/filter:_in%
=== RUN   TestSnowflake/TestStatementEmptyResultSet
    driver_test.go:403: 
            Error Trace:    /home/runner/work/arrow-adbc/arrow-adbc/go/adbc/driver/snowflake/driver_test.go:403
            Error:          Not equal: 
                            expected: int(25)
                            actual  : int64(26)
            Test:           TestSnowflake/TestStatementEmptyResultSet
lidavidm commented 6 months ago

CC @zeroshade