Cannot enqueue Query after invoking quit

alx commented 9 years ago

On a fresh install with apparently nothing wrong.

etherpad-lite@web:/var/www/draw.tetalab.org$ ./bin/run.sh 
Ensure that all dependencies are up to date...
start...
Access Etherdraw at http://127.0.0.19002
made room
load from db
Initting db

/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/Parser.js:82
        throw err;
              ^
Error: Cannot enqueue Query after invoking quit.
    at Protocol._validateEnqueue (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/Protocol.js:196:16)
    at Protocol._enqueue (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/Protocol.js:129:13)
    at Connection.query (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/Connection.js:185:25)
    at /var/www/draw.tetalab.org/node_modules/ueberDB/mysql_db.js:86:12
    at Query._callback (/var/www/draw.tetalab.org/node_modules/ueberDB/mysql_db.js:116:5)
    at Query.Sequence.end (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:24)
    at Query._handleFinalResultPacket (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/sequences/Query.js:143:8)
    at Query.EofPacket (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/sequences/Query.js:127:8)
    at Protocol._parsePacket (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/Protocol.js:271:23)
    at Parser.write (/var/www/draw.tetalab.org/node_modules/ueberDB/node_modules/mysql/lib/protocol/Parser.js:77:12)

JohnMcLear commented 9 years ago

Please read: http://mclear.co.uk/2015/01/15/how-to-write-a-bug-report/

alx commented 9 years ago

How to replicate : create a fresh etherdraw install, configure settings.json with mysql database, launch bin/run.sh

Expected behavior: http://120.0.0.1:9002/ create a new draw pad where it's possible to draw
Actual behavior: http://120.0.0.1:9002/ is opening, freezing with "Loading existing sketch... Click and hold to access the colour wheel" message, and the server is crashing with first comment error

Dirty db settings are working, using it until I can find more information about this issue.

System : debian jessy, node v0.10.36
settings.json :

  "dbType" : "mysql",
  "dbSettings" : {
    "user"    : "root", 
    "host"    : "localhost", 
    "password": "", 
    "database": "etherdraw"
  }

database etherdraw exists in mysql, and store table was created during first run

JohnMcLear commented 9 years ago

Try update node please. Sounds like a dep issue ----- Reply message ----- From: "Alexandre Girard" notifications@github.com To: "JohnMcLear/draw" draw@noreply.github.com Cc: "John McLear" John@mclear.co Subject: [draw] Cannot enqueue Query after invoking quit (#184) Date: Fri, Jan 30, 2015 13:56

How to replicate : create a fresh etherdraw install, configure settings.json with mysql database, launch bin/run.sh

Expected behavior: http://120.0.0.1:9002/ create a new draw pad where it's possible to draw
Actual behavior: http://120.0.0.1:9002/ is opening, freezing with "Loading existing sketch... Click and hold to access the colour wheel" message, and the server is crashing with first comment error

Dirty db settings are working, using it until I can find more information about this issue.

System : debian jessy, node v0.10.36
settings.json :

"dbType" : "mysql", "dbSettings" : { "user" : "root", "host" : "localhost", "password": "", "database": "etherdraw" }
database etherdraw exists in mysql, and store table was created during first run

— Reply to this email directly or view it on GitHubhttps://github.com/JohnMcLear/draw/issues/184#issuecomment-72203954.

JohnMcLear commented 9 years ago

Latest node? ----- Reply message ----- From: "Alexandre Girard" notifications@github.com To: "JohnMcLear/draw" draw@noreply.github.com Cc: "John McLear" John@mclear.co Subject: [draw] Cannot enqueue Query after invoking quit (#184) Date: Fri, Jan 30, 2015 13:56

How to replicate : create a fresh etherdraw install, configure settings.json with mysql database, launch bin/run.sh

Expected behavior: http://120.0.0.1:9002/ create a new draw pad where it's possible to draw
Actual behavior: http://120.0.0.1:9002/ is opening, freezing with "Loading existing sketch... Click and hold to access the colour wheel" message, and the server is crashing with first comment error

Dirty db settings are working, using it until I can find more information about this issue.

System : debian jessy, node v0.10.36
settings.json :

"dbType" : "mysql", "dbSettings" : { "user" : "root", "host" : "localhost", "password": "", "database": "etherdraw" }
database etherdraw exists in mysql, and store table was created during first run

— Reply to this email directly or view it on GitHubhttps://github.com/JohnMcLear/draw/issues/184#issuecomment-72203954.

alx commented 9 years ago

Yes, latest node : http://nodejs.org/ Current Version: v0.10.36

alx commented 9 years ago

If it can help, etherpad is working fine on the same machine with mysql settings.

JohnMcLear commented 9 years ago

Okay must be a db config issue with lTest ueberdb try roll back ueberdb a few minor versions and test that..

----- Reply message ----- From: "Alexandre Girard" notifications@github.com To: "JohnMcLear/draw" draw@noreply.github.com Cc: "John McLear" John@mclear.co Subject: [draw] Cannot enqueue Query after invoking quit (#184) Date: Fri, Jan 30, 2015 14:21

If it can help, etherpad is working fine on the same machine with mysql settings.

— Reply to this email directly or view it on GitHubhttps://github.com/JohnMcLear/draw/issues/184#issuecomment-72207818.

JohnMcLear commented 9 years ago

Closing due to lack of activity

shadowcodex commented 8 years ago

Having the same issue, did we ever figure out what the issue was?

ghost commented 7 years ago

I'm also experiencing this issue. I used the docker container like so:

docker run -d \
    -e MYSQL_ROOT_PASSWORD=password \
    -e MYSQL_DATABASE=etherdraw \
    --name etherdraw_mysql mysql

# Wait for mysql to start
sleep 65

docker run -d \
    --name etherdraw \
    -p 0.0.0.0:9002:9002 \
    --link etherdraw_mysql:mysql \
    -v /root/docker/etherdraw/etherdraw-settings.json:/srv/etherdraw/draw/settings.json \
    anybox/etherdraw:develop

cat etherdraw-settings.json
{
  //IP and port which etherpad should bind at
  "ip" : "0.0.0.0",
  "port" : 9002,

  //database type. You can choose between dirty, postgres, sqlite and mysql
  //You shouldn't use "dirty" for for anything else than testing or development
  "dbType" : "mysql",
  //the database specific settings
  "dbSettings" : {
    "user"    : "root", 
    "host"    : "etherdraw_mysql", 
    "password": "password",
    "database": "etherdraw"
  },
  /* The default selected tool - 'pencil', 'brush', 'select' */
  "tool": "brush"
}

The page hangs at "Loading existing sketch... Click and hold to access the colour wheel". Docker logs dont show:

$ docker logs etherdraw
Access Etherdraw at http://0.0.0.0:9002

ghost commented 7 years ago

I'm getting the same result when using the "dirty" db type.

JohnMcLear / draw

Cannot enqueue Query after invoking quit #184