[bug] SubPath from #406

[andyli029]

Describe the problem
If data exits, upgrade will failed.
show info about DataVolumeName：

columns_priv.MYD  general_log.CSM         innodb_table_stats.frm  proxies_priv.frm          tables_priv.MYI
columns_priv.MYI  general_log.CSV         innodb_table_stats.ibd  server_cost.frm           tables_priv.frm
columns_priv.frm  general_log.frm         ndb_binlog_index.MYD    server_cost.ibd           time_zone.frm
db.MYD            gtid_executed.frm       ndb_binlog_index.MYI    servers.frm               time_zone.ibd
db.MYI            gtid_executed.ibd       ndb_binlog_index.frm    servers.ibd               time_zone_leap_second.frm
db.frm            help_category.frm       plugin.frm              slave_master_info.frm     time_zone_leap_second.ibd
db.opt            help_category.ibd       plugin.ibd              slave_master_info.ibd     time_zone_name.frm
engine_cost.frm   help_keyword.frm        proc.MYD                slave_relay_log_info.frm  time_zone_name.ibd
engine_cost.ibd   help_keyword.ibd        proc.MYI                slave_relay_log_info.ibd  time_zone_transition.frm
event.MYD         help_relation.frm       proc.frm                slave_worker_info.frm     time_zone_transition.ibd
event.MYI         help_relation.ibd       procs_priv.MYD          slave_worker_info.ibd     time_zone_transition_type.frm
event.frm         help_topic.frm          procs_priv.MYI          slow_log.CSM              time_zone_transition_type.ibd
func.MYD          help_topic.ibd          procs_priv.frm          slow_log.CSV              user.MYD
func.MYI          innodb_index_stats.frm  proxies_priv.MYD        slow_log.frm              user.MYI
func.frm          innodb_index_stats.ibd  proxies_priv.MYI        tables_priv.MYD           user.frm

To Reproduce

Expected behavior

Environment:

• RadonDB MySQL version: v.2.1.4

[runkecheng]

more detail? Why var/lib/mysql/mysql is empty? If mysql initialize successfully, the Dir will not empty.

[andyli029]

The info above is from var/lib/mysql/mysql.

[runkecheng]

I tested V2.1.2-> v2.1.4, did not encounter this problem, var/lib/mysql/mysql generated when initialization.

[andyli029]

You need test it again.
Think about #406.

[runkecheng]

You need test it again more. Think about #406.

need reclaim step.

[acekingke]

/var/lib/mysql is data directory， /var/lib/mysql/mysql is database mysql . so data directory do not have this files.
check whether the sidecar images and operator images consistent

[runkecheng]

expect mount:

/data/var/lib/kubelet/pods/01746017-d2a4-4c21-8eed-0008dd2888dd/volume-subpaths/pvc-56274bf9-5991-4e20-bd4d-2278485bd8d9# ls
backup  init-mysql  init-sidecar  mysql  xenon

/data/var/lib/kubelet/pods/01746017-d2a4-4c21-8eed-0008dd2888dd/volume-subpaths/pvc-56274bf9-5991-4e20-bd4d-2278485bd8d9/mysql/1# ls
auto.cnf         client-key.pem  ibdata1           mysql-bin.000002        mysql-relay-bin.000002  performance_schema  server-cert.pem  xtrabackup_binlog_pos_innodb
ca-key.pem       ib_buffer_pool  ibtmp1            mysql-bin.000003        mysql-relay-bin.index   private_key.pem     server-key.pem   xtrabackup_info
ca.pem           ib_logfile0     mysql             mysql-bin.index         mysql.sock              public_key.pem      sys              xtrabackup_master_key_id
client-cert.pem  ib_logfile1     mysql-bin.000001  mysql-relay-bin.000001  mysql.sock.lock         radondb             xb_doublewrite


root@worker-p001:/data/var/lib/kubelet/pods/01746017-d2a4-4c21-8eed-0008dd2888dd/volume-subpaths/pvc-56274bf9-5991-4e20-bd4d-2278485bd8d9/init-sidecar# ls
7  8
root@worker-p001:/data/var/lib/kubelet/pods/01746017-d2a4-4c21-8eed-0008dd2888dd/volume-subpaths/pvc-56274bf9-5991-4e20-bd4d-2278485bd8d9/init-sidecar# ls 7/
auto.cnf         client-key.pem  ibdata1           mysql-bin.000002        mysql-relay-bin.000002  performance_schema  server-cert.pem  xtrabackup_binlog_pos_innodb
ca-key.pem       ib_buffer_pool  ibtmp1            mysql-bin.000003        mysql-relay-bin.index   private_key.pem     server-key.pem   xtrabackup_info
ca.pem           ib_logfile0     mysql             mysql-bin.index         mysql.sock              public_key.pem      sys              xtrabackup_master_key_id
client-cert.pem  ib_logfile1     mysql-bin.000001  mysql-relay-bin.000001  mysql.sock.lock         radondb             xb_doublewrite
root@worker-p001:/data/var/lib/kubelet/pods/01746017-d2a4-4c21-8eed-0008dd2888dd/volume-subpaths/pvc-56274bf9-5991-4e20-bd4d-2278485bd8d9/init-sidecar# ls 8/
peers.json

But in some conditions, the generated directory is inconsistent with the expected results (it mount var/lib/mysql/mysql not var/lib/mysql), i haven't found the reason yet.