Server errors/restarting service & IMAP refreshing

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
cwaltzer
New user
New user
Posts: 3
Joined: 2015-10-20 21:06

Server errors/restarting service & IMAP refreshing

Post by cwaltzer » 2015-10-22 16:34

I am currently having a TON of hMailserver issues and do not even know where to begin. Outlook clients need to close and open outlook to receive new messages and the worst part seems to be that when I am on the mail server and am watching for issues and/or looking around I get COM errors and then the service seems to re-start as I then have to log back in to the hMailserver Administrator. Any help would be GREATLY aprreciated. Please let me know as soon as possible what you need from me in the way of logs etc. Thank you in advance for your help!

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Server errors/restarting service & IMAP refreshing

Post by Bill48105 » 2015-10-22 20:19

Hi. you didn't state what version of hmail you are on. some have known issues & crashing under certain circumstances (heavy load especially or seemingly randomly). Knowing the exact errors from hmail logs would be helpful too
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

cwaltzer
New user
New user
Posts: 3
Joined: 2015-10-20 21:06

Re: Server errors/restarting service & IMAP refreshing

Post by cwaltzer » 2015-10-22 20:21

Sorry - Version 5.5.2-b2129.

Bill48105
Developer
Developer
Posts: 6192
Joined: 2010-04-24 23:16
Location: Michigan, USA

Re: Server errors/restarting service & IMAP refreshing

Post by Bill48105 » 2015-10-22 20:33

ok great thanks if someone reads & has idea they can respond in meantime will see how far we can get to resolving your issues in IRC
hMailServer build LIVE on my servers: 5.4-B2014050402
#hmailserver on FreeNode IRC https://webchat.freenode.net/?channels=#hmailserver
*** ABSENT FROM hMail! Those in IRC know how to find me if urgent. ***

cwaltzer
New user
New user
Posts: 3
Joined: 2015-10-20 21:06

Re: Server errors/restarting service & IMAP refreshing

Post by cwaltzer » 2015-10-22 20:44

Bill48105 wrote:Hi. you didn't state what version of hmail you are on. some have known issues & crashing under certain circumstances (heavy load especially or seemingly randomly). Knowing the exact errors from hmail logs would be helpful too

Errors:

"ERROR" 2304 "2015-10-22 06:18:09.402" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x99\x8F P...' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (43, 333, 1039080, '2014-11-14 23:39:28', '"USERNAME REMOVED" <EMAIL ADDRESS REMOVED>', 'FW: "ERROR" 2708 "2015-10-22 06:42:07.443" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."
"ERROR" 2708 "2015-10-22 06:42:07.443" "Severity: 1 (Critical), Code: HM5062, Source: IMAPFetch::ReportCriticalError_, Description: ERROR HM10001 - IMAP FETCH: Error when loading MIME message. - C:\Program Files (x86)\hMailServer\Data\DOMAINREMOVED\USER REMOVED\CE\{CE35B637-79F9-4982-B9AD-0E30DBB2AE41}.eml"
"ERROR" 2708 "2015-10-22 06:42:07.459" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."

User avatar
jimimaseye
Moderator
Moderator
Posts: 8132
Joined: 2011-09-08 17:48

Re: Server errors/restarting service & IMAP refreshing

Post by jimimaseye » 2015-10-22 21:32

I think the problem is this
cwaltzer wrote: MySQL: Incorrect string value: '\xF0\x9F\x99\x8F P...' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata

For explanation and resolve, see here: viewtopic.php?f=9&t=27884

I think there was a fix in 5.6 (but dont quote me)
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
SorenR
Senior user
Senior user
Posts: 3192
Joined: 2006-08-21 15:38
Location: Denmark

Re: Server errors/restarting service & IMAP refreshing

Post by SorenR » 2015-10-22 21:45

jimimaseye wrote:I think the problem is this
cwaltzer wrote: MySQL: Incorrect string value: '\xF0\x9F\x99\x8F P...' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata

For explanation and resolve, see here: viewtopic.php?f=9&t=27884

I think there was a fix in 5.6 (but dont quote me)
Nah... Script no good... :oops:

Look here for a more permanent fix... hMailServer 5.5.2 contain half the fix (fixed in Version 5.5 - Build 2074), the other half is the proper config and version of MySQL.

viewtopic.php?f=7&t=26860&p=166080&hili ... b4#p166080
SørenR.

“With age comes wisdom, but sometimes age comes alone.”
- Oscar Wilde

Post Reply