greensql-fw[2002]: segfault at db1 ip 00000db1 sp bfb0d1ac error 14 in greensql-fw[8048000+26000]

1 reply
spids2
spids2's picture
Joined: 06/11/2009
User offline. Last seen 39 weeks 5 hours ago.

I'm having greensql-fw-0.9.6 die randomly on me every 10 days or so, it was running fine for a couple months now dieing ever so often :S, any help would be much appreciated and if u need any other logs let me know.

Thanks,

--spids

messages:

Jun 11 03:54:03 none kernel: greensql-fw[2002]: segfault at db1 ip 00000db1 sp bfb0d1ac error 14 in greensql-fw[8048000+26000]

Greensql.log:

11/Jun/2009 3:54:03] NET_DEBUG [1]frontend socket fired 9
[11/Jun/2009 3:54:03] SQL_DEBUG QUERY command[myDB]: select * from myDBTbl
[11/Jun/2009 3:54:03] SQL_DEBUG AFTER NORM : select * from mydbtbl
[11/Jun/2009 3:54:03] SQL_DEBUG RISK : 0
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 5 bytes (received 10239)
[11/Jun/2009 3:54:03] NET_DEBUG Long response. Number of fields 12
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 65, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 75, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 73, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 77, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 75, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 79, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 75, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 69, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 83, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 73, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 75, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG Additionla Header size 77, type 3.
[11/Jun/2009 3:54:03] NET_DEBUG End of fields packet 901-10239
[11/Jun/2009 3:54:03] NET_DEBUG Last Field size 9.
[11/Jun/2009 3:54:03] NET_DEBUG End of header-start of data (left 9329 bytes).
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 9329
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 77 bytes (received 6195)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6195
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 180 bytes (received 10287)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10287
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 74 bytes (received 6154)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6154
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 60 bytes (received 10280)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10280
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 92 bytes (received 6157)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6157
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 56 bytes (received 10262)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10262
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 116 bytes (received 6192)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6192
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 116 bytes (received 10302)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10302
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 121 bytes (received 6161)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6161
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 105 bytes (received 10268)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10268
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 80 bytes (received 6192)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6192
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 77 bytes (received 10287)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10287
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 69 bytes (received 6192)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6192
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 115 bytes (received 10247)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10247
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 65 bytes (received 6202)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 6202
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 106 bytes (received 10245)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10245
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 1603 bytes (received 10427)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10427
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 1623 bytes (received 10837)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10837
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 4680 bytes (received 10490)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10490
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 529 bytes (received 10385)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10385
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 2246 bytes (received 10560)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10560
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 2341 bytes (received 12537)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 12537
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 7151 bytes (received 12198)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 12198
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]frontend socket fired 9
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG Proxy data send
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 7152 bytes (received 15286)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 15286
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 4421 bytes (received 14162)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 14162
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 5760 bytes (received 12842)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 12842
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 6199 bytes (received 12243)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 12243
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 4056 bytes (received 11327)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 11327
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 175 bytes (received 10354)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10354
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 236 bytes (received 10388)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10388
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 226 bytes (received 10401)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 10401
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]backend socket fired 10
[11/Jun/2009 3:54:03] NET_DEBUG packet size expected 82 bytes (received 3339)
[11/Jun/2009 3:54:03] NET_DEBUG Data packet, size left 3339
[11/Jun/2009 3:54:03] NET_DEBUG End of long response.
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG [1]frontend socket fired 9
[11/Jun/2009 3:54:03] NET_DEBUG Socket_write
[11/Jun/2009 3:54:03] NET_DEBUG Failed to send, closing socket
[11/Jun/2009 3:54:03] NET_DEBUG connection close()
[11/Jun/2009 3:54:03] NET_DEBUG Failed to read socket, closing socket
[11/Jun/2009 3:54:03] NET_DEBUG connection close()

yuli
yuli's picture
Joined: 01/30/2008
User offline. Last seen 20 hours 55 min ago.

Hello Spids

I advise you to just upgrade to the latest official version or even update to the version available via subversion.

A lot of bugs were fixed including the one you describe.

Best regards,
Yuli

Back to top