GitLab

command remote-option-def6-set on debian10 with:

wlodek@debian10-64-1:~ $ mysql --version
mysql  Ver 15.1 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

all is fresh install from debs (isc0040620190820192009) from nexus, also I created bd schema using kea-admin from deb

command:

{'arguments': {'option-defs': [{'code': 222,
                                'name': 'foo',
                                'type': 'uint32'}],
               'remote': {'type': 'mysql'},
               'server-tags': ['all']},
 'command': 'remote-option-def6-set',
 'service': ['dhcp6']}

response:

[
  {
    "result": 1,
    "text": "unable to execute for <UPDATE dhcp6_option_def AS d INNER JOIN dhcp6_option_def_server AS a  ON d.id = a.option_def_id INNER JOIN dhcp6_server AS s  ON a.server_id = s.id SET  d.code = ?,  d.name = ?,  d.space = ?,  d.type = ?,  d.modification_ts = ?,  d.array = ?,  d.encapsulate = ?,  d.record_types = ?,  d.user_context = ? WHERE s.tag = ? AND d.code = ? AND d.space = ?>, reason: Prepared statement needs to be re-prepared (error code 1615)"
  }
]