Problems with dbmail_physmessage

Hello All,

I am getting this messages in my logs and funny things
happening with 
thunderbird and outlook express, can someone point me in the
correct 
direction to solve this database issue?

Oct 02 22:41:05 celeste dbmail-lmtpd[12658]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:05 celeste dbmail-lmtpd[13951]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:05 celeste dbmail-lmtpd[12651]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:05 celeste dbmail-lmtpd[12673]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:05 celeste dbmail-lmtpd[12658]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:05 celeste dbmail-lmtpd[13951]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:05 celeste dbmail-lmtpd[12651]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:05 celeste dbmail-lmtpd[12673]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:12 celeste dbmail-lmtpd[14041]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:12 celeste dbmail-lmtpd[14041]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:12 celeste dbmail-lmtpd[14041]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:17 celeste dbmail-lmtpd[13951]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:17 celeste dbmail-lmtpd[13951]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:17 celeste dbmail-lmtpd[13951]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:20 celeste dbmail-lmtpd[13951]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:20 celeste dbmail-lmtpd[13951]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:20 celeste dbmail-lmtpd[13951]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:20 celeste dbmail-lmtpd[12658]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:20 celeste dbmail-lmtpd[12658]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:20 celeste dbmail-lmtpd[12658]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:21 celeste dbmail-lmtpd[14047]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:21 celeste dbmail-lmtpd[14047]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:21 celeste dbmail-lmtpd[14047]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:27 celeste dbmail-lmtpd[12658]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:27 celeste dbmail-lmtpd[12658]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:27 celeste dbmail-lmtpd[12658]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.
Oct 02 22:41:28 celeste dbmail-lmtpd[13951]: Error:[sql] 
dbmysql.c,db_query(+294): [The table 'dbmail_physmessage' is
full] 
[INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES (0, 
CURRENT_TIMESTAMP)]
Oct 02 22:41:30 celeste dbmail-lmtpd[13951]: Error:[db] 
db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of 
physmessage failed
Oct 02 22:41:34 celeste dbmail-lmtpd[13951]:
Error:[delivery] 
pipe.c,insert_messages(+545): failed to store temporary
message.

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

The log clearly states:

'''The table 'dbmail_physmessage' is full'''

so make sure you fix your mysql installation.


Sunny Koh wrote:
> Hello All,
> 
> I am getting this messages in my logs and funny things
happening with
> thunderbird and outlook express, can someone point me
in the correct
> direction to solve this database issue?
> 
> Oct 02 22:41:05 celeste dbmail-lmtpd[12658]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:05 celeste dbmail-lmtpd[13951]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:05 celeste dbmail-lmtpd[12651]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:05 celeste dbmail-lmtpd[12673]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:05 celeste dbmail-lmtpd[12658]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:05 celeste dbmail-lmtpd[13951]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:05 celeste dbmail-lmtpd[12651]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:05 celeste dbmail-lmtpd[12673]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:12 celeste dbmail-lmtpd[14041]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:12 celeste dbmail-lmtpd[14041]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:12 celeste dbmail-lmtpd[14041]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:17 celeste dbmail-lmtpd[13951]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:17 celeste dbmail-lmtpd[13951]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:17 celeste dbmail-lmtpd[13951]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:20 celeste dbmail-lmtpd[13951]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:20 celeste dbmail-lmtpd[13951]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:20 celeste dbmail-lmtpd[13951]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:20 celeste dbmail-lmtpd[12658]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:20 celeste dbmail-lmtpd[12658]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:20 celeste dbmail-lmtpd[12658]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:21 celeste dbmail-lmtpd[14047]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:21 celeste dbmail-lmtpd[14047]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:21 celeste dbmail-lmtpd[14047]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:27 celeste dbmail-lmtpd[12658]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:27 celeste dbmail-lmtpd[12658]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:27 celeste dbmail-lmtpd[12658]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> Oct 02 22:41:28 celeste dbmail-lmtpd[13951]:
Error:[sql]
> dbmysql.c,db_query(+294): [The table
'dbmail_physmessage' is full]
> [INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0,
> CURRENT_TIMESTAMP)]
> Oct 02 22:41:30 celeste dbmail-lmtpd[13951]:
Error:[db]
> db.c,db_insert_physmessage_with_internal_date(+1137):
insertion of
> physmessage failed
> Oct 02 22:41:34 celeste dbmail-lmtpd[13951]:
Error:[delivery]
> pipe.c,insert_messages(+545): failed to store temporary
message.
> 
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail