# Pxc-operator - 1.10.0, pxc-db - 1.10.0

**URL:** <https://forums.percona.com/t/pxc-operator-1-10-0-pxc-db-1-10-0/17052>\
**Category:** Percona Operator for MySQL\
**Tags:** percona\
**Created:** [August 16, 2022, 1:39pm UTC](https://forums.percona.com/t/pxc-operator-1-10-0-pxc-db-1-10-0/17052 "2022-08-16T13:39:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![schugaj](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/schugaj/32/7242_2.png) [@schugaj](https://forums.percona.com/u/schugaj)\
**Post date:** [August 16, 2022, 1:39pm UTC](https://forums.percona.com/t/pxc-operator-1-10-0-pxc-db-1-10-0/17052/1 "2022-08-16T13:39:07Z")

</div>

I have some issue.

pxc-operator - 1.10.0, pxc-db - 1.10.0

The operator log sometimes has this errors.

reconcile replication error",“err”:"get primary pxc pod: not found

“exec syncusers: command terminated with exit code 1 / / ERROR (line:1799) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:1893) : Could not find a primary cluster node\n”,“errorVerbose”:"exec syncusers: command terminated with exit code 1 / / ERROR (line:1799) : Could not find any nodes belonging to the cluster with writer hostgroup:11

`ERROR 2013 (HY000): Lost connection to MySQL server at 'waiting for initial communication packet', system error: 110\nERROR (line:1933) : Failed to load the user list from PXC. \n-- Please check the PXC connection parameters and status.`

settings proxysql  
admin\_variables =  
{  
admin\_credentials=“”  
mysql\_ifaces=“0.0.0.0:6032”  
refresh\_interval=2000

cluster\_username=“proxyadmin”  
cluster\_password=“”  
checksum\_admin\_variables=false  
checksum\_ldap\_variables=false  
checksum\_mysql\_variables=false  
cluster\_check\_interval\_ms=200  
cluster\_check\_status\_frequency=100  
cluster\_mysql\_query\_rules\_save\_to\_disk=true  
cluster\_mysql\_servers\_save\_to\_disk=true  
cluster\_mysql\_users\_save\_to\_disk=true  
cluster\_proxysql\_servers\_save\_to\_disk=true  
cluster\_mysql\_query\_rules\_diffs\_before\_sync=1  
cluster\_mysql\_servers\_diffs\_before\_sync=1  
cluster\_mysql\_users\_diffs\_before\_sync=1  
cluster\_proxysql\_servers\_diffs\_before\_sync=1  
}

mysql\_variables=  
{  
monitor\_password=“”  
monitor\_galera\_healthcheck\_interval=1000  
threads=4  
max\_connections=2048  
default\_query\_delay=0  
default\_query\_timeout=120000  
poll\_timeout=2000  
interfaces=“0.0.0.0:3306;0.0.0.0:33062”  
default\_schema=“information\_schema”  
stacksize=1048576  
connect\_timeout\_server=120000  
monitor\_history=60000  
monitor\_connect\_interval=20000  
monitor\_ping\_interval=10000  
ping\_timeout\_server=200  
commands\_stats=true  
sessions\_sort=true  
have\_ssl=true  
ssl\_p2s\_ca=“/etc/proxysql/ssl-internal/ca.crt”  
ssl\_p2s\_cert=“/etc/proxysql/ssl-internal/tls.crt”  
ssl\_p2s\_key=“/etc/proxysql/ssl-internal/tls.key”  
ssl\_p2s\_cipher=“ECDHE-RSA-AES128-GCM-SHA256”  
}

mysql\_galera\_hostgroups =  
(  
{  
writer\_hostgroup=666  
backup\_writer\_hostgroup=600  
reader\_hostgroup=777  
offline\_hostgroup=700  
max\_writers=0  
writer\_is\_also\_reader=1  
max\_transactions\_behind=100  
active=1  
},  
{  
writer\_hostgroup=110  
backup\_writer\_hostgroup=120  
reader\_hostgroup=100  
offline\_hostgroup=130  
max\_writers=1  
writer\_is\_also\_reader=1  
max\_transactions\_behind=100  
active=1  
},  
{  
writer\_hostgroup=111  
backup\_writer\_hostgroup=121  
reader\_hostgroup=101  
offline\_hostgroup=131  
max\_writers=1  
writer\_is\_also\_reader=1  
max\_transactions\_behind=100  
active=1  
}  
)

mysql\_servers =  
(  
{ address=“prod-pxc-2.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=111, max\_connections=4096, weight=1, use\_ssl=1 },  
{ address=“prod-pxc-1.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=111, max\_connections=4096, weight=100, use\_ssl=1 },  
{ address=“prod-pxc-0.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=777, max\_connections=4096, weight=100, use\_ssl=1 },  
{ address=“prod-pxc-1.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=777, max\_connections=4096, weight=0, use\_ssl=1 },  
{ address=“prod-pxc-2.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=777, max\_connections=4096, weight=100, use\_ssl=1 },  
{ address=“prod-pxc-0.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=110, max\_connections=4096, weight=10, use\_ssl=1 },  
{ address=“prod-pxc-1.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=110, max\_connections=4096, weight=100, use\_ssl=1 },  
{ address=“prod-pxc-2.prod-pxc.pxc-tubes-prod.svc.cluster.local”, port=3306 , hostgroup=110, max\_connections=4096, weight=10, use\_ssl=1 }  
)

mysql\_query\_rules =  
(  
{  
rule\_id=48  
active=1  
username=“aemediauser”  
match\_digest=“^SELECT.\* FOR UPDATE”  
destination\_hostgroup=111  
apply=1  
},  
{  
rule\_id=49  
active=1  
username=“aemediauser”  
match\_digest=“^SELECT”  
destination\_hostgroup=111  
apply=1  
},  
{  
rule\_id=50  
active=1  
username=“tube\_main”  
match\_digest=“^SELECT.\* FOR UPDATE”  
destination\_hostgroup=111  
apply=1  
},  
{  
rule\_id=51  
active=1  
username=“tube\_main”  
match\_digest=“^SELECT”  
destination\_hostgroup=111  
apply=1  
},  
{  
rule\_id=52  
active=1  
username=“tube”  
match\_digest=“^SELECT.\* FOR UPDATE”  
destination\_hostgroup=110  
apply=1  
},  
{  
rule\_id=53  
active=1  
username=“tube”  
match\_digest=“^SELECT”  
destination\_hostgroup=777  
apply=1  
},  
{  
rule\_id=54  
active=1  
username=“sphinxuser”  
match\_digest=“^SELECT.\* FOR UPDATE”  
destination\_hostgroup=110  
apply=1  
},  
{  
rule\_id=55  
active=1  
username=“sphinxuser”  
match\_digest=“^SELECT”  
destination\_hostgroup=777  
apply=1  
}  
)

mysql\_users =  
(  
{ username = “tube”, password = “”, default\_hostgroup = 110, transaction\_persistent = 0, active = 1 },  
{ username = “tube\_main”, password = “”, default\_hostgroup = 111, transaction\_persistent = 1, active = 1 },  
{ username = “aemediauser”, password = “”, default\_hostgroup = 111, transaction\_persistent = 1, active = 1 },  
{ username = “sphinxuser”, password = “”, default\_hostgroup = 110, transaction\_persistent = 0, active = 1 }  
)

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [August 22, 2022, 9:39am UTC](https://forums.percona.com/t/pxc-operator-1-10-0-pxc-db-1-10-0/17052/2 "2022-08-22T09:39:48Z")

</div>

Hello @schugaj ,

is there anything else specific about your workloads or installation that we should know about before trying to reproduce the issue?

Also, does this error impact database availability or service in any way?