After building another server (identical) and restoring the DB I am able to create users, edit their data. Pretty much all replication tasks fail though.Restarting services fail, and dropping the database is unsuccessful.
On Tue, May 11, 2010 at 6:09 AM, Tony Graziano <[email protected] > wrote: > I've attached a spreadsheet where I've altered the names/pintokens, etc. It > clearly show the user with the missing storage id, but as I look at a > working system, I see some users with a missing storage ID without the > problem of adding or modifying users. So I am not confident that this is > nothing more than a dead end. > > Since the errors are LUCENE, and related to tapestry, it makes more sense > to me this is a tapestry/java error. No users were manually created. When > the system was first built, the initial users were imported via csv, and it > threw no errors and the job was successful, the errors starting occurring > 2-3 days after the system was built. The errors point to data being out of > order, I know, but I did not make any changes to the data manually. > > 1. Build system from ISO. > 2. Import users > 3. Configure gateways, other parameters > 4. Import certificate for google. > 5. upload certificate for system. > 6. days later import google addresses (large number) and sipxconfig becomes > unresponsive, restart configserver > 7. Added user, could not assign alias afterwards. > 8. Cannot add or modify ANY users, system useable but unmanageable anymore. > > If I do a drop database and restore from backup, I don't have much hope my > issue will be resolved if the issue is with the DB (i.e., I would be > importing the same error that caused this to begin with). > > I'd like to understand what caused this, because the way I built it was > very "normal". The export was from a 4.0.4 system, on a new domain, so the > pintokens and such were cleared from the csv file (as well as the superadmin > account), before importing. It was just a successful users import, the job > status showed no issues whatsoever. > > I don't think it's an index problem. I've run a manual reindex of all the > tables, nothing has changed. > > Is there anywhere I can look closer to find out what is the matter or how > to fix it? > > > On Tue, May 11, 2010 at 5:32 AM, Tony Graziano < > [email protected]> wrote: > >> no. >> >> Once the import failed I did look at the postgres table (view). Saw the >> last user entered, which I was not able to configure an alias for, does not >> have a "value_storage_id" set. >> >> I suspect this is an issue because the "order" is being affected when the >> row is trying to be written or altered. >> >> If so, how do I fix it? >> >> >> On Tue, May 11, 2010 at 5:01 AM, George Niculae < >> [email protected]> wrote: >> >>> >>> --- On Tue, 5/11/10, Tony Graziano <[email protected]> wrote: >>> >>> >To confirm this, I get a "docs out of order" message trying to import 1 >>> >user. >>> > >>> >The import fails with: >>> >docs out of order (-2 < 0 ) >>> >>> Just wondering if you manually inserted users in db (or any other way but >>> not via sipxconfig) >>> >>> George >>> >>> >>> >>> >>> >> >> >> -- >> ====================== >> Tony Graziano, Manager >> Telephone: 434.984.8430 >> sip: [email protected] >> Fax: 434.984.8431 >> >> Email: [email protected] >> >> LAN/Telephony/Security and Control Systems Helpdesk: >> Telephone: 434.984.8426 >> sip: [email protected] >> Fax: 434.984.8427 >> >> Helpdesk Contract Customers: >> http://www.myitdepartment.net/gethelp/ >> >> Why do mathematicians always confuse Halloween and Christmas? >> Because 31 Oct = 25 Dec. >> >> > > > -- > ====================== > Tony Graziano, Manager > Telephone: 434.984.8430 > sip: [email protected] > Fax: 434.984.8431 > > Email: [email protected] > > LAN/Telephony/Security and Control Systems Helpdesk: > Telephone: 434.984.8426 > sip: [email protected] > Fax: 434.984.8427 > > Helpdesk Contract Customers: > http://www.myitdepartment.net/gethelp/ > > Why do mathematicians always confuse Halloween and Christmas? > Because 31 Oct = 25 Dec. > > -- ====================== Tony Graziano, Manager Telephone: 434.984.8430 sip: [email protected] Fax: 434.984.8431 Email: [email protected] LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [email protected] Fax: 434.984.8427 Helpdesk Contract Customers: http://www.myitdepartment.net/gethelp/ Why do mathematicians always confuse Halloween and Christmas? Because 31 Oct = 25 Dec.
_______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev sipXecs IP PBX -- http://www.sipfoundry.org/
