Deletion issues

[Imisrael]

I am having some issues with deleting rows.

Some of the code:

` conInfo, err := griddb_go.CreateContainerInfo("Users",
[][]interface{}{
{"username", griddb_go.TYPE_STRING},
{"email", griddb_go.TYPE_STRING},
{"password", griddb_go.TYPE_BLOB}},
griddb_go.CONTAINER_COLLECTION,
true)
if err != nil {
fmt.Println("Create containerInfo failed")
}
col, err := gridstore.PutContainer(conInfo, true)
if err != nil {
fmt.Println("put container failed")
}

	query, err := col.Query(fmt.Sprintf("SELECT * WHERE username='%s'", username))
	if err != nil {
		fmt.Println("create query failed")
	}
	rs, err := query.Fetch(false)
	if err != nil {
		fmt.Println("create rs from query failed")
	}

	col.SetAutoCommit(false)

	if rs.HasNext() {
		rrow, err := rs.NextRow()
		if err != nil {
			fmt.Println("Error retrieving row")
		}
		//deletes user
		col.Remove(rrow[0])
		col.Commit()
	} else {
		fmt.Println("error. Has Next Failed")
	}`

This is hooked up to a webpage and is triggered when a button is pressed. But the issue is, sometimes it deletes, sometimes it doesn't.

[knonomura]

Thank you for using GridDB Go Client.
I will check this issue.

[knonomura]

Sorry for late reply.
When we delete row 10.000 times, sometime go_client ran successfully, sometime failed.

So, I updated typemap for field type string/blob.
Please try the latest source code.

[Imisrael]

Thank you for pushing this fix.

Unfortunately after building I am having some issues reading from GridDB. When I try to run put/read from GridDB I get the following error:

/tmp/go-build289726786/b001/exe/griddb: symbol lookup error: /tmp/go-build289726786/b001/exe/griddb: undefined symbol: gsPutContainerGeneralV3_3
exit status 127

This is my go env:

GOARCH="amd64"
GOBIN="/home/imru/go/bin"
GOCACHE="/home/imru/.cache/go-build"
GOEXE=""
GOHOSTARCH="amd64"
GOHOSTOS="linux"
GOOS="linux"
GOPATH="/home/imru/go/src:/home/imru/go/src/github.com/griddb/go_client/"
GORACE=""
GOROOT="/usr/local/go"
GOTMPDIR=""
GOTOOLDIR="/usr/local/go/pkg/tool/linux_amd64"
GCCGO="gccgo"
CC="gcc"
CXX="g++"
CGO_ENABLED="1"
CGO_CFLAGS="-g -O2"
CGO_CPPFLAGS=""
CGO_CXXFLAGS="-g -O2"
CGO_FFLAGS="-g -O2"
CGO_LDFLAGS="-g -O2"
PKG_CONFIG="pkg-config"
GOGCCFLAGS="-fPIC -m64 -pthread -fmessage-length=0 -fdebug-prefix-map=/tmp/go-build908016776=/tmp/go-build -gno-record-gcc-switches"

Here is some sample code I'm trying to run which fails:

package main

import (
    "fmt"
    "github.com/griddb/go_client"
    "golang.org/x/crypto/bcrypt"
)

func main() {

    factory := griddb_go.StoreFactoryGetInstance()

    gridstore := factory.GetStore(map[string]interface{}{
        "cluster_name":        "defaultCluster",
        "username":            "admin",
        "password":            "admin",
        "notification_member": "192.168.1.4:10001,192.168.1.5:10001,192.168.1.6:10001",
    })

    fmt.Println("successfully connected: ", gridstore)

    // Create Collection
    conInfo, err := griddb_go.CreateContainerInfo("Users",
        [][]interface{}{
            {"username", griddb_go.TYPE_STRING},
            {"email", griddb_go.TYPE_STRING},
            {"password", griddb_go.TYPE_BLOB}},
        griddb_go.CONTAINER_COLLECTION,
        true)
    if err != nil {
        fmt.Println("Create containerInfo failed")
    }
    col, err := gridstore.PutContainer(conInfo, false)
    if err != nil {
        fmt.Println("put container failed")
    }

    col.SetAutoCommit(false)

    password := []byte("epic")
    hashedPassword, err := bcrypt.GenerateFromPassword(password, bcrypt.DefaultCost)
    if err != nil {
        panic(err)
    }

    row := []interface{}{"test", "test@fixstars.com", hashedPassword}
    err = col.Put(row)
    if err != nil {
        fmt.Println("col.Put panic:", err)
    }
    col.Commit()

    // Create normal query
    query, err := col.Query("select *")
    if err != nil {
        fmt.Println("create query failed")
    }
    //Execute query
    rs, err := query.Fetch(true)
    if err != nil {
        fmt.Println("create rs from query failed")
    }
    for rs.HasNext() {
        // Update row
        rrow, err := rs.NextRow()
        if err != nil {
            fmt.Println("NextRow from rs failed")
        }
        fmt.Println("Person: name=", rrow[0], " status=", rrow[1], " count=", rrow[2])
    }

}

Thank you for your assistance!

[knonomura]

I guess you use Go Client build with gridstore.h of C Client V4.0 and
the library libgridstore.so of C Client V3.0.

Could you please use C Client for GridDB V4.0 ?

[Imisrael]

Thank you for the continued support.

I've successfully built the go_client with the new C_Client but now I'm getting some strange error. I'm not sure if it's something wrong with my env, but go commands work in other locations. I get this error:

main.go:23:2: no Go files in /home/imru/go/src/src/github.com/griddb/go_client

[knonomura]

Could you please set GOPATH to the directory path placed GridDB Go Client ?
ex.) export GOPATH=/home/imru/go

[Imisrael]

I was able to fix it actually. I had placed the go_client in a directory within the gopath and it was causing issues for whatever reason. To fix, I just needed to move the go_client dir outside to a different location. Thanks for the help.

…

On Wed, Aug 15, 2018 at 8:26 PM, Katsuhiko Nonomura < ***@***.***> wrote: Could you please set GOPATH to the directory path placed GridDB Go Client ? ex.) export GOPATH=/home/imru/go — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AMmgQHUC-MBTJ-5XtAM1cozAx49l9viTks5uROZggaJpZM4ViiaK> .