Elena Stepanova elenst
elenst
/ gist:e2e1fd9109916a55430e7b993585634e
Created
March 15, 2017 18:32
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1980 cp vm-jessie-amd64-qa.qcow2 vm-jessie-qa.qcow2 | |
| 1981 qemu-img rebase -b vm-jessie-qa.qcow2 vm-jessie-amd64-qa-upgrade.qcow2 | |
| 1982 qemu-img commit vm-jessie-amd64-qa-upgrade.qcow2 | |
| 1983 qemu-img info vm-jessie-amd64-qa-upgrade.qcow2 | |
| 1984 qemu-img commit vm-jessie-qa.qcow2 | |
| 1985 qemu-img info vm-jessie-qa.qcow2 | |
| 1986 runvm --port=10730 --user=buildbot --smp=4 --cpu=qemu64 --startup-timeout=600 vm-jessie-qa.qcow2 bash | |
| 1987 runvm --port=10730 --user=buildbot --smp=4 --cpu=qemu64 --startup-timeout=600 vm-jessie-amd64-qa.qcow2 bash | |
| 1988 runvm --port=10730 --user=buildbot --smp=4 --cpu=qemu64 --startup-timeout=600 vm-jessie-qa.qcow2 bash | |
| 1989 cp vm-jessie-qa.qcow2 /kvm/vms/ |
elenst
/ gist:1608c026a2be87e6f9d42f22ec5c5763
Created
March 7, 2017 12:59
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| set names utf8; | |
| SELECT (COLUMN_GET(COLUMN_GET(COLUMN_CREATE('child', COLUMN_CREATE('int', 123)), 'child' AS char), 'int' AS char) * 2); | |
| SELECT (COLUMN_GET(COLUMN_GET(COLUMN_CREATE('child', COLUMN_CREATE('int', 123)), 'child' AS binary), 'int' AS char) * 2); |
elenst
/ gist:08399edca7f42b82ce0e42c027a19386
Created
March 7, 2017 12:46
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MariaDB [test]> show variables like '%char%'; | |
| +--------------------------+--------------------------------+ | |
| | Variable_name | Value | | |
| +--------------------------+--------------------------------+ | |
| | character_set_client | utf8 | | |
| | character_set_connection | utf8 | | |
| | character_set_database | latin1 | | |
| | character_set_filesystem | binary | | |
| | character_set_results | utf8 | | |
| | character_set_server | latin1 | |
elenst
/ gist:61c407cef605eb5f05adfbcc834c3517
Created
March 7, 2017 12:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MariaDB [test]> SELECT (COLUMN_GET(COLUMN_GET(COLUMN_CREATE('child', COLUMN_CREATE('int', 123)), 'child' AS char), 'int' AS char) * 2); | |
| +-----------------------------------------------------------------------------------------------------------------+ | |
| | (COLUMN_GET(COLUMN_GET(COLUMN_CREATE('child', COLUMN_CREATE('int', 123)), 'child' AS char), 'int' AS char) * 2) | | |
| +-----------------------------------------------------------------------------------------------------------------+ | |
| | 246 | | |
| +-----------------------------------------------------------------------------------------------------------------+ | |
| 1 row in set (0.00 sec) | |
| MariaDB [test]> SELECT (COLUMN_GET(COLUMN_GET(COLUMN_CREATE('child', COLUMN_CREATE('int', 123)), 'child' AS binary), 'int' AS char) * 2); | |
| +-------------------------------------------------------------------------------------------------------------------+ |
elenst
/ 2017-03-01 crash in Log_event::read_log_event
Created
March 1, 2017 13:24
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 170301 2:23:22 [Note] /home/elenst/git/bb-10.0-monty-rel/sql/mysqld (mysqld 10.0.30-MariaDB) starting as process 33045 ... | |
| 170301 2:23:22 [Note] InnoDB: Using mutexes to ref count buffer pool pages | |
| 170301 2:23:22 [Note] InnoDB: The InnoDB memory heap is disabled | |
| 170301 2:23:22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 170301 2:23:22 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
| 170301 2:23:22 [Note] InnoDB: Compressed tables use zlib 1.2.3.4 | |
| 170301 2:23:22 [Note] InnoDB: Using Linux native AIO | |
| 170301 2:23:22 [Note] InnoDB: Using CPU crc32 instructions | |
| 170301 2:23:22 [Note] InnoDB: Initializing buffer pool, size = 128.0M | |
| 170301 2:23:22 [Note] InnoDB: Completed initialization of buffer pool |
elenst
/ gist:9c236d14c6a17e21f0c88d869a88bf74
Created
February 20, 2017 11:12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CPack Error: Error while execution CPackRPM.cmake | |
| CPackRPM:Debug: rpmbuild version is <4.11.2> | |
| CPackRPM:Debug: LSB_RELEASE = lsb_release not installed/found! | |
| CPackRPM:Debug: Trying to build a relocatable package | |
| CPackRPM:Debug: removing '/usr' from relocation paths | |
| CPackRPM:Debug: processing URL | |
| CPackRPM:Debug: CPACK_RPM_test_PACKAGE_URL not defined | |
| CPackRPM:Debug: using CPACK_RPM_PACKAGE_URL | |
| CPackRPM:Debug: User defined Url: | |
| http://mariadb.org |
elenst
/ gist:8dd1e574a17420b4ca0c7952360b4485
Created
February 19, 2017 21:34
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ESC[0;31m"....insert into t2 values (7750+0.33)ESC[0m | |
| ESC[0;31m...........ESC[0m | |
| ESC[0;31m"....insert into t2 values (7750+0.75)ESC[0m | |
| ESC[0;31m...........ESC[0m | |
| ESC[0;31m.....insert into t2 values (7749)ESC[0m | |
| ESC[0;31m...........ESC[0m | |
| ESC[0;31m"....insert into t2 values (7749+0.33)ESC[0m | |
| ESC[0;31m...........ESC[0m | |
| ESC[0;31m"....insert into t2 values (7749+0.75)ESC[0m | |
| ESC[0;31m...........ESC[0m |
elenst
/ gist:b32bda21b65d275496a9af62f335efc4
Created
February 19, 2017 18:30
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Thread 1 (Thread 0x2b675ed3ead0 (LWP 31223)): | |
| #0 0x00000036decca3ff in poll () from /lib64/libc.so.6 | |
| #1 0x0000000000467d90 in pvio_socket_wait_io_or_timeout (pvio=<value optimized out>, is_read=<value optimized out>, timeout=-1) | |
| at /home/buildbot/buildbot/build/libmariadb/plugins/pvio/pvio_socket.c:511 | |
| #2 0x0000000000467e27 in pvio_socket_read (pvio=0x7fff4c072860, buffer=0x10cd4450 "\a", length=16384) at /home/buildbot/buildbot/build/libmariadb/plugins/pvio/pvio_socket.c:279 | |
| #3 0x0000000000455df0 in ma_pvio_read (pvio=0x10cd43e0, buffer=0x10cd4450 "\a", length=16384) at /home/buildbot/buildbot/build/libmariadb/libmariadb/ma_pvio.c:251 | |
| #4 0x0000000000455f01 in ma_pvio_cache_read (pvio=0x7fff4c072860, buffer=0x10cd8460 "\"", length=4) at /home/buildbot/buildbot/build/libmariadb/libmariadb/ma_pvio.c:293 | |
| #5 0x000000000046b6fb in ma_real_read (net=0x10cc2c10, complen=0x7fff4c0729b0) at /home/buildbot/buildbot/build/libmariadb/libmariadb/ma_net.c:376 | |
| #6 0x000000000046b861 in ma_net_read (net=0x7fff4c072 |
elenst
/ gist:04ae9f64c717a16c6845d4246933a272
Created
February 19, 2017 15:48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Thread 7 (Thread 0x4164a940 (LWP 14339)): | |
| #0 0x00000036df40ab00 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 | |
| #1 0x0000000000de58b9 in inline_mysql_cond_timedwait (arg=<value optimized out>) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1175 | |
| #2 timer_handler (arg=<value optimized out>) at /home/buildbot/buildbot/build/mysys/thr_timer.c:292 | |
| #3 0x0000000000ce2d19 in pfs_spawn_thread (arg=<value optimized out>) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1862 | |
| #4 0x00000036df406367 in start_thread () from /lib64/libpthread.so.0 | |
| #5 0x00000036decd2f7d in clone () from /lib64/libc.so.6 | |
| Thread 6 (Thread 0x4204b940 (LWP 14340)): | |
| #0 0x00000036df40ab00 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 |
elenst
/ #11 (2017-02-19)
Created
February 19, 2017 00:01
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| bb-10.0-monty 5c1c0416487ad5cd764ae64c00b2c5fe046134d0 | |
| Unfortunately I don't have a processlist for this one | |
| Thread 29 (Thread 0x7f724e3ff700 (LWP 3275)): | |
| #0 0x00007f72637080fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 | |
| #1 0x00000000008508f6 in inline_mysql_cond_timedwait (src_file=0xc49550 "/home/elenst/git/bb-10.0-monty-rel/storage/maria/ma_servicethread.c", src_line=116, abstime=0x7f724e3fed60, mutex=0x1aefa00 <LOCK_checkpoint>, that=0x1aef9c0 <COND_checkpoint>) at /home/elenst/git/bb-10.0-monty-rel/include/mysql/psi/mysql_thread.h:1202 | |
| #2 my_service_thread_sleep (control=control@entry=0x1254e00 <checkpoint_control>, sleep_time=<optimised out>) at /home/elenst/git/bb-10.0-monty-rel/storage/maria/ma_servicethread.c:115 | |
| #3 0x000000000084a492 in ma_checkpoint_background (arg=arg@entry=0x1e) at /home/elenst/git/bb-10.0-monty-rel/storage/maria/ma_checkpoint.c:708 |