Bug 988965

Could you tell us what database is shutting down?

Lowing the severity until we can get more details.

http://walkking-oitozero.rhcloud.com

Database: walkking
Type: MySQL 

I have create another account (http://walkking-walkking.rhcloud.com) and I'm having the same problem.

So MySQL is shutting down.

To investigate further, SSH to the MySQL gear and look at logs: mysql/log/*.log

Sorry, I misread your question. I thought you were asking what database type I was using.

MySQL is not shutting down. The database connection goes down because the server instance stops. Also, I can't get much information on node log file.

Ah, OK, so MySQL server is running, but your Node.js app terminates?

Given the information thus far, I suspect the problem lies with your application, and we need to figure out the cause. Since we do not have enough information to go on with, let us first increase verbosity for your application's logging if possible, and study the resulting logs.

Same log info. Can you increase verbosity also in walkking-walkking.rhcloud.com?

## --------------------------------------------------
nodejs/logs/node.log

Error: Connection lost: The server closed the connection.
    at Protocol.end (/var/lib/openshift/51fcde2b5973ca71eb0000fe/app-root/runtime/repo/node_modules/jugglingdb-mysql/node_modules/mysql/lib/protocol/Protocol.js:72:13)
    at Socket.onend (_stream_readable.js:483:10)
    at Socket.g (events.js:175:14)
    at Socket.EventEmitter.emit (events.js:117:20)
    at _stream_readable.js:910:16
    at process._tickCallback (node.js:415:13)
npm info walkking.1 Failed to exec start script
npm ERR! weird error 8
npm ERR! not ok code 0


## --------------------------------------------------

mysql/log/mysql_error.log

130803 06:45:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//data/
130803  6:45:00  InnoDB: Initializing buffer pool, size = 16.0M
130803  6:45:00  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130803  6:45:00  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130803  6:45:00  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130803  6:45:01  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130803  6:45:01  InnoDB: Started; log sequence number 0 0
130803  6:45:01 [Note] Event Scheduler: Loaded 0 events
130803  6:45:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//socket/mysql.sock'  port: 3306  Source distribution
130803  6:48:14 [Note] /usr/libexec/mysqld: Normal shutdown

130803  6:48:14 [Note] Event Scheduler: Purging the queue. 0 events
130803  6:48:14  InnoDB: Starting shutdown...
130803  6:48:16  InnoDB: Shutdown completed; log sequence number 0 44233
130803  6:48:16 [Note] /usr/libexec/mysqld: Shutdown complete

130803 06:48:16 mysqld_safe mysqld from pid file /var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//pid/mysql.pid ended
130803 06:50:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//data/
130803  6:50:58  InnoDB: Initializing buffer pool, size = 16.0M
130803  6:50:58  InnoDB: Completed initialization of buffer pool
130803  6:50:58  InnoDB: Started; log sequence number 0 44233
130803  6:50:59 [Note] Event Scheduler: Loaded 0 events
130803  6:50:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//socket/mysql.sock'  port: 3306  Source distribution
130803  6:54:55 [Note] /usr/libexec/mysqld: Normal shutdown

130803  6:54:55 [Note] Event Scheduler: Purging the queue. 0 events
130803  6:54:55  InnoDB: Starting shutdown...
130803  6:54:59  InnoDB: Shutdown completed; log sequence number 0 44233
130803  6:54:59 [Note] /usr/libexec/mysqld: Shutdown complete

130803 06:54:59 mysqld_safe mysqld from pid file /var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//pid/mysql.pid ended
130803 06:55:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//data/
130803  6:55:31  InnoDB: Initializing buffer pool, size = 16.0M
130803  6:55:31  InnoDB: Completed initialization of buffer pool
130803  6:55:31  InnoDB: Started; log sequence number 0 44233
130803  6:55:31 [Note] Event Scheduler: Loaded 0 events
130803  6:55:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/openshift/51fcde2b5973ca71eb0000fe/mysql//socket/mysql.sock'  port: 3306  Source distribution

## --------------------------------------------------
#node.js
ctl_app status 
ATTR: quota_blocks=1048576
ATTR: quota_files=40000
CLIENT_RESULT: Application is not running

#mysql
ctl_app status 
ATTR: quota_blocks=1048576
ATTR: quota_files=40000
CLIENT_RESULT: MySQL is running

MySQL shutdown seems normal.

In your node.js application log, there is this line:

npm info walkking.1 Failed to exec start script
npm ERR! weird error 8
npm ERR! not ok code 0

It seems that the log is incomplete, though. Please look into nodejs/logs/node.log as to why your application is failing to start.

Hi,

Is there any update on this?

walkking-oitozero.rhcloud.com is no longer found in DNS.