From: <bac...@li...> - 2008-03-31 09:08:19
|
A NOTE has been added to this issue. ====================================================================== http://bugs.bacula.org/view.php?id=1066 ====================================================================== Reported By: hsn Assigned To: ebollengier ====================================================================== Project: bacula Issue ID: 1066 Category: Director Reproducibility: random Severity: major Priority: normal Status: assigned ====================================================================== Date Submitted: 03-19-2008 00:08 GMT Last Modified: 03-31-2008 10:08 BST ====================================================================== Summary: catalog query error during backup Description: 1. 19-Mar 00:45 brave-sd: User defined maximum volume capacity 260,046,848 exceeded 2. +on device "DATA" (/data/bacula). 3. 19-Mar 00:45 dharma-dir JobId 295: Fatal error: catreq.c:336 Invalid Catalog 4. +request: CatReq Job=HOME-backup.2008-03-19_00.08.03 UpdateMedia 5. +VolName=Brave-0015 VolJobs=1 VolFiles=0 VolBlocks=4030 VolBytes=259983550 6. +VolMounts=14 VolErrors=0 VolWrites=20161 MaxVolBytes=260046848 7. +EndTime=1205883934 VolStatus=Full Slot=0 relabel=0 InChanger=0 VolReadTime=0 8. +VolWriteTime=-132940036 VolFirstWritten=0 VolParts=0 9. 19-Mar 00:45 brave-sd: HOME-backup.2008-03-19_00.08.03 Fatal error: Error 10. +getting Volume info: 1990 Invalid Catalog Request: CatReq 11. +Job=HOME-backup.2008-03-19_00.08.03 UpdateMedia VolName=Brave-0015 VolJobs=1 12. +VolFiles=0 VolBlocks=4030 VolBytes=259983550 VolMounts=14 VolErrors=0 13. +VolWrites=20161 MaxVolBytes=260046848 EndTime=1205883934 VolStatus=Full Slot=0 14. +relabel=0 InChanger=0 VolReadTime=0 VolWriteTime=-132940036 VolFirstWritten=0 15. +VolParts=0 postgresql 8.2 logfile contains following errors: Mar 19 00:45:46 sanatana postgres[94537]: [3-1] ERROR: unexpected message type 0x58 during COPY from stdin Mar 19 00:45:46 sanatana postgres[94537]: [3-2] CONTEXT: COPY batch, line 20610: "" Mar 19 00:45:46 sanatana postgres[94537]: [3-3] STATEMENT: COPY batch FROM STDIN Mar 19 00:45:46 sanatana postgres[94537]: [4-1] LOG: could not send data to client: Broken pipe Mar 19 00:45:46 sanatana postgres[94537]: [5-1] LOG: unexpected EOF on client connection ====================================================================== ---------------------------------------------------------------------- kern - 03-19-08 07:30 ---------------------------------------------------------------------- If this fails each time you run, as you *seem* to imply, then you most likely have a broken build; otherwise, please read www.bacula.org -> Bug Reports and provide sufficient info to analyze/resolve this issue otherwise we must close the bug as being "not reproducible" due to insufficient information. ---------------------------------------------------------------------- hsn - 03-26-08 22:55 ---------------------------------------------------------------------- it doesnt fail every time, it seems to be race condition in SQL module due to bad locking. SQL Query is sent on socket which is currently used for COPY operation. ---------------------------------------------------------------------- ebollengier - 03-27-08 10:37 ---------------------------------------------------------------------- Could you check that your postgresql build is thread safe ? with something like "nm /usr/lib/libpq.so | grep pthread" Batch mode uses a dedicate sql connection, so bad locking is not on the top of the list. Thanks ---------------------------------------------------------------------- chowmeined - 03-30-08 14:21 ---------------------------------------------------------------------- I am also running into this issue, or at least I am getting the same error in postgres. Backups seem to work when the job is small (1500 files), but if the job is large (250,000 files) then I get this error. Could it possibly be an issue with batch inserts? 2008-03-30 03:38:02 PDT ERROR: table "temp" does not exist 2008-03-30 03:38:02 PDT STATEMENT: DROP TABLE temp 2008-03-30 03:38:02 PDT ERROR: table "temp1" does not exist 2008-03-30 03:38:02 PDT STATEMENT: DROP TABLE temp1 2008-03-30 05:47:32 PDT ERROR: unexpected message type 0x58 during COPY from stdin 2008-03-30 05:47:32 PDT CONTEXT: COPY batch, line 235307 2008-03-30 05:47:32 PDT STATEMENT: COPY batch FROM STDIN 2008-03-30 05:47:32 PDT LOG: could not send data to client: Broken pipe 2008-03-30 05:47:32 PDT STATEMENT: COPY batch FROM STDIN 2008-03-30 05:47:32 PDT LOG: unexpected EOF on client connection -- System Information -- Bacula Version: Version: 2.2.8 (26 January 2008) i486-pc-linux-gnu debian 4.0 Postgres Version: PostgreSQL 8.3.1 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) OS Version: Linux 2.6.18-6-686 http://bugs.bacula.org/view.php?id=1 SMP Sun Feb 10 22:11:31 UTC 2008 i686 GNU/Linux It appears that libpq.so is linked with libpthread: ldd /usr/lib/libpq.so | grep pthread libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7d1c000) I have attached my config.out from compiling bacula as well as the output of pg_config which shows the options used to build postgres. ---------------------------------------------------------------------- ebollengier - 03-31-08 10:08 ---------------------------------------------------------------------- chowmeined, Can you tell me if your bacula-dir binary is linked with the right postgresql lib ? (ldd /path/to/bacula-dir) Can you reproduce this bug ? Can you send me the list of your files ? (it could be an escaping problem) Thanks Issue History Date Modified Username Field Change ====================================================================== 03-19-08 00:08 hsn New Issue 03-19-08 07:30 kern Note Added: 0003220 03-19-08 07:30 kern Status new => feedback 03-26-08 22:55 hsn Note Added: 0003234 03-27-08 10:34 ebollengier Status feedback => assigned 03-27-08 10:34 ebollengier Assigned To => ebollengier 03-27-08 10:37 ebollengier Note Added: 0003235 03-30-08 14:21 chowmeined Note Added: 0003243 03-30-08 14:25 chowmeined File Added: config.out 03-30-08 14:26 chowmeined File Added: pg_config.txt 03-31-08 10:08 ebollengier Note Added: 0003244 ====================================================================== |