Bacula-users
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: [Bacula-users] Postgres Error

2011-05-19 06:48:20
Subject: Re: [Bacula-users] Postgres Error
From: Martin Simmons <martin AT lispworks DOT com>
To: Mike Seda <maseda AT stanford DOT edu>
Date: Thu, 19 May 2011 11:45:01 +0100 
Oh, I see now -- CREATE TABLE JobHisto (LIKE Job) doesn't create a sequence
(and it isn't wanted).

__Martin


>>>>> On Wed, 18 May 2011 12:05:18 -0700, Mike Seda said:
> 
> All,
> OK. It looks like this issue has shown up before and is not critical:
> http://old.nabble.com/regression-tests%3A-jobhisto_jobid_seq-td28277084.html
> 
> If anyone else runs into this in the future, the relevant commit is at 
> the following link:
> http://www.bacula.org/git/cgit.cgi/bacula/commit/?id=fe35ad03e0bff911ab8c7fcea9684bba83e3e9b9
> 
> I'm not sure why this commit never made it into bacula-client-5.0.3 from 
> FreeBSD Ports though.
> 
> Mike
> 
> 
> On 05/18/2011 11:16 AM, Mike Seda wrote:
> > Hi Martin,
> > It turns out that I do have a jobhisto table after all:
> >
> > bacula=> SELECT table_name FROM information_schema.tables WHERE 
> > table_schema = 'public';
> >    table_name
> > ----------------
> >  location
> >  filename
> >  path
> >  file
> >  mediatype
> >  pool
> >  storage
> >  log
> >  fileset
> >  media
> >  locationlog
> >  jobhisto
> >  pathhierarchy
> >  unsavedfiles
> >  basefiles
> >  jobmedia
> >  job
> >  client
> >  counters
> >  version
> >  cdimages
> >  device
> >  status
> >  pathvisibility
> > (24 rows)
> >
> > bacula=>
> >
> > Mike
> >
> >
> > On 05/18/2011 10:46 AM, Mike Seda wrote:
> >> Hi Martin,
> >> It looks like make_bacula_tables succeeded. There were some notices (not
> >> errors) though, which are provided below:
> >>
> >> [pgsql@bmir-backup-dir /usr/local]$ share/bacula/make_bacula_tables
> >> Making PostgreSQL tables
> >> psql:<stdin>:7: NOTICE:  CREATE TABLE will create implicit sequence
> >> "filename_filenameid_seq" for serial column "filename.filenameid"
> >> psql:<stdin>:7: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
> >> index "filename_pkey" for table "filename"
> >> CREATE TABLE
> >> ALTER TABLE
> >> CREATE INDEX
> >> psql:<stdin>:17: NOTICE:  CREATE TABLE will create implicit sequence
> >> "path_pathid_seq" for serial column "path.pathid"
> >> psql:<stdin>:17: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "path_pkey" for table "path"
> >> CREATE TABLE
> >> ALTER TABLE
> >> CREATE INDEX
> >> psql:<stdin>:33: NOTICE:  CREATE TABLE will create implicit sequence
> >> "file_fileid_seq" for serial column "file.fileid"
> >> psql:<stdin>:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "file_pkey" for table "file"
> >> CREATE TABLE
> >> CREATE INDEX
> >> CREATE INDEX
> >> psql:<stdin>:84: NOTICE:  CREATE TABLE will create implicit sequence
> >> "job_jobid_seq" for serial column "job.jobid"
> >> psql:<stdin>:84: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "job_pkey" for table "job"
> >> CREATE TABLE
> >> CREATE INDEX
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:99: NOTICE:  CREATE TABLE will create implicit sequence
> >> "location_locationid_seq" for serial column "location.locationid"
> >> psql:<stdin>:99: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "location_pkey" for table "location"
> >> CREATE TABLE
> >> psql:<stdin>:109: NOTICE:  CREATE TABLE will create implicit sequence
> >> "fileset_filesetid_seq" for serial column "fileset.filesetid"
> >> psql:<stdin>:109: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "fileset_pkey" for table "fileset"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:126: NOTICE:  CREATE TABLE will create implicit sequence
> >> "jobmedia_jobmediaid_seq" for serial column "jobmedia.jobmediaid"
> >> psql:<stdin>:126: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "jobmedia_pkey" for table "jobmedia"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:178: NOTICE:  CREATE TABLE will create implicit sequence
> >> "media_mediaid_seq" for serial column "media.mediaid"
> >> psql:<stdin>:178: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "media_pkey" for table "media"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:188: NOTICE:  CREATE TABLE will create implicit sequence
> >> "mediatype_mediatypeid_seq" for serial column "mediatype.mediatypeid"
> >> psql:<stdin>:188: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "mediatype_pkey" for table "mediatype"
> >> CREATE TABLE
> >> psql:<stdin>:195: NOTICE:  CREATE TABLE will create implicit sequence
> >> "storage_storageid_seq" for serial column "storage.storageid"
> >> psql:<stdin>:195: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "storage_pkey" for table "storage"
> >> CREATE TABLE
> >> psql:<stdin>:214: NOTICE:  CREATE TABLE will create implicit sequence
> >> "device_deviceid_seq" for serial column "device.deviceid"
> >> psql:<stdin>:214: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "device_pkey" for table "device"
> >> CREATE TABLE
> >> psql:<stdin>:246: NOTICE:  CREATE TABLE will create implicit sequence
> >> "pool_poolid_seq" for serial column "pool.poolid"
> >> psql:<stdin>:246: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "pool_pkey" for table "pool"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:259: NOTICE:  CREATE TABLE will create implicit sequence
> >> "client_clientid_seq" for serial column "client.clientid"
> >> psql:<stdin>:259: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "client_pkey" for table "client"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:270: NOTICE:  CREATE TABLE will create implicit sequence
> >> "log_logid_seq" for serial column "log.logid"
> >> psql:<stdin>:270: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "log_pkey" for table "log"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:285: NOTICE:  CREATE TABLE will create implicit sequence
> >> "locationlog_loclogid_seq" for serial column "locationlog.loclogid"
> >> psql:<stdin>:285: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "locationlog_pkey" for table "locationlog"
> >> CREATE TABLE
> >> psql:<stdin>:297: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "counters_pkey" for table "counters"
> >> CREATE TABLE
> >> psql:<stdin>:309: NOTICE:  CREATE TABLE will create implicit sequence
> >> "basefiles_baseid_seq" for serial column "basefiles.baseid"
> >> psql:<stdin>:309: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "basefiles_pkey" for table "basefiles"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:320: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "unsavedfiles_pkey" for table "unsavedfiles"
> >> CREATE TABLE
> >> psql:<stdin>:327: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "cdimages_pkey" for table "cdimages"
> >> CREATE TABLE
> >> psql:<stdin>:335: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "pathhierarchy_pkey" for table "pathhierarchy"
> >> CREATE TABLE
> >> CREATE INDEX
> >> psql:<stdin>:347: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "pathvisibility_pkey" for table "pathvisibility"
> >> CREATE TABLE
> >> CREATE INDEX
> >> CREATE TABLE
> >> psql:<stdin>:361: NOTICE:  CREATE TABLE / PRIMARY KEY will create
> >> implicit index "status_pkey" for table "status"
> >> CREATE TABLE
> >> INSERT 0 1
> >> INSERT 0 1
> >> .
> >> .
> >> INSERT 0 1
> >> INSERT 0 1
> >> Creation of Bacula PostgreSQL tables succeeded.
> >>
> >> BTW, it does not look like there was a jobhisto table created.
> >>
> >> Mike
> >>
> >>
> >> On 05/18/2011 04:26 AM, Martin Simmons wrote:
> >>>>>>>> On Tue, 17 May 2011 20:40:27 -0700, Mike Seda said:
> >>>> Hi All,
> >>>> I'm currently attempting to stand up a Bacula Director on FreeBSD 8.2.
> >>>>
> >>>> I installed the following packages from FreeBSD Ports:
> >>>> bacula-client-5.0.3
> >>>> bacula-server-5.0.3
> >>>> postgresql-client-8.3.14,1
> >>>> postgresql-server-8.3.14
> >>>>
> >>>> Everything has gone pretty well so far, but I just ran into the 
> >>>> error below:
> >>>> [pgsql@bmir-backup-dir /usr/local]$ 
> >>>> share/bacula/grant_bacula_privileges
> >>>> Granting PostgreSQL privileges
> >>>> CREATE ROLE
> >>>> GRANT
> >>>> GRANT
> >>>> .
> >>>> .
> >>>> GRANT
> >>>> GRANT
> >>>> psql:<stdin>:38: ERROR:  relation "jobhisto_jobid_seq" does not exist
> >>>> GRANT
> >>>> GRANT
> >>>> .
> >>>> .
> >>>> GRANT
> >>>> GRANT
> >>>> Privileges for user bacula granted on database bacula.
> >>>>
> >>>> Any thoughts?
> >>> Was make_bacula_tables 100% successful?  In particular, did it 
> >>> create the
> >>> jobhisto table?
> >>>
> >>> __Martin
> >>>
> >>> ------------------------------------------------------------------------------
> >>>  
> >>>
> >>> What Every C/C++ and Fortran developer Should Know!
> >>> Read this article and learn how Intel has extended the reach of its
> >>> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> >>> developers boost performance applications - including clusters.
> >>> http://p.sf.net/sfu/intel-dev2devmay
> >>> _______________________________________________
> >>> Bacula-users mailing list
> >>> Bacula-users AT lists.sourceforge DOT net
> >>> https://lists.sourceforge.net/lists/listinfo/bacula-users
> >> ------------------------------------------------------------------------------
> >>  
> >>
> >> What Every C/C++ and Fortran developer Should Know!
> >> Read this article and learn how Intel has extended the reach of its
> >> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> >> developers boost performance applications - including clusters.
> >> http://p.sf.net/sfu/intel-dev2devmay
> >> _______________________________________________
> >> Bacula-users mailing list
> >> Bacula-users AT lists.sourceforge DOT net
> >> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its 
> next-generation tools to help Windows* and Linux* C/C++ and Fortran 
> developers boost performance applications - including clusters. 
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 

------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [Bacula-users] OneFS = no doesn't work, Martin Simmons
Next by Date:  [Bacula-users] Tape Volume used after Migration Jobs, Robert Kromoser
Previous by Thread:  Re: [Bacula-users] Postgres Error, Mike Seda
Next by Thread:  Re: [Bacula-users] Postgres Error, Dan Langille
Indexes:  [Date] [Thread] [Top] [All Lists]