Mailing List Archive

[DBMail 0001078]: DBMail stopped working after upgrading to mysql 5.7
A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=1078
======================================================================
Reported By: px3
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1078
Category: Database layer
Reproducibility: have not tried
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 16-May-16 12:39 CEST
Last Modified: 05-Sep-16 17:05 CEST
======================================================================
Summary: DBMail stopped working after upgrading to mysql 5.7
Description:
After upgrading mysql to 5.7.12 dbmail stopped working.
Inserts into the database are no longer possible.

Using mysql and executing the same statements from the mysql-client,
everything works fine.

All other applications on the machine are runnning fine, expect dbmail.

dbmail-util -a shows no errors.

Even trying to create a new user with dbmail-users ends up in:
May 16 12:42:51 rdsroot dbmail/user[29631]: Debug:[user] do_add(+65):
Adding user px3 with password type crypt,0 bytes mailbox limit and clientid
0...
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5810] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5aa0] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_begin_transaction(+542): BEGIN
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [INSERT INTO dbmail_users
(userid,passwd,client_idnr,maxmail_size,encryption_type) VALUES (?,?,?,?,?)
]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 2:[fE3UF87llocO6]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 3:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 4:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 5:[crypt]


And then nothing more happens.

Mysql shows no errors in the logfiles.

======================================================================

----------------------------------------------------------------------
(0003734) px3 (reporter) - 16-May-16 13:08
http://www.dbmail.org/mantis/view.php?id=1078#c3734
----------------------------------------------------------------------
The severity is "block", but i can't change it :(

----------------------------------------------------------------------
(0003735) Wouter0100 (reporter) - 19-Jul-16 23:16
http://www.dbmail.org/mantis/view.php?id=1078#c3735
----------------------------------------------------------------------
I agree with you, this is a major blocker. The SQL files are also incorrect
(datetime default), but we're able to fix that manually.

Although I'm not experienced with C, it seems to hang around here
https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L3976
. Not sure why - yet.

----------------------------------------------------------------------
(0003736) Wouter0100 (reporter) - 19-Jul-16 23:28
http://www.dbmail.org/mantis/view.php?id=1078#c3736
----------------------------------------------------------------------
Now I'm pretty sure it has to do with the transactions. Removing aliases
works fine
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/modules/authsql.c#L571-L589),
but it hangs on removing a user
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L4006-L4024).


----------------------------------------------------------------------
(0003737) Wouter0100 (reporter) - 19-Jul-16 23:52
http://www.dbmail.org/mantis/view.php?id=1078#c3737
----------------------------------------------------------------------
Tomorrow I'll try compiling dbmail so I'm able to test some code changes
(currently using from debian packages). Could also be a bug in libzdb,
because PreparedStatement_execute seems to hang when it's a transaction.

----------------------------------------------------------------------
(0003738) px3 (reporter) - 20-Jul-16 15:40
http://www.dbmail.org/mantis/view.php?id=1078#c3738
----------------------------------------------------------------------
This behaviour accours on every "insert"
Even new mails are no longer written to the DB

----------------------------------------------------------------------
(0003741) px3 (reporter) - 05-Sep-16 17:05
http://www.dbmail.org/mantis/view.php?id=1078#c3741
----------------------------------------------------------------------
close this ticket. i fixed it myself by patching a bunch of code :(

Issue History
Date Modified Username Field Change
======================================================================
16-May-16 12:39 px3 New Issue
16-May-16 13:06 px3 Issue Monitored: px3
16-May-16 13:08 px3 Note Added: 0003734
19-Jul-16 23:16 Wouter0100 Note Added: 0003735
19-Jul-16 23:16 Wouter0100 Issue Monitored: Wouter0100
19-Jul-16 23:28 Wouter0100 Note Added: 0003736
19-Jul-16 23:52 Wouter0100 Note Added: 0003737
20-Jul-16 15:40 px3 Note Added: 0003738
05-Sep-16 17:05 px3 Note Added: 0003741
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[DBMail 0001078]: DBMail stopped working after upgrading to mysql 5.7 [ In reply to ]
A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=1078
======================================================================
Reported By: px3
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1078
Category: Database layer
Reproducibility: have not tried
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 16-May-16 12:39 CEST
Last Modified: 07-Sep-16 11:41 CEST
======================================================================
Summary: DBMail stopped working after upgrading to mysql 5.7
Description:
After upgrading mysql to 5.7.12 dbmail stopped working.
Inserts into the database are no longer possible.

Using mysql and executing the same statements from the mysql-client,
everything works fine.

All other applications on the machine are runnning fine, expect dbmail.

dbmail-util -a shows no errors.

Even trying to create a new user with dbmail-users ends up in:
May 16 12:42:51 rdsroot dbmail/user[29631]: Debug:[user] do_add(+65):
Adding user px3 with password type crypt,0 bytes mailbox limit and clientid
0...
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5810] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5aa0] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_begin_transaction(+542): BEGIN
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [INSERT INTO dbmail_users
(userid,passwd,client_idnr,maxmail_size,encryption_type) VALUES (?,?,?,?,?)
]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 2:[fE3UF87llocO6]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 3:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 4:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 5:[crypt]


And then nothing more happens.

Mysql shows no errors in the logfiles.

======================================================================

----------------------------------------------------------------------
(0003734) px3 (reporter) - 16-May-16 13:08
http://www.dbmail.org/mantis/view.php?id=1078#c3734
----------------------------------------------------------------------
The severity is "block", but i can't change it :(

----------------------------------------------------------------------
(0003735) Wouter0100 (reporter) - 19-Jul-16 23:16
http://www.dbmail.org/mantis/view.php?id=1078#c3735
----------------------------------------------------------------------
I agree with you, this is a major blocker. The SQL files are also incorrect
(datetime default), but we're able to fix that manually.

Although I'm not experienced with C, it seems to hang around here
https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L3976
. Not sure why - yet.

----------------------------------------------------------------------
(0003736) Wouter0100 (reporter) - 19-Jul-16 23:28
http://www.dbmail.org/mantis/view.php?id=1078#c3736
----------------------------------------------------------------------
Now I'm pretty sure it has to do with the transactions. Removing aliases
works fine
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/modules/authsql.c#L571-L589),
but it hangs on removing a user
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L4006-L4024).


----------------------------------------------------------------------
(0003737) Wouter0100 (reporter) - 19-Jul-16 23:52
http://www.dbmail.org/mantis/view.php?id=1078#c3737
----------------------------------------------------------------------
Tomorrow I'll try compiling dbmail so I'm able to test some code changes
(currently using from debian packages). Could also be a bug in libzdb,
because PreparedStatement_execute seems to hang when it's a transaction.

----------------------------------------------------------------------
(0003738) px3 (reporter) - 20-Jul-16 15:40
http://www.dbmail.org/mantis/view.php?id=1078#c3738
----------------------------------------------------------------------
This behaviour accours on every "insert"
Even new mails are no longer written to the DB

----------------------------------------------------------------------
(0003741) px3 (reporter) - 05-Sep-16 17:05
http://www.dbmail.org/mantis/view.php?id=1078#c3741
----------------------------------------------------------------------
close this ticket. i fixed it myself by patching a bunch of code :(

----------------------------------------------------------------------
(0003742) alan (reporter) - 07-Sep-16 11:41
http://www.dbmail.org/mantis/view.php?id=1078#c3742
----------------------------------------------------------------------
Please consider donating your patches so others can share in your success
and avoid issues that upgrading to mysql 5.7 brings.

Issue History
Date Modified Username Field Change
======================================================================
16-May-16 12:39 px3 New Issue
16-May-16 13:06 px3 Issue Monitored: px3
16-May-16 13:08 px3 Note Added: 0003734
19-Jul-16 23:16 Wouter0100 Note Added: 0003735
19-Jul-16 23:16 Wouter0100 Issue Monitored: Wouter0100
19-Jul-16 23:28 Wouter0100 Note Added: 0003736
19-Jul-16 23:52 Wouter0100 Note Added: 0003737
20-Jul-16 15:40 px3 Note Added: 0003738
05-Sep-16 17:05 px3 Note Added: 0003741
07-Sep-16 11:41 alan Note Added: 0003742
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[DBMail 0001078]: DBMail stopped working after upgrading to mysql 5.7 [ In reply to ]
A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=1078
======================================================================
Reported By: px3
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1078
Category: Database layer
Reproducibility: have not tried
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 16-May-16 12:39 CEST
Last Modified: 07-Sep-16 20:18 CEST
======================================================================
Summary: DBMail stopped working after upgrading to mysql 5.7
Description:
After upgrading mysql to 5.7.12 dbmail stopped working.
Inserts into the database are no longer possible.

Using mysql and executing the same statements from the mysql-client,
everything works fine.

All other applications on the machine are runnning fine, expect dbmail.

dbmail-util -a shows no errors.

Even trying to create a new user with dbmail-users ends up in:
May 16 12:42:51 rdsroot dbmail/user[29631]: Debug:[user] do_add(+65):
Adding user px3 with password type crypt,0 bytes mailbox limit and clientid
0...
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5810] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5aa0] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_begin_transaction(+542): BEGIN
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [INSERT INTO dbmail_users
(userid,passwd,client_idnr,maxmail_size,encryption_type) VALUES (?,?,?,?,?)
]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 2:[fE3UF87llocO6]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 3:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 4:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 5:[crypt]


And then nothing more happens.

Mysql shows no errors in the logfiles.

======================================================================

----------------------------------------------------------------------
(0003734) px3 (reporter) - 16-May-16 13:08
http://www.dbmail.org/mantis/view.php?id=1078#c3734
----------------------------------------------------------------------
The severity is "block", but i can't change it :(

----------------------------------------------------------------------
(0003735) Wouter0100 (reporter) - 19-Jul-16 23:16
http://www.dbmail.org/mantis/view.php?id=1078#c3735
----------------------------------------------------------------------
I agree with you, this is a major blocker. The SQL files are also incorrect
(datetime default), but we're able to fix that manually.

Although I'm not experienced with C, it seems to hang around here
https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L3976
. Not sure why - yet.

----------------------------------------------------------------------
(0003736) Wouter0100 (reporter) - 19-Jul-16 23:28
http://www.dbmail.org/mantis/view.php?id=1078#c3736
----------------------------------------------------------------------
Now I'm pretty sure it has to do with the transactions. Removing aliases
works fine
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/modules/authsql.c#L571-L589),
but it hangs on removing a user
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L4006-L4024).


----------------------------------------------------------------------
(0003737) Wouter0100 (reporter) - 19-Jul-16 23:52
http://www.dbmail.org/mantis/view.php?id=1078#c3737
----------------------------------------------------------------------
Tomorrow I'll try compiling dbmail so I'm able to test some code changes
(currently using from debian packages). Could also be a bug in libzdb,
because PreparedStatement_execute seems to hang when it's a transaction.

----------------------------------------------------------------------
(0003738) px3 (reporter) - 20-Jul-16 15:40
http://www.dbmail.org/mantis/view.php?id=1078#c3738
----------------------------------------------------------------------
This behaviour accours on every "insert"
Even new mails are no longer written to the DB

----------------------------------------------------------------------
(0003741) px3 (reporter) - 05-Sep-16 17:05
http://www.dbmail.org/mantis/view.php?id=1078#c3741
----------------------------------------------------------------------
close this ticket. i fixed it myself by patching a bunch of code :(

----------------------------------------------------------------------
(0003742) alan (reporter) - 07-Sep-16 11:41
http://www.dbmail.org/mantis/view.php?id=1078#c3742
----------------------------------------------------------------------
Please consider donating your patches so others can share in your success
and avoid issues that upgrading to mysql 5.7 brings.

----------------------------------------------------------------------
(0003743) px3 (reporter) - 07-Sep-16 20:18
http://www.dbmail.org/mantis/view.php?id=1078#c3743
----------------------------------------------------------------------
Cross my heard and hope to die: i won't publish my fixes.
I have been waiting 4 month that someone of the community might take care
of this bug and none did.

so, in my point of view, this project is dead.

i am thinking about creating a fork and keep on maintaining, but donating
to this project in the current status isn't worth it.

Issue History
Date Modified Username Field Change
======================================================================
16-May-16 12:39 px3 New Issue
16-May-16 13:06 px3 Issue Monitored: px3
16-May-16 13:08 px3 Note Added: 0003734
19-Jul-16 23:16 Wouter0100 Note Added: 0003735
19-Jul-16 23:16 Wouter0100 Issue Monitored: Wouter0100
19-Jul-16 23:28 Wouter0100 Note Added: 0003736
19-Jul-16 23:52 Wouter0100 Note Added: 0003737
20-Jul-16 15:40 px3 Note Added: 0003738
05-Sep-16 17:05 px3 Note Added: 0003741
07-Sep-16 11:41 alan Note Added: 0003742
07-Sep-16 20:18 px3 Note Added: 0003743
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
[DBMail 0001078]: DBMail stopped working after upgrading to mysql 5.7 [ In reply to ]
A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=1078
======================================================================
Reported By: px3
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1078
Category: Database layer
Reproducibility: have not tried
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 16-May-16 12:39 CEST
Last Modified: 07-Sep-16 20:57 CEST
======================================================================
Summary: DBMail stopped working after upgrading to mysql 5.7
Description:
After upgrading mysql to 5.7.12 dbmail stopped working.
Inserts into the database are no longer possible.

Using mysql and executing the same statements from the mysql-client,
everything works fine.

All other applications on the machine are runnning fine, expect dbmail.

dbmail-util -a shows no errors.

Even trying to create a new user with dbmail-users ends up in:
May 16 12:42:51 rdsroot dbmail/user[29631]: Debug:[user] do_add(+65):
Adding user px3 with password type crypt,0 bytes mailbox limit and clientid
0...
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5810] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5aa0] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_con_close(+291): [0xe05ca0] connection to pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db] db_con_get(+263):
[0xe05ca0] connection from pool
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_begin_transaction(+542): BEGIN
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_prepare(+419): [0xe05ca0] [INSERT INTO dbmail_users
(userid,passwd,client_idnr,maxmail_size,encryption_type) VALUES (?,?,?,?,?)
]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 1:[px3]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 2:[fE3UF87llocO6]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 3:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_u64(+439): [0xdf5d10] 4:[0]
May 16 12:42:51 rdsroot dbmail/user[29631]: Database:[db]
db_stmt_set_str(+427): [0xdf5d10] 5:[crypt]


And then nothing more happens.

Mysql shows no errors in the logfiles.

======================================================================

----------------------------------------------------------------------
(0003734) px3 (reporter) - 16-May-16 13:08
http://www.dbmail.org/mantis/view.php?id=1078#c3734
----------------------------------------------------------------------
The severity is "block", but i can't change it :(

----------------------------------------------------------------------
(0003735) Wouter0100 (reporter) - 19-Jul-16 23:16
http://www.dbmail.org/mantis/view.php?id=1078#c3735
----------------------------------------------------------------------
I agree with you, this is a major blocker. The SQL files are also incorrect
(datetime default), but we're able to fix that manually.

Although I'm not experienced with C, it seems to hang around here
https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L3976
. Not sure why - yet.

----------------------------------------------------------------------
(0003736) Wouter0100 (reporter) - 19-Jul-16 23:28
http://www.dbmail.org/mantis/view.php?id=1078#c3736
----------------------------------------------------------------------
Now I'm pretty sure it has to do with the transactions. Removing aliases
works fine
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/modules/authsql.c#L571-L589),
but it hangs on removing a user
(https://github.com/pjstevns/dbmail/blob/f5b73b342b4a6cae1bb15340e5da7330e29319c1/src/dm_db.c#L4006-L4024).


----------------------------------------------------------------------
(0003737) Wouter0100 (reporter) - 19-Jul-16 23:52
http://www.dbmail.org/mantis/view.php?id=1078#c3737
----------------------------------------------------------------------
Tomorrow I'll try compiling dbmail so I'm able to test some code changes
(currently using from debian packages). Could also be a bug in libzdb,
because PreparedStatement_execute seems to hang when it's a transaction.

----------------------------------------------------------------------
(0003738) px3 (reporter) - 20-Jul-16 15:40
http://www.dbmail.org/mantis/view.php?id=1078#c3738
----------------------------------------------------------------------
This behaviour accours on every "insert"
Even new mails are no longer written to the DB

----------------------------------------------------------------------
(0003741) px3 (reporter) - 05-Sep-16 17:05
http://www.dbmail.org/mantis/view.php?id=1078#c3741
----------------------------------------------------------------------
close this ticket. i fixed it myself by patching a bunch of code :(

----------------------------------------------------------------------
(0003742) alan (reporter) - 07-Sep-16 11:41
http://www.dbmail.org/mantis/view.php?id=1078#c3742
----------------------------------------------------------------------
Please consider donating your patches so others can share in your success
and avoid issues that upgrading to mysql 5.7 brings.

----------------------------------------------------------------------
(0003743) px3 (reporter) - 07-Sep-16 20:18
http://www.dbmail.org/mantis/view.php?id=1078#c3743
----------------------------------------------------------------------
Cross my heard and hope to die: i won't publish my fixes.
I have been waiting 4 month that someone of the community might take care
of this bug and none did.

so, in my point of view, this project is dead.

i am thinking about creating a fork and keep on maintaining, but donating
to this project in the current status isn't worth it.

----------------------------------------------------------------------
(0003744) alan (reporter) - 07-Sep-16 20:57
http://www.dbmail.org/mantis/view.php?id=1078#c3744
----------------------------------------------------------------------
I'm sorry you feel that way, I would have offered more help but am running
dbmail on FreeBSD with PostgreSQL, MySQL here is still 5.6 and as my life
is falling apart am unlikely to upgrade anytime soon. Paul Stevens put so
much effort in last year he's almost burnt out. Not sure where the others
are.
Please do fork and maintain, it's a great project, reasonably stable and
with plenty of opportunities for improvement.

Issue History
Date Modified Username Field Change
======================================================================
16-May-16 12:39 px3 New Issue
16-May-16 13:06 px3 Issue Monitored: px3
16-May-16 13:08 px3 Note Added: 0003734
19-Jul-16 23:16 Wouter0100 Note Added: 0003735
19-Jul-16 23:16 Wouter0100 Issue Monitored: Wouter0100
19-Jul-16 23:28 Wouter0100 Note Added: 0003736
19-Jul-16 23:52 Wouter0100 Note Added: 0003737
20-Jul-16 15:40 px3 Note Added: 0003738
05-Sep-16 17:05 px3 Note Added: 0003741
07-Sep-16 11:41 alan Note Added: 0003742
07-Sep-16 20:18 px3 Note Added: 0003743
07-Sep-16 20:57 alan Note Added: 0003744
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev