SMPP connection thread blocked by DLR sql query

"Cezary Siwek" <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
Hello,
 
 
I saw this problem few times in my SMPP connection logs.
When mysql connection dies for some reason (but tcp socket is still open),
trafiic to my smpp sms center is totally blocked.
After 15 mins (tcp timeout) when mysql connection gets reconnected i have
smpp traffic back.
Anyone seen this problem before ? I guess it can be fixed by calling sql
queries in a separate thread/process. 
 
I've tested it with various kannel and libmysql versions
 
regards,
 
Cezary Siwek
 
 
 
2008-04-22 14:14:48 [28402] [7] DEBUG: SMPP PDU dump ends.
2008-04-22 14:14:48 [28402] [7] DEBUG: DLR[mysql]: Adding DLR smsc=smpp,
ts=4294967295, src=000000, dst=+4478666xxxxx, mask=7, boxc=company
2008-04-22 14:14:48 [28402] [7] DEBUG: sql: INSERT INTO dlr (smsc, ts,
source, destination, service, url, mask, boxc, status) VALUES ('smpp',
'4294967295', '000000', '+4478666xxxxx',
 'test',
'http://localhost/cgi-bin/dlr?from=%P&to=%p&smsc=%i&timestamp=%t&msgid=12088
70087ZVHnCeVxFb&dlr=%d', '7', 'company', '0');
2008-04-22 14:30:16 [28402] [7] ERROR: MYSQL: database check failed!
2008-04-22 14:30:16 [28402] [7] ERROR: MYSQL: Lost connection to MySQL
server during query
2008-04-22 14:30:16 [28402] [7] INFO: MYSQL: Connected to server at
db1.local.company.
2008-04-22 14:30:16 [28402] [7] INFO: MYSQL: server version
5.0.32-Debian_7etch4-log, client version 5.0.32.
2008-04-22 14:30:16 [28402] [7] ERROR: MYSQL: database check failed!
2008-04-22 14:30:16 [28402] [7] ERROR: MYSQL: MySQL server has gone away
2008-04-22 14:30:16 [28402] [7] INFO: MYSQL: Connected to server at
db1.local.company.
2008-04-22 14:30:16 [28402] [7] INFO: MYSQL: server version
5.0.32-Debian_7etch4-log, client version 5.0.32.
2008-04-22 14:30:16 [28402] [7] DEBUG: SMPP[smpp]: Sending enquire link:
2008-04-22 14:30:16 [28402] [7] DEBUG: SMPP PDU 0x81dd1a0 dump:
2008-04-22 14:30:16 [28402] [7] DEBUG:   type_name: enquire_link
2008-04-22 14:30:16 [28402] [7] DEBUG:   command_id: 21 = 0x00000015
2008-04-22 14:30:16 [28402] [7] DEBUG:   command_status: 0 = 0x00000000
2008-04-22 14:30:16 [28402] [7] DEBUG:   sequence_number: 2811 = 0x00000afb
2008-04-22 14:30:16 [28402] [7] DEBUG: SMPP PDU dump ends.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.