Skip to content

Instantly share code, notes, and snippets.

@Epigene
Created May 6, 2016 11:47
Show Gist options
  • Save Epigene/2dc7e1b28a866a5e69e7b8d2c95f7919 to your computer and use it in GitHub Desktop.
Save Epigene/2dc7e1b28a866a5e69e7b8d2c95f7919 to your computer and use it in GitHub Desktop.
maria db log output for irresponsive dokku app
2016-05-06 11:30:04 140555160876992 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-06 11:30:04 140555160876992 [Note] InnoDB: Waiting for purge to start
2016-05-06 11:30:04 140555160876992 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1616809
2016-05-06 11:30:04 140554365011712 [Note] InnoDB: Dumping buffer pool(s) not yet started
ERROR: 1049 Unknown database 'test'
2016-05-06 11:30:04 140555160876992 [ERROR] Aborting
WARNING: OPENGIS REQUIRED SP-S WERE NOT COMPLETELY INSTALLED!
GIS extentions might not work properly.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Database initialized
MySQL init process in progress...
2016-05-06 11:30:07 139843548858304 [Note] mysqld (mysqld 10.1.10-MariaDB-1~jessie) starting as process 133 ...
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Memory barrier is not used
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Using Linux native AIO
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Using SSE crc32 instructions
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Completed initialization of buffer pool
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Waiting for purge to start
2016-05-06 11:30:07 139843548858304 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1616819
2016-05-06 11:30:07 139842751006464 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-05-06 11:30:07 139843548858304 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-06 11:30:07 139843548858304 [Warning] 'user' entry 'root@523393210bb7' ignored in --skip-name-resolve mode.
2016-05-06 11:30:07 139843548858304 [Warning] 'proxies_priv' entry '@% root@523393210bb7' ignored in --skip-name-resolve mode.
2016-05-06 11:30:07 139843548858304 [Note] mysqld: ready for connections.
Version: '10.1.10-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
2016-05-06 11:30:09 139843548301056 [Warning] 'proxies_priv' entry '@% root@523393210bb7' ignored in --skip-name-resolve mode.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'blog``' at line 1
2016-05-06 11:30:10 139891827058624 [Note] mysqld (mysqld 10.1.10-MariaDB-1~jessie) starting as process 1 ...
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Memory barrier is not used
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Using Linux native AIO
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Using SSE crc32 instructions
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Completed initialization of buffer pool
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: The log sequence numbers 1616819 and 1616819 in ibdata files do not match the log sequence number 1616829 in the ib_logfiles!
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Database was not shutdown normally!
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Starting crash recovery.
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Restoring possible half-written data pages
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: from the doublewrite buffer...
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Waiting for purge to start
2016-05-06 11:30:10 139891827058624 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 1616829
2016-05-06 11:30:10 139891019060992 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-05-06 11:30:10 139891827058624 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-06 11:30:10 139891827058624 [Note] Recovering after a crash using tc.log
2016-05-06 11:30:10 139891827058624 [Note] Starting crash recovery...
2016-05-06 11:30:10 139891827058624 [Note] Crash recovery finished.
2016-05-06 11:30:10 139891827058624 [Note] Server socket created on IP: '::'.
2016-05-06 11:30:10 139891827058624 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired
2016-05-06 11:30:10 139891827058624 [Warning] Checking table: './mysql/user'
2016-05-06 11:30:10 139891827058624 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly
2016-05-06 11:30:10 139891827058624 [Warning] 'proxies_priv' entry '@% root@523393210bb7' ignored in --skip-name-resolve mode.
2016-05-06 11:30:10 139891827058624 [ERROR] mysqld: Table './mysql/time_zone_name' is marked as crashed and should be repaired
2016-05-06 11:30:10 139891827058624 [Warning] Checking table: './mysql/time_zone_name'
2016-05-06 11:30:10 139891827058624 [ERROR] mysql.time_zone_name: 1 client is using or hasn't closed the table properly
2016-05-06 11:30:10 139891827058624 [ERROR] mysqld: Table './mysql/time_zone' is marked as crashed and should be repaired
2016-05-06 11:30:10 139891827058624 [Warning] Checking table: './mysql/time_zone'
2016-05-06 11:30:10 139891827058624 [ERROR] mysql.time_zone: 1 client is using or hasn't closed the table properly
2016-05-06 11:30:10 139891827058624 [Note] mysqld: ready for connections.
Version: '10.1.10-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment