Re: [Bacula-users] Config token too long - limit of 500 characters?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Dan,

This restriction has been removed in version 7.0.0, which will be ready in about a week. There just remains compatibility testing (being done by Bacula Systems), and document, which I am doing, and it is about 1/2 finished.

Best regards,
Kern

On 03/23/2014 07:53 PM, Dan Langille wrote:
> For the record, given that I?ve found this error in the archives and did not find the answer.
>
> I was working on a COPY job today, expanding the SQL to help with some testing. I have encountered the config token limit.
>
> The error is:
>
> ###
> $ sudo service bacula-dir restart
> Stopping bacula_dir.
> Waiting for PIDS: 92978.
> Starting bacula_dir.
> 23-Mar 18:48 bacula-dir: ERROR TERMINATION at lex.c:268
> Config token too long, file: /usr/local/etc/bacula/client-crey.conf, line 104, begins at line 87
> /usr/local/etc/rc.d/bacula-dir: WARNING: failed to start bacula_dir
> ###
>
>
> The problem lines are:
>
> ###
>   Selection Pattern = "
> SELECT DISTINCT J.JobId, J.StartTime
>    FROM Job J, Pool P
>    WHERE P.Name = 'IncrFile'
>      AND P.PoolId = J.PoolId
>      AND J.Type = 'B'
>      AND J.JobStatus IN ('T','W')
>      AND J.jobBytes > 0
>      AND J.JobId NOT IN
>          (SELECT PriorJobId
>             FROM Job
>            WHERE Type IN ('B','C')
>              AND Job.JobStatus IN ('T','W')
>              AND PriorJobId != 0)
>      AND J.endtime > current_timestamp - interval '21 day'
>    AND J.jobid = 165750
> ORDER BY J.StartTime
>   LIMIT 1
> ?
> ###
>
> If I remove a character from the query, any character, the problem goes away.
>
> It appears that the query cannot be more than 500 characters including beginning and ending quotes.
>
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlMv1QwACgkQNgfoSvWqwEh0RQCfR/pd2k6ME77tGY7bWQt7zAP7
MPAAoPnSFOiDhWoyDmjkOoft21EjqKCq
=oH57
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users