> Hello!
> Please uncomment this line in sql.c:
> #define DEBUG_SQL
> then recompile. indexer will output all SQL queries being
> sent to backend. What is the query which produces error?
I recompiled with the above statement enable and I'm getting a
segmentation vault. Here is the backtrace:
... lots of inserts ....
[32136] SQL 0.01s: INSERT INTO dict (url_id,word,intag)
VALUES(43075,'xls',65540) ->0
[32136] SQL 0.02s: COMMIT ->0
Indexer[32136]: [1] language: total: 153 en:153 (100%)
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1024 (LWP 32136)]
0x8051ffa in sql_query (Indexer=0x807f538,
qbuf=0xbfff4f9c "UPDATE url SET
status=200,last_mod_time=998334083,next_index_time=998938884,tag='',txt='PP2000_450
EXHIBIT L 1: Recommended Spare Parts List (Spare Parts For Basic Units)", ' '
<repeats 16 times>, "Rev.11 1"...)
at sql.c:1429
1429 fprintf(stderr,"[%d] SQL %.2fs: %s
->%d\n",getpid(),(float)ticks/1000,qbuf,
(gdb) where
#0 0x8051ffa in sql_query (Indexer=0x807f538,
qbuf=0xbfff4f9c "UPDATE url SET
status=200,last_mod_time=998334083,next_index_time=998938884,tag='',txt='PP2000_450
EXHIBIT L 1: Recommended Spare Parts List (Spare Parts For Basic Units)", ' '
<repeats 16 times>, "Rev.11 1"...)
at sql.c:1429
#1 0x80554cf in UdmLongUpdateUrl (Indexer=0x807f538, url_id=43075,
status=200, changed=1, size=23094, period=604800, tag=0xbfff64b7
"",
last_mod_time=998334083,
text_escaped=0xbfffc4cc "PP2000_450 EXHIBIT L 1: Recommended
Spare Parts List (Spare Parts For Basic Units)", ' ' <repeats 16
times>, "Rev.11 12-26-00", ' ' <repeats 22 times>, "LE TNR
times>PRIMEPOWER2000/450 D:GP2K-GA71 PRIME"...,
times>title_escaped=0xbfffc0fc "Ref-Spareparts-2001-04-06.xls",
content_type=0xbfffbe58 "text/html", keywords_escaped=0xbfffc2cc
"",
descript_escaped=0xbfffc200 "", crc32=4262739198, lang=0xbfffaa54
"en",
category=0xbfff64b7 "") at sql.c:2916
#2 0x804ea26 in UdmIndexNextURL ()
#3 0x804a227 in thread_main ()
#4 0x804abbd in main ()
#5 0x405d5baf in __libc_start_main () from /lib/libc.so.6
(gdb) x/20s qbuf
0xbfff4f9c: "UPDATE url SET
status=200,last_mod_time=998334083,next_index_time=998938884,tag='',txt='PP2000_450
EXHIBIT L 1: Recommended Spare Parts List (Spare Parts For Basic
Units)", ' ' <repeats 16 times>, "Rev.11 1"...
0xbfff5064: "2-26-00", ' ' <repeats 22 times>, "LE TNR
PRIMEPOWER2000/450 D:GP2K-GA71 PRIMEPOWER2000 8x450MHz/8MB
A3C40018216 A3C40018521
',title='Ref-Spareparts-2001-04-06.xls',content_type='text/"...
0xbfff512c:
"html',docsize=23094,keywords='',description='',crc32=-32228098,lang='en',category=''
WHERE rec_id=43075"
0xbfff5194: ""
0xbfff5195: ""
0xbfff5196: ""
Does this help?
--
Mit freundlichen Gruessen / Regards
Frank Ridderbusch
Fujitsu Siemens Computers, EP SQ XS1
Heinz Nixdorf Ring, 33106 Paderborn, Germany
Tel.: (49) 5251-8-22033 Email: [EMAIL PROTECTED]
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
