Database error in

Query:

INSERT INTO `sys_profiles_match`(`profile_id`, `sort`, `profiles_match`) VALUES(18023, 'none', 'a:90:{i:0;s:5:"11096";i:1;s:5:"13428";i:2;s:4:"1941";i:3;s:5:"16647";i:4;s:4:"1953";i:5;s:5:"16519";i:6;s:4:"2387";i:7;s:5:"17204";i:8;s:4:"2464";i:9;s:4:"2629";i:10;s:5:"16357";i:11;s:4:"2805";i:12;s:4:"3005";i:13;s:4:"3104";i:14;s:4:"3470";i:15;s:5:"12466";i:16;s:4:"3606";i:17;s:4:"4148";i:18;s:4:"4608";i:19;s:4:"5206";i:20;s:4:"5920";i:21;s:4:"5930";i:22;s:4:"5973";i:23;s:4:"6096";i:24;s:4:"6292";i:25;s:4:"6718";i:26;s:4:"6792";i:27;s:4:"7306";i:28;s:4:"7317";i:29;s:4:"7443";i:30;s:4:"8121";i:31;s:4:"8559";i:32;s:4:"8561";i:33;s:4:"8586&
 quot;;i:34;s:4:"8678";i:35;s:4:"8729";i:36;s:4:"8793";i:37;s:4:"8945";i:38;s:4:"8985";i:39;s:4:"9345";i:40;s:4:"9571";i:41;s:4:"9973";i:42;s:5:"15071";i:43;s:5:"10592";i:44;s:5:"10066";i:45;s:5:"10849";i:46;s:5:"11677";i:47;s:5:"11827";i:48;s:5:"12144";i:49;s:5:"12681";i:50;s:5:"13097";i:51;s:5:"13173";i:52;s:5:"13246";i:53;s:5:"13600";i:54;s:5:"13896";i:55;s:5:"13923";i:56;s:5:"14098";i:57;s:5:"14403";i:58;s:5:"14448";i:59;s:5:"14477";i:60;s:5:"14550";i:61;s:5:"15024";i:62;s:5:"14752";i:63;s:5:"14868";i:64;s:5:"15077";i:65;s:5:"15150";i:66;s:5:"15299";i:67;s:5:"15354";i:68;s:5:"15745";i:69;s:5:"15818";i:70;s:5:"1592
 8";i:71;s:5:"15960";i:72;s:5:"16034";i:73;s:5:"16895";i:74;s:5:"16792";i:75;s:5:"16795";i:76;s:5:"16927";i:77;s:5:"17037";i:78;s:5:"17162";i:79;s:5:"17176";i:80;s:5:"17812";i:81;s:5:"17951";i:82;s:5:"19059";i:83;s:5:"19274";i:84;s:5:"19721";i:85;s:5:"19829";i:86;s:5:"20265";i:87;s:5:"20407";i:88;s:5:"20704";i:89;s:5:"21149";}')

Mysql error: Duplicate entry '18023-none' for key 'profile_id'

I get 1-2 of these errors daily... is there something I can do to mitigate these? how are they occurring? A new user clicking the confirm button a couple times quickly?

Thanks

have you been able to be this rectified? i would like to look at this, and see why the entity_id which should be auto-generated, and incrementally advanced, but then again, not sure what is firing these matches, are they automated, are you using fake profiles, there are many questions that could arise from this, but there is something going on that is non-dolphin

no this is still ongoing.

I'm not using any fake profiles and the only thing automated is the periodic cron job...

Would the complete backtrace mean anything or help at all?

one form today...

Query:

INSERT INTO `sys_profiles_match`(`profile_id`, `sort`, `profiles_match`) VALUES(11991, 'none', 'a:0:{}')

Mysql error: Duplicate entry '11991-none' for key 'profile_id'

Found error in the file '/var/www/domain/inc/match.inc.php' at line 106.
Called 'query' function with erroneous argument #0.

Here's a new one...

Query:

INSERT INTO  `sys_albums` SET `sys_albums`.`Caption` = 'Giovanni30331\'s photos', `sys_albums`.`Uri` = 'Giovanni30331-s-photos', `sys_albums`.`Location` = 'Undefined', `sys_albums`.`AllowAlbumView` = '3', `sys_albums`.`Type` = 'bx_photos', `sys_albums`.`Owner` = '22501', `sys_albums`.`Status` = 'active', `sys_albums`.`Date` = '1343113576', `sys_albums`.`LastObjId` = '0' 

Mysql error: Duplicate entry 'Giovanni30331-s-photos-bx_photos-22501' for key 'Uri'

Found error in the file '/var/www/domain/inc/classes/BxDolAlbums.php' at line 85.
Called 'res' function with erroneous argument #0.

there seems to be something going on with that stupid matching module, which has never worked, but that is just one of many things that dont work on dolphin. 

Duplicate entry for profile ID of 11991, the script is trying to insert sys_profiles_match, it says there is already an entry for Profile ID 11991, so if you are not running a profiles module there is something wrong with your site, or do you have ^10,000 members on your site? 

this has nothing to do with a user i do not believe, this is the match script trying to run, but the entries are already in the database so it kicks it out on Profile ID as that is set as the primary key. turn off the match making  and see if that stops the emails, but honestly one or two of those a day, can be expected on a site with more than ten thousand members. 

yeah I'm nearing 20k members.

I've noticed that sometimes the periodic cron job runs over a minute so maybe it's cause there is 2 running at the same time, it overlaps a task that didn't complete yet?

Is it save to change the periodic cron to every 5 mins perhaps?

Yes. you can change it to whatever amount you want. Just keep in mind that the longer the interval between cron runs, the longer one will have to wait for a video they uploaded to be processed.

But if it is taking over a minute to run, you may want to think about a more powerful server. Or more memory. MySql uses memory for most of it's work. Peridioc runs should not take anywhere near that long.

well, that is exactly what I did yesterday. ;) which is why I bought your site maintenance module ;)

I don't believe I've had a DB issue yet. So This could very well have just been a case of over utilization.