hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

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
made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-11 13:35

Hi, my errorlog attached...
you have any input for me?

2 imap Folders can't be deletetd or synchronised
not in Outlook, not in hms-admin-console
MY ideas hav' gone out :(

Greetings

"ERROR" 3764 "2014-07-31 01:02:03.410" "Severity: 2 (High), Code: HM4207, Source: MySQLRecordset::GetInt64Value, Description: An unknown error occurred while reading value from recordset: messageid"
"ERROR" 3764 "2014-07-31 01:02:03.442" "Severity: 3 (Medium), Code: HM5136, Source: TCPConnection::HandleRead, Description: An error occured while parsing data. Data length: 38, Data: jgbo DELETE "INBOX.12_folder1". Remote IP: xxx.xxx.xxx.xxx"
"ERROR" 2160 "2014-07-31 05:16:50.802" "Severity: 2 (High), Code: HM4207, Source: MySQLRecordset::GetInt64Value, Description: An unknown error occurred while reading value from recordset: messageid"
"ERROR" 2160 "2014-07-31 05:16:50.802" "Severity: 3 (Medium), Code: HM5136, Source: TCPConnection::HandleRead, Description: An error occured while parsing data. Data length: 47, Data: vzlx STATUS "INBOX.11_folder2" (UNSEEN). Remote IP: xxx.xxx.xxx.xxx"
"ERROR" 4032 "2014-07-31 09:02:05.020" "Severity: 2 (High), Code: HM4207, Source: MySQLRecordset::GetInt64Value, Description: An unknown error occurred while reading value from recordset: messageid"
"ERROR" 4032 "2014-07-31 09:02:05.020" "Severity: 3 (Medium), Code: HM5136, Source: TCPConnection::HandleRead, Description: An error occured while parsing data. Data length: 38, Data: i06h DELETE "INBOX.12_folder1". Remote IP: xxx.xxx.xxx.xxx"

User avatar
mattg
Moderator
Moderator
Posts: 20294
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by mattg » 2014-08-11 15:51

Is each IMAP folder set as a sub folder of each other??

Check the database...
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by ^DooM^ » 2014-08-11 16:31

Also while you are in there run a repair on the DB

https://www.hmailserver.com/documentati ... pair_mysql
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-11 16:35

oh, i don't explained Location...

These folders located in "deleted items" and both are subfolders from deleted items...
i can rename and they are still in the "imap Folder query"... but i can't delete them...

everythime outlook want to synchro the Folders it began to hang ...(i've unchecked temporary synchro on deleted items)

how to check database? no expirience with mysql :/

greetings

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by ^DooM^ » 2014-08-11 16:37

Read the docs i linked above, shows how to access DB
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

percepts
Senior user
Senior user
Posts: 5282
Joined: 2009-10-20 16:33
Location: Sceptred Isle

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by percepts » 2014-08-11 18:10

go into hmail admin and go to the account these folders are in. Then in the advanced tab you can edit folders and either delete the ones you want by right clicking on folder in left column or emptying the folder.

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by ^DooM^ » 2014-08-12 00:14

percepts wrote:go into hmail admin and go to the account these folders are in. Then in the advanced tab you can edit folders and either delete the ones you want by right clicking on folder in left column or emptying the folder.
He tried, that, it didn't work :/
made_my_day wrote:2 imap Folders can't be deletetd or synchronised
not in Outlook, not in hms-admin-console
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

percepts
Senior user
Senior user
Posts: 5282
Joined: 2009-10-20 16:33
Location: Sceptred Isle

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by percepts » 2014-08-12 00:18

Note to self: Must pay attention :oops:

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by ^DooM^ » 2014-08-12 00:24

Tis cool, I do it all the time :D
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 11:34

Hi & thanks for help...
i did a "REPAIR TABLE hm_imapfolders" query with SQLyog

but i got the message --> The storage engine for the table doesn't Support repair - 55B

any ideas?!

it is
1) Folderid 26 / folderissubscribed = 0
2) Folderid 29 / folderissubscribed = 1

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 12:13

edit:

when i go to table hm_messages and set a filter on MessageFolderid=26 (i thin it's the same as hm_imapfolders folderid=26)
then i got a lot of Messages which are not shown in Outlook... maybe that's my Problem?

User avatar
mattg
Moderator
Moderator
Posts: 20294
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by mattg » 2014-08-12 12:38

is folder 26 selected as a subscribed folder in outlook

(If you don't know please post version of Outlook)
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 13:13

it is equal
i can subscribe or not subscribe... the "folderissubscribed" item works in SQL... the Folders are shown in Outlook when i subscribe and don't shown when i don't subscribe...

both Folders are unsubscribed now and the folderissubscribed item Shows "0"
i think there is a Problem inside the Folders... can it be?

Outlook 2010 and 2013 - same Problem

User avatar
mattg
Moderator
Moderator
Posts: 20294
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by mattg » 2014-08-12 13:33

so, the issue is that you can't remove these folders, or synchronise them, but you can 'subscribe to them' or 'unsubscribe to them', is that correct?

Does Outlook keep offline copies of these folders?
Outlook is notoriously bad at IMAP, especially Outlook 2013.

Does say, Thunderbird allow you to remove these folders, or to synch them?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 14:00

mattg wrote:so, the issue is that you can't remove these folders, or synchronise them, but you can 'subscribe to them' or 'unsubscribe to them', is that correct?
--> YES that is correct
mattg wrote:Does Outlook keep offline copies of these folders?
Outlook is notoriously bad at IMAP, especially Outlook 2013.
maybe there offline Folders at some Clients... but it's no Problem, all Mails are saved from this Folders...
if the solution should be a "hard delete" @ database then it must be :) (but how without crashing DB)
mattg wrote:Does say, Thunderbird allow you to remove these folders, or to synch them?
Thunderbird having same Problems such Outlook :(

percepts
Senior user
Senior user
Posts: 5282
Joined: 2009-10-20 16:33
Location: Sceptred Isle

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by percepts » 2014-08-12 14:33

can you confirm that the folder names you see in outlook are the same as you see in hmailadmin when you look at the account advanced tab edit folders list.

e.g is the foldername called "Trash" in hmail but deleted "items in outlook" or are they both the same name

OR

is the foldername case identical in both setups

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 14:57

the Folder names are identically and i can Change them without probs

User avatar
mattg
Moderator
Moderator
Posts: 20294
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by mattg » 2014-08-12 16:06

Are these public folders?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 17:07

no, the Folders created @ inbox 6 months ago...
everything works fine... but some day Outlook starts to make imap Connections without closing them...
and the users starting to hard kill Outlook... in meaning of that i think there is something corrupt at these 2 Folders...
synchronise @this 2 Folders take a long time and never ends - so we want do delete these folders completly

edit:
i found this one @ error logs
"ERROR" 3808 "2014-07-28 17:32:58.140" "Severity: 2 (High), Code: HM4208, Source: IOCPQueueWorkerTask::DoWork, Description: An unknown error occured while handling asynchronous requests."

User avatar
mattg
Moderator
Moderator
Posts: 20294
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by mattg » 2014-08-12 17:24

Then just kill the database entries for them, and then run Data Directory Synchroniser, to put any mail in them back into the inbox.

Restart your hMailserver after you drop those entries, and DDS may take a LONG TIME depending on number of messages etc
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

percepts
Senior user
Senior user
Posts: 5282
Joined: 2009-10-20 16:33
Location: Sceptred Isle

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by percepts » 2014-08-12 17:24

OR

how many emails/data do you have in the account ?

I'm thinking you could create another account with same folder structure, drag and drop the mail from old to new account except the two folders causing the problem.
Then delete the old acount
Then rename the new account to the old account name.

made_my_day
New user
New user
Posts: 9
Joined: 2014-08-11 13:28

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by made_my_day » 2014-08-12 17:30

mattg wrote:Then just kill the database entries for them, and then run Data Directory Synchroniser, to put any mail in them back into the inbox.

Restart your hMailserver after you drop those entries, and DDS may take a LONG TIME depending on number of messages etc
The entries in SQL - tables - hm_imapfolders
--> Folder id 26 & 29?
just "klick" and trash?

User avatar
mattg
Moderator
Moderator
Posts: 20294
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Post by mattg » 2014-08-12 17:31

That's what I'm thinking.

Backup first just in case, also a good idea to copy your data directory somewhere else as well...
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

Post Reply