{"action":"created","issue":{"url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/issues/9","repository_url":"https://api.github.com/repos/biggis-project/biggis-infrastructure","labels_url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/issues/9/comments","events_url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/issues/9/events","html_url":"https://github.com/biggis-project/biggis-infrastructure/issues/9","id":165599974,"number":9,"title":"mariadb warnings","user":{"login":"vsimko","id":7080773,"avatar_url":"https://avatars.githubusercontent.com/u/7080773?v=3","gravatar_id":"","url":"https://api.github.com/users/vsimko","html_url":"https://github.com/vsimko","followers_url":"https://api.github.com/users/vsimko/followers","following_url":"https://api.github.com/users/vsimko/following{/other_user}","gists_url":"https://api.github.com/users/vsimko/gists{/gist_id}","starred_url":"https://api.github.com/users/vsimko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vsimko/subscriptions","organizations_url":"https://api.github.com/users/vsimko/orgs","repos_url":"https://api.github.com/users/vsimko/repos","events_url":"https://api.github.com/users/vsimko/events{/privacy}","received_events_url":"https://api.github.com/users/vsimko/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"wipatrick","id":15153294,"avatar_url":"https://avatars.githubusercontent.com/u/15153294?v=3","gravatar_id":"","url":"https://api.github.com/users/wipatrick","html_url":"https://github.com/wipatrick","followers_url":"https://api.github.com/users/wipatrick/followers","following_url":"https://api.github.com/users/wipatrick/following{/other_user}","gists_url":"https://api.github.com/users/wipatrick/gists{/gist_id}","starred_url":"https://api.github.com/users/wipatrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wipatrick/subscriptions","organizations_url":"https://api.github.com/users/wipatrick/orgs","repos_url":"https://api.github.com/users/wipatrick/repos","events_url":"https://api.github.com/users/wipatrick/events{/privacy}","received_events_url":"https://api.github.com/users/wipatrick/received_events","type":"User","site_admin":false},"assignees":[{"login":"wipatrick","id":15153294,"avatar_url":"https://avatars.githubusercontent.com/u/15153294?v=3","gravatar_id":"","url":"https://api.github.com/users/wipatrick","html_url":"https://github.com/wipatrick","followers_url":"https://api.github.com/users/wipatrick/followers","following_url":"https://api.github.com/users/wipatrick/following{/other_user}","gists_url":"https://api.github.com/users/wipatrick/gists{/gist_id}","starred_url":"https://api.github.com/users/wipatrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wipatrick/subscriptions","organizations_url":"https://api.github.com/users/wipatrick/orgs","repos_url":"https://api.github.com/users/wipatrick/repos","events_url":"https://api.github.com/users/wipatrick/events{/privacy}","received_events_url":"https://api.github.com/users/wipatrick/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/milestones/1","html_url":"https://github.com/biggis-project/biggis-infrastructure/milestones/M3%20-%20Integrated%20Prototype","labels_url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/milestones/1/labels","id":1638692,"number":1,"title":"M3 - Integrated Prototype","description":"Demo of data processing - ingest, preprocessing, kompression, analysis\r\n","creator":{"login":"vsimko","id":7080773,"avatar_url":"https://avatars.githubusercontent.com/u/7080773?v=3","gravatar_id":"","url":"https://api.github.com/users/vsimko","html_url":"https://github.com/vsimko","followers_url":"https://api.github.com/users/vsimko/followers","following_url":"https://api.github.com/users/vsimko/following{/other_user}","gists_url":"https://api.github.com/users/vsimko/gists{/gist_id}","starred_url":"https://api.github.com/users/vsimko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vsimko/subscriptions","organizations_url":"https://api.github.com/users/vsimko/orgs","repos_url":"https://api.github.com/users/vsimko/repos","events_url":"https://api.github.com/users/vsimko/events{/privacy}","received_events_url":"https://api.github.com/users/vsimko/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":2,"state":"open","created_at":"2016-03-11T10:32:27Z","updated_at":"2016-07-15T11:10:39Z","due_on":"2016-08-31T22:00:00Z","closed_at":null},"comments":4,"created_at":"2016-07-14T16:11:19Z","updated_at":"2016-07-15T11:10:39Z","closed_at":"2016-07-15T11:10:39Z","body":"When executing:\r\n``` sql\r\ndrop table if exists tiles;\r\n```\r\n\r\nThe following warning appears:\r\n```\r\nWhen creat\r\n0 row(s) affected, 1 warning(s): 1146 Table 'mysql.table_stats' doesn't exist\r\n```\r\n\r\nThis may be related to docker [Warning] and [ERROR] messages when starting mysql instance:\r\n```\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] mysqld (mysqld 10.1.14-MariaDB) starting as process 1 ...\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Using mutexes to ref count buffer pool pages\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: The InnoDB memory heap is disabled\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Memory barrier is not used\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Compressed tables use zlib 1.2.8\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Using Linux native AIO\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Using SSE crc32 instructions\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Initializing buffer pool, size = 128.0M\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Completed initialization of buffer pool\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Database physically writes the file full: wait...\r\ndb_1| 2016-07-14 15:55:59 139831771294760 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB\r\ndb_1| 2016-07-14 15:56:00 139831771294760 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Warning] InnoDB: New log files created, LSN=45883\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Doublewrite buffer not found: creating new\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Doublewrite buffer created\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: 128 rollback segment(s) are active.\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Warning] InnoDB: Creating foreign key constraint system tables.\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Foreign key constraint system tables created\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Creating tablespace and datafile system tables.\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Tablespace and datafile system tables created.\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB: Waiting for purge to start\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 0\r\ndb_1| 2016-07-14 15:56:01 139831440374448 [Note] InnoDB: Dumping buffer pool(s) not yet started\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] Plugin 'FEEDBACK' is disabled.\r\ndb_1| 2016-07-14 15:56:01 139831303170736 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] Server socket created on IP: '::'.\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them\r\ndb_1| 2016-07-14 15:56:01 139831302556336 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist\r\ndb_1| 2016-07-14 15:56:01 139831771294760 [Note] mysqld: ready for connections.\r\ndb_1| Version: '10.1.14-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server\r\n```"},"comment":{"url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/issues/comments/232924765","html_url":"https://github.com/biggis-project/biggis-infrastructure/issues/9#issuecomment-232924765","issue_url":"https://api.github.com/repos/biggis-project/biggis-infrastructure/issues/9","id":232924765,"user":{"login":"vsimko","id":7080773,"avatar_url":"https://avatars.githubusercontent.com/u/7080773?v=3","gravatar_id":"","url":"https://api.github.com/users/vsimko","html_url":"https://github.com/vsimko","followers_url":"https://api.github.com/users/vsimko/followers","following_url":"https://api.github.com/users/vsimko/following{/other_user}","gists_url":"https://api.github.com/users/vsimko/gists{/gist_id}","starred_url":"https://api.github.com/users/vsimko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vsimko/subscriptions","organizations_url":"https://api.github.com/users/vsimko/orgs","repos_url":"https://api.github.com/users/vsimko/repos","events_url":"https://api.github.com/users/vsimko/events{/privacy}","received_events_url":"https://api.github.com/users/vsimko/received_events","type":"User","site_admin":false},"created_at":"2016-07-15T11:10:39Z","updated_at":"2016-07-15T11:10:39Z","body":"yes, but make sure that \"mysql\" database exists in the image when someone downloads it.\r\nI fixed the problem only inside my docker installation."}}
{"actor":{"display_login":"vsimko"}}