Re: [firebird-support] Character sets and collations of columns
On 30.08.2016 o 08:14, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: >> One of the legacy databases I happen to maintain has character sets and >> collations messed up. [...] > > For a database that is messed up like this, I'd go the clean way and > use a pump. That would also give you the opportunity to change it to > Unicode (UTF-8) at the same time, which is a transition that you will > have to do anyway. Probably you're right and that's how it's gonna end. Nevertheless, it would be nice to know the inner workings of character sets and collations (and the corresponding flags in system tables), what kind of manipulation is possible on existing data and what impact it might cause. That kind of knowledge might be valuable for its own sake, so if anyone is aware of any sources of information casting some light on the subject, please point them out. Knowledge never hurts ;) thanks and regards Tomasz ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] gbak error
On 31 August 2016 at 18:16, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > Can you show us the permissions of the directory that you are trying to > write to? And also of the database file that you are trying to back up? > the directory is 777 and the database is 550 owned by firebird, group unb > > And is there an existing fbk that you are trying to overwrite or is it a > new file? > new file > > And what user and group are you using to perform the gbak along with the > flags. > user and group are called unb, the firebird user is also a member of group unb, gbak -backup -user sysdba -password x filename > > Does anything show up in dmesg that would indicate some kind of I/O error > or hard disk starting to go bad? > no, and its a VM This was all working and then it didn't, no changes detected anywhere Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
Re: [firebird-support] gbak error
Sounds like the user running gbak has insufficient rights to create a file in the target folder. Mark - Bericht beantwoorden - Van: "Nick Upson n...@telensa.com [firebird-support]" Aan: "firebird support" Onderwerp: [firebird-support] gbak error Datum: wo, aug. 31, 2016 18:41 its possible that the file is created and removed quickly enough that I don't see it Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 31 August 2016 at 17:38, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: Nick, > it either happens on creation or a file is started and then removed very > quickly "then removed very quickly"??? Please elaborate. Sean
Re: [firebird-support] gbak error
Can you show us the permissions of the directory that you are trying to write to? And also of the database file that you are trying to back up? And is there an existing fbk that you are trying to overwrite or is it a new file? And what user and group are you using to perform the gbak along with the flags. Does anything show up in dmesg that would indicate some kind of I/O error or hard disk starting to go bad? -steve On Wed, Aug 31, 2016 at 12:41 PM, Nick Upson n...@telensa.com [firebird-support] wrote: > > > its possible that the file is created and removed quickly enough that I > don't see it > > Nick Upson, > Principal Operations Engineer, Telensa Ltd. > Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 > > On 31 August 2016 at 17:38, 'Leyne, Sean' s...@broadviewsoftware.com > [firebird-support] wrote: > >> >> >> Nick, >> >> > it either happens on creation or a file is started and then removed >> very >> > quickly >> >> "then removed very quickly"??? >> >> Please elaborate. >> >> >> Sean >> >> > >
Re: [firebird-support] gbak error
its possible that the file is created and removed quickly enough that I don't see it Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 31 August 2016 at 17:38, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > Nick, > > > it either happens on creation or a file is started and then removed very > > quickly > > "then removed very quickly"??? > > Please elaborate. > > > Sean > > >
RE: [firebird-support] gbak error
Nick, > it either happens on creation or a file is started and then removed very > quickly "then removed very quickly"??? Please elaborate. Sean
Re: [firebird-support] gbak error
Hello
Sent from Yahoo Mail. Get the app
On Wednesday, August 31, 2016 6:02 PM, "Nick Upson n...@telensa.com
[firebird-support]" wrote:
it either happens on creation or a file is started and then removed very
quickly
Nick Upson,
Principal Operations Engineer, Telensa Ltd.
Direct+44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
On 31 August 2016 at 16:57, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
Does the error happen on file creation or after some data has been written?
On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support]
wrote:
no, not a file name collision and plenty of disk space
this just started happening, no change to installed s/w
Nick Upson,
Principal Operations Engineer, Telensa Ltd.
Direct+44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
Hello Nick,
> I'm running fb2.1 on centos5, recently a system has started
> throwing this error when asked to do a backup, the gbak parameters
> are unchanged, permissions all seem ok, any suggestions what I might check
> gbak: ERROR:Unexpected I/O error while writing to backup file
> gbak:Exiting before completion due to errors
"gbak parameters are unchanged." Could be you already have a file in
that location with the same name.
HB
#yiv7008999817 #yiv7008999817 -- #yiv7008999817ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7008999817
#yiv7008999817ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7008999817
#yiv7008999817ygrp-mkp #yiv7008999817hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7008999817 #yiv7008999817ygrp-mkp #yiv7008999817ads
{margin-bottom:10px;}#yiv7008999817 #yiv7008999817ygrp-mkp .yiv7008999817ad
{padding:0 0;}#yiv7008999817 #yiv7008999817ygrp-mkp .yiv7008999817ad p
{margin:0;}#yiv7008999817 #yiv7008999817ygrp-mkp .yiv7008999817ad a
{color:#ff;text-decoration:none;}#yiv7008999817 #yiv7008999817ygrp-sponsor
#yiv7008999817ygrp-lc {font-family:Arial;}#yiv7008999817
#yiv7008999817ygrp-sponsor #yiv7008999817ygrp-lc #yiv7008999817hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7008999817
#yiv7008999817ygrp-sponsor #yiv7008999817ygrp-lc .yiv7008999817ad
{margin-bottom:10px;padding:0 0;}#yiv7008999817 #yiv7008999817actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7008999817
#yiv7008999817activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7008999817
#yiv7008999817activity span {font-weight:700;}#yiv7008999817
#yiv7008999817activity span:first-child
{text-transform:uppercase;}#yiv7008999817 #yiv7008999817activity span a
{color:#5085b6;text-decoration:none;}#yiv7008999817 #yiv7008999817activity span
span {color:#ff7900;}#yiv7008999817 #yiv7008999817activity span
.yiv7008999817underline {text-decoration:underline;}#yiv7008999817
.yiv7008999817attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7008999817 .yiv7008999817attach div a
{text-decoration:none;}#yiv7008999817 .yiv7008999817attach img
{border:none;padding-right:5px;}#yiv7008999817 .yiv7008999817attach label
{display:block;margin-bottom:5px;}#yiv7008999817 .yiv7008999817attach label a
{text-decoration:none;}#yiv7008999817 blockquote {margin:0 0 0
4px;}#yiv7008999817 .yiv7008999817bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7008999817
.yiv7008999817bold a {text-decoration:none;}#yiv7008999817 dd.yiv7008999817last
p a {font-family:Verdana;font-weight:700;}#yiv7008999817 dd.yiv7008999817last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7008999817
dd.yiv7008999817last p span.yiv7008999817yshortcuts
{margin-right:0;}#yiv7008999817 div.yiv7008999817attach-table div div a
{text-decoration:none;}#yiv7008999817 div.yiv7008999817attach-table
{width:400px;}#yiv7008999817 div.yiv7008999817file-title a, #yiv7008999817
div.yiv7008999817file-title a:active, #yiv7008999817
div.yiv7008999817file-title a:hover, #yiv7008999817 div.yiv7008999817file-title
a:visited {text-decoration:none;}#yiv7008999817 div.yiv7008999817photo-title a,
#yiv7008999817 div.yiv7008999817photo-title a:active, #yiv7008999817
div.yiv7008999817photo-title a:hover, #yiv7008999817
div.yiv7008999817photo-title a:visited {text-decoration:none;}#yiv7008999817
div#yiv7008999817ygrp-mlmsg #yiv7008999817ygrp-msg p a
span.yiv7008999817yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7008999817
.yiv7008999817green {color:#628c2a;}#yiv7008999817 .yiv7008999817MsoNormal
{margin:0 0 0 0;}#yiv7008999817 o {font-size:0;}#yiv7008999817
#yiv7008999817photos div {float:left;width:72px;}#yiv7008999817
#yiv7008999817photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv7008999817
#yiv7008999817photos div label
Re: [firebird-support] gbak error
it either happens on creation or a file is started and then removed very quickly Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 31 August 2016 at 16:57, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > Does the error happen on file creation or after some data has been written? > > > > On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > no, not a file name collision and plenty of disk space > > this just started happening, no change to installed s/w > > Nick Upson, > Principal Operations Engineer, Telensa Ltd. > Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 > > On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au > [firebird-support] wrote: > >> >> >> Hello Nick, >> >> > I'm running fb2.1 on centos5, recently a system has started >> > throwing this error when asked to do a backup, the gbak parameters >> > are unchanged, permissions all seem ok, any suggestions what I might >> check >> >> > gbak: ERROR:Unexpected I/O error while writing to backup file >> > gbak:Exiting before completion due to errors >> >> "gbak parameters are unchanged." Could be you already have a file in >> that location with the same name. >> >> HB >> >> > >
Re: [firebird-support] gbak error
Does the error happen on file creation or after some data has been written? > On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > > > no, not a file name collision and plenty of disk space > > this just started happening, no change to installed s/w > > Nick Upson, > Principal Operations Engineer, Telensa Ltd. > Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 > > >> On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au >> [firebird-support] wrote: >> Hello Nick, >> >> > I'm running fb2.1 on centos5, recently a system has started >> > throwing this error when asked to do a backup, the gbak parameters >> > are unchanged, permissions all seem ok, any suggestions what I might check >> >> > gbak: ERROR:Unexpected I/O error while writing to backup file >> > gbak:Exiting before completion due to errors >> >> "gbak parameters are unchanged." Could be you already have a file in >> that location with the same name. >> >> HB > > > >
