mariadb - SHOW FULL FIELDS FROM error
MariaDB [mysql]>show full fields from user;
ERROR 1036 (HY000): Table ‘/tmp/#sql_126_0.MAI’ is read only
This is affecting Rails/ActiveRecord further down my stack…
To reproduce…
docker 1.10.3 .. 1.12.6
alpine 3.5.x .. 3.6.0
$ docker run —rm -it latest /bin/sh
/ # apk -U add mariadb mariadb-client
fetch
http://dl-cdn.alpinelinux.org/alpine/v3.6/main/x86\_64/APKINDEX.tar.gz
fetch
http://dl-cdn.alpinelinux.org/alpine/v3.6/community/x86\_64/APKINDEX.tar.gz
(1/9) Installing mariadb-common (10.1.22-r1)
(2/9) Installing libaio (0.3.110-r0)
(3/9) Installing ncurses-terminfo-base (6.0-r7)
(4/9) Installing ncurses-terminfo (6.0-r7)
(5/9) Installing ncurses-libs (6.0-r7)
(6/9) Installing libgcc (6.3.0-r4)
(7/9) Installing libstdc (6.3.0-r4)
(8/9) Installing mariadb (10.1.22-r1)
Executing mariadb-10.1.22-r1.pre-install
(9/9) Installing mariadb-client (10.1.22-r1)
Executing busybox-1.26.2-r4.trigger
OK: 176 MiB in 20 packages
/ # mysql_install_db
Installing MariaDB/MySQL system tables in ‘/var/lib/mysql’ …
2017-05-30 18:18:49 139785626479432 [Note] /usr/bin/mysqld (mysqld
10.1.22-MariaDB) starting as process 96 …
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Using mutexes to
ref count buffer pool pages
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: The InnoDB memory
heap is disabled
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Mutexes and
rw_locks use GCC atomic builtins
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Compressed tables
use zlib 1.2.11
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Using Linux native
AIO
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Using SSE crc32
instructions
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Initializing buffer
pool, size = 128.0M
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Completed
initialization of buffer pool
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: The first specified
data file ./ibdata1 did not exist: a new database to be created!
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Setting file
./ibdata1 size to 12 MB
2017-05-30 18:18:49 139785626479432 [Note] InnoDB: Setting log file
./ib_logfile101 size to 48 MB
2017-05-30 18:18:50 139785626479432 [Note] InnoDB: Setting log file
./ib_logfile1 size to 48 MB
2017-05-30 18:18:50 139785626479432 [Note] InnoDB: Renaming log file
./ib_logfile101 to ./ib_logfile0
2017-05-30 18:18:50 139785626479432 [Warning] InnoDB: New log files
created, LSN=45883
2017-05-30 18:18:50 139785626479432 [Note] InnoDB: Doublewrite buffer
not found: creating new
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: Doublewrite buffer
created
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: 128 rollback
segment(s) are active.
2017-05-30 18:18:51 139785626479432 [Warning] InnoDB: Creating foreign
key constraint system tables.
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: Foreign key
constraint system tables created
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: Creating tablespace
and datafile system tables.
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: Tablespace and
datafile system tables created.
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: Waiting for purge
to start
2017-05-30 18:18:51 139785626479432 [Note] InnoDB: Percona XtraDB
(http://www.percona.com) 5.6.35-80.0 started; log sequence number 0
2017-05-30 18:18:51 139785263569640 [Note] InnoDB: Dumping buffer
pool(s) not yet started
2017-05-30 18:18:51 139785263209192 [Warning] Failed to load slave
replication state from table mysql.gtid_slave_pos: 1146: Table
‘mysql.gtid_slave_pos’ doesn’t exist
OK
Filling help tables…
2017-05-30 18:18:55 139974328748872 [Note] /usr/bin/mysqld (mysqld
10.1.22-MariaDB) starting as process 125 …
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Using mutexes to
ref count buffer pool pages
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: The InnoDB memory
heap is disabled
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Mutexes and
rw_locks use GCC atomic builtins
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Compressed tables
use zlib 1.2.11
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Using Linux native
AIO
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Using SSE crc32
instructions
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Initializing buffer
pool, size = 128.0M
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Completed
initialization of buffer pool
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Highest supported
file format is Barracuda.
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: 128 rollback
segment(s) are active.
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Waiting for purge
to start
2017-05-30 18:18:55 139974328748872 [Note] InnoDB: Percona XtraDB
(http://www.percona.com) 5.6.35-80.0 started; log sequence number
1616799
2017-05-30 18:18:55 139973972822760 [Note] InnoDB: Dumping buffer
pool(s) not yet started
OK
Creating OpenGIS required SP-s…
2017-05-30 18:18:58 140416992480072 [Note] /usr/bin/mysqld (mysqld
10.1.22-MariaDB) starting as process 155 …
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Using mutexes to
ref count buffer pool pages
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: The InnoDB memory
heap is disabled
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Mutexes and
rw_locks use GCC atomic builtins
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Compressed tables
use zlib 1.2.11
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Using Linux native
AIO
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Using SSE crc32
instructions
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Initializing buffer
pool, size = 128.0M
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Completed
initialization of buffer pool
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Highest supported
file format is Barracuda.
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: 128 rollback
segment(s) are active.
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Waiting for purge
to start
2017-05-30 18:18:58 140416992480072 [Note] InnoDB: Percona XtraDB
(http://www.percona.com) 5.6.35-80.0 started; log sequence number
1616809
2017-05-30 18:18:58 140416636553960 [Note] InnoDB: Dumping buffer
pool(s) not yet started
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
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 3c42e00ef39f 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.
You can start the MariaDB daemon with:
cd ‘/usr’ ; /usr/bin/mysqld_safe —datadir=‘/var/lib/mysql’
You can test the MariaDB daemon with mysql-test-run.pl
cd ‘/usr/mysql-test’ ; perl mysql-test-run.pl
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
Consider joining MariaDB’s strong and vibrant community:
https://mariadb.org/get-involved/
/ # mysqld_safe &
170530 18:19:59 mysqld_safe Logging to
‘/var/lib/mysql/3c42e00ef39f.err’.
170530 18:19:59 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/# mysql mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.22-MariaDB MariaDB Server
Copyright © 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [mysql]>show full fields from user;
ERROR 1036 (HY000): Table ‘/tmp/#sql_13a_0.MAI’ is read only
MariaDB [mysql]>\q
Bye
/ # ls -alF /tmp
total 4
drwxrwxrwt 2 root root 6 May 30 18:20 ./
drwxr-xr-x 18 root root 4096 May 30 18:16 ../
/ #
(from redmine: issue id 7345, created on 2017-05-30, closed on 2019-05-03)