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

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,

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

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 mu

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

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

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

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 usin

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

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 Databa

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

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,

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

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 th

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

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:

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

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 Dean

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

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

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

@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 ?

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

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 t

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

> 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.Pat

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

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 Bac

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

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

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

/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 > > beca

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

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

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

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 a

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

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, > F

[Bacula-users] Fatal error sql_create.c

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

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

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 ---

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

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 > On Wed, Jun 13, 2012

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

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 --

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

Jean-François Leroux 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 ev

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

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

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

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 s

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

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

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

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, >

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

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 my