Re: AW: [firebird-support] Re: 335544382. Can't allocate difference page
> ---In firebird-support@yahoogroups.com, wrote : > > Hi again, > > > I had the error now again: 335544382. Can't allocate difference page > > I think that happened when I tried to execute > ALTER DATABASE END BACKUP > > I also found the following in syslog: > > Feb 19 04:24:13 kernel:traps: firebird[16552] trap invalid opcode > ip:7fabfa1bec19 sp:7fabd19c6950 error:0 in > libpthread-2.23.so[7fabfa1b2000+17000] > Feb 19 04:24:13 systemd-coredump[16555]: Cannot store coredump of 5837 > (firebird): No space left on device > Feb 19 04:24:13 systemd-coredump[16555]: Process 5837 (firebird) of user 450 > dumped core. > > Feb 27 09:03:34 kernel:traps: firebird[5995] trap invalid opcode > ip:7f94c16c8c19 sp:7f94af7fb4a0 error:0 in > libpthread-2.23.so[7f94c16bc000+17000] > Feb 27 09:03:35 systemd-coredump[7883]: Cannot store coredump of 5846 > (firebird): No space left on device > Feb 27 09:03:35 systemd-coredump[7883]: Process 5846 (firebird) of user 450 > dumped core. > > Sadly I do not have a coredump (as that part of the harddrive is not mounted > writeable). Hmm... "No space left on device" error points into another direction... > But also notice, that the firebird database partition still has >400GB free > space. Does you defined explicit difference file name in that database ? > Also I found a "335544363. no transaction for request" error, but I have no > timestamp and cannot correlate it with the crash. > However I got the impression that this happened really short after the crash > (and we are using a connection pool). > > This is currently firebird 3.0.2. > Does the information above help in any way? Almost no, sorry. Crash dump could help. firebird.log contents also could help. And output of gstat -h Regards, Vlad
AW: [firebird-support] Re: 335544382. Can't allocate difference page
Hi again, I had the error now again: 335544382. Can't allocate difference page I think that happened when I tried to execute ALTER DATABASE END BACKUP I also found the following in syslog: Feb 19 04:24:13 kernel:traps: firebird[16552] trap invalid opcode ip:7fabfa1bec19 sp:7fabd19c6950 error:0 in libpthread-2.23.so[7fabfa1b2000+17000] Feb 19 04:24:13 systemd-coredump[16555]: Cannot store coredump of 5837 (firebird): No space left on device Feb 19 04:24:13 systemd-coredump[16555]: Process 5837 (firebird) of user 450 dumped core. Feb 27 09:03:34 kernel:traps: firebird[5995] trap invalid opcode ip:7f94c16c8c19 sp:7f94af7fb4a0 error:0 in libpthread-2.23.so[7f94c16bc000+17000] Feb 27 09:03:35 systemd-coredump[7883]: Cannot store coredump of 5846 (firebird): No space left on device Feb 27 09:03:35 systemd-coredump[7883]: Process 5846 (firebird) of user 450 dumped core. Sadly I do not have a coredump (as that part of the harddrive is not mounted writeable). But also notice, that the firebird database partition still has >400GB free space. Also I found a "335544363. no transaction for request" error, but I have no timestamp and cannot correlate it with the crash. However I got the impression that this happened really short after the crash (and we are using a connection pool). This is currently firebird 3.0.2. Does the information above help in any way? We are preparing an update to the system that will make the coredump position writeable. But then we do not want to wait for the next problem at the customers site. Regards, Steffen
AW: [firebird-support] Re: 335544382. Can't allocate difference page
Hi > In short: write to the difference file was not successfull. > > Common reason could be out of disk space or some other error at > filesystem\disk level. > Of course, there is always exists possiblilty of some kind of bug at the > engine itself... > but i never saw such errors before. 450G free space. > > I am sure there was no power outage and the system did not reboot. > > There are no indications about hard drive errors in the logs. > > > > What could I do to find the source of this problem? > > Is it reproducible ? > What is the current state of the database (gstat -h) ? > Any messages at firebird.log around that time ? I cannot test at the moment. The machine is at a remote location. We are having it shipped here and I can inspect it then (if the problem stays). I will report the result of gstat -h. However I wasn't able to find a firebird.log file at all. (This is a gentoo installation.) Regards, Steffen
[firebird-support] Re: 335544382. Can't allocate difference page
> ---In firebird-support@yahoogroups.com, wrote : > > > I am using firebird 3.0.2 and I access it using java (jaybird). > The system is running on linux 4.12. > > I am trying to execute the following statement: > ALTER DATABASE END BACKUP; > > Then I get the following error: > GDS Exception. 335544382. Can't allocate difference page > > > Can someone tell me what is going on? In short: write to the difference file was not successfull. Common reason could be out of disk space or some other error at filesystem\disk level. Of course, there is always exists possiblilty of some kind of bug at the engine itself... but i never saw such errors before. > I am sure there was no power outage and the system did not reboot. > There are no indications about hard drive errors in the logs. > > What could I do to find the source of this problem? Is it reproducible ? What is the current state of the database (gstat -h) ? Any messages at firebird.log around that time ? Regards, Vlad
