Hello Yan,
it looks that the pid ( the person ) doesn't exist on your setup.
So check in the person tab if you can find it (the person id appear just
before the error in the log).
Regards
Fabrice
Le 2017-11-16 ?? 05:21, Yan via PacketFence-users a ??crit?0?2:
> Hi dear users,
>
> We use PF V7.3 in our offices and currently there 200+ employees using
> PF as AAA server for 802.1x wireless connection. I guess we are not
> the largest client of PF. But when I check packetfence.log I found
> below errors keeps occurring. And most of the errors happened around
> 10:00 to 11:00 am. Our employees usually come to office during this time.?0?2
> I keep all system settings as default.?0?2So is this performance issue ?
> Are these errors caused by any inappropriate settings ? How could I
> optimize my settings to resolve this issue ?
>
> error log below:
> packetfence_httpd.aaa: httpd.aaa(32263) ERROR: [mac:xx:xx:xx:26:13:xx]
> Database query failed with non retryable error: Cannot add or update a
> child row: a foreign key constraint fails (`pf`.`node`, CONSTRAINT
> `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON DELETE
> CASCADE ON UPDATE CASCADE) (errno: 1452) [INSERT INTO `node` (
> `autoreg`, `bandwidth_balance`, `bypass_role_id`, `bypass_vlan`,
> `category_id`, `computername`, `detect_date`, `device_class`,
> `device_score`, `device_type`, `device_version`, `dhcp6_enterprise`,
> `dhcp6_fingerprint`, `dhcp_fingerprint`, `dhcp_vendor`, `last_arp`,
> `last_dhcp`, `last_seen`, `lastskip`, `mac`, `machine_account`,
> `notes`, `pid`, `regdate`, `sessionid`, `status`, `time_balance`,
> `unregdate`, `user_agent`, `voip`) VALUES ( ?, ?, ?, ?, ?, ?, NOW(),
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ? ) ON DUPLICATE KEY UPDATE `autoreg` = ?, `last_seen` = NOW(),
> `notes` = ?, `pid` = ?, `status` = ?] (pf::dal::db_execute)
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
fdur...@inverse.ca :: +1.514.447.4918 (x135) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
