ProblemType: Bug
.etc.apparmor.d.usr.sbin.mysqld:
 # vim:syntax=apparmor
 # Last Modified: Tue Jun 19 17:37:30 2007
 #include <tunables/global>
 
 /usr/sbin/mysqld {
   #include <abstractions/base>
   #include <abstractions/nameservice>
   #include <abstractions/user-tmp>
   #include <abstractions/mysql>
   #include <abstractions/winbind>
 
   capability dac_override,
   capability sys_resource,
   capability setgid,
   capability setuid,
 
   network tcp,
 
   /etc/hosts.allow r,
   /etc/hosts.deny r,
 
   /etc/mysql/** r,
   /usr/lib/mysql/plugin/ r,
   /usr/lib/mysql/plugin/*.so* mr,
   /usr/sbin/mysqld mr,
   /usr/share/mysql/** r,
   /var/log/mysql.log rw,
   /var/log/mysql.err rw,
   /var/lib/mysql/ r,
   /var/lib/mysql/** rwk,
   /var/log/mysql/ r,
   /var/log/mysql/* rw,
   /var/run/mysqld/mysqld.pid rw,
   /var/run/mysqld/mysqld.sock w,
   /run/mysqld/mysqld.pid rw,
   /run/mysqld/mysqld.sock w,
 
   /sys/devices/system/cpu/ r,
 
   # Site-specific additions and overrides. See local/README for details.
   #include <local/usr.sbin.mysqld>
 }
ApportVersion: 2.17-0ubuntu1
Architecture: amd64
Date: Thu Apr  2 16:25:03 2015
Dependencies:
 gcc-4.9-base 4.9.2-10ubuntu12
 gcc-5-base 5-20150401-0ubuntu1
 libaio1 0.3.110-1
 libc6 2.21-0ubuntu4
 libgcc1 1:5-20150401-0ubuntu1
 libstdc++6 4.9.2-10ubuntu12
 libwrap0 7.6.q-25
 multiarch-support 2.21-0ubuntu4
 tcpd 7.6.q-25
 zlib1g 1:1.2.8.dfsg-2ubuntu1
DistroRelease: Ubuntu 15.04
Ec2AMI: ami-00000d16
Ec2AMIManifest: FIXME
Ec2AvailabilityZone: nova
Ec2InstanceType: m1.small
Ec2Kernel: aki-0000022a
Ec2Ramdisk: ari-0000022a
JournalErrors:
 -- Logs begin at Thu 2015-04-02 15:32:27 UTC, end at Thu 2015-04-02 16:24:54 UTC. --
 Apr 02 15:32:27 hostname kernel: ACPI: RSDP 0x00000000000F1470 000014 (v00 BOCHS )
 Apr 02 15:32:27 hostname kernel: ACPI: RSDT 0x000000007FFFE450 000034 (v01 BOCHS  BXPCRSDT 00000001 BXPC 00000001)
 Apr 02 15:32:27 hostname kernel: ACPI: FACP 0x000000007FFFFF80 000074 (v01 BOCHS  BXPCFACP 00000001 BXPC 00000001)
 Apr 02 15:32:27 hostname kernel: ACPI: DSDT 0x000000007FFFE490 001137 (v01 BXPC   BXDSDT   00000001 INTL 20100528)
 Apr 02 15:32:27 hostname kernel: ACPI: FACS 0x000000007FFFFF40 000040
 Apr 02 15:32:27 hostname kernel: ACPI: SSDT 0x000000007FFFF700 000838 (v01 BOCHS  BXPCSSDT 00000001 BXPC 00000001)
 Apr 02 15:32:27 hostname kernel: ACPI: APIC 0x000000007FFFF610 000078 (v01 BOCHS  BXPCAPIC 00000001 BXPC 00000001)
 Apr 02 15:32:27 hostname kernel: ACPI: HPET 0x000000007FFFF5D0 000038 (v01 BOCHS  BXPCHPET 00000001 BXPC 00000001)
 Apr 02 15:32:27 hostname kernel: ACPI: All ACPI Tables successfully acquired
 Apr 02 15:32:27 hostname kernel: NMI watchdog: disabled (cpu0): hardware events not enabled
 Apr 02 15:32:27 hostname kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S1_] (20141107/hwxface-580)
 Apr 02 15:32:27 hostname kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S2_] (20141107/hwxface-580)
 Apr 02 15:32:27 hostname kernel: acpi PNP0A03:00: fail to add MMCONFIG information, can't access extended PCI configuration space under this bridge.
 Apr 02 15:32:27 hostname kernel: ACPI: Enabled 16 GPEs in block 00 to 0F
 Apr 02 15:32:27 hostname kernel: ACPI: PCI Interrupt Link [LNKD] enabled at IRQ 11
 Apr 02 15:32:27 hostname kernel: ACPI: PCI Interrupt Link [LNKC] enabled at IRQ 10
 Apr 02 15:32:27 hostname kernel: ACPI: PCI Interrupt Link [LNKA] enabled at IRQ 10
 Apr 02 15:32:27 hostname kernel: ACPI: PCI Interrupt Link [LNKB] enabled at IRQ 11
 Apr 02 15:32:27 hostname kernel: PCCT header not found.
 Apr 02 15:32:27 hostname kernel: ACPI PCC probe failed.
 Apr 02 15:32:27 hostname systemd[1]: Cannot add dependency job for unit sshd-keygen.service, ignoring: Unit sshd-keygen.service failed to load: No such file or directory.
 Apr 02 15:32:27 hostname systemd[1]: Cannot add dependency job for unit display-manager.service, ignoring: Unit display-manager.service failed to load: No such file or directory.
 Apr 02 15:32:29 hostname systemd-tmpfiles[359]: [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path "/var/log", ignoring.
 Apr 02 15:32:32 hostname /usr/sbin/irqbalance[589]: Balancing is ineffective on systems with a single cache domain.  Shutting down
 Apr 02 15:32:39 hostname sshd[789]: error: Could not load host key: /etc/ssh/ssh_host_ed25519_key
 Apr 02 15:47:41 hostname systemd-tmpfiles[6144]: [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path "/var/log", ignoring.
 Apr 02 16:03:42 hostname sudo[6178]: username : unable to resolve host hostname
 Apr 02 16:21:06 hostname kernel: sched: RT throttling activated
 Apr 02 16:21:55 hostname mysqld_safe[9835]: 2015-04-02 16:21:55 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 Apr 02 16:22:45 hostname mysqld_safe[9873]: 2015-04-02 16:22:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 Apr 02 16:22:49 hostname mysqld_safe[9898]: 2015-04-02 16:22:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 Apr 02 16:24:33 hostname sudo[10465]: username : unable to resolve host hostname
 Apr 02 16:24:44 hostname sudo[10494]: username : unable to resolve host hostname
 Apr 02 16:24:54 hostname sudo[10496]: username : unable to resolve host hostname
KernLog:
 [    0.010276] Security Framework initialized
 [    0.012009] AppArmor: AppArmor initialized
 [    0.077438] evm: security.selinux
 [    0.078159] evm: security.SMACK64
 [    0.078863] evm: security.SMACK64EXEC
 [    0.079622] evm: security.SMACK64TRANSMUTE
 [    0.080003] evm: security.SMACK64MMAP
 [    0.080757] evm: security.ima
 [    0.081411] evm: security.capability
 [    0.410546] AppArmor: AppArmor Filesystem Enabled
 [    0.622219] audit: type=2000 audit(1427988733.804:1): initialized
 [    0.889206] AppArmor: AppArmor sha1 policy hashing enabled
 [    8.812049] systemd[1]: systemd 219 running in system mode. (+PAM +AUDIT +SELINUX +IMA +APPARMOR +SMACK +SYSVINIT +UTMP +LIBCRYPTSETUP +GCRYPT -GNUTLS +ACL +XZ -LZ4 -SECCOMP +BLKID -ELFUTILS +KMOD -IDN)
 [   18.157754] audit: type=1400 audit(1427988751.760:2): apparmor="STATUS" operation="profile_load" profile="unconfined" name="/sbin/dhclient" pid=415 comm="apparmor_parser"
 [   18.157766] audit: type=1400 audit(1427988751.760:3): apparmor="STATUS" operation="profile_load" profile="unconfined" name="/usr/lib/NetworkManager/nm-dhcp-client.action" pid=415 comm="apparmor_parser"
 [   18.157774] audit: type=1400 audit(1427988751.760:4): apparmor="STATUS" operation="profile_load" profile="unconfined" name="/usr/lib/NetworkManager/nm-dhcp-helper" pid=415 comm="apparmor_parser"
 [   18.157780] audit: type=1400 audit(1427988751.760:5): apparmor="STATUS" operation="profile_load" profile="unconfined" name="/usr/lib/connman/scripts/dhclient-script" pid=415 comm="apparmor_parser"
 [   18.162830] audit: type=1400 audit(1427988751.764:6): apparmor="STATUS" operation="profile_load" profile="unconfined" name="/usr/sbin/tcpdump" pid=415 comm="apparmor_parser"
 [ 3038.889414] audit: type=1400 audit(1427991772.491:7): apparmor="STATUS" operation="profile_load" profile="unconfined" name="/usr/sbin/mysqld" pid=9929 comm="apparmor_parser"
 
Logs.var.log.daemon.log: 
Logs.var.log.mysql.error.log:
 2015-04-02 16:21:55 9834 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
 2015-04-02 16:21:55 9834 [Note] Plugin 'FEDERATED' is disabled.
 2015-04-02 16:21:55 9834 [Note] InnoDB: Using atomics to ref count buffer pool pages
 2015-04-02 16:21:55 9834 [Note] InnoDB: The InnoDB memory heap is disabled
 2015-04-02 16:21:55 9834 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 2015-04-02 16:21:55 9834 [Note] InnoDB: Memory barrier is not used
 2015-04-02 16:21:55 9834 [Note] InnoDB: Compressed tables use zlib 1.2.8
 2015-04-02 16:21:55 9834 [Note] InnoDB: Using Linux native AIO
 2015-04-02 16:21:55 9834 [Note] InnoDB: Using CPU crc32 instructions
 2015-04-02 16:21:55 9834 [Note] InnoDB: Initializing buffer pool, size = 128.0M
 2015-04-02 16:21:55 9834 [Note] InnoDB: Completed initialization of buffer pool
 2015-04-02 16:21:55 9834 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
 2015-04-02 16:21:55 9834 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
 2015-04-02 16:21:55 9834 [Note] InnoDB: Database physically writes the file full: wait...
 2015-04-02 16:22:00 9834 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
 2015-04-02 16:22:17 9834 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
 2015-04-02 16:22:24 9834 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 2015-04-02 16:22:24 9834 [Warning] InnoDB: New log files created, LSN=45781
 2015-04-02 16:22:24 9834 [Note] InnoDB: Doublewrite buffer not found: creating new
 2015-04-02 16:22:25 9834 [Note] InnoDB: Doublewrite buffer created
 2015-04-02 16:22:25 9834 [Note] InnoDB: 128 rollback segment(s) are active.
 2015-04-02 16:22:25 9834 [Warning] InnoDB: Creating foreign key constraint system tables.
 2015-04-02 16:22:25 9834 [Note] InnoDB: Foreign key constraint system tables created
 2015-04-02 16:22:25 9834 [Note] InnoDB: Creating tablespace and datafile system tables.
 2015-04-02 16:22:25 9834 [Note] InnoDB: Tablespace and datafile system tables created.
 2015-04-02 16:22:25 9834 [Note] InnoDB: Waiting for purge to start
 2015-04-02 16:22:25 9834 [Note] InnoDB: 5.6.23 started; log sequence number 0
 2015-04-02 16:22:43 9834 [Note] Binlog end
 2015-04-02 16:22:43 9834 [Note] InnoDB: FTS optimize thread exiting.
 2015-04-02 16:22:43 9834 [Note] InnoDB: Starting shutdown...
 2015-04-02 16:22:45 9834 [Note] InnoDB: Shutdown completed; log sequence number 1625977
 2015-04-02 16:22:45 9872 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
 2015-04-02 16:22:45 9872 [Note] Plugin 'FEDERATED' is disabled.
 2015-04-02 16:22:45 9872 [Note] InnoDB: Using atomics to ref count buffer pool pages
 2015-04-02 16:22:45 9872 [Note] InnoDB: The InnoDB memory heap is disabled
 2015-04-02 16:22:45 9872 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 2015-04-02 16:22:45 9872 [Note] InnoDB: Memory barrier is not used
 2015-04-02 16:22:45 9872 [Note] InnoDB: Compressed tables use zlib 1.2.8
 2015-04-02 16:22:45 9872 [Note] InnoDB: Using Linux native AIO
 2015-04-02 16:22:45 9872 [Note] InnoDB: Using CPU crc32 instructions
 2015-04-02 16:22:45 9872 [Note] InnoDB: Initializing buffer pool, size = 128.0M
 2015-04-02 16:22:45 9872 [Note] InnoDB: Completed initialization of buffer pool
 2015-04-02 16:22:45 9872 [Note] InnoDB: Highest supported file format is Barracuda.
 2015-04-02 16:22:45 9872 [Note] InnoDB: 128 rollback segment(s) are active.
 2015-04-02 16:22:45 9872 [Note] InnoDB: Waiting for purge to start
 2015-04-02 16:22:45 9872 [Note] InnoDB: 5.6.23 started; log sequence number 1625977
 2015-04-02 16:22:45 9872 [Note] Binlog end
 2015-04-02 16:22:45 9872 [Note] InnoDB: FTS optimize thread exiting.
 2015-04-02 16:22:45 9872 [Note] InnoDB: Starting shutdown...
 2015-04-02 16:22:48 9872 [Note] InnoDB: Shutdown completed; log sequence number 1625987
 2015-04-02 16:22:49 9897 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
 2015-04-02 16:22:49 9897 [Note] Plugin 'FEDERATED' is disabled.
 2015-04-02 16:22:49 9897 [Note] InnoDB: Using atomics to ref count buffer pool pages
 2015-04-02 16:22:49 9897 [Note] InnoDB: The InnoDB memory heap is disabled
 2015-04-02 16:22:49 9897 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 2015-04-02 16:22:49 9897 [Note] InnoDB: Memory barrier is not used
 2015-04-02 16:22:49 9897 [Note] InnoDB: Compressed tables use zlib 1.2.8
 2015-04-02 16:22:49 9897 [Note] InnoDB: Using Linux native AIO
 2015-04-02 16:22:49 9897 [Note] InnoDB: Using CPU crc32 instructions
 2015-04-02 16:22:49 9897 [Note] InnoDB: Initializing buffer pool, size = 128.0M
 2015-04-02 16:22:49 9897 [Note] InnoDB: Completed initialization of buffer pool
 2015-04-02 16:22:49 9897 [Note] InnoDB: Highest supported file format is Barracuda.
 2015-04-02 16:22:49 9897 [Note] InnoDB: 128 rollback segment(s) are active.
 2015-04-02 16:22:49 9897 [Note] InnoDB: Waiting for purge to start
 2015-04-02 16:22:49 9897 [Note] InnoDB: 5.6.23 started; log sequence number 1625987
 2015-04-02 16:22:49 9897 [Note] Binlog end
 2015-04-02 16:22:49 9897 [Note] InnoDB: FTS optimize thread exiting.
 2015-04-02 16:22:49 9897 [Note] InnoDB: Starting shutdown...
 2015-04-02 16:22:52 9897 [Note] InnoDB: Shutdown completed; log sequence number 1625997
 150402 16:22:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 2015-04-02 16:22:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 2015-04-02 16:22:57 10333 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
 
 2015-04-02 16:22:57 10333 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
 
 2015-04-02 16:22:57 10333 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
 2015-04-02 16:22:57 10333 [Note] Plugin 'FEDERATED' is disabled.
 2015-04-02 16:22:57 10333 [ERROR] Function 'innodb' already exists
 2015-04-02 16:22:57 10333 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
 2015-04-02 16:22:57 10333 [ERROR] Function 'federated' already exists
 2015-04-02 16:22:57 10333 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
 2015-04-02 16:22:57 10333 [ERROR] Function 'blackhole' already exists
 2015-04-02 16:22:57 10333 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
 2015-04-02 16:22:57 10333 [ERROR] Function 'archive' already exists
 2015-04-02 16:22:57 10333 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
 2015-04-02 16:22:57 10333 [Note] InnoDB: Using atomics to ref count buffer pool pages
 2015-04-02 16:22:57 10333 [Note] InnoDB: The InnoDB memory heap is disabled
 2015-04-02 16:22:57 10333 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 2015-04-02 16:22:57 10333 [Note] InnoDB: Memory barrier is not used
 2015-04-02 16:22:57 10333 [Note] InnoDB: Compressed tables use zlib 1.2.8
 2015-04-02 16:22:57 10333 [Note] InnoDB: Using Linux native AIO
 2015-04-02 16:22:57 10333 [Note] InnoDB: Using CPU crc32 instructions
 2015-04-02 16:22:57 10333 [Note] InnoDB: Initializing buffer pool, size = 128.0M
 2015-04-02 16:22:57 10333 [Note] InnoDB: Completed initialization of buffer pool
 2015-04-02 16:22:57 10333 [Note] InnoDB: Highest supported file format is Barracuda.
 2015-04-02 16:22:58 10333 [Note] InnoDB: 128 rollback segment(s) are active.
 2015-04-02 16:22:58 10333 [Note] InnoDB: Waiting for purge to start
 2015-04-02 16:22:58 10333 [Note] InnoDB: 5.6.23 started; log sequence number 1625997
 2015-04-02 16:22:58 10333 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 863de9d7-d954-11e4-915d-fa163ef96732.
 2015-04-02 16:22:58 10333 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
 2015-04-02 16:22:58 10333 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
 2015-04-02 16:22:58 10333 [Note] Server socket created on IP: '127.0.0.1'.
 2015-04-02 16:22:58 10333 [Note] Event Scheduler: Loaded 0 events
 2015-04-02 16:22:58 10333 [Note] /usr/sbin/mysqld: ready for connections.
 Version: '5.6.23-1~exp1~ubuntu5'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
 
MySQLConf.etc.mysql.conf.d.mysql.cnf:
 [mysql]
 
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet	= 16M
 
MySQLConf.etc.mysql.my.cnf:
 #
 # The MySQL database server configuration file.
 #
 # You can copy this to one of:
 # - "/etc/mysql/my.cnf" to set global options,
 # - "~/.my.cnf" to set user-specific options.
 # 
 # One can use all long options that the program supports.
 # Run program with --help to get a list of available options and with
 # --print-defaults to see which it would actually understand and use.
 #
 # For explanations see
 # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
 #
 # * IMPORTANT: Additional settings that can override those from this file!
 #   The files must end with '.cnf', otherwise they'll be ignored.
 #
 
 !includedir /etc/mysql/conf.d/
 !includedir /etc/mysql/mysql.conf.d/
 
MySQLVarLibDirListing: False
Package: mysql-server-core-5.6 5.6.23-1~exp1~ubuntu5
PackageArchitecture: amd64
ProcEnviron:
 LC_TIME=en_US.UTF-8
 LC_MONETARY=en_US.UTF-8
 TERM=xterm
 PATH=(custom, no user)
 LC_ADDRESS=en_US.UTF-8
 XDG_RUNTIME_DIR=<set>
 LC_TELEPHONE=en_US.UTF-8
 LANG=en_US.UTF-8
 SHELL=/bin/bash
 LC_NAME=en_US.UTF-8
 LC_MEASUREMENT=en_US.UTF-8
 LC_IDENTIFICATION=en_US.UTF-8
 LC_NUMERIC=en_US.UTF-8
 LC_PAPER=en_US.UTF-8
ProcVersionSignature: User Name 3.19.0-11.11-generic 3.19.3
SourcePackage: mysql-5.6
Tags:  vivid ec2-images
Uname: Linux 3.19.0-11-generic x86_64
UpgradeStatus: No upgrade log present (probably fresh install)
_MarkForUpload: True