Article ID: 117364, created on Sep 19, 2013, last review on Apr 16, 2017

  • Applies to:
  • Odin Business Automation Standard

Symptoms

1.Store is loading slow. Hosting Plans are not visible in the store.

2.Store us unavailable, the following error appears:

"Our store is temporarily closed.

We apologize for the inconvenience."

Cause

/var/log/hspc/hspc.log:
--->8---
[2013/09/18 02:30:30] [FATAL] [7790] [HSPC::Exc::Mysql::new] DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/HSPC/WebDB.pm line 238.
---8<---

Resolution

Edit /etc/my.cnf (check if the db is remote in /etc/hspc/hspc.conf)

--->8---
[mysqld]
...
max_allowed_packet = 32M (value may be different, 32 should be enough)
---8<---

Restart MySQL.

Search Words

max_allowed_packet

We apologize for the inconvenience

[pid 10399] send(31, "POST /hspc/xml-api HTTP/1.0\r\nHost: hsp.doemee.be\r\nUser-Agent: NuSOAP/0.7.2 (1.11)\r\nContent-Type: text/xml; charset=UTF-8\r\nSOAPAction: \"\"\r\nContent-Length: 623\r\nExpect: \r\n\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\"><SOAP-ENV:Body><ns7974:session_open xmlns:ns7974=\"HSPC/API/1.0\"><__numeric_0><email xsi:type=\"xsd:string\">hspcstore@doemee.be</email><password xsi:type=\"xsd:string\">Woul2Eib</password><lang_id xsi:nil=\"true\"/></__numeric_0></ns7974:session_open></SOAP-ENV:Body></SOAP-ENV:Envelope>", 794, 0) = 794 [pid 10399] poll([{fd=31, events=POLLIN|POLLPRI|POLLERR|POLLHUP}], 1, 0) = 0 [pid 10399] poll([{fd=31, events=POLLIN|POLLERR|PO

store is unavailable

Got a packet bigger than

Our store is temporarily closed.

After Moving MySQL Database shop is not displayed correctly

Our store is temporarily closed. We apologize for the inconvenience.

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF