Skip to content

Errors for Postgres run. #54

Description

@jamessewell

Hello, I'm incoming from the PlanetScale blog.

I run this prepare:

./tpcc.lua   
    --pgsql-host=${DB_HOST}   
    --pgsql-port=${DB_PORT}   
    --pgsql-password=${DB_PASSWORD}   
    --pgsql-user=${DB_USER}   
    --pgsql-db=${DB_NAME}   
    --tables=20   
    --scale=250   
    --use_fk=0   
    --threads=20   
    --report-interval=1  
    --db-driver=pgsql   
    prepare

Which finishes with no errors, and then:

./tpcc.lua \
    --pgsql-host=${DB_HOST} \
    --pgsql-port=${DB_PORT} \
    --pgsql-password=${DB_PASSWORD} \
    --pgsql-user=${DB_USER} \
    --pgsql-db=${DB_NAME} \
    --tables=20 \
    --scale=250 \
    --use_fk=0 \
    --time=300 \
    --threads=32 \
    --report-interval=1 \
    --histogram=off \
    --percentile=99 \
    --db-driver=pgsql \
    run

Which gives me this error quickly:

sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)

Running the test with following options:
Number of threads: 32
Report intermediate results every 1 second(s)
Initializing random number generator from current time


Initializing worker threads...

DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
DB SCHEMA public
Threads started!

FATAL: `thread_run' function failed: ./tpcc_run.lua:120: attempt to perform arithmetic on local 'd_next_o_id' (a nil value)
FATAL: `thread_run' function failed: ./tpcc_run.lua:363: attempt to perform arithmetic on a nil value
ALERT: attempt to fetch row from an empty result set
FATAL: `thread_run' function failed: ./tpcc_run.lua:335: attempt to index global 'row' (a nil value)
ALERT: attempt to fetch row from an empty result set
FATAL: `thread_run' function failed: ./tpcc_run.lua:335: attempt to index global 'row' (a nil value)
ALERT: attempt to fetch row from an empty result set
FATAL: `thread_run' function failed: ./tpcc_run.lua:335: attempt to index global 'row' (a nil value)

Running a check shows only PASSED.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions