<div dir="ltr">I am following the clusterlabs documentation that is for RedHat and making adjustments to Ubuntu.<br><div><br></div><div>node01= 10.10.10.100 (zabbix core)</div><div>node02= 10.10.10.200 (zabbix core)</div><div>VIP= 10.10.10.250</div><div>zabbixweb= 10.10.10.2</div><div>zabbixbd= 10.10.10.1</div><div><br></div><div>I am having problem in zabbix core connection (node01 and node02) with zabbixbd is coming duplicate data in the database server because the two core is sending the same information to the database.<br></div><div><br></div><div>As the cluster is active / active wanted a way to information originated by them also be unique and not each generate the same information and try to add to the database because it is generating me the errors below.<br></div><div><br></div><div><div><div style="font-size:12.8px">2016-10-08 12:40:19 BRT [23651-1] zabbix@zabbix ERROR: duplicate key value violates unique constraint "events_pkey"</div><div style="font-size:12.8px">2016-10-08 12:40:19 BRT [23651-2] zabbix@zabbix DETAIL: Key (eventid)=(83) already exists.</div><div style="font-size:12.8px"><br></div><div><span style="font-size:12.8px">And zabbix Server that runs on the node (01 and 02) is giving me these errors below.</span><br></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px"><div style="font-size:12.8px">root@node02:~# tail -f /var/log/zabbix/zabbix_server.<wbr>log </div><div style="font-size:12.8px">]</div><div style="font-size:12.8px"> 1276:20161008:123901.007 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "events_pkey"</div><div style="font-size:12.8px">DETAIL: Key (eventid)=(80) already exists.</div><div style="font-size:12.8px"> [insert into events (eventid,source,object,<wbr>objectid,clock,ns,value) values (80,0,0,13491,1475941141,<wbr>832194,1),(81,3,0,13491,<wbr>1475941141,832194,0),(82,3,0,<wbr>13574,1475941141,836284,0);</div><div style="font-size:12.8px">]</div><div style="font-size:12.8px"> 1267:20161008:124019.389 enabling Zabbix agent checks on host "Zabbix server": host became available</div><div style="font-size:12.8px"> 1285:20161008:124019.764 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "events_pkey"</div><span class="gmail-im" style="font-size:12.8px">DETAIL: Key (eventid)=(83) already exists.</span><div style="font-size:12.8px"> [insert into events (eventid,source,object,<wbr>objectid,clock,ns,value) values (83,0,0,13491,1475941219,<wbr>390629436,0);</div><div style="font-size:12.8px">]</div></div><div style="font-size:12.8px"><br></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-10-08 22:26 GMT-03:00 Digimer <span dir="ltr"><<a href="mailto:lists@alteeve.ca" target="_blank">lists@alteeve.ca</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Can you please share the requested information?<br>
<br>
digimer<br>
<span class=""><br>
On 08/10/16 07:51 PM, Dayvidson Bezerra wrote:<br>
> My project is to achieve a cluster zabbix active / active.<br>
><br>
> I'm having trouble declaring zabbix service in the cluster.<br>
><br>
> 2016-10-08 13:04 GMT-03:00 Digimer <<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a><br>
</span>> <mailto:<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a>>>:<br>
<span class="">><br>
> Can you share your current full configuration please?<br>
><br>
> If you're hitting errors, please also share the relevant log entries<br>
> from the nodes.<br>
><br>
> digimer<br>
><br>
> On 07/10/16 09:06 PM, Dayvidson Bezerra wrote:<br>
> > The company only uses Ubuntu, and do not want another distro in your<br>
> > environment.<br>
> ><br>
> > I'm scolding to solve this .. I've done active / passive cluster with<br>
> > DRBD but active / not active.<br>
> ><br>
> > What I have read is about the use of pacemaker + corosync and using GSF2.<br>
> ><br>
> > Someone who has already succeeded in making active / active in Linux Ubuntu?<br>
> ><br>
> ><br>
> > 2016-10-07 20:50 GMT-03:00 Digimer <<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a> <mailto:<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a>><br>
</span>> > <mailto:<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a> <mailto:<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a>>>>:<br>
<span class="">> ><br>
> > On 07/10/16 07:46 PM, Dayvidson Bezerra wrote:<br>
> > > Hello.<br>
> > > I am wanting to set up an active / active cluster in ubuntu 16.04 with<br>
> > > pacemaket and corosync and following the clusterlabs documentation I'm<br>
> > > not getting.<br>
> > > Someone has documentation that might help?<br>
> ><br>
> > Last I checked (and it's not been recently), ubuntu's support for HA is<br>
> > still lacking. It's recommended for people new to HA to use either RHEL<br>
> > (CentOS) or SUSE. Red Hat and SUSE both have paid staff who make sure<br>
> > that HA works well.<br>
> ><br>
> > If you want to use Ubuntu, after you get a working config in either EL<br>
> > or SUSE, then you can port. That way, if you run into issues, you will<br>
> > know your config is good and that you're dealing with an OS issue. Keeps<br>
> > the fewest variables in play at a time.<br>
> ><br>
> > Also, I don't know of any good docs for HA on ubuntu, for the same<br>
> > reason.<br>
> ><br>
> > --<br>
> > Digimer<br>
> > Papers and Projects: <a href="https://alteeve.ca/w/" rel="noreferrer" target="_blank">https://alteeve.ca/w/</a><br>
> > What if the cure for cancer is trapped in the mind of a person without<br>
> > access to education?<br>
> ><br>
> > ______________________________<wbr>_________________<br>
> > Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
</span>> <mailto:<a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>> <mailto:<a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
<span class="">> <mailto:<a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>><wbr>><br>
> > <a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
> <<a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a>><br>
> > <<a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
> <<a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a>>><br>
> ><br>
> > Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
> > Getting started:<br>
> > <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> <<a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a>><br>
> > <<a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> <<a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a>>><br>
> > Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > /*Dayvidson Bezerra*<br>
> > /<br>
> > //*/Pós-Graduado em Gerenciamento de Redes - FIR-PE/<br>
> > /Graduado em Redes de Computadores - FMN<br>
</span>> > /*/F: <a href="tel:%2B55%2081%209877-5127" value="+558198775127">+55 81 9877-5127</a> <tel:%2B55%2081%209877-5127>/<br>
<span class="im HOEnZb">> > /Skype: dayvidson.bezerra<br>
> > //Lattes: //<a href="http://lattes.cnpq.br/3299061783823913/" rel="noreferrer" target="_blank">http://lattes.cnpq.br/<wbr>3299061783823913/</a><br>
> <<a href="http://lattes.cnpq.br/3299061783823913/" rel="noreferrer" target="_blank">http://lattes.cnpq.br/<wbr>3299061783823913/</a>> /<br>
> > //Linked In:<br>
> /<a href="http://br.linkedin.com/pub/dayvidson-bezerra/2a/772/bb7/" rel="noreferrer" target="_blank">http://br.linkedin.com/pub/<wbr>dayvidson-bezerra/2a/772/bb7/</a><br>
> <<a href="http://br.linkedin.com/pub/dayvidson-bezerra/2a/772/bb7/" rel="noreferrer" target="_blank">http://br.linkedin.com/pub/<wbr>dayvidson-bezerra/2a/772/bb7/</a>><br>
> > /<br>
> ><br>
> ><br>
> > ______________________________<wbr>_________________<br>
> > Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
</span><div class="HOEnZb"><div class="h5">> <mailto:<a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>><br>
> > <a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
> <<a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a>><br>
> ><br>
> > Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
> > Getting started:<br>
> <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> <<a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a>><br>
> > Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
> ><br>
><br>
><br>
> --<br>
> Digimer<br>
> Papers and Projects: <a href="https://alteeve.ca/w/" rel="noreferrer" target="_blank">https://alteeve.ca/w/</a><br>
> What if the cure for cancer is trapped in the mind of a person without<br>
> access to education?<br>
><br>
> ______________________________<wbr>_________________<br>
> Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a> <mailto:<a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>><br>
> <a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
> <<a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a>><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started:<br>
> <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> <<a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a>><br>
> Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
><br>
><br>
><br>
><br>
> --<br>
> /*Dayvidson Bezerra*<br>
> /<br>
> //*/Pós-Graduado em Gerenciamento de Redes - FIR-PE/<br>
> /Graduado em Redes de Computadores - FMN<br>
> /*/F: <a href="tel:%2B55%2081%209877-5127" value="+558198775127">+55 81 9877-5127</a>/<br>
> /Skype: dayvidson.bezerra<br>
> //Lattes: //<a href="http://lattes.cnpq.br/3299061783823913/" rel="noreferrer" target="_blank">http://lattes.cnpq.br/<wbr>3299061783823913/</a> /<br>
> //Linked In: /<a href="http://br.linkedin.com/pub/dayvidson-bezerra/2a/772/bb7/" rel="noreferrer" target="_blank">http://br.linkedin.com/pub/<wbr>dayvidson-bezerra/2a/772/bb7/</a><br>
> /<br>
><br>
><br>
> ______________________________<wbr>_________________<br>
> Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
> <a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
> Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
><br>
<br>
<br>
--<br>
Digimer<br>
Papers and Projects: <a href="https://alteeve.ca/w/" rel="noreferrer" target="_blank">https://alteeve.ca/w/</a><br>
What if the cure for cancer is trapped in the mind of a person without<br>
access to education?<br>
<br>
______________________________<wbr>_________________<br>
Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
<a href="http://clusterlabs.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://clusterlabs.org/<wbr>mailman/listinfo/users</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" rel="noreferrer" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" rel="noreferrer" target="_blank">http://www.clusterlabs.org/<wbr>doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" rel="noreferrer" target="_blank">http://bugs.clusterlabs.org</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><font style="font-family:courier new,monospace"><i><b>Dayvidson Bezerra</b><br></i></font><div><font style="font-family:courier new,monospace"><i></i><b><i><span style="font-weight:normal">Pós-Graduado em Gerenciamento de Redes - FIR-PE</span></i><span style="font-weight:normal"><br></span><i><span style="font-weight:normal">Graduado em Redes de Computadores - FMN</span><br></i></b></font><font size="2"><i><font face="comic sans ms,sans-serif" size="1"><font face="courier new,monospace" size="2">F: +55 81 9877-5127</font></font></i></font></div><div><font size="2"><i><font face="comic sans ms,sans-serif" size="1"><font face="courier new,monospace" size="2">Skype: dayvidson.bezerra<br></font></font></i></font><font style="font-family:'courier new',monospace" size="2"><i>Lattes:<font color="#999999"> </font></i></font><font size="2"><i><font face="courier new, monospace" color="#999999"><a href="http://lattes.cnpq.br/3299061783823913" target="_blank">http://lattes.cnpq.br/3299061783823913</a></font></i></font> <font size="2"><i><br></i></font><font style="font-family:courier new,monospace" size="2"><i>Linked In: </i><a title="Visualizar perfil público" href="http://br.linkedin.com/pub/dayvidson-bezerra/2a/772/bb7" name="UNIQUE_ID_SafeHtmlFilter_UNIQUE_ID_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_SafeHtmlFilter_webProfileURL" target="_blank">http://br.linkedin.com/pub/dayvidson-bezerra/2a/772/bb7</a><i><br></i></font><br></div></div></div></div></div></div></div></div>
</div>