Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • Kea Kea
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 555
    • Issues 555
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 66
    • Merge requests 66
  • Deployments
    • Deployments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • ISC Open Source ProjectsISC Open Source Projects
  • KeaKea
  • Issues
  • #1066
Closed
Open
Issue created Dec 19, 2019 by Maxim Bich@Kazun3500

DHCP6_CONFIG_LOAD_FAIL configuration error using file -- Extra data in statement

I user mysql db configuration backend and after start dhcpv6 server i got an error

2019-12-19 09:37:05.934 ERROR [kea-dhcp6.dhcp6/4219] DHCP6_CONFIG_LOAD_FAIL configuration error using file: /usr/local/etc/kea/kea-dhcp6.conf.my, reason: during update from config backend database: Extra data in <string>:1:2. Statement is <SELECT  s.subnet_id,  s.subnet_prefix,  s.client_class,  s.interface,  s.modification_ts,  s.preferred_lifetime,  s.rapid_commit,  s.rebind_timer,  s.relay,  s.renew_timer,  s.require_client_classes,  s.reservation_mode,  s.shared_network_name,  s.user_context,  s.valid_lifetime,  p.id,  p.start_address,  p.end_address,  p.subnet_id,  p.modification_ts,  d.id,  d.prefix,  d.prefix_length,  d.delegated_prefix_length,  d.subnet_id,  d.modification_ts,  x.option_id,  x.code,  x.value,  x.formatted_value,  x.space,  x.persistent,  x.dhcp6_subnet_id,  x.scope_id,  x.user_context,  x.shared_network_name,  x.pool_id,  x.modification_ts,  x.pd_pool_id,  y.option_id,  y.code,  y.value,  y.formatted_value,  y.space,  y.persistent,  y.dhcp6_subnet_id,  y.scope_id,  y.user_context,  y.shared_network_name,  y.pool_id,  y.modification_ts,  y.pd_pool_id,  o.option_id,  o.code,  o.value,  o.formatted_value,  o.space,  o.persistent,  o.dhcp6_subnet_id,  o.scope_id,  o.user_context,  o.shared_network_name,  o.pool_id,  o.modification_ts,  o.pd_pool_id,   s.calculate_tee_times,  s.t1_percent,  s.t2_percent,  s.interface_id,  s.min_preferred_lifetime,  s.max_preferred_lifetime,  s.min_valid_lifetime,  s.max_valid_lifetime,  p.client_class,  p.require_client_classes,  p.user_context,  d.excluded_prefix,  d.excluded_prefix_length,  d.client_class,  d.require_client_classes,  d.user_context,  srv.tag FROM dhcp6_subnet AS s INNER JOIN dhcp6_subnet_server AS a   ON s.subnet_id = a.subnet_id INNER JOIN dhcp6_server AS srv   ON (a.server_id = srv.id) LEFT JOIN dhcp6_pool AS p ON s.subnet_id = p.subnet_id LEFT JOIN dhcp6_pd_pool AS d ON s.subnet_id = d.subnet_id LEFT JOIN dhcp6_options AS x ON x.scope_id = 5 AND p.id = x.pool_id LEFT JOIN dhcp6_options AS y ON y.scope_id = 6 AND d.id = y.pd_pool_id LEFT JOIN dhcp6_options AS o ON o.scope_id = 1 AND s.subnet_id = o.dhcp6_subnet_id WHERE s.modification_ts > ? ORDER BY s.subnet_id, p.id, d.id, x.option_id, y.option_id, o.option_id>
2019-12-19 09:37:05.934 ERROR [kea-dhcp6.dhcp6/4219] DHCP6_INIT_FAIL failed to initialize Kea server: configuration error using file '/usr/local/etc/kea/kea-dhcp6.conf.my': during update from config backend database: Extra data in <string>:1:2. Statement is <SELECT  s.subnet_id,  s.subnet_prefix,  s.client_class,  s.interface,  s.modification_ts,  s.preferred_lifetime,  s.rapid_commit,  s.rebind_timer,  s.relay,  s.renew_timer,  s.require_client_classes,  s.reservation_mode,  s.shared_network_name,  s.user_context,  s.valid_lifetime,  p.id,  p.start_address,  p.end_address,  p.subnet_id,  p.modification_ts,  d.id,  d.prefix,  d.prefix_length,  d.delegated_prefix_length,  d.subnet_id,  d.modification_ts,  x.option_id,  x.code,  x.value,  x.formatted_value,  x.space,  x.persistent,  x.dhcp6_subnet_id,  x.scope_id,  x.user_context,  x.shared_network_name,  x.pool_id,  x.modification_ts,  x.pd_pool_id,  y.option_id,  y.code,  y.value,  y.formatted_value,  y.space,  y.persistent,  y.dhcp6_subnet_id,  y.scope_id,  y.user_context,  y.shared_network_name,  y.pool_id,  y.modification_ts,  y.pd_pool_id,  o.option_id,  o.code,  o.value,  o.formatted_value,  o.space,  o.persistent,  o.dhcp6_subnet_id,  o.scope_id,  o.user_context,  o.shared_network_name,  o.pool_id,  o.modification_ts,  o.pd_pool_id,   s.calculate_tee_times,  s.t1_percent,  s.t2_percent,  s.interface_id,  s.min_preferred_lifetime,  s.max_preferred_lifetime,  s.min_valid_lifetime,  s.max_valid_lifetime,  p.client_class,  p.require_client_classes,  p.user_context,  d.excluded_prefix,  d.excluded_prefix_length,  d.client_class,  d.require_client_classes,  d.user_context,  srv.tag FROM dhcp6_subnet AS s INNER JOIN dhcp6_subnet_server AS a   ON s.subnet_id = a.subnet_id INNER JOIN dhcp6_server AS srv   ON (a.server_id = srv.id) LEFT JOIN dhcp6_pool AS p ON s.subnet_id = p.subnet_id LEFT JOIN dhcp6_pd_pool AS d ON s.subnet_id = d.subnet_id LEFT JOIN dhcp6_options AS x ON x.scope_id = 5 AND p.id = x.pool_id LEFT JOIN dhcp6_options AS y ON y.scope_id = 6 AND d.id = y.pd_pool_id LEFT JOIN dhcp6_options AS o ON o.scope_id = 1 AND s.subnet_id = o.dhcp6_subnet_id WHERE s.modification_ts > ? ORDER BY s.subnet_id, p.id, d.id, x.option_id, y.option_id, o.option_id>
2019-12-19 09:37:05.935 INFO  [kea-dhcp6.mysql-cb-hooks/4219] MYSQL_CB_DEINIT_OK unloading MYSQL CB hooks library successful
2019-12-19 09:37:05.935 INFO  [kea-dhcp6.hooks/4219] HOOKS_LIBRARY_UNLOADED hooks library /usr/local/lib/kea/hooks/libdhcp_mysql_cb.so successfully unloaded

query results

subnet_id subnet_prefix client_class interface modification_ts preferred_lifetime rapid_commit rebind_timer relay renew_timer require_client_classes reservation_mode shared_network_name user_context valid_lifetime id start_address end_address subnet_id modification_ts id prefix prefix_length delegated_prefix_length subnet_id modification_ts option_id code value formatted_value space persistent dhcp6_subnet_id scope_id user_context shared_network_name pool_id modification_ts pd_pool_id option_id code value formatted_value space persistent dhcp6_subnet_id scope_id user_context shared_network_name pool_id modification_ts pd_pool_id option_id code value formatted_value space persistent dhcp6_subnet_id scope_id user_context shared_network_name pool_id modification_ts pd_pool_id calculate_tee_times t1_percent t2_percent interface_id min_preferred_lifetime max_preferred_lifetime min_valid_lifetime max_valid_lifetime client_class require_client_classes user_context excluded_prefix excluded_prefix_length client_class require_client_classes user_context tag
3 2a0a:eac1:3::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:3::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 261 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 3 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
3 2a0a:eac1:3::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:3::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 262 24 NULL cosmostv.by dhcp6 0 3 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
7 2a0a:eac1:7::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:7::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 257 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 7 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
7 2a0a:eac1:7::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:7::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 258 24 NULL cosmostv.by dhcp6 0 7 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
8 2a0a:eac1:8::/48 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:8::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 253 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 8 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
8 2a0a:eac1:8::/48 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:8::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 254 24 NULL cosmostv.by dhcp6 0 8 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
9 2a0a:eac1:9::/64 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:9::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 247 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 9 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
9 2a0a:eac1:9::/64 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:9::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 248 24 NULL cosmostv.by dhcp6 0 9 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
21 2a0a:eac1:15::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:15::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 259 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 21 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
21 2a0a:eac1:15::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:15::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 260 24 NULL cosmostv.by dhcp6 0 21 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
24 2a0a:eac1:18::/48 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:18::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 249 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 24 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
24 2a0a:eac1:18::/48 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:18::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 250 24 NULL cosmostv.by dhcp6 0 24 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
57 2a0a:eac1:39:5600::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:39:5600::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 255 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 57 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
57 2a0a:eac1:39:5600::/64 NULL ens19 2019-12-19 10:01:56 NULL NULL NULL 2a0a:eac1:39:5600::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 256 24 NULL cosmostv.by dhcp6 0 57 1 NULL NULL NULL 2019-12-19 10:01:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
2457 2a0a:eac1:999::/64 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:999::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 251 23 NULL 2a0a:eac0::45, 2a0a:eac0::6 dhcp6 0 2457 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all
2457 2a0a:eac1:999::/64 NULL ens19 2019-12-19 10:01:55 NULL NULL NULL 2a0a:eac1:999::1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 252 24 NULL cosmostv.by dhcp6 0 2457 1 NULL NULL NULL 2019-12-19 10:01:55 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL all

When I remove the relay from the subnet table - the error disappears. Tell me what could be the problem?

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking