Strange postresSQL errors...

[Madison Kelly]

Hi all,

   I was working on my backup program when I started getting this error. 
It seems out of the blue because what I was working on had nothing to do 
with the operations around this error. The error is in the middle of 
some database calls the program was making and the number before the DB 
call is the program line number. PostgresSQL 7.4 on Fedora Core 1:


=- Error -=

  | |- 2587 DBI: SELECT file_backup, file_restore, file_display FROM 
file_dir WHERE file_parent_dir='/Business/AlteevesNiche/Archive' AND 
file_name='3d' AND file_src_uuid='21b8155e-bf55-446c-9776-7d72b451e91e'
  | |- 2587 DBI: SELECT file_backup, file_restore, file_display FROM 
file_dir WHERE file_parent_dir='/Business/AlteevesNiche/Archive/3d' AND 
file_name='Tt' AND file_src_uuid='21b8155e-bf55-446c-9776-7d72b451e91e'
  | |- 2587 DBI: SELECT file_backup, file_restore, file_display FROM 
file_dir WHERE file_parent_dir='/Business/AlteevesNiche/Archive' AND 
file_name='Alteeve's Niche' AND 
file_src_uuid='21b8155e-bf55-446c-9776-7d72b451e91e'

DBD::Pg::st execute failed: ERROR:  syntax error at or near "s" at 
character 173 at ./cron.pl line 2589.
DBD::Pg::st fetchrow_array failed: no statement executing at ./cron.pl 
line 2590.
sh: -c: line 1: unexpected EOF while looking for matching `''
sh: -c: line 2: syntax error: unexpected end of file

  | |- 2587 DBI: SELECT file_backup, file_restore, file_display FROM 
file_dir WHERE file_parent_dir='/Business/AlteevesNiche/Archive' AND 
file_name='an-webmail' AND 
file_src_uuid='21b8155e-bf55-446c-9776-7d72b451e91e'
  | |- 2587 DBI: SELECT file_backup, file_restore, file_display FROM 
file_dir WHERE 
file_parent_dir='/Business/AlteevesNiche/Archive/an-webmail' AND 
file_name='webmail' AND file_src_uuid='21b8155e-bf55-446c-9776-7d72b451e91e'
  | |- 2587 DBI: SELECT file_backup, file_restore, file_display FROM 
file_dir WHERE 
file_parent_dir='/Business/AlteevesNiche/Archive/an-webmail/webmail' AND 
file_name='class' AND file_src_uuid='21b8155e-bf55-446c-9776-7d72b451e91e'

  =- End error -=

Here is the chunk of code with the line numbers:

  =- Code Snippet -=

2587: $ln=__LINE__; print " | |- $ln DBI: SELECT file_backup, 
file_restore, file_display FROM file_dir WHERE 
file_parent_dir='$file_parent_dir' AND file_name='$file_name' AND 
file_src_uuid='$file_src_uuid'\n";
2588: $DBreq=$DB->prepare("SELECT file_backup, file_restore FROM 
file_dir WHERE file_parent_dir='$file_parent_dir' AND 
file_name='$file_name' AND file_src_uuid='$file_src_uuid'") || die 
$DBI::errstr;
2589: $passed_file_backup=$DBreq->execute();
2590: @passed_file_backup=$DBreq->fetchrow_array();
2591: $passed_file_backup=@passed_file_backup[0];

  =- End Code Snippet -=

   It looks like it is erroring on the 'execute' and 'fetchrow_array'. 
It performs this call hundreds of times and the error only pops up once 
or twice. Any insight will be greatly appreciated!!

The ever-question-asking Madison
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml