Issue with database and ubn_options on xstore theme

I am still continuing to have so many endless problems with this theme. Please see below an issues discovered from my hosting provide:

The issue you experience is caused by the database and more specifically the ubn_options table.

When the product page is accessed, the following error is logged in the php_errorlog:

[15-Oct-2024 12:14:24 UTC] WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for query UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”aa1e29803c1bf678a044697de8f96461\”:{\”price\”:{\”4767\”:\”36.10\”,\”4768\”:\”43.32\”,\”4769\”:\”45.15\”,\”4770\”:\”54.18\”,\”4771\”:\”22.55\”,\”4772\”:\”27.06\”,\”4773\”:\”27.10\”,\”4774\”:\”32.52\”,\”4775\”:\”36.10\”,\”4776\”:\”43.32\”,\”4777\”:\”45.15\”,\”4778\”:\”54.18\”,\”4779\”:\”22.55\”,\”4780\”:\”27.06\”,\”4781\”:\”27.10\”,\”4782\”:\”32.52\”,\”4783\”:\”36.10\”,\”4784\”:\”43.32\”,\”4785\”:\”45.15\”,\”4786\”:\”54.18\”,\”4787\”:\”22.55\”,\”4788\”:\”27.06\”,\”4789\”:\”27.10\”,\”4790\”:\”32.52\”,\”4791\”:\”36.10\”,\”4792\”:\”43.32\”,\”4793\”:\”45.15\”,\”4794\”:\”54.18\”,\”4795\”:\”22.55\”,\”4796\”:\”27.06\”,\”4797\”:\”27.10\”,\”4798\”:\”32.52\”,\”4799\”:\”36.10\”,\”4800\”:\”43.32\”,\”4801\”:\”45.15\”,\”4802\”:\”54.18\”,\”4717\”:\”27.10\”,\”4718\”:\”32.52\”,\”4719\”:\”36.10\”,\”4720\”:\”43.32\”,\”4721\”:\”45.15\”,\”4722\”:\”54.18\”,\”4723\”:\”22.55\”,\”4724\”:\”27.06\”,\”4725\”:\”27.10\”,\”4726\”:\”32.52\”,\”4727\”:\”36.10\”,\”4728\”:\”43.32\”,\”4729\”:\”45.15\”,\”4730\”:\”54.18\”,\”4731\”:\”22.55\”,\”4732\”:\”27.06\”,\”4733\”:\”27.10\”,\”4734\”:\”32.52\”,\”4735\”:\”36.10\”,\”4736\”:\”43.32\”,\”4737\”:\”45.15\”,\”4738\”:\”54.18\”,\”4739\”:\”22.55\”,\”4740\”:\”27.06\”,\”4741\”:\”27.10\”,\”4742\”:\”32.52\”,\”4743\”:\”36.10\”,\”4744\

We increased the max_allowed_packet up to 1GB, which is the maximum allowed based on the available resources, however, the issue persists.

I also tried exporting the database and creating a backup so that it can be optimized, but I stumbled upon a different issue:

baseos | hoghtontimber.co.uk | u8-j96senbslpfz@c1103406.sgvps.net:~/www/hoghtontimber.co.uk/public_html$ wp db dump
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table ubn_options at row: 1288

So when you try exporting the database with wp-cli, the process fails quite fast – for about 2 seconds. Usually when this error occurs, MySQL service crashes and restarts itself. However, in this situation, there is no error recorded in the log and MySQL is still up and running.

That makes us believe the DB itself and more precisely the ubn_options table has too many lines or there is something corrupted in it. We checked if there is a memory outage during the process and there is not.

I’ve tried optimising the database but this did not resolve the issue and similar queries are constantly being executed:

Id | User | Host | db | Command | Time | State | Info | Time_ms | Rows_sent | Rows_examined |
+—-+—————+—————–+—————-+———+——+———-+——————————————————————————————————+———+———–+—————+
| 7 | ucfwufp6utfgk | localhost:27714 | db7kxm9ea2tyoo | Query | 1 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”0f948de3ec0465d7c6f4d4b6113 | 1191 | 0 | 1 |
| 8 | ucfwufp6utfgk | localhost:27718 | db7kxm9ea2tyoo | Query | 1 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”331963771976089c5a03afc2d55 | 1223 | 0 | 1 |
| 9 | ucfwufp6utfgk | localhost:27726 | db7kxm9ea2tyoo | Query | 2 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”89cb63126c5e4037061857b9240 | 1707 | 0 | 1 |
| 11 | ucfwufp6utfgk | localhost:27756 | db7kxm9ea2tyoo | Sleep | 1 | | | 286 | 1 | 1 |
| 12 | ucfwufp6utfgk | localhost:27772 | db7kxm9ea2tyoo | Sleep | 1 | | | 286 | 1 | 1 |
| 13 | ucfwufp6utfgk | localhost:27798 | db7kxm9ea2tyoo | Query | 1 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”7f3d8de4209432e2858323dd449 | 974 | 0 | 1 |
| 15 | ucfwufp6utfgk | localhost:27818 | db7kxm9ea2tyoo | Sleep | 1 | | | 286 | 1 | 1 |
| 17 | ucfwufp6utfgk | localhost:27842 | db7kxm9ea2tyoo | Query | 1 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”2f61e9c051cd37b86816378b4c2 | 1046 | 0 | 1 |
| 24 | ucfwufp6utfgk | localhost:44766 | db7kxm9ea2tyoo | Sleep | 1 | | | 286 | 1 | 1 |
| 76 | ucfwufp6utfgk | localhost:62268 | db7kxm9ea2tyoo | Query | 2 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”2283488235035cf9f7803dd6d6b | 1975 | 0 | 1 |
| 78 | ucfwufp6utfgk | localhost:46648 | db7kxm9ea2tyoo | Sleep | 9 | | | 8629 | 1 | 5 |
| 80 | ucfwufp6utfgk | localhost:46792 | db7kxm9ea2tyoo | Query | 2 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”b554635bbfb0e2050b5e71d8e9a | 1740 | 0 | 1 |
| 86 | ucfwufp6utfgk | localhost:40936 | db7kxm9ea2tyoo | Query | 4 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”df61b7da44057ec10df9e0f7e35 | 3628 | 0 | 1 |
| 87 | ucfwufp6utfgk | localhost:57952 | db7kxm9ea2tyoo | Query | 0 | updating | UPDATE ubn_options SET option_value = ‘{\”version\”:\”1719415142\”,\”ee6fe062b866ef5855a1d75ec77 | 176 | 0 | 1 |
+—-+—————+—————–+—————-+———+——+———-+——————————————-

You should contact your developer for further assistance and investigation of that issue and if there are any MySQL settings you would like to be changed, we can try applying them.

Can you please shed light on how to fix this error. as it causing pages not to load and losing the site owner customer by the day.