Postgresql error when trying to create customer invoice
After a long time of inactivity, we took an order today. I created the customer as usual. When I clicked on "Customer Invoice" on the contact's page after a contact search, I got the "Internal Server Error" message. I seem to get these in my Postgesql log for the relevant times: 2019-12-13 04:59:17 GMT LOG: SSL error: decryption failed or bad record mac 2019-12-13 04:59:17 GMT LOG: could not receive data from client: Connection reset by peer 2019-12-13 04:59:17 GMT LOG: unexpected EOF on client connection with an open transaction 2019-12-13 05:31:44 GMT LOG: SSL error: decryption failed or bad record mac 2019-12-13 05:31:44 GMT LOG: could not receive data from client: Connection reset by peer 2019-12-13 05:31:44 GMT LOG: unexpected EOF on client connection with an open transaction and in the ledgersmb log no connection to the server: SELECT * FROM "public"."setting_get"(?) at /usr/local/share/perl/5.24.1/PGObject.pm line 360. Postgresql 9.6.15 Ledgersmb 1.6.10 using starman. Can someone help guide on my troubleshooting and resolution path? Thanks in advance, Louis
hi Louis, On Fri, Dec 13, 2019 at 6:41 AM Louis <lbmlist@hethcote.com> wrote:
After a long time of inactivity, we took an order today.
Congrats!
I created the customer as usual. When I clicked on "Customer Invoice" on the contact's page after a contact search, I got the "Internal Server Error" message.
Ok. That's unfortunate. Below, you list the logs for the database (which seems to indicate that the server is hanging up...). Do you also have more info from the starman logs? From the PostgreSQL logs and the bit from starman that you sent, I can't see enough, I'm afraid...
I seem to get these in my Postgesql log for the relevant times:
2019-12-13 04:59:17 GMT LOG: SSL error: decryption failed or bad record mac 2019-12-13 04:59:17 GMT LOG: could not receive data from client: Connection reset by peer 2019-12-13 04:59:17 GMT LOG: unexpected EOF on client connection with an open transaction
2019-12-13 05:31:44 GMT LOG: SSL error: decryption failed or bad record mac 2019-12-13 05:31:44 GMT LOG: could not receive data from client: Connection reset by peer 2019-12-13 05:31:44 GMT LOG: unexpected EOF on client connection with an open transaction
and in the ledgersmb log
no connection to the server: SELECT * FROM "public"."setting_get"(?) at /usr/local/share/perl/5.24.1/PGObject.pm line 360.
Postgresql 9.6.15 Ledgersmb 1.6.10 using starman.
Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
participants (2)
-
Erik Huelsmann -
Louis