[Bacula-users] Fatal error: sql_create.c:841

[Guilherme Santos]

Hey guys, what's up?
Could someone try to help me to identify why some of my jobs have this error 
below? This happen only sometimes.


Fatal error: sql_create.c:841 Fill File table Query failed: INSERT INTO File 
(FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT 
batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, 
batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN 
Filename ON (batch.Name = Filename.Name): ERR=Lock wait timeout exceeded; try 
restarting transaction

I found this "solution" in a place. Do you think that will it resolve?



"If you run into this problem, there is a fairly simple fix in most
cases.  The default innodb lock wait timeout is 50 seconds.  To change
it, edit the MySQL config file (normally /etc/my.cnf) and change the line:

# innodb_lock_wait_timeout=50

to:

innodb_lock_wait_timeout=100

Then restart MySQL and Bacula."




Thanks!!
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

Hello Ana,

Thank you very much on detail description. I will set
innodb_autoinc_lock_mode=2
and I will test this.

I don’t use replication.

Yes, I was build bacula with batch-insert. Batch insert works, I can see
that when bacula send attributes and I show all process in mysql.

Thank you very much.

*—*

*Petar Kozić*
System Administrator


On April 14, 2017 at 3:33:47 AM, Ana Emília M. Arruda (
emiliaarr...@gmail.com) wrote:

Hello Petar,

I'm sorry I didn't give you details about the best value for '
innodb_autoinc_lock_mode'
 to use with bacula catalog.

Having "innodb_autoinc_lock_mode=2" is the best option for performance of bulk
INSERTs (you can see some INSERT...SELECT statements in the logs you sent
here).

I am not a DBA, but I would recommend you to have this value set to 2 for
better performance and avoid the locks/timeouts. Please be careful with
this value if you use replication (quite sure you don't need/use this for
bacula catalog).

The issue you are having is related to attribute insertion in catalog after
job runs. Since you are reporting this when dealing with some heavy
(maybe?) simultaneous full backup jobs, you will need to have your MariaDB
well tuned to get this working.

I would also recommend you to have your files pruned regularly from
catalog, so this file table doesn't grow too much in the case you deal with
millions of files.

You told in one of your emails: "I have enabled batch insert".  It is
strongly recommended to build bacula with batch insert enabled and this is
the default in newer versions.

Phil Stracchino gave very good recommendations here:
https://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg61883.html

The user was having a similar issue, please find here the complete thread:
https://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg61787.html

Hope this helps.

Best regards,
Ana

On Thu, Apr 13, 2017 at 10:45 PM, Ana Emília M. Arruda <
emiliaarr...@gmail.com> wrote:

> Hello Petar,
>
> Please have a look here: http://bacula.10910.n7.nabble.com/innodb-autoinc-
> lock-mode-td82493.html
>
> Maybe the script for MySQL tunning can help with MariaDB too:
> https://github.com/major/MySQLTuner-perl
>
> Best regards,
>
> Ana
>
> On Thu, Apr 13, 2017 at 10:09 PM, Petar Kozić  wrote:
>
>> I using MariaDB 10.1.
>> Which value of innodb_autoinc_lock_mode is best for Bacula, do you know ?
>>
>>
>>
>> *—*
>>
>> *Petar Kozić*
>> System Administrator
>>
>>
>>
>> On April 13, 2017 at 10:04:23 PM, Ana Emília M. Arruda (
>> emiliaarr...@gmail.com) wrote:
>>
>> Hello Petar,
>>
>> Could you please let us know which Bacula/MySQL Database version are you
>> using?
>>
>> Maybe it would be a good idea to have a look at "innodb_autoinc_lock_mode
>> 
>> " configuration.​
>>
>> ​Best regards,
>>
>> Ana​
>>
>>
>>
>> On Thu, Apr 13, 2017 at 4:23 PM, Petar Kozić  wrote:
>>
>>> Thank you on your answer. Yes I have about 80GB free in drive where is
>>> SD working directory.
>>>
>>>
>>> *—*
>>>
>>> *Petar Kozić*
>>> System Administrator
>>>
>>>
>>>
>>> On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda (
>>> emiliaarr...@gmail.com) wrote:
>>>
>>> Hi Petar,
>>>
>>> If you are using spool attributes, you need enough space in the SD
>>> working directory to store them before SD send attributes to Director.
>>>
>>> Could you please check if you have enough space in the SD working
>>> directory?
>>>
>>> Best regards,
>>> Ana
>>>
>>> On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić 
>>> wrote:
>>>
 Yes, I have.

 I was upload on pasterbin:
 http://pastebin.ca/3794414

 Log is contionous with same error.


 *—*

 *Petar Kozić*
 System Administrator


 On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
 djosip+n...@linuxpages.net) wrote:

 On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
 > @Josip Deanovic
 > Are you using spooling?
 > If yes, is your spool directory on the same file system as your
 database
 > data?
 >
 > No, I don’t spooling Data, only Attributes
 >
 > My config:
 > Spool Data = no
 > Spool Attributes = yes
 >
 >
 > I was increase innodb_timewait_lockout = 150 but error appears again.
 >
 > Some ideas ?

 Do you have anything useful in your mysql logs?

 --
 Josip Deanovic

 
 --
 Check out the vibrant tech community on one of the world's most
 engaging tech sites, Slashdot.org! http://sdm.link/slashdot
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 

Re: [Bacula-users] Fatal error sql_create.c

[Ana Emília M . Arruda]

Hello Petar,

I'm sorry I didn't give you details about the best value for '
innodb_autoinc_lock_mode'
 to use with bacula catalog.

Having "innodb_autoinc_lock_mode=2" is the best option for performance of bulk
INSERTs (you can see some INSERT...SELECT statements in the logs you sent
here).

I am not a DBA, but I would recommend you to have this value set to 2 for
better performance and avoid the locks/timeouts. Please be careful with
this value if you use replication (quite sure you don't need/use this for
bacula catalog).

The issue you are having is related to attribute insertion in catalog after
job runs. Since you are reporting this when dealing with some heavy
(maybe?) simultaneous full backup jobs, you will need to have your MariaDB
well tuned to get this working.

I would also recommend you to have your files pruned regularly from
catalog, so this file table doesn't grow too much in the case you deal with
millions of files.

You told in one of your emails: "I have enabled batch insert".  It is
strongly recommended to build bacula with batch insert enabled and this is
the default in newer versions.

Phil Stracchino gave very good recommendations here:
https://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg61883.html

The user was having a similar issue, please find here the complete thread:
https://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg61787.html

Hope this helps.

Best regards,
Ana

On Thu, Apr 13, 2017 at 10:45 PM, Ana Emília M. Arruda <
emiliaarr...@gmail.com> wrote:

> Hello Petar,
>
> Please have a look here: http://bacula.10910.n7.nabble.com/innodb-autoinc-
> lock-mode-td82493.html
>
> Maybe the script for MySQL tunning can help with MariaDB too:
> https://github.com/major/MySQLTuner-perl
>
> Best regards,
>
> Ana
>
> On Thu, Apr 13, 2017 at 10:09 PM, Petar Kozić  wrote:
>
>> I using MariaDB 10.1.
>> Which value of innodb_autoinc_lock_mode is best for Bacula, do you know ?
>>
>>
>>
>> *—*
>>
>> *Petar Kozić*
>> System Administrator
>>
>>
>>
>> On April 13, 2017 at 10:04:23 PM, Ana Emília M. Arruda (
>> emiliaarr...@gmail.com) wrote:
>>
>> Hello Petar,
>>
>> Could you please let us know which Bacula/MySQL Database version are you
>> using?
>>
>> Maybe it would be a good idea to have a look at "innodb_autoinc_lock_mode
>> 
>> " configuration.​
>>
>> ​Best regards,
>>
>> Ana​
>>
>>
>>
>> On Thu, Apr 13, 2017 at 4:23 PM, Petar Kozić  wrote:
>>
>>> Thank you on your answer. Yes I have about 80GB free in drive where is
>>> SD working directory.
>>>
>>>
>>> *—*
>>>
>>> *Petar Kozić*
>>> System Administrator
>>>
>>>
>>>
>>> On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda (
>>> emiliaarr...@gmail.com) wrote:
>>>
>>> Hi Petar,
>>>
>>> If you are using spool attributes, you need enough space in the SD
>>> working directory to store them before SD send attributes to Director.
>>>
>>> Could you please check if you have enough space in the SD working
>>> directory?
>>>
>>> Best regards,
>>> Ana
>>>
>>> On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić 
>>> wrote:
>>>
 Yes, I have.

 I was upload on pasterbin:
 http://pastebin.ca/3794414

 Log is contionous with same error.


 *—*

 *Petar Kozić*
 System Administrator


 On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
 djosip+n...@linuxpages.net) wrote:

 On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
 > @Josip Deanovic
 > Are you using spooling?
 > If yes, is your spool directory on the same file system as your
 database
 > data?
 >
 > No, I don’t spooling Data, only Attributes
 >
 > My config:
 > Spool Data = no
 > Spool Attributes = yes
 >
 >
 > I was increase innodb_timewait_lockout = 150 but error appears again.
 >
 > Some ideas ?

 Do you have anything useful in your mysql logs?

 --
 Josip Deanovic

 
 --
 Check out the vibrant tech community on one of the world's most
 engaging tech sites, Slashdot.org! http://sdm.link/slashdot
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


 
 --
 Check out the vibrant tech community on one of the world's most
 engaging tech sites, Slashdot.org! http://sdm.link/slashdot
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


>>>
>>
>

Re: [Bacula-users] Fatal error sql_create.c

[Ana Emília M . Arruda]

Hello Petar,

Please have a look here:
http://bacula.10910.n7.nabble.com/innodb-autoinc-lock-mode-td82493.html

Maybe the script for MySQL tunning can help with MariaDB too:
https://github.com/major/MySQLTuner-perl

Best regards,

Ana

On Thu, Apr 13, 2017 at 10:09 PM, Petar Kozić  wrote:

> I using MariaDB 10.1.
> Which value of innodb_autoinc_lock_mode is best for Bacula, do you know ?
>
>
>
> *—*
>
> *Petar Kozić*
> System Administrator
>
>
>
> On April 13, 2017 at 10:04:23 PM, Ana Emília M. Arruda (
> emiliaarr...@gmail.com) wrote:
>
> Hello Petar,
>
> Could you please let us know which Bacula/MySQL Database version are you
> using?
>
> Maybe it would be a good idea to have a look at "innodb_autoinc_lock_mode
> 
> " configuration.​
>
> ​Best regards,
>
> Ana​
>
>
>
> On Thu, Apr 13, 2017 at 4:23 PM, Petar Kozić  wrote:
>
>> Thank you on your answer. Yes I have about 80GB free in drive where is SD
>> working directory.
>>
>>
>> *—*
>>
>> *Petar Kozić*
>> System Administrator
>>
>>
>>
>> On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda (
>> emiliaarr...@gmail.com) wrote:
>>
>> Hi Petar,
>>
>> If you are using spool attributes, you need enough space in the SD
>> working directory to store them before SD send attributes to Director.
>>
>> Could you please check if you have enough space in the SD working
>> directory?
>>
>> Best regards,
>> Ana
>>
>> On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić  wrote:
>>
>>> Yes, I have.
>>>
>>> I was upload on pasterbin:
>>> http://pastebin.ca/3794414
>>>
>>> Log is contionous with same error.
>>>
>>>
>>> *—*
>>>
>>> *Petar Kozić*
>>> System Administrator
>>>
>>>
>>> On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
>>> djosip+n...@linuxpages.net) wrote:
>>>
>>> On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
>>> > @Josip Deanovic
>>> > Are you using spooling?
>>> > If yes, is your spool directory on the same file system as your
>>> database
>>> > data?
>>> >
>>> > No, I don’t spooling Data, only Attributes
>>> >
>>> > My config:
>>> > Spool Data = no
>>> > Spool Attributes = yes
>>> >
>>> >
>>> > I was increase innodb_timewait_lockout = 150 but error appears again.
>>> >
>>> > Some ideas ?
>>>
>>> Do you have anything useful in your mysql logs?
>>>
>>> --
>>> Josip Deanovic
>>>
>>> 
>>> --
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> ___
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>
>>>
>>> 
>>> --
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> ___
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>
>>>
>>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

I using MariaDB 10.1.
Which value of innodb_autoinc_lock_mode is best for Bacula, do you know ?



*—*

*Petar Kozić*
System Administrator



On April 13, 2017 at 10:04:23 PM, Ana Emília M. Arruda (
emiliaarr...@gmail.com) wrote:

Hello Petar,

Could you please let us know which Bacula/MySQL Database version are you
using?

Maybe it would be a good idea to have a look at "innodb_autoinc_lock_mode

" configuration.​

​Best regards,

Ana​



On Thu, Apr 13, 2017 at 4:23 PM, Petar Kozić  wrote:

> Thank you on your answer. Yes I have about 80GB free in drive where is SD
> working directory.
>
>
> *—*
>
> *Petar Kozić*
> System Administrator
>
>
>
> On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda (
> emiliaarr...@gmail.com) wrote:
>
> Hi Petar,
>
> If you are using spool attributes, you need enough space in the SD working
> directory to store them before SD send attributes to Director.
>
> Could you please check if you have enough space in the SD working
> directory?
>
> Best regards,
> Ana
>
> On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić  wrote:
>
>> Yes, I have.
>>
>> I was upload on pasterbin:
>> http://pastebin.ca/3794414
>>
>> Log is contionous with same error.
>>
>>
>> *—*
>>
>> *Petar Kozić*
>> System Administrator
>>
>>
>> On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
>> djosip+n...@linuxpages.net) wrote:
>>
>> On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
>> > @Josip Deanovic
>> > Are you using spooling?
>> > If yes, is your spool directory on the same file system as your database
>> > data?
>> >
>> > No, I don’t spooling Data, only Attributes
>> >
>> > My config:
>> > Spool Data = no
>> > Spool Attributes = yes
>> >
>> >
>> > I was increase innodb_timewait_lockout = 150 but error appears again.
>> >
>> > Some ideas ?
>>
>> Do you have anything useful in your mysql logs?
>>
>> --
>> Josip Deanovic
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Ana Emília M . Arruda]

Hello Petar,

Could you please let us know which Bacula/MySQL Database version are you
using?

Maybe it would be a good idea to have a look at "innodb_autoinc_lock_mode

" configuration.​

​Best regards,

Ana​



On Thu, Apr 13, 2017 at 4:23 PM, Petar Kozić  wrote:

> Thank you on your answer. Yes I have about 80GB free in drive where is SD
> working directory.
>
>
> *—*
>
> *Petar Kozić*
> System Administrator
>
>
>
> On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda (
> emiliaarr...@gmail.com) wrote:
>
> Hi Petar,
>
> If you are using spool attributes, you need enough space in the SD working
> directory to store them before SD send attributes to Director.
>
> Could you please check if you have enough space in the SD working
> directory?
>
> Best regards,
> Ana
>
> On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić  wrote:
>
>> Yes, I have.
>>
>> I was upload on pasterbin:
>> http://pastebin.ca/3794414
>>
>> Log is contionous with same error.
>>
>>
>> *—*
>>
>> *Petar Kozić*
>> System Administrator
>>
>>
>> On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
>> djosip+n...@linuxpages.net) wrote:
>>
>> On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
>> > @Josip Deanovic
>> > Are you using spooling?
>> > If yes, is your spool directory on the same file system as your database
>> > data?
>> >
>> > No, I don’t spooling Data, only Attributes
>> >
>> > My config:
>> > Spool Data = no
>> > Spool Attributes = yes
>> >
>> >
>> > I was increase innodb_timewait_lockout = 150 but error appears again.
>> >
>> > Some ideas ?
>>
>> Do you have anything useful in your mysql logs?
>>
>> --
>> Josip Deanovic
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

Thank you on your answer. Yes I have about 80GB free in drive where is SD
working directory.


*—*

*Petar Kozić*
System Administrator



On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda (
emiliaarr...@gmail.com) wrote:

Hi Petar,

If you are using spool attributes, you need enough space in the SD working
directory to store them before SD send attributes to Director.

Could you please check if you have enough space in the SD working directory?

Best regards,
Ana

On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić  wrote:

> Yes, I have.
>
> I was upload on pasterbin:
> http://pastebin.ca/3794414
>
> Log is contionous with same error.
>
>
> *—*
>
> *Petar Kozić*
> System Administrator
>
>
> On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
> djosip+n...@linuxpages.net) wrote:
>
> On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
> > @Josip Deanovic
> > Are you using spooling?
> > If yes, is your spool directory on the same file system as your database
> > data?
> >
> > No, I don’t spooling Data, only Attributes
> >
> > My config:
> > Spool Data = no
> > Spool Attributes = yes
> >
> >
> > I was increase innodb_timewait_lockout = 150 but error appears again.
> >
> > Some ideas ?
>
> Do you have anything useful in your mysql logs?
>
> --
> Josip Deanovic
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Ana Emília M . Arruda]

Hi Petar,

If you are using spool attributes, you need enough space in the SD working
directory to store them before SD send attributes to Director.

Could you please check if you have enough space in the SD working directory?

Best regards,
Ana

On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić  wrote:

> Yes, I have.
>
> I was upload on pasterbin:
> http://pastebin.ca/3794414
>
> Log is contionous with same error.
>
>
> *—*
>
> *Petar Kozić*
> System Administrator
>
>
> On April 12, 2017 at 11:03:51 AM, Josip Deanovic (
> djosip+n...@linuxpages.net) wrote:
>
> On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
> > @Josip Deanovic
> > Are you using spooling?
> > If yes, is your spool directory on the same file system as your database
> > data?
> >
> > No, I don’t spooling Data, only Attributes
> >
> > My config:
> > Spool Data = no
> > Spool Attributes = yes
> >
> >
> > I was increase innodb_timewait_lockout = 150 but error appears again.
> >
> > Some ideas ?
>
> Do you have anything useful in your mysql logs?
>
> --
> Josip Deanovic
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

Yes, I have.

I was upload on pasterbin:
http://pastebin.ca/3794414

Log is contionous with same error.


*—*

*Petar Kozić*
System Administrator


On April 12, 2017 at 11:03:51 AM, Josip Deanovic (djosip+n...@linuxpages.net)
wrote:

On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
> @Josip Deanovic
> Are you using spooling?
> If yes, is your spool directory on the same file system as your database
> data?
>
> No, I don’t spooling Data, only Attributes
>
> My config:
> Spool Data = no
> Spool Attributes = yes
>
>
> I was increase innodb_timewait_lockout = 150 but error appears again.
>
> Some ideas ?

Do you have anything useful in your mysql logs?

-- 
Josip Deanovic

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Josip Deanovic]

On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote:
> @Josip Deanovic
> Are you using spooling?
> If yes, is your spool directory on the same file system as your database
> data?
> 
> No, I don’t spooling Data, only Attributes
> 
> My config:
> Spool Data = no
> Spool Attributes = yes
> 
> 
> I was increase innodb_timewait_lockout = 150 but error appears again.
> 
> Some ideas ?

Do you have anything useful in your mysql logs?

-- 
Josip Deanovic

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

@Josip Deanovic
Are you using spooling?
If yes, is your spool directory on the same file system as your database
data?

No, I don’t spooling Data, only Attributes

My config:
Spool Data = no
Spool Attributes = yes


I was increase innodb_timewait_lockout = 150 but error appears again.

Some ideas ?



*—*

*Petar Kozić*
System Administrator


On April 10, 2017 at 9:06:36 AM, Petar Kozić (petar.ko...@mint.rs) wrote:

Are you using spooling?
If yes, is your spool directory on the same file system as your database
data?
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

Thank you very much, I also think it is innodb_timeout is relevant for this
problem, because I was get this error last week and when I increase timeout
from 50 to 100 this problem was disappear. After few days I was restart
mysql, but I still to add this statement in my.cnf and timeout was revert
to 50.

Last night I was increase timeout to 150 and set in my.cnf

I will inform is the problem solved.

Thank you.

*—*

*Petar Kozić*
System Administrator

On April 9, 2017 at 7:55:19 PM, Heitor Faria (hei...@bacula.com.br) wrote:

> On Sunday 2017-04-09 02:49:41 Petar Kozić wrote:
>> Hi,
>> Can someone tell me why I get this error:
>>
>> Fatal error: sql_create.c:833 Fill File table Query failed: INSERT INTO
>> File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
>> batch.FileIndex, batch.JobId, Path.PathId,
>> Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch
>> JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
>> Filename.Name): ERR=Lock wait timeout exceeded; try restarting
>> transaction

Hello, Peter: I suspect this error was here before on this list. There is a
workaround which is increasing database lock wait timeout value, and
probably deploy some configuration tuning for Bacula workload in order to
prevent transactions taking that long.

>> This error appear only when I doing Full backup at Sunday on my about
>> 10-12 linux instances.
>> *—*
>>
>> *Petar Kozić*
>> System Administrator

Regards,
-- 
===
Heitor Medrado de Faria | Bacula do Brasil
• Não seja tarifado pelo tamanho dos seus backups, conheça o Bacula
Enterprise: http://www.bacula.com.br/enterprise/
• Ministro treinamento e implementação in-company do Bacula Community:
http://www.bacula.com.br/in-company/
(61) 98268-4220 | www.bacula.com.br


Indicamos também as capacitações complementares:
• Shell básico e Programação em Shell com Julio Neves.
• Zabbix com Adail Host.


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Heitor Faria]

> On Sunday 2017-04-09 02:49:41 Petar Kozić wrote:
>> Hi,
>> Can someone tell me why I get this error:
>> 
>> Fatal error: sql_create.c:833 Fill File table Query failed: INSERT INTO
>> File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
>> batch.FileIndex, batch.JobId, Path.PathId,
>> Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch
>> JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
>> Filename.Name): ERR=Lock wait timeout exceeded; try restarting
>> transaction

Hello, Peter: I suspect this error was here before on this list. There is a 
workaround which is increasing database lock wait timeout value, and probably 
deploy some configuration tuning for Bacula workload in order to prevent 
transactions taking that long.

>> This error appear only when I doing Full backup at Sunday on my about
>> 10-12 linux instances.
>> *—*
>> 
>> *Petar Kozić*
>> System Administrator

Regards,
-- 
=== 
Heitor Medrado de Faria | Bacula do Brasil 
• Não seja tarifado pelo tamanho dos seus backups, conheça o Bacula Enterprise: 
http://www.bacula.com.br/enterprise/ 
• Ministro treinamento e implementação in-company do Bacula Community: 
http://www.bacula.com.br/in-company/ 
(61) 98268-4220 | www.bacula.com.br 
 
Indicamos também as capacitações complementares: 
• Shell básico e Programação em Shell com Julio Neves. 
• Zabbix com Adail Host. 


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

Yes, I am using spooling, but I don't have define spooling directory.
Director and mysql is on same server. Storage is on same but on different
mount point LVM.

On Apr 9, 2017 6:23 PM, "Josip Deanovic"  wrote:

On Sunday 2017-04-09 05:50:31 Petar Kozić wrote:
> This happend only on Sunday when Bacula run scheduled full backup on
> about 12 instances. Ofcorse, I have different run time in schedule, but
> because some instances have lot data, in some time 2-3 instances works
> in same time.
>
> I have over 70GB free space on mysql server and thats not problem. I’m
> also increase innodb_timeout from 50 to 100 last week when I have same
> problem.
>
> I have enabled batch insert, maybe thats problem or I must to increase
> inndob_timeout more.

Are you using spooling?
If yes, is your spool directory on the same file system as your database
data?

--
Josip Deanovic


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Josip Deanovic]

On Sunday 2017-04-09 05:50:31 Petar Kozić wrote:
> This happend only on Sunday when Bacula run scheduled full backup on
> about 12 instances. Ofcorse, I have different run time in schedule, but
> because some instances have lot data, in some time 2-3 instances works
> in same time.
> 
> I have over 70GB free space on mysql server and thats not problem. I’m
> also increase innodb_timeout from 50 to 100 last week when I have same
> problem.
> 
> I have enabled batch insert, maybe thats problem or I must to increase
> inndob_timeout more.

Are you using spooling?
If yes, is your spool directory on the same file system as your database
data?

-- 
Josip Deanovic

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

/tmp folder is on root where I have 70 GB free.

On Apr 9, 2017 3:18 PM, "Gary R. Schmidt"  wrote:

> On 09/04/2017 22:50, Petar Kozić wrote:
> > This happend only on Sunday when Bacula run scheduled full backup on
> > about 12 instances. Ofcorse, I have different run time in schedule, but
> > because some instances have lot data, in some time 2-3 instances works
> > in same time.
> >
> > I have over 70GB free space on mysql server and thats not problem. I’m
> > also increase innodb_timeout from 50 to 100 last week when I have same
> > problem.
> >
> > I have enabled batch insert, maybe thats problem or I must to increase
> > inndob_timeout more.
> >
>
> How much free *temporary* filespace is there?
>
> MySQL needs lots of /tmp, or however you have configured it.
>
> You might want to run one of the various MySQL tuning tools out there, I
> likr http://mysqltuner.pl.
>
> Cheers,
> GaryB-)
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Gary R. Schmidt]

On 09/04/2017 22:50, Petar Kozić wrote:
> This happend only on Sunday when Bacula run scheduled full backup on 
> about 12 instances. Ofcorse, I have different run time in schedule, but 
> because some instances have lot data, in some time 2-3 instances works 
> in same time.
> 
> I have over 70GB free space on mysql server and thats not problem. I’m 
> also increase innodb_timeout from 50 to 100 last week when I have same 
> problem.
> 
> I have enabled batch insert, maybe thats problem or I must to increase 
> inndob_timeout more.
> 

How much free *temporary* filespace is there?

MySQL needs lots of /tmp, or however you have configured it.

You might want to run one of the various MySQL tuning tools out there, I 
likr http://mysqltuner.pl.

Cheers,
GaryB-)

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Petar Kozić]

This happend only on Sunday when Bacula run scheduled full backup on about
12 instances. Ofcorse, I have different run time in schedule, but because
some instances have lot data, in some time 2-3 instances works in same time.

I have over 70GB free space on mysql server and thats not problem. I’m also
increase innodb_timeout from 50 to 100 last week when I have same problem.

I have enabled batch insert, maybe thats problem or I must to increase
inndob_timeout more.

Thanks.

*—*

*Petar Kozić*
System Administrator


On April 9, 2017 at 12:13:28 PM, Josip Deanovic (djosip+n...@linuxpages.net)
wrote:

On Sunday 2017-04-09 02:49:41 Petar Kozić wrote:
> Hi,
> Can someone tell me why I get this error:
>
> Fatal error: sql_create.c:833 Fill File table Query failed: INSERT INTO
> File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
> batch.FileIndex, batch.JobId, Path.PathId,
> Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch
> JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
> Filename.Name): ERR=Lock wait timeout exceeded; try restarting
> transaction
>
> This error appear only when I doing Full backup at Sunday on my about
> 10-12 linux instances.
> *—*
>
> *Petar Kozić*
> System Administrator


Check the logs of your database server, check if the database
has enough space on the file system.

Run full backup manually and observe what is going on the backup
and the database server.

-- 
Josip Deanovic

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error sql_create.c

[Josip Deanovic]

On Sunday 2017-04-09 02:49:41 Petar Kozić wrote:
> Hi,
> Can someone tell me why I get this error:
> 
> Fatal error: sql_create.c:833 Fill File table Query failed: INSERT INTO
> File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
> batch.FileIndex, batch.JobId, Path.PathId,
> Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch
> JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
> Filename.Name): ERR=Lock wait timeout exceeded; try restarting
> transaction
> 
> This error appear only when I doing Full backup at Sunday on my about
> 10-12 linux instances.
> *—*
> 
> *Petar Kozić*
> System Administrator


Check the logs of your database server, check if the database
has enough space on the file system.

Run full backup manually and observe what is going on the backup
and the database server.

-- 
Josip Deanovic

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Fatal error sql_create.c

[Petar Kozić]

Hi,
Can someone tell me why I get this error:

Fatal error: sql_create.c:833 Fill File table Query failed: INSERT INTO
File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat,
batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path)
JOIN Filename ON (batch.Name = Filename.Name): ERR=Lock wait timeout
exceeded; try restarting transaction

This error appear only when I doing Full backup at Sunday on my about 10-12
linux instances.
*—*

*Petar Kozić*
System Administrator
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:800 sql

[Jean-François Leroux]

Thanks, everybody.
That was my /tmp directory, as you said. It was mounted with 16 Mb 
inside the vserver. I corrected that and it works now.
All I have to do is updating my other servers in squeeze :)

Thanks again.
Jean-François

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:800 sql

[Uwe Schuerkamp]

On Wed, Jun 13, 2012 at 10:37:45PM +0200, Jean-François Leroux wrote:
 
 wait_timeout=691200
 interactive_timeout=691200
 
 To my.cnf.
 
 I also added HearbeatInterval = 1 min
 
 to bacula-sd.conf and bacula-fd.conf (on the vserver that had problems).
 
 But still no go. Backup runs for about 15 minutes and then hangs with this
 error.

Hi,

does the backup *always* crash after 15 minutes? What's the value of
tcp_keepalive_timeout on the systems involved?

I'm asking because recently we had a weird effect where a backup of a
windows client would start off just fine, but simply die after the
amount of seconds for tcp_keepalive_time + 2 secs or so. 

Any firewalls involved in the communication among the vservers? 

Can you ssh into the other servers from the director without the idle
ssh sessions timing out on you? 

All the best, Uwe 

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:800 sql

[Marco van Wieringen]

Jean-François Leroux leroux.jeanfrancois at gmail.com writes:

 
 
 Sorry, forgot the title in my former message. Here it goes again.Hi
list,Here's my setup : DIR, SD and FD are on different 
 virtual machines. They are debian squeeze vservers (all of them). Until 
 recently, we were running 2.4.4.1 (lenny) and everything was fine. I had
  to update some servers in squeeze, so I also created new virtual 
 machines and configured them with bacula (DIR/SD), version 5.0.2-2.2+b1 
 and configured my clients with the corresponding FD.Now the problem :When
executing a backup for big servers (100 Gb +), I get this error :Fatal error:
sql_create.c:800 sql_create.c:800 insert -- followed by the mysql query.Then
:Fatal error: catreq.c:497 attribute create error. sql_find.c:376 Request for
Volume item 1 greater than max 0 or less than 1
 
 13-Jun 18:01 unisson.private.tice.ac-orlea JobId 170: Fatal error: 
 Network error with FD during Backup: ERR=Interrupted system call13-Jun 18:01
unisson.private.tice.ac-orlea JobId 170: Fatal error: No Job status returned
from FD.
 13-Jun 18:01 unisson.private.tice.ac-orlea JobId 170: Fatal error: 
 sql_get.c:373 sql_get.c:373 query SELECT VolumeName,MAX(VolIndex) FROM 
 JobMedia,Media WHERE JobMedia.JobId=170 AND 
 JobMedia.MediaId=Media.MediaId GROUP BY VolumeName ORDER BY 2 ASC 
 failed:
 Got error 28 from storage engine

Try a google search for error 28 mysql and you will find out its
a known mysql error for telling you run out of space. So I would
search in the mysql space first something is filling probably some
temp space.

Marco


--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:800 sql

[Piotr Babula]

Your main problem is probably here:

 Got error 28 from storage engine

which means:

# perror 28
OS error code  28:  No space left on device

So please check space on filesystem where mysql creates temporary tables.

Regards
Piotr
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:800 sql

[Jean-François Leroux]

Hi Uwe,
Thanks for the answer.
I've found it in the meantime: my vserver was defined with a 16 Mb /tmp
directory. Increasing it to 100 made the job.
Anyway, I'll keep your advice about tcp_keepalive ready if it happens again.

Cheers.
Jean-François

2012/6/14 Uwe Schuerkamp uwe.schuerk...@nionex.net

 On Wed, Jun 13, 2012 at 10:37:45PM +0200, Jean-François Leroux wrote:
 
  wait_timeout=691200
  interactive_timeout=691200
 
  To my.cnf.
 
  I also added HearbeatInterval = 1 min
 
  to bacula-sd.conf and bacula-fd.conf (on the vserver that had problems).
 
  But still no go. Backup runs for about 15 minutes and then hangs with
 this
  error.

 Hi,

 does the backup *always* crash after 15 minutes? What's the value of
 tcp_keepalive_timeout on the systems involved?

 I'm asking because recently we had a weird effect where a backup of a
 windows client would start off just fine, but simply die after the
 amount of seconds for tcp_keepalive_time + 2 secs or so.

 Any firewalls involved in the communication among the vservers?

 Can you ssh into the other servers from the director without the idle
 ssh sessions timing out on you?

 All the best, Uwe

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Fatal error: sql_create.c:800 sql

[Jean-François Leroux]

Sorry, forgot the title in my former message. Here it goes again.

Hi list,

Here's my setup :
DIR, SD and FD are on different virtual machines. They are debian squeeze
vservers (all of them). Until recently, we were running 2.4.4.1 (lenny) and
everything was fine. I had to update some servers in squeeze, so I also
created new virtual machines and configured them with bacula (DIR/SD),
version 5.0.2-2.2+b1 and configured my clients with the corresponding FD.

Now the problem :

When executing a backup for big servers (100 Gb +), I get this error :

Fatal error: sql_create.c:800 sql_create.c:800 insert -- followed by the
mysql query.

Then :

Fatal error: catreq.c:497 attribute create error. sql_find.c:376 Request
for Volume item 1 greater than max 0 or less than 1
13-Jun 18:01 unisson.private.tice.ac-orlea JobId 170: Fatal error: Network
error with FD during Backup: ERR=Interrupted system call
13-Jun 18:01 unisson.private.tice.ac-orlea JobId 170: Fatal error: No Job
status returned from FD.
13-Jun 18:01 unisson.private.tice.ac-orlea JobId 170: Fatal error:
sql_get.c:373 sql_get.c:373 query SELECT VolumeName,MAX(VolIndex) FROM
JobMedia,Media WHERE JobMedia.JobId=170 AND JobMedia.MediaId=Media.MediaId
GROUP BY VolumeName ORDER BY 2 ASC failed:
Got error 28 from storage engine

I *did* read the faq and added

wait_timeout=691200
interactive_timeout=691200

To my.cnf.

I also added HearbeatInterval = 1 min

to bacula-sd.conf and bacula-fd.conf (on the vserver that had problems).

But still no go. Backup runs for about 15 minutes and then hangs with this
error.

I have increased other my.cnf params :

key_buffer  = 64M
max_allowed_packet  = 16M
thread_stack= 192K
thread_cache_size   = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
max_connections= 100
table_cache= 256
thread_concurrency = 10

But still nothing.

Any idea would be very much appreciated since I've got no backup now for
most of my servers...

Thanks!
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed

[Adrian Reyer]

Hi Maria,

On Wed, Feb 08, 2012 at 11:46:24AM -0800, Maria McKinley wrote:
 05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 Fill 
 File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, 
 FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, 
 Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON 
 (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): 
 ERR=Table './bacula/File' is marked as crashed and last (automatic?) 
 repair failed

Have you tried 'mysqlrepair bacula File' or 'mysqlrepair -A'?

Regards,
Adrian
-- 
LiHAS - Adrian Reyer - Hessenwiesenstraße 10 - D-70565 Stuttgart
Fon: +49 (7 11) 78 28 50 90 - Fax:  +49 (7 11) 78 28 50 91
Mail: li...@lihas.de - Web: http://lihas.de
Linux, Netzwerke, Consulting  Support - USt-ID: DE 227 816 626 Stuttgart

--
Virtualization  Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed

[Maria McKinley]

On 2/10/12 1:37 PM, Adrian Reyer wrote:
 Hi Maria,

 On Wed, Feb 08, 2012 at 11:46:24AM -0800, Maria McKinley wrote:
 05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 Fill
 File table Query failed: INSERT INTO File (FileIndex, JobId, PathId,
 FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId,
 Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
 (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name):
 ERR=Table './bacula/File' is marked as crashed and last (automatic?)
 repair failed

 Have you tried 'mysqlrepair bacula File' or 'mysqlrepair -A'?

 Regards,
   Adrian

Thanks so much, not sure why I didn't find that command. I am cautiously 
optimistic that worked. Was able to check status, and start a new job 
without errors.

cheers,
maria

--
Virtualization  Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed

[Maria McKinley]

Hi there,

I had a backup go horribly bad the other day. I believe it was because 
of a lost connection during the backup. Since then, I have not been able 
to do backup. I have tried using both dbcheck and myisamchk to repair 
the databases, but this has not helped. I am afraid my knowledge of 
mysql is extremely limited, and I am not sure what to do. The errors 
just keep piling up. Here is an example:

05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 Fill 
File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, 
FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, 
Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON 
(batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): 
ERR=Table './bacula/File' is marked as crashed and last (automatic?) 
repair failed

Judging from other, plentiful error messages, it appears most of the 
tables are marked as crashed. How do I repair these problems?

thanks,
maria

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users